Query Metrics

54 Database Queries
3 Different statements
7.85 ms Query time
0 Invalid entities
210 Managed entities

Queries

Group similar statements

# Time Info
1 0.18 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.date_debut_publication AS date_debut_publication_5, t0.date_fin_publication AS date_fin_publication_6, t0.a_la_une AS a_la_une_7, t0.titre AS titre_8, t0.contenu AS contenu_9, t0.jeune AS jeune_10, t0.professionnel AS professionnel_11, t0.slug AS slug_12, t0.publie AS publie_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.created_date AS created_date_16, t0.update_date AS update_date_17, t0.compteur_affichage AS compteur_affichage_18, t0.compteur_visite AS compteur_visite_19 FROM actualite t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "publications-ij-scope-un-mois-davril-sous-le-signe-de-lorientation-et-des-jobs-dete"
]
2 0.56 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
]
3 0.28 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
]
4 0.17 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
]
5 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:
[
  165
]
6 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
]
7 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
]
8 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
]
9 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
]
10 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
]
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:
[
  192
]
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:
[
  196
]
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:
[
  2
]
14 0.20 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
]
15 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:
[
  352
]
16 0.14 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
]
17 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:
[
  325
]
18 0.14 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
]
19 0.20 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
]
20 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:
[
  3
]
21 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:
[
  40
]
22 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:
[
  41
]
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:
[
  42
]
24 0.14 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
]
25 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:
[
  70
]
26 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:
[
  71
]
27 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:
[
  7
]
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:
[
  43
]
29 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:
[
  44
]
30 0.14 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
]
31 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:
[
  258
]
32 0.14 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
]
33 0.14 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
]
34 0.14 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
]
35 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:
[
  330
]
36 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:
[
  4
]
37 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:
[
  236
]
38 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:
[
  242
]
39 0.14 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
]
40 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:
[
  54
]
41 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:
[
  55
]
42 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:
[
  56
]
43 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:
[
  8
]
44 0.14 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
]
45 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:
[
  58
]
46 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:
[
  59
]
47 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:
[
  313
]
48 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:
[
  9
]
49 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:
[
  220
]
50 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:
[
  221
]
51 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:
[
  11
]
52 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:
[
  230
]
53 0.14 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
]
54 0.14 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
]

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\Actualite 5