Symfony Profiler

SELECT 
  `creation_timestamp` 
FROM 
  `migration` 
WHERE 
  `update` IS NOT NULL 
  AND `update_destructive` IS NULL

SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` 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 
  @MIGRATION_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582718994_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345021_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345063_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587126585_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625566312_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606378923_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607952506_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608034991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612945522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620808652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631192197_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1566896378_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1579597261_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580742497_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584020367_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584615734_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588138609_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597841941_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603726376_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620989898_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621518771_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634193548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652779309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574344300_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572944593_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573045796_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573135374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573139562_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573140186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573209317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573209481_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574072727_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576497438_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576497500_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576503670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576505995_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1577972394_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578049087_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578066584_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584096712_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585054485_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585055462_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587976714_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587988241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592301104_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602233999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602832962_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607683101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611068135_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614764106_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625817765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630049295_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636367162_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642147726_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646304817_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648797644_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649245702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652692175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653310700_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653661469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1680157673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1688639650_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1689061373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1701076963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1718713101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1718877324_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1722868766_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666208_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666268_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1713775973_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607423732_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616412445_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616413078_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622039002_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629280389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642507826_IS_ACTIVE = TRUE

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 @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;SET @MIGRATION_1625566312_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1566896378_IS_ACTIVE = TRUE;SET @MIGRATION_1579597261_IS_ACTIVE = TRUE;SET @MIGRATION_1580742497_IS_ACTIVE = TRUE;SET @MIGRATION_1584020367_IS_ACTIVE = TRUE;SET @MIGRATION_1584615734_IS_ACTIVE = TRUE;SET @MIGRATION_1588138609_IS_ACTIVE = TRUE;SET @MIGRATION_1597841941_IS_ACTIVE = TRUE;SET @MIGRATION_1603726376_IS_ACTIVE = TRUE;SET @MIGRATION_1620989898_IS_ACTIVE = TRUE;SET @MIGRATION_1621518771_IS_ACTIVE = TRUE;SET @MIGRATION_1634193548_IS_ACTIVE = TRUE;SET @MIGRATION_1652779309_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1572944593_IS_ACTIVE = TRUE;SET @MIGRATION_1573045796_IS_ACTIVE = TRUE;SET @MIGRATION_1573135374_IS_ACTIVE = TRUE;SET @MIGRATION_1573139562_IS_ACTIVE = TRUE;SET @MIGRATION_1573140186_IS_ACTIVE = TRUE;SET @MIGRATION_1573209317_IS_ACTIVE = TRUE;SET @MIGRATION_1573209481_IS_ACTIVE = TRUE;SET @MIGRATION_1574072727_IS_ACTIVE = TRUE;SET @MIGRATION_1576497438_IS_ACTIVE = TRUE;SET @MIGRATION_1576497500_IS_ACTIVE = TRUE;SET @MIGRATION_1576503670_IS_ACTIVE = TRUE;SET @MIGRATION_1576505995_IS_ACTIVE = TRUE;SET @MIGRATION_1577972394_IS_ACTIVE = TRUE;SET @MIGRATION_1578049087_IS_ACTIVE = TRUE;SET @MIGRATION_1578066584_IS_ACTIVE = TRUE;SET @MIGRATION_1584096712_IS_ACTIVE = TRUE;SET @MIGRATION_1585054485_IS_ACTIVE = TRUE;SET @MIGRATION_1585055462_IS_ACTIVE = TRUE;SET @MIGRATION_1587976714_IS_ACTIVE = TRUE;SET @MIGRATION_1587988241_IS_ACTIVE = TRUE;SET @MIGRATION_1592301104_IS_ACTIVE = TRUE;SET @MIGRATION_1602233999_IS_ACTIVE = TRUE;SET @MIGRATION_1602832962_IS_ACTIVE = TRUE;SET @MIGRATION_1607683101_IS_ACTIVE = TRUE;SET @MIGRATION_1611068135_IS_ACTIVE = TRUE;SET @MIGRATION_1614764106_IS_ACTIVE = TRUE;SET @MIGRATION_1625817765_IS_ACTIVE = TRUE;SET @MIGRATION_1630049295_IS_ACTIVE = TRUE;SET @MIGRATION_1636367162_IS_ACTIVE = TRUE;SET @MIGRATION_1642147726_IS_ACTIVE = TRUE;SET @MIGRATION_1646304817_IS_ACTIVE = TRUE;SET @MIGRATION_1648797644_IS_ACTIVE = TRUE;SET @MIGRATION_1649245702_IS_ACTIVE = TRUE;SET @MIGRATION_1652692175_IS_ACTIVE = TRUE;SET @MIGRATION_1653310700_IS_ACTIVE = TRUE;SET @MIGRATION_1653661469_IS_ACTIVE = TRUE;SET @MIGRATION_1680157673_IS_ACTIVE = TRUE;SET @MIGRATION_1688639650_IS_ACTIVE = TRUE;SET @MIGRATION_1689061373_IS_ACTIVE = TRUE;SET @MIGRATION_1701076963_IS_ACTIVE = TRUE;SET @MIGRATION_1718713101_IS_ACTIVE = TRUE;SET @MIGRATION_1718877324_IS_ACTIVE = TRUE;SET @MIGRATION_1722868766_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1713775973_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;

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 
  item_rounding 
FROM 
  currency 
WHERE 
  id = : id

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT 
  id 
FROM 
  integration 
WHERE 
  access_key = : accessKey

SELECT id FROM integration WHERE access_key = 'SWIAV21VDDZETDJQSHJOU2HRRQ';

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

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

SELECT 
  admin 
FROM 
  `integration` 
WHERE 
  id = : id

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

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

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

SELECT 
  module.module, 
  module.response 
FROM 
  wbm_data_layer_modules module

SELECT module.module, module.response FROM wbm_data_layer_modules module;

SELECT 
  `customer`.`id` as `customer.id`, 
  `customer`.`customer_group_id` as `customer.groupId`, 
  `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`, 
  `customer`.`sales_channel_id` as `customer.salesChannelId`, 
  `customer`.`language_id` as `customer.languageId`, 
  `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`, 
  `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`, 
  `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`, 
  `customer`.`auto_increment` as `customer.autoIncrement`, 
  `customer`.`customer_number` as `customer.customerNumber`, 
  `customer`.`salutation_id` as `customer.salutationId`, 
  `customer`.`first_name` as `customer.firstName`, 
  `customer`.`last_name` as `customer.lastName`, 
  `customer`.`company` as `customer.company`, 
  `customer`.`password` as `customer.password`, 
  `customer`.`email` as `customer.email`, 
  `customer`.`title` as `customer.title`, 
  `customer`.`vat_ids` as `customer.vatIds`, 
  `customer`.`affiliate_code` as `customer.affiliateCode`, 
  `customer`.`campaign_code` as `customer.campaignCode`, 
  `customer`.`active` as `customer.active`, 
  `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`, 
  `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`, 
  `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`, 
  `customer`.`hash` as `customer.hash`, 
  `customer`.`guest` as `customer.guest`, 
  `customer`.`first_login` as `customer.firstLogin`, 
  `customer`.`last_login` as `customer.lastLogin`, 
  `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`, 
  `customer`.`newsletter` as `customer.newsletter`, 
  `customer`.`birthday` as `customer.birthday`, 
  `customer`.`last_order_date` as `customer.lastOrderDate`, 
  `customer`.`order_count` as `customer.orderCount`, 
  `customer`.`order_total_amount` as `customer.orderTotalAmount`, 
  `customer`.`custom_fields` as `customer.customFields`, 
  `customer`.`legacy_password` as `customer.legacyPassword`, 
  `customer`.`legacy_encoder` as `customer.legacyEncoder`, 
  `customer`.`remote_address` as `customer.remoteAddress`, 
  `customer`.`tag_ids` as `customer.tagIds`, 
  `customer`.`requested_customer_group_id` as `customer.requestedGroupId`, 
  `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`, 
  `customer`.`created_at` as `customer.createdAt`, 
  `customer`.`updated_at` as `customer.updatedAt` 
FROM 
  `customer` 
WHERE 
  (
    (
      JSON_CONTAINS(
        `customer`.`tag_ids`, 
        JSON_ARRAY(
          : param_cb31711aaa124f669bf1c6eda6e8625f
        )
      ) 
      AND `customer`.`active` = : param_1f1337cf0a9d4377805854ae2ccaab29
    )
  )

SELECT `customer`.`id` as `customer.id`, `customer`.`customer_group_id` as `customer.groupId`, `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` as `customer.salesChannelId`, `customer`.`language_id` as `customer.languageId`, `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`, `customer`.`auto_increment` as `customer.autoIncrement`, `customer`.`customer_number` as `customer.customerNumber`, `customer`.`salutation_id` as `customer.salutationId`, `customer`.`first_name` as `customer.firstName`, `customer`.`last_name` as `customer.lastName`, `customer`.`company` as `customer.company`, `customer`.`password` as `customer.password`, `customer`.`email` as `customer.email`, `customer`.`title` as `customer.title`, `customer`.`vat_ids` as `customer.vatIds`, `customer`.`affiliate_code` as `customer.affiliateCode`, `customer`.`campaign_code` as `customer.campaignCode`, `customer`.`active` as `customer.active`, `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`, `customer`.`hash` as `customer.hash`, `customer`.`guest` as `customer.guest`, `customer`.`first_login` as `customer.firstLogin`, `customer`.`last_login` as `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`, `customer`.`newsletter` as `customer.newsletter`, `customer`.`birthday` as `customer.birthday`, `customer`.`last_order_date` as `customer.lastOrderDate`, `customer`.`order_count` as `customer.orderCount`, `customer`.`order_total_amount` as `customer.orderTotalAmount`, `customer`.`custom_fields` as `customer.customFields`, `customer`.`legacy_password` as `customer.legacyPassword`, `customer`.`legacy_encoder` as `customer.legacyEncoder`, `customer`.`remote_address` as `customer.remoteAddress`, `customer`.`tag_ids` as `customer.tagIds`, `customer`.`requested_customer_group_id` as `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`, `customer`.`created_at` as `customer.createdAt`, `customer`.`updated_at` as `customer.updatedAt` FROM `customer` WHERE ((JSON_CONTAINS(`customer`.`tag_ids`, JSON_ARRAY('59fcd62c29964ca79423b44439aebebc')) AND `customer`.`active` = '0'));