Symfony Profiler

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/salons/' 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 = ?
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
  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
  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
  1

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 1;

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
  1

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 1;

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.country_code AS country_code_4,
  t0.city_group AS city_group_5,
  t0.timezone AS timezone_6,
  t0.map_latitude AS map_latitude_7,
  t0.map_longitude AS map_longitude_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0;

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;