Symfony Profiler

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

Query Metrics

Queries

Group similar statements

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.slug = ? LIMIT 1

[
  "appels-offres"
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.isEnabled AS isEnabled_5
FROM
  opportunities_categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.slug = 'appels-offres' LIMIT 1;

SELECT count(o0_.id) AS sclr_0 FROM opportunities o0_ LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id WHERE o0_.isEnabled = 1 AND o1_.id = 2

[]

SELECT
  count(o0_.id) AS sclr_0
FROM
  opportunities o0_
  LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id
WHERE
  o0_.isEnabled = 1
  AND o1_.id = 2

SELECT count(o0_.id) AS sclr_0 FROM opportunities o0_ LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id WHERE o0_.isEnabled = 1 AND o1_.id = 2;

SELECT o0_.opening_date AS opening_date_0, o0_.closing_date AS closing_date_1, o0_.structure AS structure_2, o0_.place AS place_3, o0_.submission_link AS submission_link_4, o0_.submission_btn_title AS submission_btn_title_5, o0_.id AS id_6, o0_.title AS title_7, o0_.description AS description_8, o0_.content AS content_9, o0_.slug AS slug_10, o0_.date AS date_11, o0_.createdAt AS createdAt_12, o0_.lastUpdate AS lastUpdate_13, o0_.isEnabled AS isEnabled_14, o1_.id AS id_15, o1_.label AS label_16, o1_.description AS description_17, o1_.slug AS slug_18, o1_.isEnabled AS isEnabled_19, o0_.biblio_id AS biblio_id_20, o0_.category_id AS category_id_21, o0_.type_id AS type_id_22, o0_.banner_id AS banner_id_23, o0_.sector_id AS sector_id_24, o0_.user_id AS user_id_25, o0_.updatedBy AS updatedBy_26 FROM opportunities o0_ LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id WHERE o0_.isEnabled = 1 AND o1_.id = 2 LIMIT 60

[]

SELECT
  o0_.opening_date AS opening_date_0,
  o0_.closing_date AS closing_date_1,
  o0_.structure AS structure_2,
  o0_.place AS place_3,
  o0_.submission_link AS submission_link_4,
  o0_.submission_btn_title AS submission_btn_title_5,
  o0_.id AS id_6,
  o0_.title AS title_7,
  o0_.description AS description_8,
  o0_.content AS content_9,
  o0_.slug AS slug_10,
  o0_.date AS date_11,
  o0_.createdAt AS createdAt_12,
  o0_.lastUpdate AS lastUpdate_13,
  o0_.isEnabled AS isEnabled_14,
  o1_.id AS id_15,
  o1_.label AS label_16,
  o1_.description AS description_17,
  o1_.slug AS slug_18,
  o1_.isEnabled AS isEnabled_19,
  o0_.biblio_id AS biblio_id_20,
  o0_.category_id AS category_id_21,
  o0_.type_id AS type_id_22,
  o0_.banner_id AS banner_id_23,
  o0_.sector_id AS sector_id_24,
  o0_.user_id AS user_id_25,
  o0_.updatedBy AS updatedBy_26
FROM
  opportunities o0_
  LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id
WHERE
  o0_.isEnabled = 1
  AND o1_.id = 2
LIMIT
  60

SELECT o0_.opening_date AS opening_date_0, o0_.closing_date AS closing_date_1, o0_.structure AS structure_2, o0_.place AS place_3, o0_.submission_link AS submission_link_4, o0_.submission_btn_title AS submission_btn_title_5, o0_.id AS id_6, o0_.title AS title_7, o0_.description AS description_8, o0_.content AS content_9, o0_.slug AS slug_10, o0_.date AS date_11, o0_.createdAt AS createdAt_12, o0_.lastUpdate AS lastUpdate_13, o0_.isEnabled AS isEnabled_14, o1_.id AS id_15, o1_.label AS label_16, o1_.description AS description_17, o1_.slug AS slug_18, o1_.isEnabled AS isEnabled_19, o0_.biblio_id AS biblio_id_20, o0_.category_id AS category_id_21, o0_.type_id AS type_id_22, o0_.banner_id AS banner_id_23, o0_.sector_id AS sector_id_24, o0_.user_id AS user_id_25, o0_.updatedBy AS updatedBy_26 FROM opportunities o0_ LEFT JOIN opportunities_categories o1_ ON o0_.category_id = o1_.id WHERE o0_.isEnabled = 1 AND o1_.id = 2 LIMIT 60;

SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM biblios t0 WHERE t0.id IN (?, ?, ?, ?)

[
  1
  6
  7
  8
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.isEnabled AS isEnabled_3
FROM
  biblios t0
WHERE
  t0.id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM biblios t0 WHERE t0.id IN (1, 6, 7, 8);

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.isEnabled AS isEnabled_5,
  t0.banner_id AS banner_id_6
FROM
  articles_categories t0
WHERE
  t0.isEnabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = 1;

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.isEnabled AS isEnabled_5
FROM
  opportunities_categories t0
WHERE
  t0.isEnabled = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = 1;

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0

[]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.slug AS slug_4
FROM
  resources_categories t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0;

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.isEnabled AS isEnabled_5
FROM
  videos_categories t0
WHERE
  t0.isEnabled = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = 1;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping