Symfony Profiler

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
  p0_.profile_id AS sclr_0,
  SUM(p0_.visits) AS sclr_1
FROM
  profile_ctr p0_
  INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  INNER JOIN profile_adboard_placements p2_ ON p1_.id = p2_.profile_id
  LEFT JOIN placement_hidings p3_ ON p1_.id = p3_.profile_id
  AND p3_.entity_type IN ('profile')
WHERE
  p1_.city_id = ?
  AND p1_.moderation_status = ?
  AND p1_.deleted_at IS NULL
  AND p3_.id IS NULL
  AND p1_.person_gender IN (?)
  AND p0_.date >= ?
GROUP BY
  p0_.profile_id
HAVING
  SUM(p0_.visits) > 0
ORDER BY
  sclr_1 DESC,
  sclr_0 DESC
LIMIT
  100

SELECT p0_.profile_id AS sclr_0, SUM(p0_.visits) AS sclr_1 FROM profile_ctr p0_ INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id AND (p1_.deleted_at IS NULL) INNER JOIN profile_adboard_placements p2_ ON p1_.id = p2_.profile_id LEFT JOIN placement_hidings p3_ ON p1_.id = p3_.profile_id AND p3_.entity_type IN ('profile') WHERE p1_.city_id = 1 AND p1_.moderation_status = 1 AND p1_.deleted_at IS NULL AND p3_.id IS NULL AND p1_.person_gender IN (1) AND p0_.date >= '2026-07-29 18:00:53' GROUP BY p0_.profile_id HAVING SUM(p0_.visits) > 0 ORDER BY sclr_1 DESC, sclr_0 DESC LIMIT 100;

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
  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
  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,
  p0_.user_id AS user_id_54,
  p0_.city_id AS city_id_55,
  p0_.primary_station_id AS primary_station_id_56,
  p0_.saloon_id AS saloon_id_57
FROM
  profiles p0_
