11.57 ms
2
"COMMIT"
2.02 ms
1
UPDATE `product` SET `media` = IFNULL (
(
SELECT `product_media` . `product_id`
FROM `product_media`
WHERE `product_media` . `product_id` = `product` . id
AND `product_media` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `media` = IFNULL (
(
SELECT `product_media` . `product_id`
FROM `product_media`
WHERE `product_media` . `product_id` = `product` . id
AND `product_media` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
1.46 ms
1
UPDATE `product` SET `categories` = IFNULL (
(
SELECT `product_category` . `product_id`
FROM `product_category`
WHERE `product_category` . `product_id` = `product` . id
AND `product_category` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `categories` = IFNULL (
(
SELECT `product_category` . `product_id`
FROM `product_category`
WHERE `product_category` . `product_id` = `product` . id
AND `product_category` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
1.19 ms
1
UPDATE `product` SET `prices` = IFNULL (
(
SELECT `product_price` . `product_id`
FROM `product_price`
WHERE `product_price` . `product_id` = `product` . id
AND `product_price` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `prices` = IFNULL (
(
SELECT `product_price` . `product_id`
FROM `product_price`
WHERE `product_price` . `product_id` = `product` . id
AND `product_price` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
1.07 ms
1
UPDATE `product` SET `properties` = IFNULL (
(
SELECT `product_property` . `product_id`
FROM `product_property`
WHERE `product_property` . `product_id` = `product` . id
AND `product_property` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `properties` = IFNULL (
(
SELECT `product_property` . `product_id`
FROM `product_property`
WHERE `product_property` . `product_id` = `product` . id
AND `product_property` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
1.03 ms
1
UPDATE `product` SET `customFieldSets` = IFNULL (
(
SELECT `product_custom_field_set` . `product_id`
FROM `product_custom_field_set`
WHERE `product_custom_field_set` . `product_id` = `product` . id
AND `product_custom_field_set` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `customFieldSets` = IFNULL (
(
SELECT `product_custom_field_set` . `product_id`
FROM `product_custom_field_set`
WHERE `product_custom_field_set` . `product_id` = `product` . id
AND `product_custom_field_set` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
1.02 ms
1
UPDATE `product` SET `translations` = IFNULL (
(
SELECT `product_translation` . `product_id`
FROM `product_translation`
WHERE `product_translation` . `product_id` = `product` . id
AND `product_translation` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `translations` = IFNULL (
(
SELECT `product_translation` . `product_id`
FROM `product_translation`
WHERE `product_translation` . `product_id` = `product` . id
AND `product_translation` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.94 ms
1
UPDATE `product` SET `visibilities` = IFNULL (
(
SELECT `product_visibility` . `product_id`
FROM `product_visibility`
WHERE `product_visibility` . `product_id` = `product` . id
AND `product_visibility` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `visibilities` = IFNULL (
(
SELECT `product_visibility` . `product_id`
FROM `product_visibility`
WHERE `product_visibility` . `product_id` = `product` . id
AND `product_visibility` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.92 ms
1
UPDATE `product` SET `crossSellings` = IFNULL (
(
SELECT `product_cross_selling` . `product_id`
FROM `product_cross_selling`
WHERE `product_cross_selling` . `product_id` = `product` . id
AND `product_cross_selling` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `crossSellings` = IFNULL (
(
SELECT `product_cross_selling` . `product_id`
FROM `product_cross_selling`
WHERE `product_cross_selling` . `product_id` = `product` . id
AND `product_cross_selling` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.92 ms
1
UPDATE `product` SET `warehouseGroups` = IFNULL (
(
SELECT `product_warehouse_group` . `product_id`
FROM `product_warehouse_group`
WHERE `product_warehouse_group` . `product_id` = `product` . id
AND `product_warehouse_group` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `warehouseGroups` = IFNULL (
(
SELECT `product_warehouse_group` . `product_id`
FROM `product_warehouse_group`
WHERE `product_warehouse_group` . `product_id` = `product` . id
AND `product_warehouse_group` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.83 ms
1
UPDATE `product` SET `warehouses` = IFNULL (
(
SELECT `product_warehouse` . `product_id`
FROM `product_warehouse`
WHERE `product_warehouse` . `product_id` = `product` . id
AND `product_warehouse` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `warehouses` = IFNULL (
(
SELECT `product_warehouse` . `product_id`
FROM `product_warehouse`
WHERE `product_warehouse` . `product_id` = `product` . id
AND `product_warehouse` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.82 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `deliveryTime` = IFNULL (`product` . `delivery_time_id` , parent . `delivery_time_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `deliveryTime` = IFNULL (`product` . `delivery_time_id` , parent . `delivery_time_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.78 ms
1
UPDATE `product` SET `customPrice` = IFNULL (
(
SELECT `custom_price` . `product_id`
FROM `custom_price`
WHERE `custom_price` . `product_id` = `product` . id
AND `custom_price` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `customPrice` = IFNULL (
(
SELECT `custom_price` . `product_id`
FROM `custom_price`
WHERE `custom_price` . `product_id` = `product` . id
AND `custom_price` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.76 ms
1
UPDATE `product` SET `tags` = IFNULL (
(
SELECT `product_tag` . `product_id`
FROM `product_tag`
WHERE `product_tag` . `product_id` = `product` . id
AND `product_tag` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `tags` = IFNULL (
(
SELECT `product_tag` . `product_id`
FROM `product_tag`
WHERE `product_tag` . `product_id` = `product` . id
AND `product_tag` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.74 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `tax` = IFNULL (`product` . `tax_id` , parent . `tax_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `tax` = IFNULL (`product` . `tax_id` , parent . `tax_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.73 ms
1
UPDATE `product` AS `product`
SET `product` . `manufacturer` = `product` . `product_manufacturer_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `manufacturer` = `product` . `product_manufacturer_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.73 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `cover` = IFNULL (`product` . `product_media_id` , parent . `product_media_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `cover` = IFNULL (`product` . `product_media_id` , parent . `product_media_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.72 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `unit` = IFNULL (`product` . `unit_id` , parent . `unit_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `unit` = IFNULL (`product` . `unit_id` , parent . `unit_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.72 ms
1
UPDATE `product` AS `product`
SET `product` . `cmsPage` = `product` . `cms_page_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `cmsPage` = `product` . `cms_page_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.70 ms
1
UPDATE `product` SET `subscriptionPlans` = IFNULL (
(
SELECT `subscription_plan_product_mapping` . `product_id`
FROM `subscription_plan_product_mapping`
WHERE `subscription_plan_product_mapping` . `product_id` = `product` . id
AND `subscription_plan_product_mapping` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (? )
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` SET `subscriptionPlans` = IFNULL (
(
SELECT `subscription_plan_product_mapping` . `product_id`
FROM `subscription_plan_product_mapping`
WHERE `subscription_plan_product_mapping` . `product_id` = `product` . id
AND `subscription_plan_product_mapping` . `product_version_id` = `product` . version_id
LIMIT 1
),
IFNULL (`product` . parent_id , `product` . id )
)
WHERE `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.70 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `cmsPage` = IFNULL (`product` . `cms_page_id` , parent . `cms_page_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `cmsPage` = IFNULL (`product` . `cms_page_id` , parent . `cms_page_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.70 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `canonicalProduct` = IFNULL (`product` . `canonical_product_id` , parent . `canonical_product_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `canonicalProduct` = IFNULL (`product` . `canonical_product_id` , parent . `canonical_product_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.65 ms
1
UPDATE `product` AS `product`
SET `product` . `unit` = `product` . `unit_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `unit` = `product` . `unit_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.65 ms
1
UPDATE `product` AS `product`
SET `product` . `deliveryTime` = `product` . `delivery_time_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `deliveryTime` = `product` . `delivery_time_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.64 ms
1
UPDATE `product` AS `product`
SET `product` . `cover` = `product` . `product_media_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `cover` = `product` . `product_media_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.64 ms
1
SELECT DISTINCT LOWER (HEX (product_stream_id ))
FROM product_stream_mapping
WHERE product_stream_mapping . product_id IN (? )
AND product_stream_mapping . product_version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
SELECT DISTINCT LOWER (HEX (product_stream_id ))
FROM product_stream_mapping
WHERE product_stream_mapping . product_id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )
AND product_stream_mapping . product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.63 ms
1
UPDATE `product` AS `product`
SET `product` . `featureSet` = `product` . `product_feature_set_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `featureSet` = `product` . `product_feature_set_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.62 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `manufacturer` = IFNULL (`product` . `product_manufacturer_id` , parent . `product_manufacturer_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `manufacturer` = IFNULL (`product` . `product_manufacturer_id` , parent . `product_manufacturer_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.62 ms
1
UPDATE `product` AS `product`
SET `product` . `tax` = `product` . `tax_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `tax` = `product` . `tax_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.61 ms
1
UPDATE `product` as `product` , `product` as parent
SET `product` . `featureSet` = IFNULL (`product` . `product_feature_set_id` , parent . `product_feature_set_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (? )AND `product` . version_id = parent . version_id
AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` as `product` , `product` as parent
SET `product` . `featureSet` = IFNULL (`product` . `product_feature_set_id` , parent . `product_feature_set_id` )
WHERE `product` . parent_id = parent . id
AND `product` . parent_id IS NOT NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = parent . version_id
AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.57 ms
1
UPDATE `product` AS `product`
SET `product` . `canonicalProduct` = `product` . `canonical_product_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (? )AND `product` . version_id = ?
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product` AS `product`
SET `product` . `canonicalProduct` = `product` . `canonical_product_id`
WHERE `product` . parent_id IS NULL
AND `product` . id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 )AND `product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.47 ms
1
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ;
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ; ;
Copy
0.41 ms
1
SELECT `acl_role` . `privileges`
FROM `acl_role`
INNER JOIN `app` ON `app` . `acl_role_id` = `acl_role` . `id`
WHERE `app` . `integration_id` = ?
Parameters :
[
b"\x01 ›ÛÛÿh}ÑŽ%š³ÐoWÌ ]
SELECT `acl_role` . `privileges`
FROM `acl_role`
INNER JOIN `app` ON `app` . `acl_role_id` = `acl_role` . `id`
WHERE `app` . `integration_id` = 0x019BDBDBFF687DD18D259AB3D06F57CC
; Copy
0.36 ms
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.29 ms
1
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
; Copy
0.29 ms
1
UPDATE `product_cross_selling_assigned_products` SET `cross_selling_id` = ? , `product_id` = ? , `product_version_id` = ? , `position` = ? , `updated_at` = ? WHERE id = ? AND product_version_id = ?
Parameters :
[
b"‡±AVýîÆ«²kA AD\x1A "
b"\x00\x00\f m°~~~~~~~~~\x00\x02 \x0F ©\x1C ãéjK¾KÙÎu,4%1
"2026-05-13 12:29:29.939 "
b"&\x18 y¢ü»À¡?\x00 \0\x1C ŒÝ» "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% ]
UPDATE `product_cross_selling_assigned_products` SET `cross_selling_id` = 0x8790B14156FDEEC6ABB26B412041441A , `product_id` = 0x00000C6DB07E7E7E7E7E7E7E7E7E0002 , `product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 , `position` = 1 , `updated_at` = '2026-05-13 12:29:29.939' WHERE id = 0x261879A2FCBBC0A13F005C301C8CDDBB AND product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ; Copy
0.29 ms
1
SELECT DISTINCT LOWER (HEX (product . parent_id )) as id FROM product WHERE id IN (? )
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 ]
SELECT DISTINCT LOWER (HEX (product . parent_id )) as id FROM product WHERE id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 ); Copy
0.27 ms
1
SELECT id FROM integration WHERE access_key = ?
Parameters :
[
"SWIAAVYYDXPOT09WCLDDBZFNQW "
]
SELECT id FROM integration WHERE access_key = 'SWIAAVYYDXPOT09WCLDDBZFNQW' ; Copy
0.24 ms
1
SELECT 1 as `exists` , `id` , `product_version_id` FROM `product_cross_selling_assigned_products` WHERE (`id` , `product_version_id` ) IN ((? , ? ))
Parameters :
[
b"&\x18 y¢ü»À¡?\x00 \0\x1C ŒÝ» "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% ]
SELECT 1 as `exists` , `id` , `product_version_id` FROM `product_cross_selling_assigned_products` WHERE (`id` , `product_version_id` ) IN ((0x261879A2FCBBC0A13F005C301C8CDDBB , 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 )); Copy
0.24 ms
1
SELECT LOWER (HEX (`product_id` )) FROM `product_cross_selling` WHERE `id` = ?
Parameters :
[
b"‡±AVýîÆ«²kA AD\x1A "
]
SELECT LOWER (HEX (`product_id` )) FROM `product_cross_selling` WHERE `id` = 0x8790B14156FDEEC6ABB26B412041441A ; Copy
0.22 ms
1
DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL )
DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL ); Copy
0.22 ms
1
SELECT DISTINCT LOWER (HEX (id )) as id FROM product WHERE parent_id IN (? )
Parameters :
[
b"\x00\x00\f m¶~~~~~~~~~\x00\x02 ]
SELECT DISTINCT LOWER (HEX (id )) as id FROM product WHERE parent_id IN (0x00000C6DB67E7E7E7E7E7E7E7E7E0002 ); Copy
0.21 ms
1
SELECT `alias` , `index` FROM admin_elasticsearch_index_task
SELECT `alias` , `index` FROM admin_elasticsearch_index_task ; Copy
0.21 ms
1
SELECT 1 as `exists` FROM `product_cross_selling_assigned_products` WHERE (`id` = ? ) AND (`product_version_id` = ? )
Parameters :
[
b"&\x18 y¢ü»À¡?\x00 \0\x1C ŒÝ» "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% ]
SELECT 1 as `exists` FROM `product_cross_selling_assigned_products` WHERE (`id` = 0x261879A2FCBBC0A13F005C301C8CDDBB ) AND (`product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ); Copy
0.19 ms
1
SELECT admin FROM `integration` WHERE id = ?
Parameters :
[
b"\x01 ›ÛÛÿh}ÑŽ%š³ÐoWÌ ]
SELECT admin FROM `integration` WHERE id = 0x019BDBDBFF687DD18D259AB3D06F57CC ; Copy
0.19 ms
1
SELECT role . privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping . acl_role_id = role . id WHERE mapping . integration_id = ?
Parameters :
[
b"\x01 ›ÛÛÿh}ÑŽ%š³ÐoWÌ ]
SELECT role . privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping . acl_role_id = role . id WHERE mapping . integration_id = 0x019BDBDBFF687DD18D259AB3D06F57CC ; Copy
0.19 ms
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters :
[
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA ; Copy
0.18 ms
2
"START TRANSACTION"
"START TRANSACTION" ; Copy
0.17 ms
1
DELETE FROM b2b_order_number WHERE custom_ordernumber IN (NULL )
DELETE FROM b2b_order_number WHERE custom_ordernumber IN (NULL ); Copy