Symfony Profiler

SELECT
  `key`,
  `value`
FROM
  `app_config`

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

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

SELECT
  `key`,
  `value`
FROM
  `app_config`

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

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',
        ''
      )
  )

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
  `name`,
  `path`,
  `author`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
            ;

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT
  id
FROM
  integration
WHERE
  access_key = ?

SELECT id FROM integration WHERE access_key = 'SWIAYURKWGSZZHZODW1KEXRIQW';

SELECT
  `acl_role`.`privileges`
FROM
  `acl_role`
  INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE
  `app`.`integration_id` = ?

SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = 0x0192B88D10637B86ADA5BCE94EB65097
        ;

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

SELECT admin FROM `integration` WHERE id = 0x0192B88D10637B86ADA5BCE94EB65097;

SELECT
  role.privileges
FROM
  integration_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.integration_id = ?

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x0192B88D10637B86ADA5BCE94EB65097;

SELECT
  `order`.`id`,
  `order`.`auto_increment`,
  `order`.`order_number`
FROM
  `order`
WHERE
  (`order`.`version_id` = ?)
  AND (
    (
      (`order`.`created_at` >= ?)
    )
  )
ORDER BY
  `order`.`created_at` ASC,
  `order`.`id` ASC
LIMIT
  50

SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE (`order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`order`.`created_at` >= '2024-12-23T15:58:31'))) ORDER BY `order`.`created_at` ASC, `order`.`id` ASC LIMIT 50;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      `order`.`id`,
      `order`.`auto_increment`,
      `order`.`order_number`
    FROM
      `order`
    WHERE
      (`order`.`version_id` = ?)
      AND (
        (
          (`order`.`created_at` >= ?)
        )
      )
  ) total

SELECT COUNT(*) FROM (SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE (`order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`order`.`created_at` >= '2024-12-23T15:58:31')))) total;

