Query Metrics

7 Database Queries
7 Different statements
10.10 ms Query time
0 Invalid entities
246 Managed entities

Queries

Group similar statements

# Time Info
1 1.52 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.date_ajout AS date_ajout_4, t0.nb_page AS nb_page_5, t0.prix AS prix_6, t0.traducteur AS traducteur_7, t0.ean AS ean_8, t0.collection AS collection_9, t0.date_parution AS date_parution_10, t0.video AS video_11, t0.audio AS audio_12, t0.poche AS poche_13, t0.url_feuilletage AS url_feuilletage_14, t0.premier_roman AS premier_roman_15, t0.update_at AS update_at_16, t0.old_id AS old_id_17, t0.slug AS slug_18, t0.is_web_only AS is_web_only_19, t0.has_couv AS has_couv_20, t0.reco_text AS reco_text_21, t0.info_techis_valid AS info_techis_valid_22, t0.mediasis_valid AS mediasis_valid_23, t0.chroniqueis_valid AS chroniqueis_valid_24, t0.maquette_ftis_valid AS maquette_ftis_valid_25, t0.maquette_mediais_valid AS maquette_mediais_valid_26, t0.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_27, t0.reco_is_valid AS reco_is_valid_28, t0.maquette_reco_is_valid AS maquette_reco_is_valid_29, t0.niveau_libraire AS niveau_libraire_30, t0.jpro_video AS jpro_video_31, t0.has_thumb AS has_thumb_32, t0.image_interieur AS image_interieur_33, t0.url_interieur AS url_interieur_34, t0.genre_id AS genre_id_35, t0.type_id AS type_id_36, t0.niveau_id AS niveau_id_37, t0.distributeur_id AS distributeur_id_38, t0.ecrivain_voyageur_id AS ecrivain_voyageur_id_39, t0.jplecture_id AS jplecture_id_40, t0.j_pro_editeur_id AS j_pro_editeur_id_41, t0.categorie_id AS categorie_id_42, t0.interieur_ext_id AS interieur_ext_id_43 FROM livre t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "eglises-de-venise"
]
2 0.46 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.titre AS titre_2, f0_.code AS code_3, f0_.est_publie AS est_publie_4, f0_.est_metier AS est_metier_5, f1_.id AS id_6, f1_.titre AS titre_7, f1_.date_creation AS date_creation_8, f1_.is_permanent AS is_permanent_9, f1_.date_debut_pub AS date_debut_pub_10, f1_.date_fin_pub AS date_fin_pub_11, f1_.ordre AS ordre_12, f1_.image AS image_13, f1_.texte AS texte_14, f1_.image_position AS image_position_15, f1_.parameters AS parameters_16, f1_.couleur_fond_id AS couleur_fond_id_17, f1_.type_id AS type_id_18, f1_.front_page_id AS front_page_id_19 FROM front_page f0_ LEFT JOIN front_module f1_ ON f0_.id = f1_.front_page_id WHERE f0_.code = ? ORDER BY f1_.ordre ASC
Parameters:
[
  "chronique"
]
3 1.89 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.infois_ok AS infois_ok_3, t0.visuel_ok AS visuel_ok_4, t0.recos_ok AS recos_ok_5, t0.textes_ok AS textes_ok_6, t0.date_creation AS date_creation_7, t0.update_at AS update_at_8, t0.signature AS signature_9, t0.old_id AS old_id_10, t0.reco_selectionne AS reco_selectionne_11, t0.type AS type_12, t0.exergue AS exergue_13, t0.texte_original_id AS texte_original_id_14, t0.texte_relu_id AS texte_relu_id_15, t0.texte_final_id AS texte_final_id_16, t0.revue_id AS revue_id_17, t0.auteur_id AS auteur_id_18, t0.contact_id AS contact_id_19, t0.genre_id AS genre_id_20 FROM chronique t0 INNER JOIN chronique_livre ON t0.id = chronique_livre.chronique_id WHERE chronique_livre.livre_id = ? ORDER BY t0.type DESC, t0.id DESC
Parameters:
[
  1843
]
4 0.68 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapeau AS chapeau_3, t0.contenu AS contenu_4, t0.is_valide AS is_valide_5 FROM chronique_texte t0 WHERE t0.id = ?
Parameters:
[
  8606
]
5 0.29 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.36 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 4.91 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\FrontModule 2
App\Entity\TypeFrontModule 2
App\Entity\Livre 1
App\Entity\Distributeur 1
App\Entity\FrontPage 1
App\Entity\Chronique 1
App\Entity\ChroniqueTexte 1
App\Entity\Revue 1
App\Entity\Contact 1

Entities Mapping

Class Mapping errors
App\Entity\Livre No errors.
App\Entity\Genre No errors.
App\Entity\TypeLivre No errors.
App\Entity\NiveauLivre No errors.
App\Entity\Distributeur No errors.
App\Entity\EcrivainVoyageur No errors.
App\Entity\JourneePro No errors.
App\Entity\JProEditeur No errors.
App\Entity\Categorie No errors.
App\Entity\PhotoExtended No errors.
App\Entity\Auteur No errors.
App\Entity\ThemeLivre No errors.
App\Entity\Editeur No errors.
App\Entity\Revue No errors.
App\Entity\Avis No errors.
App\Entity\Chronique No errors.
App\Entity\MEL No errors.
App\Entity\Contact No errors.
App\Entity\Etiquette No errors.
App\Entity\Newsletter No errors.
App\Entity\InscritJP No errors.
App\Entity\User No errors.
App\Entity\Envie 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\FrontPage No errors.
App\Entity\FrontModule No errors.
App\Entity\FrontColor No errors.
App\Entity\TypeFrontModule No errors.
App\Entity\Timeline No errors.
App\Entity\ChroniqueTexte No errors.
App\Entity\TypeStructure No errors.
App\Entity\RepartitionPro No errors.
App\Entity\Page No errors.
App\Entity\EspacePro\ProPage No errors.
App\Entity\SI\CRM\MessageCom No errors.
App\Entity\AvisAuteur No errors.
App\Entity\Thematique No errors.
App\Entity\Publicite No errors.
App\Entity\DiffusionNum 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\Client No errors.
App\Entity\EspacePro\Election No errors.
App\Entity\Jeu\ParticipationPP No errors.
App\Entity\ContentBlock No errors.