1
3.46 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 , c1_ . cart_id AS cart_id_67 , c1_ . product_variant_id AS product_variant_id_68 , p2_ . product_id AS product_id_69 , p3_ . vat_id AS vat_id_70 , p3_ . main_category_id AS main_category_id_71 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 ,
c1_ . cart_id AS cart_id_67 ,
c1_ . product_variant_id AS product_variant_id_68 ,
p2_ . product_id AS product_id_69 ,
p3_ . vat_id AS vat_id_70 ,
p3_ . main_category_id AS main_category_id_71
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 , c1_ . cart_id AS cart_id_67 , c1_ . product_variant_id AS product_variant_id_68 , p2_ . product_id AS product_id_69 , p3_ . vat_id AS vat_id_70 , p3_ . main_category_id AS main_category_id_71 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
3.65 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