Query Metrics

9 Database Queries
9 Different statements
68.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.84 ms
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-04-03 05:37:56' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC
Parameters:
[]
2 2.52 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.content AS content_3, a0_.slug AS slug_4, a0_.createdAt AS createdAt_5, a0_.lastUpdate AS lastUpdate_6, a0_.date AS date_7, a0_.isEnabled AS isEnabled_8, a0_.isOnFrontPage AS isOnFrontPage_9, a0_.isVisible AS isVisible_10, a0_.isDeleted AS isDeleted_11, a0_.youtube AS youtube_12, a0_.flickr AS flickr_13, a0_.URL AS URL_14, a0_.soundcloud AS soundcloud_15, a0_.updatedBy AS updatedBy_16, a0_.banner_id AS banner_id_17, a0_.category_id AS category_id_18, a0_.type_id AS type_id_19, a0_.user_id AS user_id_20, a0_.album_id AS album_id_21, a0_.biblio_id AS biblio_id_22 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-04-03 05:37:56' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC LIMIT 30
Parameters:
[]
3 56.66 ms
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 (?)
Parameters:
[
  [
    83
    78
    2
    6
    10
    27
    41
    44
  ]
]
4 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0 WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
5 0.90 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM albums t0 WHERE t0.id IN (?)
Parameters:
[
  [
    12
    11
    2
    3
    5
    8
  ]
]
6 1.70 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
7 1.00 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_enabled AS is_enabled_5 FROM StructuresCategories t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
8 1.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0
Parameters:
[]
9 0.87 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Articles No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\ArticlesTypes No errors.
App\Entity\Albums No errors.
App\Entity\Biblios No errors.
App\Entity\Users No errors.
App\Entity\Tags No errors.
App\Entity\Formations No errors.
App\Entity\FormationsThematics No errors.
App\Entity\Registrations No errors.
App\Entity\FormationsSessions No errors.
App\Entity\StructuresCategories No errors.
App\Entity\ResourcesCategories No errors.
App\Entity\Resources No errors.