https://preprod.copees.com/fr/product-option/get-option-by-product/14

Method
GET
HTTP Status
200
IP
40.77.167.18
Profiled on
Token
fdab5d

Query Metrics

5 Database Queries
5 Different statements
2.25 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.51 ms 
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
]
View formatted query    View runnable query    Explain query
2 0.39 ms 
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
]
View formatted query    View runnable query    Explain query
3 0.29 ms 
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.id = ?
Parameters: 
[
  "14"
]
View formatted query    View runnable query    Explain query
4 0.37 ms 
SELECT t0.id AS id_1, t0.is_reluire AS is_reluire_2, t0.rectoverso AS rectoverso_3, t0.plastification AS plastification_4, t0.is_default AS is_default_5, t0.is_enabled AS is_enabled_6, t0.pourcentage_add AS pourcentage_add_7, t0.design_type_color_lab AS design_type_color_lab_8, t0.id_product_mat_exaprint AS id_product_mat_exaprint_9, t0.id_product_brillant_exaprint AS id_product_brillant_exaprint_10, t0.ref_product_mat_exaprint AS ref_product_mat_exaprint_11, t0.ref_product_brillant_exaprint AS ref_product_brillant_exaprint_12, t0.id_product_soft_touch_exaprint AS id_product_soft_touch_exaprint_13, t0.ref_product_soft_touch_exaprint AS ref_product_soft_touch_exaprint_14, t0.id_product_pelliculemat_exaprint AS id_product_pelliculemat_exaprint_15, t0.ref_product_pelliculemat_exaprint AS ref_product_pelliculemat_exaprint_16, t0.id_product_pellicule_brillant_exaprint AS id_product_pellicule_brillant_exaprint_17, t0.ref_product_pellicule_brillant_exaprint AS ref_product_pellicule_brillant_exaprint_18, t0.format AS format_19, t0.gramage AS gramage_20, t0.type_impression AS type_impression_21, t0.type_format AS type_format_22, t0.specificite AS specificite_23, t0.type_couleur AS type_couleur_24, t0.taille AS taille_25, t0.zone_impression AS zone_impression_26, t0.nbr_couleur AS nbr_couleur_27, t0.support_suspension AS support_suspension_28, t0.type_carton AS type_carton_29, t0.oeille AS oeille_30, t0.product_id AS product_id_31 FROM product_attribute t0 WHERE t0.product_id = ? AND t0.is_default = ? LIMIT 1
Parameters: 
[
  14
  1
]
View formatted query    View runnable query    Explain query
5 0.68 ms 
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_.file AS file_4, a0_.type_attribute AS type_attribute_5, a0_.image_produit AS image_produit_6, a0_.description_produit AS description_produit_7, a0_.tips_produit AS tips_produit_8, a0_.greentouch_produit AS greentouch_produit_9, a0_.guide_tailles_produit AS guide_tailles_produit_10, a0_.sort AS sort_11, a0_.is_finition_mate AS is_finition_mate_12, a0_.is_finition_glasse AS is_finition_glasse_13, a0_.file_finition_mate AS file_finition_mate_14, a0_.file_finition_glasse AS file_finition_glasse_15, a0_.text_finition_glasse AS text_finition_glasse_16, a0_.text_finition_mate AS text_finition_mate_17, a0_.is_finition_transparent AS is_finition_transparent_18, a0_.file_finition_transparent AS file_finition_transparent_19, a0_.text_finition_transparent AS text_finition_transparent_20, a0_.is_finition_repositionalble AS is_finition_repositionalble_21, a0_.file_finition_repositionalble AS file_finition_repositionalble_22, a0_.text_finition_repositionalble AS text_finition_repositionalble_23, a0_.file_avec_verification AS file_avec_verification_24, a0_.file_sans_verification AS file_sans_verification_25, a0_.text_avec_verification AS text_avec_verification_26, a0_.text_sans_verification AS text_sans_verification_27, a0_.image_recto AS image_recto_28, a0_.image_verso AS image_verso_29, a0_.description2 AS description2_30, a0_.is_bords_arrondis AS is_bords_arrondis_31, a0_.file_avec_bords_arrondis AS file_avec_bords_arrondis_32, a0_.file_sans_bords_arrondis AS file_sans_bords_arrondis_33, a0_.text_avec_bords_arrondis AS text_avec_bords_arrondis_34, a0_.text_sans_bords_arrondis AS text_sans_bords_arrondis_35, a0_.is_plastification AS is_plastification_36, a0_.file_avec_plastification AS file_avec_plastification_37, a0_.file_sans_plastification AS file_sans_plastification_38, a0_.text_avec_plastification AS text_avec_plastification_39, a0_.text_sans_plastification AS text_sans_plastification_40, a0_.is_finition_soft_touch AS is_finition_soft_touch_41, a0_.file_finition_soft_touch AS file_finition_soft_touch_42, a0_.text_finition_soft_touch AS text_finition_soft_touch_43, a0_.is_finition_pelliculemat AS is_finition_pelliculemat_44, a0_.file_finition_pelliculemat AS file_finition_pelliculemat_45, a0_.text_finition_pelliculemat AS text_finition_pelliculemat_46, a0_.is_display_none AS is_display_none_47, a0_.is_top AS is_top_48, a0_.is_finition_pellicule_brillant AS is_finition_pellicule_brillant_49, a0_.file_finition_pellicule_brillant AS file_finition_pellicule_brillant_50, a0_.text_finition_pellicule_brillant AS text_finition_pellicule_brillant_51 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 (a0_.is_soon IS NULL OR a0_.is_soon = 0) AND p1_.product_id = ? AND p1_.is_enabled = 1 ORDER BY a0_.sort ASC, a0_.name ASC
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query

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
  • The mappings App\Entity\Product#productImageMobile and App\Entity\ProductImageMobile#product are inconsistent with each other.
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.