Query Metrics
42
Database Queries
20
Different statements
12.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"presentation-pole-enseignement-superieur"
]
|
| 2 | 0.53 ms |
SELECT b.titre_bloc_diaporama, ba.titre_bloc_accordeon, c.titre_bloc_colonne, cp.bloc_accordeon_id, cp.bloc_diaporama_id, cp.bloc_video_id, bvideo.titre_bloc_video, cp.colonne_id_id, cp.text_image_id_id, ti.titre_bloc_text_image FROM page p LEFT JOIN position cp ON p.id = cp.page_id_id LEFT JOIN bloc_colonne c ON cp.colonne_id_id = c.id LEFT JOIN bloc_text_image ti ON ti.id = cp.text_image_id_id LEFT JOIN bloc_diaporama b ON b.id = cp.bloc_diaporama_id LEFT JOIN bloc_accordeon ba ON ba.id = cp.bloc_accordeon_id LEFT JOIN bloc_video bvideo ON bvideo.id = cp.bloc_video_id WHERE cp.page_id_id = :page ORDER BY cp.position
Parameters:
[ "page" => 4 ] |
| 3 | 0.24 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 69 ] |
| 4 | 0.26 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
69
]
|
| 5 | 0.24 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 70 ] |
| 6 | 0.18 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
70
]
|
| 7 | 0.18 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 71 ] |
| 8 | 0.24 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
71
]
|
| 9 | 0.28 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 73 ] |
| 10 | 0.22 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
73
]
|
| 11 | 0.18 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 125 ] |
| 12 | 0.16 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
125
]
|
| 13 | 0.18 ms |
SELECT * FROM bloc_text_image c INNER JOIN media ON c.media_id = media.id WHERE c.id = :id ORDER BY c.id
Parameters:
[ "id" => 160 ] |
| 14 | 0.16 ms |
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
160
]
|
| 15 | 0.32 ms |
SELECT * FROM page as p INNER JOIN seo_parent as sp ON p.seo_parent_id = sp.id INNER JOIN seo as s ON s.id = sp.seo_id WHERE p.id = :id
Parameters:
[ "id" => 4 ] |
| 16 | 0.31 ms |
SELECT * FROM options WHERE name IN ("metaTitre", "metaDescription", "metaKeywords")
Parameters:
[] |
| 17 | 0.19 ms |
SELECT DATABASE()
Parameters:
[] |
| 18 | 0.63 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"isaacetoil_dev"
]
|
| 19 | 0.12 ms |
SELECT DATABASE()
Parameters:
[] |
| 20 | 0.52 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"isaacetoil_dev"
]
|
| 21 | 0.14 ms |
SELECT DATABASE()
Parameters:
[] |
| 22 | 0.58 ms |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "isaacetoil_dev" "doctrine_migration_versions" ] |
| 23 | 0.11 ms |
SELECT DATABASE()
Parameters:
[] |
| 24 | 0.94 ms |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'isaacetoil_dev' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "isaacetoil_dev" "doctrine_migration_versions" ] |
| 25 | 1.29 ms |
SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "isaacetoil_dev" "isaacetoil_dev" "doctrine_migration_versions" ] |
| 26 | 0.22 ms |
SELECT DATABASE()
Parameters:
[] |
| 27 | 0.33 ms |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "isaacetoil_dev" "doctrine_migration_versions" ] |
| 28 | 0.33 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
| 29 | 0.17 ms |
SELECT DATABASE()
Parameters:
[] |
| 30 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 31 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM options t0 WHERE t0.name IN (?, ?)
Parameters:
[ "information" "informationIsCritique" ] |
| 32 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0
Parameters:
[] |
| 33 | 0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 34 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.name IS NULL LIMIT 1
Parameters:
[] |
| 35 | 0.20 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.id = ?
Parameters:
[
"presentation-pole-enseignement-superieur"
]
|
| 36 | 0.18 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"presentation-pole-enseignement-superieur"
]
|
| 37 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
94
]
|
| 38 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
90
]
|
| 39 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
93
]
|
| 40 | 0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
97
]
|
| 41 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
96
]
|
| 42 | 0.72 ms |
SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_
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\EntityBase | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Pole | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Seo\SeoParent | No errors. |
| App\Entity\BlocTextImage | No errors. |
| App\Entity\BlocAccordeon | No errors. |
| App\Entity\BlocDiaporama | No errors. |
| App\Entity\BlocColonne | No errors. |
| App\Entity\Position | No errors. |
| App\Entity\PositionBlocsFormation | No errors. |
| App\Entity\PositionBlocsActualite | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\Agenda | No errors. |
| App\Entity\User | No errors. |
| App\Entity\OffreEmploi | No errors. |
| App\Entity\Seo\Seo | No errors. |
| App\Entity\BlocAccordeonItem | No errors. |
| App\Entity\BlocDiaporamaItem | No errors. |
| App\Entity\BlocColonneItem | No errors. |
| App\Entity\BlocVideo | No errors. |
| App\Entity\Options | No errors. |
| App\Entity\Domaines | No errors. |
| App\Entity\Diplomes | No errors. |
| App\Entity\Contrats | No errors. |
| App\Entity\Duree | No errors. |
| App\Entity\DiaporamaFormation | No errors. |
| App\Entity\CategorieActu | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\TypeEmploi | No errors. |
| App\Entity\DiaporamaFormationItem | No errors. |