Symfony Profiler

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-25 13:50:00' GROUP BY p0_.profile_id HAVING SUM(p0_.visits) > 0 ORDER BY sclr_1 DESC, sclr_0 DESC LIMIT 100;

SELECT
  (
    CASE WHEN (s0_.position_group IS NOT NULL) THEN s0_.position_group ELSE 0 END
  ) AS sclr_0,
  (
    CASE WHEN (s0_.position IS NOT NULL) THEN s0_.position ELSE 0 END
  ) AS sclr_1,
  (
    CASE WHEN (s1_.user_id IS NOT NULL) THEN 1 ELSE 0 END
  ) AS sclr_2,
  s1_.id AS id_3,
  s1_.uri_identity AS uri_identity_4,
  s1_.name AS name_5,
  s1_.description AS description_6,
  s1_.client_types AS client_types_7,
  s1_.phone_number AS phone_number_8,
  s1_.prices AS prices_9,
  s1_.extra_charge AS extra_charge_10,
  s1_.districts AS districts_11,
  s1_.address AS address_12,
  s1_.created_at AS created_at_13,
  s1_.updated_at AS updated_at_14,
  s1_.inactivated_at AS inactivated_at_15,
  s1_.email AS email_16,
  s1_.seo AS seo_17,
  s1_.delete_mode AS delete_mode_18,
  s1_.deleted_at AS deleted_at_19,
  s1_.messengers_telegram AS messengers_telegram_20,
  s1_.messengers_whatsapp AS messengers_whatsapp_21,
  s1_.messengers_max AS messengers_max_22,
  s1_.messengers_telegram_username AS messengers_telegram_username_23,
  s1_.messengers_max_url AS messengers_max_url_24,
  s1_.call_time_from AS call_time_from_25,
  s1_.call_time_to AS call_time_to_26,
  s1_.call_answering_to AS call_answering_to_27,
  s1_.working_hours_since AS working_hours_since_28,
  s1_.working_hours_till AS working_hours_till_29,
  s1_.apartments_one_hour_price AS apartments_one_hour_price_30,
  s1_.apartments_two_hours_price AS apartments_two_hours_price_31,
  s1_.apartments_night_price AS apartments_night_price_32,
  s1_.take_out_one_hour_price AS take_out_one_hour_price_33,
  s1_.take_out_two_hours_price AS take_out_two_hours_price_34,
  s1_.take_out_night_price AS take_out_night_price_35,
  s1_.take_out_locations AS take_out_locations_36,
  s1_.express_provided AS express_provided_37,
  s1_.express_price AS express_price_38,
  s1_.map_latitude AS map_latitude_39,
  s1_.map_longitude AS map_longitude_40,
  p2_.id AS id_41,
  p2_.placed_at AS placed_at_42,
  p2_.placed_until AS placed_until_43,
  s0_.type AS type_44,
  s0_.position_group AS position_group_45,
  s0_.position AS position_46,
  s0_.placed_at AS placed_at_47,
  s0_.placed_until AS placed_until_48,
  c3_.id AS id_49,
  c3_.name AS name_50,
  c3_.uri_identity AS uri_identity_51,
  c3_.country_code AS country_code_52,
  c3_.city_group AS city_group_53,
  c3_.city_price_category AS city_price_category_54,
  c3_.timezone AS timezone_55,
  c3_.map_latitude AS map_latitude_56,
  c3_.map_longitude AS map_longitude_57,
  c4_.id AS id_58,
  c4_.name AS name_59,
  c4_.uri_identity AS uri_identity_60,
  s5_.id AS id_61,
  s5_.path AS path_62,
  s5_.preview_path AS preview_path_63,
  s6_.type AS type_64,
  s6_.position_group AS position_group_65,
  s6_.position AS position_66,
  s6_.placed_at AS placed_at_67,
  s6_.placed_until AS placed_until_68,
  s1_.user_id AS user_id_69,
  s1_.city_id AS city_id_70,
  s1_.primary_station_id AS primary_station_id_71,
  p2_.entity_type AS entity_type_72,
  p2_.saloon_id AS saloon_id_73,
  s0_.saloon_id AS saloon_id_74,
  s0_.placement_price_id AS placement_price_id_75,
  c4_.city_id AS city_id_76,
  c4_.county_id AS county_id_77,
  c4_.district_id AS district_id_78,
  s5_.type AS type_79,
  s5_.saloon_id AS saloon_id_80,
  s6_.saloon_id AS saloon_id_81,
  s6_.placement_price_id AS placement_price_id_82
