Query Metrics
24
Database Queries
21
Different statements
21.91 ms
Query time
8
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.39 ms (42.85%) |
1 |
SELECT t0.id AS id_1, t0.image_liste_name AS image_liste_name_2, t0.active AS active_3, t0.date_creation AS date_creation_4, t0.date_update AS date_update_5, t0.date_bibliostream AS date_bibliostream_6, t0.titre_fr AS titre_fr_7, t0.titre_en AS titre_en_8, t0.sous_titre_fr AS sous_titre_fr_9, t0.sous_titre_en AS sous_titre_en_10, t0.titre_original AS titre_original_11, t0.numero_de_partie_fr AS numero_de_partie_fr_12, t0.numero_de_partie_en AS numero_de_partie_en_13, t0.texte_alternatif_fr AS texte_alternatif_fr_14, t0.texte_alternatif_en AS texte_alternatif_en_15, t0.resume_fr AS resume_fr_16, t0.resume_en AS resume_en_17, t0.annee_edition AS annee_edition_18, t0.annee_production AS annee_production_19, t0.copyright AS copyright_20, t0.duree AS duree_21, t0.isbn AS isbn_22, t0.numero_editeur AS numero_editeur_23, t0.ean_telechargement AS ean_telechargement_24, t0.ean_pret AS ean_pret_25, t0.ean_cd AS ean_cd_26, t0.jeunesse_age_min AS jeunesse_age_min_27, t0.jeunesse_age_max AS jeunesse_age_max_28, t0.copyright_image AS copyright_image_29, t0.langue_sources AS langue_sources_30, t0.langue_originale AS langue_originale_31, t0.bkdo_id AS bkdo_id_32, t0.produit_appel AS produit_appel_33, t0.titre_a_la_une AS titre_a_la_une_34, t0.recommendation_narra AS recommendation_narra_35, t0.best_seller AS best_seller_36, t0.most_pre_purchased AS most_pre_purchased_37, t0.most_pre_purchased_ca AS most_pre_purchased_ca_38, t0.bool_eur AS bool_eur_39, t0.bool_cad AS bool_cad_40, t0.bool_chf AS bool_chf_41, t0.bool_usd AS bool_usd_42, t0.date_best_seller AS date_best_seller_43, t0.genre_indicatif AS genre_indicatif_44, t0.bibliostream AS bibliostream_45, t0.telechargement AS telechargement_46, t0.inapp AS inapp_47, t0.enrichissements_fr AS enrichissements_fr_48, t0.enrichissements_en AS enrichissements_en_49, t0.image_hd_name AS image_hd_name_50, t0.image_fiche_name AS image_fiche_name_51, t0.use_image_hd AS use_image_hd_52, t0.livre_d_ici AS livre_d_ici_53, t0.extrait_path AS extrait_path_54, t0.old_id_img AS old_id_img_55, t0.id_crm AS id_crm_56, t0.prix_reference AS prix_reference_57, t0.poids AS poids_58, t0.nb_audio_files AS nb_audio_files_59, t0.livrable_telechargement AS livrable_telechargement_60, t0.livrable_streaming AS livrable_streaming_61, t0.tier_indicatif AS tier_indicatif_62, t0.interprete_indicatif AS interprete_indicatif_63, t0.url_origine_presentation_fr AS url_origine_presentation_fr_64, t0.url_origine_presentation_en AS url_origine_presentation_en_65, t0.url_extrait AS url_extrait_66, t0.extrait_cdn AS extrait_cdn_67, t0.coup_de_coeur_libraire AS coup_de_coeur_libraire_68, t0.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_69, t0.video AS video_70, t0.bool_chapitre_gratuit AS bool_chapitre_gratuit_71, t0.duree_min AS duree_min_72, t0.best_seller_ca AS best_seller_ca_73, t0.numero_tome AS numero_tome_74, t0.prix_reference_ca AS prix_reference_ca_75, t0.prix_reference_usd AS prix_reference_usd_76, t0.abonnement AS abonnement_77, t0.is_abonnement_ct AS is_abonnement_ct_78, t0.cat1a AS cat1a_79, t0.cat1b AS cat1b_80, t0.cat2a AS cat2a_81, t0.cat2b AS cat2b_82, t0.cat3 AS cat3_83, t0.alias_url AS alias_url_84, t0.date_fin_precommande AS date_fin_precommande_85, t0.date_fin_precommande_ca AS date_fin_precommande_ca_86, t0.nb_tracks AS nb_tracks_87, t0.preorder AS preorder_88, t0.promotion AS promotion_89, t0.prix_vente AS prix_vente_90, t0.prix_vente_ca AS prix_vente_ca_91, t0.promotion_ca AS promotion_ca_92, t0.preorder_ca AS preorder_ca_93, t0.collection_id AS collection_id_94, t0.publics_id AS publics_id_95, t0.publics_jeunesse_id AS publics_jeunesse_id_96, t0.version_id AS version_id_97, t0.type_realisation_id AS type_realisation_id_98, t0.clil_id AS clil_id_99, t0.editor_id AS editor_id_100, t0.genre1_id AS genre1_id_101, t0.sousgenre1_id AS sousgenre1_id_102, t0.genre2_id AS genre2_id_103, t0.sousgenre2_id AS sousgenre2_id_104, t0.genre3_id AS genre3_id_105, t0.sousgenre3_id AS sousgenre3_id_106, t0.fournisseur_id AS fournisseur_id_107, t0.serie_id AS serie_id_108 FROM produit t0 WHERE t0.alias_url = ? LIMIT 1
Parameters:
[
"delivrance-les-enquetes-du-departement-v"
]
|
|
1.82 ms (8.29%) |
2 |
SELECT p0_.precommande AS precommande_0, p0_.prix_ttc AS prix_ttc_1, t1_.taux AS taux_2, p0_.date_fin AS date_fin_3, p0_.date_created AS date_created_4 FROM produit_prix p0_ INNER JOIN tva t1_ ON p0_.tva_id = t1_.id INNER JOIN produit_produit_prix p3_ ON p0_.id = p3_.produit_prix_id INNER JOIN produit p2_ ON p2_.id = p3_.produit_id INNER JOIN devise d4_ ON p0_.devise_id = d4_.id WHERE (p0_.date_fin >= ? OR p0_.date_fin IS NULL) AND p2_.id = ? AND d4_.code = ? ORDER BY p0_.date_fin DESC
Parameters:
[ "2026-07-21 16:24:16" 3411 "EUR" ] |
|
1.21 ms (5.53%) |
2 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.bkdo_id AS bkdo_id_6, t0.id_webdev AS id_webdev_7, t0.clil AS clil_8, t0.date_update AS date_update_9, t0.groupe_id AS groupe_id_10 FROM genres t0 WHERE t0.id = ?
Parameters:
[
21
]
|
|
1.16 ms (5.30%) |
2 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.bkdo_id AS bkdo_id_6, t0.id_webdev AS id_webdev_7, t0.clil AS clil_8, t0.date_update AS date_update_9, t0.bisac AS bisac_10, t0.thema AS thema_11, t0.service AS service_12, t0.genre_id AS genre_id_13 FROM sous_genres t0 WHERE t0.id = ?
Parameters:
[
14
]
|
|
0.59 ms (2.69%) |
1 |
SELECT t0.id AS id_1, t0.taux AS taux_2 FROM tva t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.58 ms (2.66%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_realisateurs ON t0.id = produits_realisateurs.tier_id WHERE produits_realisateurs.produit_id = ?
Parameters:
[
3411
]
|
|
0.55 ms (2.52%) |
1 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.date_update AS date_update_4 FROM publics t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.55 ms (2.50%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.tva AS tva_4 FROM devise t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.53 ms (2.43%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_interpretes ON t0.id = produits_interpretes.tier_id WHERE produits_interpretes.produit_id = ?
Parameters:
[
3411
]
|
|
0.51 ms (2.35%) |
1 |
SELECT t0.id AS id_1, t0.multiplicateur AS multiplicateur_2, t0.prix AS prix_3, t0.nombre_pret AS nombre_pret_4, t0.simultaneite AS simultaneite_5, t0.duree_annee AS duree_annee_6, t0.duree_pret AS duree_pret_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.tva_id AS tva_id_10, t0.devise_id AS devise_id_11 FROM produit_prix_education t0 INNER JOIN produit_prix_education_produit ON t0.id = produit_prix_education_produit.produit_prix_education_id WHERE produit_prix_education_produit.produit_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
3411
]
|
|
0.50 ms (2.28%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_traducteurs ON t0.id = produits_traducteurs.tier_id WHERE produits_traducteurs.produit_id = ?
Parameters:
[
3411
]
|
|
0.49 ms (2.24%) |
1 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.id_webdev AS id_webdev_6, t0.date_update AS date_update_7 FROM prix_litteraire t0 INNER JOIN produit_prix_litteraire ON t0.id = produit_prix_litteraire.prix_litteraire_id WHERE produit_prix_litteraire.produit_id = ?
Parameters:
[
3411
]
|
|
0.48 ms (2.17%) |
1 |
SELECT t0.id AS id_1, t0.multiplicateur AS multiplicateur_2, t0.prix AS prix_3, t0.nombre_pret AS nombre_pret_4, t0.simultaneite AS simultaneite_5, t0.duree_annee AS duree_annee_6, t0.duree_pret AS duree_pret_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.tva_id AS tva_id_10, t0.devise_id AS devise_id_11 FROM produit_prix_streaming t0 INNER JOIN produit_produit_prix_streaming ON t0.id = produit_produit_prix_streaming.produit_prix_streaming_id WHERE produit_produit_prix_streaming.produit_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
3411
]
|
|
0.47 ms (2.15%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_auteurs ON t0.id = produits_auteurs.tier_id WHERE produits_auteurs.produit_id = ?
Parameters:
[
3411
]
|
|
0.46 ms (2.10%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_illustrateurs ON t0.id = produits_illustrateurs.tier_id WHERE produits_illustrateurs.produit_id = ?
Parameters:
[
3411
]
|
|
0.46 ms (2.09%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 WHERE t0.id = ?
Parameters:
[
44
]
|
|
0.46 ms (2.09%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.patronyme AS patronyme_7, t0.pseudonyme AS pseudonyme_8, t0.isni AS isni_9, t0.nationalite AS nationalite_10, t0.description_fr AS description_fr_11, t0.description_en AS description_en_12, t0.vip AS vip_13, t0.copyright_image AS copyright_image_14, t0.image_name AS image_name_15, t0.algolia_name AS algolia_name_16, t0.bkdo_id AS bkdo_id_17, t0.old_id_image AS old_id_image_18 FROM tier t0 INNER JOIN produits_compositeurs ON t0.id = produits_compositeurs.tier_id WHERE produits_compositeurs.produit_id = ?
Parameters:
[
3411
]
|
|
0.45 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_fin AS date_fin_3, t0.prix_ttc AS prix_ttc_4, t0.precommande AS precommande_5, t0.tva_id AS tva_id_6, t0.devise_id AS devise_id_7 FROM produit_prix t0 INNER JOIN produit_produit_prix ON t0.id = produit_produit_prix.produit_prix_id WHERE produit_produit_prix.produit_id = ? ORDER BY t0.date_fin ASC
Parameters:
[
3411
]
|
|
0.43 ms (1.98%) |
1 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3 FROM type_realisation t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.42 ms (1.93%) |
1 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.id_webdev AS id_webdev_4, t0.date_update AS date_update_5 FROM theme t0 INNER JOIN produit_theme ON t0.id = produit_theme.theme_id WHERE produit_theme.produit_id = ?
Parameters:
[
3411
]
|
|
0.39 ms (1.79%) |
1 |
SELECT t0.id AS id_1, t0.libelle_fr AS libelle_fr_2, t0.libelle_en AS libelle_en_3, t0.id_webdev AS id_webdev_4, t0.onix AS onix_5, t0.date_update AS date_update_6 FROM version t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Produit |
|
| App\Entity\Collections | No errors. |
| App\Entity\Publics | No errors. |
| App\Entity\PublicsJeunesse | No errors. |
| App\Entity\Version | No errors. |
| App\Entity\TypeRealisation | No errors. |
| App\Entity\ProduitClil | No errors. |
| App\Entity\Tier | No errors. |
| App\Entity\Genres |
|
| App\Entity\SousGenres |
|
| App\Entity\Fournisseur | No errors. |
| App\Entity\Serie | No errors. |
| App\Entity\PageAccueil |
|
| App\Entity\Selection | No errors. |
| App\Entity\TransactionItems |
|
| App\Entity\ProduitAvis | No errors. |
| App\Entity\BlogArticle | No errors. |
| App\Entity\Promotion | No errors. |
| App\Entity\UserProduits | No errors. |
| App\Entity\ProduitPrix |
|
| App\Entity\ProduitPrixStreaming | No errors. |
| App\Entity\ProduitsLies |
|
| App\Entity\Bbs_OrderItems | No errors. |
| App\Entity\Bbs_CurrentReader | No errors. |
| App\Entity\UserChapitreGratuit | No errors. |
| App\Entity\UserWishlists | No errors. |
| App\Entity\UserDownloads | No errors. |
| App\Entity\CampagnePromo | No errors. |
| App\Entity\PrixLitteraire | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\ProduitHls | No errors. |
| App\Entity\ProduitPrixEducation | No errors. |
| App\Entity\DownloadToken | No errors. |
| App\Entity\GroupeGenres | No errors. |
| App\Entity\ProduitOnix | No errors. |
| App\Entity\Tva | No errors. |
| App\Entity\Devise |
|
| App\Entity\Transaction | No errors. |
| App\Entity\CarteCadeau | No errors. |
| App\Entity\ProduitPrixOnix | No errors. |