1 |
0.82 ms |
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 = 2;
|
5 |
1.48 ms |
SELECT o.id, o.uuid, o.vintage, o.type as offerType, o.price, o.qty, o.unoficial_price, o.unoficial_qty, o.format_filled, f.name as formatName, pack.name as packagingName, o.packaging_flat, o.packaging_value, o.is_flat, o.comment, e.provisioning, o.status, vint.price as releasePrice, vint.recommended_price as recommandedPrice,
CASE
WHEN e.display_name IS NOT NULL AND e.display_name != ''
THEN e.display_name
ELSE e.name
END AS entityDisplayName,
CASE
WHEN pr.display_name IS NOT NULL AND pr.display_name != ''
THEN pr.display_name
ELSE pr.name
END AS productDisplayName
FROM offer o
LEFT JOIN entity e ON o.entity_id = e.id
LEFT JOIN product pr ON o.product_id = pr.id
LEFT JOIN product_format f ON o.format_id = f.id
LEFT JOIN product_packaging pack ON o.packaging_id = pack.id
LEFT JOIN product_vintage vint ON o.product_id = vint.product_id AND o.vintage = vint.year
WHERE o.uuid IN (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"2b78420f-3cd8-411a-82dd-b72ac562e254"
"1fff2c69-f0aa-46f2-8079-e6c6c4ef96e3"
"2152e813-ddad-421d-9cdc-64b326de9a3f"
"0ffadbeb-b949-4029-8c87-4d7c967622d0"
"1f6be9a9-1571-4245-93b7-d924cf7ec5b1"
"40340a77-85ff-4684-88ef-4068db954af3"
"145af212-8c74-4089-89bc-6bd91ee449aa"
]
SELECT o.id, o.uuid, o.vintage, o.type as offerType, o.price, o.qty, o.unoficial_price, o.unoficial_qty, o.format_filled, f.name as formatName, pack.name as packagingName, o.packaging_flat, o.packaging_value, o.is_flat, o.comment, e.provisioning, o.status, vint.price as releasePrice, vint.recommended_price as recommandedPrice,
CASE
WHEN e.display_name IS NOT NULL AND e.display_name != ''
THEN e.display_name
ELSE e.name
END AS entityDisplayName,
CASE
WHEN pr.display_name IS NOT NULL AND pr.display_name != ''
THEN pr.display_name
ELSE pr.name
END AS productDisplayName
FROM offer o
LEFT JOIN entity e ON o.entity_id = e.id
LEFT JOIN product pr ON o.product_id = pr.id
LEFT JOIN product_format f ON o.format_id = f.id
LEFT JOIN product_packaging pack ON o.packaging_id = pack.id
LEFT JOIN product_vintage vint ON o.product_id = vint.product_id AND o.vintage = vint.year
WHERE o.uuid IN ('2b78420f-3cd8-411a-82dd-b72ac562e254', '1fff2c69-f0aa-46f2-8079-e6c6c4ef96e3', '2152e813-ddad-421d-9cdc-64b326de9a3f', '0ffadbeb-b949-4029-8c87-4d7c967622d0', '1f6be9a9-1571-4245-93b7-d924cf7ec5b1', '40340a77-85ff-4684-88ef-4068db954af3', '145af212-8c74-4089-89bc-6bd91ee449aa') ;
|