Query Metrics
2
Database Queries
2
Different statements
1.84 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.49 ms (81.00%) |
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:
[
"les-enigmes-daurel-le-consul"
]
|
|
0.35 ms (19.00%) |
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"
]
|
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\FrontModule | 2 |
| App\Entity\TypeFrontModule | 2 |
| App\Entity\FrontPage | 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\FrontPage | No errors. |
| App\Entity\FrontModule | No errors. |
| App\Entity\FrontColor | No errors. |
| App\Entity\TypeFrontModule | No errors. |
| App\Entity\Timeline | No errors. |