3.93 ms (13.17%)
1
SELECT c0_ . id AS id_0 , c0_ . session_id AS session_id_1 , c0_ . status AS status_2 , c0_ . last_activity_at AS last_activity_at_3 , c0_ . email AS email_4 , c0_ . firstname AS firstname_5 , c0_ . lastname AS lastname_6 , c0_ . telephone AS telephone_7 , c0_ . company_name AS company_name_8 , c0_ . cin AS cin_9 , c0_ . vat_id AS vat_id_10 , c0_ . pickup_point_id AS pickup_point_id_11 , c0_ . pickup_point_name AS pickup_point_name_12 , c0_ . note AS note_13 , c0_ . newsletter_consent AS newsletter_consent_14 , c0_ . gdpr_consent AS gdpr_consent_15 , c0_ . payment_method AS payment_method_16 , c0_ . tracking_heureka_opt_out AS tracking_heureka_opt_out_17 , c0_ . tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18 , c0_ . created_at AS created_at_19 , c0_ . updated_at AS updated_at_20 , c0_ . address_street AS address_street_21 , c0_ . address_descriptive_number AS address_descriptive_number_22 , c0_ . address_city AS address_city_23 , c0_ . address_country AS address_country_24 , c0_ . address_zip_code AS address_zip_code_25 , c0_ . invoice_street AS invoice_street_26 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_27 , c0_ . invoice_city AS invoice_city_28 , c0_ . invoice_country AS invoice_country_29 , c0_ . invoice_zip_code AS invoice_zip_code_30 , c1_ . id AS id_31 , c1_ . quantity AS quantity_32 , c1_ . is_gift AS is_gift_33 , c1_ . created_at AS created_at_34 , c1_ . updated_at AS updated_at_35 , p2_ . id AS id_36 , p2_ . public_id AS public_id_37 , p2_ . code AS code_38 , p2_ . is_default AS is_default_39 , p2_ . weight_modification AS weight_modification_40 , p2_ . price_modification_amount AS price_modification_amount_41 , p2_ . price_modification_currency AS price_modification_currency_42 , p2_ . stock_stock AS stock_stock_43 , p2_ . stock_reserved AS stock_reserved_44 , p3_ . id AS id_45 , p3_ . public_id AS public_id_46 , p3_ . name AS name_47 , p3_ . description AS description_48 , p3_ . short_description AS short_description_49 , p3_ . code AS code_50 , p3_ . ean AS ean_51 , p3_ . unit AS unit_52 , p3_ . active AS active_53 , p3_ . can_be_bought AS can_be_bought_54 , p3_ . searchable AS searchable_55 , p3_ . show_price AS show_price_56 , p3_ . in_stock_text AS in_stock_text_57 , p3_ . out_of_stock_text AS out_of_stock_text_58 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_59 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_60 , p3_ . search_vector_cs AS search_vector_cs_61 , p3_ . search_vector_en AS search_vector_en_62 , p3_ . seo_title AS seo_title_63 , p3_ . seo_description AS seo_description_64 , p3_ . seo_url AS seo_url_65 , p3_ . stock_stock AS stock_stock_66 , p3_ . stock_reserved AS stock_reserved_67 , p3_ . logistic_weight AS logistic_weight_68 , p3_ . logistic_size_width AS logistic_size_width_69 , p3_ . logistic_size_height AS logistic_size_height_70 , p3_ . logistic_size_length AS logistic_size_length_71 , p3_ . price_amount AS price_amount_72 , p3_ . price_currency AS price_currency_73 , p3_ . purchase_price_amount AS purchase_price_amount_74 , p3_ . purchase_price_currency AS purchase_price_currency_75 , c0_ . customer_id AS customer_id_76 , c0_ . shipping_method_id AS shipping_method_id_77 , c0_ . discount_code_id AS discount_code_id_78 , c1_ . cart_id AS cart_id_79 , c1_ . product_variant_id AS product_variant_id_80 , p2_ . product_id AS product_id_81 , p3_ . vat_id AS vat_id_82 , p3_ . main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_ . id = c1_ . cart_id LEFT JOIN product_variant p2_ ON c1_ . product_variant_id = p2_ . id LEFT JOIN product p3_ ON p2_ . product_id = p3_ . id WHERE c0_ . session_id = ? AND c0_ . status = ? ORDER BY c1_ . id ASC
Parameters :
[
"493c38f0974f0cc85533d82c77bf5892 "
"active "
]
SELECT
c0_ . id AS id_0 ,
c0_ . session_id AS session_id_1 ,
c0_ . status AS status_2 ,
c0_ . last_activity_at AS last_activity_at_3 ,
c0_ . email AS email_4 ,
c0_ . firstname AS firstname_5 ,
c0_ . lastname AS lastname_6 ,
c0_ . telephone AS telephone_7 ,
c0_ . company_name AS company_name_8 ,
c0_ . cin AS cin_9 ,
c0_ . vat_id AS vat_id_10 ,
c0_ . pickup_point_id AS pickup_point_id_11 ,
c0_ . pickup_point_name AS pickup_point_name_12 ,
c0_ . note AS note_13 ,
c0_ . newsletter_consent AS newsletter_consent_14 ,
c0_ . gdpr_consent AS gdpr_consent_15 ,
c0_ . payment_method AS payment_method_16 ,
c0_ . tracking_heureka_opt_out AS tracking_heureka_opt_out_17 ,
c0_ . tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18 ,
c0_ . created_at AS created_at_19 ,
c0_ . updated_at AS updated_at_20 ,
c0_ . address_street AS address_street_21 ,
c0_ . address_descriptive_number AS address_descriptive_number_22 ,
c0_ . address_city AS address_city_23 ,
c0_ . address_country AS address_country_24 ,
c0_ . address_zip_code AS address_zip_code_25 ,
c0_ . invoice_street AS invoice_street_26 ,
c0_ . invoice_descriptive_number AS invoice_descriptive_number_27 ,
c0_ . invoice_city AS invoice_city_28 ,
c0_ . invoice_country AS invoice_country_29 ,
c0_ . invoice_zip_code AS invoice_zip_code_30 ,
c1_ . id AS id_31 ,
c1_ . quantity AS quantity_32 ,
c1_ . is_gift AS is_gift_33 ,
c1_ . created_at AS created_at_34 ,
c1_ . updated_at AS updated_at_35 ,
p2_ . id AS id_36 ,
p2_ . public_id AS public_id_37 ,
p2_ . code AS code_38 ,
p2_ . is_default AS is_default_39 ,
p2_ . weight_modification AS weight_modification_40 ,
p2_ . price_modification_amount AS price_modification_amount_41 ,
p2_ . price_modification_currency AS price_modification_currency_42 ,
p2_ . stock_stock AS stock_stock_43 ,
p2_ . stock_reserved AS stock_reserved_44 ,
p3_ . id AS id_45 ,
p3_ . public_id AS public_id_46 ,
p3_ . name AS name_47 ,
p3_ . description AS description_48 ,
p3_ . short_description AS short_description_49 ,
p3_ . code AS code_50 ,
p3_ . ean AS ean_51 ,
p3_ . unit AS unit_52 ,
p3_ . active AS active_53 ,
p3_ . can_be_bought AS can_be_bought_54 ,
p3_ . searchable AS searchable_55 ,
p3_ . show_price AS show_price_56 ,
p3_ . in_stock_text AS in_stock_text_57 ,
p3_ . out_of_stock_text AS out_of_stock_text_58 ,
p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_59 ,
p3_ . filter_variant_value_ids AS filter_variant_value_ids_60 ,
p3_ . search_vector_cs AS search_vector_cs_61 ,
p3_ . search_vector_en AS search_vector_en_62 ,
p3_ . seo_title AS seo_title_63 ,
p3_ . seo_description AS seo_description_64 ,
p3_ . seo_url AS seo_url_65 ,
p3_ . stock_stock AS stock_stock_66 ,
p3_ . stock_reserved AS stock_reserved_67 ,
p3_ . logistic_weight AS logistic_weight_68 ,
p3_ . logistic_size_width AS logistic_size_width_69 ,
p3_ . logistic_size_height AS logistic_size_height_70 ,
p3_ . logistic_size_length AS logistic_size_length_71 ,
p3_ . price_amount AS price_amount_72 ,
p3_ . price_currency AS price_currency_73 ,
p3_ . purchase_price_amount AS purchase_price_amount_74 ,
p3_ . purchase_price_currency AS purchase_price_currency_75 ,
c0_ . customer_id AS customer_id_76 ,
c0_ . shipping_method_id AS shipping_method_id_77 ,
c0_ . discount_code_id AS discount_code_id_78 ,
c1_ . cart_id AS cart_id_79 ,
c1_ . product_variant_id AS product_variant_id_80 ,
p2_ . product_id AS product_id_81 ,
p3_ . vat_id AS vat_id_82 ,
p3_ . main_category_id AS main_category_id_83
FROM
cart c0_
LEFT JOIN cart_item c1_ ON c0_ . id = c1_ . cart_id
LEFT JOIN product_variant p2_ ON c1_ . product_variant_id = p2_ . id
LEFT JOIN product p3_ ON p2_ . product_id = p3_ . id
WHERE
c0_ . session_id = ?
AND c0_ . status = ?
ORDER BY
c1_ . id ASC
Copy
SELECT c0_ . id AS id_0 , c0_ . session_id AS session_id_1 , c0_ . status AS status_2 , c0_ . last_activity_at AS last_activity_at_3 , c0_ . email AS email_4 , c0_ . firstname AS firstname_5 , c0_ . lastname AS lastname_6 , c0_ . telephone AS telephone_7 , c0_ . company_name AS company_name_8 , c0_ . cin AS cin_9 , c0_ . vat_id AS vat_id_10 , c0_ . pickup_point_id AS pickup_point_id_11 , c0_ . pickup_point_name AS pickup_point_name_12 , c0_ . note AS note_13 , c0_ . newsletter_consent AS newsletter_consent_14 , c0_ . gdpr_consent AS gdpr_consent_15 , c0_ . payment_method AS payment_method_16 , c0_ . tracking_heureka_opt_out AS tracking_heureka_opt_out_17 , c0_ . tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18 , c0_ . created_at AS created_at_19 , c0_ . updated_at AS updated_at_20 , c0_ . address_street AS address_street_21 , c0_ . address_descriptive_number AS address_descriptive_number_22 , c0_ . address_city AS address_city_23 , c0_ . address_country AS address_country_24 , c0_ . address_zip_code AS address_zip_code_25 , c0_ . invoice_street AS invoice_street_26 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_27 , c0_ . invoice_city AS invoice_city_28 , c0_ . invoice_country AS invoice_country_29 , c0_ . invoice_zip_code AS invoice_zip_code_30 , c1_ . id AS id_31 , c1_ . quantity AS quantity_32 , c1_ . is_gift AS is_gift_33 , c1_ . created_at AS created_at_34 , c1_ . updated_at AS updated_at_35 , p2_ . id AS id_36 , p2_ . public_id AS public_id_37 , p2_ . code AS code_38 , p2_ . is_default AS is_default_39 , p2_ . weight_modification AS weight_modification_40 , p2_ . price_modification_amount AS price_modification_amount_41 , p2_ . price_modification_currency AS price_modification_currency_42 , p2_ . stock_stock AS stock_stock_43 , p2_ . stock_reserved AS stock_reserved_44 , p3_ . id AS id_45 , p3_ . public_id AS public_id_46 , p3_ . name AS name_47 , p3_ . description AS description_48 , p3_ . short_description AS short_description_49 , p3_ . code AS code_50 , p3_ . ean AS ean_51 , p3_ . unit AS unit_52 , p3_ . active AS active_53 , p3_ . can_be_bought AS can_be_bought_54 , p3_ . searchable AS searchable_55 , p3_ . show_price AS show_price_56 , p3_ . in_stock_text AS in_stock_text_57 , p3_ . out_of_stock_text AS out_of_stock_text_58 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_59 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_60 , p3_ . search_vector_cs AS search_vector_cs_61 , p3_ . search_vector_en AS search_vector_en_62 , p3_ . seo_title AS seo_title_63 , p3_ . seo_description AS seo_description_64 , p3_ . seo_url AS seo_url_65 , p3_ . stock_stock AS stock_stock_66 , p3_ . stock_reserved AS stock_reserved_67 , p3_ . logistic_weight AS logistic_weight_68 , p3_ . logistic_size_width AS logistic_size_width_69 , p3_ . logistic_size_height AS logistic_size_height_70 , p3_ . logistic_size_length AS logistic_size_length_71 , p3_ . price_amount AS price_amount_72 , p3_ . price_currency AS price_currency_73 , p3_ . purchase_price_amount AS purchase_price_amount_74 , p3_ . purchase_price_currency AS purchase_price_currency_75 , c0_ . customer_id AS customer_id_76 , c0_ . shipping_method_id AS shipping_method_id_77 , c0_ . discount_code_id AS discount_code_id_78 , c1_ . cart_id AS cart_id_79 , c1_ . product_variant_id AS product_variant_id_80 , p2_ . product_id AS product_id_81 , p3_ . vat_id AS vat_id_82 , p3_ . main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_ . id = c1_ . cart_id LEFT JOIN product_variant p2_ ON c1_ . product_variant_id = p2_ . id LEFT JOIN product p3_ ON p2_ . product_id = p3_ . id WHERE c0_ . session_id = '493c38f0974f0cc85533d82c77bf5892' AND c0_ . status = 'active' ORDER BY c1_ . id ASC ;
Copy
1.23 ms (4.13%)
1
INSERT INTO cart (id , session_id , status , last_activity_at , email , firstname , lastname , telephone , company_name , cin , vat_id , pickup_point_id , pickup_point_name , note , newsletter_consent , gdpr_consent , payment_method , tracking_heureka_opt_out , tracking_zbozi_opt_in , created_at , updated_at , address_street , address_descriptive_number , address_city , address_country , address_zip_code , invoice_street , invoice_descriptive_number , invoice_city , invoice_country , invoice_zip_code , customer_id , shipping_method_id , discount_code_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"9f4a8ca6-3bff-4b0b-9c72-1c9fe17bdddb "
"493c38f0974f0cc85533d82c77bf5892 "
"active "
"2026-07-09 03:23:06 "
null
null
null
null
null
null
null
null
null
null
0
0
null
null
null
"2026-07-09 03:23:06 "
"2026-07-09 03:23:06 "
null
null
null
null
null
null
null
null
null
null
null
null
null
]
INSERT INTO cart (
id , session_id , status , last_activity_at ,
email , firstname , lastname , telephone ,
company_name , cin , vat_id , pickup_point_id ,
pickup_point_name , note , newsletter_consent ,
gdpr_consent , payment_method , tracking_heureka_opt_out ,
tracking_zbozi_opt_in , created_at ,
updated_at , address_street , address_descriptive_number ,
address_city , address_country , address_zip_code ,
invoice_street , invoice_descriptive_number ,
invoice_city , invoice_country , invoice_zip_code ,
customer_id , shipping_method_id ,
discount_code_id
)
VALUES
(
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ?
)
Copy
INSERT INTO cart (id , session_id , status , last_activity_at , email , firstname , lastname , telephone , company_name , cin , vat_id , pickup_point_id , pickup_point_name , note , newsletter_consent , gdpr_consent , payment_method , tracking_heureka_opt_out , tracking_zbozi_opt_in , created_at , updated_at , address_street , address_descriptive_number , address_city , address_country , address_zip_code , invoice_street , invoice_descriptive_number , invoice_city , invoice_country , invoice_zip_code , customer_id , shipping_method_id , discount_code_id ) VALUES ('9f4a8ca6-3bff-4b0b-9c72-1c9fe17bdddb' , '493c38f0974f0cc85533d82c77bf5892' , 'active' , '2026-07-09 03:23:06' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 0 , 0 , NULL , NULL , NULL , '2026-07-09 03:23:06' , '2026-07-09 03:23:06' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL );
Copy