Query Metrics

7 Database Queries
7 Different statements
8.46 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.81 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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "decrets"
]
2 0.98 ms
SELECT count(r0_.id) AS sclr_0 FROM resources r0_ LEFT JOIN resources_categories r1_ ON r0_.category_id = r1_.id WHERE r0_.isEnabled = 1 AND r1_.id = 1 ORDER BY r0_.date DESC, r0_.date DESC
Parameters:
[]
3 0.91 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.isEnabled AS isEnabled_3, r0_.createdAt AS createdAt_4, r0_.date AS date_5, r0_.document_id AS document_id_6, r0_.cover_id AS cover_id_7, r0_.category_id AS category_id_8, r0_.createdBy AS createdBy_9, r0_.updatedBy AS updatedBy_10 FROM resources r0_ LEFT JOIN resources_categories r1_ ON r0_.category_id = r1_.id WHERE r0_.isEnabled = 1 AND r1_.id = 1 ORDER BY r0_.date DESC, r0_.date DESC LIMIT 50
Parameters:
[]
4 1.08 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
]
5 0.90 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
]
6 0.93 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:
[]
7 0.85 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\ResourcesCategories No errors.
App\Entity\Resources No errors.
App\Entity\OSFile No errors.
App\Entity\File No errors.
App\Entity\Picture No errors.
App\Entity\Users No errors.
App\Entity\Formations No errors.
App\Entity\Albums No errors.
App\Entity\FormationsThematics No errors.
App\Entity\Registrations No errors.
App\Entity\FormationsSessions No errors.
App\Entity\StructuresCategories No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\Articles No errors.