Query Metrics

6 Database Queries
6 Different statements
15.20 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 11.40 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.abbreviation AS abbreviation_4, t0.director AS director_5, t0.address AS address_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.map AS map_10, t0.description AS description_11, t0.content AS content_12, t0.date AS date_13, t0.isEnabled AS isEnabled_14, t0.slug AS slug_15, t0.logo_id AS logo_id_16, t0.director_picture_id AS director_picture_id_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.category_id AS category_id_20, t21.id AS id_22, t21.label AS label_23, t21.description AS description_24, t21.slug AS slug_25, t21.is_enabled AS is_enabled_26, t0.sector_id AS sector_id_27 FROM Structures t0 LEFT JOIN StructuresCategories t21 ON t0.category_id = t21.id WHERE t0.isEnabled = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
2 0.52 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 = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
3 0.99 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
]
4 0.73 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
]
5 1.02 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:
[]
6 0.54 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\StructuresCategories No errors.
App\Entity\Structures
  • The association App\Entity\Structures#projects refers to the owning side field App\Entity\Projects#structure which does not exist.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\Users No errors.
App\Entity\Sectors
  • The association App\Entity\Sectors#articles refers to the owning side field App\Entity\Articles#sector which does not exist.
  • The association App\Entity\Sectors#resources refers to the owning side field App\Entity\Resources#sector which does not exist.
  • The association App\Entity\Sectors#projects refers to the owning side field App\Entity\Projects#sector which does not exist.
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\ArticlesCategories No errors.
App\Entity\Articles No errors.
App\Entity\ResourcesCategories No errors.
App\Entity\Resources No errors.