https://pim.vivog.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CFront%255CModules%255CMenuController%253A%253Amain

Method
GET
HTTP Status
200
IP
88.177.143.203
Profiled on
Token
e7710e

Query Metrics

111 Database Queries
24 Different statements
38.23 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.26 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.38 ms 
SELECT t0.customers_id AS customers_id_1, t0.purchased_without_account AS purchased_without_account_2, t0.customers_gender AS customers_gender_3, t0.customers_firstname AS customers_firstname_4, t0.customers_lastname AS customers_lastname_5, t0.customers_dob AS customers_dob_6, t0.customers_email_address AS customers_email_address_7, t0.customers_telephone AS customers_telephone_8, t0.customers_fax AS customers_fax_9, t0.customers_tva AS customers_tva_10, t0.customers_siret AS customers_siret_11, t0.customers_elevage AS customers_elevage_12, t0.customers_affixe AS customers_affixe_13, t0.customers_password AS customers_password_14, t0.customers_newsletter AS customers_newsletter_15, t0.customers_selected_template AS customers_selected_template_16, t0.customers_group_ra AS customers_group_ra_17, t0.customers_payment_allowed AS customers_payment_allowed_18, t0.customers_shipment_allowed AS customers_shipment_allowed_19, t0.customers_validation_code AS customers_validation_code_20, t0.customers_validation AS customers_validation_21, t0.customers_email_registered AS customers_email_registered_22, t0.customers_sage AS customers_sage_23, t0.customers_sap_id AS customers_sap_id_24, t0.customers_company AS customers_company_25, t0.customers_referent AS customers_referent_26, t0.customers_metier AS customers_metier_27, t0.customers_metier_sap AS customers_metier_sap_28, t0.customers_autreprecisez AS customers_autreprecisez_29, t0.customers_pai_differe AS customers_pai_differe_30, t0.customers_exclu_TVA AS customers_exclu_TVA_31, t0.customers_invoice_type AS customers_invoice_type_32, t0.customers_last_login AS customers_last_login_33, t0.customers_creation AS customers_creation_34, t0.customers_nblogin AS customers_nblogin_35, t0.customers_account_update AS customers_account_update_36, t0.customers_status AS customers_status_37, t0.customers_expert AS customers_expert_38, t0.customers_expert_id AS customers_expert_id_39, t0.customers_consent_ad_products AS customers_consent_ad_products_40, t0.customers_consent_ad_others AS customers_consent_ad_others_41, t0.customers_consent_group AS customers_consent_group_42, t0.customers_default_address_id AS customers_default_address_id_43, t0.languages_id AS languages_id_44, t0.customers_group_id AS customers_group_id_45 FROM customers t0 WHERE t0.customers_id = ?
Parameters: 
[
  39158
]
View formatted query    View runnable query    Explain query
3 0.19 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
4 0.23 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
5 0.18 ms 
SELECT t0.address_book_id AS address_book_id_1, t0.entry_gender AS entry_gender_2, t0.entry_company AS entry_company_3, t0.entry_company_tax_id AS entry_company_tax_id_4, t0.entry_firstname AS entry_firstname_5, t0.entry_lastname AS entry_lastname_6, t0.entry_street_address AS entry_street_address_7, t0.entry_suburb AS entry_suburb_8, t0.entry_postcode AS entry_postcode_9, t0.entry_city AS entry_city_10, t0.entry_state AS entry_state_11, t0.entry_phone AS entry_phone_12, t0.entry_email AS entry_email_13, t0.entry_zone_id AS entry_zone_id_14, t0.customers_id AS customers_id_15, t0.entry_country_id AS entry_country_id_16 FROM address_book t0 WHERE t0.address_book_id = ?
Parameters: 
[
  74240
]
View formatted query    View runnable query    Explain query
6 0.19 ms 
SELECT t0.id AS id_1, t0.from_cart_amount AS from_cart_amount_2, t0.price AS price_3, t0.carrier_id AS carrier_id_4, t0.countries_id AS countries_id_5 FROM shipping_rates t0 WHERE t0.countries_id = ?
Parameters: 
[
  73
]
View formatted query    View runnable query    Explain query
7 0.20 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.final_price AS final_price_3, t0.total_price AS total_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8 FROM carts_items t0 WHERE t0.cart_id = ?
Parameters: 
[
  24377
]
View formatted query    View runnable query    Explain query
8 0.30 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = ?
Parameters: 
[
  20645
]
View formatted query    View runnable query    Explain query
9 0.29 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = ?
Parameters: 
[
  20641
]
View formatted query    View runnable query    Explain query
10 0.29 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = ?
Parameters: 
[
  20644
]
View formatted query    View runnable query    Explain query
11 15.38 ms 
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.products_code AS products_code_65, p0_.is_default_variant AS is_default_variant_66, p0_.products_parent_id AS products_parent_id_67, p0_.products_model_id AS products_model_id_68, p0_.manufacturers_id AS manufacturers_id_69, p0_.products_tax_class_id AS products_tax_class_id_70 FROM products p0_ WHERE p0_.products_status = 1 AND p0_.products_gift = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 0.25 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id IN (?, ?, ?) AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20645
  20641
  20644
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
13 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
14 0.22 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
15 0.18 ms 
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters: 
[
  20645
]
View formatted query    View runnable query    Explain query
16 0.25 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
17 0.18 ms 
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.manufacturers_name AS manufacturers_name_3, t0.manufacturers_image AS manufacturers_image_4, t0.date_added AS date_added_5, t0.last_modified AS last_modified_6, t0.manufacturers_statuts AS manufacturers_statuts_7, t0.manufacturers_order AS manufacturers_order_8, t0.manufacturers_locked_price AS manufacturers_locked_price_9, t0.manufacturers_welcome AS manufacturers_welcome_10, t0.manufacturers_export AS manufacturers_export_11 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters: 
[
  330
]
View formatted query    View runnable query    Explain query
18 0.23 ms 
SELECT t0.countries_id AS countries_id_1, t0.countries_name AS countries_name_2, t0.countries_iso_code_2 AS countries_iso_code_2_3, t0.countries_iso_code_3 AS countries_iso_code_3_4, t0.address_format_id AS address_format_id_5, t0.countries_distri_name AS countries_distri_name_6, t0.countries_adresse AS countries_adresse_7, t0.countries_website AS countries_website_8, t0.countries_url AS countries_url_9, t0.countries_tel AS countries_tel_10, t0.countries_logo AS countries_logo_11, t0.countries_blocage AS countries_blocage_12, t0.countries_commercial AS countries_commercial_13, t0.countries_texte_prix01 AS countries_texte_prix01_14, t0.countries_texte_prix02 AS countries_texte_prix02_15, t0.countries_texte_email01 AS countries_texte_email01_16, t0.countries_email AS countries_email_17, t0.countries_soleil AS countries_soleil_18, t0.countries_bienvenue AS countries_bienvenue_19, t0.countries_rank AS countries_rank_20 FROM countries t0 WHERE t0.countries_id = ?
Parameters: 
[
  73
]
View formatted query    View runnable query    Explain query
19 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
20 0.18 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
21 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
22 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
23 0.23 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
24 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
25 0.20 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
26 0.12 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
27 0.19 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
28 0.18 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
29 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
30 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
31 0.15 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
32 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
33 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
34 0.12 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
35 0.08 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
36 0.15 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
37 0.11 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
38 0.19 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
39 0.19 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20645
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
40 0.11 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
41 0.18 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
42 0.13 ms 
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters: 
[
  20641
]
View formatted query    View runnable query    Explain query
43 0.12 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
44 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
45 0.21 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
46 0.12 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
47 0.20 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
48 0.22 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
49 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
50 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
51 0.16 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
52 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
53 0.19 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
54 0.12 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
55 0.16 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
56 0.17 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
57 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
58 0.21 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
59 0.17 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
60 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
61 0.18 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
62 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
63 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
64 0.17 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20641
  "2026-09-07 09:17:13"
  "2026-09-07 09:17:13"
]
View formatted query    View runnable query    Explain query
65 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
66 0.16 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
67 0.18 ms 
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters: 
[
  20644
]
View formatted query    View runnable query    Explain query
68 0.17 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
69 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
70 0.17 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
71 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
72 0.18 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
73 0.22 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
74 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
75 0.16 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
76 0.12 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
77 0.16 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
78 0.20 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
79 0.15 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
80 0.15 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
81 0.16 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
82 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
83 0.20 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
84 0.15 ms 
SELECT s0_.specials_id AS specials_id_0, s0_.specials_new_products_price AS specials_new_products_price_1, s0_.specials_date_added AS specials_date_added_2, s0_.specials_last_modified AS specials_last_modified_3, s0_.expires_date AS expires_date_4, s0_.date_status_change AS date_status_change_5, s0_.status AS status_6, s0_.products_id AS products_id_7, s0_.customers_group_id AS customers_group_id_8 FROM specials s0_ WHERE s0_.products_id = ? AND s0_.date_status_change <= ? AND s0_.expires_date >= ? LIMIT 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
85 0.14 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
86 0.15 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
87 0.13 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
88 0.15 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
89 0.14 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
90 0.07 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
91 0.17 ms 
UPDATE carts_items SET final_price = ?, total_price = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  14.75
  88.5
  "2026-09-07 09:17:14"
  137684
]
View formatted query    View runnable query    Explain query
92 0.16 ms 
UPDATE carts_items SET final_price = ?, total_price = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  5.83
  5.83
  "2026-09-07 09:17:14"
  137685
]
View formatted query    View runnable query    Explain query
93 0.15 ms 
UPDATE carts_items SET final_price = ?, total_price = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  9.92
  9.92
  "2026-09-07 09:17:14"
  137686
]
View formatted query    View runnable query    Explain query
94 3.35 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
95 0.22 ms 
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters: 
[
  20645
]
View formatted query    View runnable query    Explain query
96 0.18 ms 
SELECT t0.tax_class_id AS tax_class_id_1, t0.tax_class_title AS tax_class_title_2, t0.tax_class_description AS tax_class_description_3, t0.last_modified AS last_modified_4, t0.date_added AS date_added_5 FROM tax_class t0 WHERE t0.tax_class_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
97 0.28 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_parent_id = ?
Parameters: 
[
  20645
]
View formatted query    View runnable query    Explain query
98 0.22 ms 
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters: 
[
  20641
]
View formatted query    View runnable query    Explain query
99 0.30 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_parent_id = ?
Parameters: 
[
  20641
]
View formatted query    View runnable query    Explain query
100 0.22 ms 
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters: 
[
  20644
]
View formatted query    View runnable query    Explain query
101 0.32 ms 
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_parent_id = ?
Parameters: 
[
  20644
]
View formatted query    View runnable query    Explain query
102 0.21 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20645
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
103 0.19 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20641
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
104 0.23 ms 
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters: 
[
  20644
  "2026-09-07 09:17:14"
  "2026-09-07 09:17:14"
]
View formatted query    View runnable query    Explain query
105 0.18 ms 
SELECT t0.id AS id_1, t0.sap_id AS sap_id_2, t0.customers_id AS customers_id_3, t0.price_group_id AS price_group_id_4 FROM customers_price_groups t0 WHERE t0.customers_id = ?
Parameters: 
[
  39158
]
View formatted query    View runnable query    Explain query
106 0.18 ms 
SELECT count(w0_.ID) AS sclr_0 FROM wishlists w0_ WHERE w0_.customers_id = ?
Parameters: 
[
  39158
]
View formatted query    View runnable query    Explain query
107 0.15 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "VV"
]
View formatted query    View runnable query    Explain query
108 0.15 ms 
SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = ? AND t0.price_group_id = ? LIMIT 1
Parameters: 
[
  39158
  1
]
View formatted query    View runnable query    Explain query
109 0.24 ms 
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters: 
[
  20645
]
View formatted query    View runnable query    Explain query
110 0.22 ms 
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters: 
[
  20641
]
View formatted query    View runnable query    Explain query
111 0.19 ms 
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters: 
[
  20644
]
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\PriceGroup No errors.
App\Entity\Customer No errors.
App\Entity\Address No errors.
App\Entity\Language No errors.
App\Entity\CustomerGroup No errors.
App\Entity\CustomerPriceGroup No errors.
App\Entity\Cart No errors.
App\Entity\Carrier No errors.
App\Entity\PaymentMean No errors.
App\Entity\CartItem No errors.
App\Entity\ShippingRate No errors.
App\Entity\Country No errors.
App\Entity\Product No errors.
App\Entity\ProductModel No errors.
App\Entity\Manufacturer No errors.
App\Entity\TaxClass No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductDescription No errors.
App\Entity\Picture No errors.
App\Entity\PictureProduct No errors.
App\Entity\ProductCountryRestriction No errors.
App\Entity\ProductToProductExtraField No errors.
App\Entity\ProductPrice No errors.
App\Entity\MarketingRule No errors.
App\Entity\MarketingRuleProductDiscounted No errors.
App\Entity\SpecialPrice No errors.
App\Entity\ManufacturerDescription No errors.
App\Entity\ManufacturerCountry No errors.
App\Entity\ProductModelVariant No errors.
App\Entity\TaxRate No errors.
App\Entity\ProductModelAttribute No errors.
App\Entity\ProductModelDescription No errors.
App\Entity\ProductModelCountryRestriction No errors.
App\Entity\Attribute No errors.
App\Entity\ProductAttributeDescription No errors.
App\Entity\PictureDescription No errors.
App\Entity\ProductExtraField No errors.
App\Entity\MarketingRuleDescription No errors.
App\Entity\MarketingRuleProductRequested No errors.
App\Entity\Coupon No errors.
App\Entity\MarketingRuleCustomer No errors.
App\Entity\WishlistProduct No errors.
App\Entity\AttributeDescription No errors.