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/gallery/' 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
  DISTINCT p0_.id AS id_0,
  p1_.position_group AS position_group_1,
  p1_.position AS position_2
FROM
  profiles p0_
  LEFT JOIN placement_hidings p2_ ON p0_.id = p2_.profile_id
  AND p2_.entity_type IN ('profile')
  LEFT JOIN profile_media_files p3_ ON p0_.id = p3_.profile_id
  AND p3_.type IN ('avatar')
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
  INNER JOIN cities c4_ ON p0_.city_id = c4_.id
  LEFT JOIN profile_stations p6_ ON p0_.id = p6_.profile_id
  LEFT JOIN city_stations c5_ ON c5_.id = p6_.station_id
  LEFT JOIN profile_media_files p7_ ON p0_.id = p7_.profile_id
  AND p7_.type IN (
    'photo', 'video', 'selfie', 'avatar',
    'adm_apr_ph'
  )
  LEFT JOIN profile_media_files p8_ ON p0_.id = p8_.profile_id
  AND p8_.type IN ('video')
  LEFT JOIN profile_media_files p9_ ON p0_.id = p9_.profile_id
  AND p9_.type IN ('avatar')
  LEFT JOIN profile_comments p10_ ON p0_.id = p10_.profile_id
  AND p10_.account_type IN ('customer')
  AND (p10_.deleted_at IS NULL)
  LEFT JOIN profile_top_placements p11_ ON p0_.id = p11_.profile_id
WHERE
  (
    (
      p0_.city_id = ?
      AND NOT (p0_.is_masseur = ?)
    )
    AND p0_.person_gender IN (?)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p1_.position_group DESC,
  p1_.position ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p1_.position_group AS position_group_1, p1_.position AS position_2 FROM profiles p0_ LEFT JOIN placement_hidings p2_ ON p0_.id = p2_.profile_id AND p2_.entity_type IN ('profile') LEFT JOIN profile_media_files p3_ ON p0_.id = p3_.profile_id AND p3_.type IN ('avatar') INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id INNER JOIN cities c4_ ON p0_.city_id = c4_.id LEFT JOIN profile_stations p6_ ON p0_.id = p6_.profile_id LEFT JOIN city_stations c5_ ON c5_.id = p6_.station_id LEFT JOIN profile_media_files p7_ ON p0_.id = p7_.profile_id AND p7_.type IN ('photo', 'video', 'selfie', 'avatar', 'adm_apr_ph') LEFT JOIN profile_media_files p8_ ON p0_.id = p8_.profile_id AND p8_.type IN ('video') LEFT JOIN profile_media_files p9_ ON p0_.id = p9_.profile_id AND p9_.type IN ('avatar') LEFT JOIN profile_comments p10_ ON p0_.id = p10_.profile_id AND p10_.account_type IN ('customer') AND (p10_.deleted_at IS NULL) LEFT JOIN profile_top_placements p11_ ON p0_.id = p11_.profile_id WHERE ((p0_.city_id = 1 AND NOT (p0_.is_masseur = 1)) AND p0_.person_gender IN (1)) AND (p0_.deleted_at IS NULL) ORDER BY p1_.position_group DESC, p1_.position ASC LIMIT 30;

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
  s0_.id AS id_0,
  s0_.`group` AS group_1,
  s0_.name AS name_2,
  s0_.uri_identity AS uri_identity_3
FROM
  services s0_
ORDER BY
  s0_.`group` 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 FROM services s0_ ORDER BY s0_.`group` ASC, s0_.id ASC;