Symfony Profiler

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

Query Metrics

Queries

Group similar statements

SELECT count(DISTINCT (a0_.id)) AS sclr_0 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.date <= '2025-05-09 08:07:54' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC

[]

SELECT
  count(
    DISTINCT (a0_.id)
  ) AS sclr_0
FROM
  articles a0_
  LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id
  LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id
  LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id
  LEFT JOIN albums a4_ ON a0_.album_id = a4_.id
  LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id
WHERE
  a0_.date <= '2025-05-09 08:07:54'
  AND a0_.isEnabled = 1
ORDER BY
  a0_.date DESC

SELECT count(DISTINCT (a0_.id)) AS sclr_0 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.date <= '2025-05-09 08:07:54' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC;

SELECT a0_.isOnFrontPage AS isOnFrontPage_0, a0_.isVisible AS isVisible_1, a0_.isDeleted AS isDeleted_2, a0_.youtube AS youtube_3, a0_.flickr AS flickr_4, a0_.URL AS URL_5, a0_.soundcloud AS soundcloud_6, a0_.hasGeneratedPdf AS hasGeneratedPdf_7, a0_.id AS id_8, a0_.title AS title_9, a0_.description AS description_10, a0_.content AS content_11, a0_.slug AS slug_12, a0_.date AS date_13, a0_.createdAt AS createdAt_14, a0_.lastUpdate AS lastUpdate_15, a0_.isEnabled AS isEnabled_16, a0_.category_id AS category_id_17, a0_.type_id AS type_id_18, a0_.album_id AS album_id_19, a0_.biblio_id AS biblio_id_20, a0_.qrcode_id AS qrcode_id_21, a0_.generated_pdf_id AS generated_pdf_id_22, a0_.banner_id AS banner_id_23, a0_.sector_id AS sector_id_24, a0_.user_id AS user_id_25, a0_.updatedBy AS updatedBy_26 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.date <= '2025-05-09 08:07:54' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC LIMIT 30

[]

SELECT
  a0_.isOnFrontPage AS isOnFrontPage_0,
  a0_.isVisible AS isVisible_1,
  a0_.isDeleted AS isDeleted_2,
  a0_.youtube AS youtube_3,
  a0_.flickr AS flickr_4,
  a0_.URL AS URL_5,
  a0_.soundcloud AS soundcloud_6,
  a0_.hasGeneratedPdf AS hasGeneratedPdf_7,
  a0_.id AS id_8,
  a0_.title AS title_9,
  a0_.description AS description_10,
  a0_.content AS content_11,
  a0_.slug AS slug_12,
  a0_.date AS date_13,
  a0_.createdAt AS createdAt_14,
  a0_.lastUpdate AS lastUpdate_15,
  a0_.isEnabled AS isEnabled_16,
  a0_.category_id AS category_id_17,
  a0_.type_id AS type_id_18,
  a0_.album_id AS album_id_19,
  a0_.biblio_id AS biblio_id_20,
  a0_.qrcode_id AS qrcode_id_21,
  a0_.generated_pdf_id AS generated_pdf_id_22,
  a0_.banner_id AS banner_id_23,
  a0_.sector_id AS sector_id_24,
  a0_.user_id AS user_id_25,
  a0_.updatedBy AS updatedBy_26
FROM
  articles a0_
  LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id
  LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id
  LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id
  LEFT JOIN albums a4_ ON a0_.album_id = a4_.id
  LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id
WHERE
  a0_.date <= '2025-05-09 08:07:54'
  AND a0_.isEnabled = 1
ORDER BY
  a0_.date DESC
LIMIT
  30

SELECT a0_.isOnFrontPage AS isOnFrontPage_0, a0_.isVisible AS isVisible_1, a0_.isDeleted AS isDeleted_2, a0_.youtube AS youtube_3, a0_.flickr AS flickr_4, a0_.URL AS URL_5, a0_.soundcloud AS soundcloud_6, a0_.hasGeneratedPdf AS hasGeneratedPdf_7, a0_.id AS id_8, a0_.title AS title_9, a0_.description AS description_10, a0_.content AS content_11, a0_.slug AS slug_12, a0_.date AS date_13, a0_.createdAt AS createdAt_14, a0_.lastUpdate AS lastUpdate_15, a0_.isEnabled AS isEnabled_16, a0_.category_id AS category_id_17, a0_.type_id AS type_id_18, a0_.album_id AS album_id_19, a0_.biblio_id AS biblio_id_20, a0_.qrcode_id AS qrcode_id_21, a0_.generated_pdf_id AS generated_pdf_id_22, a0_.banner_id AS banner_id_23, a0_.sector_id AS sector_id_24, a0_.user_id AS user_id_25, a0_.updatedBy AS updatedBy_26 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.date <= '2025-05-09 08:07:54' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC LIMIT 30;

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.id IN (?)

[
  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.id IN (?)

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.id IN (1);

SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?)

[
  28
  18
  19
  14
  20
  21
  4
  2
]

SELECT
  t0.target AS target_1,
  t0.thumbnailDir AS thumbnailDir_2,
  t0.hasThumbnail AS hasThumbnail_3,
  t0.id AS id_4,
  t0.pages AS pages_5,
  t0.downloads AS downloads_6,
  t0.reading AS reading_7,
  t0.name AS name_8,
  t0.dir AS dir_9,
  t0.source AS source_10,
  t0.size AS size_11,
  t0.is_enabled AS is_enabled_12,
  t0.is_deleted AS is_deleted_13,
  t0.last_update AS last_update_14,
  t0.created_at AS created_at_15,
  t0.formatSize AS formatSize_16,
  t0.mimetype AS mimetype_17
FROM
  picture t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id IN (28, 18, 19, 14, 20, 21, 4, 2);

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