https://deamonerp.fr/cpi2/public/fr/base-outils?p=fr%2Fbase-outils

Query Metrics

45 Database Queries
8 Different statements
34.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.61 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_seo_fr AS titre_seo_fr_4, t0.titre_seo_en AS titre_seo_en_5, t0.texte_seo_fr AS texte_seo_fr_6, t0.texte_seo_en AS texte_seo_en_7, t0.route AS route_8, t0.url AS url_9 FROM pages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
2 9.08 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.color AS color_3, t0.ordre AS ordre_4, t0.rond AS rond_5, t0.pages_id AS pages_id_6, t0.actualites_id AS actualites_id_7, t0.jobs_id AS jobs_id_8, t0.formations_id AS formations_id_9 FROM sections t0 WHERE t0.pages_id = ?
Parameters:
[
  5
]
3 0.93 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.color AS color_3, t0.ordre AS ordre_4, t0.rond AS rond_5, t0.pages_id AS pages_id_6, t0.actualites_id AS actualites_id_7, t0.jobs_id AS jobs_id_8, t0.formations_id AS formations_id_9 FROM sections t0 WHERE t0.pages_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  5
]
4 0.22 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.auteur AS auteur_4 FROM temoignages t0
Parameters:
[]
5 0.81 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  37
]
6 1.49 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  26
]
7 0.88 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  153
]
8 0.70 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  154
]
9 0.41 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  157
]
10 0.41 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  158
]
11 0.43 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  159
]
12 0.45 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  160
]
13 0.39 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  161
]
14 0.54 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  162
]
15 0.38 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  43
]
16 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  32
]
17 0.43 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  163
]
18 0.40 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  164
]
19 0.66 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  165
]
20 1.58 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  166
]
21 0.59 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  167
]
22 0.44 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  44
]
23 0.51 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  33
]
24 0.48 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  168
]
25 0.57 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  169
]
26 0.58 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  170
]
27 0.37 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  171
]
28 0.48 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  172
]
29 0.47 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  45
]
30 0.39 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  34
]
31 0.51 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  173
]
32 0.45 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  174
]
33 0.36 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  175
]
34 0.41 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  176
]
35 0.34 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  177
]
36 0.39 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  565
]
37 0.79 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  46
]
38 0.45 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  35
]
39 0.43 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  178
]
40 0.55 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  180
]
41 0.44 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.image AS image_4, t0.texte_fr AS texte_fr_5, t0.texte_en AS texte_en_6, t0.ordre AS ordre_7, t0.contenus_id AS contenus_id_8 FROM carousels t0 WHERE t0.contenus_id = ?
Parameters:
[
  152
]
42 0.39 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  48
]
43 0.52 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  37
]
44 0.50 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  184
]
45 0.53 ms
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  609
]

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\Sections No errors.
App\Entity\Pages No errors.
App\Entity\Temoignages No errors.
App\Entity\Actualites No errors.
App\Entity\Jobs No errors.
App\Entity\Formations No errors.
App\Entity\Lignes No errors.
App\Entity\Blocs No errors.
App\Entity\Contenus No errors.
App\Entity\TypesContenus No errors.
App\Entity\Accordeons No errors.
App\Entity\Carousels No errors.