1
1.01 ms
SELECT e0_ . id AS id_0 , e0_ . exchange_rate AS exchange_rate_1 , e0_ . last_automatic_update AS last_automatic_update_2 , e0_ . created_at AS created_at_3 , e0_ . updated_at AS updated_at_4 , e0_ . currency_from_id AS currency_from_id_5 , e0_ . currency_to_id AS currency_to_id_6 FROM exchange_rate e0_
SELECT e0_ . id AS id_0 , e0_ . exchange_rate AS exchange_rate_1 , e0_ . last_automatic_update AS last_automatic_update_2 , e0_ . created_at AS created_at_3 , e0_ . updated_at AS updated_at_4 , e0_ . currency_from_id AS currency_from_id_5 , e0_ . currency_to_id AS currency_to_id_6 FROM exchange_rate e0_ ;
Copy
2
1.17 ms
SELECT r0_ . id AS id_0 , r0_ . source AS source_1 , r0_ . destination AS destination_2 , r0_ . active AS active_3 , r0_ . status_code AS status_code_4 , r0_ . created_at AS created_at_5 , r0_ . updated_at AS updated_at_6 FROM redirect_route r0_ WHERE r0_ . source = ?
Parameters :
[
"/cs/panske-tenisky/763-produkt-22 "
]
SELECT r0_ . id AS id_0 , r0_ . source AS source_1 , r0_ . destination AS destination_2 , r0_ . active AS active_3 , r0_ . status_code AS status_code_4 , r0_ . created_at AS created_at_5 , r0_ . updated_at AS updated_at_6 FROM redirect_route r0_ WHERE r0_ . source = '/cs/panske-tenisky/763-produkt-22' ;
Copy
3
1.40 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = ?
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = 1 ;
Copy
4
0.80 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = ?
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = 1 ;
Copy
5
0.84 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC ;
Copy
6
0.87 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = ?
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = 1 ;
Copy
7
4.00 ms
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 :
[
"820d1739a6670444bb6289ad905ab8e0 "
"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 = '820d1739a6670444bb6289ad905ab8e0' AND c0_ . status = 'active' ORDER BY c1_ . id ASC ;
Copy
8
0.31 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
9
0.93 ms
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 :
[
"6596ac6a-553f-4b24-9f0e-1db2405e7243 "
"820d1739a6670444bb6289ad905ab8e0 "
"active "
"2026-07-09 04:35:06 "
null
null
null
null
null
null
null
null
null
null
0
0
null
null
null
"2026-07-09 04:35:06 "
"2026-07-09 04:35: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 ('6596ac6a-553f-4b24-9f0e-1db2405e7243' , '820d1739a6670444bb6289ad905ab8e0' , 'active' , '2026-07-09 04:35:06' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 0 , 0 , NULL , NULL , NULL , '2026-07-09 04:35:06' , '2026-07-09 04:35:06' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL );
Copy
10
0.87 ms
"COMMIT"
11
0.69 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . short_description AS short_description_5 , t0 . code AS code_6 , t0 . ean AS ean_7 , t0 . unit AS unit_8 , t0 . active AS active_9 , t0 . can_be_bought AS can_be_bought_10 , t0 . searchable AS searchable_11 , t0 . show_price AS show_price_12 , t0 . in_stock_text AS in_stock_text_13 , t0 . out_of_stock_text AS out_of_stock_text_14 , t0 . filter_parameter_value_ids AS filter_parameter_value_ids_15 , t0 . filter_variant_value_ids AS filter_variant_value_ids_16 , t0 . search_vector_cs AS search_vector_cs_17 , t0 . search_vector_en AS search_vector_en_18 , t0 . seo_title AS seo_title_19 , t0 . seo_description AS seo_description_20 , t0 . seo_url AS seo_url_21 , t0 . stock_stock AS stock_stock_22 , t0 . stock_reserved AS stock_reserved_23 , t0 . logistic_weight AS logistic_weight_24 , t0 . logistic_size_width AS logistic_size_width_25 , t0 . logistic_size_height AS logistic_size_height_26 , t0 . logistic_size_length AS logistic_size_length_27 , t0 . price_amount AS price_amount_28 , t0 . price_currency AS price_currency_29 , t0 . purchase_price_amount AS purchase_price_amount_30 , t0 . purchase_price_currency AS purchase_price_currency_31 , t0 . vat_id AS vat_id_32 , t0 . main_category_id AS main_category_id_33 FROM product t0 WHERE t0 . public_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . short_description AS short_description_5 , t0 . code AS code_6 , t0 . ean AS ean_7 , t0 . unit AS unit_8 , t0 . active AS active_9 , t0 . can_be_bought AS can_be_bought_10 , t0 . searchable AS searchable_11 , t0 . show_price AS show_price_12 , t0 . in_stock_text AS in_stock_text_13 , t0 . out_of_stock_text AS out_of_stock_text_14 , t0 . filter_parameter_value_ids AS filter_parameter_value_ids_15 , t0 . filter_variant_value_ids AS filter_variant_value_ids_16 , t0 . search_vector_cs AS search_vector_cs_17 , t0 . search_vector_en AS search_vector_en_18 , t0 . seo_title AS seo_title_19 , t0 . seo_description AS seo_description_20 , t0 . seo_url AS seo_url_21 , t0 . stock_stock AS stock_stock_22 , t0 . stock_reserved AS stock_reserved_23 , t0 . logistic_weight AS logistic_weight_24 , t0 . logistic_size_width AS logistic_size_width_25 , t0 . logistic_size_height AS logistic_size_height_26 , t0 . logistic_size_length AS logistic_size_length_27 , t0 . price_amount AS price_amount_28 , t0 . price_currency AS price_currency_29 , t0 . purchase_price_amount AS purchase_price_amount_30 , t0 . purchase_price_currency AS purchase_price_currency_31 , t0 . vat_id AS vat_id_32 , t0 . main_category_id AS main_category_id_33 FROM product t0 WHERE t0 . public_id = '763' LIMIT 1 ;
Copy
12
0.50 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . code AS code_3 , t0 . is_default AS is_default_4 , t0 . weight_modification AS weight_modification_5 , t0 . price_modification_amount AS price_modification_amount_6 , t0 . price_modification_currency AS price_modification_currency_7 , t0 . stock_stock AS stock_stock_8 , t0 . stock_reserved AS stock_reserved_9 , t0 . product_id AS product_id_10 FROM product_variant t0 WHERE t0 . public_id IS NULL LIMIT 1
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . code AS code_3 , t0 . is_default AS is_default_4 , t0 . weight_modification AS weight_modification_5 , t0 . price_modification_amount AS price_modification_amount_6 , t0 . price_modification_currency AS price_modification_currency_7 , t0 . stock_stock AS stock_stock_8 , t0 . stock_reserved AS stock_reserved_9 , t0 . product_id AS product_id_10 FROM product_variant t0 WHERE t0 . public_id IS NULL LIMIT 1 ;
Copy
13
1.33 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = ?
Parameters :
[
"5c3e1d7a-9f6b-4a0c-1e4d-3b8f0a5c6e7f "
]
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = '5c3e1d7a-9f6b-4a0c-1e4d-3b8f0a5c6e7f' ;
Copy
14
1.82 ms
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 :
[
"820d1739a6670444bb6289ad905ab8e0 "
"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 = '820d1739a6670444bb6289ad905ab8e0' AND c0_ . status = 'active' ORDER BY c1_ . id ASC ;
Copy
15
0.46 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . code AS code_3 , t0 . is_default AS is_default_4 , t0 . weight_modification AS weight_modification_5 , t0 . price_modification_amount AS price_modification_amount_6 , t0 . price_modification_currency AS price_modification_currency_7 , t0 . stock_stock AS stock_stock_8 , t0 . stock_reserved AS stock_reserved_9 , t0 . product_id AS product_id_10 FROM product_variant t0 WHERE (t0 . is_default = ? AND t0 . product_id = ? )
Parameters :
[
1
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . code AS code_3 , t0 . is_default AS is_default_4 , t0 . weight_modification AS weight_modification_5 , t0 . price_modification_amount AS price_modification_amount_6 , t0 . price_modification_currency AS price_modification_currency_7 , t0 . stock_stock AS stock_stock_8 , t0 . stock_reserved AS stock_reserved_9 , t0 . product_id AS product_id_10 FROM product_variant t0 WHERE (t0 . is_default = 1 AND t0 . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' );
Copy
16
0.78 ms
SELECT t0 . id AS id_1 , t0 . is_main AS is_main_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_image t0 WHERE t0 . product_id = ?
Parameters :
[
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . is_main AS is_main_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_image t0 WHERE t0 . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' ;
Copy
17
0.47 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 , t0 . name AS name_4 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"dd33049b-1ec1-4dcc-bbe8-689569353a54 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 , t0 . name AS name_4 FROM file t0 WHERE t0 . id = 'dd33049b-1ec1-4dcc-bbe8-689569353a54' ;
Copy
18
0.83 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = ?
Parameters :
[
"8d6f4e0b-2a9c-4b3d-4f7e-6c1a3b8d9f0e "
]
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = '8d6f4e0b-2a9c-4b3d-4f7e-6c1a3b8d9f0e' ;
Copy
19
0.51 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = ?
Parameters :
[
"4b2d0c6f-8e5a-4f9b-0d3c-2a7e9f4b5d6c "
]
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . slug AS slug_4 , t0 . description AS description_5 , t0 . lft AS lft_6 , t0 . lvl AS lvl_7 , t0 . rgt AS rgt_8 , t0 . position AS position_9 , t0 . seo_title AS seo_title_10 , t0 . seo_description AS seo_description_11 , t0 . seo_url AS seo_url_12 , t0 . image_id AS image_id_13 , t0 . tree_root AS tree_root_14 , t0 . parent_id AS parent_id_15 FROM category t0 WHERE t0 . id = '4b2d0c6f-8e5a-4f9b-0d3c-2a7e9f4b5d6c' ;
Copy
20
0.93 ms
SELECT n0_ . id AS id_0 , n0_ . active AS active_1 , n0_ . content AS content_2 , n0_ . notice_position AS notice_position_3 , n0_ . show_from AS show_from_4 , n0_ . show_to AS show_to_5 , n0_ . background_color AS background_color_6 , n0_ . text_color AS text_color_7 , n0_ . button_background_color AS button_background_color_8 , n0_ . button_hover_background_color AS button_hover_background_color_9 , n0_ . button_text_color AS button_text_color_10 , n0_ . notice_type AS notice_type_11 FROM notice n0_ WHERE n0_ . notice_type IN ('infobar' )
SELECT n0_ . id AS id_0 , n0_ . active AS active_1 , n0_ . content AS content_2 , n0_ . notice_position AS notice_position_3 , n0_ . show_from AS show_from_4 , n0_ . show_to AS show_to_5 , n0_ . background_color AS background_color_6 , n0_ . text_color AS text_color_7 , n0_ . button_background_color AS button_background_color_8 , n0_ . button_hover_background_color AS button_hover_background_color_9 , n0_ . button_text_color AS button_text_color_10 , n0_ . notice_type AS notice_type_11 FROM notice n0_ WHERE n0_ . notice_type IN ('infobar' );
Copy
21
1.33 ms
SELECT c0_ . id AS id_0 , c0_ . public_id AS public_id_1 , c0_ . name AS name_2 , c0_ . slug AS slug_3 , c0_ . description AS description_4 , c0_ . lft AS lft_5 , c0_ . lvl AS lvl_6 , c0_ . rgt AS rgt_7 , c0_ . position AS position_8 , c0_ . seo_title AS seo_title_9 , c0_ . seo_description AS seo_description_10 , c0_ . seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC
SELECT c0_ . id AS id_0 , c0_ . public_id AS public_id_1 , c0_ . name AS name_2 , c0_ . slug AS slug_3 , c0_ . description AS description_4 , c0_ . lft AS lft_5 , c0_ . lvl AS lvl_6 , c0_ . rgt AS rgt_7 , c0_ . position AS position_8 , c0_ . seo_title AS seo_title_9 , c0_ . seo_description AS seo_description_10 , c0_ . seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC ;
Copy
22
1.77 ms
SELECT s0_ . id AS id_0 , s0_ . public_id AS public_id_1 , s0_ . title AS title_2 , s0_ . slug AS slug_3 , s0_ . content AS content_4 , s0_ . show_contact_form AS show_contact_form_5 , s0_ . active AS active_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s0_ . seo_title AS seo_title_9 , s0_ . seo_description AS seo_description_10 , s0_ . seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_ . active = true ORDER BY s0_ . created_at ASC
SELECT s0_ . id AS id_0 , s0_ . public_id AS public_id_1 , s0_ . title AS title_2 , s0_ . slug AS slug_3 , s0_ . content AS content_4 , s0_ . show_contact_form AS show_contact_form_5 , s0_ . active AS active_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s0_ . seo_title AS seo_title_9 , s0_ . seo_description AS seo_description_10 , s0_ . seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_ . active = true ORDER BY s0_ . created_at ASC ;
Copy
23
0.99 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = ?
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = 1 ;
Copy
24
0.70 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC ;
Copy
25
0.89 ms
SELECT s0_ . id AS id_0 , s0_ . public_id AS public_id_1 , s0_ . title AS title_2 , s0_ . slug AS slug_3 , s0_ . content AS content_4 , s0_ . show_contact_form AS show_contact_form_5 , s0_ . active AS active_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s0_ . seo_title AS seo_title_9 , s0_ . seo_description AS seo_description_10 , s0_ . seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_ . active = true ORDER BY s0_ . created_at ASC
SELECT s0_ . id AS id_0 , s0_ . public_id AS public_id_1 , s0_ . title AS title_2 , s0_ . slug AS slug_3 , s0_ . content AS content_4 , s0_ . show_contact_form AS show_contact_form_5 , s0_ . active AS active_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s0_ . seo_title AS seo_title_9 , s0_ . seo_description AS seo_description_10 , s0_ . seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_ . active = true ORDER BY s0_ . created_at ASC ;
Copy
26
0.77 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = ?
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id WHERE c0_ . is_default = 1 ;
Copy
27
0.52 ms
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC
SELECT c0_ . code AS code_0 , c0_ . is_default AS is_default_1 , c0_ . is_active AS is_active_2 , c0_ . decimal_places AS decimal_places_3 , e1_ . id AS id_4 , e1_ . exchange_rate AS exchange_rate_5 , e1_ . last_automatic_update AS last_automatic_update_6 , e1_ . created_at AS created_at_7 , e1_ . updated_at AS updated_at_8 , e2_ . id AS id_9 , e2_ . exchange_rate AS exchange_rate_10 , e2_ . last_automatic_update AS last_automatic_update_11 , e2_ . created_at AS created_at_12 , e2_ . updated_at AS updated_at_13 , e1_ . currency_from_id AS currency_from_id_14 , e1_ . currency_to_id AS currency_to_id_15 , e2_ . currency_from_id AS currency_from_id_16 , e2_ . currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_ . code = e1_ . currency_to_id LEFT JOIN exchange_rate e2_ ON c0_ . code = e2_ . currency_from_id ORDER BY c0_ . is_default DESC , c0_ . code ASC ;
Copy
28
0.93 ms
SELECT c0_ . id AS id_0 , c0_ . public_id AS public_id_1 , c0_ . name AS name_2 , c0_ . slug AS slug_3 , c0_ . description AS description_4 , c0_ . lft AS lft_5 , c0_ . lvl AS lvl_6 , c0_ . rgt AS rgt_7 , c0_ . position AS position_8 , c0_ . seo_title AS seo_title_9 , c0_ . seo_description AS seo_description_10 , c0_ . seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC
SELECT c0_ . id AS id_0 , c0_ . public_id AS public_id_1 , c0_ . name AS name_2 , c0_ . slug AS slug_3 , c0_ . description AS description_4 , c0_ . lft AS lft_5 , c0_ . lvl AS lvl_6 , c0_ . rgt AS rgt_7 , c0_ . position AS position_8 , c0_ . seo_title AS seo_title_9 , c0_ . seo_description AS seo_description_10 , c0_ . seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC ;
Copy
29
1.09 ms
SELECT s0_ . id AS id_0 , s0_ . position AS position_1 , s0_ . title AS title_2 , s0_ . content AS content_3 , s0_ . link_url AS link_url_4 , s0_ . link_label AS link_label_5 , s0_ . is_active AS is_active_6 , f1_ . id AS id_7 , f1_ . size AS size_8 , f1_ . mime_type AS mime_type_9 , f1_ . name AS name_10 , s0_ . image_id AS image_id_11 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_ . image_id = f1_ . id WHERE s0_ . is_active = true ORDER BY s0_ . position ASC , s0_ . id ASC
SELECT s0_ . id AS id_0 , s0_ . position AS position_1 , s0_ . title AS title_2 , s0_ . content AS content_3 , s0_ . link_url AS link_url_4 , s0_ . link_label AS link_label_5 , s0_ . is_active AS is_active_6 , f1_ . id AS id_7 , f1_ . size AS size_8 , f1_ . mime_type AS mime_type_9 , f1_ . name AS name_10 , s0_ . image_id AS image_id_11 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_ . image_id = f1_ . id WHERE s0_ . is_active = true ORDER BY s0_ . position ASC , s0_ . id ASC ;
Copy
30
1.00 ms
SELECT t0 . id AS id_1 , t0 . is_main AS is_main_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_image t0 INNER JOIN product_image_product_variant ON t0 . id = product_image_product_variant . product_image_id WHERE product_image_product_variant . product_variant_id = ?
Parameters :
[
"2fabfed3-006f-4c90-8978-9957d19452d7 "
]
SELECT t0 . id AS id_1 , t0 . is_main AS is_main_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_image t0 INNER JOIN product_image_product_variant ON t0 . id = product_image_product_variant . product_image_id WHERE product_image_product_variant . product_variant_id = '2fabfed3-006f-4c90-8978-9957d19452d7' ;
Copy
31
0.91 ms
SELECT t0 . id AS id_1 , t0 . rate AS rate_2 FROM tax_rate t0 WHERE t0 . id = ?
Parameters :
[
"9fc197e0-507f-4666-a8d7-6059449c23a7 "
]
SELECT t0 . id AS id_1 , t0 . rate AS rate_2 FROM tax_rate t0 WHERE t0 . id = '9fc197e0-507f-4666-a8d7-6059449c23a7' ;
Copy
32
2.30 ms
SELECT v0_ . id AS id_0 , (v0_ . name - > > ? ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > ? ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = ? GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC
SELECT v0_ . id AS id_0 , (v0_ . name - > > 'cs' ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > 'cs' ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ;
Copy
33
0.59 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . position AS position_5 , t0 . variant_id AS variant_id_6 FROM variant_value t0 INNER JOIN product_variant_variant_value ON t0 . id = product_variant_variant_value . variant_value_id WHERE product_variant_variant_value . product_variant_id = ?
Parameters :
[
"2fabfed3-006f-4c90-8978-9957d19452d7 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . position AS position_5 , t0 . variant_id AS variant_id_6 FROM variant_value t0 INNER JOIN product_variant_variant_value ON t0 . id = product_variant_variant_value . variant_value_id WHERE product_variant_variant_value . product_variant_id = '2fabfed3-006f-4c90-8978-9957d19452d7' ;
Copy
34
1.15 ms
SELECT v0_ . id AS id_0 , (v0_ . name - > > ? ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > ? ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = ? GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC
SELECT v0_ . id AS id_0 , (v0_ . name - > > 'cs' ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > 'cs' ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ;
Copy
35
1.20 ms
SELECT v0_ . id AS id_0 , (v0_ . name - > > ? ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > ? ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = ? GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC
SELECT v0_ . id AS id_0 , (v0_ . name - > > 'cs' ) AS sclr_1 , v1_ . id AS id_2 , (v1_ . name - > > 'cs' ) AS sclr_3 , v0_ . type AS type_4 , v1_ . color AS color_5 , MAX (CASE WHEN (p2_ . stock_stock - p2_ . stock_reserved ) > 0 THEN 1 ELSE 0 END ) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_ . id = p3_ . product_variant_id INNER JOIN variant_value v1_ ON v1_ . id = p3_ . variant_value_id INNER JOIN variant v0_ ON v1_ . variant_id = v0_ . id WHERE p2_ . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ;
Copy
36
0.87 ms
SELECT t0 . id AS id_1 , t0 . custom_value AS custom_value_2 , t0 . product_id AS product_id_3 , t0 . parameter_id AS parameter_id_4 , t0 . parameter_value_id AS parameter_value_id_5 FROM product_parameter t0 WHERE t0 . product_id = ?
Parameters :
[
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . custom_value AS custom_value_2 , t0 . product_id AS product_id_3 , t0 . parameter_id AS parameter_id_4 , t0 . parameter_value_id AS parameter_value_id_5 FROM product_parameter t0 WHERE t0 . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' ;
Copy
37
1.06 ms
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . short_description AS short_description_5 , t0 . code AS code_6 , t0 . ean AS ean_7 , t0 . unit AS unit_8 , t0 . active AS active_9 , t0 . can_be_bought AS can_be_bought_10 , t0 . searchable AS searchable_11 , t0 . show_price AS show_price_12 , t0 . in_stock_text AS in_stock_text_13 , t0 . out_of_stock_text AS out_of_stock_text_14 , t0 . filter_parameter_value_ids AS filter_parameter_value_ids_15 , t0 . filter_variant_value_ids AS filter_variant_value_ids_16 , t0 . search_vector_cs AS search_vector_cs_17 , t0 . search_vector_en AS search_vector_en_18 , t0 . seo_title AS seo_title_19 , t0 . seo_description AS seo_description_20 , t0 . seo_url AS seo_url_21 , t0 . stock_stock AS stock_stock_22 , t0 . stock_reserved AS stock_reserved_23 , t0 . logistic_weight AS logistic_weight_24 , t0 . logistic_size_width AS logistic_size_width_25 , t0 . logistic_size_height AS logistic_size_height_26 , t0 . logistic_size_length AS logistic_size_length_27 , t0 . price_amount AS price_amount_28 , t0 . price_currency AS price_currency_29 , t0 . purchase_price_amount AS purchase_price_amount_30 , t0 . purchase_price_currency AS purchase_price_currency_31 , t0 . vat_id AS vat_id_32 , t0 . main_category_id AS main_category_id_33 FROM product t0 INNER JOIN product_related ON t0 . id = product_related . product_target WHERE product_related . product_source = ?
Parameters :
[
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . public_id AS public_id_2 , t0 . name AS name_3 , t0 . description AS description_4 , t0 . short_description AS short_description_5 , t0 . code AS code_6 , t0 . ean AS ean_7 , t0 . unit AS unit_8 , t0 . active AS active_9 , t0 . can_be_bought AS can_be_bought_10 , t0 . searchable AS searchable_11 , t0 . show_price AS show_price_12 , t0 . in_stock_text AS in_stock_text_13 , t0 . out_of_stock_text AS out_of_stock_text_14 , t0 . filter_parameter_value_ids AS filter_parameter_value_ids_15 , t0 . filter_variant_value_ids AS filter_variant_value_ids_16 , t0 . search_vector_cs AS search_vector_cs_17 , t0 . search_vector_en AS search_vector_en_18 , t0 . seo_title AS seo_title_19 , t0 . seo_description AS seo_description_20 , t0 . seo_url AS seo_url_21 , t0 . stock_stock AS stock_stock_22 , t0 . stock_reserved AS stock_reserved_23 , t0 . logistic_weight AS logistic_weight_24 , t0 . logistic_size_width AS logistic_size_width_25 , t0 . logistic_size_height AS logistic_size_height_26 , t0 . logistic_size_length AS logistic_size_length_27 , t0 . price_amount AS price_amount_28 , t0 . price_currency AS price_currency_29 , t0 . purchase_price_amount AS purchase_price_amount_30 , t0 . purchase_price_currency AS purchase_price_currency_31 , t0 . vat_id AS vat_id_32 , t0 . main_category_id AS main_category_id_33 FROM product t0 INNER JOIN product_related ON t0 . id = product_related . product_target WHERE product_related . product_source = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' ;
Copy
38
0.63 ms
SELECT t0 . id AS id_1 , t0 . url AS url_2 , t0 . title AS title_3 , t0 . position AS position_4 , t0 . product_id AS product_id_5 FROM product_video t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC
Parameters :
[
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . url AS url_2 , t0 . title AS title_3 , t0 . position AS position_4 , t0 . product_id AS product_id_5 FROM product_video t0 WHERE t0 . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' ORDER BY t0 . position ASC ;
Copy
39
0.58 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_file t0 WHERE t0 . product_id = ?
Parameters :
[
"337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . position AS position_3 , t0 . product_id AS product_id_4 , t0 . file_id AS file_id_5 FROM product_file t0 WHERE t0 . product_id = '337b6ec3-9e68-4af1-8ff0-ba0a8ab15ffb' ;
Copy
40
0.86 ms
SELECT f0_ . id AS id_0 , f0_ . position AS position_1 , f0_ . label AS label_2 , f0_ . url AS url_3 , f0_ . is_active AS is_active_4 FROM footer_link f0_ WHERE f0_ . is_active = true ORDER BY f0_ . position ASC , f0_ . id ASC
SELECT f0_ . id AS id_0 , f0_ . position AS position_1 , f0_ . label AS label_2 , f0_ . url AS url_3 , f0_ . is_active AS is_active_4 FROM footer_link f0_ WHERE f0_ . is_active = true ORDER BY f0_ . position ASC , f0_ . id ASC ;
Copy
41
0.44 ms
SELECT s0_ . id AS id_0 , s0_ . position AS position_1 , s0_ . network AS network_2 , s0_ . url AS url_3 , s0_ . is_active AS is_active_4 FROM social_link s0_ WHERE s0_ . is_active = true ORDER BY s0_ . position ASC , s0_ . id ASC
SELECT s0_ . id AS id_0 , s0_ . position AS position_1 , s0_ . network AS network_2 , s0_ . url AS url_3 , s0_ . is_active AS is_active_4 FROM social_link s0_ WHERE s0_ . is_active = true ORDER BY s0_ . position ASC , s0_ . id ASC ;
Copy