Symfony Profiler

Query Metrics

153 Database Queries
108 Different statements
286.80 ms Query time
Queries


SELECT `key`, `value` FROM `app_config`
# 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`;
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
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 configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
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 LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
SELECT 1 as `exists`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((?,?,?))
SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (?)) AND (version_id = ?)
SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = ?) AND (`version_id` = ?)
SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
"START TRANSACTION"
UPDATE `product` SET `version_id` = ?, `parent_version_id` = ?, `product_manufacturer_version_id` = ?, `product_media_version_id` = ?, `canonical_product_version_id` = ?, `cms_page_version_id` = ?, `stock` = ?, `updated_at` = ?, `available_stock` = ? WHERE id = ? AND version_id = ?
UPDATE `product_translation` SET `product_id` = ?, `language_id` = ?, `product_version_id` = ?, `updated_at` = ? WHERE product_id = ? AND language_id = ? AND product_version_id = ?
"COMMIT"
"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` 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 LOWER(HEX(id)), available FROM product WHERE id IN (?) AND product.version_id = ?
UPDATE product
            LEFT JOIN product parent
                ON parent.id = product.parent_id
                AND parent.version_id = product.version_id

            SET product.available = IFNULL((
                COALESCE(product.is_closeout, parent.is_closeout, 0) * product.stock
                >=
                COALESCE(product.is_closeout, parent.is_closeout, 0) * IFNULL(product.min_purchase, parent.min_purchase)
            ), 0)
            WHERE product.id IN (?)
            AND product.version_id = ?
SELECT LOWER(HEX(id)), available FROM product WHERE 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 (?)
INSERT INTO `increment` (`pool`, `cluster`, `key`, `count`, `created_at`)
            VALUES (?, ?, ?, 1, ?)
            ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = ?
"START TRANSACTION"
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
"COMMIT"
SELECT DISTINCT LOWER(HEX(`id`))
             FROM product
             WHERE `id` IN (?)
             AND `parent_id` IS NULL
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` LEFT JOIN `product_price` `product.prices` ON `product`.`prices` = `product.prices`.`product_id` AND `product`.version_id = `product.prices`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((((IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) >= ? AND IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) <= ?) OR ((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.prices`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100) >= ? AND (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.prices`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100) <= ?)))) 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 ((((IFNULL(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) = ?)) 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`.`release_date`, `product.parent`.`release_date`) > ?) AND (IFNULL(`product`.`release_date`, `product.parent`.`release_date`) < ?))) OR (((IFNULL(`product`.`release_date`, `product.parent`.`release_date`) < ?) AND (IFNULL(`product`.`release_date`, `product.parent`.`release_date`) > ?)))) 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_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.options`.`id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?)) AND `product`.`id` IN (?))) GROUP BY `product`.`id`
"START TRANSACTION"
DELETE FROM product_stream_mapping WHERE product_id IN (?)
"COMMIT"
UPDATE `product` SET `product`.`property_ids` = NULL
WHERE `product`.id IN (?) AND `product`.version_id = ?
UPDATE `product`, `product_property` 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 AND `product`.version_id = ?
)
WHERE `product_property`.`product_id` = `product`.`properties`
AND `product`.id IN (?)
AND `product`.version_id = `product_property`.product_version_id AND `product`.version_id = ?
UPDATE `product` SET `product`.`option_ids` = NULL
WHERE `product`.id IN (?) AND `product`.version_id = ?
UPDATE `product`, `product_option` 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 AND `product`.version_id = ?
)
WHERE `product_option`.`product_id` = `product`.`id`
AND `product`.id IN (?)
AND `product`.version_id = `product_option`.product_version_id AND `product`.version_id = ?
UPDATE `product` SET `product`.`stream_ids` = NULL
WHERE `product`.id IN (?) AND `product`.version_id = ?
UPDATE `product`, `product_stream_mapping` 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 AND `product`.version_id = ?
)
WHERE `product_stream_mapping`.`product_id` = `product`.`id`
AND `product`.id IN (?)
AND `product`.version_id = `product_stream_mapping`.product_version_id AND `product`.version_id = ?
UPDATE `product` SET `product`.`tag_ids` = NULL
WHERE `product`.id IN (?) AND `product`.version_id = ?
UPDATE `product`, `product_tag` 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 AND `product`.version_id = ?
)
WHERE `product_tag`.`product_id` = `product`.`tags`
AND `product`.id IN (?)
AND `product`.version_id = `product_tag`.product_version_id AND `product`.version_id = ?
UPDATE `product` SET `product`.`category_ids` = NULL
WHERE `product`.id IN (?) AND `product`.version_id = ?
UPDATE `product`, `product_category` 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 AND `product`.version_id = ?
)
WHERE `product_category`.`product_id` = `product`.`categories`
AND `product`.id IN (?)
AND `product`.version_id = `product_category`.product_version_id 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 (NULL) AND `product_version_id` = ?
"COMMIT"
"START TRANSACTION"
"COMMIT"
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 (?)
SELECT DISTINCT LOWER(HEX(product_stream_id))
             FROM product_stream_mapping
             WHERE product_stream_mapping.product_id IN (?)
             AND product_stream_mapping.product_version_id = ?
