Symfony Profiler

# app-scripts::refresh::read
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]

# app-scripts::refresh::read
SELECT
  `app`.`id` AS `app.id`,
  `app`.`name` AS `app.name`,
  `app`.`path` AS `app.path`,
  `app`.`author` AS `app.author`,
  `app`.`copyright` AS `app.copyright`,
  `app`.`license` AS `app.license`,
  `app`.`active` AS `app.active`,
  `app`.`configurable` AS `app.configurable`,
  `app`.`privacy` AS `app.privacy`,
  `app`.`version` AS `app.version`,
  `app`.`icon` AS `app.iconRaw`,
  `app`.`app_secret` AS `app.appSecret`,
  `app`.`modules` AS `app.modules`,
  `app`.`main_module` AS `app.mainModule`,
  `app`.`cookies` AS `app.cookies`,
  `app`.`allow_disable` AS `app.allowDisable`,
  `app`.`base_app_url` AS `app.baseAppUrl`,
  `app`.`allowed_hosts` AS `app.allowedHosts`,
  `app`.`template_load_priority` AS `app.templateLoadPriority`,
  `app`.`integration_id` AS `app.integrationId`,
  `app.integration`.`id` AS `app.integration.id`,
  `app.integration`.`label` AS `app.integration.label`,
  `app.integration`.`access_key` AS `app.integration.accessKey`,
  `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`,
  `app.integration`.`admin` AS `app.integration.admin`,
  `app.integration`.`custom_fields` AS `app.integration.customFields`,
  `app.integration`.`deleted_at` AS `app.integration.deletedAt`,
  `app.integration`.`write_access` AS `app.integration.writeAccess`,
  `app.integration`.`created_at` AS `app.integration.createdAt`,
  `app.integration`.`updated_at` AS `app.integration.updatedAt`,
  `app`.`acl_role_id` AS `app.aclRoleId`,
  `app.aclRole`.`id` AS `app.aclRole.id`,
  `app.aclRole`.`name` AS `app.aclRole.name`,
  `app.aclRole`.`description` AS `app.aclRole.description`,
  `app.aclRole`.`privileges` AS `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` AS `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`,
  `app`.`created_at` AS `app.createdAt`,
  `app`.`updated_at` AS `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) AS `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) AS `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) AS `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) AS `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label AS `app.translation.label`,
      `app.translation`.description AS `app.translation.description`,
      `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields AS `app.translation.customFields`,
      `app.translation`.created_at AS `app.translation.createdAt`,
      `app.translation`.updated_at AS `app.translation.updatedAt`,
      `app.translation`.app_id AS `app.translation.appId`,
      `app.translation`.language_id AS `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  LEFT JOIN (SELECT `product.options.translation`.property_group_option_id, `product.options.translation`.name AS `product.options.translation.name`, `product.options.translation`.position AS `product.options.translation.position`, `product.options.translation`.custom_fields AS `product.options.translation.customFields`, `product.options.translation`.created_at AS `product.options.translation.createdAt`, `product.options.translation`.updated_at AS `product.options.translation.updatedAt`, `product.options.translation`.property_group_option_id AS `product.options.translation.propertyGroupOptionId`, `product.options.translation`.language_id AS `product.options.translation.languageId` FROM `property_group_option_translation` `product.options.translation` WHERE `product.options.translation`.language_id = ?) `product.options.property_group_option_translation` ON `product.options.property_group_option_translation`.`property_group_option_id` = `product.options`.`id` WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND (JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?)) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY(?))) AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) GROUP BY `product`.`id` ORDER BY MAX(IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100))) DESC, MIN(COALESCE(`product.options.translation.name`)) ASC

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"³┬ì3ÄfE¡░\x1Eðé8}\x16>"
  "0273dad9bd60b0c0c369597118216a35"
  "06381c0da663457b86b8f90eafa079a0"
  "0d3d238b089a67e34e39b5abf80db19b"
  "2bd7f6bbcf7e4cc490559313f56aa38d"
  "32f97f6e8d90432983af8cf5b8e7beb0"
  "33b1929f4a9a34b0cc0274860e07096a"
  "3d17514e3da75d06bf5ccaed068ba7da"
  "40e761b767911fa296c401f849bfb67d"
  "4a0b0dcedd48f780778d1cd1bb8f9877"
  "5948e633898c4f2646653c8c936b6317"
  "5bd435f1cb8c433abacf3eceb9ee7452"
  "5fbad92ff1cd4d2ea49e9677a07740d9"
  "6a9a822363f221f7927a18d900e3d8df"
  "7312251c2f6f44a5b6d9c7877ec37a7d"
  "7b934a60ddc07b8f5b1134c03430bba6"
  "7e5590fece884b6da6d0ced6f05eba97"
  "81dabfe564f24da898ddcd59c6814754"
  "84109ae4b4178430b8174b1dfef9162b"
  "94ca8ea720644008ac28e8710a682aeb"
  "980ef8d89e13449eaffb8605500fb28a"
  "9d56f8d5611bc53fa1b652cb83345e21"
  "9dc02319575a4cc8820a041a78667870"
  "ab24c1a6f62d456caad3e6577c7186f6"
  "c2d59bf241054168aa6d01b20e8dcf40"
  "cddd7e243c0943b0971aed0f1a4eac8c"
  "e72080967a8d4e2fb64875b73364a825"
  "e89e4008477e4703b9bd81b30908e52b"
  "efc5f4b470619b932aed03953e50ce60"
  "f355b9915a8b46fda70f7c13784bb3cf"
  "f849bf52fcfd25b0cd6e3f2e74607516"
  "fe01d67a002dfa0f3ac084298142eccd"
  10
  b"nÓc§ÌPGØ×Z3ε2¢▒"
  true
]

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`
  AND `product`.`version_id` = `product.options.mapping`.`product_version_id`
  LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`
  LEFT JOIN (
    SELECT
      `product.options.translation`.property_group_option_id,
      `product.options.translation`.name AS `product.options.translation.name`,
      `product.options.translation`.position AS `product.options.translation.position`,
      `product.options.translation`.custom_fields AS `product.options.translation.customFields`,
      `product.options.translation`.created_at AS `product.options.translation.createdAt`,
      `product.options.translation`.updated_at AS `product.options.translation.updatedAt`,
      `product.options.translation`.property_group_option_id AS `product.options.translation.propertyGroupOptionId`,
      `product.options.translation`.language_id AS `product.options.translation.languageId`
    FROM
      `property_group_option_translation` `product.options.translation`
    WHERE
      `product.options.translation`.language_id = ?
  ) `product.options.property_group_option_translation` ON `product.options.property_group_option_translation`.`property_group_option_id` = `product.options`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      `product`.`parent_id` = ?
      AND (
        JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
        OR JSON_CONTAINS(
          IFNULL(
            `product`.`option_ids`, `product.parent`.`option_ids`
          ),
          JSON_ARRAY(?)
        )
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
GROUP BY
  `product`.`id`
ORDER BY
  MAX(
    IFNULL(
      (
        ROUND(
          (
            ROUND(
              CAST(
                (
                  COALESCE(
                    (
                      JSON_UNQUOTE(
                        JSON_EXTRACT(
                          `product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                        )
                      ) + 0.0
                    )
                  )
                ) AS DECIMAL(30, 20)
              ),
              2
            )
          ) * 100,
          0
        ) / 100
      ),
      (
        ROUND(
          (
            ROUND(
              CAST(
                (
                  COALESCE(
                    (
                      JSON_UNQUOTE(
                        JSON_EXTRACT(
                          `product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                        )
                      ) + 0.0
                    )
                  )
                ) AS DECIMAL(30, 20)
              ),
              2
            )
          ) * 100,
          0
        ) / 100
      )
    )
  ) DESC,
  MIN(
    COALESCE(
      `product.options.translation.name`
    )
  ) ASC

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  LEFT JOIN (SELECT `product.options.translation`.property_group_option_id, `product.options.translation`.name AS `product.options.translation.name`, `product.options.translation`.position AS `product.options.translation.position`, `product.options.translation`.custom_fields AS `product.options.translation.customFields`, `product.options.translation`.created_at AS `product.options.translation.createdAt`, `product.options.translation`.updated_at AS `product.options.translation.updatedAt`, `product.options.translation`.property_group_option_id AS `product.options.translation.propertyGroupOptionId`, `product.options.translation`.language_id AS `product.options.translation.languageId` FROM `property_group_option_translation` `product.options.translation` WHERE `product.options.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.options.property_group_option_translation` ON `product.options.property_group_option_translation`.`property_group_option_id` = `product.options`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` = 0xFCC28D338E6645ADB01ED082387D163E AND (JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('0273dad9bd60b0c0c369597118216a35')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('06381c0da663457b86b8f90eafa079a0')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('0d3d238b089a67e34e39b5abf80db19b')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('2bd7f6bbcf7e4cc490559313f56aa38d')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('32f97f6e8d90432983af8cf5b8e7beb0')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('33b1929f4a9a34b0cc0274860e07096a')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('3d17514e3da75d06bf5ccaed068ba7da')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('40e761b767911fa296c401f849bfb67d')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('4a0b0dcedd48f780778d1cd1bb8f9877')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('5948e633898c4f2646653c8c936b6317')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('5bd435f1cb8c433abacf3eceb9ee7452')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('5fbad92ff1cd4d2ea49e9677a07740d9')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('6a9a822363f221f7927a18d900e3d8df')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('7312251c2f6f44a5b6d9c7877ec37a7d')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('7b934a60ddc07b8f5b1134c03430bba6')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('7e5590fece884b6da6d0ced6f05eba97')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('81dabfe564f24da898ddcd59c6814754')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('84109ae4b4178430b8174b1dfef9162b')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('94ca8ea720644008ac28e8710a682aeb')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('980ef8d89e13449eaffb8605500fb28a')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('9d56f8d5611bc53fa1b652cb83345e21')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('9dc02319575a4cc8820a041a78667870')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('ab24c1a6f62d456caad3e6577c7186f6')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('c2d59bf241054168aa6d01b20e8dcf40')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('cddd7e243c0943b0971aed0f1a4eac8c')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('e72080967a8d4e2fb64875b73364a825')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('e89e4008477e4703b9bd81b30908e52b')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('efc5f4b470619b932aed03953e50ce60')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('f355b9915a8b46fda70f7c13784bb3cf')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('f849bf52fcfd25b0cd6e3f2e74607516')) OR JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('fe01d67a002dfa0f3ac084298142eccd'))) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x6EE063F5DE50479D9E5A33D7E632BDB1 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) GROUP BY `product`.`id` ORDER BY MAX(IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100))) DESC, MIN(COALESCE(`product.options.translation.name`)) ASC;

SELECT `swag_customized_products_template_option`.`id` AS `swag_customized_products_template_option.id`, `swag_customized_products_template_option`.`version_id` AS `swag_customized_products_template_option.versionId`, `swag_customized_products_template_option`.`template_version_id` AS `swag_customized_products_template_option.templateVersionId`, `swag_customized_products_template_option`.`type` AS `swag_customized_products_template_option.type`, `swag_customized_products_template_option`.`type_properties` AS `swag_customized_products_template_option.typeProperties`, `swag_customized_products_template_option`.`item_number` AS `swag_customized_products_template_option.itemNumber`, `swag_customized_products_template_option`.`required` AS `swag_customized_products_template_option.required`, `swag_customized_products_template_option`.`one_time_surcharge` AS `swag_customized_products_template_option.oneTimeSurcharge`, `swag_customized_products_template_option`.`relative_surcharge` AS `swag_customized_products_template_option.relativeSurcharge`, `swag_customized_products_template_option`.`advanced_surcharge` AS `swag_customized_products_template_option.advancedSurcharge`, `swag_customized_products_template_option`.`position` AS `swag_customized_products_template_option.position`, `swag_customized_products_template_option`.`price` AS `swag_customized_products_template_option.price`, `swag_customized_products_template_option`.`percentage_surcharge` AS `swag_customized_products_template_option.percentageSurcharge`, `swag_customized_products_template_option`.`template_id` AS `swag_customized_products_template_option.templateId`, `swag_customized_products_template_option`.`tax_id` AS `swag_customized_products_template_option.taxId`, `swag_customized_products_template_option`.`created_at` AS `swag_customized_products_template_option.createdAt`, `swag_customized_products_template_option`.`updated_at` AS `swag_customized_products_template_option.updatedAt`, `swag_customized_products_template_option.translation.displayName`, COALESCE(`swag_customized_products_template_option.translation.displayName`,`swag_customized_products_template_option.translation.displayName`) AS `swag_customized_products_template_option.displayName`, `swag_customized_products_template_option.translation.description`, COALESCE(`swag_customized_products_template_option.translation.description`,`swag_customized_products_template_option.translation.description`) AS `swag_customized_products_template_option.description`, `swag_customized_products_template_option.translation.placeholder`, COALESCE(`swag_customized_products_template_option.translation.placeholder`,`swag_customized_products_template_option.translation.placeholder`) AS `swag_customized_products_template_option.placeholder`, `swag_customized_products_template_option.translation.createdAt`, `swag_customized_products_template_option.translation.updatedAt`, `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`, `swag_customized_products_template_option.translation.languageId`, `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId` FROM `swag_customized_products_template_option` LEFT JOIN (SELECT `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id, `swag_customized_products_template_option.translation`.display_name AS `swag_customized_products_template_option.translation.displayName`, `swag_customized_products_template_option.translation`.description AS `swag_customized_products_template_option.translation.description`, `swag_customized_products_template_option.translation`.placeholder AS `swag_customized_products_template_option.translation.placeholder`, `swag_customized_products_template_option.translation`.created_at AS `swag_customized_products_template_option.translation.createdAt`, `swag_customized_products_template_option.translation`.updated_at AS `swag_customized_products_template_option.translation.updatedAt`, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`, `swag_customized_products_template_option.translation`.language_id AS `swag_customized_products_template_option.translation.languageId`, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId` FROM `swag_customized_products_template_option_translation` `swag_customized_products_template_option.translation` WHERE `swag_customized_products_template_option.translation`.language_id = ?) `swag_customized_products_template_option.swag_customized_products_template_option_translation` ON `swag_customized_products_template_option.swag_customized_products_template_option_translation`.`swag_customized_products_template_option_id` = `swag_customized_products_template_option`.`id` AND `swag_customized_products_template_option.swag_customized_products_template_option_translation`.swag_customized_products_template_option_version_id = `swag_customized_products_template_option`.version_id WHERE (`swag_customized_products_template_option`.`version_id` = ?) AND ((`swag_customized_products_template_option`.`template_id` IN (?, ?, ?))) ORDER BY `swag_customized_products_template_option`.`position` ASC

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"$ÌíE”Ÿ‡¶–r&Î{ô©n"
  b"ßM_-˜$lGx\x18eÍ[y­&"
  b"®ò£ëí<ü5┬È┴@fı╬\x1A"
]

SELECT
  `swag_customized_products_template_option`.`id` AS `swag_customized_products_template_option.id`,
  `swag_customized_products_template_option`.`version_id` AS `swag_customized_products_template_option.versionId`,
  `swag_customized_products_template_option`.`template_version_id` AS `swag_customized_products_template_option.templateVersionId`,
  `swag_customized_products_template_option`.`type` AS `swag_customized_products_template_option.type`,
  `swag_customized_products_template_option`.`type_properties` AS `swag_customized_products_template_option.typeProperties`,
  `swag_customized_products_template_option`.`item_number` AS `swag_customized_products_template_option.itemNumber`,
  `swag_customized_products_template_option`.`required` AS `swag_customized_products_template_option.required`,
  `swag_customized_products_template_option`.`one_time_surcharge` AS `swag_customized_products_template_option.oneTimeSurcharge`,
  `swag_customized_products_template_option`.`relative_surcharge` AS `swag_customized_products_template_option.relativeSurcharge`,
  `swag_customized_products_template_option`.`advanced_surcharge` AS `swag_customized_products_template_option.advancedSurcharge`,
  `swag_customized_products_template_option`.`position` AS `swag_customized_products_template_option.position`,
  `swag_customized_products_template_option`.`price` AS `swag_customized_products_template_option.price`,
  `swag_customized_products_template_option`.`percentage_surcharge` AS `swag_customized_products_template_option.percentageSurcharge`,
  `swag_customized_products_template_option`.`template_id` AS `swag_customized_products_template_option.templateId`,
  `swag_customized_products_template_option`.`tax_id` AS `swag_customized_products_template_option.taxId`,
  `swag_customized_products_template_option`.`created_at` AS `swag_customized_products_template_option.createdAt`,
  `swag_customized_products_template_option`.`updated_at` AS `swag_customized_products_template_option.updatedAt`,
  `swag_customized_products_template_option.translation.displayName`,
  COALESCE(
    `swag_customized_products_template_option.translation.displayName`,
    `swag_customized_products_template_option.translation.displayName`
  ) AS `swag_customized_products_template_option.displayName`,
  `swag_customized_products_template_option.translation.description`,
  COALESCE(
    `swag_customized_products_template_option.translation.description`,
    `swag_customized_products_template_option.translation.description`
  ) AS `swag_customized_products_template_option.description`,
  `swag_customized_products_template_option.translation.placeholder`,
  COALESCE(
    `swag_customized_products_template_option.translation.placeholder`,
    `swag_customized_products_template_option.translation.placeholder`
  ) AS `swag_customized_products_template_option.placeholder`,
  `swag_customized_products_template_option.translation.createdAt`,
  `swag_customized_products_template_option.translation.updatedAt`,
  `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`,
  `swag_customized_products_template_option.translation.languageId`,
  `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId`
FROM
  `swag_customized_products_template_option`
  LEFT JOIN (
    SELECT
      `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id,
      `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id,
      `swag_customized_products_template_option.translation`.display_name AS `swag_customized_products_template_option.translation.displayName`,
      `swag_customized_products_template_option.translation`.description AS `swag_customized_products_template_option.translation.description`,
      `swag_customized_products_template_option.translation`.placeholder AS `swag_customized_products_template_option.translation.placeholder`,
      `swag_customized_products_template_option.translation`.created_at AS `swag_customized_products_template_option.translation.createdAt`,
      `swag_customized_products_template_option.translation`.updated_at AS `swag_customized_products_template_option.translation.updatedAt`,
      `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`,
      `swag_customized_products_template_option.translation`.language_id AS `swag_customized_products_template_option.translation.languageId`,
      `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId`
    FROM
      `swag_customized_products_template_option_translation` `swag_customized_products_template_option.translation`
    WHERE
      `swag_customized_products_template_option.translation`.language_id = ?
  ) `swag_customized_products_template_option.swag_customized_products_template_option_translation` ON `swag_customized_products_template_option.swag_customized_products_template_option_translation`.`swag_customized_products_template_option_id` = `swag_customized_products_template_option`.`id`
  AND `swag_customized_products_template_option.swag_customized_products_template_option_translation`.swag_customized_products_template_option_version_id = `swag_customized_products_template_option`.version_id
WHERE
  (
    `swag_customized_products_template_option`.`version_id` = ?
  )
  AND (
    (
      `swag_customized_products_template_option`.`template_id` IN (?, ?, ?)
    )
  )
ORDER BY
  `swag_customized_products_template_option`.`position` ASC

SELECT `swag_customized_products_template_option`.`id` AS `swag_customized_products_template_option.id`, `swag_customized_products_template_option`.`version_id` AS `swag_customized_products_template_option.versionId`, `swag_customized_products_template_option`.`template_version_id` AS `swag_customized_products_template_option.templateVersionId`, `swag_customized_products_template_option`.`type` AS `swag_customized_products_template_option.type`, `swag_customized_products_template_option`.`type_properties` AS `swag_customized_products_template_option.typeProperties`, `swag_customized_products_template_option`.`item_number` AS `swag_customized_products_template_option.itemNumber`, `swag_customized_products_template_option`.`required` AS `swag_customized_products_template_option.required`, `swag_customized_products_template_option`.`one_time_surcharge` AS `swag_customized_products_template_option.oneTimeSurcharge`, `swag_customized_products_template_option`.`relative_surcharge` AS `swag_customized_products_template_option.relativeSurcharge`, `swag_customized_products_template_option`.`advanced_surcharge` AS `swag_customized_products_template_option.advancedSurcharge`, `swag_customized_products_template_option`.`position` AS `swag_customized_products_template_option.position`, `swag_customized_products_template_option`.`price` AS `swag_customized_products_template_option.price`, `swag_customized_products_template_option`.`percentage_surcharge` AS `swag_customized_products_template_option.percentageSurcharge`, `swag_customized_products_template_option`.`template_id` AS `swag_customized_products_template_option.templateId`, `swag_customized_products_template_option`.`tax_id` AS `swag_customized_products_template_option.taxId`, `swag_customized_products_template_option`.`created_at` AS `swag_customized_products_template_option.createdAt`, `swag_customized_products_template_option`.`updated_at` AS `swag_customized_products_template_option.updatedAt`, `swag_customized_products_template_option.translation.displayName`, COALESCE(`swag_customized_products_template_option.translation.displayName`,`swag_customized_products_template_option.translation.displayName`) AS `swag_customized_products_template_option.displayName`, `swag_customized_products_template_option.translation.description`, COALESCE(`swag_customized_products_template_option.translation.description`,`swag_customized_products_template_option.translation.description`) AS `swag_customized_products_template_option.description`, `swag_customized_products_template_option.translation.placeholder`, COALESCE(`swag_customized_products_template_option.translation.placeholder`,`swag_customized_products_template_option.translation.placeholder`) AS `swag_customized_products_template_option.placeholder`, `swag_customized_products_template_option.translation.createdAt`, `swag_customized_products_template_option.translation.updatedAt`, `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`, `swag_customized_products_template_option.translation.languageId`, `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId` FROM `swag_customized_products_template_option` LEFT JOIN (SELECT `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id, `swag_customized_products_template_option.translation`.display_name AS `swag_customized_products_template_option.translation.displayName`, `swag_customized_products_template_option.translation`.description AS `swag_customized_products_template_option.translation.description`, `swag_customized_products_template_option.translation`.placeholder AS `swag_customized_products_template_option.translation.placeholder`, `swag_customized_products_template_option.translation`.created_at AS `swag_customized_products_template_option.translation.createdAt`, `swag_customized_products_template_option.translation`.updated_at AS `swag_customized_products_template_option.translation.updatedAt`, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionId`, `swag_customized_products_template_option.translation`.language_id AS `swag_customized_products_template_option.translation.languageId`, `swag_customized_products_template_option.translation`.swag_customized_products_template_option_version_id AS `swag_customized_products_template_option.translation.swagCustomizedProductsTemplateOptionVersionId` FROM `swag_customized_products_template_option_translation` `swag_customized_products_template_option.translation` WHERE `swag_customized_products_template_option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `swag_customized_products_template_option.swag_customized_products_template_option_translation` ON `swag_customized_products_template_option.swag_customized_products_template_option_translation`.`swag_customized_products_template_option_id` = `swag_customized_products_template_option`.`id` AND `swag_customized_products_template_option.swag_customized_products_template_option_translation`.swag_customized_products_template_option_version_id = `swag_customized_products_template_option`.version_id WHERE (`swag_customized_products_template_option`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`swag_customized_products_template_option`.`template_id` IN (0x24CCED45949F87B6967226CE7BF4A96E, 0xDF4D5F2D98246C47781865CD5B79AD26, 0xA9959C89A13C8135C2D4C14066D5CE1A))) ORDER BY `swag_customized_products_template_option`.`position` ASC;

SELECT `swag_customized_products_template_option_value_price`.`id` AS `swag_customized_products_template_option_value_price.id`, `swag_customized_products_template_option_value_price`.`version_id` AS `swag_customized_products_template_option_value_price.versionId`, `swag_customized_products_template_option_value_price`.`template_option_value_id` AS `swag_customized_products_template_option_value_price.templateOptionValueId`, `swag_customized_products_template_option_value_price`.`template_option_value_version_id` AS `swag_customized_products_template_option_value_price.templateOptionValueVersionId`, `swag_customized_products_template_option_value_price`.`price` AS `swag_customized_products_template_option_value_price.price`, `swag_customized_products_template_option_value_price`.`percentage_surcharge` AS `swag_customized_products_template_option_value_price.percentageSurcharge`, `swag_customized_products_template_option_value_price`.`rule_id` AS `swag_customized_products_template_option_value_price.ruleId`, `swag_customized_products_template_option_value_price`.`created_at` AS `swag_customized_products_template_option_value_price.createdAt`, `swag_customized_products_template_option_value_price`.`updated_at` AS `swag_customized_products_template_option_value_price.updatedAt` FROM `swag_customized_products_template_option_value_price` WHERE (`swag_customized_products_template_option_value_price`.`version_id` = ?) AND ((`swag_customized_products_template_option_value_price`.`template_option_value_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))

[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x19•0A¨¾Ñ.´\r×y¬š\x04á"
  b"\x1DØÅÇ®\f\x03Û'¯,ÐX\\x15╠"
  b"3ÕJR•^/³Û颬\rÉâ\x12"
  b"|â\x05!\x0EN†È"éì·)r§Ì"
  b"¬å×Ö\x12]&²{.ræq¿\tf"
  b"Ý\x0F^¡¶"ÇÖË¥”ºd\x0Fb\n"
  b"""
    \x06\x1A0çr/ÄŒ\x15ÿåóË\n
    „+
    """
  b"\vt*á\x02Ú÷Â\x02Ñ°Ê…Ã\x1Aƒ"
  b"\x1F\x02û±ÜrÚñ3ØÏ$¢¹!y"
  b")ŸÅ(—÷»Vr;y·L¬É@"
  b"‘và+¬\x15U\x12ø¹;ð9‰\x11K"
  b"¤a?UZ—éÆ>\x10o“X4ʳ"
  b")]®ÿµ6«L¨\x10ΟۮÃÂ"
  b")¸¥ÖcõUþ\x0F²“ï¿ò²Ä"
  b"x\x0EÆÊ─ñ┼%'oüÏ\v\x13±L"
  b"Âgää[˜\x00~¾ù'6ì\x03{“"
  b"öe‘E\x1Eñ"ëÂîŽ2ýí)r"
  b"ûxÖ]׫\x16†Ìú¸µ¸z‰T"
  b"4ÇD%Z¨êuü9ºDÉ˾}"
  b"g;­6§Ô©ÂQiB„\x00ß\x12¼"
  b"†\x10\x1Eκ_ücW\e\x1CÔ*0UÜ"
  b"\x03KônÓmdÅ\x19)}Ù Å‹ö"
  b":*˜ì}ÈVÍAÙ\x08ld|0k"
  b"È£\x1Døz1>8Y=È\x0E4côÉ"
  b"¦î,**OÖ┐6ɹ»H■c'"
  b"µkDØã╩█▓Áæªl└ö§\x1A"
  b"ù/þRl\x11SxNÊ8l4³DD"
  b"8#n†P×êí,-íÊ\ÒqŒ"
  b"^OD0Ĭ=]Æ׌\x17€cÎí"
  b"¦ÕFX¶eè±É¥‘ß\rï#z"
  b"°\vwõg<b]\x1CGo˜"Ëð]"
  b"±:4RCiÓY¹«CžÕª–\x00"
  b"øÈÒš1\t%êÎ\x15²dÖ79\x0F"
  b"(\ÔKÿ…Ö’™bì'[îˆÞ"
  b"EXQœÅ¹K¾*\x1F;R'FÝ_"
  b"è;\x08]╬Ö¢'║▄\x07Pü{¼C"
  b"""
    ULÁ?’\n
    \n
    î¹\tj‹PPÞ½
    """
  b"f#là$ƒÅèp\x10®Ù╬{\x1FÈ"
  b"k°\x08?½3\x1AÏ&¼Ø\t¤êRþ"
  b"—@<\v\x04©±‡lg1>—³šÐ"
  b"݉ð}@h« © ¯$Z)[\f"
  b"ýv▓\x0Eg¶╠Eì\x05¥þ´¸Û\x07"
  b";$úðªÂ¿gÊÖë–G\r·K"
  b"a¥─ØS¥*nº%G\x16┌\x08;¹"
  b"æyç\x18\x14¥\x7F¬ª{-É®à¨ã"
  b"âaÕ>ä‰\x1F°Êá\f<¦¦Êo"
  b"òØÝ\x03ÙZU¬ÀzH\v\x13»f?"
  b"þ\x02¸ÙT+†X,glikZîj"
  b"\x02ü\rðMÛ▒2\x16§«øXßü:"
  b"Ø\x12Y┌ÖÞÐ┼îK┌!├¼,\x0F"
  b"""
    ÄÇè\x1AËË\n
    ý‚á>+o-ŸW
    """
]

SELECT
  `swag_customized_products_template_option_value_price`.`id` AS `swag_customized_products_template_option_value_price.id`,
  `swag_customized_products_template_option_value_price`.`version_id` AS `swag_customized_products_template_option_value_price.versionId`,
  `swag_customized_products_template_option_value_price`.`template_option_value_id` AS `swag_customized_products_template_option_value_price.templateOptionValueId`,
  `swag_customized_products_template_option_value_price`.`template_option_value_version_id` AS `swag_customized_products_template_option_value_price.templateOptionValueVersionId`,
  `swag_customized_products_template_option_value_price`.`price` AS `swag_customized_products_template_option_value_price.price`,
  `swag_customized_products_template_option_value_price`.`percentage_surcharge` AS `swag_customized_products_template_option_value_price.percentageSurcharge`,
  `swag_customized_products_template_option_value_price`.`rule_id` AS `swag_customized_products_template_option_value_price.ruleId`,
  `swag_customized_products_template_option_value_price`.`created_at` AS `swag_customized_products_template_option_value_price.createdAt`,
  `swag_customized_products_template_option_value_price`.`updated_at` AS `swag_customized_products_template_option_value_price.updatedAt`
FROM
  `swag_customized_products_template_option_value_price`
WHERE
  (
    `swag_customized_products_template_option_value_price`.`version_id` = ?
  )
  AND (
    (
      `swag_customized_products_template_option_value_price`.`template_option_value_id` IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?
      )
    )
  )

SELECT `swag_customized_products_template_option_value_price`.`id` AS `swag_customized_products_template_option_value_price.id`, `swag_customized_products_template_option_value_price`.`version_id` AS `swag_customized_products_template_option_value_price.versionId`, `swag_customized_products_template_option_value_price`.`template_option_value_id` AS `swag_customized_products_template_option_value_price.templateOptionValueId`, `swag_customized_products_template_option_value_price`.`template_option_value_version_id` AS `swag_customized_products_template_option_value_price.templateOptionValueVersionId`, `swag_customized_products_template_option_value_price`.`price` AS `swag_customized_products_template_option_value_price.price`, `swag_customized_products_template_option_value_price`.`percentage_surcharge` AS `swag_customized_products_template_option_value_price.percentageSurcharge`, `swag_customized_products_template_option_value_price`.`rule_id` AS `swag_customized_products_template_option_value_price.ruleId`, `swag_customized_products_template_option_value_price`.`created_at` AS `swag_customized_products_template_option_value_price.createdAt`, `swag_customized_products_template_option_value_price`.`updated_at` AS `swag_customized_products_template_option_value_price.updatedAt` FROM `swag_customized_products_template_option_value_price` WHERE (`swag_customized_products_template_option_value_price`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`swag_customized_products_template_option_value_price`.`template_option_value_id` IN (0x19953041A8BED12EB40DD779AC9A04E1, 0x1D9D8F80A90C03EA27EE2CD1585C15CC, 0x33D54A52955E2FB3DBE9A2AC0DC9E212, 0x7CE205210E4E86C822E9ECB72972A7CC, 0xACE5D7D6125D26B27B2E72E671BF0966, 0xDD0F5EA1B622C7D6CBA594BA640F620A, 0x061A30E7722FC48C15FFE5F3CB0A842B, 0x0B742AE102DAF7C202D1B0CA85C31A83, 0x1F0296F19A72E9A4339DD824BDFB2179, 0x299FC52897F7BB56723B79B74CACC940, 0x9176E02BAC155512F8B93BF03989114B, 0xA4613F555A97E9C63E106F935834CAB3, 0x295DAEFFB536AB4CA810CE9FDBAEC3C2, 0x29B8A5D663F555FE0FB293EFBFF2B2C4, 0x780E92D2C4A4C525276F81D80B13F14C, 0xC267E4E45B98007EBEF92736EC037B93, 0xF66591451EF122EBC2EE8E32FDED2972, 0xFB78D65DD7AB1686CCFAB8B5B87A8954, 0x348044255AF988758139A74490D3F37D, 0x673BAD36A7D4A9C25169428400DF12BC, 0x86101ECEBA5FFC63571B1CD42A3055DC, 0x034BF46ED36D64C519297DD9A0C58BF6, 0x3A2A98EC7DC856CD41D9086C647C306B, 0xC8A31DF87A313E38593DC80E3463F4C9, 0xDD8C2C2A2A4F99BF3690FBAF48FE6327, 0xE66B449DC6CADBB2B591A66CC094F51A, 0xF92FFE526C1153784ECA386C34B34444, 0x38236E8650D7EAED2C2DEDCA5CD2718C, 0x5E4F4430C4AC3D5DC6D78C178063CEED, 0xA6D54658B665E8B1C9A591DF0DEF237A, 0xB00B77F5673C625D1C476F9822CBF05D, 0xB13A34524369D359B9AB439ED5AA9600, 0xF8C8D29A310925EACE15B264D637390F, 0x285CD44BFF85D6929962EC275BEE88DE, 0x4558519CC5B94BBE2A1F3B522746DD5F, 0x8A3B085DCE99BD27BADC0750817BAC43, 0x554CC13F920A0AEEB9096A8B5050DEBD, 0x66236C85249F8F8A7010A9EBCE7B1FD4, 0x6BB0083FBD331ACF26BCD809A4EA52FE, 0x97403C0B04A9B1876C67313E97B39AD0, 0xDD89F07D4068ABA0A920AF245A295B0C, 0xEC76B20E67F4CC458D05BEE7EFF7EA07, 0x3B24FAF0AAC2BF67CAD6EB96470DB74B, 0x61BEC49D53BE2A6EA7254716DA083BFB, 0x9179871814BE7FAAA67B2D90A985F9C6, 0xE261D53EE4891FB0CAE10C3CA6A6CA6F, 0xF2D8DD03D95A55ACC07A480B13BB663F, 0xFE02B8D9542B86582C676C696B5AEE6A, 0x02810DD04DEAB13216F5AE9B58E1813A, 0x9D1259DA99E8D1C58C4BDA21C3AC2C0F, 0xC4C7E81ACBCB0AFD82E13E2B6F2D9F57)));

SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product.parent`.`cheapest_price` AS `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) AS `product.cheapestPrice`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, COALESCE(`product`.`swag_customized_products_template_id`, `product.parent`.`swag_customized_products_template_id`) AS `product.swagCustomizedProductsTemplateId`, COALESCE(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) AS `product.swagCustomizedProductsTemplateVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) AS `product.options.id_mapping`, `product.unit`.`id` AS `product.unit.id`, `product.unit`.`created_at` AS `product.unit.createdAt`, `product.unit`.`updated_at` AS `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) AS `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) AS `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) AS `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` AS `product.deliveryTime.id`, `product.deliveryTime`.`min` AS `product.deliveryTime.min`, `product.deliveryTime`.`max` AS `product.deliveryTime.max`, `product.deliveryTime`.`unit` AS `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` AS `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` AS `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) AS `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) AS `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` AS `product.cover.id`, `product.cover`.`version_id` AS `product.cover.versionId`, `product.cover`.`product_id` AS `product.cover.productId`, `product.cover`.`product_version_id` AS `product.cover.productVersionId`, `product.cover`.`media_id` AS `product.cover.mediaId`, `product.cover`.`position` AS `product.cover.position`, `product.cover.media`.`id` AS `product.cover.media.id`, `product.cover.media`.`user_id` AS `product.cover.media.userId`, `product.cover.media`.`media_folder_id` AS `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` AS `product.cover.media.mimeType`, `product.cover.media`.`file_extension` AS `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` AS `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` AS `product.cover.media.fileName`, `product.cover.media`.`file_size` AS `product.cover.media.fileSize`, `product.cover.media`.`media_type` AS `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` AS `product.cover.media.metaData`, `product.cover.media`.`config` AS `product.cover.media.config`, `product.cover.media`.`path` AS `product.cover.media.path`, `product.cover.media`.`private` AS `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` AS `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` AS `product.cover.media.createdAt`, `product.cover.media`.`updated_at` AS `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) AS `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) AS `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) AS `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` AS `product.cover.customFields`, `product.cover`.`created_at` AS `product.cover.createdAt`, `product.cover`.`updated_at` AS `product.cover.updatedAt`, `product.swagCustomizedProductsTemplate`.`id` AS `product.swagCustomizedProductsTemplate.id`, `product.swagCustomizedProductsTemplate`.`version_id` AS `product.swagCustomizedProductsTemplate.versionId`, `product.swagCustomizedProductsTemplate`.`parent_version_id` AS `product.swagCustomizedProductsTemplate.parentVersionId`, `product.swagCustomizedProductsTemplate`.`internal_name` AS `product.swagCustomizedProductsTemplate.internalName`, `product.swagCustomizedProductsTemplate`.`active` AS `product.swagCustomizedProductsTemplate.active`, `product.swagCustomizedProductsTemplate`.`step_by_step` AS `product.swagCustomizedProductsTemplate.stepByStep`, `product.swagCustomizedProductsTemplate`.`confirm_input` AS `product.swagCustomizedProductsTemplate.confirmInput`, `product.swagCustomizedProductsTemplate`.`options_auto_collapse` AS `product.swagCustomizedProductsTemplate.optionsAutoCollapse`, `product.swagCustomizedProductsTemplate`.`decision_tree` AS `product.swagCustomizedProductsTemplate.decisionTree`, `product.swagCustomizedProductsTemplate`.`media_id` AS `product.swagCustomizedProductsTemplate.mediaId`, `product.swagCustomizedProductsTemplate`.`created_at` AS `product.swagCustomizedProductsTemplate.createdAt`, `product.swagCustomizedProductsTemplate`.`updated_at` AS `product.swagCustomizedProductsTemplate.updatedAt`, `product.swagCustomizedProductsTemplate.translation.displayName`, COALESCE(`product.swagCustomizedProductsTemplate.translation.displayName`,`product.swagCustomizedProductsTemplate.translation.displayName`) AS `product.swagCustomizedProductsTemplate.displayName`, `product.swagCustomizedProductsTemplate.translation.description`, COALESCE(`product.swagCustomizedProductsTemplate.translation.description`,`product.swagCustomizedProductsTemplate.translation.description`) AS `product.swagCustomizedProductsTemplate.description`, `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `swag_customized_products_template` `product.swagCustomizedProductsTemplate` ON `product`.`swagCustomizedProductsTemplate` = `product.swagCustomizedProductsTemplate`.`id` AND IFNULL(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) = `product.swagCustomizedProductsTemplate`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code AS `product.unit.translation.shortCode`, `product.unit.translation`.name AS `product.unit.translation.name`, `product.unit.translation`.custom_fields AS `product.unit.translation.customFields`, `product.unit.translation`.created_at AS `product.unit.translation.createdAt`, `product.unit.translation`.updated_at AS `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id AS `product.unit.translation.unitId`, `product.unit.translation`.language_id AS `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name AS `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields AS `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at AS `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at AS `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id AS `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id AS `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title AS `product.cover.media.translation.title`, `product.cover.media.translation`.alt AS `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields AS `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at AS `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at AS `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id AS `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id AS `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id, `product.swagCustomizedProductsTemplate.translation`.display_name AS `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation`.description AS `product.swagCustomizedProductsTemplate.translation.description`, `product.swagCustomizedProductsTemplate.translation`.created_at AS `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation`.updated_at AS `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id AS `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation`.language_id AS `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id AS `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId` FROM `swag_customized_products_template_translation` `product.swagCustomizedProductsTemplate.translation` WHERE `product.swagCustomizedProductsTemplate.translation`.language_id = ?) `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation` ON `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_id` = `product.swagCustomizedProductsTemplate`.`id` AND `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.swag_customized_products_template_version_id = `product.swagCustomizedProductsTemplate`.version_id WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?))