SELECT
  `order`.`id` as `order.id`,
  `order`.`version_id` as `order.versionId`,
  `order`.`auto_increment` as `order.autoIncrement`,
  `order`.`order_number` as `order.orderNumber`,
  `order`.`billing_address_id` as `order.billingAddressId`,
  `order`.`billing_address_version_id` as `order.billingAddressVersionId`,
  `order`.`currency_id` as `order.currencyId`,
  `order`.`language_id` as `order.languageId`,
  `order`.`sales_channel_id` as `order.salesChannelId`,
  `order`.`order_date_time` as `order.orderDateTime`,
  `order`.`order_date` as `order.orderDate`,
  `order`.`price` as `order.price`,
  `order`.`amount_total` as `order.amountTotal`,
  `order`.`amount_net` as `order.amountNet`,
  `order`.`position_price` as `order.positionPrice`,
  `order`.`tax_status` as `order.taxStatus`,
  `order`.`shipping_costs` as `order.shippingCosts`,
  `order`.`shipping_total` as `order.shippingTotal`,
  `order`.`currency_factor` as `order.currencyFactor`,
  `order`.`deep_link_code` as `order.deepLinkCode`,
  `order`.`affiliate_code` as `order.affiliateCode`,
  `order`.`campaign_code` as `order.campaignCode`,
  `order`.`customer_comment` as `order.customerComment`,
  `order`.`source` as `order.source`,
  `order`.`state_id` as `order.stateId`,
  `order`.`rule_ids` as `order.ruleIds`,
  `order`.`custom_fields` as `order.customFields`,
  `order`.`created_by_id` as `order.createdById`,
  `order`.`updated_by_id` as `order.updatedById`,
  `order.orderCustomer`.`id` as `order.orderCustomer.id`,
  `order.orderCustomer`.`version_id` as `order.orderCustomer.versionId`,
  `order.orderCustomer`.`customer_id` as `order.orderCustomer.customerId`,
  `order.orderCustomer`.`order_id` as `order.orderCustomer.orderId`,
  `order.orderCustomer`.`order_version_id` as `order.orderCustomer.orderVersionId`,
  `order.orderCustomer`.`email` as `order.orderCustomer.email`,
  `order.orderCustomer`.`salutation_id` as `order.orderCustomer.salutationId`,
  `order.orderCustomer`.`first_name` as `order.orderCustomer.firstName`,
  `order.orderCustomer`.`last_name` as `order.orderCustomer.lastName`,
  `order.orderCustomer`.`company` as `order.orderCustomer.company`,
  `order.orderCustomer`.`title` as `order.orderCustomer.title`,
  `order.orderCustomer`.`vat_ids` as `order.orderCustomer.vatIds`,
  `order.orderCustomer`.`customer_number` as `order.orderCustomer.customerNumber`,
  `order.orderCustomer`.`custom_fields` as `order.orderCustomer.customFields`,
  `order.orderCustomer`.`remote_address` as `order.orderCustomer.remoteAddress`,
  `order.orderCustomer`.`created_at` as `order.orderCustomer.createdAt`,
  `order.orderCustomer`.`updated_at` as `order.orderCustomer.updatedAt`,
  `order.orderCustomer.customer`.`id` as `order.orderCustomer.customer.id`,
  `order.orderCustomer.customer`.`customer_group_id` as `order.orderCustomer.customer.groupId`,
  `order.orderCustomer.customer`.`sales_channel_id` as `order.orderCustomer.customer.salesChannelId`,
  `order.orderCustomer.customer`.`language_id` as `order.orderCustomer.customer.languageId`,
  `order.orderCustomer.customer`.`last_payment_method_id` as `order.orderCustomer.customer.lastPaymentMethodId`,
  `order.orderCustomer.customer`.`default_billing_address_id` as `order.orderCustomer.customer.defaultBillingAddressId`,
  `order.orderCustomer.customer`.`default_shipping_address_id` as `order.orderCustomer.customer.defaultShippingAddressId`,
  `order.orderCustomer.customer`.`auto_increment` as `order.orderCustomer.customer.autoIncrement`,
  `order.orderCustomer.customer`.`customer_number` as `order.orderCustomer.customer.customerNumber`,
  `order.orderCustomer.customer`.`salutation_id` as `order.orderCustomer.customer.salutationId`,
  `order.orderCustomer.customer`.`first_name` as `order.orderCustomer.customer.firstName`,
  `order.orderCustomer.customer`.`last_name` as `order.orderCustomer.customer.lastName`,
  `order.orderCustomer.customer`.`company` as `order.orderCustomer.customer.company`,
  `order.orderCustomer.customer`.`password` as `order.orderCustomer.customer.password`,
  `order.orderCustomer.customer`.`email` as `order.orderCustomer.customer.email`,
  `order.orderCustomer.customer`.`title` as `order.orderCustomer.customer.title`,
  `order.orderCustomer.customer`.`vat_ids` as `order.orderCustomer.customer.vatIds`,
  `order.orderCustomer.customer`.`affiliate_code` as `order.orderCustomer.customer.affiliateCode`,
  `order.orderCustomer.customer`.`campaign_code` as `order.orderCustomer.customer.campaignCode`,
  `order.orderCustomer.customer`.`active` as `order.orderCustomer.customer.active`,
  `order.orderCustomer.customer`.`double_opt_in_registration` as `order.orderCustomer.customer.doubleOptInRegistration`,
  `order.orderCustomer.customer`.`double_opt_in_email_sent_date` as `order.orderCustomer.customer.doubleOptInEmailSentDate`,
  `order.orderCustomer.customer`.`double_opt_in_confirm_date` as `order.orderCustomer.customer.doubleOptInConfirmDate`,
  `order.orderCustomer.customer`.`hash` as `order.orderCustomer.customer.hash`,
  `order.orderCustomer.customer`.`guest` as `order.orderCustomer.customer.guest`,
  `order.orderCustomer.customer`.`first_login` as `order.orderCustomer.customer.firstLogin`,
  `order.orderCustomer.customer`.`last_login` as `order.orderCustomer.customer.lastLogin`,
  `order.orderCustomer.customer`.`newsletter_sales_channel_ids` as `order.orderCustomer.customer.newsletterSalesChannelIds`,
  `order.orderCustomer.customer`.`birthday` as `order.orderCustomer.customer.birthday`,
  `order.orderCustomer.customer`.`last_order_date` as `order.orderCustomer.customer.lastOrderDate`,
  `order.orderCustomer.customer`.`order_count` as `order.orderCustomer.customer.orderCount`,
  `order.orderCustomer.customer`.`order_total_amount` as `order.orderCustomer.customer.orderTotalAmount`,
  `order.orderCustomer.customer`.`review_count` as `order.orderCustomer.customer.reviewCount`,
  `order.orderCustomer.customer`.`custom_fields` as `order.orderCustomer.customer.customFields`,
  `order.orderCustomer.customer`.`legacy_password` as `order.orderCustomer.customer.legacyPassword`,
  `order.orderCustomer.customer`.`legacy_encoder` as `order.orderCustomer.customer.legacyEncoder`,
  `order.orderCustomer.customer`.`remote_address` as `order.orderCustomer.customer.remoteAddress`,
  `order.orderCustomer.customer`.`tag_ids` as `order.orderCustomer.customer.tagIds`,
  `order.orderCustomer.customer`.`requested_customer_group_id` as `order.orderCustomer.customer.requestedGroupId`,
  `order.orderCustomer.customer`.`bound_sales_channel_id` as `order.orderCustomer.customer.boundSalesChannelId`,
  `order.orderCustomer.customer`.`account_type` as `order.orderCustomer.customer.accountType`,
  `order.orderCustomer.customer`.`created_by_id` as `order.orderCustomer.customer.createdById`,
  `order.orderCustomer.customer`.`updated_by_id` as `order.orderCustomer.customer.updatedById`,
  `order.orderCustomer.customer`.`default_payment_method_id` as `order.orderCustomer.customer.defaultPaymentMethodId`,
  `order.orderCustomer.customer`.`created_at` as `order.orderCustomer.customer.createdAt`,
  `order.orderCustomer.customer`.`updated_at` as `order.orderCustomer.customer.updatedAt`,
  `order`.`item_rounding` as `order.itemRounding`,
  `order`.`total_rounding` as `order.totalRounding`,
  `order`.`created_at` as `order.createdAt`,
  `order`.`updated_at` as `order.updatedAt`,
  `order.stateMachineState`.`id` as `order.stateMachineState.id`,
  `order.stateMachineState`.`technical_name` as `order.stateMachineState.technicalName`,
  `order.stateMachineState`.`state_machine_id` as `order.stateMachineState.stateMachineId`,
  `order.stateMachineState`.`created_at` as `order.stateMachineState.createdAt`,
  `order.stateMachineState`.`updated_at` as `order.stateMachineState.updatedAt`,
  `order.stateMachineState.translation.name`,
  `order.stateMachineState.translation.name` as `order.stateMachineState.name`,
  `order.stateMachineState.translation.customFields`,
  `order.stateMachineState.translation.customFields` as `order.stateMachineState.customFields`,
  `order.language`.`id` as `order.language.id`,
  `order.language`.`parent_id` as `order.language.parentId`,
  `order.language`.`locale_id` as `order.language.localeId`,
  `order.language`.`translation_code_id` as `order.language.translationCodeId`,
  `order.language`.`name` as `order.language.name`,
  `order.language`.`custom_fields` as `order.language.customFields`,
  `order.language`.`created_at` as `order.language.createdAt`,
  `order.language`.`updated_at` as `order.language.updatedAt`,
  `order.language.locale`.`id` as `order.language.locale.id`,
  `order.language.locale`.`code` as `order.language.locale.code`,
  `order.language.locale`.`created_at` as `order.language.locale.createdAt`,
  `order.language.locale`.`updated_at` as `order.language.locale.updatedAt`,
  `order.language.locale.translation.name`,
  `order.language.locale.translation.name` as `order.language.locale.name`,
  `order.language.locale.translation.territory`,
  `order.language.locale.translation.territory` as `order.language.locale.territory`,
  `order.language.locale.translation.customFields`,
  `order.language.locale.translation.customFields` as `order.language.locale.customFields`,
  `order.currency`.`id` as `order.currency.id`,
  `order.currency`.`factor` as `order.currency.factor`,
  `order.currency`.`symbol` as `order.currency.symbol`,
  `order.currency`.`iso_code` as `order.currency.isoCode`,
  `order.currency`.`position` as `order.currency.position`,
  `order.currency`.`tax_free_from` as `order.currency.taxFreeFrom`,
  `order.currency`.`item_rounding` as `order.currency.itemRounding`,
  `order.currency`.`total_rounding` as `order.currency.totalRounding`,
  `order.currency`.`created_at` as `order.currency.createdAt`,
  `order.currency`.`updated_at` as `order.currency.updatedAt`,
  `order.currency.translation.shortName`,
  `order.currency.translation.shortName` as `order.currency.shortName`,
  `order.currency.translation.name`,
  `order.currency.translation.name` as `order.currency.name`,
  `order.currency.translation.customFields`,
  `order.currency.translation.customFields` as `order.currency.customFields`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(`order.tags.mapping`.`tag_id`) SEPARATOR '||'
      )
    FROM
      `order_tag` `order.tags.mapping`
    WHERE
      `order.tags.mapping`.`order_id` = `order`.`id`
  ) as `order.tags.id_mapping`
