Query Metrics
181
Database Queries
20
Different statements
18.65 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.67 ms (0.00%) |
141 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.sort AS sort_4, t0.description AS description_5, t0.icone AS icone_6, t0.parent_menu_id AS parent_menu_id_7 FROM menu_burger t0 WHERE t0.parent_menu_id = ? ORDER BY t0.sort ASC
Parameters:
[
15
]
|
3.05 ms (0.00%) |
7 |
SELECT t0.id AS id_1, t0.nbr_papier_min AS nbr_papier_min_2, t0.nbr_papier_max AS nbr_papier_max_3, t0.accessoire AS accessoire_4, t0.attribute AS attribute_5 FROM accessoire_reluire_nbr t0 WHERE t0.accessoire = ?
Parameters:
[
1
]
|
2.01 ms (0.00%) |
2 |
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM accessoire_product a1_ LEFT JOIN accessoire a0_ ON a1_.accessoire = a0_.id WHERE a0_.type_accessoire = ? AND a1_.product = ? ORDER BY a0_.name ASC
Parameters:
[ 2 3 ] |
1.14 ms (0.00%) |
2 |
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1, a0_.name_papier AS name_papier_2, a0_.description AS description_3, a0_.type_format AS type_format_4, a0_.type_grammage AS type_grammage_5, a0_.is_top AS is_top_6 FROM product_attribute p1_ LEFT JOIN attribut a0_ ON p1_.format = a0_.id WHERE (a0_.is_deleted IS NULL OR a0_.is_deleted = 0) AND p1_.product_id = ? AND p1_.is_enabled = 1 ORDER BY a0_.name ASC
Parameters:
[
3
]
|
0.94 ms (0.00%) |
2 |
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1, a0_.name_papier AS name_papier_2, a0_.description AS description_3, a0_.type_format AS type_format_4, a0_.type_grammage AS type_grammage_5, a0_.is_top AS is_top_6 FROM product_attribute p1_ LEFT JOIN attribut a0_ ON p1_.gramage = a0_.id WHERE (a0_.is_deleted IS NULL OR a0_.is_deleted = 0) AND (a0_.is_dos_carre IS NULL OR a0_.is_dos_carre = 0) AND (a0_.is_pique2point IS NULL OR a0_.is_pique2point = 0) AND (a0_.is_pique2point IS NULL OR a0_.is_pique2point = 0) AND (a0_.is_dos_carre_pique IS NULL OR a0_.is_dos_carre_pique = 0) AND p1_.product_id = ? AND p1_.is_enabled = 1 ORDER BY a0_.name ASC
Parameters:
[
3
]
|
0.70 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prix_ht AS prix_ht_3, t0.prix_ttc AS prix_ttc_4, t0.type_product AS type_product_5, t0.qty AS qty_6, t0.description AS description_7, t0.file AS file_8, t0.sort AS sort_9, t0.pourcentage_add AS pourcentage_add_10, t0.info_bulle AS info_bulle_11, t0.is_recto AS is_recto_12, t0.is_recto_verso AS is_recto_verso_13, t0.is_deleted AS is_deleted_14, t0.besoin_product_is_promo AS besoin_product_is_promo_15, t0.besoin_product_text_prix_promo AS besoin_product_text_prix_promo_16, t0.besoin_product_is_new AS besoin_product_is_new_17, t0.besoin_product_is_luxe AS besoin_product_is_luxe_18, t0.besoin_product_is_moment AS besoin_product_is_moment_19, t0.besoin_product_text_prix AS besoin_product_text_prix_20, t0.besoin_product_text_titre AS besoin_product_text_titre_21, t0.file_besoin_product AS file_besoin_product_22, t0.is_color_lab AS is_color_lab_23, t0.is_new_display_color_lab AS is_new_display_color_lab_24, t0.image_bloc_option_product AS image_bloc_option_product_25, t0.titre_bloc_option_product AS titre_bloc_option_product_26, t0.titre_bloc_option_product_police AS titre_bloc_option_product_police_27, t0.titre_bloc_option_product_taille AS titre_bloc_option_product_taille_28, t0.titre_bloc_option_product_couleur AS titre_bloc_option_product_couleur_29, t0.titre_bloc_option_product_overlay AS titre_bloc_option_product_overlay_30, t0.image_bloc_option_product_overlay AS image_bloc_option_product_overlay_31, t0.sous_titre_bloc_option_product AS sous_titre_bloc_option_product_32, t0.sous_titre_bloc_option_product_police AS sous_titre_bloc_option_product_police_33, t0.sous_titre_bloc_option_product_taille AS sous_titre_bloc_option_product_taille_34, t0.sous_titre_bloc_option_product_couleur AS sous_titre_bloc_option_product_couleur_35, t0.sous_titre_bloc_option_product_overlay AS sous_titre_bloc_option_product_overlay_36, t0.titre_product_description AS titre_product_description_37, t0.description_produit AS description_produit_38, t0.tips_produit AS tips_produit_39, t0.greentouch_produit AS greentouch_produit_40, t0.guide_tailles_produit AS guide_tailles_produit_41, t0.prix_ht_abonnement_pro AS prix_ht_abonnement_pro_42, t0.prix_ttc_abonnement_pro AS prix_ttc_abonnement_pro_43, t0.prix_ht_abonnement_team AS prix_ht_abonnement_team_44, t0.prix_ttc_abonnement_team AS prix_ttc_abonnement_team_45, t0.prix_ht_abonnement_pro_couleur AS prix_ht_abonnement_pro_couleur_46, t0.prix_ttc_abonnement_pro_couleur AS prix_ttc_abonnement_pro_couleur_47, t0.prix_ht_abonnement_team_couleur AS prix_ht_abonnement_team_couleur_48, t0.prix_ttc_abonnement_team_couleur AS prix_ttc_abonnement_team_couleur_49, t0.prix_ht_abonnement_entreprise AS prix_ht_abonnement_entreprise_50, t0.prix_ttc_abonnement_entreprise AS prix_ttc_abonnement_entreprise_51, t0.besoin_product_name1 AS besoin_product_name1_52, t0.besoin_productdescription1 AS besoin_productdescription1_53, t0.besoin_product_name2 AS besoin_product_name2_54, t0.besoin_productdescription2 AS besoin_productdescription2_55, t0.besoin_product_name3 AS besoin_product_name3_56, t0.besoin_productdescription3 AS besoin_productdescription3_57, t0.besoin_product_name4 AS besoin_product_name4_58, t0.besoin_productdescription4 AS besoin_productdescription4_59, t0.besoin_product_name5 AS besoin_product_name5_60, t0.besoin_productdescription5 AS besoin_productdescription5_61, t0.besoin_product_name6 AS besoin_product_name6_62, t0.besoin_productdescription6 AS besoin_productdescription6_63, t0.besoin_product_name7 AS besoin_product_name7_64, t0.besoin_productdescription7 AS besoin_productdescription7_65, t0.image_bloc_option_product_new1 AS image_bloc_option_product_new1_66, t0.titre_bloc_option_product_new1 AS titre_bloc_option_product_new1_67, t0.titre_bloc_option_product_police_new1 AS titre_bloc_option_product_police_new1_68, t0.titre_bloc_option_product_taille_new1 AS titre_bloc_option_product_taille_new1_69, t0.titre_bloc_option_product_couleur_new1 AS titre_bloc_option_product_couleur_new1_70, t0.titre_btn_bloc_option_product_new1 AS titre_btn_bloc_option_product_new1_71, t0.link_btn_bloc_option_product_new1 AS link_btn_bloc_option_product_new1_72, t0.link_btn_bloc_option_product_new1is_extern AS link_btn_bloc_option_product_new1is_extern_73, t0.titre_btn_bloc_option_product_police_new1 AS titre_btn_bloc_option_product_police_new1_74, t0.titre_btn_bloc_option_product_taille_new1 AS titre_btn_bloc_option_product_taille_new1_75, t0.titre_btn_bloc_option_product_couleur_new1 AS titre_btn_bloc_option_product_couleur_new1_76, t0.titre_btn_bloc_option_product_couleur_background_new1 AS titre_btn_bloc_option_product_couleur_background_new1_77, t0.image_bloc_option_product_new2 AS image_bloc_option_product_new2_78, t0.titre_bloc_option_product_new2 AS titre_bloc_option_product_new2_79, t0.titre_bloc_option_product_police_new2 AS titre_bloc_option_product_police_new2_80, t0.titre_bloc_option_product_taille_new2 AS titre_bloc_option_product_taille_new2_81, t0.titre_bloc_option_product_couleur_new2 AS titre_bloc_option_product_couleur_new2_82, t0.titre_btn_bloc_option_product_new2 AS titre_btn_bloc_option_product_new2_83, t0.link_btn_bloc_option_product_new2 AS link_btn_bloc_option_product_new2_84, t0.link_btn_bloc_option_product_new2is_extern AS link_btn_bloc_option_product_new2is_extern_85, t0.titre_btn_bloc_option_product_police_new2 AS titre_btn_bloc_option_product_police_new2_86, t0.titre_btn_bloc_option_product_taille_new2 AS titre_btn_bloc_option_product_taille_new2_87, t0.titre_btn_bloc_option_product_couleur_new2 AS titre_btn_bloc_option_product_couleur_new2_88, t0.titre_btn_bloc_option_product_couleur_background_new2 AS titre_btn_bloc_option_product_couleur_background_new2_89, t0.image_bloc_option_product_new3 AS image_bloc_option_product_new3_90, t0.titre_bloc_option_product_new3 AS titre_bloc_option_product_new3_91, t0.titre_bloc_option_product_police_new3 AS titre_bloc_option_product_police_new3_92, t0.titre_bloc_option_product_taille_new3 AS titre_bloc_option_product_taille_new3_93, t0.titre_bloc_option_product_couleur_new3 AS titre_bloc_option_product_couleur_new3_94, t0.titre_btn_bloc_option_product_new3 AS titre_btn_bloc_option_product_new3_95, t0.link_btn_bloc_option_product_new3 AS link_btn_bloc_option_product_new3_96, t0.link_btn_bloc_option_product_new3is_extern AS link_btn_bloc_option_product_new3is_extern_97, t0.titre_btn_bloc_option_product_police_new3 AS titre_btn_bloc_option_product_police_new3_98, t0.titre_btn_bloc_option_product_taille_new3 AS titre_btn_bloc_option_product_taille_new3_99, t0.titre_btn_bloc_option_product_couleur_new3 AS titre_btn_bloc_option_product_couleur_new3_100, t0.titre_btn_bloc_option_product_couleur_background_new3 AS titre_btn_bloc_option_product_couleur_background_new3_101, t0.image_bloc_option_product_new4 AS image_bloc_option_product_new4_102, t0.titre_bloc_option_product_new4 AS titre_bloc_option_product_new4_103, t0.titre_bloc_option_product_police_new4 AS titre_bloc_option_product_police_new4_104, t0.titre_bloc_option_product_taille_new4 AS titre_bloc_option_product_taille_new4_105, t0.titre_bloc_option_product_couleur_new4 AS titre_bloc_option_product_couleur_new4_106, t0.titre_btn_bloc_option_product_new4 AS titre_btn_bloc_option_product_new4_107, t0.link_btn_bloc_option_product_new4 AS link_btn_bloc_option_product_new4_108, t0.link_btn_bloc_option_product_new4is_extern AS link_btn_bloc_option_product_new4is_extern_109, t0.titre_btn_bloc_option_product_police_new4 AS titre_btn_bloc_option_product_police_new4_110, t0.titre_btn_bloc_option_product_taille_new4 AS titre_btn_bloc_option_product_taille_new4_111, t0.titre_btn_bloc_option_product_couleur_new4 AS titre_btn_bloc_option_product_couleur_new4_112, t0.titre_btn_bloc_option_product_couleur_background_new4 AS titre_btn_bloc_option_product_couleur_background_new4_113, t0.lien_savoir_plus AS lien_savoir_plus_114, t0.lien_savoir_plus_is_extern AS lien_savoir_plus_is_extern_115, t0.image_bloc1option_product AS image_bloc1option_product_116, t0.titre_bloc1option_product AS titre_bloc1option_product_117, t0.description_bloc1option_product AS description_bloc1option_product_118, t0.titre_btn_bloc1option_product AS titre_btn_bloc1option_product_119, t0.link_btn_bloc1option_product AS link_btn_bloc1option_product_120, t0.link_btn_bloc1option_product_is_extern AS link_btn_bloc1option_product_is_extern_121, t0.image_bloc2option_product AS image_bloc2option_product_122, t0.titre_bloc2option_product AS titre_bloc2option_product_123, t0.description_bloc2option_product AS description_bloc2option_product_124, t0.titre_btn_bloc2option_product AS titre_btn_bloc2option_product_125, t0.link_btn_bloc2option_product AS link_btn_bloc2option_product_126, t0.link_btn_bloc2option_product_is_extern AS link_btn_bloc2option_product_is_extern_127, t0.image_bloc3option_product AS image_bloc3option_product_128, t0.titre_bloc3option_product AS titre_bloc3option_product_129, t0.description_bloc3option_product AS description_bloc3option_product_130, t0.titre_btn_bloc3option_product AS titre_btn_bloc3option_product_131, t0.link_btn_bloc3option_product AS link_btn_bloc3option_product_132, t0.link_btn_bloc3option_product_is_extern AS link_btn_bloc3option_product_is_extern_133, t0.product_titre_mobile AS product_titre_mobile_134, t0.image_bloc_tel_option_product AS image_bloc_tel_option_product_135, t0.description_bloc_tel_option_product AS description_bloc_tel_option_product_136, t0.savoir_plus_grammage_option_product AS savoir_plus_grammage_option_product_137, t0.savoir_plus_grammage_option_product_is_extern AS savoir_plus_grammage_option_product_is_extern_138, t0.lien_calandly_option_product AS lien_calandly_option_product_139, t0.lien_calandly_option_product_is_extern AS lien_calandly_option_product_is_extern_140, t0.lien_cdemande_devis AS lien_cdemande_devis_141, t0.lien_cdemande_devis_is_extern AS lien_cdemande_devis_is_extern_142, t0.image_bloc_modal_liseuse1 AS image_bloc_modal_liseuse1_143, t0.image_bloc_modal_liseuse2 AS image_bloc_modal_liseuse2_144, t0.image_bloc_modal_liseuse3 AS image_bloc_modal_liseuse3_145, t0.lien_bloc_modal_liseuse1 AS lien_bloc_modal_liseuse1_146, t0.lien_bloc_modal_liseuse2 AS lien_bloc_modal_liseuse2_147, t0.lien_bloc_modal_liseuse3 AS lien_bloc_modal_liseuse3_148, t0.meta_title AS meta_title_149, t0.meta_description AS meta_description_150 FROM product t0 WHERE t0.type_product = ? LIMIT 1
Parameters:
[
3
]
|
0.65 ms (0.00%) |
2 |
SELECT p0_.is_reluire AS is_reluire_0, p0_.rectoverso AS rectoverso_1, a1_.id AS id_2, a1_.name AS name_3, a2_.id AS id_4 FROM product_attribute p0_ LEFT JOIN attribut a1_ ON p0_.format = a1_.id LEFT JOIN attribut a2_ ON p0_.gramage = a2_.id WHERE p0_.product_id = ? AND p0_.is_enabled = 1
Parameters:
[
3
]
|
0.65 ms (0.00%) |
2 |
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1, a0_.couleur_dos AS couleur_dos_2, a0_.couleur AS couleur_3, a0_.petit_cote AS petit_cote_4, a0_.grand_cote AS grand_cote_5, a0_.papier_coverture_mat AS papier_coverture_mat_6, a0_.papier_coverture_brillant AS papier_coverture_brillant_7, a0_.is_dos_carre AS is_dos_carre_8, a0_.nbr_papier AS nbr_papier_9, a0_.type_reluire AS type_reluire_10, a0_.image_reluire2 AS image_reluire2_11, a0_.path_page AS path_page_12 FROM accessoire_product a1_ LEFT JOIN accessoire a0_ ON a1_.accessoire = a0_.id WHERE a0_.type_accessoire = ? AND a1_.product = ? ORDER BY a0_.name ASC
Parameters:
[ 1 3 ] |
0.39 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.couleur_dos AS couleur_dos_3, t0.couleur AS couleur_4, t0.type_accessoire AS type_accessoire_5, t0.type_couleur AS type_couleur_6, t0.petit_cote AS petit_cote_7, t0.grand_cote AS grand_cote_8, t0.nbr_papier AS nbr_papier_9, t0.prix_ht AS prix_ht_10, t0.prix_ttc AS prix_ttc_11, t0.prix_ht_abonnement_pro AS prix_ht_abonnement_pro_12, t0.prix_ttc_abonnement_pro AS prix_ttc_abonnement_pro_13, t0.prix_ht_abonnement_team AS prix_ht_abonnement_team_14, t0.prix_ttc_abonnement_team AS prix_ttc_abonnement_team_15, t0.prix_ht_abonnement_entreprise AS prix_ht_abonnement_entreprise_16, t0.prix_ttc_abonnement_entreprise AS prix_ttc_abonnement_entreprise_17, t0.qty AS qty_18, t0.nomenclature AS nomenclature_19, t0.is_dos_carre AS is_dos_carre_20, t0.is_pique2point AS is_pique2point_21, t0.is_dos_carre_pique AS is_dos_carre_pique_22, t0.papier_coverture_mat AS papier_coverture_mat_23, t0.papier_coverture_brillant AS papier_coverture_brillant_24, t0.type_reluire AS type_reluire_25, t0.livraison30min_lendemain AS livraison30min_lendemain_26, t0.livraison30min2j AS livraison30min2j_27, t0.image_reluire AS image_reluire_28, t0.image_reluire2 AS image_reluire2_29, t0.content_modal_min_max_reluire AS content_modal_min_max_reluire_30, t0.path_page AS path_page_31, t0.path_page_regle AS path_page_regle_32 FROM accessoire t0 WHERE t0.type_accessoire = ?
Parameters:
[
1
]
|
0.37 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.num_bandeau AS num_bandeau_3 FROM bandeau_rose t0 WHERE t0.num_bandeau = ? LIMIT 1
Parameters:
[
1
]
|
0.31 ms (0.00%) |
2 |
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.description AS description_2, c0_.is_deleted AS is_deleted_3 FROM category_pdf c0_ WHERE c0_.is_deleted IS NULL OR c0_.is_deleted = 0 ORDER BY c0_.id ASC
Parameters:
[] |
0.30 ms (0.00%) |
2 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.image AS image_2, p0_.file AS file_3, p0_.qty AS qty_4, p0_.qty_color AS qty_color_5, p0_.qty_noir AS qty_noir_6, p0_.is_deleted AS is_deleted_7, p0_.trie AS trie_8, p0_.category_pdf AS category_pdf_9 FROM product_pdf p0_ WHERE p0_.is_deleted IS NULL OR p0_.is_deleted = 0 ORDER BY p0_.trie ASC LIMIT 20
Parameters:
[] |
0.25 ms (0.00%) |
4 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.country_code = ?
Parameters:
[
"FR"
]
|
0.23 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.name_path AS name_path_2, t0.name_route AS name_route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.titre AS titre_6, t0.content AS content_7 FROM seo t0 WHERE t0.name_route = ? LIMIT 1
Parameters:
[
"liseuse"
]
|
0.22 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.condition_d AS condition_d_3 FROM bandeau_home_page t0 LIMIT 1
Parameters:
[] |
0.20 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.country_code = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[ "US" 1 ] |
0.17 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_w AS type_w_3 FROM config_wording t0 WHERE t0.type_w = ? LIMIT 1
Parameters:
[
1
]
|
0.16 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.sort AS sort_4, t0.description AS description_5, t0.icone AS icone_6, t0.parent_menu_id AS parent_menu_id_7 FROM menu_burger t0 ORDER BY t0.sort ASC
Parameters:
[] |
0.14 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.bandeau_home_page_id AS bandeau_home_page_id_3 FROM bandeau_home_page_item t0 WHERE t0.bandeau_home_page_id = ?
Parameters:
[
1
]
|
0.10 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.language_code = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[ "Fr" 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\User | No errors. |
App\Entity\LanguageCountry | No errors. |
App\Entity\Product |
|
App\Entity\AccessoireProduct | No errors. |
App\Entity\ProductImage | No errors. |
App\Entity\TextHoverProduct | No errors. |
App\Entity\LiseuseProduitAtribut | No errors. |
App\Entity\TipsProduct | No errors. |
App\Entity\RecommendationProduct | No errors. |
App\Entity\ProductImageMobile | No errors. |
App\Entity\ProductAttribute | No errors. |
App\Entity\Attribut | No errors. |
App\Entity\Accessoire | No errors. |
App\Entity\CategoryPdf | No errors. |
App\Entity\ProductPdf | No errors. |
App\Entity\AccessoireReluireNbr | No errors. |
App\Entity\ConfigWording | No errors. |
App\Entity\Seo | No errors. |
App\Entity\BandeauHomePage | No errors. |
App\Entity\BandeauHomePageItem | No errors. |
App\Entity\BandeauRose | No errors. |
App\Entity\MenuBurger | No errors. |