2.78 ms (10.93%)
1
SELECT o0_ . id AS id_0 , e1_ . id AS id_1 , CASE WHEN e1_ . display_name IS NOT NULL AND e1_ . display_name < > '' THEN e1_ . display_name ELSE e1_ . name END AS sclr_2 , CASE WHEN o0_ . import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3 , CASE WHEN o2_ . id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4 , e1_ . code AS code_5 , o0_ . id AS id_6 , o0_ . uuid AS uuid_7 , o0_ . type AS type_8 , o0_ . vintage AS vintage_9 , o0_ . packaging_flat AS packaging_flat_10 , o0_ . packaging_value AS packaging_value_11 , o0_ . is_flat AS is_flat_12 , o0_ . format_filled AS format_filled_13 , o0_ . type AS type_14 , p3_ . uuid AS uuid_15 , p3_ . name AS name_16 , p3_ . display_name AS display_name_17 , p3_ . code AS code_18 , e4_ . id AS id_19 , o0_ . category AS category_20 , p5_ . name AS name_21 , p5_ . code AS code_22 , p6_ . name AS name_23 , o0_ . qty AS qty_24 , o0_ . price AS price_25 , o0_ . last_update AS last_update_26 , o0_ . unoficial_qty AS unoficial_qty_27 , o0_ . unoficial_price AS unoficial_price_28 , o0_ . unoficial_update AS unoficial_update_29 , o0_ . status AS status_30 , o0_ . created_by_name AS created_by_name_31 , o0_ . comment AS comment_32 , o0_ . status AS status_33 , e1_ . provisioning AS provisioning_34 , p7_ . price AS price_35 , p7_ . recommended_price AS recommended_price_36 , e1_ . offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_ . format_id = p5_ . id LEFT JOIN product_packaging p6_ ON o0_ . packaging_id = p6_ . id LEFT JOIN entity e1_ ON o0_ . entity_id = e1_ . id LEFT JOIN offer_favourite o2_ ON (o2_ . offer_id = o0_ . id ) LEFT JOIN product p3_ ON o0_ . product_id = p3_ . id LEFT JOIN entity e4_ ON p3_ . entity_id = e4_ . id LEFT JOIN product_vintage p7_ ON p3_ . id = p7_ . product_id AND (p7_ . product_id = p3_ . id AND p7_ . year = o0_ . vintage ) WHERE (((e1_ . id < > e4_ . id OR (e1_ . id = e4_ . id AND o0_ . price < > 0 )) OR ((o0_ . price = 0 AND o0_ . qty < > 0 ) OR (o0_ . price = 0 AND o0_ . unoficial_qty < > 0 ) OR (o0_ . price = 0 AND o0_ . unoficial_price < > 0 )))) AND e1_ . ignore_import = ? AND p3_ . uuid = ? AND o0_ . vintage = ? AND e1_ . status = ? AND o0_ . status = 1 AND o0_ . qty > 0 AND o0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY CASE WHEN (o0_ . format_id = 3 AND o0_ . format_filled = 1 ) THEN 0 ELSE 1 END ASC , CASE WHEN e1_ . id = e4_ . id THEN 0 ELSE 1 END ASC , CASE WHEN (CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN o0_ . price ELSE COALESCE (o0_ . unoficial_price , o0_ . price ) END = 0 ) THEN 1 ELSE 0 END ASC , CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN o0_ . price ELSE COALESCE (o0_ . unoficial_price , o0_ . price ) END ASC , o0_ . last_update DESC
Parameters :
[
0
"cd64e941-2745-492a-96bd-c1830bd99cab "
2020
1
208594
26335
224193
246593
176917
14426
30986
140025
9219
9220
76948
244477
3708
169786
102284
94580
51510
129338
20288
20289
194002
19196
75212
75887
154868
15074
129339
103129
3710
154867
162588
224192
76949
224191
224190
15075
15076
]
SELECT
o0_ . id AS id_0 ,
e1_ . id AS id_1 ,
CASE WHEN e1_ . display_name IS NOT NULL
AND e1_ . display_name < > '' THEN
e1_ . display_name
ELSE
e1_ . name
END AS sclr_2 ,
CASE WHEN o0_ . import_process_id = 1 THEN
'manual'
ELSE
'import'
END AS sclr_3 ,
CASE WHEN o2_ . id IS NOT NULL THEN
1
ELSE
0
END AS sclr_4 ,
e1_ . code AS code_5 ,
o0_ . id AS id_6 ,
o0_ . uuid AS uuid_7 ,
o0_ . type AS type_8 ,
o0_ . vintage AS vintage_9 ,
o0_ . packaging_flat AS packaging_flat_10 ,
o0_ . packaging_value AS packaging_value_11 ,
o0_ . is_flat AS is_flat_12 ,
o0_ . format_filled AS format_filled_13 ,
o0_ . type AS type_14 ,
p3_ . uuid AS uuid_15 ,
p3_ . name AS name_16 ,
p3_ . display_name AS display_name_17 ,
p3_ . code AS code_18 ,
e4_ . id AS id_19 ,
o0_ . category AS category_20 ,
p5_ . name AS name_21 ,
p5_ . code AS code_22 ,
p6_ . name AS name_23 ,
o0_ . qty AS qty_24 ,
o0_ . price AS price_25 ,
o0_ . last_update AS last_update_26 ,
o0_ . unoficial_qty AS unoficial_qty_27 ,
o0_ . unoficial_price AS unoficial_price_28 ,
o0_ . unoficial_update AS unoficial_update_29 ,
o0_ . status AS status_30 ,
o0_ . created_by_name AS created_by_name_31 ,
o0_ . comment AS comment_32 ,
o0_ . status AS status_33 ,
e1_ . provisioning AS provisioning_34 ,
p7_ . price AS price_35 ,
p7_ . recommended_price AS recommended_price_36 ,
e1_ . offer_type AS offer_type_37
FROM
offer o0_
LEFT JOIN product_format p5_ ON o0_ . format_id = p5_ . id
LEFT JOIN product_packaging p6_ ON o0_ . packaging_id = p6_ . id
LEFT JOIN entity e1_ ON o0_ . entity_id = e1_ . id
LEFT JOIN offer_favourite o2_ ON (o2_ . offer_id = o0_ . id )
LEFT JOIN product p3_ ON o0_ . product_id = p3_ . id
LEFT JOIN entity e4_ ON p3_ . entity_id = e4_ . id
LEFT JOIN product_vintage p7_ ON p3_ . id = p7_ . product_id
AND (
p7_ . product_id = p3_ . id
AND p7_ . year = o0_ . vintage
)
WHERE
(
(
(
e1_ . id < > e4_ . id
OR (
e1_ . id = e4_ . id
AND o0_ . price < > 0
)
)
OR (
(
o0_ . price = 0
AND o0_ . qty < > 0
)
OR (
o0_ . price = 0
AND o0_ . unoficial_qty < > 0
)
OR (
o0_ . price = 0
AND o0_ . unoficial_price < > 0
)
)
)
)
AND e1_ . ignore_import = ?
AND p3_ . uuid = ?
AND o0_ . vintage = ?
AND e1_ . status = ?
AND o0_ . status = 1
AND o0_ . qty > 0
AND o0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ?
)
ORDER BY
CASE WHEN (
o0_ . format_id = 3
AND o0_ . format_filled = 1
) THEN
0
ELSE
1
END ASC ,
CASE WHEN e1_ . id = e4_ . id THEN
0
ELSE
1
END ASC ,
CASE WHEN (
CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN
o0_ . price
ELSE
COALESCE (o0_ . unoficial_price , o0_ . price )
END = 0
) THEN
1
ELSE
0
END ASC ,
CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN
o0_ . price
ELSE
COALESCE (o0_ . unoficial_price , o0_ . price )
END ASC ,
o0_ . last_update DESC
Copy
SELECT o0_ . id AS id_0 , e1_ . id AS id_1 , CASE WHEN e1_ . display_name IS NOT NULL AND e1_ . display_name < > '' THEN e1_ . display_name ELSE e1_ . name END AS sclr_2 , CASE WHEN o0_ . import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3 , CASE WHEN o2_ . id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4 , e1_ . code AS code_5 , o0_ . id AS id_6 , o0_ . uuid AS uuid_7 , o0_ . type AS type_8 , o0_ . vintage AS vintage_9 , o0_ . packaging_flat AS packaging_flat_10 , o0_ . packaging_value AS packaging_value_11 , o0_ . is_flat AS is_flat_12 , o0_ . format_filled AS format_filled_13 , o0_ . type AS type_14 , p3_ . uuid AS uuid_15 , p3_ . name AS name_16 , p3_ . display_name AS display_name_17 , p3_ . code AS code_18 , e4_ . id AS id_19 , o0_ . category AS category_20 , p5_ . name AS name_21 , p5_ . code AS code_22 , p6_ . name AS name_23 , o0_ . qty AS qty_24 , o0_ . price AS price_25 , o0_ . last_update AS last_update_26 , o0_ . unoficial_qty AS unoficial_qty_27 , o0_ . unoficial_price AS unoficial_price_28 , o0_ . unoficial_update AS unoficial_update_29 , o0_ . status AS status_30 , o0_ . created_by_name AS created_by_name_31 , o0_ . comment AS comment_32 , o0_ . status AS status_33 , e1_ . provisioning AS provisioning_34 , p7_ . price AS price_35 , p7_ . recommended_price AS recommended_price_36 , e1_ . offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_ . format_id = p5_ . id LEFT JOIN product_packaging p6_ ON o0_ . packaging_id = p6_ . id LEFT JOIN entity e1_ ON o0_ . entity_id = e1_ . id LEFT JOIN offer_favourite o2_ ON (o2_ . offer_id = o0_ . id ) LEFT JOIN product p3_ ON o0_ . product_id = p3_ . id LEFT JOIN entity e4_ ON p3_ . entity_id = e4_ . id LEFT JOIN product_vintage p7_ ON p3_ . id = p7_ . product_id AND (p7_ . product_id = p3_ . id AND p7_ . year = o0_ . vintage ) WHERE (((e1_ . id < > e4_ . id OR (e1_ . id = e4_ . id AND o0_ . price < > 0 )) OR ((o0_ . price = 0 AND o0_ . qty < > 0 ) OR (o0_ . price = 0 AND o0_ . unoficial_qty < > 0 ) OR (o0_ . price = 0 AND o0_ . unoficial_price < > 0 )))) AND e1_ . ignore_import = 0 AND p3_ . uuid = 'cd64e941-2745-492a-96bd-c1830bd99cab' AND o0_ . vintage = 2020 AND e1_ . status = 1 AND o0_ . status = 1 AND o0_ . qty > 0 AND o0_ . id IN (208594 , 26335 , 224193 , 246593 , 176917 , 14426 , 30986 , 140025 , 9219 , 9220 , 76948 , 244477 , 3708 , 169786 , 102284 , 94580 , 51510 , 129338 , 20288 , 20289 , 194002 , 19196 , 75212 , 75887 , 154868 , 15074 , 129339 , 103129 , 3710 , 154867 , 162588 , 224192 , 76949 , 224191 , 224190 , 15075 , 15076 ) ORDER BY CASE WHEN (o0_ . format_id = 3 AND o0_ . format_filled = 1 ) THEN 0 ELSE 1 END ASC , CASE WHEN e1_ . id = e4_ . id THEN 0 ELSE 1 END ASC , CASE WHEN (CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN o0_ . price ELSE COALESCE (o0_ . unoficial_price , o0_ . price ) END = 0 ) THEN 1 ELSE 0 END ASC , CASE WHEN o0_ . price < = COALESCE (o0_ . unoficial_price , o0_ . price ) THEN o0_ . price ELSE COALESCE (o0_ . unoficial_price , o0_ . price ) END ASC , o0_ . last_update DESC ;
Copy
0.68 ms (2.69%)
1
SELECT *
FROM offer_history oh
WHERE oh . offer_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
208594
26335
224193
246593
176917
14426
30986
9219
140025
9220
76948
244477
3708
169786
102284
94580
51510
129338
20288
20289
194002
19196
75212
75887
154868
15074
129339
103129
3710
154867
162588
224192
76949
224191
224190
15075
15076
]
SELECT *
FROM offer_history oh
WHERE oh . offer_id IN (208594 , 26335 , 224193 , 246593 , 176917 , 14426 , 30986 , 9219 , 140025 , 9220 , 76948 , 244477 , 3708 , 169786 , 102284 , 94580 , 51510 , 129338 , 20288 , 20289 , 194002 , 19196 , 75212 , 75887 , 154868 , 15074 , 129339 , 103129 , 3710 , 154867 , 162588 , 224192 , 76949 , 224191 , 224190 , 15075 , 15076 );
Copy
0.60 ms (2.36%)
1
SELECT t0 . email AS email_1 , t0 . roles AS roles_2 , t0 . password AS password_3 , t0 . need_password_update AS need_password_update_4 , t0 . tryout AS tryout_5 , t0 . firstname AS firstname_6 , t0 . lastname AS lastname_7 , t0 . phone AS phone_8 , t0 . mobile AS mobile_9 , t0 . image AS image_10 , t0 . theme AS theme_11 , t0 . status AS status_12 , t0 . last_login AS last_login_13 , t0 . last_activity AS last_activity_14 , t0 . note AS note_15 , t0 . acl AS acl_16 , t0 . widgets AS widgets_17 , t0 . preferences AS preferences_18 , t0 . notification AS notification_19 , t0 . id AS id_20 , t0 . uuid AS uuid_21 , t0 . company_id AS company_id_22 FROM user t0 WHERE t0 . id = ?
SELECT t0 . email AS email_1 , t0 . roles AS roles_2 , t0 . password AS password_3 , t0 . need_password_update AS need_password_update_4 , t0 . tryout AS tryout_5 , t0 . firstname AS firstname_6 , t0 . lastname AS lastname_7 , t0 . phone AS phone_8 , t0 . mobile AS mobile_9 , t0 . image AS image_10 , t0 . theme AS theme_11 , t0 . status AS status_12 , t0 . last_login AS last_login_13 , t0 . last_activity AS last_activity_14 , t0 . note AS note_15 , t0 . acl AS acl_16 , t0 . widgets AS widgets_17 , t0 . preferences AS preferences_18 , t0 . notification AS notification_19 , t0 . id AS id_20 , t0 . uuid AS uuid_21 , t0 . company_id AS company_id_22 FROM user t0 WHERE t0 . id = 16 ;
Copy
0.59 ms (2.32%)
1
SELECT t0 . code AS code_1 , t0 . display_name AS display_name_2 , t0 . lwin AS lwin_3 , t0 . site AS site_4 , t0 . seller_price_qty AS seller_price_qty_5 , t0 . price AS price_6 , t0 . merged_uuids AS merged_uuids_7 , t0 . has_lwin_suggests AS has_lwin_suggests_8 , t0 . from_import AS from_import_9 , t0 . bundle AS bundle_10 , t0 . id AS id_11 , t0 . uuid AS uuid_12 , t0 . name AS name_13 , t0 . status AS status_14 , t0 . country_id AS country_id_15 , t0 . region_id AS region_id_16 , t0 . sub_region_id AS sub_region_id_17 , t0 . color_id AS color_id_18 , t0 . type_id AS type_id_19 , t0 . sub_type_id AS sub_type_id_20 , t0 . entity_id AS entity_id_21 , t0 . classification_id AS classification_id_22 , t0 . line_id AS line_id_23 , t0 . producer_id AS producer_id_24 FROM product t0 WHERE t0 . id = ?
SELECT t0 . code AS code_1 , t0 . display_name AS display_name_2 , t0 . lwin AS lwin_3 , t0 . site AS site_4 , t0 . seller_price_qty AS seller_price_qty_5 , t0 . price AS price_6 , t0 . merged_uuids AS merged_uuids_7 , t0 . has_lwin_suggests AS has_lwin_suggests_8 , t0 . from_import AS from_import_9 , t0 . bundle AS bundle_10 , t0 . id AS id_11 , t0 . uuid AS uuid_12 , t0 . name AS name_13 , t0 . status AS status_14 , t0 . country_id AS country_id_15 , t0 . region_id AS region_id_16 , t0 . sub_region_id AS sub_region_id_17 , t0 . color_id AS color_id_18 , t0 . type_id AS type_id_19 , t0 . sub_type_id AS sub_type_id_20 , t0 . entity_id AS entity_id_21 , t0 . classification_id AS classification_id_22 , t0 . line_id AS line_id_23 , t0 . producer_id AS producer_id_24 FROM product t0 WHERE t0 . id = 13 ;
Copy