Symfony Profiler

DELETE FROM
  messenger_messages
WHERE
  delivered_at = ?

DELETE FROM messenger_messages WHERE delivered_at = '9999-12-31 23:59:59';

SELECT
  m.*
FROM
  messenger_messages m
WHERE
  (
    m.delivered_at is null
    OR m.delivered_at < ?
  )
  AND (m.available_at <= ?)
  AND (m.queue_name = ?)
ORDER BY
  available_at ASC
LIMIT
  1 FOR
UPDATE

SELECT m.* FROM messenger_messages m WHERE (m.delivered_at is null OR m.delivered_at < '2025-07-10 04:11:27') AND (m.available_at <= '2025-07-10 05:11:27') AND (m.queue_name = 'default') ORDER BY available_at ASC LIMIT 1 FOR UPDATE;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

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`.`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`.`write_access` as `app.integration.writeAccess`,
  `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`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  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`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  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`
WHERE
  `app`.`id` IN (?)

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`.`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`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` 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`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 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` WHERE `app`.`id` IN (0x00FBF6EF72AA4821B3890592BDA1F2D7);

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 `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 (0x00FBF6EF72AA4821B3890592BDA1F2D7));

UPDATE
  messenger_messages
SET
  delivered_at = ?
WHERE
  id = ?

UPDATE messenger_messages SET delivered_at = '2025-07-10 05:11:27' WHERE id = '189591';

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`,
  `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`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  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`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  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`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` 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`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 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` WHERE (`app`.`active` = 1);

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 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`
        ;

UPDATE
  `increment`
SET
  `count` = `count` - 1,
  `updated_at` = ?
WHERE
  `pool` = ?
  AND `cluster` = ?
  AND `key` = ?
  AND `count` > 0;

UPDATE `increment`
            SET `count` = `count` - 1, `updated_at` = '2025-07-10 05:11:27.692'
            WHERE `pool` = 'message_queue' AND `cluster` = 'message_queue_stats' AND `key` = 'Shopware\\Core\\Framework\\Log\\ScheduledTask\\LogCleanupTask' AND `count` > 0;
        ;

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(`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
  `scheduled_task`.`id` as `scheduled_task.id`,
  `scheduled_task`.`name` as `scheduled_task.name`,
  `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`,
  `scheduled_task`.`run_interval` as `scheduled_task.runInterval`,
  `scheduled_task`.`status` as `scheduled_task.status`,
  `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`,
  `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`,
  `scheduled_task`.`created_at` as `scheduled_task.createdAt`,
  `scheduled_task`.`updated_at` as `scheduled_task.updatedAt`
FROM
  `scheduled_task`
WHERE
  `scheduled_task`.`id` IN (?)

SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE `scheduled_task`.`id` IN (0x2184854707BC45F587EBBC9C1FDA4A6A);

SELECT
  1 as `exists`,
  `id`
FROM
  `scheduled_task`
WHERE
  `id` IN (?)

SELECT 1 as `exists`, `id` FROM `scheduled_task` WHERE `id` IN (0x2184854707BC45F587EBBC9C1FDA4A6A);

