3.31 ms (16.87%)
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
"82c982bd-7bd5-467f-91d8-63c2c7840d76 "
1989
1
254052
32739
208261
237346
223853
]
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 = '82c982bd-7bd5-467f-91d8-63c2c7840d76' AND o0_ . vintage = 1989 AND e1_ . status = 1 AND o0_ . status = 1 AND o0_ . qty > 0 AND o0_ . id IN (254052 , 32739 , 208261 , 237346 , 223853 ) 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.75 ms (3.81%)
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.53 ms (2.72%)
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 = 96 ;
Copy