Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation 12
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

Queries

Group similar statements

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.free AS free_5, t0.price AS price_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM `catalogue_option` t0 WHERE t0.free = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.free AS free_5,
  t0.price AS price_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.deleted_by_id AS deleted_by_id_14
FROM
  `catalogue_option` t0
WHERE
  t0.free = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.free AS free_5, t0.price AS price_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM `catalogue_option` t0 WHERE t0.free = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.free AS free_5, t0.price AS price_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM `catalogue_option` t0 WHERE t0.free = ?

[
  0
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.free AS free_5,
  t0.price AS price_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted AS deleted_10,
  t0.deleted_at AS deleted_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.deleted_by_id AS deleted_by_id_14
FROM
  `catalogue_option` t0
WHERE
  t0.free = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.free AS free_5, t0.price AS price_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM `catalogue_option` t0 WHERE t0.free = 0;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.description AS description_3, c0_.free AS free_4, c0_.price AS price_5, c0_.active AS active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.deleted AS deleted_9, c0_.deleted_at AS deleted_at_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.deleted_by_id AS deleted_by_id_13 FROM `catalogue_option` c0_ WHERE c0_.deleted = ? AND c0_.free = ? ORDER BY c0_.id ASC

[
  0
  0
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.description AS description_3,
  c0_.free AS free_4,
  c0_.price AS price_5,
  c0_.active AS active_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c0_.deleted AS deleted_9,
  c0_.deleted_at AS deleted_at_10,
  c0_.created_by_id AS created_by_id_11,
  c0_.updated_by_id AS updated_by_id_12,
  c0_.deleted_by_id AS deleted_by_id_13
FROM
  `catalogue_option` c0_
WHERE
  c0_.deleted = ?
  AND c0_.free = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.description AS description_3, c0_.free AS free_4, c0_.price AS price_5, c0_.active AS active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.deleted AS deleted_9, c0_.deleted_at AS deleted_at_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.deleted_by_id AS deleted_by_id_13 FROM `catalogue_option` c0_ WHERE c0_.deleted = 0 AND c0_.free = 0 ORDER BY c0_.id ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.phase AS phase_3, c0_.price AS price_4, c0_.price_favored AS price_favored_5, c0_.reservation AS reservation_6, c0_.reservation_favored AS reservation_favored_7, c0_.active AS active_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted AS deleted_11, c0_.deleted_at AS deleted_at_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.deleted_by_id AS deleted_by_id_15 FROM `catalogue_product` c0_ LEFT JOIN `order` o1_ ON c0_.id = o1_.product_id WHERE c0_.deleted = ? AND c0_.active = ? AND (o1_.status IS NULL OR o1_.status IN (?, ?)) ORDER BY c0_.id ASC

[
  0
  1
  "CANCELLED"
  "NEW"
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.phase AS phase_3,
  c0_.price AS price_4,
  c0_.price_favored AS price_favored_5,
  c0_.reservation AS reservation_6,
  c0_.reservation_favored AS reservation_favored_7,
  c0_.active AS active_8,
  c0_.created_at AS created_at_9,
  c0_.updated_at AS updated_at_10,
  c0_.deleted AS deleted_11,
  c0_.deleted_at AS deleted_at_12,
  c0_.created_by_id AS created_by_id_13,
  c0_.updated_by_id AS updated_by_id_14,
  c0_.deleted_by_id AS deleted_by_id_15
FROM
  `catalogue_product` c0_
  LEFT JOIN `order` o1_ ON c0_.id = o1_.product_id
WHERE
  c0_.deleted = ?
  AND c0_.active = ?
  AND (
    o1_.status IS NULL
    OR o1_.status IN (?, ?)
  )
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.phase AS phase_3, c0_.price AS price_4, c0_.price_favored AS price_favored_5, c0_.reservation AS reservation_6, c0_.reservation_favored AS reservation_favored_7, c0_.active AS active_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted AS deleted_11, c0_.deleted_at AS deleted_at_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.deleted_by_id AS deleted_by_id_15 FROM `catalogue_product` c0_ LEFT JOIN `order` o1_ ON c0_.id = o1_.product_id WHERE c0_.deleted = 0 AND c0_.active = 1 AND (o1_.status IS NULL OR o1_.status IN ('CANCELLED', 'NEW')) ORDER BY c0_.id ASC;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping