Symfony Profiler

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product_translation`
SET
  `product_id` = ?,
  `language_id` = ?,
  `product_version_id` = ?,
  `updated_at` = ?
WHERE
  product_id = ?
  AND language_id = ?
  AND product_version_id = ?

UPDATE `product_translation` SET `product_id` = 0x8908946485634E72898980A86747C615, `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, `product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `updated_at` = '2025-12-23 10:31:40.983' WHERE product_id = 0x8908946485634E72898980A86747C615 AND language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B AND product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `version_id` = ?,
  `parent_version_id` = ?,
  `product_manufacturer_version_id` = ?,
  `product_media_version_id` = ?,
  `canonical_product_version_id` = ?,
  `cms_page_version_id` = ?,
  `stock` = ?,
  `updated_at` = ?,
  `available_stock` = ?
WHERE
  id = ?
  AND version_id = ?

UPDATE `product` SET `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `parent_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_manufacturer_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_media_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `canonical_product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `cms_page_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `stock` = 72, `updated_at` = '2025-12-23 10:31:40.981', `available_stock` = 72 WHERE id = 0x8908946485634E72898980A86747C615 AND version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

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 = ?

SELECT DISTINCT LOWER(HEX(product_stream_id))
             FROM product_stream_mapping
             WHERE product_stream_mapping.product_id IN (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
             AND product_stream_mapping.product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

SELECT
  1 as `exists`,
  parent_id,
  `id`,
  `version_id`
FROM
  `product`
WHERE
  (
    `id` IN (?)
  )
  AND (version_id = ?)

SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (0x8908946485634E72898980A86747C615)) AND (version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

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 = ?

UPDATE `product` AS `product`
                    SET `product`.`deliveryTime` = `product`.`delivery_time_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"data\":[\"8908946485634e72898980a86747c615\",\"536a4e8234074712b6c75e669912784d\",\"36fb03d0d0f34d06b6cce471f9e555fc\",\"2f43d6e6f15046a8a657a40462e61726\",\"957a7acf32714bf596696a447311f27e\",\"7ba769782f894c80a2f0f6f46672f4a2\",\"cf7b7e08855146c2bf02e223780616ef\",\"ef6ceae331df4cd18c7365192296b346\",\"3d2a1c2ecff845c69abbfd240d77f431\",\"c4913104d59e4e7788fe754b06e65048\",\"3cd3904f5b2c41709ead6aaa0988af45\",\"db277434e42e415fbbb40ce8a5284f7b\",\"b86f8ff48e5a43d59405fc5ffb412910\",\"cfe35e042fee4546afde19c1eddcb57b\",\"698b879378664229a69bac39dddf92ad\",\"a31d3d5067a34f5181e43050ef30353e\",\"d6e764ec969e4aa3acc3c6c068816735\",\"7ebaec5d279d4e2c8dbf8d520aa821cf\",\"7b71e5e1a4e14f919de9b63ffb6207eb\",\"6e767146fa344b71b250f0a5c38a872b\"],\"offset\":null,\"indexer\":\"product.indexer\",\"context\":{\"extensions\":{\"swag.publisher.common-update-change-detector\":{\"extensions\":[]}},\"languageIdChain\":[\"2fbb5fe2e29a4d70aa5854ce7ce3e20b\"],\"scope\":\"crud\",\"rulesLocked\":false,\"source\":{\"type\":\"admin-api\",\"isAdmin\":true,\"permissions\":[],\"userId\":null,\"integrationId\":\"a5bddebe1bc84691baf177538ab6c935\"},\"ruleIds\":[],\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"versionId\":\"0fa91ce3e96a4bc2be4bd9ce752c3425\",\"currencyFactor\":1.0,\"considerInheritance\":false,\"taxState\":\"gross\",\"rounding\":{\"extensions\":[],\"decimals\":2,\"interval\":0.01,\"roundForNet\":true}},\"skip\":[\"product.inheritance\",\"product.stock\"],\"forceQueue\":false,\"isFullIndexing\":false}', '{\"type\":\"Shopware\\\\Core\\\\Content\\\\Product\\\\DataAbstractionLayer\\\\ProductIndexingMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-12-23 10:31:41', '2025-12-23 10:31:41');

SELECT
  1 as `exists`,
  `product_id`,
  `language_id`,
  `product_version_id`
