Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.23 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.14 ms (0.00%)	1	SELECT t0.id AS id_1, t0.prix_ht AS prix_ht_2, t0.prix_ttc AS prix_ttc_3, t0.prix_ht_reduction AS prix_ht_reduction_4, t0.prix_ttc_reduction AS prix_ttc_reduction_5, t0.prix_ht_without_reduction AS prix_ht_without_reduction_6, t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7, t0.product_name AS product_name_8, t0.type_product AS type_product_9, t0.qty AS qty_10, t0.qty_color AS qty_color_11, t0.qty_noir AS qty_noir_12, t0.commentaire AS commentaire_13, t0.is_reluire AS is_reluire_14, t0.file_papier AS file_papier_15, t0.token AS token_16, t0.file_papier_name AS file_papier_name_17, t0.nbr_papier AS nbr_papier_18, t0.is_default AS is_default_19, t0.file_papier_first_image AS file_papier_first_image_20, t0.imprim_sans_marge AS imprim_sans_marge_21, t0.is_ma_crea AS is_ma_crea_22, t0.is_plus_expert AS is_plus_expert_23, t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24, t0.is_plus_plastification AS is_plus_plastification_25, t0.is_plus_verification AS is_plus_verification_26, t0.finition AS finition_27, t0.is_top_imp AS is_top_imp_28, t0.is_modif AS is_modif_29, t0.real_path_file AS real_path_file_30, t0.is_enveloppe AS is_enveloppe_31, t0.souhaite_str AS souhaite_str_32, t0.is_trait AS is_trait_33, t0.petit_cote AS petit_cote_34, t0.grand_cote AS grand_cote_35, t0.prix_carrier_ht AS prix_carrier_ht_36, t0.prix_carrier_ttc AS prix_carrier_ttc_37, t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38, t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39, t0.date_end AS date_end_40, t0.date_start AS date_start_41, t0.type_livraison_national AS type_livraison_national_42, t0.id_service_point_livraison AS id_service_point_livraison_43, t0.type_livraison30min AS type_livraison30min_44, t0.adresse AS adresse_45, t0.city AS city_46, t0.code_postal AS code_postal_47, t0.country AS country_48, t0.country_code AS country_code_49, t0.lat AS lat_50, t0.longi AS longi_51, t0.template_id_crello AS template_id_crello_52, t0.mauvais_format AS mauvais_format_53, t0.color_lab_token_product AS color_lab_token_product_54, t0.color_lab_id_product AS color_lab_id_product_55, t0.is_exaprint AS is_exaprint_56, t0.is_decoupe_doc AS is_decoupe_doc_57, t0.is_promo_detail AS is_promo_detail_58, t0.format_largeur AS format_largeur_59, t0.format_hauteur AS format_hauteur_60, t0.date_estime_livraison_national AS date_estime_livraison_national_61, t0.product_id AS product_id_62, t0.product_attribute_id AS product_attribute_id_63, t0.cart_id AS cart_id_64, t0.carrier_id AS carrier_id_65, t0.imprimeur_id AS imprimeur_id_66 FROM cart_detail t0 WHERE t0.token = ? LIMIT 1 Parameters: [`"4ee32e78ba0f59ff8163b8101f0c938e"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.prix_ht AS prix_ht_2, t0.prix_ttc AS prix_ttc_3, t0.prix_ht_reduction AS prix_ht_reduction_4, t0.prix_ttc_reduction AS prix_ttc_reduction_5, t0.prix_ht_without_reduction AS prix_ht_without_reduction_6, t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7, t0.product_name AS product_name_8, t0.type_product AS type_product_9, t0.qty AS qty_10, t0.qty_color AS qty_color_11, t0.qty_noir AS qty_noir_12, t0.commentaire AS commentaire_13, t0.is_reluire AS is_reluire_14, t0.file_papier AS file_papier_15, t0.token AS token_16, t0.file_papier_name AS file_papier_name_17, t0.nbr_papier AS nbr_papier_18, t0.is_default AS is_default_19, t0.file_papier_first_image AS file_papier_first_image_20, t0.imprim_sans_marge AS imprim_sans_marge_21, t0.is_ma_crea AS is_ma_crea_22, t0.is_plus_expert AS is_plus_expert_23, t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24, t0.is_plus_plastification AS is_plus_plastification_25, t0.is_plus_verification AS is_plus_verification_26, t0.finition AS finition_27, t0.is_top_imp AS is_top_imp_28, t0.is_modif AS is_modif_29, t0.real_path_file AS real_path_file_30, t0.is_enveloppe AS is_enveloppe_31, t0.souhaite_str AS souhaite_str_32, t0.is_trait AS is_trait_33, t0.petit_cote AS petit_cote_34, t0.grand_cote AS grand_cote_35, t0.prix_carrier_ht AS prix_carrier_ht_36, t0.prix_carrier_ttc AS prix_carrier_ttc_37, t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38, t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39, t0.date_end AS date_end_40, t0.date_start AS date_start_41, t0.type_livraison_national AS type_livraison_national_42, t0.id_service_point_livraison AS id_service_point_livraison_43, t0.type_livraison30min AS type_livraison30min_44, t0.adresse AS adresse_45, t0.city AS city_46, t0.code_postal AS code_postal_47, t0.country AS country_48, t0.country_code AS country_code_49, t0.lat AS lat_50, t0.longi AS longi_51, t0.template_id_crello AS template_id_crello_52, t0.mauvais_format AS mauvais_format_53, t0.color_lab_token_product AS color_lab_token_product_54, t0.color_lab_id_product AS color_lab_id_product_55, t0.is_exaprint AS is_exaprint_56, t0.is_decoupe_doc AS is_decoupe_doc_57, t0.is_promo_detail AS is_promo_detail_58, t0.format_largeur AS format_largeur_59, t0.format_hauteur AS format_hauteur_60, t0.date_estime_livraison_national AS date_estime_livraison_national_61, t0.product_id AS product_id_62, t0.product_attribute_id AS product_attribute_id_63, t0.cart_id AS cart_id_64, t0.carrier_id AS carrier_id_65, t0.imprimeur_id AS imprimeur_id_66 FROM cart_detail t0 WHERE t0.token = ? LIMIT 1 SELECT t0.id AS id_1, t0.prix_ht AS prix_ht_2, t0.prix_ttc AS prix_ttc_3, t0.prix_ht_reduction AS prix_ht_reduction_4, t0.prix_ttc_reduction AS prix_ttc_reduction_5, t0.prix_ht_without_reduction AS prix_ht_without_reduction_6, t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7, t0.product_name AS product_name_8, t0.type_product AS type_product_9, t0.qty AS qty_10, t0.qty_color AS qty_color_11, t0.qty_noir AS qty_noir_12, t0.commentaire AS commentaire_13, t0.is_reluire AS is_reluire_14, t0.file_papier AS file_papier_15, t0.token AS token_16, t0.file_papier_name AS file_papier_name_17, t0.nbr_papier AS nbr_papier_18, t0.is_default AS is_default_19, t0.file_papier_first_image AS file_papier_first_image_20, t0.imprim_sans_marge AS imprim_sans_marge_21, t0.is_ma_crea AS is_ma_crea_22, t0.is_plus_expert AS is_plus_expert_23, t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24, t0.is_plus_plastification AS is_plus_plastification_25, t0.is_plus_verification AS is_plus_verification_26, t0.finition AS finition_27, t0.is_top_imp AS is_top_imp_28, t0.is_modif AS is_modif_29, t0.real_path_file AS real_path_file_30, t0.is_enveloppe AS is_enveloppe_31, t0.souhaite_str AS souhaite_str_32, t0.is_trait AS is_trait_33, t0.petit_cote AS petit_cote_34, t0.grand_cote AS grand_cote_35, t0.prix_carrier_ht AS prix_carrier_ht_36, t0.prix_carrier_ttc AS prix_carrier_ttc_37, t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38, t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39, t0.date_end AS date_end_40, t0.date_start AS date_start_41, t0.type_livraison_national AS type_livraison_national_42, t0.id_service_point_livraison AS id_service_point_livraison_43, t0.type_livraison30min AS type_livraison30min_44, t0.adresse AS adresse_45, t0.city AS city_46, t0.code_postal AS code_postal_47, t0.country AS country_48, t0.country_code AS country_code_49, t0.lat AS lat_50, t0.longi AS longi_51, t0.template_id_crello AS template_id_crello_52, t0.mauvais_format AS mauvais_format_53, t0.color_lab_token_product AS color_lab_token_product_54, t0.color_lab_id_product AS color_lab_id_product_55, t0.is_exaprint AS is_exaprint_56, t0.is_decoupe_doc AS is_decoupe_doc_57, t0.is_promo_detail AS is_promo_detail_58, t0.format_largeur AS format_largeur_59, t0.format_hauteur AS format_hauteur_60, t0.date_estime_livraison_national AS date_estime_livraison_national_61, t0.product_id AS product_id_62, t0.product_attribute_id AS product_attribute_id_63, t0.cart_id AS cart_id_64, t0.carrier_id AS carrier_id_65, t0.imprimeur_id AS imprimeur_id_66 FROM cart_detail t0 WHERE t0.token = '4ee32e78ba0f59ff8163b8101f0c938e' LIMIT 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`] View formatted query View runnable query Explain query 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 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 = 'Fr' AND t0.is_enabled = 1 LIMIT 1;

