Symfony Profiler

Query Metrics

217 Database Queries
124 Different statements
156.98 ms Query time
Queries


# dbal-plugin-loader
        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 `key`, `value` FROM `app_config`
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 item_rounding FROM currency WHERE id = ?
SELECT id FROM integration WHERE access_key = ?
SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?
SELECT admin FROM `integration` WHERE id = ?
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
SELECT 1 as `exists`, `product_cross_selling_id`, `language_id` FROM `product_cross_selling_translation` WHERE (`product_cross_selling_id`,`language_id`) IN ((?,?),(?,?))
SELECT 1 as `exists`, `id` FROM `product_cross_selling` WHERE `id` IN (?)
SELECT 1 as `exists` FROM `product_cross_selling_translation` WHERE (`product_cross_selling_id` = ?) AND (`language_id` = ?)
SELECT 1 as `exists` FROM `product_cross_selling_translation` WHERE (`product_cross_selling_id` = ?) AND (`language_id` = ?)
"START TRANSACTION"
UPDATE `product_cross_selling` SET `product_id` = ?, `type` = ?, `active` = ?, `updated_at` = ? WHERE id = ?
UPDATE `product_cross_selling_translation` SET `product_cross_selling_id` = ?, `language_id` = ?, `name` = ?, `updated_at` = ? WHERE product_cross_selling_id = ? AND language_id = ?
UPDATE `product_cross_selling_translation` SET `product_cross_selling_id` = ?, `language_id` = ?, `name` = ?, `updated_at` = ? WHERE product_cross_selling_id = ? AND language_id = ?
"COMMIT"
DELETE FROM acris_cross_selling_discount_mapping WHERE lower(HEX(cross_selling_id)) LIKE "8790b14156fdeec6abb26b412041441a"
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `acris_cross_s_d` `product_cross_selling.acrisCrossSellingDisplay` ON `product_cross_selling`.`id` = `product_cross_selling.acrisCrossSellingDisplay`.`product_cross_selling_id` LEFT JOIN `product_cross_selling_assigned_products` `product_cross_selling.assignedProducts` ON `product_cross_selling`.`id` = `product_cross_selling.assignedProducts`.`cross_selling_id` WHERE ((((`product_cross_selling`.`id` IN (?)) AND `product_cross_selling`.`active` = ? AND ((`product_cross_selling`.`type` = ? AND (`product_cross_selling.assignedProducts`.`cross_selling_id` IN (?))) OR (`product_cross_selling`.`type` = ? AND NOT (`product_cross_selling`.`product_stream_id` <=> ?))) AND NOT (`product_cross_selling.acrisCrossSellingDisplay`.`discount_type` <=> ?) AND NOT (`product_cross_selling.acrisCrossSellingDisplay`.`discount` <=> ?) AND (`product_cross_selling.acrisCrossSellingDisplay`.`discount` > ?) AND (`product_cross_selling.acrisCrossSellingDisplay`.`product_cross_selling_id` IN (?))))) AND (`product_cross_selling`.`id` IN (?)) GROUP BY `product_cross_selling`.`id`
"START TRANSACTION"
DELETE FROM b2b_order_number WHERE custom_ordernumber IN (NULL)
"COMMIT"
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 = ?
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 `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 `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 `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 `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 `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 `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 `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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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`, `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 = ?
UPDATE `product` AS `product`
                    SET `product`.`tax` = `product`.`tax_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
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 = ?
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 = ?
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 = ?
UPDATE `product` AS `product`
                    SET `product`.`unit` = `product`.`unit_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
SELECT DISTINCT LOWER(HEX(product.parent_id)) as id FROM product WHERE id IN (?)
SELECT DISTINCT LOWER(HEX(id)) as id FROM product WHERE parent_id IN (?)
SELECT DISTINCT LOWER(HEX(`id`))
             FROM product
             WHERE `id` IN (?)
             AND `parent_id` IS NULL
SELECT product.id as id, product.variant_listing_config as config, (SELECT COUNT(id) FROM product as child WHERE product.id = child.parent_id) as child_count FROM product WHERE (product.version_id = ?) AND (product.id IN (?))
UPDATE product SET display_group = NULL WHERE product.id = :id AND product.version_id = :versionId
UPDATE product SET display_group = MD5(HEX(product.parent_id)) WHERE product.parent_id = :id AND product.version_id = :versionId
"START TRANSACTION"
UPDATE `product`  as parent
                LEFT JOIN
                (
                    SELECT parent_id, count(id) total
                    FROM   `product`
                    WHERE parent_id in (?)
                    AND version_id = ?
                    GROUP BY parent_id
                ) child ON parent.id = child.parent_id
            SET parent.child_count = IFNULL(child.total, 0)
            WHERE parent.id IN (?)
            AND parent.version_id = ?
"COMMIT"
SELECT id, api_filter FROM product_stream WHERE invalid = 0 AND api_filter IS NOT NULL
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?, ?, ?, ?, ?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`product_number` IN (?, ?, ?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((((`product`.`id` IN (?, ?, ?, ?)) OR (`product`.`parent_id` IN (?, ?, ?, ?))))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((((`product`.`id` IN (?, ?, ?, ?)) OR (`product`.`parent_id` IN (?, ?, ?, ?))))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((((`product`.`id` IN (?, ?, ?, ?, ?, ?)) OR (`product`.`parent_id` IN (?, ?, ?, ?, ?, ?))))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((((`product`.`id` IN (?, ?, ?, ?)) OR (`product`.`parent_id` IN (?, ?, ?, ?))))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((((`product`.`id` IN (?)) OR (`product`.`parent_id` IN (?))))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((((`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?) AND (`product`.`id` = ? OR `product`.`parent_id` = ?))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR ((`product`.`product_number` IN (?, ?)))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND (COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ? OR COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ? OR COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ? OR COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_media` `product.media` ON `product`.`media` = `product.media`.`product_id` AND `product`.version_id = `product.media`.product_version_id LEFT JOIN `media` `product.media.media` ON `product.media`.`media_id` = `product.media.media`.`id` WHERE (`product`.`version_id` = ?) AND (((`product.media.media`.`file_size` >= ?) AND (`product`.`id` IN (?)))) GROUP BY `product`.`id`
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ? AND NOT (`product`.`product_number` <=> ?)) OR (NOT (`product`.`product_number` <=> ?))) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?) OR (IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?) OR (`product`.`product_number` = ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`name` as `product.parent.translation.name` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((((IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND COALESCE(`product.translation.name`,`product.parent.translation.name`) LIKE ?)) AND (`product`.`id` IN (?))))
"START TRANSACTION"
DELETE FROM product_stream_mapping WHERE product_id IN (?)
SAVEPOINT DOCTRINE_2
INSERT INTO `product_stream_mapping` (`product_id`, `product_version_id`, `product_stream_id`) VALUES (?,?,?), (?,?,?);
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"
UPDATE `product`
SET `product`.`property_ids` = (
    SELECT CONCAT('[', GROUP_CONCAT(JSON_QUOTE(LOWER(HEX(`product_property`.`property_group_option_id`)))), ']')
    FROM `product_property`
    WHERE `product_property`.`product_id` = `product`.`properties`
    AND `product`.version_id = `product_property`.product_version_id
)
WHERE `product`.id IN (?)
AND `product`.version_id = ?
UPDATE `product`
SET `product`.`option_ids` = (
    SELECT CONCAT('[', GROUP_CONCAT(JSON_QUOTE(LOWER(HEX(`product_option`.`property_group_option_id`)))), ']')
    FROM `product_option`
    WHERE `product_option`.`product_id` = `product`.`id`
    AND `product`.version_id = `product_option`.product_version_id
)
WHERE `product`.id IN (?)
AND `product`.version_id = ?
UPDATE `product`
SET `product`.`stream_ids` = (
    SELECT CONCAT('[', GROUP_CONCAT(JSON_QUOTE(LOWER(HEX(`product_stream_mapping`.`product_stream_id`)))), ']')
    FROM `product_stream_mapping`
    WHERE `product_stream_mapping`.`product_id` = `product`.`id`
    AND `product`.version_id = `product_stream_mapping`.product_version_id
)
WHERE `product`.id IN (?)
AND `product`.version_id = ?
UPDATE `product`
SET `product`.`tag_ids` = (
    SELECT CONCAT('[', GROUP_CONCAT(JSON_QUOTE(LOWER(HEX(`product_tag`.`tag_id`)))), ']')
    FROM `product_tag`
    WHERE `product_tag`.`product_id` = `product`.`tags`
    AND `product`.version_id = `product_tag`.product_version_id
)
WHERE `product`.id IN (?)
AND `product`.version_id = ?
UPDATE `product`
SET `product`.`category_ids` = (
    SELECT CONCAT('[', GROUP_CONCAT(JSON_QUOTE(LOWER(HEX(`product_category`.`category_id`)))), ']')
    FROM `product_category`
    WHERE `product_category`.`product_id` = `product`.`categories`
    AND `product`.version_id = `product_category`.product_version_id
)
WHERE `product`.id IN (?)
AND `product`.version_id = ?
SELECT LOWER(HEX(product.id)) as product_id, GROUP_CONCAT(category.path SEPARATOR '') as paths, GROUP_CONCAT(LOWER(HEX(category.id)) SEPARATOR '|') as ids FROM product LEFT JOIN product_category mapping ON mapping.product_id = product.categories AND mapping.product_version_id = product.version_id LEFT JOIN category category ON mapping.category_id = category.id AND mapping.category_version_id = category.version_id AND mapping.category_version_id = ? WHERE (product.categories IN (?)) AND (product.version_id = ?) GROUP BY product.id
"START TRANSACTION"
DELETE FROM product_category_tree WHERE `product_id` IN (?, ?) AND `product_version_id` = ?
"COMMIT"
"START TRANSACTION"
UPDATE product SET category_tree = :tree WHERE id = :id AND version_id = :version
UPDATE product SET category_tree = :tree WHERE id = :id AND version_id = :version
"COMMIT"
"START TRANSACTION"
INSERT IGNORE INTO `product_category_tree` (`product_id`, `product_version_id`, `category_id`, `category_version_id`) VALUES (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?), (?,?,?,?);
"COMMIT"
SELECT LOWER(HEX(IFNULL(product.parent_id, product.id))) as parent_id, LOWER(HEX(product.id)) as variant_id, LOWER(HEX(price.rule_id)) as rule_id, LOWER(HEX(IFNULL(product.unit_id, parent.unit_id))) as unit_id, IFNULL(product.purchase_unit, parent.purchase_unit) as purchase_unit, IFNULL(product.reference_unit, parent.reference_unit) as reference_unit, IFNULL(product.min_purchase, parent.min_purchase) as min_purchase, price.price, price.quantity_start != 1 as is_ranged FROM product INNER JOIN product_price price ON price.product_id = product.prices AND product.version_id = price.product_version_id LEFT JOIN product parent ON parent.id = product.parent_id WHERE (product.id IN (?) OR product.parent_id IN (?)) AND (product.version_id = ?) AND (IFNULL(product.active, parent.active) = 1) AND ((product.child_count = 0 OR product.parent_id IS NOT NULL)) AND (price.quantity_end IS NULL)
SELECT LOWER(HEX(IFNULL(product.parent_id, product.id))) as parent_id, LOWER(HEX(product.id)) as variant_id, NULL as rule_id, 0 AS is_ranged, product.price as price, IFNULL(product.min_purchase, parent.min_purchase) as min_purchase, LOWER(HEX(IFNULL(product.unit_id, parent.unit_id))) as unit_id, IFNULL(product.purchase_unit, parent.purchase_unit) as purchase_unit, IFNULL(product.reference_unit, parent.reference_unit) as reference_unit, product.child_count as child_count FROM product LEFT JOIN product parent ON product.parent_id = parent.id WHERE (product.id IN (?) OR product.parent_id IN (?)) AND (product.version_id = ?) AND (IFNULL(product.active, parent.active) = 1 OR product.child_count > 0)
UPDATE product SET cheapest_price = :price WHERE id = :id AND version_id = :version
SELECT id, cheapest_price_accessor FROM product WHERE parent_id = ? AND version_id = ?
UPDATE product SET rating_average = NULL WHERE (parent_id IN (?) OR id IN (?)) AND version_id = ?
SELECT IFNULL(product.parent_id, product.id) as id, AVG(product_review.points) as average FROM product_review LEFT JOIN product product ON product.id = product_review.product_id OR product.parent_id = product_review.product_id WHERE (product_review.status = 1) AND (product.id IN (?) OR product.parent_id IN (?)) AND (product.version_id = ?) GROUP BY IFNULL(product.parent_id, product.id)
SELECT LOWER(HEX(`product`.`id`)) as id,
                IF(`product_download`.`id` IS NOT NULL, 1, 0) as hasDownloads,
                `product`.`states`
                FROM `product`
                LEFT JOIN `product_download` ON `product`.`id` = `product_download`.`product_id`
                AND `product`.`version_id` = `product_download`.`product_version_id`
                WHERE `product`.`id` IN (?)
                AND `product`.`version_id` = ?
                GROUP BY `product`.`id`
UPDATE product SET updated_at = ? WHERE id IN (?)
UPDATE elasticsearch_index_task SET `doc_count` = `doc_count` - ? WHERE `index` = ?
SELECT LOWER(HEX(`language_id`)), LOWER(HEX(`sales_channel_id`)) as salesChannelId FROM sales_channel_language
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(p.active, pp.active) AS active,
    p.available AS available,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'name', tag.name,'id', LOWER(HEX(tag.id))
             )
         ),
    ']'
) as tags,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'visibility', product_visibility.visibility,'salesChannelId', LOWER(HEX(product_visibility.sales_channel_id))
             )
         ),
    ']'
) as visibilities,
    IFNULL(p.manufacturer_number, pp.manufacturer_number) AS manufacturerNumber,
    IFNULL(p.available_stock, pp.available_stock) AS availableStock,
    IFNULL(p.rating_average, pp.rating_average) AS ratingAverage,
    p.product_number as productNumber,
    p.sales,
    LOWER(HEX(p.manufacturer)) AS productManufacturerId,
    LOWER(HEX(p.delivery_time_id)) as deliveryTimeId,
    IFNULL(p.shipping_free, pp.shipping_free) AS shippingFree,
    IFNULL(p.is_closeout, pp.is_closeout) AS isCloseout,
    LOWER(HEX(IFNULL(p.product_media_id, pp.product_media_id))) AS coverId,
    IFNULL(p.weight, pp.weight) AS weight,
    IFNULL(p.length, pp.length) AS length,
    IFNULL(p.height, pp.height) AS height,
    IFNULL(p.width, pp.width) AS width,
    IFNULL(p.release_date, pp.release_date) AS releaseDate,
    IFNULL(p.created_at, pp.created_at) AS createdAt,
    IFNULL(p.category_tree, pp.category_tree) AS categoryTree,
    IFNULL(p.category_ids, pp.category_ids) AS categoryIds,
    IFNULL(p.option_ids, pp.option_ids) AS optionIds,
    IFNULL(p.property_ids, pp.property_ids) AS propertyIds,
    IFNULL(p.tag_ids, pp.tag_ids) AS tagIds,
    LOWER(HEX(IFNULL(p.tax_id, pp.tax_id))) AS taxId,
    IFNULL(p.stock, pp.stock) AS stock,
    IFNULL(p.ean, pp.ean) AS ean,
    IFNULL(p.mark_as_topseller, pp.mark_as_topseller) AS markAsTopseller,
    p.auto_increment as autoIncrement,
    p.display_group as displayGroup,
    IFNULL(p.cheapest_price_accessor, pp.cheapest_price_accessor) as cheapest_price_accessor,
    LOWER(HEX(p.parent_id)) as parentId,
    p.child_count as childCount,
    p.states

FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
    LEFT JOIN product_visibility ON(product_visibility.product_id = p.visibilities AND product_visibility.product_version_id = p.version_id)
    LEFT JOIN product_tag ON (product_tag.product_id = p.tags AND product_tag.product_version_id = p.version_id)
    LEFT JOIN tag ON tag.id = product_tag.tag_id

WHERE p.id IN (?) AND p.version_id = ? AND (p.child_count = 0 OR p.parent_id IS NOT NULL OR JSON_EXTRACT(`p`.`variant_listing_config`, "$.displayParent") = 1)

GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.name, product_parent.name) AS name,
    IFNULL(product_main.description, product_parent.description) AS description,
    IFNULL(product_main.meta_title, product_parent.meta_title) AS metaTitle,
    IFNULL(product_main.meta_description, product_parent.meta_description) AS metaDescription,
    product_main.custom_fields AS customFields,
    product_parent.custom_fields AS parentCustomFields,
    IFNULL(product_main.custom_search_keywords, product_parent.custom_search_keywords) AS customSearchKeywords,
    manufacturer.name AS manufacturerName,
    delivery_time_translation.name as deliveryTimeName,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'languageId', LOWER(HEX(category.language_id)),'id', LOWER(HEX(category.category_id)),'name', category.name
             )
         ),
    ']'
) as categories
FROM product p
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_manufacturer_translation manufacturer ON manufacturer.product_manufacturer_id = p.manufacturer AND manufacturer.language_id = ? AND manufacturer.product_manufacturer_version_id = p.version_id AND manufacturer.name IS NOT NULL
    LEFT JOIN product_category ON (product_category.product_id = p.categories AND product_category.product_version_id = p.version_id)
    LEFT JOIN category_translation category ON category.category_id = product_category.category_id AND category.category_version_id = product_category.category_version_id AND category.name IS NOT NULL AND category.language_id = ?
    LEFT JOIN delivery_time_translation ON delivery_time_translation.delivery_time_id = p.delivery_time_id AND delivery_time_translation.language_id = ?

WHERE p.id IN (?) AND p.version_id = ?

GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.name, product_parent.name) AS name,
    IFNULL(product_main.description, product_parent.description) AS description,
    IFNULL(product_main.meta_title, product_parent.meta_title) AS metaTitle,
    IFNULL(product_main.meta_description, product_parent.meta_description) AS metaDescription,
    product_main.custom_fields AS customFields,
    product_parent.custom_fields AS parentCustomFields,
    IFNULL(product_main.custom_search_keywords, product_parent.custom_search_keywords) AS customSearchKeywords,
    manufacturer.name AS manufacturerName,
    delivery_time_translation.name as deliveryTimeName,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'languageId', LOWER(HEX(category.language_id)),'id', LOWER(HEX(category.category_id)),'name', category.name
             )
         ),
    ']'
) as categories
FROM product p
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_manufacturer_translation manufacturer ON manufacturer.product_manufacturer_id = p.manufacturer AND manufacturer.language_id = ? AND manufacturer.product_manufacturer_version_id = p.version_id AND manufacturer.name IS NOT NULL
    LEFT JOIN product_category ON (product_category.product_id = p.categories AND product_category.product_version_id = p.version_id)
    LEFT JOIN category_translation category ON category.category_id = product_category.category_id AND category.category_version_id = product_category.category_version_id AND category.name IS NOT NULL AND category.language_id = ?
    LEFT JOIN delivery_time_translation ON delivery_time_translation.delivery_time_id = p.delivery_time_id AND delivery_time_translation.language_id = ?

WHERE p.id IN (?) AND p.version_id = ?

GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.name, product_parent.name) AS name,
    IFNULL(product_main.description, product_parent.description) AS description,
    IFNULL(product_main.meta_title, product_parent.meta_title) AS metaTitle,
    IFNULL(product_main.meta_description, product_parent.meta_description) AS metaDescription,
    product_main.custom_fields AS customFields,
    product_parent.custom_fields AS parentCustomFields,
    IFNULL(product_main.custom_search_keywords, product_parent.custom_search_keywords) AS customSearchKeywords,
    manufacturer.name AS manufacturerName,
    delivery_time_translation.name as deliveryTimeName,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'languageId', LOWER(HEX(category.language_id)),'id', LOWER(HEX(category.category_id)),'name', category.name
             )
         ),
    ']'
) as categories
FROM product p
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_manufacturer_translation manufacturer ON manufacturer.product_manufacturer_id = p.manufacturer AND manufacturer.language_id = ? AND manufacturer.product_manufacturer_version_id = p.version_id AND manufacturer.name IS NOT NULL
    LEFT JOIN product_category ON (product_category.product_id = p.categories AND product_category.product_version_id = p.version_id)
    LEFT JOIN category_translation category ON category.category_id = product_category.category_id AND category.category_version_id = product_category.category_version_id AND category.name IS NOT NULL AND category.language_id = ?
    LEFT JOIN delivery_time_translation ON delivery_time_translation.delivery_time_id = p.delivery_time_id AND delivery_time_translation.language_id = ?

WHERE p.id IN (?) AND p.version_id = ?

GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.name, product_parent.name) AS name,
    IFNULL(product_main.description, product_parent.description) AS description,
    IFNULL(product_main.meta_title, product_parent.meta_title) AS metaTitle,
    IFNULL(product_main.meta_description, product_parent.meta_description) AS metaDescription,
    product_main.custom_fields AS customFields,
    product_parent.custom_fields AS parentCustomFields,
    IFNULL(product_main.custom_search_keywords, product_parent.custom_search_keywords) AS customSearchKeywords,
    manufacturer.name AS manufacturerName,
    delivery_time_translation.name as deliveryTimeName,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'languageId', LOWER(HEX(category.language_id)),'id', LOWER(HEX(category.category_id)),'name', category.name
             )
         ),
    ']'
) as categories
FROM product p
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_manufacturer_translation manufacturer ON manufacturer.product_manufacturer_id = p.manufacturer AND manufacturer.language_id = ? AND manufacturer.product_manufacturer_version_id = p.version_id AND manufacturer.name IS NOT NULL
    LEFT JOIN product_category ON (product_category.product_id = p.categories AND product_category.product_version_id = p.version_id)
    LEFT JOIN category_translation category ON category.category_id = product_category.category_id AND category.category_version_id = product_category.category_version_id AND category.name IS NOT NULL AND category.language_id = ?
    LEFT JOIN delivery_time_translation ON delivery_time_translation.delivery_time_id = p.delivery_time_id AND delivery_time_translation.language_id = ?

WHERE p.id IN (?) AND p.version_id = ?

GROUP BY p.id
SELECT
    custom_field.`name`,
    custom_field.type
FROM custom_field_set_relation
    INNER JOIN custom_field ON(custom_field.set_id = custom_field_set_relation.set_id)
WHERE custom_field_set_relation.entity_name = ?
SELECT
    LOWER(HEX(product_id)) as id,
    custom_ordernumber,
    context_owner_id
FROM b2b_order_number
WHERE
    product_id IN(?)
    AND product_version_id = ?
SELECT
    LOWER(HEX(product_id)) as id,
    auth_id,
    in_stock
FROM b2b_in_stocks
WHERE
    product_id IN (?)
    AND product_version_id = ?
SELECT LOWER(HEX(product_id)) as product_id, LOWER(HEX(rule_id)) as rule_id FROM swag_dynamic_access_product_rule WHERE product_id in (?)
SELECT LOWER(HEX(product.id)) AS product_id, product.warehouse_group_stock, pp.warehouse_group_stock as parent_warehouse_group_stock
    FROM product
    LEFT JOIN product pp ON(product.parent_id = pp.id AND pp.version_id = ?)
    WHERE product.id IN (?) AND product.version_id = ?
    GROUP BY product.id
SELECT LOWER(HEX(wg.id)) AS id,
           wg.priority as priority,
           LOWER(HEX(wg.rule_id)) AS ruleId,
           LOWER(HEX(product.id)) as productId
    FROM product
    INNER JOIN product_warehouse_group as pwg
        ON product.warehouseGroups = pwg.product_id
    INNER JOIN warehouse_group wg
        ON pwg.warehouse_group_id = wg.id
    WHERE product.id IN (?)
    AND product.version_id = ?
SELECT
    LOWER(HEX(p.id)) AS id,
    LOWER(HEX(IFNULL(p.unit_id, pp.unit_id))) AS unitId,
    IFNULL(p.reference_unit, pp.reference_unit) AS referenceUnit,
    IFNULL(p.purchase_unit, pp.purchase_unit) AS purchaseUnit,
    IFNULL(p.purchase_prices, pp.purchase_prices) AS purchasePrices
FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
WHERE p.id IN (?) AND p.version_id = ? AND (p.child_count = 0 OR p.parent_id IS NOT NULL OR JSON_EXTRACT(`p`.`variant_listing_config`, "$.displayParent") = 1)
GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.pack_unit, product_parent.pack_unit) AS packUnit,
    IFNULL(product_main.pack_unit_plural, product_parent.pack_unit_plural) AS packUnitPlural,
    IFNULL(product_main.keywords, product_parent.keywords) AS keywords,
    unit.name as unitName,
    unit.short_code as unitShortCode,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'name', cross_selling.name,'id', LOWER(HEX(cross_selling.product_cross_selling_id)),'languageId', LOWER(HEX(cross_selling.language_id))
             )
         ),
    ']'
) as crossSellings
FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_cross_selling ON product_cross_selling.product_id = p.crossSellings
    LEFT JOIN product_cross_selling_translation cross_selling ON cross_selling.product_cross_selling_id = product_cross_selling.id
    LEFT JOIN unit_translation unit ON unit.unit_id = p.unit AND unit.language_id = ?
WHERE p.id IN (?) AND p.version_id = ?
GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.pack_unit, product_parent.pack_unit) AS packUnit,
    IFNULL(product_main.pack_unit_plural, product_parent.pack_unit_plural) AS packUnitPlural,
    IFNULL(product_main.keywords, product_parent.keywords) AS keywords,
    unit.name as unitName,
    unit.short_code as unitShortCode,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'name', cross_selling.name,'id', LOWER(HEX(cross_selling.product_cross_selling_id)),'languageId', LOWER(HEX(cross_selling.language_id))
             )
         ),
    ']'
) as crossSellings
FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_cross_selling ON product_cross_selling.product_id = p.crossSellings
    LEFT JOIN product_cross_selling_translation cross_selling ON cross_selling.product_cross_selling_id = product_cross_selling.id
    LEFT JOIN unit_translation unit ON unit.unit_id = p.unit AND unit.language_id = ?
WHERE p.id IN (?) AND p.version_id = ?
GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.pack_unit, product_parent.pack_unit) AS packUnit,
    IFNULL(product_main.pack_unit_plural, product_parent.pack_unit_plural) AS packUnitPlural,
    IFNULL(product_main.keywords, product_parent.keywords) AS keywords,
    unit.name as unitName,
    unit.short_code as unitShortCode,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'name', cross_selling.name,'id', LOWER(HEX(cross_selling.product_cross_selling_id)),'languageId', LOWER(HEX(cross_selling.language_id))
             )
         ),
    ']'
) as crossSellings
FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_cross_selling ON product_cross_selling.product_id = p.crossSellings
    LEFT JOIN product_cross_selling_translation cross_selling ON cross_selling.product_cross_selling_id = product_cross_selling.id
    LEFT JOIN unit_translation unit ON unit.unit_id = p.unit AND unit.language_id = ?
WHERE p.id IN (?) AND p.version_id = ?
GROUP BY p.id
SELECT
    LOWER(HEX(p.id)) AS id,
    IFNULL(product_main.pack_unit, product_parent.pack_unit) AS packUnit,
    IFNULL(product_main.pack_unit_plural, product_parent.pack_unit_plural) AS packUnitPlural,
    IFNULL(product_main.keywords, product_parent.keywords) AS keywords,
    unit.name as unitName,
    unit.short_code as unitShortCode,
    CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'name', cross_selling.name,'id', LOWER(HEX(cross_selling.product_cross_selling_id)),'languageId', LOWER(HEX(cross_selling.language_id))
             )
         ),
    ']'
) as crossSellings
FROM product p
    LEFT JOIN product pp ON(p.parent_id = pp.id AND pp.version_id = ?)
    LEFT JOIN product_translation product_main ON product_main.product_id = p.id AND product_main.product_version_id = p.version_id AND product_main.language_id = ?
    LEFT JOIN product_translation product_parent ON product_parent.product_id = p.parent_id AND product_parent.product_version_id = p.version_id AND product_parent.language_id = ?
    LEFT JOIN product_cross_selling ON product_cross_selling.product_id = p.crossSellings
    LEFT JOIN product_cross_selling_translation cross_selling ON cross_selling.product_cross_selling_id = product_cross_selling.id
    LEFT JOIN unit_translation unit ON unit.unit_id = p.unit AND unit.language_id = ?
WHERE p.id IN (?) AND p.version_id = ?
GROUP BY p.id
SELECT
    'id',
    LOWER(HEX(psm.product_stream_id)) AS id
FROM product_stream_mapping psm
WHERE psm.product_id = ?
SELECT DISTINCT
               LOWER(HEX(sales_channel.id)) as salesChannelId,
               LOWER(HEX(domains.language_id)) as languageId
             FROM sales_channel_domain as domains
             INNER JOIN sales_channel
               ON domains.sales_channel_id = sales_channel.id
               AND sales_channel.active = 1 AND sales_channel.type_id != ?
SELECT LOWER(HEX(sales_channel_id)) as sales_channel_id, template
             FROM seo_url_template
             WHERE route_name LIKE ?
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language`
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`measurement_units` as `sales_channel.measurementUnits`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE (NOT (`sales_channel`.`type_id` <=> ?))
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 1 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 1 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?) AND p.version_id = ?
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50 OFFSET 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?) AND p.version_id = ?
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50 OFFSET 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?) AND p.version_id = ?
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50 OFFSET 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?) AND p.version_id = ?
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50 OFFSET 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?) AND p.version_id = ?
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`auto_increment` >= ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id` ORDER BY MIN(`product`.`auto_increment`) ASC LIMIT 50 OFFSET 50
"START TRANSACTION"
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
"COMMIT"
SELECT DISTINCT LOWER(HEX(category_id)) as category_id
             FROM product_category_tree
             WHERE product_id IN (?)
             AND product_version_id = ?
             AND category_version_id = ?
SELECT DISTINCT LOWER(HEX(COALESCE(parent_id, id))) as id FROM product WHERE id IN (?) AND version_id = ?
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 = ?
DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL)
SELECT `alias`, `index` FROM admin_elasticsearch_index_task
Database Connections

Name	Service
0	default
Entity Managers

There are no configured entity managers.
Second Level Cache

Second Level Cache is not enabled.
Symfony Profiler

POST https://sw6staging.behr-labor.eu/api/_action/sync

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
