Query Metrics
8
Database Queries
8
Different statements
3.86 ms
Query time
0
Invalid entities
23
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.19 ms (30.72%) |
1 |
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 WHERE t0.id = ?
Parameters:
[
"9255"
]
|
|
0.63 ms (16.42%) |
1 |
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:
[
9255
]
|
|
0.63 ms (16.27%) |
1 |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
8094
]
|
|
0.33 ms (8.47%) |
1 |
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 INNER JOIN chronique_livre ON t0.id = chronique_livre.livre_id WHERE chronique_livre.chronique_id = ?
Parameters:
[
9255
]
|
|
0.28 ms (7.33%) |
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:
[
5
]
|
|
0.28 ms (7.15%) |
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.27 ms (6.89%) |
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:
[
1095
]
|
|
0.26 ms (6.76%) |
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:
[
"entretien"
]
|
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\Genre | 8 |
| App\Entity\FrontModule | 2 |
| App\Entity\TypeFrontModule | 2 |
| App\Entity\Chronique | 1 |
| App\Entity\ChroniqueTexte | 1 |
| App\Entity\Revue | 1 |
| App\Entity\Auteur | 1 |
| App\Entity\Contact | 1 |
| App\Entity\FrontPage | 1 |
| App\Entity\Livre | 1 |
| App\Entity\Distributeur | 1 |
| App\Entity\Structure | 1 |
| App\Entity\User | 1 |
| App\Entity\NewsContact | 1 |