https://www.staging.lacabaneacoudre.fr/formations

Query Metrics

61 Database Queries
8 Different statements
63.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.introduction AS introduction_2, f0_.description AS description_3, f0_.meta_description AS meta_description_4, f0_.picture AS picture_5, f0_.picture_alt AS picture_alt_6, f0_.price_ht AS price_ht_7, f0_.tva AS tva_8, f0_.is_published AS is_published_9, f0_.iframe AS iframe_10, f0_.level_id AS level_id_11 FROM formation f0_ WHERE f0_.is_published = 1 LIMIT 6
Parameters:
[]
2 0.91 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.introduction AS introduction_2, f0_.description AS description_3, f0_.meta_description AS meta_description_4, f0_.picture AS picture_5, f0_.picture_alt AS picture_alt_6, f0_.price_ht AS price_ht_7, f0_.tva AS tva_8, f0_.is_published AS is_published_9, f0_.iframe AS iframe_10, f0_.level_id AS level_id_11 FROM formation f0_ WHERE f0_.is_published = 1
Parameters:
[]
3 0.39 ms
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
]
4 22.60 ms
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
]
5 0.78 ms
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
]
6 1.56 ms
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
]
7 1.24 ms
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
]
8 0.60 ms
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
]
9 0.54 ms
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:
[
  54
]
10 0.64 ms
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:
[
  55
]
11 0.63 ms
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:
[
  11
]
12 0.55 ms
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:
[
  6
]
13 0.53 ms
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:
[
  7
]
14 0.52 ms
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:
[
  8
]
15 0.55 ms
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:
[
  9
]
16 0.51 ms
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:
[
  10
]
17 0.85 ms
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:
[
  11
]
18 0.55 ms
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:
[
  12
]
19 0.53 ms
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:
[
  13
]
20 0.51 ms
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:
[
  14
]
21 0.52 ms
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:
[
  15
]
22 0.52 ms
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:
[
  16
]
23 0.55 ms
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:
[
  17
]
24 0.52 ms
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:
[
  18
]
25 0.54 ms
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:
[
  19
]
26 0.53 ms
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:
[
  20
]
27 0.53 ms
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:
[
  21
]
28 0.53 ms
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:
[
  22
]
29 0.84 ms
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:
[
  23
]
30 0.54 ms
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:
[
  24
]
31 0.50 ms
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:
[
  25
]
32 6.15 ms
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:
[
  12
]
33 0.53 ms
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:
[
  26
]
34 0.49 ms
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:
[
  27
]
35 0.49 ms
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:
[
  28
]
36 0.52 ms
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:
[
  29
]
37 0.55 ms
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:
[
  30
]
38 0.46 ms
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:
[
  31
]
39 0.46 ms
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:
[
  32
]
40 0.46 ms
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:
[
  33
]
41 0.49 ms
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:
[
  34
]
42 0.58 ms
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:
[
  13
]
43 0.52 ms
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:
[
  35
]
44 0.54 ms
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:
[
  36
]
45 0.50 ms
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:
[
  38
]
46 0.47 ms
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:
[
  39
]
47 0.45 ms
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:
[
  40
]
48 0.57 ms
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:
[
  41
]
49 0.55 ms
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:
[
  42
]
50 0.48 ms
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:
[
  43
]
51 0.56 ms
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:
[
  44
]
52 0.60 ms
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:
[
  45
]
53 0.50 ms
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:
[
  46
]
54 0.49 ms
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:
[
  47
]
55 0.51 ms
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:
[
  48
]
56 0.57 ms
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:
[
  49
]
57 0.55 ms
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:
[
  50
]
58 0.53 ms
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:
[
  51
]
59 0.59 ms
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:
[
  52
]
60 0.61 ms
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:
[
  14
]
61 0.50 ms
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:
[
  56
]

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.