Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 66
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 4
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.caption AS caption_2, l1_.id AS id_3, l1_.name AS name_4, l1_.code AS code_5, g0_.gallery_item_id AS gallery_item_id_6, g0_.language_id AS language_id_7 FROM gallery_item_translation g0_ INNER JOIN gallery_item g2_ ON g0_.gallery_item_id = g2_.id INNER JOIN language l1_ ON g0_.language_id = l1_.id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item_translation g3_ INNER JOIN gallery_item g4_ ON g3_.gallery_item_id = g4_.id WHERE g4_.id = ?) ORDER BY g0_.id ASC LIMIT 10

[
  1
]

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.caption AS caption_2,
  l1_.id AS id_3,
  l1_.name AS name_4,
  l1_.code AS code_5,
  g0_.gallery_item_id AS gallery_item_id_6,
  g0_.language_id AS language_id_7
FROM
  gallery_item_translation g0_
  INNER JOIN gallery_item g2_ ON g0_.gallery_item_id = g2_.id
  INNER JOIN language l1_ ON g0_.language_id = l1_.id
WHERE
  g0_.id IN (
    SELECT
      g3_.id
    FROM
      gallery_item_translation g3_
      INNER JOIN gallery_item g4_ ON g3_.gallery_item_id = g4_.id
    WHERE
      g4_.id = ?
  )
ORDER BY
  g0_.id ASC
LIMIT
  10

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.caption AS caption_2, l1_.id AS id_3, l1_.name AS name_4, l1_.code AS code_5, g0_.gallery_item_id AS gallery_item_id_6, g0_.language_id AS language_id_7 FROM gallery_item_translation g0_ INNER JOIN gallery_item g2_ ON g0_.gallery_item_id = g2_.id INNER JOIN language l1_ ON g0_.language_id = l1_.id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item_translation g3_ INNER JOIN gallery_item g4_ ON g3_.gallery_item_id = g4_.id WHERE g4_.id = 1) ORDER BY g0_.id ASC LIMIT 10;

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, l1_.id AS id_3, l1_.name AS name_4, l1_.code AS code_5, g0_.gallery_id AS gallery_id_6, g0_.language_id AS language_id_7 FROM gallery_translation g0_ INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id INNER JOIN language l1_ ON g0_.language_id = l1_.id WHERE g0_.id IN (SELECT g3_.id FROM gallery_translation g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = ?) ORDER BY g0_.id ASC LIMIT 10

[
  2
]

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.description AS description_2,
  l1_.id AS id_3,
  l1_.name AS name_4,
  l1_.code AS code_5,
  g0_.gallery_id AS gallery_id_6,
  g0_.language_id AS language_id_7
FROM
  gallery_translation g0_
  INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id
  INNER JOIN language l1_ ON g0_.language_id = l1_.id
WHERE
  g0_.id IN (
    SELECT
      g3_.id
    FROM
      gallery_translation g3_
      INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id
    WHERE
      g4_.id = ?
  )
ORDER BY
  g0_.id ASC
LIMIT
  10

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, l1_.id AS id_3, l1_.name AS name_4, l1_.code AS code_5, g0_.gallery_id AS gallery_id_6, g0_.language_id AS language_id_7 FROM gallery_translation g0_ INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id INNER JOIN language l1_ ON g0_.language_id = l1_.id WHERE g0_.id IN (SELECT g3_.id FROM gallery_translation g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = 2) ORDER BY g0_.id ASC LIMIT 10;

SELECT DISTINCT g0_.id AS id_0, g0_.id AS id_1 FROM gallery_item g0_ INNER JOIN gallery g1_ ON g0_.gallery_id = g1_.id LEFT JOIN gallery_item_translation g2_ ON g0_.id = g2_.gallery_item_id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = ?) ORDER BY g0_.id ASC LIMIT 24

[
  2
]

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.id AS id_1
FROM
  gallery_item g0_
  INNER JOIN gallery g1_ ON g0_.gallery_id = g1_.id
  LEFT JOIN gallery_item_translation g2_ ON g0_.id = g2_.gallery_item_id
WHERE
  g0_.id IN (
    SELECT
      g3_.id
    FROM
      gallery_item g3_
      INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id
    WHERE
      g4_.id = ?
  )
