1
3.84 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_ . payment_method AS payment_method_14 , c0_ . created_at AS created_at_15 , c0_ . updated_at AS updated_at_16 , c0_ . address_street AS address_street_17 , c0_ . address_descriptive_number AS address_descriptive_number_18 , c0_ . address_city AS address_city_19 , c0_ . address_country AS address_country_20 , c0_ . address_zip_code AS address_zip_code_21 , c0_ . invoice_street AS invoice_street_22 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 , c0_ . invoice_city AS invoice_city_24 , c0_ . invoice_country AS invoice_country_25 , c0_ . invoice_zip_code AS invoice_zip_code_26 , c1_ . id AS id_27 , c1_ . quantity AS quantity_28 , c1_ . created_at AS created_at_29 , c1_ . updated_at AS updated_at_30 , p2_ . id AS id_31 , p2_ . code AS code_32 , p2_ . is_default AS is_default_33 , p2_ . weight_modification AS weight_modification_34 , p2_ . price_modification_amount AS price_modification_amount_35 , p2_ . price_modification_currency AS price_modification_currency_36 , p2_ . stock_stock AS stock_stock_37 , p2_ . stock_reserved AS stock_reserved_38 , p3_ . id AS id_39 , p3_ . name AS name_40 , p3_ . description AS description_41 , p3_ . short_description AS short_description_42 , p3_ . code AS code_43 , p3_ . ean AS ean_44 , p3_ . unit AS unit_45 , p3_ . active AS active_46 , p3_ . can_be_bought AS can_be_bought_47 , p3_ . in_stock_text AS in_stock_text_48 , p3_ . out_of_stock_text AS out_of_stock_text_49 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 , p3_ . seo_title AS seo_title_52 , p3_ . seo_description AS seo_description_53 , p3_ . seo_url AS seo_url_54 , p3_ . stock_stock AS stock_stock_55 , p3_ . stock_reserved AS stock_reserved_56 , p3_ . logistic_weight AS logistic_weight_57 , p3_ . logistic_size_width AS logistic_size_width_58 , p3_ . logistic_size_height AS logistic_size_height_59 , p3_ . logistic_size_length AS logistic_size_length_60 , p3_ . price_amount AS price_amount_61 , p3_ . price_currency AS price_currency_62 , p3_ . purchase_price_amount AS purchase_price_amount_63 , p3_ . purchase_price_currency AS purchase_price_currency_64 , c0_ . customer_id AS customer_id_65 , c0_ . shipping_method_id AS shipping_method_id_66 , c0_ . discount_code_id AS discount_code_id_67 , c1_ . cart_id AS cart_id_68 , c1_ . product_variant_id AS product_variant_id_69 , p2_ . product_id AS product_id_70 , p3_ . vat_id AS vat_id_71 , p3_ . main_category_id AS main_category_id_72 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 :
[
""
"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_ . payment_method AS payment_method_14 ,
c0_ . created_at AS created_at_15 ,
c0_ . updated_at AS updated_at_16 ,
c0_ . address_street AS address_street_17 ,
c0_ . address_descriptive_number AS address_descriptive_number_18 ,
c0_ . address_city AS address_city_19 ,
c0_ . address_country AS address_country_20 ,
c0_ . address_zip_code AS address_zip_code_21 ,
c0_ . invoice_street AS invoice_street_22 ,
c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 ,
c0_ . invoice_city AS invoice_city_24 ,
c0_ . invoice_country AS invoice_country_25 ,
c0_ . invoice_zip_code AS invoice_zip_code_26 ,
c1_ . id AS id_27 ,
c1_ . quantity AS quantity_28 ,
c1_ . created_at AS created_at_29 ,
c1_ . updated_at AS updated_at_30 ,
p2_ . id AS id_31 ,
p2_ . code AS code_32 ,
p2_ . is_default AS is_default_33 ,
p2_ . weight_modification AS weight_modification_34 ,
p2_ . price_modification_amount AS price_modification_amount_35 ,
p2_ . price_modification_currency AS price_modification_currency_36 ,
p2_ . stock_stock AS stock_stock_37 ,
p2_ . stock_reserved AS stock_reserved_38 ,
p3_ . id AS id_39 ,
p3_ . name AS name_40 ,
p3_ . description AS description_41 ,
p3_ . short_description AS short_description_42 ,
p3_ . code AS code_43 ,
p3_ . ean AS ean_44 ,
p3_ . unit AS unit_45 ,
p3_ . active AS active_46 ,
p3_ . can_be_bought AS can_be_bought_47 ,
p3_ . in_stock_text AS in_stock_text_48 ,
p3_ . out_of_stock_text AS out_of_stock_text_49 ,
p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 ,
p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 ,
p3_ . seo_title AS seo_title_52 ,
p3_ . seo_description AS seo_description_53 ,
p3_ . seo_url AS seo_url_54 ,
p3_ . stock_stock AS stock_stock_55 ,
p3_ . stock_reserved AS stock_reserved_56 ,
p3_ . logistic_weight AS logistic_weight_57 ,
p3_ . logistic_size_width AS logistic_size_width_58 ,
p3_ . logistic_size_height AS logistic_size_height_59 ,
p3_ . logistic_size_length AS logistic_size_length_60 ,
p3_ . price_amount AS price_amount_61 ,
p3_ . price_currency AS price_currency_62 ,
p3_ . purchase_price_amount AS purchase_price_amount_63 ,
p3_ . purchase_price_currency AS purchase_price_currency_64 ,
c0_ . customer_id AS customer_id_65 ,
c0_ . shipping_method_id AS shipping_method_id_66 ,
c0_ . discount_code_id AS discount_code_id_67 ,
c1_ . cart_id AS cart_id_68 ,
c1_ . product_variant_id AS product_variant_id_69 ,
p2_ . product_id AS product_id_70 ,
p3_ . vat_id AS vat_id_71 ,
p3_ . main_category_id AS main_category_id_72
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_ . payment_method AS payment_method_14 , c0_ . created_at AS created_at_15 , c0_ . updated_at AS updated_at_16 , c0_ . address_street AS address_street_17 , c0_ . address_descriptive_number AS address_descriptive_number_18 , c0_ . address_city AS address_city_19 , c0_ . address_country AS address_country_20 , c0_ . address_zip_code AS address_zip_code_21 , c0_ . invoice_street AS invoice_street_22 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 , c0_ . invoice_city AS invoice_city_24 , c0_ . invoice_country AS invoice_country_25 , c0_ . invoice_zip_code AS invoice_zip_code_26 , c1_ . id AS id_27 , c1_ . quantity AS quantity_28 , c1_ . created_at AS created_at_29 , c1_ . updated_at AS updated_at_30 , p2_ . id AS id_31 , p2_ . code AS code_32 , p2_ . is_default AS is_default_33 , p2_ . weight_modification AS weight_modification_34 , p2_ . price_modification_amount AS price_modification_amount_35 , p2_ . price_modification_currency AS price_modification_currency_36 , p2_ . stock_stock AS stock_stock_37 , p2_ . stock_reserved AS stock_reserved_38 , p3_ . id AS id_39 , p3_ . name AS name_40 , p3_ . description AS description_41 , p3_ . short_description AS short_description_42 , p3_ . code AS code_43 , p3_ . ean AS ean_44 , p3_ . unit AS unit_45 , p3_ . active AS active_46 , p3_ . can_be_bought AS can_be_bought_47 , p3_ . in_stock_text AS in_stock_text_48 , p3_ . out_of_stock_text AS out_of_stock_text_49 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 , p3_ . seo_title AS seo_title_52 , p3_ . seo_description AS seo_description_53 , p3_ . seo_url AS seo_url_54 , p3_ . stock_stock AS stock_stock_55 , p3_ . stock_reserved AS stock_reserved_56 , p3_ . logistic_weight AS logistic_weight_57 , p3_ . logistic_size_width AS logistic_size_width_58 , p3_ . logistic_size_height AS logistic_size_height_59 , p3_ . logistic_size_length AS logistic_size_length_60 , p3_ . price_amount AS price_amount_61 , p3_ . price_currency AS price_currency_62 , p3_ . purchase_price_amount AS purchase_price_amount_63 , p3_ . purchase_price_currency AS purchase_price_currency_64 , c0_ . customer_id AS customer_id_65 , c0_ . shipping_method_id AS shipping_method_id_66 , c0_ . discount_code_id AS discount_code_id_67 , c1_ . cart_id AS cart_id_68 , c1_ . product_variant_id AS product_variant_id_69 , p2_ . product_id AS product_id_70 , p3_ . vat_id AS vat_id_71 , p3_ . main_category_id AS main_category_id_72 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 = 'active' ORDER BY c1_ . id ASC ;
Copy
2
1.16 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 , f1_ . id AS id_8 , f1_ . size AS size_9 , f1_ . mime_type AS mime_type_10 , c0_ . image_id AS image_id_11 , c0_ . tree_root AS tree_root_12 , c0_ . parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_ . image_id = f1_ . id WHERE c0_ . parent_id IS NULL ORDER BY c0_ . position ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 , f1_ . id AS id_8 , f1_ . size AS size_9 , f1_ . mime_type AS mime_type_10 , c0_ . image_id AS image_id_11 , c0_ . tree_root AS tree_root_12 , c0_ . parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_ . image_id = f1_ . id WHERE c0_ . parent_id IS NULL ORDER BY c0_ . position ASC ;
Copy
3
1.15 ms
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . type AS type_2 , f0_ . is_enabled AS is_enabled_3 , p1_ . id AS id_4 , p1_ . name AS name_5 , p1_ . slug AS slug_6 , p2_ . id AS id_7 , p2_ . name AS name_8 , p2_ . slug AS slug_9 , f0_ . entity AS entity_10 , f0_ . parameter_id AS parameter_id_11 , p2_ . parameter_id AS parameter_id_12 FROM filter_configuration f0_ LEFT JOIN parameter p1_ ON f0_ . parameter_id = p1_ . id LEFT JOIN parameter_value p2_ ON p1_ . id = p2_ . parameter_id WHERE (f0_ . is_enabled = ? ) AND f0_ . entity IN ('parameter' ) ORDER BY f0_ . name ASC
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . type AS type_2 , f0_ . is_enabled AS is_enabled_3 , p1_ . id AS id_4 , p1_ . name AS name_5 , p1_ . slug AS slug_6 , p2_ . id AS id_7 , p2_ . name AS name_8 , p2_ . slug AS slug_9 , f0_ . entity AS entity_10 , f0_ . parameter_id AS parameter_id_11 , p2_ . parameter_id AS parameter_id_12 FROM filter_configuration f0_ LEFT JOIN parameter p1_ ON f0_ . parameter_id = p1_ . id LEFT JOIN parameter_value p2_ ON p1_ . id = p2_ . parameter_id WHERE (f0_ . is_enabled = 1 ) AND f0_ . entity IN ('parameter' ) ORDER BY f0_ . name ASC ;
Copy
4
0.81 ms
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . type AS type_2 , f0_ . is_enabled AS is_enabled_3 , v1_ . id AS id_4 , v1_ . name AS name_5 , v1_ . slug AS slug_6 , v1_ . type AS type_7 , v2_ . id AS id_8 , v2_ . name AS name_9 , v2_ . slug AS slug_10 , v2_ . color AS color_11 , f0_ . entity AS entity_12 , f0_ . variant_id AS variant_id_13 , v2_ . variant_id AS variant_id_14 FROM filter_configuration f0_ LEFT JOIN variant v1_ ON f0_ . variant_id = v1_ . id LEFT JOIN variant_value v2_ ON v1_ . id = v2_ . variant_id WHERE (f0_ . is_enabled = ? ) AND f0_ . entity IN ('variant' ) ORDER BY f0_ . name ASC
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . type AS type_2 , f0_ . is_enabled AS is_enabled_3 , v1_ . id AS id_4 , v1_ . name AS name_5 , v1_ . slug AS slug_6 , v1_ . type AS type_7 , v2_ . id AS id_8 , v2_ . name AS name_9 , v2_ . slug AS slug_10 , v2_ . color AS color_11 , f0_ . entity AS entity_12 , f0_ . variant_id AS variant_id_13 , v2_ . variant_id AS variant_id_14 FROM filter_configuration f0_ LEFT JOIN variant v1_ ON f0_ . variant_id = v1_ . id LEFT JOIN variant_value v2_ ON v1_ . id = v2_ . variant_id WHERE (f0_ . is_enabled = 1 ) AND f0_ . entity IN ('variant' ) ORDER BY f0_ . name ASC ;
Copy
5
3.01 ms
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . description AS description_2 , p0_ . short_description AS short_description_3 , p0_ . code AS code_4 , p0_ . ean AS ean_5 , p0_ . unit AS unit_6 , p0_ . active AS active_7 , p0_ . can_be_bought AS can_be_bought_8 , p0_ . in_stock_text AS in_stock_text_9 , p0_ . out_of_stock_text AS out_of_stock_text_10 , p0_ . filter_parameter_value_ids AS filter_parameter_value_ids_11 , p0_ . filter_variant_value_ids AS filter_variant_value_ids_12 , p0_ . seo_title AS seo_title_13 , p0_ . seo_description AS seo_description_14 , p0_ . seo_url AS seo_url_15 , p0_ . stock_stock AS stock_stock_16 , p0_ . stock_reserved AS stock_reserved_17 , p0_ . logistic_weight AS logistic_weight_18 , p0_ . logistic_size_width AS logistic_size_width_19 , p0_ . logistic_size_height AS logistic_size_height_20 , p0_ . logistic_size_length AS logistic_size_length_21 , p0_ . price_amount AS price_amount_22 , p0_ . price_currency AS price_currency_23 , p0_ . purchase_price_amount AS purchase_price_amount_24 , p0_ . purchase_price_currency AS purchase_price_currency_25 , p1_ . id AS id_26 , p1_ . code AS code_27 , p1_ . is_default AS is_default_28 , p1_ . weight_modification AS weight_modification_29 , p1_ . price_modification_amount AS price_modification_amount_30 , p1_ . price_modification_currency AS price_modification_currency_31 , p1_ . stock_stock AS stock_stock_32 , p1_ . stock_reserved AS stock_reserved_33 , v2_ . id AS id_34 , v2_ . name AS name_35 , v2_ . slug AS slug_36 , v2_ . color AS color_37 , v3_ . id AS id_38 , v3_ . name AS name_39 , v3_ . slug AS slug_40 , v3_ . type AS type_41 , p4_ . id AS id_42 , p4_ . custom_value AS custom_value_43 , p5_ . id AS id_44 , p5_ . name AS name_45 , p5_ . slug AS slug_46 , p6_ . id AS id_47 , p6_ . name AS name_48 , p6_ . slug AS slug_49 , p0_ . vat_id AS vat_id_50 , p0_ . main_category_id AS main_category_id_51 , p1_ . product_id AS product_id_52 , v2_ . variant_id AS variant_id_53 , p4_ . product_id AS product_id_54 , p4_ . parameter_id AS parameter_id_55 , p4_ . parameter_value_id AS parameter_value_id_56 , p6_ . parameter_id AS parameter_id_57 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_ . id = p1_ . product_id LEFT JOIN product_variant_variant_value p7_ ON p1_ . id = p7_ . product_variant_id LEFT JOIN variant_value v2_ ON v2_ . id = p7_ . variant_value_id LEFT JOIN variant v3_ ON v2_ . variant_id = v3_ . id LEFT JOIN product_parameter p4_ ON p0_ . id = p4_ . product_id LEFT JOIN parameter p5_ ON p4_ . parameter_id = p5_ . id LEFT JOIN parameter_value p6_ ON p4_ . parameter_value_id = p6_ . id ORDER BY p0_ . name ASC
SELECT
p0_ . id AS id_0 ,
p0_ . name AS name_1 ,
p0_ . description AS description_2 ,
p0_ . short_description AS short_description_3 ,
p0_ . code AS code_4 ,
p0_ . ean AS ean_5 ,
p0_ . unit AS unit_6 ,
p0_ . active AS active_7 ,
p0_ . can_be_bought AS can_be_bought_8 ,
p0_ . in_stock_text AS in_stock_text_9 ,
p0_ . out_of_stock_text AS out_of_stock_text_10 ,
p0_ . filter_parameter_value_ids AS filter_parameter_value_ids_11 ,
p0_ . filter_variant_value_ids AS filter_variant_value_ids_12 ,
p0_ . seo_title AS seo_title_13 ,
p0_ . seo_description AS seo_description_14 ,
p0_ . seo_url AS seo_url_15 ,
p0_ . stock_stock AS stock_stock_16 ,
p0_ . stock_reserved AS stock_reserved_17 ,
p0_ . logistic_weight AS logistic_weight_18 ,
p0_ . logistic_size_width AS logistic_size_width_19 ,
p0_ . logistic_size_height AS logistic_size_height_20 ,
p0_ . logistic_size_length AS logistic_size_length_21 ,
p0_ . price_amount AS price_amount_22 ,
p0_ . price_currency AS price_currency_23 ,
p0_ . purchase_price_amount AS purchase_price_amount_24 ,
p0_ . purchase_price_currency AS purchase_price_currency_25 ,
p1_ . id AS id_26 ,
p1_ . code AS code_27 ,
p1_ . is_default AS is_default_28 ,
p1_ . weight_modification AS weight_modification_29 ,
p1_ . price_modification_amount AS price_modification_amount_30 ,
p1_ . price_modification_currency AS price_modification_currency_31 ,
p1_ . stock_stock AS stock_stock_32 ,
p1_ . stock_reserved AS stock_reserved_33 ,
v2_ . id AS id_34 ,
v2_ . name AS name_35 ,
v2_ . slug AS slug_36 ,
v2_ . color AS color_37 ,
v3_ . id AS id_38 ,
v3_ . name AS name_39 ,
v3_ . slug AS slug_40 ,
v3_ . type AS type_41 ,
p4_ . id AS id_42 ,
p4_ . custom_value AS custom_value_43 ,
p5_ . id AS id_44 ,
p5_ . name AS name_45 ,
p5_ . slug AS slug_46 ,
p6_ . id AS id_47 ,
p6_ . name AS name_48 ,
p6_ . slug AS slug_49 ,
p0_ . vat_id AS vat_id_50 ,
p0_ . main_category_id AS main_category_id_51 ,
p1_ . product_id AS product_id_52 ,
v2_ . variant_id AS variant_id_53 ,
p4_ . product_id AS product_id_54 ,
p4_ . parameter_id AS parameter_id_55 ,
p4_ . parameter_value_id AS parameter_value_id_56 ,
p6_ . parameter_id AS parameter_id_57
FROM
product p0_
LEFT JOIN product_variant p1_ ON p0_ . id = p1_ . product_id
LEFT JOIN product_variant_variant_value p7_ ON p1_ . id = p7_ . product_variant_id
LEFT JOIN variant_value v2_ ON v2_ . id = p7_ . variant_value_id
LEFT JOIN variant v3_ ON v2_ . variant_id = v3_ . id
LEFT JOIN product_parameter p4_ ON p0_ . id = p4_ . product_id
LEFT JOIN parameter p5_ ON p4_ . parameter_id = p5_ . id
LEFT JOIN parameter_value p6_ ON p4_ . parameter_value_id = p6_ . id
ORDER BY
p0_ . name ASC
Copy
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . description AS description_2 , p0_ . short_description AS short_description_3 , p0_ . code AS code_4 , p0_ . ean AS ean_5 , p0_ . unit AS unit_6 , p0_ . active AS active_7 , p0_ . can_be_bought AS can_be_bought_8 , p0_ . in_stock_text AS in_stock_text_9 , p0_ . out_of_stock_text AS out_of_stock_text_10 , p0_ . filter_parameter_value_ids AS filter_parameter_value_ids_11 , p0_ . filter_variant_value_ids AS filter_variant_value_ids_12 , p0_ . seo_title AS seo_title_13 , p0_ . seo_description AS seo_description_14 , p0_ . seo_url AS seo_url_15 , p0_ . stock_stock AS stock_stock_16 , p0_ . stock_reserved AS stock_reserved_17 , p0_ . logistic_weight AS logistic_weight_18 , p0_ . logistic_size_width AS logistic_size_width_19 , p0_ . logistic_size_height AS logistic_size_height_20 , p0_ . logistic_size_length AS logistic_size_length_21 , p0_ . price_amount AS price_amount_22 , p0_ . price_currency AS price_currency_23 , p0_ . purchase_price_amount AS purchase_price_amount_24 , p0_ . purchase_price_currency AS purchase_price_currency_25 , p1_ . id AS id_26 , p1_ . code AS code_27 , p1_ . is_default AS is_default_28 , p1_ . weight_modification AS weight_modification_29 , p1_ . price_modification_amount AS price_modification_amount_30 , p1_ . price_modification_currency AS price_modification_currency_31 , p1_ . stock_stock AS stock_stock_32 , p1_ . stock_reserved AS stock_reserved_33 , v2_ . id AS id_34 , v2_ . name AS name_35 , v2_ . slug AS slug_36 , v2_ . color AS color_37 , v3_ . id AS id_38 , v3_ . name AS name_39 , v3_ . slug AS slug_40 , v3_ . type AS type_41 , p4_ . id AS id_42 , p4_ . custom_value AS custom_value_43 , p5_ . id AS id_44 , p5_ . name AS name_45 , p5_ . slug AS slug_46 , p6_ . id AS id_47 , p6_ . name AS name_48 , p6_ . slug AS slug_49 , p0_ . vat_id AS vat_id_50 , p0_ . main_category_id AS main_category_id_51 , p1_ . product_id AS product_id_52 , v2_ . variant_id AS variant_id_53 , p4_ . product_id AS product_id_54 , p4_ . parameter_id AS parameter_id_55 , p4_ . parameter_value_id AS parameter_value_id_56 , p6_ . parameter_id AS parameter_id_57 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_ . id = p1_ . product_id LEFT JOIN product_variant_variant_value p7_ ON p1_ . id = p7_ . product_variant_id LEFT JOIN variant_value v2_ ON v2_ . id = p7_ . variant_value_id LEFT JOIN variant v3_ ON v2_ . variant_id = v3_ . id LEFT JOIN product_parameter p4_ ON p0_ . id = p4_ . product_id LEFT JOIN parameter p5_ ON p4_ . parameter_id = p5_ . id LEFT JOIN parameter_value p6_ ON p4_ . parameter_value_id = p6_ . id ORDER BY p0_ . name ASC ;
Copy
6
1.23 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_ . payment_method AS payment_method_14 , c0_ . created_at AS created_at_15 , c0_ . updated_at AS updated_at_16 , c0_ . address_street AS address_street_17 , c0_ . address_descriptive_number AS address_descriptive_number_18 , c0_ . address_city AS address_city_19 , c0_ . address_country AS address_country_20 , c0_ . address_zip_code AS address_zip_code_21 , c0_ . invoice_street AS invoice_street_22 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 , c0_ . invoice_city AS invoice_city_24 , c0_ . invoice_country AS invoice_country_25 , c0_ . invoice_zip_code AS invoice_zip_code_26 , c1_ . id AS id_27 , c1_ . quantity AS quantity_28 , c1_ . created_at AS created_at_29 , c1_ . updated_at AS updated_at_30 , p2_ . id AS id_31 , p2_ . code AS code_32 , p2_ . is_default AS is_default_33 , p2_ . weight_modification AS weight_modification_34 , p2_ . price_modification_amount AS price_modification_amount_35 , p2_ . price_modification_currency AS price_modification_currency_36 , p2_ . stock_stock AS stock_stock_37 , p2_ . stock_reserved AS stock_reserved_38 , p3_ . id AS id_39 , p3_ . name AS name_40 , p3_ . description AS description_41 , p3_ . short_description AS short_description_42 , p3_ . code AS code_43 , p3_ . ean AS ean_44 , p3_ . unit AS unit_45 , p3_ . active AS active_46 , p3_ . can_be_bought AS can_be_bought_47 , p3_ . in_stock_text AS in_stock_text_48 , p3_ . out_of_stock_text AS out_of_stock_text_49 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 , p3_ . seo_title AS seo_title_52 , p3_ . seo_description AS seo_description_53 , p3_ . seo_url AS seo_url_54 , p3_ . stock_stock AS stock_stock_55 , p3_ . stock_reserved AS stock_reserved_56 , p3_ . logistic_weight AS logistic_weight_57 , p3_ . logistic_size_width AS logistic_size_width_58 , p3_ . logistic_size_height AS logistic_size_height_59 , p3_ . logistic_size_length AS logistic_size_length_60 , p3_ . price_amount AS price_amount_61 , p3_ . price_currency AS price_currency_62 , p3_ . purchase_price_amount AS purchase_price_amount_63 , p3_ . purchase_price_currency AS purchase_price_currency_64 , c0_ . customer_id AS customer_id_65 , c0_ . shipping_method_id AS shipping_method_id_66 , c0_ . discount_code_id AS discount_code_id_67 , c1_ . cart_id AS cart_id_68 , c1_ . product_variant_id AS product_variant_id_69 , p2_ . product_id AS product_id_70 , p3_ . vat_id AS vat_id_71 , p3_ . main_category_id AS main_category_id_72 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 :
[
""
"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_ . payment_method AS payment_method_14 ,
c0_ . created_at AS created_at_15 ,
c0_ . updated_at AS updated_at_16 ,
c0_ . address_street AS address_street_17 ,
c0_ . address_descriptive_number AS address_descriptive_number_18 ,
c0_ . address_city AS address_city_19 ,
c0_ . address_country AS address_country_20 ,
c0_ . address_zip_code AS address_zip_code_21 ,
c0_ . invoice_street AS invoice_street_22 ,
c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 ,
c0_ . invoice_city AS invoice_city_24 ,
c0_ . invoice_country AS invoice_country_25 ,
c0_ . invoice_zip_code AS invoice_zip_code_26 ,
c1_ . id AS id_27 ,
c1_ . quantity AS quantity_28 ,
c1_ . created_at AS created_at_29 ,
c1_ . updated_at AS updated_at_30 ,
p2_ . id AS id_31 ,
p2_ . code AS code_32 ,
p2_ . is_default AS is_default_33 ,
p2_ . weight_modification AS weight_modification_34 ,
p2_ . price_modification_amount AS price_modification_amount_35 ,
p2_ . price_modification_currency AS price_modification_currency_36 ,
p2_ . stock_stock AS stock_stock_37 ,
p2_ . stock_reserved AS stock_reserved_38 ,
p3_ . id AS id_39 ,
p3_ . name AS name_40 ,
p3_ . description AS description_41 ,
p3_ . short_description AS short_description_42 ,
p3_ . code AS code_43 ,
p3_ . ean AS ean_44 ,
p3_ . unit AS unit_45 ,
p3_ . active AS active_46 ,
p3_ . can_be_bought AS can_be_bought_47 ,
p3_ . in_stock_text AS in_stock_text_48 ,
p3_ . out_of_stock_text AS out_of_stock_text_49 ,
p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 ,
p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 ,
p3_ . seo_title AS seo_title_52 ,
p3_ . seo_description AS seo_description_53 ,
p3_ . seo_url AS seo_url_54 ,
p3_ . stock_stock AS stock_stock_55 ,
p3_ . stock_reserved AS stock_reserved_56 ,
p3_ . logistic_weight AS logistic_weight_57 ,
p3_ . logistic_size_width AS logistic_size_width_58 ,
p3_ . logistic_size_height AS logistic_size_height_59 ,
p3_ . logistic_size_length AS logistic_size_length_60 ,
p3_ . price_amount AS price_amount_61 ,
p3_ . price_currency AS price_currency_62 ,
p3_ . purchase_price_amount AS purchase_price_amount_63 ,
p3_ . purchase_price_currency AS purchase_price_currency_64 ,
c0_ . customer_id AS customer_id_65 ,
c0_ . shipping_method_id AS shipping_method_id_66 ,
c0_ . discount_code_id AS discount_code_id_67 ,
c1_ . cart_id AS cart_id_68 ,
c1_ . product_variant_id AS product_variant_id_69 ,
p2_ . product_id AS product_id_70 ,
p3_ . vat_id AS vat_id_71 ,
p3_ . main_category_id AS main_category_id_72
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_ . payment_method AS payment_method_14 , c0_ . created_at AS created_at_15 , c0_ . updated_at AS updated_at_16 , c0_ . address_street AS address_street_17 , c0_ . address_descriptive_number AS address_descriptive_number_18 , c0_ . address_city AS address_city_19 , c0_ . address_country AS address_country_20 , c0_ . address_zip_code AS address_zip_code_21 , c0_ . invoice_street AS invoice_street_22 , c0_ . invoice_descriptive_number AS invoice_descriptive_number_23 , c0_ . invoice_city AS invoice_city_24 , c0_ . invoice_country AS invoice_country_25 , c0_ . invoice_zip_code AS invoice_zip_code_26 , c1_ . id AS id_27 , c1_ . quantity AS quantity_28 , c1_ . created_at AS created_at_29 , c1_ . updated_at AS updated_at_30 , p2_ . id AS id_31 , p2_ . code AS code_32 , p2_ . is_default AS is_default_33 , p2_ . weight_modification AS weight_modification_34 , p2_ . price_modification_amount AS price_modification_amount_35 , p2_ . price_modification_currency AS price_modification_currency_36 , p2_ . stock_stock AS stock_stock_37 , p2_ . stock_reserved AS stock_reserved_38 , p3_ . id AS id_39 , p3_ . name AS name_40 , p3_ . description AS description_41 , p3_ . short_description AS short_description_42 , p3_ . code AS code_43 , p3_ . ean AS ean_44 , p3_ . unit AS unit_45 , p3_ . active AS active_46 , p3_ . can_be_bought AS can_be_bought_47 , p3_ . in_stock_text AS in_stock_text_48 , p3_ . out_of_stock_text AS out_of_stock_text_49 , p3_ . filter_parameter_value_ids AS filter_parameter_value_ids_50 , p3_ . filter_variant_value_ids AS filter_variant_value_ids_51 , p3_ . seo_title AS seo_title_52 , p3_ . seo_description AS seo_description_53 , p3_ . seo_url AS seo_url_54 , p3_ . stock_stock AS stock_stock_55 , p3_ . stock_reserved AS stock_reserved_56 , p3_ . logistic_weight AS logistic_weight_57 , p3_ . logistic_size_width AS logistic_size_width_58 , p3_ . logistic_size_height AS logistic_size_height_59 , p3_ . logistic_size_length AS logistic_size_length_60 , p3_ . price_amount AS price_amount_61 , p3_ . price_currency AS price_currency_62 , p3_ . purchase_price_amount AS purchase_price_amount_63 , p3_ . purchase_price_currency AS purchase_price_currency_64 , c0_ . customer_id AS customer_id_65 , c0_ . shipping_method_id AS shipping_method_id_66 , c0_ . discount_code_id AS discount_code_id_67 , c1_ . cart_id AS cart_id_68 , c1_ . product_variant_id AS product_variant_id_69 , p2_ . product_id AS product_id_70 , p3_ . vat_id AS vat_id_71 , p3_ . main_category_id AS main_category_id_72 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 = 'active' ORDER BY c1_ . id ASC ;
Copy
7
0.73 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"7a79ea94-236b-4062-a3b5-5a047d63c05f "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = '7a79ea94-236b-4062-a3b5-5a047d63c05f' ;
Copy
8
0.46 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = '7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f' ;
Copy
9
0.42 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' ;
Copy
10
0.45 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = '2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f' ;
Copy
11
0.46 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 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 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 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
12
0.42 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
Parameters :
[
"3fdfb7bc-49b9-46b9-9431-366c90e2605e "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . description AS description_4 , t0 . lft AS lft_5 , t0 . lvl AS lvl_6 , t0 . rgt AS rgt_7 , t0 . position AS position_8 , t0 . image_id AS image_id_9 , t0 . tree_root AS tree_root_10 , t0 . parent_id AS parent_id_11 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = '3fdfb7bc-49b9-46b9-9431-366c90e2605e' ;
Copy
13
1.83 ms
SELECT d0_ . id AS id_0 , d0_ . name AS name_1 , d0_ . code AS code_2 , d0_ . target AS target_3 , d0_ . type AS type_4 , d0_ . value AS value_5 , d0_ . active_from AS active_from_6 , d0_ . active_to AS active_to_7 , d0_ . minimum_quantity AS minimum_quantity_8 , d0_ . active AS active_9 , p1_ . id AS id_10 , p1_ . name AS name_11 , p1_ . description AS description_12 , p1_ . short_description AS short_description_13 , p1_ . code AS code_14 , p1_ . ean AS ean_15 , p1_ . unit AS unit_16 , p1_ . active AS active_17 , p1_ . can_be_bought AS can_be_bought_18 , p1_ . in_stock_text AS in_stock_text_19 , p1_ . out_of_stock_text AS out_of_stock_text_20 , p1_ . filter_parameter_value_ids AS filter_parameter_value_ids_21 , p1_ . filter_variant_value_ids AS filter_variant_value_ids_22 , p1_ . seo_title AS seo_title_23 , p1_ . seo_description AS seo_description_24 , p1_ . seo_url AS seo_url_25 , p1_ . stock_stock AS stock_stock_26 , p1_ . stock_reserved AS stock_reserved_27 , p1_ . logistic_weight AS logistic_weight_28 , p1_ . logistic_size_width AS logistic_size_width_29 , p1_ . logistic_size_height AS logistic_size_height_30 , p1_ . logistic_size_length AS logistic_size_length_31 , p1_ . price_amount AS price_amount_32 , p1_ . price_currency AS price_currency_33 , p1_ . purchase_price_amount AS purchase_price_amount_34 , p1_ . purchase_price_currency AS purchase_price_currency_35 , p2_ . id AS id_36 , p2_ . code AS code_37 , p2_ . is_default AS is_default_38 , p2_ . weight_modification AS weight_modification_39 , p2_ . price_modification_amount AS price_modification_amount_40 , p2_ . price_modification_currency AS price_modification_currency_41 , p2_ . stock_stock AS stock_stock_42 , p2_ . stock_reserved AS stock_reserved_43 , c3_ . id AS id_44 , c3_ . name AS name_45 , c3_ . slug AS slug_46 , c3_ . description AS description_47 , c3_ . lft AS lft_48 , c3_ . lvl AS lvl_49 , c3_ . rgt AS rgt_50 , c3_ . position AS position_51 , d0_ . product_id AS product_id_52 , d0_ . product_variant_id AS product_variant_id_53 , d0_ . category_id AS category_id_54 , d0_ . customer_group_id AS customer_group_id_55 , p1_ . vat_id AS vat_id_56 , p1_ . main_category_id AS main_category_id_57 , p2_ . product_id AS product_id_58 , c3_ . image_id AS image_id_59 , c3_ . tree_root AS tree_root_60 , c3_ . parent_id AS parent_id_61 FROM discount d0_ LEFT JOIN product p1_ ON d0_ . product_id = p1_ . id LEFT JOIN product_variant p2_ ON d0_ . product_variant_id = p2_ . id LEFT JOIN category c3_ ON d0_ . category_id = c3_ . id WHERE d0_ . active = ? AND d0_ . code IS NULL AND ((d0_ . active_from IS NULL OR d0_ . active_from < = ? )) AND ((d0_ . active_to IS NULL OR d0_ . active_to > = ? )) AND d0_ . customer_group_id IS NULL AND ((d0_ . target = ? AND d0_ . product_variant_id IN (? , ? , ? , ? , ? , ? )) OR (d0_ . target = ? AND d0_ . product_id IN (? , ? , ? , ? , ? , ? )) OR (d0_ . target = ? AND d0_ . category_id IN (SELECT c4_ . id FROM category c4_ WHERE EXISTS (SELECT c5_ . id FROM category c5_ WHERE c5_ . id IN (? , ? , ? , ? , ? ) AND c5_ . tree_root = c4_ . tree_root AND c5_ . lft > = c4_ . lft AND c5_ . rgt < = c4_ . rgt ))))
Parameters :
[
1
"2026-03-09 17:46:29 "
"2026-03-09 17:46:29 "
"product_variant "
"47d82780-9546-4e86-a6ea-11226d079135 "
"f4eaa657-e4d9-4564-a254-cbafca4b8556 "
"479bd059-6b50-4a19-bd9a-9eaadc06ab7c "
"67aab323-3356-4bcc-b174-3581d25944d5 "
"d7d80237-e1dc-49ff-bdcf-799ecdd77d5f "
"eb21123f-6080-4cae-9679-053ef4de9672 "
"product "
"7a79ea94-236b-4062-a3b5-5a047d63c05f "
"7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f "
"9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f "
"2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f "
"adb9d694-d757-469e-8a76-d95e6d5b7824 "
"3fdfb7bc-49b9-46b9-9431-366c90e2605e "
"category "
"9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b "
"6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a "
"5c3e1d7a-9f6b-4a0c-1e4d-3b8f0a5c6e7f "
"6b4d2c8f-0e7a-4f1b-2d5c-4a9e1f6b7d8c "
"4f2b0a6d-8c5e-4d9f-0b3a-2e7c9d4f5b6a "
]
SELECT
d0_ . id AS id_0 ,
d0_ . name AS name_1 ,
d0_ . code AS code_2 ,
d0_ . target AS target_3 ,
d0_ . type AS type_4 ,
d0_ . value AS value_5 ,
d0_ . active_from AS active_from_6 ,
d0_ . active_to AS active_to_7 ,
d0_ . minimum_quantity AS minimum_quantity_8 ,
d0_ . active AS active_9 ,
p1_ . id AS id_10 ,
p1_ . name AS name_11 ,
p1_ . description AS description_12 ,
p1_ . short_description AS short_description_13 ,
p1_ . code AS code_14 ,
p1_ . ean AS ean_15 ,
p1_ . unit AS unit_16 ,
p1_ . active AS active_17 ,
p1_ . can_be_bought AS can_be_bought_18 ,
p1_ . in_stock_text AS in_stock_text_19 ,
p1_ . out_of_stock_text AS out_of_stock_text_20 ,
p1_ . filter_parameter_value_ids AS filter_parameter_value_ids_21 ,
p1_ . filter_variant_value_ids AS filter_variant_value_ids_22 ,
p1_ . seo_title AS seo_title_23 ,
p1_ . seo_description AS seo_description_24 ,
p1_ . seo_url AS seo_url_25 ,
p1_ . stock_stock AS stock_stock_26 ,
p1_ . stock_reserved AS stock_reserved_27 ,
p1_ . logistic_weight AS logistic_weight_28 ,
p1_ . logistic_size_width AS logistic_size_width_29 ,
p1_ . logistic_size_height AS logistic_size_height_30 ,
p1_ . logistic_size_length AS logistic_size_length_31 ,
p1_ . price_amount AS price_amount_32 ,
p1_ . price_currency AS price_currency_33 ,
p1_ . purchase_price_amount AS purchase_price_amount_34 ,
p1_ . purchase_price_currency AS purchase_price_currency_35 ,
p2_ . id AS id_36 ,
p2_ . code AS code_37 ,
p2_ . is_default AS is_default_38 ,
p2_ . weight_modification AS weight_modification_39 ,
p2_ . price_modification_amount AS price_modification_amount_40 ,
p2_ . price_modification_currency AS price_modification_currency_41 ,
p2_ . stock_stock AS stock_stock_42 ,
p2_ . stock_reserved AS stock_reserved_43 ,
c3_ . id AS id_44 ,
c3_ . name AS name_45 ,
c3_ . slug AS slug_46 ,
c3_ . description AS description_47 ,
c3_ . lft AS lft_48 ,
c3_ . lvl AS lvl_49 ,
c3_ . rgt AS rgt_50 ,
c3_ . position AS position_51 ,
d0_ . product_id AS product_id_52 ,
d0_ . product_variant_id AS product_variant_id_53 ,
d0_ . category_id AS category_id_54 ,
d0_ . customer_group_id AS customer_group_id_55 ,
p1_ . vat_id AS vat_id_56 ,
p1_ . main_category_id AS main_category_id_57 ,
p2_ . product_id AS product_id_58 ,
c3_ . image_id AS image_id_59 ,
c3_ . tree_root AS tree_root_60 ,
c3_ . parent_id AS parent_id_61
FROM
discount d0_
LEFT JOIN product p1_ ON d0_ . product_id = p1_ . id
LEFT JOIN product_variant p2_ ON d0_ . product_variant_id = p2_ . id
LEFT JOIN category c3_ ON d0_ . category_id = c3_ . id
WHERE
d0_ . active = ?
AND d0_ . code IS NULL
AND (
(
d0_ . active_from IS NULL
OR d0_ . active_from < = ?
)
)
AND (
(
d0_ . active_to IS NULL
OR d0_ . active_to > = ?
)
)
AND d0_ . customer_group_id IS NULL
AND (
(
d0_ . target = ?
AND d0_ . product_variant_id IN (? , ? , ? , ? , ? , ? )
)
OR (
d0_ . target = ?
AND d0_ . product_id IN (? , ? , ? , ? , ? , ? )
)
OR (
d0_ . target = ?
AND d0_ . category_id IN (
SELECT
c4_ . id
FROM
category c4_
WHERE
EXISTS (
SELECT
c5_ . id
FROM
category c5_
WHERE
c5_ . id IN (? , ? , ? , ? , ? )
AND c5_ . tree_root = c4_ . tree_root
AND c5_ . lft > = c4_ . lft
AND c5_ . rgt < = c4_ . rgt
)
)
)
)
Copy
SELECT d0_ . id AS id_0 , d0_ . name AS name_1 , d0_ . code AS code_2 , d0_ . target AS target_3 , d0_ . type AS type_4 , d0_ . value AS value_5 , d0_ . active_from AS active_from_6 , d0_ . active_to AS active_to_7 , d0_ . minimum_quantity AS minimum_quantity_8 , d0_ . active AS active_9 , p1_ . id AS id_10 , p1_ . name AS name_11 , p1_ . description AS description_12 , p1_ . short_description AS short_description_13 , p1_ . code AS code_14 , p1_ . ean AS ean_15 , p1_ . unit AS unit_16 , p1_ . active AS active_17 , p1_ . can_be_bought AS can_be_bought_18 , p1_ . in_stock_text AS in_stock_text_19 , p1_ . out_of_stock_text AS out_of_stock_text_20 , p1_ . filter_parameter_value_ids AS filter_parameter_value_ids_21 , p1_ . filter_variant_value_ids AS filter_variant_value_ids_22 , p1_ . seo_title AS seo_title_23 , p1_ . seo_description AS seo_description_24 , p1_ . seo_url AS seo_url_25 , p1_ . stock_stock AS stock_stock_26 , p1_ . stock_reserved AS stock_reserved_27 , p1_ . logistic_weight AS logistic_weight_28 , p1_ . logistic_size_width AS logistic_size_width_29 , p1_ . logistic_size_height AS logistic_size_height_30 , p1_ . logistic_size_length AS logistic_size_length_31 , p1_ . price_amount AS price_amount_32 , p1_ . price_currency AS price_currency_33 , p1_ . purchase_price_amount AS purchase_price_amount_34 , p1_ . purchase_price_currency AS purchase_price_currency_35 , p2_ . id AS id_36 , p2_ . code AS code_37 , p2_ . is_default AS is_default_38 , p2_ . weight_modification AS weight_modification_39 , p2_ . price_modification_amount AS price_modification_amount_40 , p2_ . price_modification_currency AS price_modification_currency_41 , p2_ . stock_stock AS stock_stock_42 , p2_ . stock_reserved AS stock_reserved_43 , c3_ . id AS id_44 , c3_ . name AS name_45 , c3_ . slug AS slug_46 , c3_ . description AS description_47 , c3_ . lft AS lft_48 , c3_ . lvl AS lvl_49 , c3_ . rgt AS rgt_50 , c3_ . position AS position_51 , d0_ . product_id AS product_id_52 , d0_ . product_variant_id AS product_variant_id_53 , d0_ . category_id AS category_id_54 , d0_ . customer_group_id AS customer_group_id_55 , p1_ . vat_id AS vat_id_56 , p1_ . main_category_id AS main_category_id_57 , p2_ . product_id AS product_id_58 , c3_ . image_id AS image_id_59 , c3_ . tree_root AS tree_root_60 , c3_ . parent_id AS parent_id_61 FROM discount d0_ LEFT JOIN product p1_ ON d0_ . product_id = p1_ . id LEFT JOIN product_variant p2_ ON d0_ . product_variant_id = p2_ . id LEFT JOIN category c3_ ON d0_ . category_id = c3_ . id WHERE d0_ . active = 1 AND d0_ . code IS NULL AND ((d0_ . active_from IS NULL OR d0_ . active_from < = '2026-03-09 17:46:29' )) AND ((d0_ . active_to IS NULL OR d0_ . active_to > = '2026-03-09 17:46:29' )) AND d0_ . customer_group_id IS NULL AND ((d0_ . target = 'product_variant' AND d0_ . product_variant_id IN ('47d82780-9546-4e86-a6ea-11226d079135' , 'f4eaa657-e4d9-4564-a254-cbafca4b8556' , '479bd059-6b50-4a19-bd9a-9eaadc06ab7c' , '67aab323-3356-4bcc-b174-3581d25944d5' , 'd7d80237-e1dc-49ff-bdcf-799ecdd77d5f' , 'eb21123f-6080-4cae-9679-053ef4de9672' )) OR (d0_ . target = 'product' AND d0_ . product_id IN ('7a79ea94-236b-4062-a3b5-5a047d63c05f' , '7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f' , '9a4c2e6f-8b3d-4a1e-7c9f-3b5d8e2a4c6f' , '2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f' , 'adb9d694-d757-469e-8a76-d95e6d5b7824' , '3fdfb7bc-49b9-46b9-9431-366c90e2605e' )) OR (d0_ . target = 'category' AND d0_ . category_id IN (SELECT c4_ . id FROM category c4_ WHERE EXISTS (SELECT c5_ . id FROM category c5_ WHERE c5_ . id IN ('9a7c5b1e-3d0f-4e4a-5c8b-7f2d4e9a0c1b' , '6f4b2a8d-0c7e-4d1f-2b5a-4e9c1d6f7b8a' , '5c3e1d7a-9f6b-4a0c-1e4d-3b8f0a5c6e7f' , '6b4d2c8f-0e7a-4f1b-2d5c-4a9e1f6b7d8c' , '4f2b0a6d-8c5e-4d9f-0b3a-2e7c9d4f5b6a' ) AND c5_ . tree_root = c4_ . tree_root AND c5_ . lft > = c4_ . lft AND c5_ . rgt < = c4_ . rgt ))));
Copy
14
0.83 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d}' )
GROUP BY unnested_value ;
Copy
15
0.39 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13}' )
GROUP BY unnested_value ;
Copy
16
0.39 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f}' )
GROUP BY unnested_value ;
Copy
17
0.38 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642}' )
GROUP BY unnested_value ;
Copy
18
0.38 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35}' )
GROUP BY unnested_value ;
Copy
19
0.37 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d,8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_parameter_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d,8e85442d-8616-48ff-8b24-2e8aec165027,77d73b6e-ba4c-461c-a022-d80f824b116b,bf3d495a-37c3-4c0a-8f61-fed434ff2d13}' )
GROUP BY unnested_value ;
Copy
20
0.39 ms
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY (? )
GROUP BY unnested_value
Parameters :
[
"{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f,9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642,7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35} "
]
SELECT
unnested_value :: text as value_id ,
COUNT (* ) as count
FROM product p ,
LATERAL unnest (p . filter_variant_value_ids ) as unnested_value
WHERE p . active = true
AND unnested_value = ANY ('{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f,9b880df1-482c-4f0e-ac91-304c0554dd93,8a6a4c62-3a9a-47fa-8935-5b2c8edef512,63a4b4eb-5b5d-48a1-94a7-7af3764f5642,7efc6872-b156-4bf2-afb8-33d03ede6097,cbb9595f-a34d-4ddc-aa9b-e58e92bf8cf4,cef1c56c-c574-4e6b-a3f7-7643f0376f35}' )
GROUP BY unnested_value ;
Copy
21
0.80 ms
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . slug AS slug_2 , s0_ . content AS content_3 , s0_ . show_contact_form AS show_contact_form_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . seo_title AS seo_title_7 , s0_ . seo_description AS seo_description_8 , s0_ . seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_ . title ASC
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . slug AS slug_2 , s0_ . content AS content_3 , s0_ . show_contact_form AS show_contact_form_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . seo_title AS seo_title_7 , s0_ . seo_description AS seo_description_8 , s0_ . seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_ . title ASC ;
Copy
22
0.41 ms
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . slug AS slug_2 , s0_ . content AS content_3 , s0_ . show_contact_form AS show_contact_form_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . seo_title AS seo_title_7 , s0_ . seo_description AS seo_description_8 , s0_ . seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_ . title ASC
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . slug AS slug_2 , s0_ . content AS content_3 , s0_ . show_contact_form AS show_contact_form_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . seo_title AS seo_title_7 , s0_ . seo_description AS seo_description_8 , s0_ . seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_ . title ASC ;
Copy
23
0.75 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC ;
Copy
24
0.67 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . description AS description_3 , c0_ . lft AS lft_4 , c0_ . lvl AS lvl_5 , c0_ . rgt AS rgt_6 , c0_ . position AS position_7 FROM category c0_ ORDER BY c0_ . tree_root ASC , c0_ . lft ASC ;
Copy
25
0.86 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 :
[
"7a79ea94-236b-4062-a3b5-5a047d63c05f "
]
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 = '7a79ea94-236b-4062-a3b5-5a047d63c05f' ;
Copy
26
0.46 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"f34410e4-6b10-4cd6-955b-b2b0a5ade713 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = 'f34410e4-6b10-4cd6-955b-b2b0a5ade713' ;
Copy
27
0.59 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 :
[
"7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f "
]
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 = '7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f' ;
Copy
28
0.45 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"ed9da486-d46c-4fb8-a59a-b7c167f08c12 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = 'ed9da486-d46c-4fb8-a59a-b7c167f08c12' ;
Copy
29
0.43 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
30
0.39 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"c75c88dd-f892-4d09-a59e-c94ed723c5c4 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = 'c75c88dd-f892-4d09-a59e-c94ed723c5c4' ;
Copy
31
0.40 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 :
[
"2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f "
]
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 = '2c5f8e3a-9b1d-4f7c-a6e2-8d4b3c1a5e9f' ;
Copy
32
0.31 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"d3a05a92-2543-424d-a69b-93741aededa9 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = 'd3a05a92-2543-424d-a69b-93741aededa9' ;
Copy
33
0.34 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
34
0.29 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"8bd5c5a9-6610-41b4-831b-96a4a18ad681 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = '8bd5c5a9-6610-41b4-831b-96a4a18ad681' ;
Copy
35
0.34 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 :
[
"3fdfb7bc-49b9-46b9-9431-366c90e2605e "
]
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 = '3fdfb7bc-49b9-46b9-9431-366c90e2605e' ;
Copy
36
0.31 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = ?
Parameters :
[
"f5e5078f-097e-4f59-aae9-3550912b6808 "
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . mime_type AS mime_type_3 FROM file t0 WHERE t0 . id = 'f5e5078f-097e-4f59-aae9-3550912b6808' ;
Copy