Query Metrics
8
Database Queries
6
Different statements
12.77 ms
Query time
0
Invalid entities
244
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.92 ms (77.69%) |
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ?
Parameters:
[
"front"
]
|
|
1.27 ms (9.94%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.telephone AS telephone_4, t0.code_abomarque AS code_abomarque_5, t0.commentaire AS commentaire_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.email AS email_9, t0.old_id AS old_id_10, t0.civilite AS civilite_11, t0.old_userid AS old_userid_12, t0.actif AS actif_13, t0.bio AS bio_14, t0.has_photo AS has_photo_15, t0.is_referent AS is_referent_16, t0.date_creation AS date_creation_17, t0.receive_nmardi AS receive_nmardi_18, t0.receive_nvendredi AS receive_nvendredi_19, t0.receive_ireseau AS receive_ireseau_20, t0.structure_id AS structure_id_21, t0.adresse_id AS adresse_id_22, t0.utilisateur_id AS utilisateur_id_23, t0.news_contact_id AS news_contact_id_24 FROM contact t0 WHERE t0.id = ?
Parameters:
[
"5955"
]
|
|
0.74 ms (5.79%) |
2 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.titre AS titre_4, t0.texte AS texte_5, t0.is_actif AS is_actif_6, t0.nom AS nom_7, t0.slug AS slug_8, t0.categorie AS categorie_9, t10.id AS id_11, t10.titre AS titre_12, t10.texte_explicatif AS texte_explicatif_13, t10.actif AS actif_14, t10.date AS date_15, t10.slug AS slug_16, t10.lieu AS lieu_17, t10.repartition_pro AS repartition_pro_18, t10.nb_max_peronnes AS nb_max_peronnes_19, t10.critere_inscrit AS critere_inscrit_20, t10.lib_contenu AS lib_contenu_21, t10.bib_abonnee AS bib_abonnee_22, t10.lib_dif AS lib_dif_23, t10.type_jp AS type_jp_24, t10.heure_debut AS heure_debut_25, t10.heure_fin AS heure_fin_26, t10.image_badge AS image_badge_27, t10.display_corner_editeur AS display_corner_editeur_28, t10.illustration AS illustration_29, t10.video AS video_30, t10.programme AS programme_31, t10.livret AS livret_32, t10.active_chapitrage AS active_chapitrage_33, t10.chapitrage_category AS chapitrage_category_34, t10.date_badge AS date_badge_35, t10.page_id AS page_id_36 FROM page t0 LEFT JOIN journee_pro t10 ON t10.page_id = t0.id WHERE t0.type = ? AND t0.is_actif = ?
Parameters:
[ "front_metier" 1 ] |
|
0.29 ms (2.28%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.code AS code_4, t0.est_publie AS est_publie_5, t0.est_metier AS est_metier_6 FROM front_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"libraire"
]
|
|
0.29 ms (2.27%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC
Parameters:
[] |
|
0.26 ms (2.02%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_creation AS date_creation_3, t0.is_permanent AS is_permanent_4, t0.date_debut_pub AS date_debut_pub_5, t0.date_fin_pub AS date_fin_pub_6, t0.ordre AS ordre_7, t0.image AS image_8, t0.texte AS texte_9, t0.image_position AS image_position_10, t0.parameters AS parameters_11, t0.couleur_fond_id AS couleur_fond_id_12, t0.type_id AS type_id_13, t0.front_page_id AS front_page_id_14 FROM front_module t0 WHERE t0.front_page_id = ? ORDER BY t0.ordre ASC
Parameters:
[
7
]
|
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\Page | 227 |
| App\Entity\Genre | 8 |
| App\Entity\FrontModule | 2 |
| App\Entity\TypeFrontModule | 2 |
| App\Entity\Contact | 1 |
| App\Entity\Structure | 1 |
| App\Entity\User | 1 |
| App\Entity\NewsContact | 1 |
| App\Entity\FrontPage | 1 |