Time▼

Count

Info

0.14 ms
(0.00%)

SELECT t0.id AS id_1, t0.prix_ht AS prix_ht_2, t0.prix_ttc AS prix_ttc_3, t0.prix_ht_reduction AS prix_ht_reduction_4, t0.prix_ttc_reduction AS prix_ttc_reduction_5, t0.prix_ht_without_reduction AS prix_ht_without_reduction_6, t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7, t0.product_name AS product_name_8, t0.type_product AS type_product_9, t0.qty AS qty_10, t0.qty_color AS qty_color_11, t0.qty_noir AS qty_noir_12, t0.commentaire AS commentaire_13, t0.is_reluire AS is_reluire_14, t0.file_papier AS file_papier_15, t0.token AS token_16, t0.file_papier_name AS file_papier_name_17, t0.nbr_papier AS nbr_papier_18, t0.is_default AS is_default_19, t0.file_papier_first_image AS file_papier_first_image_20, t0.imprim_sans_marge AS imprim_sans_marge_21, t0.is_ma_crea AS is_ma_crea_22, t0.is_plus_expert AS is_plus_expert_23, t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24, t0.is_plus_plastification AS is_plus_plastification_25, t0.is_plus_verification AS is_plus_verification_26, t0.finition AS finition_27, t0.is_top_imp AS is_top_imp_28, t0.is_modif AS is_modif_29, t0.real_path_file AS real_path_file_30, t0.is_enveloppe AS is_enveloppe_31, t0.souhaite_str AS souhaite_str_32, t0.is_trait AS is_trait_33, t0.petit_cote AS petit_cote_34, t0.grand_cote AS grand_cote_35, t0.prix_carrier_ht AS prix_carrier_ht_36, t0.prix_carrier_ttc AS prix_carrier_ttc_37, t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38, t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39, t0.date_end AS date_end_40, t0.date_start AS date_start_41, t0.type_livraison_national AS type_livraison_national_42, t0.id_service_point_livraison AS id_service_point_livraison_43, t0.type_livraison30min AS type_livraison30min_44, t0.adresse AS adresse_45, t0.city AS city_46, t0.code_postal AS code_postal_47, t0.country AS country_48, t0.country_code AS country_code_49, t0.lat AS lat_50, t0.longi AS longi_51, t0.template_id_crello AS template_id_crello_52, t0.mauvais_format AS mauvais_format_53, t0.color_lab_token_product AS color_lab_token_product_54, t0.color_lab_id_product AS color_lab_id_product_55, t0.is_exaprint AS is_exaprint_56, t0.is_decoupe_doc AS is_decoupe_doc_57, t0.is_promo_detail AS is_promo_detail_58, t0.format_largeur AS format_largeur_59, t0.format_hauteur AS format_hauteur_60, t0.date_estime_livraison_national AS date_estime_livraison_national_61, t0.product_id AS product_id_62, t0.product_attribute_id AS product_attribute_id_63, t0.cart_id AS cart_id_64, t0.carrier_id AS carrier_id_65, t0.imprimeur_id AS imprimeur_id_66 FROM cart_detail t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "4ee32e78ba0f59ff8163b8101f0c938e"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.prix_ht AS prix_ht_2,
  t0.prix_ttc AS prix_ttc_3,
  t0.prix_ht_reduction AS prix_ht_reduction_4,
  t0.prix_ttc_reduction AS prix_ttc_reduction_5,
  t0.prix_ht_without_reduction AS prix_ht_without_reduction_6,
  t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7,
  t0.product_name AS product_name_8,
  t0.type_product AS type_product_9,
  t0.qty AS qty_10,
  t0.qty_color AS qty_color_11,
  t0.qty_noir AS qty_noir_12,
  t0.commentaire AS commentaire_13,
  t0.is_reluire AS is_reluire_14,
  t0.file_papier AS file_papier_15,
  t0.token AS token_16,
  t0.file_papier_name AS file_papier_name_17,
  t0.nbr_papier AS nbr_papier_18,
  t0.is_default AS is_default_19,
  t0.file_papier_first_image AS file_papier_first_image_20,
  t0.imprim_sans_marge AS imprim_sans_marge_21,
  t0.is_ma_crea AS is_ma_crea_22,
  t0.is_plus_expert AS is_plus_expert_23,
  t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24,
  t0.is_plus_plastification AS is_plus_plastification_25,
  t0.is_plus_verification AS is_plus_verification_26,
  t0.finition AS finition_27,
  t0.is_top_imp AS is_top_imp_28,
  t0.is_modif AS is_modif_29,
  t0.real_path_file AS real_path_file_30,
  t0.is_enveloppe AS is_enveloppe_31,
  t0.souhaite_str AS souhaite_str_32,
  t0.is_trait AS is_trait_33,
  t0.petit_cote AS petit_cote_34,
  t0.grand_cote AS grand_cote_35,
  t0.prix_carrier_ht AS prix_carrier_ht_36,
  t0.prix_carrier_ttc AS prix_carrier_ttc_37,
  t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38,
  t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39,
  t0.date_end AS date_end_40,
  t0.date_start AS date_start_41,
  t0.type_livraison_national AS type_livraison_national_42,
  t0.id_service_point_livraison AS id_service_point_livraison_43,
  t0.type_livraison30min AS type_livraison30min_44,
  t0.adresse AS adresse_45,
  t0.city AS city_46,
  t0.code_postal AS code_postal_47,
  t0.country AS country_48,
  t0.country_code AS country_code_49,
  t0.lat AS lat_50,
  t0.longi AS longi_51,
  t0.template_id_crello AS template_id_crello_52,
  t0.mauvais_format AS mauvais_format_53,
  t0.color_lab_token_product AS color_lab_token_product_54,
  t0.color_lab_id_product AS color_lab_id_product_55,
  t0.is_exaprint AS is_exaprint_56,
  t0.is_decoupe_doc AS is_decoupe_doc_57,
  t0.is_promo_detail AS is_promo_detail_58,
  t0.format_largeur AS format_largeur_59,
  t0.format_hauteur AS format_hauteur_60,
  t0.date_estime_livraison_national AS date_estime_livraison_national_61,
  t0.product_id AS product_id_62,
  t0.product_attribute_id AS product_attribute_id_63,
  t0.cart_id AS cart_id_64,
  t0.carrier_id AS carrier_id_65,
  t0.imprimeur_id AS imprimeur_id_66