WHERE
  (
    p0_.id IN (NULL)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  FIELD(p0_.id, NULL) ASC

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, p0_.user_id AS user_id_54, p0_.city_id AS city_id_55, p0_.primary_station_id AS primary_station_id_56, p0_.saloon_id AS saloon_id_57 FROM profiles p0_ WHERE (p0_.id IN (NULL)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, NULL) 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.id IN (NULL)

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.id IN (NULL);

SELECT
  t0.id AS id_1,
  t0.is_dummy AS is_dummy_2,
  t0.uri_identity AS uri_identity_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.client_types AS client_types_6,
  t0.phone_number AS phone_number_7,
  t0.is_masseur AS is_masseur_8,
  t0.extra_charge AS extra_charge_9,
  t0.prepayment AS prepayment_10,
  t0.prepayment_amount AS prepayment_amount_11,
  t0.prepayment_comment AS prepayment_comment_12,
  t0.is_approved AS is_approved_13,
  t0.moderation_status AS moderation_status_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.inactivated_at AS inactivated_at_17,
  t0.seo AS seo_18,
  t0.delete_mode AS delete_mode_19,
  t0.deleted_at AS deleted_at_20,
  t0.person_gender AS person_gender_21,
  t0.person_age AS person_age_22,
  t0.person_height AS person_height_23,
  t0.person_weight AS person_weight_24,
  t0.person_breast_size AS person_breast_size_25,
  t0.person_breast_type AS person_breast_type_26,
  t0.person_cloth_size AS person_cloth_size_27,
  t0.person_shoes_size AS person_shoes_size_28,
  t0.person_body_type AS person_body_type_29,
  t0.person_hair_color AS person_hair_color_30,
  t0.person_private_haircut AS person_private_haircut_31,
  t0.person_nationality AS person_nationality_32,
  t0.person_has_tattoo AS person_has_tattoo_33,
  t0.person_has_piercing AS person_has_piercing_34,
  t0.messengers_telegram AS messengers_telegram_35,
  t0.messengers_whatsapp AS messengers_whatsapp_36,
  t0.messengers_telegram_username AS messengers_telegram_username_37,
  t0.call_time_from AS call_time_from_38,
  t0.call_time_to AS call_time_to_39,
  t0.call_answering_to AS call_answering_to_40,
  t0.client_min_age AS client_min_age_41,
  t0.client_max_age AS client_max_age_42,
  t0.apartments_one_hour_price AS apartments_one_hour_price_43,
  t0.apartments_two_hours_price AS apartments_two_hours_price_44,
  t0.apartments_night_price AS apartments_night_price_45,
  t0.take_out_one_hour_price AS take_out_one_hour_price_46,
  t0.take_out_two_hours_price AS take_out_two_hours_price_47,
  t0.take_out_night_price AS take_out_night_price_48,
  t0.take_out_locations AS take_out_locations_49,
  t0.express_provided AS express_provided_50,
  t0.express_price AS express_price_51,
  t0.car_provided AS car_provided_52,
  t0.map_latitude AS map_latitude_53,
  t0.map_longitude AS map_longitude_54,
  t0.user_id AS user_id_55,
  t56.type AS type_57,
  t56.position_group AS position_group_58,
  t56.position AS position_59,
  t56.placed_at AS placed_at_60,
  t56.placed_until AS placed_until_61,
  t56.plan_managed AS plan_managed_62,
  t56.profile_id AS profile_id_63,
  t56.placement_price_id AS placement_price_id_64,
  t0.city_id AS city_id_65,
  t0.primary_station_id AS primary_station_id_66,
  t0.saloon_id AS saloon_id_67
FROM
  profiles t0
  LEFT JOIN profile_adboard_placements t56 ON t56.profile_id = t0.id
WHERE
  t0.id IN (NULL)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.is_dummy AS is_dummy_2, t0.uri_identity AS uri_identity_3, t0.name AS name_4, t0.description AS description_5, t0.client_types AS client_types_6, t0.phone_number AS phone_number_7, t0.is_masseur AS is_masseur_8, t0.extra_charge AS extra_charge_9, t0.prepayment AS prepayment_10, t0.prepayment_amount AS prepayment_amount_11, t0.prepayment_comment AS prepayment_comment_12, t0.is_approved AS is_approved_13, t0.moderation_status AS moderation_status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.inactivated_at AS inactivated_at_17, t0.seo AS seo_18, t0.delete_mode AS delete_mode_19, t0.deleted_at AS deleted_at_20, t0.person_gender AS person_gender_21, t0.person_age AS person_age_22, t0.person_height AS person_height_23, t0.person_weight AS person_weight_24, t0.person_breast_size AS person_breast_size_25, t0.person_breast_type AS person_breast_type_26, t0.person_cloth_size AS person_cloth_size_27, t0.person_shoes_size AS person_shoes_size_28, t0.person_body_type AS person_body_type_29, t0.person_hair_color AS person_hair_color_30, t0.person_private_haircut AS person_private_haircut_31, t0.person_nationality AS person_nationality_32, t0.person_has_tattoo AS person_has_tattoo_33, t0.person_has_piercing AS person_has_piercing_34, t0.messengers_telegram AS messengers_telegram_35, t0.messengers_whatsapp AS messengers_whatsapp_36, t0.messengers_telegram_username AS messengers_telegram_username_37, t0.call_time_from AS call_time_from_38, t0.call_time_to AS call_time_to_39, t0.call_answering_to AS call_answering_to_40, t0.client_min_age AS client_min_age_41, t0.client_max_age AS client_max_age_42, t0.apartments_one_hour_price AS apartments_one_hour_price_43, t0.apartments_two_hours_price AS apartments_two_hours_price_44, t0.apartments_night_price AS apartments_night_price_45, t0.take_out_one_hour_price AS take_out_one_hour_price_46, t0.take_out_two_hours_price AS take_out_two_hours_price_47, t0.take_out_night_price AS take_out_night_price_48, t0.take_out_locations AS take_out_locations_49, t0.express_provided AS express_provided_50, t0.express_price AS express_price_51, t0.car_provided AS car_provided_52, t0.map_latitude AS map_latitude_53, t0.map_longitude AS map_longitude_54, t0.user_id AS user_id_55, t56.type AS type_57, t56.position_group AS position_group_58, t56.position AS position_59, t56.placed_at AS placed_at_60, t56.placed_until AS placed_until_61, t56.plan_managed AS plan_managed_62, t56.profile_id AS profile_id_63, t56.placement_price_id AS placement_price_id_64, t0.city_id AS city_id_65, t0.primary_station_id AS primary_station_id_66, t0.saloon_id AS saloon_id_67 FROM profiles t0 LEFT JOIN profile_adboard_placements t56 ON t56.profile_id = t0.id WHERE t0.id IN (NULL) AND ((t0.deleted_at IS NULL));

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 = '/moskva/recommendations/profile/cnt5/img357x500/exclude/gender1' 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_.city_price_category AS city_price_category_5,
  c0_.timezone AS timezone_6,
  c0_.region AS region_7,
  c0_.map_latitude AS map_latitude_8,
  c0_.map_longitude AS map_longitude_9
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_.city_price_category AS city_price_category_5, c0_.timezone AS timezone_6, c0_.region AS region_7, c0_.map_latitude AS map_latitude_8, c0_.map_longitude AS map_longitude_9 FROM cities c0_ WHERE c0_.uri_identity = 'moskva' LIMIT 1;