Query Metrics
84
Database Queries
20
Different statements
15.87 ms
Query time
0
Invalid entities
252
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.15 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien_video_youtube AS lien_video_youtube_3, t0.lien_chaine_youtube AS lien_chaine_youtube_4, t0.europe_direct_id AS europe_direct_id_5 FROM accueil t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 2 | 0.15 ms |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.titre AS titre_2, m0_.cible AS cible_3, m0_.ordre AS ordre_4, m0_.parent AS parent_5 FROM menu_professionnel m0_ WHERE m0_.parent = ? AND m0_.id <= ? ORDER BY m0_.ordre ASC
Parameters:
[ 0 11 ] |
| 3 | 0.45 ms |
SELECT DISTINCT e0_.id AS id_0, e0_.description AS description_1, e0_.conditions AS conditions_2, e0_.visuel AS visuel_3, e0_.updated_visuel_at AS updated_visuel_at_4, e0_.credit_photographique AS credit_photographique_5, e0_.date AS date_6, e0_.date_format_texte AS date_format_texte_7, e0_.lieu AS lieu_8, e0_.adresse AS adresse_9, e0_.longitude AS longitude_10, e0_.latitude AS latitude_11, e0_.mots_cles AS mots_cles_12, e0_.inscription AS inscription_13, e0_.horaires AS horaires_14, e0_.titre AS titre_15, e0_.contenu AS contenu_16, e0_.jeune AS jeune_17, e0_.professionnel AS professionnel_18, e0_.slug AS slug_19, e0_.publie AS publie_20, e0_.created_by AS created_by_21, e0_.updated_by AS updated_by_22, e0_.created_date AS created_date_23, e0_.update_date AS update_date_24, e0_.compteur_affichage AS compteur_affichage_25, e0_.compteur_visite AS compteur_visite_26, e0_.commune_id AS commune_id_27 FROM evenement e0_ WHERE e0_.publie = ? AND e0_.date >= CURRENT_DATE AND e0_.professionnel = ? ORDER BY e0_.date ASC
Parameters:
[ 1 1 ] |
| 4 | 0.43 ms |
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.date_fin_publication AS date_fin_publication_5, a0_.a_la_une AS a_la_une_6, a0_.titre AS titre_7, a0_.contenu AS contenu_8, a0_.jeune AS jeune_9, a0_.professionnel AS professionnel_10, a0_.slug AS slug_11, a0_.publie AS publie_12, a0_.created_by AS created_by_13, a0_.updated_by AS updated_by_14, a0_.created_date AS created_date_15, a0_.update_date AS update_date_16, a0_.compteur_affichage AS compteur_affichage_17, a0_.compteur_visite AS compteur_visite_18 FROM actualite a0_ WHERE a0_.professionnel = ? AND a0_.publie = ? AND a0_.date_debut_publication <= CURRENT_DATE AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) AND a0_.a_la_une = ? ORDER BY a0_.date_debut_publication DESC
Parameters:
[ 1 1 1 ] |
| 5 | 0.20 ms |
SELECT t0.id AS id_1, t0.visuel AS visuel_2, t0.updated_visuel_at AS updated_visuel_at_3, t0.credit_photographique AS credit_photographique_4, t0.accroche AS accroche_5, t0.a_la_une AS a_la_une_6, t0.titre AS titre_7, t0.contenu AS contenu_8, t0.jeune AS jeune_9, t0.professionnel AS professionnel_10, t0.slug AS slug_11, t0.publie AS publie_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.created_date AS created_date_15, t0.update_date AS update_date_16, t0.compteur_affichage AS compteur_affichage_17, t0.compteur_visite AS compteur_visite_18 FROM article t0 WHERE t0.publie = ? AND t0.professionnel = ? ORDER BY t0.created_by DESC
Parameters:
[ 1 1 ] |
| 6 | 0.47 ms |
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.date_fin_publication AS date_fin_publication_5, a0_.a_la_une AS a_la_une_6, a0_.titre AS titre_7, a0_.contenu AS contenu_8, a0_.jeune AS jeune_9, a0_.professionnel AS professionnel_10, a0_.slug AS slug_11, a0_.publie AS publie_12, a0_.created_by AS created_by_13, a0_.updated_by AS updated_by_14, a0_.created_date AS created_date_15, a0_.update_date AS update_date_16, a0_.compteur_affichage AS compteur_affichage_17, a0_.compteur_visite AS compteur_visite_18 FROM actualite a0_ WHERE a0_.professionnel = ? AND a0_.publie = ? AND a0_.date_debut_publication <= CURRENT_DATE AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) ORDER BY a0_.date_debut_publication DESC
Parameters:
[ 1 1 ] |
| 7 | 0.20 ms |
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.accroche AS accroche_4, a0_.a_la_une AS a_la_une_5, a0_.titre AS titre_6, a0_.contenu AS contenu_7, a0_.jeune AS jeune_8, a0_.professionnel AS professionnel_9, a0_.slug AS slug_10, a0_.publie AS publie_11, a0_.created_by AS created_by_12, a0_.updated_by AS updated_by_13, a0_.created_date AS created_date_14, a0_.update_date AS update_date_15, a0_.compteur_affichage AS compteur_affichage_16, a0_.compteur_visite AS compteur_visite_17 FROM article a0_ WHERE a0_.professionnel = ? AND a0_.publie = ? ORDER BY a0_.created_date DESC
Parameters:
[ 1 1 ] |
| 8 | 0.15 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
0
]
|
| 9 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
1
]
|
| 10 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
165
]
|
| 11 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
171
]
|
| 12 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
175
]
|
| 13 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
181
]
|
| 14 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
188
]
|
| 15 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
323
]
|
| 16 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
192
]
|
| 17 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
196
]
|
| 18 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
2
]
|
| 19 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
314
]
|
| 20 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
352
]
|
| 21 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
353
]
|
| 22 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
325
]
|
| 23 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
38
]
|
| 24 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
39
]
|
| 25 | 0.10 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
3
]
|
| 26 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
40
]
|
| 27 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
41
]
|
| 28 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
42
]
|
| 29 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
5
]
|
| 30 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
70
]
|
| 31 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
71
]
|
| 32 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
7
]
|
| 33 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
43
]
|
| 34 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
44
]
|
| 35 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
306
]
|
| 36 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
258
]
|
| 37 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
6
]
|
| 38 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
48
]
|
| 39 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
246
]
|
| 40 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
330
]
|
| 41 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
4
]
|
| 42 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
236
]
|
| 43 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
242
]
|
| 44 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
10
]
|
| 45 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
54
]
|
| 46 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
55
]
|
| 47 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
56
]
|
| 48 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
8
]
|
| 49 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
57
]
|
| 50 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
58
]
|
| 51 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
59
]
|
| 52 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
313
]
|
| 53 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
9
]
|
| 54 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
220
]
|
| 55 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
221
]
|
| 56 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
11
]
|
| 57 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
230
]
|
| 58 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
265
]
|
| 59 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
252
]
|
| 60 | 0.18 ms |
SELECT DATABASE()
Parameters:
[] |
| 61 | 0.58 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"crij_infojeunes"
]
|
| 62 | 0.18 ms |
SELECT DATABASE()
Parameters:
[] |
| 63 | 0.52 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"crij_infojeunes"
]
|
| 64 | 0.19 ms |
SELECT @@character_set_database, @@collation_database
Parameters:
[] |
| 65 | 0.15 ms |
SELECT DATABASE()
Parameters:
[] |
| 66 | 1.21 ms |
SELECT c.TABLE_NAME, c.COLUMN_NAME, IF( c.DATA_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'crij_infojeunes' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.DATA_TYPE ), c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME 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_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION
Parameters:
[ "crij_infojeunes" "crij_infojeunes" "doctrine_migration_versions" ] |
| 67 | 0.17 ms |
SELECT DATABASE()
Parameters:
[] |
| 68 | 0.91 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "crij_infojeunes" "doctrine_migration_versions" ] |
| 69 | 0.17 ms |
SELECT DATABASE()
Parameters:
[] |
| 70 | 0.71 ms |
SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION
Parameters:
[ "crij_infojeunes" "crij_infojeunes" "doctrine_migration_versions" ] |
| 71 | 0.17 ms |
SELECT DATABASE()
Parameters:
[] |
| 72 | 0.25 ms |
SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX
Parameters:
[ "crij_infojeunes" "doctrine_migration_versions" ] |
| 73 | 0.15 ms |
SELECT DATABASE()
Parameters:
[] |
| 74 | 0.58 ms |
SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k 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 c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION
Parameters:
[ "crij_infojeunes" "crij_infojeunes" "doctrine_migration_versions" ] |
| 75 | 0.15 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
| 76 | 0.16 ms |
SELECT DATABASE()
Parameters:
[] |
| 77 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.lon AS lon_4, t0.lat AS lat_5, t0.departement_id AS departement_id_6 FROM commune t0 WHERE t0.id = ?
Parameters:
[
86194
]
|
| 78 | 0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.lon AS lon_4, t0.lat AS lat_5, t0.departement_id AS departement_id_6 FROM commune t0 WHERE t0.id = ?
Parameters:
[
33063
]
|
| 79 | 0.15 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.lon AS lon_4, t0.lat AS lat_5, t0.departement_id AS departement_id_6 FROM commune t0 WHERE t0.id = ?
Parameters:
[
33249
]
|
| 80 | 0.23 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.menu_jeune AS menu_jeune_4, t0.couleur AS couleur_5, t0.pictogramme AS pictogramme_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
184
]
|
| 81 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.menu_jeune AS menu_jeune_4, t0.couleur AS couleur_5, t0.pictogramme AS pictogramme_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
183
]
|
| 82 | 0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.menu_jeune AS menu_jeune_4, t0.couleur AS couleur_5, t0.pictogramme AS pictogramme_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
182
]
|
| 83 | 0.17 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.menu_jeune AS menu_jeune_4, t0.couleur AS couleur_5, t0.pictogramme AS pictogramme_6 FROM thematique t0 INNER JOIN article_thematique ON t0.id = article_thematique.thematique_id WHERE article_thematique.article_id = ?
Parameters:
[
181
]
|
| 84 | 0.17 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo AS logo_3, t0.updated_logo_at AS updated_logo_at_4, t0.lien AS lien_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_date AS created_date_8, t0.update_date AS update_date_9, t0.accueil_id AS accueil_id_10 FROM acces_rapide t0 WHERE t0.accueil_id = ?
Parameters:
[
2
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\MenuJeune | 205 |
| App\Entity\ContenuQualification\Thematique | 11 |
| App\Entity\Evenement | 8 |
| App\Entity\AccesRapide | 8 |
| App\Entity\Article | 5 |
| App\Entity\Actualite | 5 |
| App\Entity\MenuProfessionnel | 4 |
| App\Entity\Commune | 3 |
| App\Entity\ContenuQualification\Departement | 2 |
| App\Entity\Accueil | 1 |