Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.description AS description_4, t0.created_by_id AS created_by_id_5 FROM media_category t0 WHERE t0.id = ?

[
  "019b12b9-2c2d-78b6-a32c-9054bdc2671e"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.description AS description_4,
  t0.created_by_id AS created_by_id_5
FROM
  media_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.description AS description_4, t0.created_by_id AS created_by_id_5 FROM media_category t0 WHERE t0.id = '019b12b9-2c2d-78b6-a32c-9054bdc2671e';

SELECT t0.id AS id_1, t0.file AS file_2, t0.file_thumbnail AS file_thumbnail_3, t0.file_type AS file_type_4, t0.created AS created_5, t0.expiry AS expiry_6, t0.original_filename AS original_filename_7, t0.brand AS brand_8, t0.barcode AS barcode_9, t0.approved AS approved_10, t0.category_id AS category_id_11, t0.created_by_id AS created_by_id_12 FROM media_item t0 WHERE t0.category_id = ? AND t0.approved = ? ORDER BY t0.created DESC

[
  "019b12b9-2c2d-78b6-a32c-9054bdc2671e"
  1
]

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.file_thumbnail AS file_thumbnail_3,
  t0.file_type AS file_type_4,
  t0.created AS created_5,
  t0.expiry AS expiry_6,
  t0.original_filename AS original_filename_7,
  t0.brand AS brand_8,
  t0.barcode AS barcode_9,
  t0.approved AS approved_10,
  t0.category_id AS category_id_11,
  t0.created_by_id AS created_by_id_12
FROM
  media_item t0
WHERE
  t0.category_id = ?
  AND t0.approved = ?
ORDER BY
  t0.created DESC

SELECT t0.id AS id_1, t0.file AS file_2, t0.file_thumbnail AS file_thumbnail_3, t0.file_type AS file_type_4, t0.created AS created_5, t0.expiry AS expiry_6, t0.original_filename AS original_filename_7, t0.brand AS brand_8, t0.barcode AS barcode_9, t0.approved AS approved_10, t0.category_id AS category_id_11, t0.created_by_id AS created_by_id_12 FROM media_item t0 WHERE t0.category_id = '019b12b9-2c2d-78b6-a32c-9054bdc2671e' AND t0.approved = 1 ORDER BY t0.created DESC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.is_verified AS is_verified_6 FROM "user" t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.is_verified AS is_verified_6
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.is_verified AS is_verified_6 FROM "user" t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.file AS file_2, t0.file_thumbnail AS file_thumbnail_3, t0.file_type AS file_type_4, t0.created AS created_5, t0.expiry AS expiry_6, t0.original_filename AS original_filename_7, t0.brand AS brand_8, t0.barcode AS barcode_9, t0.approved AS approved_10, t0.category_id AS category_id_11, t0.created_by_id AS created_by_id_12 FROM media_item t0 WHERE t0.category_id = ? AND t0.approved = ? ORDER BY t0.created DESC

[
  "019b12b9-2c2d-78b6-a32c-9054bdc2671e"
  0
]

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.file_thumbnail AS file_thumbnail_3,
  t0.file_type AS file_type_4,
  t0.created AS created_5,
  t0.expiry AS expiry_6,
  t0.original_filename AS original_filename_7,
  t0.brand AS brand_8,
  t0.barcode AS barcode_9,
  t0.approved AS approved_10,
  t0.category_id AS category_id_11,
  t0.created_by_id AS created_by_id_12
FROM
  media_item t0
WHERE
  t0.category_id = ?
  AND t0.approved = ?
ORDER BY
  t0.created DESC

SELECT t0.id AS id_1, t0.file AS file_2, t0.file_thumbnail AS file_thumbnail_3, t0.file_type AS file_type_4, t0.created AS created_5, t0.expiry AS expiry_6, t0.original_filename AS original_filename_7, t0.brand AS brand_8, t0.barcode AS barcode_9, t0.approved AS approved_10, t0.category_id AS category_id_11, t0.created_by_id AS created_by_id_12 FROM media_item t0 WHERE t0.category_id = '019b12b9-2c2d-78b6-a32c-9054bdc2671e' AND t0.approved = 0 ORDER BY t0.created DESC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM media_item_tag t0 INNER JOIN media_item_tags ON t0.id = media_item_tags.media_item_tag_id WHERE media_item_tags.media_item_id = ?

[
  "019b12df-d81f-7922-a9bd-67d5bf4ff7fb"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  media_item_tag t0
  INNER JOIN media_item_tags ON t0.id = media_item_tags.media_item_tag_id
WHERE
  media_item_tags.media_item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM media_item_tag t0 INNER JOIN media_item_tags ON t0.id = media_item_tags.media_item_tag_id WHERE media_item_tags.media_item_id = '019b12df-d81f-7922-a9bd-67d5bf4ff7fb';

SELECT LOWER(m0_.brand) AS sclr_0, MIN(m0_.brand) AS sclr_1, COUNT(DISTINCT m0_.id) AS sclr_2 FROM media_item m0_ WHERE m0_.category_id = ? AND m0_.approved = true AND (m0_.brand IS NOT NULL AND m0_.brand <> '') GROUP BY sclr_0 ORDER BY sclr_1 ASC

[
  Symfony\Component\Uid\UuidV7 {#740
    __toString(): "019b12b9-2c2d-78b6-a32c-9054bdc2671e"
  }
]

SELECT
  LOWER(m0_.brand) AS sclr_0,
  MIN(m0_.brand) AS sclr_1,
  COUNT(DISTINCT m0_.id) AS sclr_2
FROM
  media_item m0_
WHERE
  m0_.category_id = ?
  AND m0_.approved = true
  AND (
    m0_.brand IS NOT NULL
    AND m0_.brand <> ''
  )
GROUP BY
  sclr_0
ORDER BY
  sclr_1 ASC

SELECT LOWER(m0_.brand) AS sclr_0, MIN(m0_.brand) AS sclr_1, COUNT(DISTINCT m0_.id) AS sclr_2 FROM media_item m0_ WHERE m0_.category_id = '019b12b9-2c2d-78b6-a32c-9054bdc2671e' AND m0_.approved = true AND (m0_.brand IS NOT NULL AND m0_.brand <> '') GROUP BY sclr_0 ORDER BY sclr_1 ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.description AS description_4, t0.created_by_id AS created_by_id_5 FROM media_category t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.description AS description_4,
  t0.created_by_id AS created_by_id_5
FROM
  media_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.description AS description_4, t0.created_by_id AS created_by_id_5 FROM media_category t0;