Symfony Profiler

SELECT
  p0_.id AS id_0
FROM
  profiles p0_
  LEFT JOIN cities c1_ ON p0_.city_id = c1_.id
  INNER JOIN profile_adboard_placements p2_ ON p0_.id = p2_.profile_id
WHERE
  (
    c1_.country_code = ?
    AND p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND p0_.is_masseur = ?
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  36

SELECT p0_.id AS id_0 FROM profiles p0_ LEFT JOIN cities c1_ ON p0_.city_id = c1_.id INNER JOIN profile_adboard_placements p2_ ON p0_.id = p2_.profile_id WHERE (c1_.country_code = 'RU' AND p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND p0_.is_masseur = 0) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 36;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c0_.country_code AS country_code_3,
  c0_.city_group AS city_group_4,
  c0_.timezone AS timezone_5,
  c0_.map_latitude AS map_latitude_6,
  c0_.map_longitude AS map_longitude_7
FROM
  cities c0_
WHERE
  c0_.uri_identity = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.timezone AS timezone_5, c0_.map_latitude AS map_latitude_6, c0_.map_longitude AS map_longitude_7 FROM cities c0_ WHERE c0_.uri_identity = 'moscow' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4,
  t0.county_id AS county_id_5,
  t0.district_id AS district_id_6
FROM
  city_stations t0
WHERE
  t0.city_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.city_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4,
  t0.county_id AS county_id_5
FROM
  city_districts t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5 FROM city_districts t0 WHERE t0.city_id = 1;

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.city_id AS city_id_8
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/moscow/usluga-seks-analnyij/' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.is_dummy AS is_dummy_1,
  p0_.uri_identity AS uri_identity_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.client_types AS client_types_5,
  p0_.phone_number AS phone_number_6,
  p0_.is_masseur AS is_masseur_7,
  p0_.extra_charge AS extra_charge_8,
  p0_.prepayment AS prepayment_9,
  p0_.prepayment_amount AS prepayment_amount_10,
  p0_.prepayment_comment AS prepayment_comment_11,
  p0_.is_approved AS is_approved_12,
  p0_.moderation_status AS moderation_status_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.inactivated_at AS inactivated_at_16,
  p0_.seo AS seo_17,
  p0_.delete_mode AS delete_mode_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.person_gender AS person_gender_20,
  p0_.person_age AS person_age_21,
  p0_.person_height AS person_height_22,
  p0_.person_weight AS person_weight_23,
  p0_.person_breast_size AS person_breast_size_24,
  p0_.person_breast_type AS person_breast_type_25,
  p0_.person_cloth_size AS person_cloth_size_26,
  p0_.person_shoes_size AS person_shoes_size_27,
  p0_.person_body_type AS person_body_type_28,
  p0_.person_hair_color AS person_hair_color_29,
  p0_.person_private_haircut AS person_private_haircut_30,
  p0_.person_nationality AS person_nationality_31,
  p0_.person_has_tattoo AS person_has_tattoo_32,
  p0_.person_has_piercing AS person_has_piercing_33,
  p0_.messengers_telegram AS messengers_telegram_34,
  p0_.messengers_whatsapp AS messengers_whatsapp_35,
  p0_.messengers_telegram_username AS messengers_telegram_username_36,
  p0_.call_time_from AS call_time_from_37,
  p0_.call_time_to AS call_time_to_38,
  p0_.call_answering_to AS call_answering_to_39,
  p0_.client_min_age AS client_min_age_40,
  p0_.client_max_age AS client_max_age_41,
  p0_.apartments_one_hour_price AS apartments_one_hour_price_42,
  p0_.apartments_two_hours_price AS apartments_two_hours_price_43,
  p0_.apartments_night_price AS apartments_night_price_44,
  p0_.take_out_one_hour_price AS take_out_one_hour_price_45,
  p0_.take_out_two_hours_price AS take_out_two_hours_price_46,
  p0_.take_out_night_price AS take_out_night_price_47,
  p0_.take_out_locations AS take_out_locations_48,
  p0_.express_provided AS express_provided_49,
  p0_.express_price AS express_price_50,
  p0_.car_provided AS car_provided_51,
  p0_.map_latitude AS map_latitude_52,
  p0_.map_longitude AS map_longitude_53,
  p1_.id AS id_54,
  p1_.placed_at AS placed_at_55,
  p1_.expires_at AS expires_at_56,
  p0_.user_id AS user_id_57,
  p0_.city_id AS city_id_58,
  p0_.primary_station_id AS primary_station_id_59,
  p1_.city_id AS city_id_60,
  p1_.profile_id AS profile_id_61,
  p1_.placement_price_id AS placement_price_id_62
FROM
  profiles p0_
  INNER JOIN profile_top_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.city_id = ?
    AND (
      ? BETWEEN p1_.placed_at
      AND p1_.expires_at
    )
    AND (
      EXISTS (
        SELECT
          p2_.id
        FROM
          profile_provided_services p2_
        WHERE
          p2_.service_id IN (?)
          AND p2_.profile_id = p0_.id
      )
    )
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  1

SELECT p0_.id AS id_0, p0_.is_dummy AS is_dummy_1, p0_.uri_identity AS uri_identity_2, p0_.name AS name_3, p0_.description AS description_4, p0_.client_types AS client_types_5, p0_.phone_number AS phone_number_6, p0_.is_masseur AS is_masseur_7, p0_.extra_charge AS extra_charge_8, p0_.prepayment AS prepayment_9, p0_.prepayment_amount AS prepayment_amount_10, p0_.prepayment_comment AS prepayment_comment_11, p0_.is_approved AS is_approved_12, p0_.moderation_status AS moderation_status_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.inactivated_at AS inactivated_at_16, p0_.seo AS seo_17, p0_.delete_mode AS delete_mode_18, p0_.deleted_at AS deleted_at_19, p0_.person_gender AS person_gender_20, p0_.person_age AS person_age_21, p0_.person_height AS person_height_22, p0_.person_weight AS person_weight_23, p0_.person_breast_size AS person_breast_size_24, p0_.person_breast_type AS person_breast_type_25, p0_.person_cloth_size AS person_cloth_size_26, p0_.person_shoes_size AS person_shoes_size_27, p0_.person_body_type AS person_body_type_28, p0_.person_hair_color AS person_hair_color_29, p0_.person_private_haircut AS person_private_haircut_30, p0_.person_nationality AS person_nationality_31, p0_.person_has_tattoo AS person_has_tattoo_32, p0_.person_has_piercing AS person_has_piercing_33, p0_.messengers_telegram AS messengers_telegram_34, p0_.messengers_whatsapp AS messengers_whatsapp_35, p0_.messengers_telegram_username AS messengers_telegram_username_36, p0_.call_time_from AS call_time_from_37, p0_.call_time_to AS call_time_to_38, p0_.call_answering_to AS call_answering_to_39, p0_.client_min_age AS client_min_age_40, p0_.client_max_age AS client_max_age_41, p0_.apartments_one_hour_price AS apartments_one_hour_price_42, p0_.apartments_two_hours_price AS apartments_two_hours_price_43, p0_.apartments_night_price AS apartments_night_price_44, p0_.take_out_one_hour_price AS take_out_one_hour_price_45, p0_.take_out_two_hours_price AS take_out_two_hours_price_46, p0_.take_out_night_price AS take_out_night_price_47, p0_.take_out_locations AS take_out_locations_48, p0_.express_provided AS express_provided_49, p0_.express_price AS express_price_50, p0_.car_provided AS car_provided_51, p0_.map_latitude AS map_latitude_52, p0_.map_longitude AS map_longitude_53, p1_.id AS id_54, p1_.placed_at AS placed_at_55, p1_.expires_at AS expires_at_56, p0_.user_id AS user_id_57, p0_.city_id AS city_id_58, p0_.primary_station_id AS primary_station_id_59, p1_.city_id AS city_id_60, p1_.profile_id AS profile_id_61, p1_.placement_price_id AS placement_price_id_62 FROM profiles p0_ INNER JOIN profile_top_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.city_id = 1 AND ('2026-04-23 10:36:24' BETWEEN p1_.placed_at AND p1_.expires_at) AND (EXISTS (SELECT p2_.id FROM profile_provided_services p2_ WHERE p2_.service_id IN (2) AND p2_.profile_id = p0_.id))) AND (p0_.deleted_at IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.`group` AS group_2,
  t0.name AS name_3,
  t0.uri_identity AS uri_identity_4,
  t0.sort AS sort_5
FROM
  services t0
WHERE
  t0.`group` = ?

SELECT t0.id AS id_1, t0.`group` AS group_2, t0.name AS name_3, t0.uri_identity AS uri_identity_4, t0.sort AS sort_5 FROM services t0 WHERE t0.`group` = 1;

SELECT
  p0_.id AS id_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      EXISTS (
        SELECT
          p2_.id
        FROM
          profile_provided_services p2_
        WHERE
          p2_.service_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          AND p2_.profile_id = p0_.id
      )
    )
    AND (
      p0_.city_id = ?
      AND p0_.is_masseur = ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  36

SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (EXISTS (SELECT p2_.id FROM profile_provided_services p2_ WHERE p2_.service_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) AND p2_.profile_id = p0_.id)) AND (p0_.city_id = 1 AND p0_.is_masseur = 0)) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 36;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      EXISTS (
        SELECT
          p2_.id
        FROM
          profile_provided_services p2_
        WHERE
          p2_.service_id IN (?)
          AND p2_.profile_id = p0_.id
      )
    )
    AND p0_.city_id = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(p0_.id) AS sclr_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (EXISTS (SELECT p2_.id FROM profile_provided_services p2_ WHERE p2_.service_id IN (2) AND p2_.profile_id = p0_.id)) AND p0_.city_id = 1) AND (p0_.deleted_at IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.`group` AS group_1,
  s0_.name AS name_2,
  s0_.uri_identity AS uri_identity_3,
  s0_.sort AS sort_4
FROM
  services s0_
ORDER BY
  s0_.`group` ASC,
  s0_.sort ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.`group` AS group_1, s0_.name AS name_2, s0_.uri_identity AS uri_identity_3, s0_.sort AS sort_4 FROM services s0_ ORDER BY s0_.`group` ASC, s0_.sort ASC, s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.`group` AS group_2,
  t0.name AS name_3,
  t0.uri_identity AS uri_identity_4,
  t0.sort AS sort_5
FROM
  services t0
WHERE
  t0.uri_identity = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`group` AS group_2, t0.name AS name_3, t0.uri_identity AS uri_identity_4, t0.sort AS sort_5 FROM services t0 WHERE t0.uri_identity = 'seks-analnyij' LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      p0_.city_id = ?
      AND p0_.is_masseur = ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  36

SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (p0_.city_id = 1 AND p0_.is_masseur = 0)) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 36;