FROM
  saloons s1_
  LEFT JOIN placement_hidings p2_ ON s1_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s0_ ON s1_.id = s0_.saloon_id
  INNER JOIN cities c3_ ON s1_.city_id = c3_.id
  LEFT JOIN saloon_stations s7_ ON s1_.id = s7_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s7_.station_id
  LEFT JOIN saloon_media_files s5_ ON s1_.id = s5_.saloon_id
  AND s5_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s6_ ON s1_.id = s6_.saloon_id
WHERE
  (
    p2_.id IS NULL
    AND s1_.city_id = ?
    AND s1_.id IN (?)
  )
  AND (s1_.deleted_at IS NULL)
ORDER BY
  sclr_0 DESC,
  sclr_1 ASC,
  s1_.inactivated_at DESC,
  sclr_2 DESC,
  s1_.id DESC

SELECT (CASE WHEN (s0_.position_group IS NOT NULL) THEN s0_.position_group ELSE 0 END) AS sclr_0, (CASE WHEN (s0_.position IS NOT NULL) THEN s0_.position ELSE 0 END) AS sclr_1, (CASE WHEN (s1_.user_id IS NOT NULL) THEN 1 ELSE 0 END) AS sclr_2, s1_.id AS id_3, s1_.uri_identity AS uri_identity_4, s1_.name AS name_5, s1_.description AS description_6, s1_.client_types AS client_types_7, s1_.phone_number AS phone_number_8, s1_.prices AS prices_9, s1_.extra_charge AS extra_charge_10, s1_.districts AS districts_11, s1_.address AS address_12, s1_.created_at AS created_at_13, s1_.updated_at AS updated_at_14, s1_.inactivated_at AS inactivated_at_15, s1_.email AS email_16, s1_.seo AS seo_17, s1_.delete_mode AS delete_mode_18, s1_.deleted_at AS deleted_at_19, s1_.messengers_telegram AS messengers_telegram_20, s1_.messengers_whatsapp AS messengers_whatsapp_21, s1_.messengers_max AS messengers_max_22, s1_.messengers_telegram_username AS messengers_telegram_username_23, s1_.messengers_max_url AS messengers_max_url_24, s1_.call_time_from AS call_time_from_25, s1_.call_time_to AS call_time_to_26, s1_.call_answering_to AS call_answering_to_27, s1_.working_hours_since AS working_hours_since_28, s1_.working_hours_till AS working_hours_till_29, s1_.apartments_one_hour_price AS apartments_one_hour_price_30, s1_.apartments_two_hours_price AS apartments_two_hours_price_31, s1_.apartments_night_price AS apartments_night_price_32, s1_.take_out_one_hour_price AS take_out_one_hour_price_33, s1_.take_out_two_hours_price AS take_out_two_hours_price_34, s1_.take_out_night_price AS take_out_night_price_35, s1_.take_out_locations AS take_out_locations_36, s1_.express_provided AS express_provided_37, s1_.express_price AS express_price_38, s1_.map_latitude AS map_latitude_39, s1_.map_longitude AS map_longitude_40, p2_.id AS id_41, p2_.placed_at AS placed_at_42, p2_.placed_until AS placed_until_43, s0_.type AS type_44, s0_.position_group AS position_group_45, s0_.position AS position_46, s0_.placed_at AS placed_at_47, s0_.placed_until AS placed_until_48, c3_.id AS id_49, c3_.name AS name_50, c3_.uri_identity AS uri_identity_51, c3_.country_code AS country_code_52, c3_.city_group AS city_group_53, c3_.city_price_category AS city_price_category_54, c3_.timezone AS timezone_55, c3_.map_latitude AS map_latitude_56, c3_.map_longitude AS map_longitude_57, c4_.id AS id_58, c4_.name AS name_59, c4_.uri_identity AS uri_identity_60, s5_.id AS id_61, s5_.path AS path_62, s5_.preview_path AS preview_path_63, s6_.type AS type_64, s6_.position_group AS position_group_65, s6_.position AS position_66, s6_.placed_at AS placed_at_67, s6_.placed_until AS placed_until_68, s1_.user_id AS user_id_69, s1_.city_id AS city_id_70, s1_.primary_station_id AS primary_station_id_71, p2_.entity_type AS entity_type_72, p2_.saloon_id AS saloon_id_73, s0_.saloon_id AS saloon_id_74, s0_.placement_price_id AS placement_price_id_75, c4_.city_id AS city_id_76, c4_.county_id AS county_id_77, c4_.district_id AS district_id_78, s5_.type AS type_79, s5_.saloon_id AS saloon_id_80, s6_.saloon_id AS saloon_id_81, s6_.placement_price_id AS placement_price_id_82 FROM saloons s1_ LEFT JOIN placement_hidings p2_ ON s1_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s0_ ON s1_.id = s0_.saloon_id INNER JOIN cities c3_ ON s1_.city_id = c3_.id LEFT JOIN saloon_stations s7_ ON s1_.id = s7_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s7_.station_id LEFT JOIN saloon_media_files s5_ ON s1_.id = s5_.saloon_id AND s5_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s6_ ON s1_.id = s6_.saloon_id WHERE (p2_.id IS NULL AND s1_.city_id = 1 AND s1_.id IN (1)) AND (s1_.deleted_at IS NULL) ORDER BY sclr_0 DESC, sclr_1 ASC, s1_.inactivated_at DESC, sclr_2 DESC, s1_.id DESC;

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
  DISTINCT s0_.id AS id_0,
  (
    CASE WHEN (s1_.position_group IS NOT NULL) THEN s1_.position_group ELSE 0 END
  ) AS sclr_1,
  (
    CASE WHEN (s1_.position IS NOT NULL) THEN s1_.position ELSE 0 END
  ) AS sclr_2,
  s0_.inactivated_at AS inactivated_at_3,
  (
    CASE WHEN (s0_.user_id IS NOT NULL) THEN 1 ELSE 0 END
  ) AS sclr_4,
  s0_.id AS id_5
