Symfony Profiler

SELECT
  p.*,
  JSON_UNQUOTE(
    JSON_EXTRACT(p.name, '$.ru')
  ) AS `name`,
  JSON_UNQUOTE(
    JSON_EXTRACT(p.description, '$.ru')
  ) AS `description`,
  (
    SELECT
      path
    FROM
      profile_media_files pmf_avatar
    WHERE
      p.id = pmf_avatar.profile_id
      AND pmf_avatar.type = 'avatar'
      AND pmf_avatar.is_main = 0
    LIMIT
      1
  ) AS `avatar_path`,
  (
    SELECT
      TYPE
    FROM
      profile_adboard_placements pap
    WHERE
      p.id = pap.profile_id
    LIMIT
      1
  ) AS `adboard_placement_type`,
  (
    SELECT
      position
    FROM
      profile_adboard_placements pap
    WHERE
      p.id = pap.profile_id
    LIMIT
      1
  ) AS `adboard_placement_position`,
  c.id AS `city_id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(c.name, '$.ru')
  ) AS `city_name`,
  c.uri_identity AS `city_uri_identity`,
  c.country_code AS `city_country_code`,
  EXISTS(
    SELECT
      *
    FROM
      profile_top_placements ptp
    WHERE
      p.id = ptp.profile_id
      AND (
        NOW() BETWEEN ptp.placed_at
        AND ptp.expires_at
      )
  ) AS `has_top_placement`,
  EXISTS(
    SELECT
      *
    FROM
      placement_hidings ph
    WHERE
      p.id = ph.profile_id
      AND ph.entity_type = 'profile'
  ) AS `has_placement_hiding`,
  (
    SELECT
      COUNT(*)
    FROM
      profile_comments pc
    WHERE
      p.id = pc.profile_id
      AND pc.deleted_at IS NULL
  ) AS `comments_count`,
  (
    SELECT
      COUNT(*)
    FROM
      profile_media_files pmf_photo
    WHERE
      p.id = pmf_photo.profile_id
      AND pmf_photo.type = 'photo'
  ) AS `photos_count`,
  (
    SELECT
      COUNT(*)
    FROM
      profile_media_files pmf_video
    WHERE
      p.id = pmf_video.profile_id
      AND pmf_video.type = 'video'
  ) AS `videos_count`,
  (
    SELECT
      COUNT(*)
    FROM
      profile_media_files pmf_selfie
    WHERE
      p.id = pmf_selfie.profile_id
      AND pmf_selfie.type = 'selfie'
  ) AS `selfies_count`,
  p.primary_station_id
FROM
  profiles `p`
  JOIN cities `c` ON c.id = p.city_id
WHERE
  p.id IN (200)
ORDER BY
  FIELD(p.id, 200)

SELECT 
                p.*, JSON_UNQUOTE(JSON_EXTRACT(p.name, '$.ru')) 
                    AS `name`, 
                JSON_UNQUOTE(JSON_EXTRACT(p.description, '$.ru')) 
                    AS `description`,
                (SELECT path FROM profile_media_files pmf_avatar WHERE p.id = pmf_avatar.profile_id AND pmf_avatar.type = 'avatar' AND pmf_avatar.is_main = 0 LIMIT 1) 
                    AS `avatar_path`,
                (SELECT TYPE FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_type`,
                (SELECT position FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_position`,
                c.id 
                    AS `city_id`, 
                JSON_UNQUOTE(JSON_EXTRACT(c.name, '$.ru')) 
                    AS `city_name`, 
                c.uri_identity 
                    AS `city_uri_identity`,
                c.country_code 
                    AS `city_country_code`,
                EXISTS(SELECT * FROM profile_top_placements ptp WHERE p.id = ptp.profile_id AND (NOW() BETWEEN ptp.placed_at AND ptp.expires_at))
                    AS `has_top_placement`,
                EXISTS(SELECT * FROM placement_hidings ph WHERE p.id = ph.profile_id AND ph.entity_type = 'profile') 
                    AS `has_placement_hiding`,
                (SELECT COUNT(*) FROM profile_comments pc WHERE p.id = pc.profile_id AND pc.deleted_at IS NULL) 
                    AS `comments_count`,
                (SELECT COUNT(*) FROM profile_media_files pmf_photo WHERE p.id = pmf_photo.profile_id AND pmf_photo.type = 'photo') 
                    AS `photos_count`,
                (SELECT COUNT(*) FROM profile_media_files pmf_video WHERE p.id = pmf_video.profile_id AND pmf_video.type = 'video') 
                    AS `videos_count`,
                (SELECT COUNT(*) FROM profile_media_files pmf_selfie WHERE p.id = pmf_selfie.profile_id AND pmf_selfie.type = 'selfie') 
                    AS `selfies_count`,
                p.primary_station_id 
            FROM profiles `p`
            JOIN cities `c` ON c.id = p.city_id 
            WHERE p.id IN (200)
            ORDER BY FIELD(p.id,200);

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
  p0_.id AS id_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND p0_.city_id = ?
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.created_at DESC,
  p0_.id DESC
LIMIT
  100

SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND p0_.city_id = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.created_at DESC, p0_.id DESC LIMIT 100;

SELECT
  s.id AS `id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(s.name, '$.ru')
  ) AS `name`,
  s.group AS `group`,
  s.uri_identity AS `uriIdentity`,
  pps.profile_id AS `profile_id`,
  pps.service_condition AS `condition`,
  pps.extra_charge AS `extra_charge`,
  pps.comment AS `comment`
