Query Metrics
5
Database Queries
5
Different statements
2.63 ms
Query time
0
Invalid entities
22
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.29 ms (49.14%) |
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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pom"
]
|
|
0.60 ms (22.71%) |
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:
[
14076
]
|
|
0.30 ms (11.33%) |
1 |
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"
]
|
|
0.23 ms (8.68%) |
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.21 ms (8.14%) |
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 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:
[
15650
]
|
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\ChroniqueTexte | 3 |
| App\Entity\FrontModule | 2 |
| App\Entity\TypeFrontModule | 2 |
| App\Entity\Livre | 1 |
| App\Entity\NiveauLivre | 1 |
| App\Entity\Distributeur | 1 |
| App\Entity\FrontPage | 1 |
| App\Entity\Chronique | 1 |
| App\Entity\Revue | 1 |
| App\Entity\Contact | 1 |