GET https://cbf-dev.cn.cnrs.fr/en/formation/21

Query Metrics

9 Database Queries
6 Different statements
5.10 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.48 ms
(28.94%)
2
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.orderNumber AS ORDERNUMBER_4 FROM header_section t0 ORDER BY t0.orderNumber ASC
Parameters:
[]
1.11 ms
(21.70%)
2
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
0.88 ms
(17.33%)
2
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id IS NULL AND t0.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
0.68 ms
(13.33%)
1
SELECT t0.id AS ID_1, t0.title AS TITLE_2, t0.titleEn AS TITLEEN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.created_at AS CREATED_AT_6, t0.verified AS VERIFIED_7, t0.image_id AS IMAGE_ID_8, t0.team_id AS TEAM_ID_9, t0.author_id AS AUTHOR_ID_10 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  21
]
0.55 ms
(10.86%)
1
SELECT t0.id AS ID_1, t0.formation_id AS FORMATION_ID_2, t0.file_id AS FILE_ID_3 FROM file_formation t0 WHERE t0.formation_id = ?
Parameters:
[
  21
]
0.40 ms
(7.84%)
1
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]

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\Formation No errors.
App\Entity\File No errors.
App\Entity\Equipe No errors.
App\UserBundle\Entity\User No errors.
App\Entity\FileFormation No errors.
App\Entity\HeaderSection
  • The mappings App\Entity\HeaderSection#pages and App\Entity\Page#section are inconsistent with each other.
App\Entity\Page
  • The association App\Entity\Page#section refers to the inverse side field App\Entity\HeaderSection#paragraphs which does not exist.
App\Entity\Paragraph No errors.