FROM
  saloons s0_
  LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id
  INNER JOIN cities c3_ ON s0_.city_id = c3_.id
  LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id
  LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id
  AND s6_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id
WHERE
  (
    p2_.id IS NULL
    AND s0_.city_id = ?
  )
  AND (s0_.deleted_at IS NULL)
ORDER BY
  sclr_1 DESC,
  sclr_2 ASC,
  s0_.inactivated_at DESC,
  sclr_4 DESC,
  s0_.id DESC
LIMIT
  36

SELECT DISTINCT s0_.id AS id_0, (CASE WHEN (s1_.position_group IS NOT NULL) THEN s1_.position_group ELSE 0 END) AS sclr_1, (CASE WHEN (s1_.position IS NOT NULL) THEN s1_.position ELSE 0 END) AS sclr_2, s0_.inactivated_at AS inactivated_at_3, (CASE WHEN (s0_.user_id IS NOT NULL) THEN 1 ELSE 0 END) AS sclr_4, s0_.id AS id_5 FROM saloons s0_ LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id INNER JOIN cities c3_ ON s0_.city_id = c3_.id LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id AND s6_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id WHERE (p2_.id IS NULL AND s0_.city_id = 1) AND (s0_.deleted_at IS NULL) ORDER BY sclr_1 DESC, sclr_2 ASC, s0_.inactivated_at DESC, sclr_4 DESC, s0_.id DESC LIMIT 36;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  saloons s0_
  LEFT JOIN placement_hidings p1_ ON s0_.id = p1_.saloon_id
  AND p1_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s2_ ON s0_.id = s2_.saloon_id
  INNER JOIN cities c3_ ON s0_.city_id = c3_.id
  LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id
  LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id
  AND s6_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id
WHERE
  (
    p1_.id IS NULL
    AND s0_.city_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM saloons s0_ LEFT JOIN placement_hidings p1_ ON s0_.id = p1_.saloon_id AND p1_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s2_ ON s0_.id = s2_.saloon_id INNER JOIN cities c3_ ON s0_.city_id = c3_.id LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id AND s6_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id WHERE (p1_.id IS NULL AND s0_.city_id = 1) AND (s0_.deleted_at IS 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
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 = '/moskva/salons/' LIMIT 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
  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_.map_latitude AS map_latitude_7,
  c0_.map_longitude AS map_longitude_8
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_.map_latitude AS map_latitude_7, c0_.map_longitude AS map_longitude_8 FROM cities c0_ WHERE c0_.uri_identity = 'moskva' LIMIT 1;