SELECT
  `product_export`.`id` as `product_export.id`,
  `product_export`.`product_stream_id` as `product_export.productStreamId`,
  `product_export`.`storefront_sales_channel_id` as `product_export.storefrontSalesChannelId`,
  `product_export`.`sales_channel_id` as `product_export.salesChannelId`,
  `product_export`.`sales_channel_domain_id` as `product_export.salesChannelDomainId`,
  `product_export`.`currency_id` as `product_export.currencyId`,
  `product_export`.`file_name` as `product_export.fileName`,
  `product_export`.`access_key` as `product_export.accessKey`,
  `product_export`.`encoding` as `product_export.encoding`,
  `product_export`.`file_format` as `product_export.fileFormat`,
  `product_export`.`include_variants` as `product_export.includeVariants`,
  `product_export`.`generate_by_cronjob` as `product_export.generateByCronjob`,
  `product_export`.`generated_at` as `product_export.generatedAt`,
  `product_export`.`interval` as `product_export.interval`,
  `product_export`.`header_template` as `product_export.headerTemplate`,
  `product_export`.`body_template` as `product_export.bodyTemplate`,
  `product_export`.`footer_template` as `product_export.footerTemplate`,
  `product_export`.`paused_schedule` as `product_export.pausedSchedule`,
  `product_export`.`is_running` as `product_export.isRunning`,
  `product_export`.`created_at` as `product_export.createdAt`,
  `product_export`.`updated_at` as `product_export.updatedAt`,
  `product_export.salesChannel`.`id` as `product_export.salesChannel.id`,
  `product_export.salesChannel`.`type_id` as `product_export.salesChannel.typeId`,
  `product_export.salesChannel`.`language_id` as `product_export.salesChannel.languageId`,
  `product_export.salesChannel`.`customer_group_id` as `product_export.salesChannel.customerGroupId`,
  `product_export.salesChannel`.`currency_id` as `product_export.salesChannel.currencyId`,
  `product_export.salesChannel`.`payment_method_id` as `product_export.salesChannel.paymentMethodId`,
  `product_export.salesChannel`.`shipping_method_id` as `product_export.salesChannel.shippingMethodId`,
  `product_export.salesChannel`.`country_id` as `product_export.salesChannel.countryId`,
  `product_export.salesChannel`.`analytics_id` as `product_export.salesChannel.analyticsId`,
  `product_export.salesChannel`.`navigation_category_id` as `product_export.salesChannel.navigationCategoryId`,
  `product_export.salesChannel`.`navigation_category_version_id` as `product_export.salesChannel.navigationCategoryVersionId`,
  `product_export.salesChannel`.`navigation_category_depth` as `product_export.salesChannel.navigationCategoryDepth`,
  `product_export.salesChannel`.`footer_category_id` as `product_export.salesChannel.footerCategoryId`,
  `product_export.salesChannel`.`footer_category_version_id` as `product_export.salesChannel.footerCategoryVersionId`,
  `product_export.salesChannel`.`service_category_id` as `product_export.salesChannel.serviceCategoryId`,
  `product_export.salesChannel`.`service_category_version_id` as `product_export.salesChannel.serviceCategoryVersionId`,
  `product_export.salesChannel`.`mail_header_footer_id` as `product_export.salesChannel.mailHeaderFooterId`,
  `product_export.salesChannel`.`hreflang_default_domain_id` as `product_export.salesChannel.hreflangDefaultDomainId`,
  `product_export.salesChannel`.`short_name` as `product_export.salesChannel.shortName`,
  `product_export.salesChannel`.`tax_calculation_type` as `product_export.salesChannel.taxCalculationType`,
  `product_export.salesChannel`.`access_key` as `product_export.salesChannel.accessKey`,
  `product_export.salesChannel`.`configuration` as `product_export.salesChannel.configuration`,
  `product_export.salesChannel`.`active` as `product_export.salesChannel.active`,
  `product_export.salesChannel`.`hreflang_active` as `product_export.salesChannel.hreflangActive`,
  `product_export.salesChannel`.`maintenance` as `product_export.salesChannel.maintenance`,
  `product_export.salesChannel`.`maintenance_ip_whitelist` as `product_export.salesChannel.maintenanceIpWhitelist`,
  `product_export.salesChannel`.`payment_method_ids` as `product_export.salesChannel.paymentMethodIds`,
  `product_export.salesChannel`.`home_cms_page_id` as `product_export.salesChannel.homeCmsPageId`,
  `product_export.salesChannel`.`home_cms_page_version_id` as `product_export.salesChannel.homeCmsPageVersionId`,
  `product_export.salesChannel.analytics`.`id` as `product_export.salesChannel.analytics.id`,
  `product_export.salesChannel.analytics`.`tracking_id` as `product_export.salesChannel.analytics.trackingId`,
  `product_export.salesChannel.analytics`.`active` as `product_export.salesChannel.analytics.active`,
  `product_export.salesChannel.analytics`.`track_orders` as `product_export.salesChannel.analytics.trackOrders`,
  `product_export.salesChannel.analytics`.`anonymize_ip` as `product_export.salesChannel.analytics.anonymizeIp`,
  `product_export.salesChannel.analytics`.`created_at` as `product_export.salesChannel.analytics.createdAt`,
  `product_export.salesChannel.analytics`.`updated_at` as `product_export.salesChannel.analytics.updatedAt`,
  `product_export.salesChannel`.`created_at` as `product_export.salesChannel.createdAt`,
  `product_export.salesChannel`.`updated_at` as `product_export.salesChannel.updatedAt`,
  `product_export.salesChannel.translation.name`,
  COALESCE(
    `product_export.salesChannel.translation.name`,
    `product_export.salesChannel.translation.name`
  ) as `product_export.salesChannel.name`,
  `product_export.salesChannel.translation.homeSlotConfig`,
  COALESCE(
    `product_export.salesChannel.translation.homeSlotConfig`,
    `product_export.salesChannel.translation.homeSlotConfig`
  ) as `product_export.salesChannel.homeSlotConfig`,
  `product_export.salesChannel.translation.homeEnabled`,
  COALESCE(
    `product_export.salesChannel.translation.homeEnabled`,
    `product_export.salesChannel.translation.homeEnabled`
  ) as `product_export.salesChannel.homeEnabled`,
  `product_export.salesChannel.translation.homeName`,
  COALESCE(
    `product_export.salesChannel.translation.homeName`,
    `product_export.salesChannel.translation.homeName`
  ) as `product_export.salesChannel.homeName`,
  `product_export.salesChannel.translation.homeMetaTitle`,
  COALESCE(
    `product_export.salesChannel.translation.homeMetaTitle`,
    `product_export.salesChannel.translation.homeMetaTitle`
  ) as `product_export.salesChannel.homeMetaTitle`,
  `product_export.salesChannel.translation.homeMetaDescription`,
  COALESCE(
    `product_export.salesChannel.translation.homeMetaDescription`,
    `product_export.salesChannel.translation.homeMetaDescription`
  ) as `product_export.salesChannel.homeMetaDescription`,
  `product_export.salesChannel.translation.homeKeywords`,
  COALESCE(
    `product_export.salesChannel.translation.homeKeywords`,
    `product_export.salesChannel.translation.homeKeywords`
  ) as `product_export.salesChannel.homeKeywords`,
  `product_export.salesChannel.translation.customFields`,
  COALESCE(
    `product_export.salesChannel.translation.customFields`,
    `product_export.salesChannel.translation.customFields`
  ) as `product_export.salesChannel.customFields`,
  `product_export.salesChannel.translation.createdAt`,
  `product_export.salesChannel.translation.updatedAt`,
  `product_export.salesChannel.translation.salesChannelId`,
  `product_export.salesChannel.translation.languageId`