ORDER BY
  g0_.id ASC
LIMIT
  24

SELECT DISTINCT g0_.id AS id_0, g0_.id AS id_1 FROM gallery_item g0_ INNER JOIN gallery g1_ ON g0_.gallery_id = g1_.id LEFT JOIN gallery_item_translation g2_ ON g0_.id = g2_.gallery_item_id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = 2) ORDER BY g0_.id ASC LIMIT 24;

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM gallery t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1

[
  "girls"
  1
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.is_active AS is_active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  gallery t0
WHERE
  t0.slug = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM gallery t0 WHERE t0.slug = 'girls' AND t0.is_active = 1 LIMIT 1;

SELECT g0_.id AS id_0, g0_.type AS type_1, g0_.sort_order AS sort_order_2, g0_.is_active AS is_active_3, g0_.image_src AS image_src_4, g0_.image_alt AS image_alt_5, g0_.stream_uid AS stream_uid_6, g0_.stream_status AS stream_status_7, g0_.poster_image_src AS poster_image_src_8, g0_.duration_seconds AS duration_seconds_9, g0_.created_at AS created_at_10, g0_.updated_at AS updated_at_11, g1_.id AS id_12, g1_.title AS title_13, g1_.caption AS caption_14, g0_.gallery_id AS gallery_id_15, g1_.gallery_item_id AS gallery_item_id_16, g1_.language_id AS language_id_17 FROM gallery_item g0_ INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id LEFT JOIN gallery_item_translation g1_ ON g0_.id = g1_.gallery_item_id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = ?) AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.id ASC

[
  2
  1
  2
  3
  4
  5
  6
  7
  8
]

SELECT
  g0_.id AS id_0,
  g0_.type AS type_1,
  g0_.sort_order AS sort_order_2,
  g0_.is_active AS is_active_3,
  g0_.image_src AS image_src_4,
  g0_.image_alt AS image_alt_5,
  g0_.stream_uid AS stream_uid_6,
  g0_.stream_status AS stream_status_7,
  g0_.poster_image_src AS poster_image_src_8,
  g0_.duration_seconds AS duration_seconds_9,
  g0_.created_at AS created_at_10,
  g0_.updated_at AS updated_at_11,
  g1_.id AS id_12,
  g1_.title AS title_13,
  g1_.caption AS caption_14,
  g0_.gallery_id AS gallery_id_15,
  g1_.gallery_item_id AS gallery_item_id_16,
  g1_.language_id AS language_id_17
FROM
  gallery_item g0_
  INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id
  LEFT JOIN gallery_item_translation g1_ ON g0_.id = g1_.gallery_item_id
WHERE
  g0_.id IN (
    SELECT
      g3_.id
    FROM
      gallery_item g3_
      INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id
    WHERE
      g4_.id = ?
  )
  AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  g0_.id ASC

SELECT g0_.id AS id_0, g0_.type AS type_1, g0_.sort_order AS sort_order_2, g0_.is_active AS is_active_3, g0_.image_src AS image_src_4, g0_.image_alt AS image_alt_5, g0_.stream_uid AS stream_uid_6, g0_.stream_status AS stream_status_7, g0_.poster_image_src AS poster_image_src_8, g0_.duration_seconds AS duration_seconds_9, g0_.created_at AS created_at_10, g0_.updated_at AS updated_at_11, g1_.id AS id_12, g1_.title AS title_13, g1_.caption AS caption_14, g0_.gallery_id AS gallery_id_15, g1_.gallery_item_id AS gallery_item_id_16, g1_.language_id AS language_id_17 FROM gallery_item g0_ INNER JOIN gallery g2_ ON g0_.gallery_id = g2_.id LEFT JOIN gallery_item_translation g1_ ON g0_.id = g1_.gallery_item_id WHERE g0_.id IN (SELECT g3_.id FROM gallery_item g3_ INNER JOIN gallery g4_ ON g3_.gallery_id = g4_.id WHERE g4_.id = 2) AND g0_.id IN (1, 2, 3, 4, 5, 6, 7, 8) ORDER BY g0_.id ASC;