Symfony Profiler

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
  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-27 16:06:13' 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,
  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
  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
  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;

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;