Symfony Profiler

# 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
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id IS NULL
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

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

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

SELECT
  last_updated_password_at
FROM
  user
WHERE
  id = ?

SELECT last_updated_password_at FROM user WHERE id = 0xEDCEBCA0768F4C41AAF8B25164CC010C;

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT
  role.privileges
FROM
  acl_user_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.user_id = ?

SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0xEDCEBCA0768F4C41AAF8B25164CC010C;

SELECT
  admin
FROM
  `user`
WHERE
  id = ?

SELECT admin FROM `user` WHERE id = 0xEDCEBCA0768F4C41AAF8B25164CC010C;

SELECT
  `order`.`id`,
  `order`.`auto_increment`,
  `order`.`order_number`
FROM
  `order`
WHERE
  `order`.`version_id` = ?
ORDER BY
  `order`.`order_date_time` DESC
LIMIT
  25

SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE `order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ORDER BY `order`.`order_date_time` DESC LIMIT 25;

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

SELECT COUNT(*) FROM (SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE `order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) 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`.`item_rounding` as `order.itemRounding`,
  `order`.`total_rounding` as `order.totalRounding`,
  `order`.`created_at` as `order.createdAt`,
  `order`.`updated_at` as `order.updatedAt`,
  `order.merchantOfTrustExtension`.`id` as `order.merchantOfTrustExtension.id`,
  `order.merchantOfTrustExtension`.`order_id` as `order.merchantOfTrustExtension.orderId`,
  `order.merchantOfTrustExtension`.`merchant_id` as `order.merchantOfTrustExtension.merchantId`,
  `order.merchantOfTrustExtension`.`created_at` as `order.merchantOfTrustExtension.createdAt`,
  `order.merchantOfTrustExtension`.`updated_at` as `order.merchantOfTrustExtension.updatedAt`,
  `order.billingAddress`.`id` as `order.billingAddress.id`,
  `order.billingAddress`.`version_id` as `order.billingAddress.versionId`,
  `order.billingAddress`.`country_id` as `order.billingAddress.countryId`,
  `order.billingAddress`.`country_state_id` as `order.billingAddress.countryStateId`,
  `order.billingAddress`.`order_id` as `order.billingAddress.orderId`,
  `order.billingAddress`.`order_version_id` as `order.billingAddress.orderVersionId`,
  `order.billingAddress`.`salutation_id` as `order.billingAddress.salutationId`,
  `order.billingAddress`.`first_name` as `order.billingAddress.firstName`,
  `order.billingAddress`.`last_name` as `order.billingAddress.lastName`,
  `order.billingAddress`.`street` as `order.billingAddress.street`,
  `order.billingAddress`.`zipcode` as `order.billingAddress.zipcode`,
  `order.billingAddress`.`city` as `order.billingAddress.city`,
  `order.billingAddress`.`company` as `order.billingAddress.company`,
  `order.billingAddress`.`department` as `order.billingAddress.department`,
  `order.billingAddress`.`title` as `order.billingAddress.title`,
  `order.billingAddress`.`vat_id` as `order.billingAddress.vatId`,
  `order.billingAddress`.`phone_number` as `order.billingAddress.phoneNumber`,
  `order.billingAddress`.`additional_address_line1` as `order.billingAddress.additionalAddressLine1`,
  `order.billingAddress`.`additional_address_line2` as `order.billingAddress.additionalAddressLine2`,
  `order.billingAddress`.`custom_fields` as `order.billingAddress.customFields`,
  `order.billingAddress`.`created_at` as `order.billingAddress.createdAt`,
  `order.billingAddress`.`updated_at` as `order.billingAddress.updatedAt`,
  `order.salesChannel`.`id` as `order.salesChannel.id`,
  `order.salesChannel`.`type_id` as `order.salesChannel.typeId`,
  `order.salesChannel`.`language_id` as `order.salesChannel.languageId`,
  `order.salesChannel`.`customer_group_id` as `order.salesChannel.customerGroupId`,
  `order.salesChannel`.`currency_id` as `order.salesChannel.currencyId`,
  `order.salesChannel`.`payment_method_id` as `order.salesChannel.paymentMethodId`,
  `order.salesChannel`.`shipping_method_id` as `order.salesChannel.shippingMethodId`,
  `order.salesChannel`.`country_id` as `order.salesChannel.countryId`,
  `order.salesChannel`.`analytics_id` as `order.salesChannel.analyticsId`,
  `order.salesChannel`.`navigation_category_id` as `order.salesChannel.navigationCategoryId`,
  `order.salesChannel`.`navigation_category_version_id` as `order.salesChannel.navigationCategoryVersionId`,
  `order.salesChannel`.`navigation_category_depth` as `order.salesChannel.navigationCategoryDepth`,
  `order.salesChannel`.`footer_category_id` as `order.salesChannel.footerCategoryId`,
  `order.salesChannel`.`footer_category_version_id` as `order.salesChannel.footerCategoryVersionId`,
  `order.salesChannel`.`service_category_id` as `order.salesChannel.serviceCategoryId`,
  `order.salesChannel`.`service_category_version_id` as `order.salesChannel.serviceCategoryVersionId`,
  `order.salesChannel`.`mail_header_footer_id` as `order.salesChannel.mailHeaderFooterId`,
  `order.salesChannel`.`hreflang_default_domain_id` as `order.salesChannel.hreflangDefaultDomainId`,
  `order.salesChannel`.`short_name` as `order.salesChannel.shortName`,
  `order.salesChannel`.`tax_calculation_type` as `order.salesChannel.taxCalculationType`,
  `order.salesChannel`.`access_key` as `order.salesChannel.accessKey`,
  `order.salesChannel`.`configuration` as `order.salesChannel.configuration`,
  `order.salesChannel`.`active` as `order.salesChannel.active`,
  `order.salesChannel`.`hreflang_active` as `order.salesChannel.hreflangActive`,
  `order.salesChannel`.`maintenance` as `order.salesChannel.maintenance`,
  `order.salesChannel`.`maintenance_ip_whitelist` as `order.salesChannel.maintenanceIpWhitelist`,
  `order.salesChannel`.`payment_method_ids` as `order.salesChannel.paymentMethodIds`,
  `order.salesChannel`.`home_cms_page_id` as `order.salesChannel.homeCmsPageId`,
  `order.salesChannel`.`home_cms_page_version_id` as `order.salesChannel.homeCmsPageVersionId`,
  `order.salesChannel`.`created_at` as `order.salesChannel.createdAt`,
  `order.salesChannel`.`updated_at` as `order.salesChannel.updatedAt`,
  `order.salesChannel.translation.name`,
  `order.salesChannel.translation.name` as `order.salesChannel.name`,
  `order.salesChannel.translation.homeSlotConfig`,
  `order.salesChannel.translation.homeSlotConfig` as `order.salesChannel.homeSlotConfig`,
  `order.salesChannel.translation.homeEnabled`,
  `order.salesChannel.translation.homeEnabled` as `order.salesChannel.homeEnabled`,
  `order.salesChannel.translation.homeName`,
  `order.salesChannel.translation.homeName` as `order.salesChannel.homeName`,
  `order.salesChannel.translation.homeMetaTitle`,
  `order.salesChannel.translation.homeMetaTitle` as `order.salesChannel.homeMetaTitle`,
  `order.salesChannel.translation.homeMetaDescription`,
  `order.salesChannel.translation.homeMetaDescription` as `order.salesChannel.homeMetaDescription`,
  `order.salesChannel.translation.homeKeywords`,
  `order.salesChannel.translation.homeKeywords` as `order.salesChannel.homeKeywords`,
  `order.salesChannel.translation.customFields`,
  `order.salesChannel.translation.customFields` as `order.salesChannel.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`,
  `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`
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 `intellicon_merchant_of_trust_extension` `order.merchantOfTrustExtension` ON `order`.`id` = `order.merchantOfTrustExtension`.`order_id`
  LEFT JOIN `order_address` `order.billingAddress` ON `order`.`billing_address_id` = `order.billingAddress`.`id`
  AND `order`.`billing_address_version_id` = `order.billingAddress`.`version_id`
  LEFT JOIN `sales_channel` `order.salesChannel` ON `order`.`sales_channel_id` = `order.salesChannel`.`id`
  LEFT JOIN `currency` `order.currency` ON `order`.`currency_id` = `order.currency`.`id`
  LEFT JOIN `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id`
  LEFT JOIN (
    SELECT
      `order.salesChannel.translation`.`sales_channel_id`,
      `order.salesChannel.translation`.`name` as `order.salesChannel.translation.name`,
      `order.salesChannel.translation`.`custom_fields` as `order.salesChannel.translation.customFields`,
      `order.salesChannel.translation`.`home_slot_config` as `order.salesChannel.translation.homeSlotConfig`,
      `order.salesChannel.translation`.`home_enabled` as `order.salesChannel.translation.homeEnabled`,
      `order.salesChannel.translation`.`home_name` as `order.salesChannel.translation.homeName`,
      `order.salesChannel.translation`.`home_meta_title` as `order.salesChannel.translation.homeMetaTitle`,
      `order.salesChannel.translation`.`home_meta_description` as `order.salesChannel.translation.homeMetaDescription`,
      `order.salesChannel.translation`.`home_keywords` as `order.salesChannel.translation.homeKeywords`
    FROM
      `sales_channel_translation` `order.salesChannel.translation`
    WHERE
      `order.salesChannel.translation`.`language_id` = ?
  ) `order.salesChannel.sales_channel_translation` ON `order.salesChannel.sales_channel_translation`.`sales_channel_id` = `order.salesChannel`.`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`
  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`
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`.`item_rounding` as `order.itemRounding`, `order`.`total_rounding` as `order.totalRounding`, `order`.`created_at` as `order.createdAt`, `order`.`updated_at` as `order.updatedAt`, `order.merchantOfTrustExtension`.`id` as `order.merchantOfTrustExtension.id`, `order.merchantOfTrustExtension`.`order_id` as `order.merchantOfTrustExtension.orderId`, `order.merchantOfTrustExtension`.`merchant_id` as `order.merchantOfTrustExtension.merchantId`, `order.merchantOfTrustExtension`.`created_at` as `order.merchantOfTrustExtension.createdAt`, `order.merchantOfTrustExtension`.`updated_at` as `order.merchantOfTrustExtension.updatedAt`, `order.billingAddress`.`id` as `order.billingAddress.id`, `order.billingAddress`.`version_id` as `order.billingAddress.versionId`, `order.billingAddress`.`country_id` as `order.billingAddress.countryId`, `order.billingAddress`.`country_state_id` as `order.billingAddress.countryStateId`, `order.billingAddress`.`order_id` as `order.billingAddress.orderId`, `order.billingAddress`.`order_version_id` as `order.billingAddress.orderVersionId`, `order.billingAddress`.`salutation_id` as `order.billingAddress.salutationId`, `order.billingAddress`.`first_name` as `order.billingAddress.firstName`, `order.billingAddress`.`last_name` as `order.billingAddress.lastName`, `order.billingAddress`.`street` as `order.billingAddress.street`, `order.billingAddress`.`zipcode` as `order.billingAddress.zipcode`, `order.billingAddress`.`city` as `order.billingAddress.city`, `order.billingAddress`.`company` as `order.billingAddress.company`, `order.billingAddress`.`department` as `order.billingAddress.department`, `order.billingAddress`.`title` as `order.billingAddress.title`, `order.billingAddress`.`vat_id` as `order.billingAddress.vatId`, `order.billingAddress`.`phone_number` as `order.billingAddress.phoneNumber`, `order.billingAddress`.`additional_address_line1` as `order.billingAddress.additionalAddressLine1`, `order.billingAddress`.`additional_address_line2` as `order.billingAddress.additionalAddressLine2`, `order.billingAddress`.`custom_fields` as `order.billingAddress.customFields`, `order.billingAddress`.`created_at` as `order.billingAddress.createdAt`, `order.billingAddress`.`updated_at` as `order.billingAddress.updatedAt`, `order.salesChannel`.`id` as `order.salesChannel.id`, `order.salesChannel`.`type_id` as `order.salesChannel.typeId`, `order.salesChannel`.`language_id` as `order.salesChannel.languageId`, `order.salesChannel`.`customer_group_id` as `order.salesChannel.customerGroupId`, `order.salesChannel`.`currency_id` as `order.salesChannel.currencyId`, `order.salesChannel`.`payment_method_id` as `order.salesChannel.paymentMethodId`, `order.salesChannel`.`shipping_method_id` as `order.salesChannel.shippingMethodId`, `order.salesChannel`.`country_id` as `order.salesChannel.countryId`, `order.salesChannel`.`analytics_id` as `order.salesChannel.analyticsId`, `order.salesChannel`.`navigation_category_id` as `order.salesChannel.navigationCategoryId`, `order.salesChannel`.`navigation_category_version_id` as `order.salesChannel.navigationCategoryVersionId`, `order.salesChannel`.`navigation_category_depth` as `order.salesChannel.navigationCategoryDepth`, `order.salesChannel`.`footer_category_id` as `order.salesChannel.footerCategoryId`, `order.salesChannel`.`footer_category_version_id` as `order.salesChannel.footerCategoryVersionId`, `order.salesChannel`.`service_category_id` as `order.salesChannel.serviceCategoryId`, `order.salesChannel`.`service_category_version_id` as `order.salesChannel.serviceCategoryVersionId`, `order.salesChannel`.`mail_header_footer_id` as `order.salesChannel.mailHeaderFooterId`, `order.salesChannel`.`hreflang_default_domain_id` as `order.salesChannel.hreflangDefaultDomainId`, `order.salesChannel`.`short_name` as `order.salesChannel.shortName`, `order.salesChannel`.`tax_calculation_type` as `order.salesChannel.taxCalculationType`, `order.salesChannel`.`access_key` as `order.salesChannel.accessKey`, `order.salesChannel`.`configuration` as `order.salesChannel.configuration`, `order.salesChannel`.`active` as `order.salesChannel.active`, `order.salesChannel`.`hreflang_active` as `order.salesChannel.hreflangActive`, `order.salesChannel`.`maintenance` as `order.salesChannel.maintenance`, `order.salesChannel`.`maintenance_ip_whitelist` as `order.salesChannel.maintenanceIpWhitelist`, `order.salesChannel`.`payment_method_ids` as `order.salesChannel.paymentMethodIds`, `order.salesChannel`.`home_cms_page_id` as `order.salesChannel.homeCmsPageId`, `order.salesChannel`.`home_cms_page_version_id` as `order.salesChannel.homeCmsPageVersionId`, `order.salesChannel`.`created_at` as `order.salesChannel.createdAt`, `order.salesChannel`.`updated_at` as `order.salesChannel.updatedAt`, `order.salesChannel.translation.name`, `order.salesChannel.translation.name` as `order.salesChannel.name`, `order.salesChannel.translation.homeSlotConfig`, `order.salesChannel.translation.homeSlotConfig` as `order.salesChannel.homeSlotConfig`, `order.salesChannel.translation.homeEnabled`, `order.salesChannel.translation.homeEnabled` as `order.salesChannel.homeEnabled`, `order.salesChannel.translation.homeName`, `order.salesChannel.translation.homeName` as `order.salesChannel.homeName`, `order.salesChannel.translation.homeMetaTitle`, `order.salesChannel.translation.homeMetaTitle` as `order.salesChannel.homeMetaTitle`, `order.salesChannel.translation.homeMetaDescription`, `order.salesChannel.translation.homeMetaDescription` as `order.salesChannel.homeMetaDescription`, `order.salesChannel.translation.homeKeywords`, `order.salesChannel.translation.homeKeywords` as `order.salesChannel.homeKeywords`, `order.salesChannel.translation.customFields`, `order.salesChannel.translation.customFields` as `order.salesChannel.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`, `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` 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 `intellicon_merchant_of_trust_extension` `order.merchantOfTrustExtension` ON `order`.`id` = `order.merchantOfTrustExtension`.`order_id` LEFT JOIN `order_address` `order.billingAddress` ON `order`.`billing_address_id` = `order.billingAddress`.`id` AND `order`.`billing_address_version_id` = `order.billingAddress`.`version_id` LEFT JOIN `sales_channel` `order.salesChannel` ON `order`.`sales_channel_id` = `order.salesChannel`.`id` LEFT JOIN `currency` `order.currency` ON `order`.`currency_id` = `order.currency`.`id` LEFT JOIN `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id` LEFT JOIN (SELECT `order.salesChannel.translation`.`sales_channel_id`, `order.salesChannel.translation`.`name` as `order.salesChannel.translation.name`, `order.salesChannel.translation`.`custom_fields` as `order.salesChannel.translation.customFields`, `order.salesChannel.translation`.`home_slot_config` as `order.salesChannel.translation.homeSlotConfig`, `order.salesChannel.translation`.`home_enabled` as `order.salesChannel.translation.homeEnabled`, `order.salesChannel.translation`.`home_name` as `order.salesChannel.translation.homeName`, `order.salesChannel.translation`.`home_meta_title` as `order.salesChannel.translation.homeMetaTitle`, `order.salesChannel.translation`.`home_meta_description` as `order.salesChannel.translation.homeMetaDescription`, `order.salesChannel.translation`.`home_keywords` as `order.salesChannel.translation.homeKeywords` FROM `sales_channel_translation` `order.salesChannel.translation` WHERE `order.salesChannel.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order.salesChannel.sales_channel_translation` ON `order.salesChannel.sales_channel_translation`.`sales_channel_id` = `order.salesChannel`.`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` 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` WHERE (`order`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`order`.`id` IN (0x01948876ECF67066AE2A2A4164C4E0F9, 0x0194886A313072F1B803511F0C65748F, 0x01948864F2AD7126AA5F451255E14502, 0x019488584F31700D91D9F760488CBA1C, 0x01948843AB5970D98041C7493AF64D7E, 0x01948840427570D28186EA0009B0C869, 0x01948833A294721595D5B1CEAB2C158B, 0x0194882FCFBC712BBD139CB7EAE89D56, 0x01948822E18F73BD847E5048B6D55DC9, 0x01948746EFAA7052BFAC4FA2B7B18EA5, 0x019484C3B39F7069A845E8860B06C133, 0x0194844EC73D7157B68F1870E95FB2B2, 0x0194842E123672919ADA7FBD2469BAA1, 0x01948410C226735EB67B6F5AF9A6493B, 0x019483ED44B170CEB2B10F1D4C512987, 0x019483E697E9708D8420481535494571, 0x01948388D72F7355B809F6E82F0BF5FC, 0x0194834A559D7342BD5889D4C86D50E9, 0x019483367AB671D48A94BA04BE66DC84, 0x0194832FECFE707AACCDD2F6B3CD86C0, 0x01948328F00E7285AE0BA1AAC098A814, 0x01948319670370CE9166E6EDD6AC565D, 0x0194830AE08C703B8FE93AA540D975D3, 0x019482F821C37151A68506B96CFB828F, 0x019482E72C6272B2A8EE0BAADC16BFA7));

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

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`
FROM
  `order_address`
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` FROM `order_address` WHERE (`order_address`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`order_address`.`order_id` IN (0x019482E72C6272B2A8EE0BAADC16BFA7, 0x019482F821C37151A68506B96CFB828F, 0x0194830AE08C703B8FE93AA540D975D3, 0x01948319670370CE9166E6EDD6AC565D, 0x01948328F00E7285AE0BA1AAC098A814, 0x0194832FECFE707AACCDD2F6B3CD86C0, 0x019483367AB671D48A94BA04BE66DC84, 0x0194834A559D7342BD5889D4C86D50E9, 0x01948388D72F7355B809F6E82F0BF5FC, 0x019483E697E9708D8420481535494571, 0x019483ED44B170CEB2B10F1D4C512987, 0x01948410C226735EB67B6F5AF9A6493B, 0x0194842E123672919ADA7FBD2469BAA1, 0x0194844EC73D7157B68F1870E95FB2B2, 0x019484C3B39F7069A845E8860B06C133, 0x01948746EFAA7052BFAC4FA2B7B18EA5, 0x01948822E18F73BD847E5048B6D55DC9, 0x0194882FCFBC712BBD139CB7EAE89D56, 0x01948833A294721595D5B1CEAB2C158B, 0x01948840427570D28186EA0009B0C869, 0x01948843AB5970D98041C7493AF64D7E, 0x019488584F31700D91D9F760488CBA1C, 0x01948864F2AD7126AA5F451255E14502, 0x0194886A313072F1B803511F0C65748F, 0x01948876ECF67066AE2A2A4164C4E0F9)));

