Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

80.11 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
80.11 ms (100.00%)	1	SELECT p0_.id AS id_0, p0_.image_liste_name AS image_liste_name_1, p0_.active AS active_2, p0_.date_creation AS date_creation_3, p0_.date_update AS date_update_4, p0_.date_bibliostream AS date_bibliostream_5, p0_.titre_fr AS titre_fr_6, p0_.titre_en AS titre_en_7, p0_.sous_titre_fr AS sous_titre_fr_8, p0_.sous_titre_en AS sous_titre_en_9, p0_.titre_original AS titre_original_10, p0_.numero_de_partie_fr AS numero_de_partie_fr_11, p0_.numero_de_partie_en AS numero_de_partie_en_12, p0_.texte_alternatif_fr AS texte_alternatif_fr_13, p0_.texte_alternatif_en AS texte_alternatif_en_14, p0_.resume_fr AS resume_fr_15, p0_.resume_en AS resume_en_16, p0_.annee_edition AS annee_edition_17, p0_.annee_production AS annee_production_18, p0_.copyright AS copyright_19, p0_.duree AS duree_20, p0_.isbn AS isbn_21, p0_.numero_editeur AS numero_editeur_22, p0_.ean_telechargement AS ean_telechargement_23, p0_.ean_pret AS ean_pret_24, p0_.ean_cd AS ean_cd_25, p0_.jeunesse_age_min AS jeunesse_age_min_26, p0_.jeunesse_age_max AS jeunesse_age_max_27, p0_.copyright_image AS copyright_image_28, p0_.langue_sources AS langue_sources_29, p0_.langue_originale AS langue_originale_30, p0_.bkdo_id AS bkdo_id_31, p0_.produit_appel AS produit_appel_32, p0_.titre_a_la_une AS titre_a_la_une_33, p0_.recommendation_narra AS recommendation_narra_34, p0_.best_seller AS best_seller_35, p0_.most_pre_purchased AS most_pre_purchased_36, p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37, p0_.bool_eur AS bool_eur_38, p0_.bool_cad AS bool_cad_39, p0_.bool_chf AS bool_chf_40, p0_.bool_usd AS bool_usd_41, p0_.date_best_seller AS date_best_seller_42, p0_.genre_indicatif AS genre_indicatif_43, p0_.bibliostream AS bibliostream_44, p0_.telechargement AS telechargement_45, p0_.inapp AS inapp_46, p0_.enrichissements_fr AS enrichissements_fr_47, p0_.enrichissements_en AS enrichissements_en_48, p0_.image_hd_name AS image_hd_name_49, p0_.image_fiche_name AS image_fiche_name_50, p0_.use_image_hd AS use_image_hd_51, p0_.livre_d_ici AS livre_d_ici_52, p0_.extrait_path AS extrait_path_53, p0_.old_id_img AS old_id_img_54, p0_.id_crm AS id_crm_55, p0_.prix_reference AS prix_reference_56, p0_.poids AS poids_57, p0_.nb_audio_files AS nb_audio_files_58, p0_.livrable_telechargement AS livrable_telechargement_59, p0_.livrable_streaming AS livrable_streaming_60, p0_.tier_indicatif AS tier_indicatif_61, p0_.interprete_indicatif AS interprete_indicatif_62, p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63, p0_.url_origine_presentation_en AS url_origine_presentation_en_64, p0_.url_extrait AS url_extrait_65, p0_.extrait_cdn AS extrait_cdn_66, p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67, p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68, p0_.video AS video_69, p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70, p0_.duree_min AS duree_min_71, p0_.best_seller_ca AS best_seller_ca_72, p0_.numero_tome AS numero_tome_73, p0_.prix_reference_ca AS prix_reference_ca_74, p0_.prix_reference_usd AS prix_reference_usd_75, p0_.abonnement AS abonnement_76, p0_.is_abonnement_ct AS is_abonnement_ct_77, p0_.cat1a AS cat1a_78, p0_.cat1b AS cat1b_79, p0_.cat2a AS cat2a_80, p0_.cat2b AS cat2b_81, p0_.cat3 AS cat3_82, p0_.alias_url AS alias_url_83, p0_.date_fin_precommande AS date_fin_precommande_84, p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85, p0_.nb_tracks AS nb_tracks_86, p0_.preorder AS preorder_87, p0_.promotion AS promotion_88, p0_.prix_vente AS prix_vente_89, p0_.prix_vente_ca AS prix_vente_ca_90, p0_.promotion_ca AS promotion_ca_91, p0_.preorder_ca AS preorder_ca_92, p0_.collection_id AS collection_id_93, p0_.publics_id AS publics_id_94, p0_.publics_jeunesse_id AS publics_jeunesse_id_95, p0_.version_id AS version_id_96, p0_.type_realisation_id AS type_realisation_id_97, p0_.clil_id AS clil_id_98, p0_.editor_id AS editor_id_99, p0_.genre1_id AS genre1_id_100, p0_.sousgenre1_id AS sousgenre1_id_101, p0_.genre2_id AS genre2_id_102, p0_.sousgenre2_id AS sousgenre2_id_103, p0_.genre3_id AS genre3_id_104, p0_.sousgenre3_id AS sousgenre3_id_105, p0_.fournisseur_id AS fournisseur_id_106, p0_.serie_id AS serie_id_107 FROM produit p0_ LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id WHERE p0_.active = 1 AND t1_.algolia_name = ? AND p0_.bool_eur = 1 ORDER BY p0_.date_creation DESC LIMIT 1000 Parameters: [`"douglas-kennedy"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image_liste_name AS image_liste_name_1, p0_.active AS active_2, p0_.date_creation AS date_creation_3, p0_.date_update AS date_update_4, p0_.date_bibliostream AS date_bibliostream_5, p0_.titre_fr AS titre_fr_6, p0_.titre_en AS titre_en_7, p0_.sous_titre_fr AS sous_titre_fr_8, p0_.sous_titre_en AS sous_titre_en_9, p0_.titre_original AS titre_original_10, p0_.numero_de_partie_fr AS numero_de_partie_fr_11, p0_.numero_de_partie_en AS numero_de_partie_en_12, p0_.texte_alternatif_fr AS texte_alternatif_fr_13, p0_.texte_alternatif_en AS texte_alternatif_en_14, p0_.resume_fr AS resume_fr_15, p0_.resume_en AS resume_en_16, p0_.annee_edition AS annee_edition_17, p0_.annee_production AS annee_production_18, p0_.copyright AS copyright_19, p0_.duree AS duree_20, p0_.isbn AS isbn_21, p0_.numero_editeur AS numero_editeur_22, p0_.ean_telechargement AS ean_telechargement_23, p0_.ean_pret AS ean_pret_24, p0_.ean_cd AS ean_cd_25, p0_.jeunesse_age_min AS jeunesse_age_min_26, p0_.jeunesse_age_max AS jeunesse_age_max_27, p0_.copyright_image AS copyright_image_28, p0_.langue_sources AS langue_sources_29, p0_.langue_originale AS langue_originale_30, p0_.bkdo_id AS bkdo_id_31, p0_.produit_appel AS produit_appel_32, p0_.titre_a_la_une AS titre_a_la_une_33, p0_.recommendation_narra AS recommendation_narra_34, p0_.best_seller AS best_seller_35, p0_.most_pre_purchased AS most_pre_purchased_36, p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37, p0_.bool_eur AS bool_eur_38, p0_.bool_cad AS bool_cad_39, p0_.bool_chf AS bool_chf_40, p0_.bool_usd AS bool_usd_41, p0_.date_best_seller AS date_best_seller_42, p0_.genre_indicatif AS genre_indicatif_43, p0_.bibliostream AS bibliostream_44, p0_.telechargement AS telechargement_45, p0_.inapp AS inapp_46, p0_.enrichissements_fr AS enrichissements_fr_47, p0_.enrichissements_en AS enrichissements_en_48, p0_.image_hd_name AS image_hd_name_49, p0_.image_fiche_name AS image_fiche_name_50, p0_.use_image_hd AS use_image_hd_51, p0_.livre_d_ici AS livre_d_ici_52, p0_.extrait_path AS extrait_path_53, p0_.old_id_img AS old_id_img_54, p0_.id_crm AS id_crm_55, p0_.prix_reference AS prix_reference_56, p0_.poids AS poids_57, p0_.nb_audio_files AS nb_audio_files_58, p0_.livrable_telechargement AS livrable_telechargement_59, p0_.livrable_streaming AS livrable_streaming_60, p0_.tier_indicatif AS tier_indicatif_61, p0_.interprete_indicatif AS interprete_indicatif_62, p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63, p0_.url_origine_presentation_en AS url_origine_presentation_en_64, p0_.url_extrait AS url_extrait_65, p0_.extrait_cdn AS extrait_cdn_66, p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67, p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68, p0_.video AS video_69, p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70, p0_.duree_min AS duree_min_71, p0_.best_seller_ca AS best_seller_ca_72, p0_.numero_tome AS numero_tome_73, p0_.prix_reference_ca AS prix_reference_ca_74, p0_.prix_reference_usd AS prix_reference_usd_75, p0_.abonnement AS abonnement_76, p0_.is_abonnement_ct AS is_abonnement_ct_77, p0_.cat1a AS cat1a_78, p0_.cat1b AS cat1b_79, p0_.cat2a AS cat2a_80, p0_.cat2b AS cat2b_81, p0_.cat3 AS cat3_82, p0_.alias_url AS alias_url_83, p0_.date_fin_precommande AS date_fin_precommande_84, p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85, p0_.nb_tracks AS nb_tracks_86, p0_.preorder AS preorder_87, p0_.promotion AS promotion_88, p0_.prix_vente AS prix_vente_89, p0_.prix_vente_ca AS prix_vente_ca_90, p0_.promotion_ca AS promotion_ca_91, p0_.preorder_ca AS preorder_ca_92, p0_.collection_id AS collection_id_93, p0_.publics_id AS publics_id_94, p0_.publics_jeunesse_id AS publics_jeunesse_id_95, p0_.version_id AS version_id_96, p0_.type_realisation_id AS type_realisation_id_97, p0_.clil_id AS clil_id_98, p0_.editor_id AS editor_id_99, p0_.genre1_id AS genre1_id_100, p0_.sousgenre1_id AS sousgenre1_id_101, p0_.genre2_id AS genre2_id_102, p0_.sousgenre2_id AS sousgenre2_id_103, p0_.genre3_id AS genre3_id_104, p0_.sousgenre3_id AS sousgenre3_id_105, p0_.fournisseur_id AS fournisseur_id_106, p0_.serie_id AS serie_id_107 FROM produit p0_ LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id WHERE p0_.active = 1 AND t1_.algolia_name = ? AND p0_.bool_eur = 1 ORDER BY p0_.date_creation DESC LIMIT 1000 SELECT p0_.id AS id_0, p0_.image_liste_name AS image_liste_name_1, p0_.active AS active_2, p0_.date_creation AS date_creation_3, p0_.date_update AS date_update_4, p0_.date_bibliostream AS date_bibliostream_5, p0_.titre_fr AS titre_fr_6, p0_.titre_en AS titre_en_7, p0_.sous_titre_fr AS sous_titre_fr_8, p0_.sous_titre_en AS sous_titre_en_9, p0_.titre_original AS titre_original_10, p0_.numero_de_partie_fr AS numero_de_partie_fr_11, p0_.numero_de_partie_en AS numero_de_partie_en_12, p0_.texte_alternatif_fr AS texte_alternatif_fr_13, p0_.texte_alternatif_en AS texte_alternatif_en_14, p0_.resume_fr AS resume_fr_15, p0_.resume_en AS resume_en_16, p0_.annee_edition AS annee_edition_17, p0_.annee_production AS annee_production_18, p0_.copyright AS copyright_19, p0_.duree AS duree_20, p0_.isbn AS isbn_21, p0_.numero_editeur AS numero_editeur_22, p0_.ean_telechargement AS ean_telechargement_23, p0_.ean_pret AS ean_pret_24, p0_.ean_cd AS ean_cd_25, p0_.jeunesse_age_min AS jeunesse_age_min_26, p0_.jeunesse_age_max AS jeunesse_age_max_27, p0_.copyright_image AS copyright_image_28, p0_.langue_sources AS langue_sources_29, p0_.langue_originale AS langue_originale_30, p0_.bkdo_id AS bkdo_id_31, p0_.produit_appel AS produit_appel_32, p0_.titre_a_la_une AS titre_a_la_une_33, p0_.recommendation_narra AS recommendation_narra_34, p0_.best_seller AS best_seller_35, p0_.most_pre_purchased AS most_pre_purchased_36, p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37, p0_.bool_eur AS bool_eur_38, p0_.bool_cad AS bool_cad_39, p0_.bool_chf AS bool_chf_40, p0_.bool_usd AS bool_usd_41, p0_.date_best_seller AS date_best_seller_42, p0_.genre_indicatif AS genre_indicatif_43, p0_.bibliostream AS bibliostream_44, p0_.telechargement AS telechargement_45, p0_.inapp AS inapp_46, p0_.enrichissements_fr AS enrichissements_fr_47, p0_.enrichissements_en AS enrichissements_en_48, p0_.image_hd_name AS image_hd_name_49, p0_.image_fiche_name AS image_fiche_name_50, p0_.use_image_hd AS use_image_hd_51, p0_.livre_d_ici AS livre_d_ici_52, p0_.extrait_path AS extrait_path_53, p0_.old_id_img AS old_id_img_54, p0_.id_crm AS id_crm_55, p0_.prix_reference AS prix_reference_56, p0_.poids AS poids_57, p0_.nb_audio_files AS nb_audio_files_58, p0_.livrable_telechargement AS livrable_telechargement_59, p0_.livrable_streaming AS livrable_streaming_60, p0_.tier_indicatif AS tier_indicatif_61, p0_.interprete_indicatif AS interprete_indicatif_62, p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63, p0_.url_origine_presentation_en AS url_origine_presentation_en_64, p0_.url_extrait AS url_extrait_65, p0_.extrait_cdn AS extrait_cdn_66, p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67, p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68, p0_.video AS video_69, p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70, p0_.duree_min AS duree_min_71, p0_.best_seller_ca AS best_seller_ca_72, p0_.numero_tome AS numero_tome_73, p0_.prix_reference_ca AS prix_reference_ca_74, p0_.prix_reference_usd AS prix_reference_usd_75, p0_.abonnement AS abonnement_76, p0_.is_abonnement_ct AS is_abonnement_ct_77, p0_.cat1a AS cat1a_78, p0_.cat1b AS cat1b_79, p0_.cat2a AS cat2a_80, p0_.cat2b AS cat2b_81, p0_.cat3 AS cat3_82, p0_.alias_url AS alias_url_83, p0_.date_fin_precommande AS date_fin_precommande_84, p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85, p0_.nb_tracks AS nb_tracks_86, p0_.preorder AS preorder_87, p0_.promotion AS promotion_88, p0_.prix_vente AS prix_vente_89, p0_.prix_vente_ca AS prix_vente_ca_90, p0_.promotion_ca AS promotion_ca_91, p0_.preorder_ca AS preorder_ca_92, p0_.collection_id AS collection_id_93, p0_.publics_id AS publics_id_94, p0_.publics_jeunesse_id AS publics_jeunesse_id_95, p0_.version_id AS version_id_96, p0_.type_realisation_id AS type_realisation_id_97, p0_.clil_id AS clil_id_98, p0_.editor_id AS editor_id_99, p0_.genre1_id AS genre1_id_100, p0_.sousgenre1_id AS sousgenre1_id_101, p0_.genre2_id AS genre2_id_102, p0_.sousgenre2_id AS sousgenre2_id_103, p0_.genre3_id AS genre3_id_104, p0_.sousgenre3_id AS sousgenre3_id_105, p0_.fournisseur_id AS fournisseur_id_106, p0_.serie_id AS serie_id_107 FROM produit p0_ LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id WHERE p0_.active = 1 AND t1_.algolia_name = 'douglas-kennedy' AND p0_.bool_eur = 1 ORDER BY p0_.date_creation DESC LIMIT 1000;

Time▼

Count

Info

80.11 ms
(100.00%)

SELECT p0_.id AS id_0, p0_.image_liste_name AS image_liste_name_1, p0_.active AS active_2, p0_.date_creation AS date_creation_3, p0_.date_update AS date_update_4, p0_.date_bibliostream AS date_bibliostream_5, p0_.titre_fr AS titre_fr_6, p0_.titre_en AS titre_en_7, p0_.sous_titre_fr AS sous_titre_fr_8, p0_.sous_titre_en AS sous_titre_en_9, p0_.titre_original AS titre_original_10, p0_.numero_de_partie_fr AS numero_de_partie_fr_11, p0_.numero_de_partie_en AS numero_de_partie_en_12, p0_.texte_alternatif_fr AS texte_alternatif_fr_13, p0_.texte_alternatif_en AS texte_alternatif_en_14, p0_.resume_fr AS resume_fr_15, p0_.resume_en AS resume_en_16, p0_.annee_edition AS annee_edition_17, p0_.annee_production AS annee_production_18, p0_.copyright AS copyright_19, p0_.duree AS duree_20, p0_.isbn AS isbn_21, p0_.numero_editeur AS numero_editeur_22, p0_.ean_telechargement AS ean_telechargement_23, p0_.ean_pret AS ean_pret_24, p0_.ean_cd AS ean_cd_25, p0_.jeunesse_age_min AS jeunesse_age_min_26, p0_.jeunesse_age_max AS jeunesse_age_max_27, p0_.copyright_image AS copyright_image_28, p0_.langue_sources AS langue_sources_29, p0_.langue_originale AS langue_originale_30, p0_.bkdo_id AS bkdo_id_31, p0_.produit_appel AS produit_appel_32, p0_.titre_a_la_une AS titre_a_la_une_33, p0_.recommendation_narra AS recommendation_narra_34, p0_.best_seller AS best_seller_35, p0_.most_pre_purchased AS most_pre_purchased_36, p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37, p0_.bool_eur AS bool_eur_38, p0_.bool_cad AS bool_cad_39, p0_.bool_chf AS bool_chf_40, p0_.bool_usd AS bool_usd_41, p0_.date_best_seller AS date_best_seller_42, p0_.genre_indicatif AS genre_indicatif_43, p0_.bibliostream AS bibliostream_44, p0_.telechargement AS telechargement_45, p0_.inapp AS inapp_46, p0_.enrichissements_fr AS enrichissements_fr_47, p0_.enrichissements_en AS enrichissements_en_48, p0_.image_hd_name AS image_hd_name_49, p0_.image_fiche_name AS image_fiche_name_50, p0_.use_image_hd AS use_image_hd_51, p0_.livre_d_ici AS livre_d_ici_52, p0_.extrait_path AS extrait_path_53, p0_.old_id_img AS old_id_img_54, p0_.id_crm AS id_crm_55, p0_.prix_reference AS prix_reference_56, p0_.poids AS poids_57, p0_.nb_audio_files AS nb_audio_files_58, p0_.livrable_telechargement AS livrable_telechargement_59, p0_.livrable_streaming AS livrable_streaming_60, p0_.tier_indicatif AS tier_indicatif_61, p0_.interprete_indicatif AS interprete_indicatif_62, p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63, p0_.url_origine_presentation_en AS url_origine_presentation_en_64, p0_.url_extrait AS url_extrait_65, p0_.extrait_cdn AS extrait_cdn_66, p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67, p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68, p0_.video AS video_69, p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70, p0_.duree_min AS duree_min_71, p0_.best_seller_ca AS best_seller_ca_72, p0_.numero_tome AS numero_tome_73, p0_.prix_reference_ca AS prix_reference_ca_74, p0_.prix_reference_usd AS prix_reference_usd_75, p0_.abonnement AS abonnement_76, p0_.is_abonnement_ct AS is_abonnement_ct_77, p0_.cat1a AS cat1a_78, p0_.cat1b AS cat1b_79, p0_.cat2a AS cat2a_80, p0_.cat2b AS cat2b_81, p0_.cat3 AS cat3_82, p0_.alias_url AS alias_url_83, p0_.date_fin_precommande AS date_fin_precommande_84, p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85, p0_.nb_tracks AS nb_tracks_86, p0_.preorder AS preorder_87, p0_.promotion AS promotion_88, p0_.prix_vente AS prix_vente_89, p0_.prix_vente_ca AS prix_vente_ca_90, p0_.promotion_ca AS promotion_ca_91, p0_.preorder_ca AS preorder_ca_92, p0_.collection_id AS collection_id_93, p0_.publics_id AS publics_id_94, p0_.publics_jeunesse_id AS publics_jeunesse_id_95, p0_.version_id AS version_id_96, p0_.type_realisation_id AS type_realisation_id_97, p0_.clil_id AS clil_id_98, p0_.editor_id AS editor_id_99, p0_.genre1_id AS genre1_id_100, p0_.sousgenre1_id AS sousgenre1_id_101, p0_.genre2_id AS genre2_id_102, p0_.sousgenre2_id AS sousgenre2_id_103, p0_.genre3_id AS genre3_id_104, p0_.sousgenre3_id AS sousgenre3_id_105, p0_.fournisseur_id AS fournisseur_id_106, p0_.serie_id AS serie_id_107 FROM produit p0_ LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id WHERE p0_.active = 1 AND t1_.algolia_name = ? AND p0_.bool_eur = 1 ORDER BY p0_.date_creation DESC LIMIT 1000

Parameters:

[
  "douglas-kennedy"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.image_liste_name AS image_liste_name_1,
  p0_.active AS active_2,
  p0_.date_creation AS date_creation_3,
  p0_.date_update AS date_update_4,
  p0_.date_bibliostream AS date_bibliostream_5,
  p0_.titre_fr AS titre_fr_6,
  p0_.titre_en AS titre_en_7,
  p0_.sous_titre_fr AS sous_titre_fr_8,
  p0_.sous_titre_en AS sous_titre_en_9,
  p0_.titre_original AS titre_original_10,
  p0_.numero_de_partie_fr AS numero_de_partie_fr_11,
  p0_.numero_de_partie_en AS numero_de_partie_en_12,
  p0_.texte_alternatif_fr AS texte_alternatif_fr_13,
  p0_.texte_alternatif_en AS texte_alternatif_en_14,
  p0_.resume_fr AS resume_fr_15,
  p0_.resume_en AS resume_en_16,
  p0_.annee_edition AS annee_edition_17,
  p0_.annee_production AS annee_production_18,
  p0_.copyright AS copyright_19,
  p0_.duree AS duree_20,
  p0_.isbn AS isbn_21,
  p0_.numero_editeur AS numero_editeur_22,
  p0_.ean_telechargement AS ean_telechargement_23,
  p0_.ean_pret AS ean_pret_24,
  p0_.ean_cd AS ean_cd_25,
  p0_.jeunesse_age_min AS jeunesse_age_min_26,
  p0_.jeunesse_age_max AS jeunesse_age_max_27,
  p0_.copyright_image AS copyright_image_28,
  p0_.langue_sources AS langue_sources_29,
  p0_.langue_originale AS langue_originale_30,
  p0_.bkdo_id AS bkdo_id_31,
  p0_.produit_appel AS produit_appel_32,
  p0_.titre_a_la_une AS titre_a_la_une_33,
  p0_.recommendation_narra AS recommendation_narra_34,
  p0_.best_seller AS best_seller_35,
  p0_.most_pre_purchased AS most_pre_purchased_36,
  p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37,
  p0_.bool_eur AS bool_eur_38,
  p0_.bool_cad AS bool_cad_39,
  p0_.bool_chf AS bool_chf_40,
  p0_.bool_usd AS bool_usd_41,
  p0_.date_best_seller AS date_best_seller_42,
  p0_.genre_indicatif AS genre_indicatif_43,
  p0_.bibliostream AS bibliostream_44,
  p0_.telechargement AS telechargement_45,
  p0_.inapp AS inapp_46,
  p0_.enrichissements_fr AS enrichissements_fr_47,
  p0_.enrichissements_en AS enrichissements_en_48,
  p0_.image_hd_name AS image_hd_name_49,
  p0_.image_fiche_name AS image_fiche_name_50,
  p0_.use_image_hd AS use_image_hd_51,
  p0_.livre_d_ici AS livre_d_ici_52,
  p0_.extrait_path AS extrait_path_53,
  p0_.old_id_img AS old_id_img_54,
  p0_.id_crm AS id_crm_55,
  p0_.prix_reference AS prix_reference_56,
  p0_.poids AS poids_57,
  p0_.nb_audio_files AS nb_audio_files_58,
  p0_.livrable_telechargement AS livrable_telechargement_59,
  p0_.livrable_streaming AS livrable_streaming_60,
  p0_.tier_indicatif AS tier_indicatif_61,
  p0_.interprete_indicatif AS interprete_indicatif_62,
  p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63,
  p0_.url_origine_presentation_en AS url_origine_presentation_en_64,
  p0_.url_extrait AS url_extrait_65,
  p0_.extrait_cdn AS extrait_cdn_66,
  p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67,
  p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68,
  p0_.video AS video_69,
  p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70,
  p0_.duree_min AS duree_min_71,
  p0_.best_seller_ca AS best_seller_ca_72,
  p0_.numero_tome AS numero_tome_73,
  p0_.prix_reference_ca AS prix_reference_ca_74,
  p0_.prix_reference_usd AS prix_reference_usd_75,
  p0_.abonnement AS abonnement_76,
  p0_.is_abonnement_ct AS is_abonnement_ct_77,
  p0_.cat1a AS cat1a_78,
  p0_.cat1b AS cat1b_79,
  p0_.cat2a AS cat2a_80,
  p0_.cat2b AS cat2b_81,
  p0_.cat3 AS cat3_82,
  p0_.alias_url AS alias_url_83,
  p0_.date_fin_precommande AS date_fin_precommande_84,
  p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85,
  p0_.nb_tracks AS nb_tracks_86,
  p0_.preorder AS preorder_87,
  p0_.promotion AS promotion_88,
  p0_.prix_vente AS prix_vente_89,
  p0_.prix_vente_ca AS prix_vente_ca_90,
  p0_.promotion_ca AS promotion_ca_91,
  p0_.preorder_ca AS preorder_ca_92,
  p0_.collection_id AS collection_id_93,
  p0_.publics_id AS publics_id_94,
  p0_.publics_jeunesse_id AS publics_jeunesse_id_95,
  p0_.version_id AS version_id_96,
  p0_.type_realisation_id AS type_realisation_id_97,
  p0_.clil_id AS clil_id_98,
  p0_.editor_id AS editor_id_99,
  p0_.genre1_id AS genre1_id_100,
  p0_.sousgenre1_id AS sousgenre1_id_101,
  p0_.genre2_id AS genre2_id_102,
  p0_.sousgenre2_id AS sousgenre2_id_103,
  p0_.genre3_id AS genre3_id_104,
  p0_.sousgenre3_id AS sousgenre3_id_105,
  p0_.fournisseur_id AS fournisseur_id_106,
  p0_.serie_id AS serie_id_107
FROM
  produit p0_
  LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id
  LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id
WHERE
  p0_.active = 1
  AND t1_.algolia_name = ?
  AND p0_.bool_eur = 1
ORDER BY
  p0_.date_creation DESC
LIMIT
  1000

SELECT p0_.id AS id_0, p0_.image_liste_name AS image_liste_name_1, p0_.active AS active_2, p0_.date_creation AS date_creation_3, p0_.date_update AS date_update_4, p0_.date_bibliostream AS date_bibliostream_5, p0_.titre_fr AS titre_fr_6, p0_.titre_en AS titre_en_7, p0_.sous_titre_fr AS sous_titre_fr_8, p0_.sous_titre_en AS sous_titre_en_9, p0_.titre_original AS titre_original_10, p0_.numero_de_partie_fr AS numero_de_partie_fr_11, p0_.numero_de_partie_en AS numero_de_partie_en_12, p0_.texte_alternatif_fr AS texte_alternatif_fr_13, p0_.texte_alternatif_en AS texte_alternatif_en_14, p0_.resume_fr AS resume_fr_15, p0_.resume_en AS resume_en_16, p0_.annee_edition AS annee_edition_17, p0_.annee_production AS annee_production_18, p0_.copyright AS copyright_19, p0_.duree AS duree_20, p0_.isbn AS isbn_21, p0_.numero_editeur AS numero_editeur_22, p0_.ean_telechargement AS ean_telechargement_23, p0_.ean_pret AS ean_pret_24, p0_.ean_cd AS ean_cd_25, p0_.jeunesse_age_min AS jeunesse_age_min_26, p0_.jeunesse_age_max AS jeunesse_age_max_27, p0_.copyright_image AS copyright_image_28, p0_.langue_sources AS langue_sources_29, p0_.langue_originale AS langue_originale_30, p0_.bkdo_id AS bkdo_id_31, p0_.produit_appel AS produit_appel_32, p0_.titre_a_la_une AS titre_a_la_une_33, p0_.recommendation_narra AS recommendation_narra_34, p0_.best_seller AS best_seller_35, p0_.most_pre_purchased AS most_pre_purchased_36, p0_.most_pre_purchased_ca AS most_pre_purchased_ca_37, p0_.bool_eur AS bool_eur_38, p0_.bool_cad AS bool_cad_39, p0_.bool_chf AS bool_chf_40, p0_.bool_usd AS bool_usd_41, p0_.date_best_seller AS date_best_seller_42, p0_.genre_indicatif AS genre_indicatif_43, p0_.bibliostream AS bibliostream_44, p0_.telechargement AS telechargement_45, p0_.inapp AS inapp_46, p0_.enrichissements_fr AS enrichissements_fr_47, p0_.enrichissements_en AS enrichissements_en_48, p0_.image_hd_name AS image_hd_name_49, p0_.image_fiche_name AS image_fiche_name_50, p0_.use_image_hd AS use_image_hd_51, p0_.livre_d_ici AS livre_d_ici_52, p0_.extrait_path AS extrait_path_53, p0_.old_id_img AS old_id_img_54, p0_.id_crm AS id_crm_55, p0_.prix_reference AS prix_reference_56, p0_.poids AS poids_57, p0_.nb_audio_files AS nb_audio_files_58, p0_.livrable_telechargement AS livrable_telechargement_59, p0_.livrable_streaming AS livrable_streaming_60, p0_.tier_indicatif AS tier_indicatif_61, p0_.interprete_indicatif AS interprete_indicatif_62, p0_.url_origine_presentation_fr AS url_origine_presentation_fr_63, p0_.url_origine_presentation_en AS url_origine_presentation_en_64, p0_.url_extrait AS url_extrait_65, p0_.extrait_cdn AS extrait_cdn_66, p0_.coup_de_coeur_libraire AS coup_de_coeur_libraire_67, p0_.coup_de_coeur_libraire_ca AS coup_de_coeur_libraire_ca_68, p0_.video AS video_69, p0_.bool_chapitre_gratuit AS bool_chapitre_gratuit_70, p0_.duree_min AS duree_min_71, p0_.best_seller_ca AS best_seller_ca_72, p0_.numero_tome AS numero_tome_73, p0_.prix_reference_ca AS prix_reference_ca_74, p0_.prix_reference_usd AS prix_reference_usd_75, p0_.abonnement AS abonnement_76, p0_.is_abonnement_ct AS is_abonnement_ct_77, p0_.cat1a AS cat1a_78, p0_.cat1b AS cat1b_79, p0_.cat2a AS cat2a_80, p0_.cat2b AS cat2b_81, p0_.cat3 AS cat3_82, p0_.alias_url AS alias_url_83, p0_.date_fin_precommande AS date_fin_precommande_84, p0_.date_fin_precommande_ca AS date_fin_precommande_ca_85, p0_.nb_tracks AS nb_tracks_86, p0_.preorder AS preorder_87, p0_.promotion AS promotion_88, p0_.prix_vente AS prix_vente_89, p0_.prix_vente_ca AS prix_vente_ca_90, p0_.promotion_ca AS promotion_ca_91, p0_.preorder_ca AS preorder_ca_92, p0_.collection_id AS collection_id_93, p0_.publics_id AS publics_id_94, p0_.publics_jeunesse_id AS publics_jeunesse_id_95, p0_.version_id AS version_id_96, p0_.type_realisation_id AS type_realisation_id_97, p0_.clil_id AS clil_id_98, p0_.editor_id AS editor_id_99, p0_.genre1_id AS genre1_id_100, p0_.sousgenre1_id AS sousgenre1_id_101, p0_.genre2_id AS genre2_id_102, p0_.sousgenre2_id AS sousgenre2_id_103, p0_.genre3_id AS genre3_id_104, p0_.sousgenre3_id AS sousgenre3_id_105, p0_.fournisseur_id AS fournisseur_id_106, p0_.serie_id AS serie_id_107 FROM produit p0_ LEFT JOIN produits_interpretes p2_ ON p0_.id = p2_.produit_id LEFT JOIN tier t1_ ON t1_.id = p2_.tier_id WHERE p0_.active = 1 AND t1_.algolia_name = 'douglas-kennedy' AND p0_.bool_eur = 1 ORDER BY p0_.date_creation DESC LIMIT 1000;

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	The mappings App\Entity\Produit#genre3 and App\Entity\Genres#produits3 are inconsistent with each other.
App\Entity\Tier	No errors.
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\Genres	The association App\Entity\Genres#produits refers to the owning side field App\Entity\Produit#genre which does not exist. The mappings App\Entity\Genres#produits3 and App\Entity\Produit#genre2 are inconsistent with each other. The association App\Entity\Genres#produitOnixes refers to the owning side field App\Entity\ProduitOnix#genres which does not exist.
App\Entity\SousGenres	The association App\Entity\SousGenres#produitOnixes refers to the owning side field App\Entity\ProduitOnix#sousgenres which does not exist.
App\Entity\Fournisseur	No errors.
App\Entity\Serie	No errors.

Symfony Profiler

https://api.staging.bookdoreille.com/api/audiobooks?authorSlug=&contributorSlug=&country=fr&limit=1000&narratorSlug=douglas-kennedy&orderBy=dateDesc&publisher=&type=

Configuration Settings

Theme