https://www.staging.lacabaneacoudre.fr/formation/5/capsule-edition-n%C2%B01

Query Metrics

62 Database Queries
9 Different statements
19.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.32 ms
(77.99%)
50
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.file AS file_5, t0.during AS during_6 FROM formation_capsule t0 WHERE t0.id = ?
Parameters:
[
  53
]
1.55 ms
(7.89%)
5
SELECT t0.id AS id_1, t0.list_order AS list_order_2, t0.section_id AS section_id_3, t0.capsule_id AS capsule_id_4 FROM formation_step t0 WHERE t0.section_id = ?
Parameters:
[
  9
]
0.62 ms
(3.15%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.picture AS picture_6, t0.picture_alt AS picture_alt_7, t0.price_ht AS price_ht_8, t0.tva AS tva_9, t0.is_published AS is_published_10, t0.iframe AS iframe_11, t0.level_id AS level_id_12 FROM formation t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
0.42 ms
(2.14%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.formation_id AS formation_id_3 FROM formation_section t0 WHERE t0.formation_id = ?
Parameters:
[
  5
]
0.40 ms
(2.06%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published AS published_4, t0.date_publication AS date_publication_5 FROM notification t0 WHERE t0.published = ? ORDER BY t0.date_publication DESC
Parameters:
[
  1
]
0.36 ms
(1.85%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.picture AS picture_6, t0.picture_alt AS picture_alt_7, t0.price_ht AS price_ht_8, t0.tva AS tva_9, t0.is_published AS is_published_10, t0.iframe AS iframe_11, t0.level_id AS level_id_12 FROM formation t0 INNER JOIN formation_formation ON t0.id = formation_formation.formation_target WHERE formation_formation.formation_source = ?
Parameters:
[
  5
]
0.36 ms
(1.85%)
1
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.date AS date_4, t0.formation_id AS formation_id_5, t0.client_id AS client_id_6 FROM formation_review t0 WHERE t0.formation_id = ?
Parameters:
[
  5
]
0.35 ms
(1.80%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.address AS address_4, t0.postcode AS postcode_5, t0.city AS city_6, t0.phone AS phone_7, t0.user_id AS user_id_8 FROM client t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.25 ms
(1.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3 FROM formation_level t0 WHERE t0.id = ?
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\Notification No errors.
App\Entity\User No errors.
App\Entity\Formation No errors.
App\Entity\FormationLevel No errors.
App\Entity\FormationReview No errors.
App\Entity\FormationSection No errors.
App\Entity\Client No errors.
App\Entity\FormationStep No errors.
App\Entity\FormationCapsule No errors.
App\Entity\ClientFormationState No errors.
App\Entity\Sewing No errors.
App\Entity\Order No errors.
App\Entity\ClientMessage No errors.