Query Metrics

9 Database Queries
7 Different statements
11.55 ms Query time
0 Invalid entities
237 Managed entities

Queries

Group similar statements

# Time Info
1 1.03 ms
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:
[
  "landing-lib"
]
2 0.22 ms
"START TRANSACTION"
Parameters:
[]
3 0.36 ms
INSERT INTO page_visited (url_base, param_spec, date, user_is_logged) VALUES (?, ?, ?, ?)
Parameters:
[
  "/je-suis-libraire"
  ""
  "2026-06-02"
  0
]
4 2.82 ms
"COMMIT"
Parameters:
[]
5 0.25 ms
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:
[]
6 0.30 ms
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
]
7 3.19 ms
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"
]
8 0.37 ms
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
]
9 3.01 ms
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"
]

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\FrontPage 1
App\Entity\Stats\PageVisited 1

Entities Mapping

Class Mapping errors
App\Entity\FrontPage No errors.
App\Entity\FrontModule No errors.
App\Entity\Stats\PageVisited No errors.
App\Entity\Genre No errors.
App\Entity\Livre No errors.
App\Entity\Chronique No errors.
App\Entity\Categorie No errors.
App\Entity\Envie No errors.
App\Entity\FrontColor No errors.
App\Entity\TypeFrontModule No errors.
App\Entity\Timeline No errors.
App\Entity\TypeLivre No errors.
App\Entity\NiveauLivre No errors.
App\Entity\Auteur No errors.
App\Entity\ThemeLivre No errors.
App\Entity\Distributeur No errors.
App\Entity\Editeur No errors.
App\Entity\Revue No errors.
App\Entity\Avis No errors.
App\Entity\MEL No errors.
App\Entity\Contact No errors.
App\Entity\Etiquette No errors.
App\Entity\Newsletter No errors.
App\Entity\EcrivainVoyageur No errors.
App\Entity\JourneePro No errors.
App\Entity\InscritJP No errors.
App\Entity\User No errors.
App\Entity\JProEditeur No errors.
App\Entity\PhotoExtended No errors.
App\Entity\EspacePro\Nomines No errors.
App\Entity\Jeu\PetitsPapiers No errors.
App\Entity\Prix\Prix No errors.
App\Entity\Prix\ParticipantPrix No errors.
App\Entity\ChroniqueTexte No errors.
App\Entity\Thematique No errors.
App\Entity\Page No errors.
App\Entity\ContentBlock No errors.
App\Entity\AvisAuteur No errors.
App\Entity\Publicite No errors.
App\Entity\DiffusionNum No errors.
App\Entity\SI\CRM\MessageCom No errors.
App\Entity\Contrat No errors.
App\Entity\Structure No errors.
App\Entity\Adresse No errors.
App\Entity\Vote No errors.
App\Entity\InscritAct No errors.
App\Entity\NewsContact No errors.
App\Entity\VieLibraire No errors.
App\Entity\SI\CRM\TypeCom No errors.
App\Entity\Meta\MetaStructure No errors.
App\Entity\EvtVote No errors.
App\Entity\NewsletterActus No errors.
App\Entity\NewsGroupe No errors.
App\Entity\EspaceNewsletterLibraire\NewsletterLibrairie No errors.
App\Entity\Filter\DestinataireFilter No errors.
App\Entity\Newsletter\NewsletterBlock No errors.
App\Entity\TypeStructure No errors.
App\Entity\RepartitionPro No errors.
App\Entity\EspacePro\ProPage No errors.
App\Entity\Client No errors.
App\Entity\EspacePro\Election No errors.
App\Entity\Jeu\ParticipationPP No errors.
App\Entity\CampagneVote No errors.
App\Entity\Carousel No errors.
App\Entity\Actus No errors.
App\Entity\GlobalContent No errors.