FROM
  `order`
  LEFT JOIN `order_customer` `order.orderCustomer` ON `order`.`id` = `order.orderCustomer`.`order_id`
  AND `order`.`version_id` = `order.orderCustomer`.`order_version_id`
  LEFT JOIN `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id`
  LEFT JOIN `language` `order.language` ON `order`.`language_id` = `order.language`.`id`
  LEFT JOIN `currency` `order.currency` ON `order`.`currency_id` = `order.currency`.`id`
  LEFT JOIN `customer` `order.orderCustomer.customer` ON `order.orderCustomer`.`customer_id` = `order.orderCustomer.customer`.`id`
  LEFT JOIN (
    SELECT
      `order.stateMachineState.translation`.`state_machine_state_id`,
      `order.stateMachineState.translation`.`name` as `order.stateMachineState.translation.name`,
      `order.stateMachineState.translation`.`custom_fields` as `order.stateMachineState.translation.customFields`
    FROM
      `state_machine_state_translation` `order.stateMachineState.translation`
    WHERE
      `order.stateMachineState.translation`.`language_id` = ?
  ) `order.stateMachineState.state_machine_state_translation` ON `order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order.stateMachineState`.`id`
  LEFT JOIN `locale` `order.language.locale` ON `order.language`.`locale_id` = `order.language.locale`.`id`
  LEFT JOIN (
    SELECT
      `order.language.locale.translation`.`locale_id`,
      `order.language.locale.translation`.`name` as `order.language.locale.translation.name`,
      `order.language.locale.translation`.`territory` as `order.language.locale.translation.territory`,
      `order.language.locale.translation`.`custom_fields` as `order.language.locale.translation.customFields`
    FROM
      `locale_translation` `order.language.locale.translation`
    WHERE
      `order.language.locale.translation`.`language_id` = ?
  ) `order.language.locale.locale_translation` ON `order.language.locale.locale_translation`.`locale_id` = `order.language.locale`.`id`
  LEFT JOIN (
    SELECT
      `order.currency.translation`.`currency_id`,
      `order.currency.translation`.`short_name` as `order.currency.translation.shortName`,
      `order.currency.translation`.`name` as `order.currency.translation.name`,
      `order.currency.translation`.`custom_fields` as `order.currency.translation.customFields`
    FROM
      `currency_translation` `order.currency.translation`
    WHERE
      `order.currency.translation`.`language_id` = ?
  ) `order.currency.currency_translation` ON `order.currency.currency_translation`.`currency_id` = `order.currency`.`id`
