Query Metrics
85
Database Queries
21
Different statements
24.61 ms
Query time
0
Invalid entities
460
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.83 ms (27.75%) |
52 |
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
]
|
|
3.37 ms (13.69%) |
1 |
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_.jeune = ? AND a0_.publie = ? ORDER BY a0_.created_date DESC
Parameters:
[ 1 1 ] |
|
2.14 ms (8.70%) |
8 |
SELECT DATABASE()
Parameters:
[] |
|
1.92 ms (7.82%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"crij_infojeunes"
]
|
|
1.66 ms (6.75%) |
1 |
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" ] |
|
1.31 ms (5.31%) |
1 |
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_.jeune = ? 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 ] |
|
0.93 ms (3.78%) |
1 |
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_.jeune = ? ORDER BY e0_.date ASC
Parameters:
[ 1 1 ] |
|
0.90 ms (3.67%) |
1 |
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" ] |
|
0.88 ms (3.56%) |
1 |
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_.jeune = ? 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 ] |
|
0.80 ms (3.26%) |
1 |
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" ] |
|
0.76 ms (3.07%) |
4 |
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
]
|
|
0.60 ms (2.45%) |
3 |
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:
[
291
]
|
|
0.59 ms (2.38%) |
1 |
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" ] |
|
0.36 ms (1.46%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.27 ms (1.09%) |
1 |
SELECT @@character_set_database, @@collation_database
Parameters:
[] |
|
0.27 ms (1.08%) |
1 |
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_jeune m0_ WHERE m0_.parent = ? AND m0_.id <= ? ORDER BY m0_.ordre ASC
Parameters:
[ 0 11 ] |
|
0.26 ms (1.05%) |
1 |
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_.jeune = ? AND a0_.a_la_une = ? AND a0_.publie = ? ORDER BY a0_.created_date DESC
Parameters:
[ 1 1 1 ] |
|
0.22 ms (0.89%) |
1 |
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" ] |
|
0.20 ms (0.80%) |
1 |
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:
[
1
]
|
|
0.19 ms (0.79%) |
1 |
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
Parameters:
[] |
|
0.16 ms (0.64%) |
1 |
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:
[
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\MenuJeune | 205 |
| App\Entity\Article | 204 |
| App\Entity\Evenement | 13 |
| App\Entity\ContenuQualification\Thematique | 11 |
| App\Entity\Actualite | 11 |
| App\Entity\AccesRapide | 8 |
| App\Entity\Commune | 4 |
| App\Entity\ContenuQualification\Departement | 3 |
| App\Entity\Accueil | 1 |