FROM
  `product_translation`
WHERE
  (
    `product_id`, `language_id`, `product_version_id`
  ) IN (
    (?, ?, ?)
  )

SELECT 1 as `exists`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((0x8908946485634E72898980A86747C615,0x2FBB5FE2E29A4D70AA5854CE7CE3E20B,0x0FA91CE3E96A4BC2BE4BD9CE752C3425));

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

SELECT
  1 as `exists`
FROM
  `product_translation`
WHERE
  (`product_id` = ?)
  AND (`language_id` = ?)
  AND (`product_version_id` = ?)

SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = 0x8908946485634E72898980A86747C615) AND (`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (`product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

SELECT
  1 as `exists`,
  parent_id
FROM
  `product`
WHERE
  (`id` = ?)
  AND (`version_id` = ?)

SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = 0x8908946485634E72898980A86747C615) AND (`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

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 = ?

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 (0x8908946485634E72898980A86747C615, 0x536A4E8234074712B6C75E669912784D, 0x36FB03D0D0F34D06B6CCE471F9E555FC, 0x2F43D6E6F15046A8A657A40462E61726, 0x957A7ACF32714BF596696A447311F27E, 0x7BA769782F894C80A2F0F6F46672F4A2, 0xCF7B7E08855146C2BF02E223780616EF, 0xEF6CEAE331DF4CD18C7365192296B346, 0x3D2A1C2ECFF845C69ABBFD240D77F431, 0xC4913104D59E4E7788FE754B06E65048, 0x3CD3904F5B2C41709EAD6AAA0988AF45, 0xDB277434E42E415FBBB40CE8A5284F7B, 0xB86F8FF48E5A43D59405FC5FFB412910, 0xCFE35E042FEE4546AFDE19C1EDDCB57B, 0x698B879378664229A69BAC39DDDF92AD, 0xA31D3D5067A34F5181E43050EF30353E, 0xD6E764EC969E4AA3ACC3C6C068816735, 0x7EBAEC5D279D4E2C8DBF8D520AA821CF, 0x7B71E5E1A4E14F919DE9B63FFB6207EB, 0x6E767146FA344B71B250F0A5C38A872B)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

# apps::webhooks::read
SELECT
  `webhook`.`id` as `webhook.id`,
  `webhook`.`name` as `webhook.name`,
  `webhook`.`event_name` as `webhook.eventName`,
  `webhook`.`url` as `webhook.url`,
  `webhook`.`only_live_version` as `webhook.onlyLiveVersion`,
  `webhook`.`error_count` as `webhook.errorCount`,
  `webhook`.`active` as `webhook.active`,
  `webhook`.`app_id` as `webhook.appId`,
  `webhook`.`created_at` as `webhook.createdAt`,
  `webhook`.`updated_at` as `webhook.updatedAt`,
  `webhook.app`.`id` as `webhook.app.id`,
  `webhook.app`.`name` as `webhook.app.name`,
  `webhook.app`.`path` as `webhook.app.path`,
  `webhook.app`.`author` as `webhook.app.author`,
  `webhook.app`.`copyright` as `webhook.app.copyright`,
  `webhook.app`.`license` as `webhook.app.license`,
  `webhook.app`.`active` as `webhook.app.active`,
  `webhook.app`.`configurable` as `webhook.app.configurable`,
  `webhook.app`.`privacy` as `webhook.app.privacy`,
  `webhook.app`.`version` as `webhook.app.version`,
  `webhook.app`.`icon` as `webhook.app.iconRaw`,
  `webhook.app`.`app_secret` as `webhook.app.appSecret`,
  `webhook.app`.`modules` as `webhook.app.modules`,
  `webhook.app`.`main_module` as `webhook.app.mainModule`,
  `webhook.app`.`cookies` as `webhook.app.cookies`,
  `webhook.app`.`allow_disable` as `webhook.app.allowDisable`,
  `webhook.app`.`base_app_url` as `webhook.app.baseAppUrl`,
  `webhook.app`.`allowed_hosts` as `webhook.app.allowedHosts`,
  `webhook.app`.`template_load_priority` as `webhook.app.templateLoadPriority`,
  `webhook.app`.`checkout_gateway_url` as `webhook.app.checkoutGatewayUrl`,
  `webhook.app`.`integration_id` as `webhook.app.integrationId`,
  `webhook.app.integration`.`id` as `webhook.app.integration.id`,
  `webhook.app.integration`.`label` as `webhook.app.integration.label`,
  `webhook.app.integration`.`access_key` as `webhook.app.integration.accessKey`,
  `webhook.app.integration`.`secret_access_key` as `webhook.app.integration.secretAccessKey`,
  `webhook.app.integration`.`last_usage_at` as `webhook.app.integration.lastUsageAt`,
  `webhook.app.integration`.`admin` as `webhook.app.integration.admin`,
  `webhook.app.integration`.`custom_fields` as `webhook.app.integration.customFields`,
  `webhook.app.integration`.`deleted_at` as `webhook.app.integration.deletedAt`,
  `webhook.app.integration`.`created_at` as `webhook.app.integration.createdAt`,
  `webhook.app.integration`.`updated_at` as `webhook.app.integration.updatedAt`,
  `webhook.app`.`acl_role_id` as `webhook.app.aclRoleId`,
  `webhook.app.aclRole`.`id` as `webhook.app.aclRole.id`,
  `webhook.app.aclRole`.`name` as `webhook.app.aclRole.name`,
  `webhook.app.aclRole`.`description` as `webhook.app.aclRole.description`,
  `webhook.app.aclRole`.`privileges` as `webhook.app.aclRole.privileges`,
  `webhook.app.aclRole`.`deleted_at` as `webhook.app.aclRole.deletedAt`,
  `webhook.app.aclRole`.`created_at` as `webhook.app.aclRole.createdAt`,
  `webhook.app.aclRole`.`updated_at` as `webhook.app.aclRole.updatedAt`,
  `webhook.app`.`created_at` as `webhook.app.createdAt`,
  `webhook.app`.`updated_at` as `webhook.app.updatedAt`,
  `webhook.app.translation.label`,
  COALESCE(
    `webhook.app.translation.label`,
    `webhook.app.translation.label`
  ) as `webhook.app.label`,
  `webhook.app.translation.description`,
  COALESCE(
    `webhook.app.translation.description`,
    `webhook.app.translation.description`
  ) as `webhook.app.description`,
  `webhook.app.translation.privacyPolicyExtensions`,
  COALESCE(
    `webhook.app.translation.privacyPolicyExtensions`,
    `webhook.app.translation.privacyPolicyExtensions`
  ) as `webhook.app.privacyPolicyExtensions`,
  `webhook.app.translation.customFields`,
  COALESCE(
    `webhook.app.translation.customFields`,
    `webhook.app.translation.customFields`
  ) as `webhook.app.customFields`,
  `webhook.app.translation.createdAt`,
  `webhook.app.translation.updatedAt`,
  `webhook.app.translation.appId`,
  `webhook.app.translation.languageId`
FROM
  `webhook`
  LEFT JOIN `app` `webhook.app` ON `webhook`.`app_id` = `webhook.app`.`id`
  LEFT JOIN (
    SELECT
      `webhook.app.translation`.app_id,
      `webhook.app.translation`.label as `webhook.app.translation.label`,
      `webhook.app.translation`.description as `webhook.app.translation.description`,
      `webhook.app.translation`.privacy_policy_extensions as `webhook.app.translation.privacyPolicyExtensions`,
      `webhook.app.translation`.custom_fields as `webhook.app.translation.customFields`,
      `webhook.app.translation`.created_at as `webhook.app.translation.createdAt`,
      `webhook.app.translation`.updated_at as `webhook.app.translation.updatedAt`,
      `webhook.app.translation`.app_id as `webhook.app.translation.appId`,
      `webhook.app.translation`.language_id as `webhook.app.translation.languageId`
    FROM
      `app_translation` `webhook.app.translation`
    WHERE
      `webhook.app.translation`.language_id = ?
  ) `webhook.app.app_translation` ON `webhook.app.app_translation`.`app_id` = `webhook.app`.`id`
  LEFT JOIN `integration` `webhook.app.integration` ON `webhook.app`.`integration_id` = `webhook.app.integration`.`id`
  LEFT JOIN `acl_role` `webhook.app.aclRole` ON `webhook.app`.`acl_role_id` = `webhook.app.aclRole`.`id`
WHERE
  (`webhook`.`active` = ?)