SELECT
  `document`.`id` as `document.id`,
  `document`.`document_type_id` as `document.documentTypeId`,
  `document`.`file_type` as `document.fileType`,
  `document`.`referenced_document_id` as `document.referencedDocumentId`,
  `document`.`order_id` as `document.orderId`,
  `document`.`document_media_file_id` as `document.documentMediaFileId`,
  `document`.`order_version_id` as `document.orderVersionId`,
  `document`.`config` as `document.config`,
  `document`.`sent` as `document.sent`,
  `document`.`static` as `document.static`,
  `document`.`deep_link_code` as `document.deepLinkCode`,
  `document`.`document_number` as `document.documentNumber`,
  `document`.`custom_fields` as `document.customFields`,
  `document`.`created_at` as `document.createdAt`,
  `document`.`updated_at` as `document.updatedAt`
FROM
  `document`
WHERE
  (
    `document`.`order_id` IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )

SELECT `document`.`id` as `document.id`, `document`.`document_type_id` as `document.documentTypeId`, `document`.`file_type` as `document.fileType`, `document`.`referenced_document_id` as `document.referencedDocumentId`, `document`.`order_id` as `document.orderId`, `document`.`document_media_file_id` as `document.documentMediaFileId`, `document`.`order_version_id` as `document.orderVersionId`, `document`.`config` as `document.config`, `document`.`sent` as `document.sent`, `document`.`static` as `document.static`, `document`.`deep_link_code` as `document.deepLinkCode`, `document`.`document_number` as `document.documentNumber`, `document`.`custom_fields` as `document.customFields`, `document`.`created_at` as `document.createdAt`, `document`.`updated_at` as `document.updatedAt` FROM `document` WHERE (`document`.`order_id` IN (0x019482E72C6272B2A8EE0BAADC16BFA7, 0x019482F821C37151A68506B96CFB828F, 0x0194830AE08C703B8FE93AA540D975D3, 0x01948319670370CE9166E6EDD6AC565D, 0x01948328F00E7285AE0BA1AAC098A814, 0x0194832FECFE707AACCDD2F6B3CD86C0, 0x019483367AB671D48A94BA04BE66DC84, 0x0194834A559D7342BD5889D4C86D50E9, 0x01948388D72F7355B809F6E82F0BF5FC, 0x019483E697E9708D8420481535494571, 0x019483ED44B170CEB2B10F1D4C512987, 0x01948410C226735EB67B6F5AF9A6493B, 0x0194842E123672919ADA7FBD2469BAA1, 0x0194844EC73D7157B68F1870E95FB2B2, 0x019484C3B39F7069A845E8860B06C133, 0x01948746EFAA7052BFAC4FA2B7B18EA5, 0x01948822E18F73BD847E5048B6D55DC9, 0x0194882FCFBC712BBD139CB7EAE89D56, 0x01948833A294721595D5B1CEAB2C158B, 0x01948840427570D28186EA0009B0C869, 0x01948843AB5970D98041C7493AF64D7E, 0x019488584F31700D91D9F760488CBA1C, 0x01948864F2AD7126AA5F451255E14502, 0x0194886A313072F1B803511F0C65748F, 0x01948876ECF67066AE2A2A4164C4E0F9));