FROM
  cart_detail t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix_ht AS prix_ht_2, t0.prix_ttc AS prix_ttc_3, t0.prix_ht_reduction AS prix_ht_reduction_4, t0.prix_ttc_reduction AS prix_ttc_reduction_5, t0.prix_ht_without_reduction AS prix_ht_without_reduction_6, t0.prix_ttc_without_reduction AS prix_ttc_without_reduction_7, t0.product_name AS product_name_8, t0.type_product AS type_product_9, t0.qty AS qty_10, t0.qty_color AS qty_color_11, t0.qty_noir AS qty_noir_12, t0.commentaire AS commentaire_13, t0.is_reluire AS is_reluire_14, t0.file_papier AS file_papier_15, t0.token AS token_16, t0.file_papier_name AS file_papier_name_17, t0.nbr_papier AS nbr_papier_18, t0.is_default AS is_default_19, t0.file_papier_first_image AS file_papier_first_image_20, t0.imprim_sans_marge AS imprim_sans_marge_21, t0.is_ma_crea AS is_ma_crea_22, t0.is_plus_expert AS is_plus_expert_23, t0.is_plus_bords_arrondis AS is_plus_bords_arrondis_24, t0.is_plus_plastification AS is_plus_plastification_25, t0.is_plus_verification AS is_plus_verification_26, t0.finition AS finition_27, t0.is_top_imp AS is_top_imp_28, t0.is_modif AS is_modif_29, t0.real_path_file AS real_path_file_30, t0.is_enveloppe AS is_enveloppe_31, t0.souhaite_str AS souhaite_str_32, t0.is_trait AS is_trait_33, t0.petit_cote AS petit_cote_34, t0.grand_cote AS grand_cote_35, t0.prix_carrier_ht AS prix_carrier_ht_36, t0.prix_carrier_ttc AS prix_carrier_ttc_37, t0.prix_carrier_ht_reduction AS prix_carrier_ht_reduction_38, t0.prix_carrier_ttc_reduction AS prix_carrier_ttc_reduction_39, t0.date_end AS date_end_40, t0.date_start AS date_start_41, t0.type_livraison_national AS type_livraison_national_42, t0.id_service_point_livraison AS id_service_point_livraison_43, t0.type_livraison30min AS type_livraison30min_44, t0.adresse AS adresse_45, t0.city AS city_46, t0.code_postal AS code_postal_47, t0.country AS country_48, t0.country_code AS country_code_49, t0.lat AS lat_50, t0.longi AS longi_51, t0.template_id_crello AS template_id_crello_52, t0.mauvais_format AS mauvais_format_53, t0.color_lab_token_product AS color_lab_token_product_54, t0.color_lab_id_product AS color_lab_id_product_55, t0.is_exaprint AS is_exaprint_56, t0.is_decoupe_doc AS is_decoupe_doc_57, t0.is_promo_detail AS is_promo_detail_58, t0.format_largeur AS format_largeur_59, t0.format_hauteur AS format_hauteur_60, t0.date_estime_livraison_national AS date_estime_livraison_national_61, t0.product_id AS product_id_62, t0.product_attribute_id AS product_attribute_id_63, t0.cart_id AS cart_id_64, t0.carrier_id AS carrier_id_65, t0.imprimeur_id AS imprimeur_id_66 FROM cart_detail t0 WHERE t0.token = '4ee32e78ba0f59ff8163b8101f0c938e' LIMIT 1;

0.10 ms
(0.00%)

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

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

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 = 'Fr' AND t0.is_enabled = 1 LIMIT 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\CartDetail	No errors.
App\Entity\Product	The mappings App\Entity\Product#productImageMobile and App\Entity\ProductImageMobile#product are inconsistent with each other.
App\Entity\ProductAttribute	No errors.
App\Entity\Cart	No errors.
App\Entity\Carrier	No errors.
App\Entity\Imprimeur	No errors.
App\Entity\CartDetailAccessoire	No errors.
App\Entity\CartDetailAdresse	No errors.
App\Entity\CartDetailPhotos	No errors.

Symfony Profiler

https://preprod.copees.com/fr/download-doc/4ee32e78ba0f59ff8163b8101f0c938e

Configuration Settings

Theme