1
0.99 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.79 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-kalhoty/719-levis-511-slim-fit-dziny "
]
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-kalhoty/719-levis-511-slim-fit-dziny' ; Copy
3
2.02 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
1.03 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
1.13 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
1.08 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
3.57 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 :
[
"f01c335b3aa3485ca1364c48fb4cc468 "
"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 = 'f01c335b3aa3485ca1364c48fb4cc468' AND c0_ . status = 'active' ORDER BY c1_ . id ASC ; Copy
8
0.59 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 = '719' LIMIT 1 ; Copy
9
0.42 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
10
1.48 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 :
[
"6b4d2c8f-0e7a-4f1b-2d5c-4a9e1f6b7d8c "
]
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 = '6b4d2c8f-0e7a-4f1b-2d5c-4a9e1f6b7d8c' ; Copy
11
1.61 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 :
[
"f01c335b3aa3485ca1364c48fb4cc468 "
"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 = 'f01c335b3aa3485ca1364c48fb4cc468' AND c0_ . status = 'active' ORDER BY c1_ . id ASC ; Copy
12
0.39 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
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ); Copy
13
0.87 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 :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ; Copy
14
0.51 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 :
[
"776a5a03-305b-4d86-8927-5f2fe9e8dff0 "
]
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 = '776a5a03-305b-4d86-8927-5f2fe9e8dff0' ; Copy
15
0.49 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 :
[
"c66ca4c9-5b96-4d9c-909f-85b354d6f0b6 "
]
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 = 'c66ca4c9-5b96-4d9c-909f-85b354d6f0b6' ; Copy
16
0.42 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
17
0.58 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
18
1.45 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
19
2.18 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
20
1.11 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
21
0.79 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
22
0.86 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.89 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.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
25
1.06 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
26
1.30 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
27
0.87 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 :
[
"e859a39f-35d4-4c09-b85d-01210ddae151 "
]
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 = 'e859a39f-35d4-4c09-b85d-01210ddae151' ; Copy
28
0.80 ms
SELECT t0 . id AS id_1 , t0 . rate AS rate_2 FROM tax_rate t0 WHERE t0 . id = ?
Parameters :
[
"d4cbf291-83a9-4c10-97a6-39675f525c02 "
]
SELECT t0 . id AS id_1 , t0 . rate AS rate_2 FROM tax_rate t0 WHERE t0 . id = 'd4cbf291-83a9-4c10-97a6-39675f525c02' ; Copy
29
2.70 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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ; Copy
30
0.65 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 :
[
"e859a39f-35d4-4c09-b85d-01210ddae151 "
]
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 = 'e859a39f-35d4-4c09-b85d-01210ddae151' ; Copy
31
1.37 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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ; Copy
32
1.28 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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ; Copy
33
1.27 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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' GROUP BY v0_ . id , v1_ . id ORDER BY v0_ . position ASC , v1_ . position ASC ; Copy
34
1.08 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 :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ; Copy
35
1.50 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 :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ; Copy
36
0.43 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 :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ORDER BY t0 . position ASC ; Copy
37
0.43 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 :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
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 = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ; Copy
38
1.50 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 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"adb9d694-d757-469e-8a76-d95e6d5b7824 "
]
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 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 'adb9d694-d757-469e-8a76-d95e6d5b7824' ; Copy
39
0.45 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 :
[
"adb9d694-d757-469e-8a76-d95e6d5b7824 "
]
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 = 'adb9d694-d757-469e-8a76-d95e6d5b7824' ; Copy
40
0.32 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 :
[
"ad1b39cc-1a64-4376-9bde-c004ef8fc3d2 "
]
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 = 'ad1b39cc-1a64-4376-9bde-c004ef8fc3d2' ; Copy
41
0.89 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
42
0.76 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