WHERE
  (`order`.`version_id` = ?)
  AND (
    `order`.`id` IN (?)
  )

SELECT `order`.`id` as `order.id`, `order`.`version_id` as `order.versionId`, `order`.`auto_increment` as `order.autoIncrement`, `order`.`order_number` as `order.orderNumber`, `order`.`billing_address_id` as `order.billingAddressId`, `order`.`billing_address_version_id` as `order.billingAddressVersionId`, `order`.`currency_id` as `order.currencyId`, `order`.`language_id` as `order.languageId`, `order`.`sales_channel_id` as `order.salesChannelId`, `order`.`order_date_time` as `order.orderDateTime`, `order`.`order_date` as `order.orderDate`, `order`.`price` as `order.price`, `order`.`amount_total` as `order.amountTotal`, `order`.`amount_net` as `order.amountNet`, `order`.`position_price` as `order.positionPrice`, `order`.`tax_status` as `order.taxStatus`, `order`.`shipping_costs` as `order.shippingCosts`, `order`.`shipping_total` as `order.shippingTotal`, `order`.`currency_factor` as `order.currencyFactor`, `order`.`deep_link_code` as `order.deepLinkCode`, `order`.`affiliate_code` as `order.affiliateCode`, `order`.`campaign_code` as `order.campaignCode`, `order`.`customer_comment` as `order.customerComment`, `order`.`source` as `order.source`, `order`.`state_id` as `order.stateId`, `order`.`rule_ids` as `order.ruleIds`, `order`.`custom_fields` as `order.customFields`, `order`.`created_by_id` as `order.createdById`, `order`.`updated_by_id` as `order.updatedById`, `order.orderCustomer`.`id` as `order.orderCustomer.id`, `order.orderCustomer`.`version_id` as `order.orderCustomer.versionId`, `order.orderCustomer`.`customer_id` as `order.orderCustomer.customerId`, `order.orderCustomer`.`order_id` as `order.orderCustomer.orderId`, `order.orderCustomer`.`order_version_id` as `order.orderCustomer.orderVersionId`, `order.orderCustomer`.`email` as `order.orderCustomer.email`, `order.orderCustomer`.`salutation_id` as `order.orderCustomer.salutationId`, `order.orderCustomer`.`first_name` as `order.orderCustomer.firstName`, `order.orderCustomer`.`last_name` as `order.orderCustomer.lastName`, `order.orderCustomer`.`company` as `order.orderCustomer.company`, `order.orderCustomer`.`title` as `order.orderCustomer.title`, `order.orderCustomer`.`vat_ids` as `order.orderCustomer.vatIds`, `order.orderCustomer`.`customer_number` as `order.orderCustomer.customerNumber`, `order.orderCustomer`.`custom_fields` as `order.orderCustomer.customFields`, `order.orderCustomer`.`remote_address` as `order.orderCustomer.remoteAddress`, `order.orderCustomer`.`created_at` as `order.orderCustomer.createdAt`, `order.orderCustomer`.`updated_at` as `order.orderCustomer.updatedAt`, `order.orderCustomer.customer`.`id` as `order.orderCustomer.customer.id`, `order.orderCustomer.customer`.`customer_group_id` as `order.orderCustomer.customer.groupId`, `order.orderCustomer.customer`.`sales_channel_id` as `order.orderCustomer.customer.salesChannelId`, `order.orderCustomer.customer`.`language_id` as `order.orderCustomer.customer.languageId`, `order.orderCustomer.customer`.`last_payment_method_id` as `order.orderCustomer.customer.lastPaymentMethodId`, `order.orderCustomer.customer`.`default_billing_address_id` as `order.orderCustomer.customer.defaultBillingAddressId`, `order.orderCustomer.customer`.`default_shipping_address_id` as `order.orderCustomer.customer.defaultShippingAddressId`, `order.orderCustomer.customer`.`auto_increment` as `order.orderCustomer.customer.autoIncrement`, `order.orderCustomer.customer`.`customer_number` as `order.orderCustomer.customer.customerNumber`, `order.orderCustomer.customer`.`salutation_id` as `order.orderCustomer.customer.salutationId`, `order.orderCustomer.customer`.`first_name` as `order.orderCustomer.customer.firstName`, `order.orderCustomer.customer`.`last_name` as `order.orderCustomer.customer.lastName`, `order.orderCustomer.customer`.`company` as `order.orderCustomer.customer.company`, `order.orderCustomer.customer`.`password` as `order.orderCustomer.customer.password`, `order.orderCustomer.customer`.`email` as `order.orderCustomer.customer.email`, `order.orderCustomer.customer`.`title` as `order.orderCustomer.customer.title`, `order.orderCustomer.customer`.`vat_ids` as `order.orderCustomer.customer.vatIds`, `order.orderCustomer.customer`.`affiliate_code` as `order.orderCustomer.customer.affiliateCode`, `order.orderCustomer.customer`.`campaign_code` as `order.orderCustomer.customer.campaignCode`, `order.orderCustomer.customer`.`active` as `order.orderCustomer.customer.active`, `order.orderCustomer.customer`.`double_opt_in_registration` as `order.orderCustomer.customer.doubleOptInRegistration`, `order.orderCustomer.customer`.`double_opt_in_email_sent_date` as `order.orderCustomer.customer.doubleOptInEmailSentDate`, `order.orderCustomer.customer`.`double_opt_in_confirm_date` as `order.orderCustomer.customer.doubleOptInConfirmDate`, `order.orderCustomer.customer`.`hash` as `order.orderCustomer.customer.hash`, `order.orderCustomer.customer`.`guest` as `order.orderCustomer.customer.guest`, `order.orderCustomer.customer`.`first_login` as `order.orderCustomer.customer.firstLogin`, `order.orderCustomer.customer`.`last_login` as `order.orderCustomer.customer.lastLogin`, `order.orderCustomer.customer`.`newsletter_sales_channel_ids` as `order.orderCustomer.customer.newsletterSalesChannelIds`, `order.orderCustomer.customer`.`birthday` as `order.orderCustomer.customer.birthday`, `order.orderCustomer.customer`.`last_order_date` as `order.orderCustomer.customer.lastOrderDate`, `order.orderCustomer.customer`.`order_count` as `order.orderCustomer.customer.orderCount`, `order.orderCustomer.customer`.`order_total_amount` as `order.orderCustomer.customer.orderTotalAmount`, `order.orderCustomer.customer`.`review_count` as `order.orderCustomer.customer.reviewCount`, `order.orderCustomer.customer`.`custom_fields` as `order.orderCustomer.customer.customFields`, `order.orderCustomer.customer`.`legacy_password` as `order.orderCustomer.customer.legacyPassword`, `order.orderCustomer.customer`.`legacy_encoder` as `order.orderCustomer.customer.legacyEncoder`, `order.orderCustomer.customer`.`remote_address` as `order.orderCustomer.customer.remoteAddress`, `order.orderCustomer.customer`.`tag_ids` as `order.orderCustomer.customer.tagIds`, `order.orderCustomer.customer`.`requested_customer_group_id` as `order.orderCustomer.customer.requestedGroupId`, `order.orderCustomer.customer`.`bound_sales_channel_id` as `order.orderCustomer.customer.boundSalesChannelId`, `order.orderCustomer.customer`.`account_type` as `order.orderCustomer.customer.accountType`, `order.orderCustomer.customer`.`created_by_id` as `order.orderCustomer.customer.createdById`, `order.orderCustomer.customer`.`updated_by_id` as `order.orderCustomer.customer.updatedById`, `order.orderCustomer.customer`.`default_payment_method_id` as `order.orderCustomer.customer.defaultPaymentMethodId`, `order.orderCustomer.customer`.`created_at` as `order.orderCustomer.customer.createdAt`, `order.orderCustomer.customer`.`updated_at` as `order.orderCustomer.customer.updatedAt`, `order`.`item_rounding` as `order.itemRounding`, `order`.`total_rounding` as `order.totalRounding`, `order`.`created_at` as `order.createdAt`, `order`.`updated_at` as `order.updatedAt`, `order.stateMachineState`.`id` as `order.stateMachineState.id`, `order.stateMachineState`.`technical_name` as `order.stateMachineState.technicalName`, `order.stateMachineState`.`state_machine_id` as `order.stateMachineState.stateMachineId`, `order.stateMachineState`.`created_at` as `order.stateMachineState.createdAt`, `order.stateMachineState`.`updated_at` as `order.stateMachineState.updatedAt`, `order.stateMachineState.translation.name`, `order.stateMachineState.translation.name` as `order.stateMachineState.name`, `order.stateMachineState.translation.customFields`, `order.stateMachineState.translation.customFields` as `order.stateMachineState.customFields`, `order.language`.`id` as `order.language.id`, `order.language`.`parent_id` as `order.language.parentId`, `order.language`.`locale_id` as `order.language.localeId`, `order.language`.`translation_code_id` as `order.language.translationCodeId`, `order.language`.`name` as `order.language.name`, `order.language`.`custom_fields` as `order.language.customFields`, `order.language`.`created_at` as `order.language.createdAt`, `order.language`.`updated_at` as `order.language.updatedAt`, `order.language.locale`.`id` as `order.language.locale.id`, `order.language.locale`.`code` as `order.language.locale.code`, `order.language.locale`.`created_at` as `order.language.locale.createdAt`, `order.language.locale`.`updated_at` as `order.language.locale.updatedAt`, `order.language.locale.translation.name`, `order.language.locale.translation.name` as `order.language.locale.name`, `order.language.locale.translation.territory`, `order.language.locale.translation.territory` as `order.language.locale.territory`, `order.language.locale.translation.customFields`, `order.language.locale.translation.customFields` as `order.language.locale.customFields`, `order.currency`.`id` as `order.currency.id`, `order.currency`.`factor` as `order.currency.factor`, `order.currency`.`symbol` as `order.currency.symbol`, `order.currency`.`iso_code` as `order.currency.isoCode`, `order.currency`.`position` as `order.currency.position`, `order.currency`.`tax_free_from` as `order.currency.taxFreeFrom`, `order.currency`.`item_rounding` as `order.currency.itemRounding`, `order.currency`.`total_rounding` as `order.currency.totalRounding`, `order.currency`.`created_at` as `order.currency.createdAt`, `order.currency`.`updated_at` as `order.currency.updatedAt`, `order.currency.translation.shortName`, `order.currency.translation.shortName` as `order.currency.shortName`, `order.currency.translation.name`, `order.currency.translation.name` as `order.currency.name`, `order.currency.translation.customFields`, `order.currency.translation.customFields` as `order.currency.customFields`, (SELECT GROUP_CONCAT(HEX(`order.tags.mapping`.`tag_id`) SEPARATOR '||')
                  FROM `order_tag` `order.tags.mapping`
                  WHERE `order.tags.mapping`.`order_id` = `order`.`id` ) as `order.tags.id_mapping` FROM `order` LEFT JOIN `order_customer` `order.orderCustomer` ON `order`.`id` = `order.orderCustomer`.`order_id` AND `order`.`version_id` = `order.orderCustomer`.`order_version_id` LEFT JOIN `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id` LEFT JOIN `language` `order.language` ON `order`.`language_id` = `order.language`.`id` LEFT JOIN `currency` `order.currency` ON `order`.`currency_id` = `order.currency`.`id` LEFT JOIN `customer` `order.orderCustomer.customer` ON `order.orderCustomer`.`customer_id` = `order.orderCustomer.customer`.`id` LEFT JOIN (SELECT `order.stateMachineState.translation`.`state_machine_state_id`, `order.stateMachineState.translation`.`name` as `order.stateMachineState.translation.name`, `order.stateMachineState.translation`.`custom_fields` as `order.stateMachineState.translation.customFields` FROM `state_machine_state_translation` `order.stateMachineState.translation` WHERE `order.stateMachineState.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order.stateMachineState.state_machine_state_translation` ON `order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order.stateMachineState`.`id` LEFT JOIN `locale` `order.language.locale` ON `order.language`.`locale_id` = `order.language.locale`.`id` LEFT JOIN (SELECT `order.language.locale.translation`.`locale_id`, `order.language.locale.translation`.`name` as `order.language.locale.translation.name`, `order.language.locale.translation`.`territory` as `order.language.locale.translation.territory`, `order.language.locale.translation`.`custom_fields` as `order.language.locale.translation.customFields` FROM `locale_translation` `order.language.locale.translation` WHERE `order.language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order.language.locale.locale_translation` ON `order.language.locale.locale_translation`.`locale_id` = `order.language.locale`.`id` LEFT JOIN (SELECT `order.currency.translation`.`currency_id`, `order.currency.translation`.`short_name` as `order.currency.translation.shortName`, `order.currency.translation`.`name` as `order.currency.translation.name`, `order.currency.translation`.`custom_fields` as `order.currency.translation.customFields` FROM `currency_translation` `order.currency.translation` WHERE `order.currency.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order.currency.currency_translation` ON `order.currency.currency_translation`.`currency_id` = `order.currency`.`id` WHERE (`order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`order`.`id` IN (0x0193F43DCECC7357B7FE4B80DABDECDB));

SELECT
  `state_machine_transition`.`id` as `state_machine_transition.id`,
  `state_machine_transition`.`action_name` as `state_machine_transition.actionName`,
  `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`,
  `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`,
  `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`,
  `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`,
  `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`,
  `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt`
FROM
  `state_machine_transition`
WHERE
  (
    `state_machine_transition`.`from_state_id` IN (?)
  )

SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`from_state_id` IN (0x0192B5386A2070ADBA68EAAB84307749));

SELECT
  `order_address`.`id` as `order_address.id`,
  `order_address`.`version_id` as `order_address.versionId`,
  `order_address`.`country_id` as `order_address.countryId`,
  `order_address`.`country_state_id` as `order_address.countryStateId`,
  `order_address`.`order_id` as `order_address.orderId`,
  `order_address`.`order_version_id` as `order_address.orderVersionId`,
  `order_address`.`salutation_id` as `order_address.salutationId`,
  `order_address`.`first_name` as `order_address.firstName`,
  `order_address`.`last_name` as `order_address.lastName`,
  `order_address`.`street` as `order_address.street`,
  `order_address`.`zipcode` as `order_address.zipcode`,
  `order_address`.`city` as `order_address.city`,
  `order_address`.`company` as `order_address.company`,
  `order_address`.`department` as `order_address.department`,
  `order_address`.`title` as `order_address.title`,
  `order_address`.`vat_id` as `order_address.vatId`,
  `order_address`.`phone_number` as `order_address.phoneNumber`,
  `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`,
  `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`,
  `order_address`.`custom_fields` as `order_address.customFields`,
  `order_address`.`created_at` as `order_address.createdAt`,
  `order_address`.`updated_at` as `order_address.updatedAt`,
  `order_address.salutation`.`id` as `order_address.salutation.id`,
  `order_address.salutation`.`salutation_key` as `order_address.salutation.salutationKey`,
  `order_address.salutation`.`created_at` as `order_address.salutation.createdAt`,
  `order_address.salutation`.`updated_at` as `order_address.salutation.updatedAt`,
  `order_address.salutation.translation.displayName`,
  `order_address.salutation.translation.displayName` as `order_address.salutation.displayName`,
  `order_address.salutation.translation.letterName`,
  `order_address.salutation.translation.letterName` as `order_address.salutation.letterName`,
  `order_address.salutation.translation.customFields`,
  `order_address.salutation.translation.customFields` as `order_address.salutation.customFields`,
  `order_address.country`.`id` as `order_address.country.id`,
  `order_address.country`.`iso` as `order_address.country.iso`,
  `order_address.country`.`position` as `order_address.country.position`,
  `order_address.country`.`active` as `order_address.country.active`,
  `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`,
  `order_address.country`.`iso3` as `order_address.country.iso3`,
  `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`,
  `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`,
  `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`,
  `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`,
  `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`,
  `order_address.country`.`customer_tax` as `order_address.country.customerTax`,
  `order_address.country`.`company_tax` as `order_address.country.companyTax`,
  `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`,
  `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`,
  `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`,
  `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`,
  `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`,
  `order_address.country`.`is_eu` as `order_address.country.isEu`,
  `order_address.country`.`created_at` as `order_address.country.createdAt`,
  `order_address.country`.`updated_at` as `order_address.country.updatedAt`,
  `order_address.country.translation.name`,
  `order_address.country.translation.name` as `order_address.country.name`,
  `order_address.country.translation.addressFormat`,
  `order_address.country.translation.addressFormat` as `order_address.country.addressFormat`,
  `order_address.country.translation.customFields`,
  `order_address.country.translation.customFields` as `order_address.country.customFields`,
  `order_address.countryState`.`id` as `order_address.countryState.id`,
  `order_address.countryState`.`country_id` as `order_address.countryState.countryId`,
  `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`,
  `order_address.countryState`.`position` as `order_address.countryState.position`,
  `order_address.countryState`.`active` as `order_address.countryState.active`,
  `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`,
  `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`,
  `order_address.countryState.translation.name`,
  `order_address.countryState.translation.name` as `order_address.countryState.name`,
  `order_address.countryState.translation.customFields`,
  `order_address.countryState.translation.customFields` as `order_address.countryState.customFields`
FROM
  `order_address`
  LEFT JOIN `salutation` `order_address.salutation` ON `order_address`.`salutation_id` = `order_address.salutation`.`id`
  LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id`
  LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id`
  LEFT JOIN (
    SELECT
      `order_address.salutation.translation`.`salutation_id`,
      `order_address.salutation.translation`.`display_name` as `order_address.salutation.translation.displayName`,
      `order_address.salutation.translation`.`letter_name` as `order_address.salutation.translation.letterName`,
      `order_address.salutation.translation`.`custom_fields` as `order_address.salutation.translation.customFields`
    FROM
      `salutation_translation` `order_address.salutation.translation`
    WHERE
      `order_address.salutation.translation`.`language_id` = ?
  ) `order_address.salutation.salutation_translation` ON `order_address.salutation.salutation_translation`.`salutation_id` = `order_address.salutation`.`id`
  LEFT JOIN (
    SELECT
      `order_address.country.translation`.`country_id`,
      `order_address.country.translation`.`name` as `order_address.country.translation.name`,
      `order_address.country.translation`.`custom_fields` as `order_address.country.translation.customFields`,
      `order_address.country.translation`.`address_format` as `order_address.country.translation.addressFormat`
    FROM
      `country_translation` `order_address.country.translation`
    WHERE
      `order_address.country.translation`.`language_id` = ?
  ) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id`
  LEFT JOIN (
    SELECT
      `order_address.countryState.translation`.`country_state_id`,
      `order_address.countryState.translation`.`name` as `order_address.countryState.translation.name`,
      `order_address.countryState.translation`.`custom_fields` as `order_address.countryState.translation.customFields`
    FROM
      `country_state_translation` `order_address.countryState.translation`
    WHERE
      `order_address.countryState.translation`.`language_id` = ?
  ) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id`
WHERE
  (`order_address`.`version_id` = ?)
  AND (
    (
      `order_address`.`order_id` IN (?)
    )
  )

SELECT `order_address`.`id` as `order_address.id`, `order_address`.`version_id` as `order_address.versionId`, `order_address`.`country_id` as `order_address.countryId`, `order_address`.`country_state_id` as `order_address.countryStateId`, `order_address`.`order_id` as `order_address.orderId`, `order_address`.`order_version_id` as `order_address.orderVersionId`, `order_address`.`salutation_id` as `order_address.salutationId`, `order_address`.`first_name` as `order_address.firstName`, `order_address`.`last_name` as `order_address.lastName`, `order_address`.`street` as `order_address.street`, `order_address`.`zipcode` as `order_address.zipcode`, `order_address`.`city` as `order_address.city`, `order_address`.`company` as `order_address.company`, `order_address`.`department` as `order_address.department`, `order_address`.`title` as `order_address.title`, `order_address`.`vat_id` as `order_address.vatId`, `order_address`.`phone_number` as `order_address.phoneNumber`, `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`, `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`, `order_address`.`custom_fields` as `order_address.customFields`, `order_address`.`created_at` as `order_address.createdAt`, `order_address`.`updated_at` as `order_address.updatedAt`, `order_address.salutation`.`id` as `order_address.salutation.id`, `order_address.salutation`.`salutation_key` as `order_address.salutation.salutationKey`, `order_address.salutation`.`created_at` as `order_address.salutation.createdAt`, `order_address.salutation`.`updated_at` as `order_address.salutation.updatedAt`, `order_address.salutation.translation.displayName`, `order_address.salutation.translation.displayName` as `order_address.salutation.displayName`, `order_address.salutation.translation.letterName`, `order_address.salutation.translation.letterName` as `order_address.salutation.letterName`, `order_address.salutation.translation.customFields`, `order_address.salutation.translation.customFields` as `order_address.salutation.customFields`, `order_address.country`.`id` as `order_address.country.id`, `order_address.country`.`iso` as `order_address.country.iso`, `order_address.country`.`position` as `order_address.country.position`, `order_address.country`.`active` as `order_address.country.active`, `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`, `order_address.country`.`iso3` as `order_address.country.iso3`, `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`, `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`, `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`, `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`, `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`, `order_address.country`.`customer_tax` as `order_address.country.customerTax`, `order_address.country`.`company_tax` as `order_address.country.companyTax`, `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`, `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`, `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`, `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`, `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`, `order_address.country`.`is_eu` as `order_address.country.isEu`, `order_address.country`.`created_at` as `order_address.country.createdAt`, `order_address.country`.`updated_at` as `order_address.country.updatedAt`, `order_address.country.translation.name`, `order_address.country.translation.name` as `order_address.country.name`, `order_address.country.translation.addressFormat`, `order_address.country.translation.addressFormat` as `order_address.country.addressFormat`, `order_address.country.translation.customFields`, `order_address.country.translation.customFields` as `order_address.country.customFields`, `order_address.countryState`.`id` as `order_address.countryState.id`, `order_address.countryState`.`country_id` as `order_address.countryState.countryId`, `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`, `order_address.countryState`.`position` as `order_address.countryState.position`, `order_address.countryState`.`active` as `order_address.countryState.active`, `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`, `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`, `order_address.countryState.translation.name`, `order_address.countryState.translation.name` as `order_address.countryState.name`, `order_address.countryState.translation.customFields`, `order_address.countryState.translation.customFields` as `order_address.countryState.customFields` FROM `order_address` LEFT JOIN `salutation` `order_address.salutation` ON `order_address`.`salutation_id` = `order_address.salutation`.`id` LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id` LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id` LEFT JOIN (SELECT `order_address.salutation.translation`.`salutation_id`, `order_address.salutation.translation`.`display_name` as `order_address.salutation.translation.displayName`, `order_address.salutation.translation`.`letter_name` as `order_address.salutation.translation.letterName`, `order_address.salutation.translation`.`custom_fields` as `order_address.salutation.translation.customFields` FROM `salutation_translation` `order_address.salutation.translation` WHERE `order_address.salutation.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_address.salutation.salutation_translation` ON `order_address.salutation.salutation_translation`.`salutation_id` = `order_address.salutation`.`id` LEFT JOIN (SELECT `order_address.country.translation`.`country_id`, `order_address.country.translation`.`name` as `order_address.country.translation.name`, `order_address.country.translation`.`custom_fields` as `order_address.country.translation.customFields`, `order_address.country.translation`.`address_format` as `order_address.country.translation.addressFormat` FROM `country_translation` `order_address.country.translation` WHERE `order_address.country.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id` LEFT JOIN (SELECT `order_address.countryState.translation`.`country_state_id`, `order_address.countryState.translation`.`name` as `order_address.countryState.translation.name`, `order_address.countryState.translation`.`custom_fields` as `order_address.countryState.translation.customFields` FROM `country_state_translation` `order_address.countryState.translation` WHERE `order_address.countryState.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id` WHERE (`order_address`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`order_address`.`order_id` IN (0x0193F43DCECC7357B7FE4B80DABDECDB)));