FROM
  profile_provided_services pps
  JOIN services s ON pps.service_id = s.id
WHERE
  pps.profile_id IN (200)
ORDER BY
  s.group ASC,
  s.sort ASC,
  s.id ASC

SELECT 
                    s.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(s.name, '$.ru')) 
                        AS `name`, 
                    s.group 
                        AS `group`, 
                    s.uri_identity 
                        AS `uriIdentity`,
                    pps.profile_id
                        AS `profile_id`,
                    pps.service_condition
                        AS `condition`,
                    pps.extra_charge
                        AS `extra_charge`,
                    pps.comment
                        AS `comment`
                FROM profile_provided_services pps
                JOIN services s ON pps.service_id = s.id 
                WHERE pps.profile_id IN (200)
                ORDER BY s.group ASC, s.sort ASC, s.id ASC;

SELECT
  ppn.profile_id,
  pn.uri_identity
FROM
  profile_profile_names ppn
  JOIN profile_names pn ON pn.id = ppn.profile_name_id
WHERE
  ppn.profile_id IN (200)
ORDER BY
  pn.canonical_name ASC

SELECT ppn.profile_id, pn.uri_identity
             FROM profile_profile_names ppn
             JOIN profile_names pn ON pn.id = ppn.profile_name_id
             WHERE ppn.profile_id IN (200)
             ORDER BY pn.canonical_name ASC;

SELECT
  cs.id AS `id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(cs.name, '$.ru')
  ) AS `name`,
  cs.uri_identity AS `uriIdentity`,
  ps.profile_id AS `profile_id`,
  csl.name AS `line_name`,
  csl.color AS `line_color`,
  cs.county_id,
  cs.district_id
FROM
  profile_stations ps
  JOIN city_stations cs ON ps.station_id = cs.id
  LEFT JOIN city_subway_station_lines cssl ON cssl.station_id = cs.id
  LEFT JOIN city_subway_lines csl ON csl.id = cssl.line_id
WHERE
  ps.profile_id IN (200)

SELECT 
                    cs.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(cs.name, '$.ru')) 
                        AS `name`, 
                    cs.uri_identity 
                        AS `uriIdentity`, 
                    ps.profile_id
                        AS `profile_id`,
                    csl.name
                        AS `line_name`,
                    csl.color
                        AS `line_color`,
                    cs.county_id, cs.district_id
                FROM profile_stations ps
                JOIN city_stations cs ON ps.station_id = cs.id 
                LEFT JOIN city_subway_station_lines cssl ON cssl.station_id = cs.id
                LEFT JOIN city_subway_lines csl ON csl.id = cssl.line_id
                WHERE ps.profile_id IN (200);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c1_.id AS id_3
FROM
  city_districts c0_
  INNER JOIN cities c1_ ON c0_.city_id = c1_.id
WHERE
  c0_.id IN (NULL)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c1_.id AS id_3 FROM city_districts c0_ INNER JOIN cities c1_ ON c0_.city_id = c1_.id WHERE c0_.id IN (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_.last_modified AS last_modified_8,
  p0_.city_id AS city_id_9
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_.last_modified AS last_modified_8, p0_.city_id AS city_id_9 FROM page_seo_texts p0_ WHERE p0_.uri = '/moskva/new/' 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;

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.city_price_category AS city_price_category_6,
  t0.timezone AS timezone_7,
  t0.region AS region_8,
  t0.map_latitude AS map_latitude_9,
  t0.map_longitude AS map_longitude_10
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.city_price_category AS city_price_category_6, t0.timezone AS timezone_7, t0.region AS region_8, t0.map_latitude AS map_latitude_9, t0.map_longitude AS map_longitude_10 FROM cities t0;