SELECT DISTINCT(LOWER(HEX(parent_id))) FROM product WHERE id IN (?) AND parent_id IS NOT NULL AND version_id = ?
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 = ?
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,
    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,
    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 = ?

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

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

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

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

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

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

GROUP BY p.id
SELECT
       LOWER(HEX(id)) as id,
       LOWER(HEX(property_group_id)) as groupId,
       CONCAT(
    '[',
         GROUP_CONCAT(DISTINCT
             JSON_OBJECT(
                'languageId', LOWER(HEX(property_group_option_translation.language_id)),'name', property_group_option_translation.name
             )
         ),
    ']'
) as translations
FROM property_group_option
         LEFT JOIN property_group_option_translation
            ON property_group_option_translation.property_group_option_id = property_group_option.id

WHERE property_group_option.id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY property_group_option.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(wg.id)) AS id,
           wg.priority as priority,
           LOWER(HEX(wg.rule_id)) AS ruleId,
           LOWER(HEX(pwg.product_id)) as productId
    FROM warehouse_group as wg
    INNER JOIN product_warehouse_group as pwg
        ON wg.id = pwg.warehouse_group_id
    WHERE pwg.product_id IN (?)
    AND pwg.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
    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(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 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`.`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`.`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 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.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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 `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.override_1.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.override_1.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.override_1.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.override_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.override_1.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.translation.override_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.override_1.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.override_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.override_1.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.override_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.override_1.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`, `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id` AND `property_group_option.translation.override_1`.`language_id` = ? WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation.override_1`.`name` as `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation.override_1`.`description` as `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation.override_1`.`position` as `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields`, `property_group_option.group.translation.override_1`.`custom_fields` as `property_group_option.group.translation.override_1.customFields` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_1`.`property_group_id` AND `property_group_option.group.translation.override_1`.`language_id` = ? WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`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_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
SELECT id, language_id languageId, sales_channel_id salesChannelId, foreign_key foreignKey, route_name routeName
            FROM seo_url
            WHERE is_canonical = 1 AND seo_path_info IN (NULL)
"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 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.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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 `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.override_1.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.override_1.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.override_1.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.override_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.override_1.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.translation.override_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.override_1.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.override_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.override_1.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.override_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.override_1.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`, `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id` AND `property_group_option.translation.override_1`.`language_id` = ? WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation.override_1`.`name` as `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation.override_1`.`description` as `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation.override_1`.`position` as `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields`, `property_group_option.group.translation.override_1`.`custom_fields` as `property_group_option.group.translation.override_1.customFields` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_1`.`property_group_id` AND `property_group_option.group.translation.override_1`.`language_id` = ? WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`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_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
SELECT id, language_id languageId, sales_channel_id salesChannelId, foreign_key foreignKey, route_name routeName
            FROM seo_url
            WHERE is_canonical = 1 AND seo_path_info IN (NULL)
"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 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.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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 `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.override_1.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.override_1.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.override_1.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.override_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.override_1.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.translation.override_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.override_1.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.override_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.override_1.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.override_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.override_1.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`, `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id` AND `property_group_option.translation.override_1`.`language_id` = ? WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation.override_1`.`name` as `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation.override_1`.`description` as `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation.override_1`.`position` as `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields`, `property_group_option.group.translation.override_1`.`custom_fields` as `property_group_option.group.translation.override_1.customFields` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_1`.`property_group_id` AND `property_group_option.group.translation.override_1`.`language_id` = ? WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`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_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
SELECT id, language_id languageId, sales_channel_id salesChannelId, foreign_key foreignKey, route_name routeName
            FROM seo_url
            WHERE is_canonical = 1 AND seo_path_info IN (NULL)
"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 = ?
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT
        LOWER(HEX(w.id)) as webhookId,
        w.name as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(a.id)) AS appId,
        a.name AS appName,
        a.active AS appActive,
        a.source_type AS appSourceType,
        a.version AS appVersion,
        a.app_secret AS appSecret,
        LOWER(HEX(a.acl_role_id)) as appAclRoleId
    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1
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

PATCH https://products-dev.ophardt.com/api/product/66dd38bc0d916874356c1b005d00251d

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