FROM
  `product_export`
  LEFT JOIN `sales_channel` `product_export.salesChannel` ON `product_export`.`sales_channel_id` = `product_export.salesChannel`.`id`
  LEFT JOIN `sales_channel_domain` `product_export.salesChannelDomain` ON `product_export`.`sales_channel_domain_id` = `product_export.salesChannelDomain`.`id`
  LEFT JOIN (
    SELECT
      `product_export.salesChannel.translation`.sales_channel_id,
      `product_export.salesChannel.translation`.name as `product_export.salesChannel.translation.name`,
      `product_export.salesChannel.translation`.home_slot_config as `product_export.salesChannel.translation.homeSlotConfig`,
      `product_export.salesChannel.translation`.home_enabled as `product_export.salesChannel.translation.homeEnabled`,
      `product_export.salesChannel.translation`.home_name as `product_export.salesChannel.translation.homeName`,
      `product_export.salesChannel.translation`.home_meta_title as `product_export.salesChannel.translation.homeMetaTitle`,
      `product_export.salesChannel.translation`.home_meta_description as `product_export.salesChannel.translation.homeMetaDescription`,
      `product_export.salesChannel.translation`.home_keywords as `product_export.salesChannel.translation.homeKeywords`,
      `product_export.salesChannel.translation`.custom_fields as `product_export.salesChannel.translation.customFields`,
      `product_export.salesChannel.translation`.created_at as `product_export.salesChannel.translation.createdAt`,
      `product_export.salesChannel.translation`.updated_at as `product_export.salesChannel.translation.updatedAt`,
      `product_export.salesChannel.translation`.sales_channel_id as `product_export.salesChannel.translation.salesChannelId`,
      `product_export.salesChannel.translation`.language_id as `product_export.salesChannel.translation.languageId`
    FROM
      `sales_channel_translation` `product_export.salesChannel.translation`
    WHERE
      `product_export.salesChannel.translation`.language_id = ?
  ) `product_export.salesChannel.sales_channel_translation` ON `product_export.salesChannel.sales_channel_translation`.`sales_channel_id` = `product_export.salesChannel`.`id`
  LEFT JOIN `sales_channel_analytics` `product_export.salesChannel.analytics` ON `product_export.salesChannel`.`analytics_id` = `product_export.salesChannel.analytics`.`id`
  LEFT JOIN `sales_channel` `product_export.salesChannelDomain.salesChannel` ON `product_export.salesChannelDomain`.`sales_channel_id` = `product_export.salesChannelDomain.salesChannel`.`id`
WHERE
  (
    (
      `product_export`.`generate_by_cronjob` = ?
      AND `product_export.salesChannel`.`active` = ?
    )
    AND (
      `product_export`.`storefront_sales_channel_id` = ?
      OR `product_export.salesChannelDomain.salesChannel`.`id` = ?
    )
  )