Symfony Profiler

# cache-id-loader
SELECT 
  `value` 
FROM 
  app_config 
WHERE 
  `key` = : key

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

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

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

SELECT 
  custom_entity.name, 
  custom_entity.fields 
FROM 
  custom_entity 
  LEFT JOIN app ON app.id = custom_entity.app_id 
WHERE 
  custom_entity.app_id IS NULL 
  OR app.active = 1

SELECT custom_entity.name, custom_entity.fields 
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
            ;

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_1636014089_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636362839_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636964297_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636971615_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638195971_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638365464_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638514913_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639122665_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639139581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639992771_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641289204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642517958_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642757286_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643366069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643386819_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643724178_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645019769_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645453538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646125417_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646817331_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647260673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647443222_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031611_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031636_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648803451_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649040981_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649315608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650620993_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_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655730949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657027979_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660814397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661759290_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661771388_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663238480_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664541794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664894872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665267882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641476963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584005462_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589800641_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589800704_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589882802_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589905764_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591365484_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626082072_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_1576850740_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576850750_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576850760_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598353434_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622466310_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634545059_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765935_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765936_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765937_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765938_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538046469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538985581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1544535797_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1563456847_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564041870_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564053392_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587476616_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589448383_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593494859_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593508853_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615794849_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712721_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712737_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712739_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712749_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712751_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582712756_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583331545_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583331555_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583331565_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587677036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618836492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619431576_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626959873_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638521990_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642146887_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644481138_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651832316_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653039072_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658231030_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663150051_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665742302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607509138_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621417443_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629818108_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1557055670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1628172267_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644922949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642784245_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645626265_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645646886_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645646961_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589963718_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619069101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623656945_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623820553_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624275180_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633436214_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1570840015_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580400794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580401225_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615889159_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661505236_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665435663_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666859263_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673945260_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1687242751_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1691081373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664344197_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_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_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_1576850740_IS_ACTIVE = TRUE;SET @MIGRATION_1576850750_IS_ACTIVE = TRUE;SET @MIGRATION_1576850760_IS_ACTIVE = TRUE;SET @MIGRATION_1598353434_IS_ACTIVE = TRUE;SET @MIGRATION_1622466310_IS_ACTIVE = TRUE;SET @MIGRATION_1634545059_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1582712721_IS_ACTIVE = TRUE;SET @MIGRATION_1582712737_IS_ACTIVE = TRUE;SET @MIGRATION_1582712739_IS_ACTIVE = TRUE;SET @MIGRATION_1582712749_IS_ACTIVE = TRUE;SET @MIGRATION_1582712751_IS_ACTIVE = TRUE;SET @MIGRATION_1582712753_IS_ACTIVE = TRUE;SET @MIGRATION_1582712756_IS_ACTIVE = TRUE;SET @MIGRATION_1583331545_IS_ACTIVE = TRUE;SET @MIGRATION_1583331555_IS_ACTIVE = TRUE;SET @MIGRATION_1583331565_IS_ACTIVE = TRUE;SET @MIGRATION_1587677036_IS_ACTIVE = TRUE;SET @MIGRATION_1618836492_IS_ACTIVE = TRUE;SET @MIGRATION_1619431576_IS_ACTIVE = TRUE;SET @MIGRATION_1626959873_IS_ACTIVE = TRUE;SET @MIGRATION_1638521990_IS_ACTIVE = TRUE;SET @MIGRATION_1642146887_IS_ACTIVE = TRUE;SET @MIGRATION_1644481138_IS_ACTIVE = TRUE;SET @MIGRATION_1651832316_IS_ACTIVE = TRUE;SET @MIGRATION_1653039072_IS_ACTIVE = TRUE;SET @MIGRATION_1658231030_IS_ACTIVE = TRUE;SET @MIGRATION_1663150051_IS_ACTIVE = TRUE;SET @MIGRATION_1665742302_IS_ACTIVE = TRUE;SET @MIGRATION_1607509138_IS_ACTIVE = TRUE;SET @MIGRATION_1621417443_IS_ACTIVE = TRUE;SET @MIGRATION_1629818108_IS_ACTIVE = TRUE;SET @MIGRATION_1557055670_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1642784245_IS_ACTIVE = TRUE;SET @MIGRATION_1645626265_IS_ACTIVE = TRUE;SET @MIGRATION_1645646886_IS_ACTIVE = TRUE;SET @MIGRATION_1645646961_IS_ACTIVE = TRUE;SET @MIGRATION_1589963718_IS_ACTIVE = TRUE;SET @MIGRATION_1619069101_IS_ACTIVE = TRUE;SET @MIGRATION_1623656945_IS_ACTIVE = TRUE;SET @MIGRATION_1623820553_IS_ACTIVE = TRUE;SET @MIGRATION_1624275180_IS_ACTIVE = TRUE;SET @MIGRATION_1633436214_IS_ACTIVE = TRUE;SET @MIGRATION_1570840015_IS_ACTIVE = TRUE;SET @MIGRATION_1580400794_IS_ACTIVE = TRUE;SET @MIGRATION_1580401225_IS_ACTIVE = TRUE;SET @MIGRATION_1615889159_IS_ACTIVE = TRUE;SET @MIGRATION_1661505236_IS_ACTIVE = TRUE;SET @MIGRATION_1665435663_IS_ACTIVE = TRUE;SET @MIGRATION_1666859263_IS_ACTIVE = TRUE;SET @MIGRATION_1673945260_IS_ACTIVE = TRUE;SET @MIGRATION_1687242751_IS_ACTIVE = TRUE;SET @MIGRATION_1691081373_IS_ACTIVE = TRUE;SET @MIGRATION_1664344197_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 = 'SWIAYWXGDWVSAHC4R1ZDUGZKVW';

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` = 0xE9E2281DB4354B5FB6AE73E9A9D23CDC
        ;

SELECT 
  admin 
FROM 
  `integration` 
WHERE 
  id = : id

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

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 = 0xE9E2281DB4354B5FB6AE73E9A9D23CDC;

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`, 
  `product`.`product_manufacturer_id` as `product.manufacturerId`, 
  `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, 
  `product`.`unit_id` as `product.unitId`, 
  `product`.`tax_id` as `product.taxId`, 
  `product`.`product_media_id` as `product.coverId`, 
  `product`.`product_media_version_id` as `product.productMediaVersionId`, 
  `product`.`delivery_time_id` as `product.deliveryTimeId`, 
  `product`.`product_feature_set_id` as `product.featureSetId`, 
  `product`.`canonical_product_id` as `product.canonicalProductId`, 
  `product`.`cms_page_id` as `product.cmsPageId`, 
  `product`.`cms_page_version_id` as `product.cmsPageVersionId`, 
  `product`.`price` as `product.price`, 
  `product`.`product_number` as `product.productNumber`, 
  `product`.`stock` as `product.stock`, 
  `product`.`restock_time` as `product.restockTime`, 
  `product`.`auto_increment` as `product.autoIncrement`, 
  `product`.`active` as `product.active`, 
  `product`.`available_stock` as `product.availableStock`, 
  `product`.`available` as `product.available`, 
  `product`.`is_closeout` as `product.isCloseout`, 
  `product`.`display_group` as `product.displayGroup`, 
  `product`.`configurator_group_config` as `product.configuratorGroupConfig`, 
  `product`.`main_variant_id` as `product.mainVariantId`, 
  `product`.`display_parent` as `product.displayParent`, 
  `product`.`variant_listing_config` as `product.variantListingConfig`, 
  `product`.`variant_restrictions` as `product.variantRestrictions`, 
  `product`.`manufacturer_number` as `product.manufacturerNumber`, 
  `product`.`ean` as `product.ean`, 
  `product`.`purchase_steps` as `product.purchaseSteps`, 
  `product`.`max_purchase` as `product.maxPurchase`, 
  `product`.`min_purchase` as `product.minPurchase`, 
  `product`.`purchase_unit` as `product.purchaseUnit`, 
  `product`.`reference_unit` as `product.referenceUnit`, 
  `product`.`shipping_free` as `product.shippingFree`, 
  `product`.`purchase_prices` as `product.purchasePrices`, 
  `product`.`mark_as_topseller` as `product.markAsTopseller`, 
  `product`.`weight` as `product.weight`, 
  `product`.`width` as `product.width`, 
  `product`.`height` as `product.height`, 
  `product`.`length` as `product.length`, 
  `product`.`release_date` as `product.releaseDate`, 
  `product`.`rating_average` as `product.ratingAverage`, 
  `product`.`category_tree` as `product.categoryTree`, 
  `product`.`property_ids` as `product.propertyIds`, 
  `product`.`option_ids` as `product.optionIds`, 
  `product`.`stream_ids` as `product.streamIds`, 
  `product`.`tag_ids` as `product.tagIds`, 
  `product`.`category_ids` as `product.categoryIds`, 
  `product`.`child_count` as `product.childCount`, 
  `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, 
  `product`.`sales` as `product.sales`, 
  `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`.`cheapest_price` as `product.cheapestPrice`, 
  `product`.`created_at` as `product.createdAt`, 
  `product`.`updated_at` as `product.updatedAt`, 
  `product.productoptionsSettings`.`id` as `product.productoptionsSettings.id`, 
  `product.productoptionsSettings`.`version_id` as `product.productoptionsSettings.versionId`, 
  `product.productoptionsSettings`.`product_id` as `product.productoptionsSettings.productId`, 
  `product.productoptionsSettings`.`product_version_id` as `product.productoptionsSettings.productVersionId`, 
  `product.productoptionsSettings`.`has_options` as `product.productoptionsSettings.hasOptions`, 
  `product.productoptionsSettings`.`custom_view` as `product.productoptionsSettings.customView`, 
  `product.productoptionsSettings`.`inherited` as `product.productoptionsSettings.inherited`, 
  `product.productoptionsSettings`.`created_at` as `product.productoptionsSettings.createdAt`, 
  `product.productoptionsSettings`.`updated_at` as `product.productoptionsSettings.updatedAt`, 
  `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`.`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.translation.metaDescription`, 
  COALESCE(
    `product.translation.metaDescription`, 
    `product.translation.metaDescription`
  ) as `product.metaDescription`, 
  `product.translation.name`, 
  COALESCE(
    `product.translation.name`, `product.translation.name`
  ) as `product.name`, 
  `product.translation.keywords`, 
  COALESCE(
    `product.translation.keywords`, 
    `product.translation.keywords`
  ) as `product.keywords`, 
  `product.translation.description`, 
  COALESCE(
    `product.translation.description`, 
    `product.translation.description`
  ) as `product.description`, 
  `product.translation.metaTitle`, 
  COALESCE(
    `product.translation.metaTitle`, 
    `product.translation.metaTitle`
  ) as `product.metaTitle`, 
  `product.translation.packUnit`, 
  COALESCE(
    `product.translation.packUnit`, 
    `product.translation.packUnit`
  ) as `product.packUnit`, 
  `product.translation.packUnitPlural`, 
  COALESCE(
    `product.translation.packUnitPlural`, 
    `product.translation.packUnitPlural`
  ) as `product.packUnitPlural`, 
  `product.translation.customSearchKeywords`, 
  COALESCE(
    `product.translation.customSearchKeywords`, 
    `product.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`, 
  `product.translation.slotConfig`, 
  COALESCE(
    `product.translation.slotConfig`, 
    `product.translation.slotConfig`
  ) as `product.slotConfig`, 
  `product.translation.customFields`, 
  COALESCE(
    `product.translation.customFields`, 
    `product.translation.customFields`
  ) as `product.customFields`, 
  `product.translation.createdAt`, 
  `product.translation.updatedAt`, 
  `product.translation.productId`, 
  `product.translation.languageId`, 
  `product.translation.productVersionId` 
FROM 
  `product` 
  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 = : languageId
  ) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` 
  AND `product.product_translation`.product_version_id = `product`.version_id 
  LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` 
  LEFT JOIN `swp_product_options_product_extension` `product.productoptionsSettings` ON `product`.`id` = `product.productoptionsSettings`.`product_id` 
  AND `product`.`version_id` = `product.productoptionsSettings`.`version_id` 
  LEFT JOIN `product_media` `product.cover` ON `product`.`product_media_id` = `product.cover`.`id` 
  AND `product`.`version_id` = `product.cover`.`version_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 = : languageId
  ) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` 
WHERE 
  (
    `product`.`version_id` = : version
  ) 
  AND (
    `product`.`id` IN (: ids)
  )

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`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`configurator_group_config` as `product.configuratorGroupConfig`, `product`.`main_variant_id` as `product.mainVariantId`, `product`.`display_parent` as `product.displayParent`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `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`.`cheapest_price` as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.productoptionsSettings`.`id` as `product.productoptionsSettings.id`, `product.productoptionsSettings`.`version_id` as `product.productoptionsSettings.versionId`, `product.productoptionsSettings`.`product_id` as `product.productoptionsSettings.productId`, `product.productoptionsSettings`.`product_version_id` as `product.productoptionsSettings.productVersionId`, `product.productoptionsSettings`.`has_options` as `product.productoptionsSettings.hasOptions`, `product.productoptionsSettings`.`custom_view` as `product.productoptionsSettings.customView`, `product.productoptionsSettings`.`inherited` as `product.productoptionsSettings.inherited`, `product.productoptionsSettings`.`created_at` as `product.productoptionsSettings.createdAt`, `product.productoptionsSettings`.`updated_at` as `product.productoptionsSettings.updatedAt`, `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`.`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.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` 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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` LEFT JOIN `swp_product_options_product_extension` `product.productoptionsSettings` ON `product`.`id` = `product.productoptionsSettings`.`product_id` AND `product`.`version_id` = `product.productoptionsSettings`.`version_id` LEFT JOIN `product_media` `product.cover` ON `product`.`product_media_id` = `product.cover`.`id` AND `product`.`version_id` = `product.cover`.`version_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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0xE9CBB0D3020E46C4B3B4A99F0F23E13D));

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

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

SELECT 
  `product_price`.`id` as `product_price.id`, 
  `product_price`.`version_id` as `product_price.versionId`, 
  `product_price`.`product_id` as `product_price.productId`, 
  `product_price`.`product_version_id` as `product_price.productVersionId`, 
  `product_price`.`rule_id` as `product_price.ruleId`, 
  `product_price`.`price` as `product_price.price`, 
  `product_price`.`quantity_start` as `product_price.quantityStart`, 
  `product_price`.`quantity_end` as `product_price.quantityEnd`, 
  `product_price`.`custom_fields` as `product_price.customFields`, 
  `product_price`.`created_at` as `product_price.createdAt`, 
  `product_price`.`updated_at` as `product_price.updatedAt` 
FROM 
  `product_price` 
WHERE 
  (
    `product_price`.`version_id` = : version
  ) 
  AND (
    (
      `product_price`.`product_id` IN (
        : param_3bb3c8cad21f424dac8e20f485d4055b
      )
    )
  )

SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id` IN (0xE9CBB0D3020E46C4B3B4A99F0F23E13D)));

SELECT 
  `seo_url`.`id` as `seo_url.id`, 
  `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, 
  `seo_url`.`language_id` as `seo_url.languageId`, 
  `seo_url`.`foreign_key` as `seo_url.foreignKey`, 
  `seo_url`.`route_name` as `seo_url.routeName`, 
  `seo_url`.`path_info` as `seo_url.pathInfo`, 
  `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, 
  `seo_url`.`is_canonical` as `seo_url.isCanonical`, 
  `seo_url`.`is_modified` as `seo_url.isModified`, 
  `seo_url`.`is_deleted` as `seo_url.isDeleted`, 
  `seo_url`.`custom_fields` as `seo_url.customFields`, 
  `seo_url`.`created_at` as `seo_url.createdAt`, 
  `seo_url`.`updated_at` as `seo_url.updatedAt` 
FROM 
  `seo_url` 
WHERE 
  (
    `seo_url`.`foreign_key` IN (
      : param_566db32e91234b9fa1964da1f53529c4
    )
  )

SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`foreign_key` IN (0xE9CBB0D3020E46C4B3B4A99F0F23E13D));

SELECT 
  `swp_product_options_product_to_options`.`id` as `swp_product_options_product_to_options.id`, 
  `swp_product_options_product_to_options`.`version_id` as `swp_product_options_product_to_options.versionId`, 
  `swp_product_options_product_to_options`.`swp_product_options_sets_groups_id` as `swp_product_options_product_to_options.swpProductOptionsSetsGroupsId`, 
  `swp_product_options_product_to_options`.`swp_product_options_groups_options_id` as `swp_product_options_product_to_options.swpProductOptionsGroupsOptionsId`, 
  `swp_product_options_product_to_options`.`product_id` as `swp_product_options_product_to_options.productId`, 
  `swp_product_options_product_to_options`.`product_version_id` as `swp_product_options_product_to_options.productVersionId`, 
  `swp_product_options_product_to_options`.`overwrite` as `swp_product_options_product_to_options.overwrite`, 
  `swp_product_options_product_to_options`.`created_at` as `swp_product_options_product_to_options.createdAt`, 
  `swp_product_options_product_to_options`.`updated_at` as `swp_product_options_product_to_options.updatedAt`, 
  `swp_product_options_product_to_options.option`.`id` as `swp_product_options_product_to_options.option.id`, 
  `swp_product_options_product_to_options.option`.`version_id` as `swp_product_options_product_to_options.option.versionId`, 
  `swp_product_options_product_to_options.option`.`position` as `swp_product_options_product_to_options.option.position`, 
  `swp_product_options_product_to_options.option`.`preselection` as `swp_product_options_product_to_options.option.preselection`, 
  `swp_product_options_product_to_options.option`.`swp_product_options_groups_id` as `swp_product_options_product_to_options.option.swpProductOptionsGroupsId`, 
  `swp_product_options_product_to_options.option`.`swp_product_options_options_id` as `swp_product_options_product_to_options.option.swpProductOptionsOptionsId`, 
  `swp_product_options_product_to_options.option`.`swp_product_options_groups_version_id` as `swp_product_options_product_to_options.option.swpProductOptionsGroupsVersionId`, 
  `swp_product_options_product_to_options.option`.`created_at` as `swp_product_options_product_to_options.option.createdAt`, 
  `swp_product_options_product_to_options.option`.`updated_at` as `swp_product_options_product_to_options.option.updatedAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`id` as `swp_product_options_product_to_options.option.productoptionsoption.id`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`version_id` as `swp_product_options_product_to_options.option.productoptionsoption.versionId`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`int_identifier` as `swp_product_options_product_to_options.option.productoptionsoption.intIdentifier`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`tax_id` as `swp_product_options_product_to_options.option.productoptionsoption.taxId`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`operator` as `swp_product_options_product_to_options.option.productoptionsoption.operator`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`price` as `swp_product_options_product_to_options.option.productoptionsoption.price`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`ordernumber` as `swp_product_options_product_to_options.option.productoptionsoption.ordernumber`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`calculationart` as `swp_product_options_product_to_options.option.productoptionsoption.calculationart`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`use_percentprice` as `swp_product_options_product_to_options.option.productoptionsoption.usePercentprice`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`use_articleprice` as `swp_product_options_product_to_options.option.productoptionsoption.useArticleprice`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`assignedproducts_count` as `swp_product_options_product_to_options.option.productoptionsoption.assignedproductsCount`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`calculation` as `swp_product_options_product_to_options.option.productoptionsoption.calculation`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`text_singlechar` as `swp_product_options_product_to_options.option.productoptionsoption.textSinglechar`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`text_regex` as `swp_product_options_product_to_options.option.productoptionsoption.textRegex`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`active` as `swp_product_options_product_to_options.option.productoptionsoption.active`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`property_group_ids` as `swp_product_options_product_to_options.option.productoptionsoption.propertyGroupIds`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`property_ids` as `swp_product_options_product_to_options.option.productoptionsoption.propertyIds`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`id` as `swp_product_options_product_to_options.option.productoptionsoption.tax.id`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`tax_rate` as `swp_product_options_product_to_options.option.productoptionsoption.tax.taxRate`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`name` as `swp_product_options_product_to_options.option.productoptionsoption.tax.name`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`position` as `swp_product_options_product_to_options.option.productoptionsoption.tax.position`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`custom_fields` as `swp_product_options_product_to_options.option.productoptionsoption.tax.customFields`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`created_at` as `swp_product_options_product_to_options.option.productoptionsoption.tax.createdAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption.tax`.`updated_at` as `swp_product_options_product_to_options.option.productoptionsoption.tax.updatedAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`swp_product_options_options_media_id` as `swp_product_options_product_to_options.option.productoptionsoption.coverId`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`swp_product_options_options_media_version_id` as `swp_product_options_product_to_options.option.productoptionsoption.swpProductOptionsOptionsMediaVersionId`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`created_at` as `swp_product_options_product_to_options.option.productoptionsoption.createdAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption`.`updated_at` as `swp_product_options_product_to_options.option.productoptionsoption.updatedAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.name`, 
  COALESCE(
    `swp_product_options_product_to_options.option.productoptionsoption.translation.name`, 
    `swp_product_options_product_to_options.option.productoptionsoption.translation.name`
  ) as `swp_product_options_product_to_options.option.productoptionsoption.name`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.shortDescription`, 
  COALESCE(
    `swp_product_options_product_to_options.option.productoptionsoption.translation.shortDescription`, 
    `swp_product_options_product_to_options.option.productoptionsoption.translation.shortDescription`
  ) as `swp_product_options_product_to_options.option.productoptionsoption.shortDescription`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.longDescription`, 
  COALESCE(
    `swp_product_options_product_to_options.option.productoptionsoption.translation.longDescription`, 
    `swp_product_options_product_to_options.option.productoptionsoption.translation.longDescription`
  ) as `swp_product_options_product_to_options.option.productoptionsoption.longDescription`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.createdAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.updatedAt`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.swpProductOptionsOptionsId`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.languageId`, 
  `swp_product_options_product_to_options.option.productoptionsoption.translation.swpProductOptionsOptionsVersionId` 
FROM 
  `swp_product_options_product_to_options` 
  LEFT JOIN `swp_product_options_groups_options` `swp_product_options_product_to_options.option` ON `swp_product_options_product_to_options`.`swp_product_options_groups_options_id` = `swp_product_options_product_to_options.option`.`id` 
  AND `swp_product_options_product_to_options`.`version_id` = `swp_product_options_product_to_options.option`.`version_id` 
  LEFT JOIN `swp_product_options_options` `swp_product_options_product_to_options.option.productoptionsoption` ON `swp_product_options_product_to_options.option`.`swp_product_options_options_id` = `swp_product_options_product_to_options.option.productoptionsoption`.`id` 
  AND `swp_product_options_product_to_options.option`.`version_id` = `swp_product_options_product_to_options.option.productoptionsoption`.`version_id` 
  LEFT JOIN `tax` `swp_product_options_product_to_options.option.productoptionsoption.tax` ON `swp_product_options_product_to_options.option.productoptionsoption`.`tax_id` = `swp_product_options_product_to_options.option.productoptionsoption.tax`.`id` 
  LEFT JOIN (
    SELECT 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.swp_product_options_options_id, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.swp_product_options_options_version_id, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.name as `swp_product_options_product_to_options.option.productoptionsoption.translation.name`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.short_description as `swp_product_options_product_to_options.option.productoptionsoption.translation.shortDescription`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.long_description as `swp_product_options_product_to_options.option.productoptionsoption.translation.longDescription`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.created_at as `swp_product_options_product_to_options.option.productoptionsoption.translation.createdAt`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.updated_at as `swp_product_options_product_to_options.option.productoptionsoption.translation.updatedAt`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.swp_product_options_options_id as `swp_product_options_product_to_options.option.productoptionsoption.translation.swpProductOptionsOptionsId`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.language_id as `swp_product_options_product_to_options.option.productoptionsoption.translation.languageId`, 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.swp_product_options_options_version_id as `swp_product_options_product_to_options.option.productoptionsoption.translation.swpProductOptionsOptionsVersionId` 
    FROM 
      `swp_product_options_options_translation` `swp_product_options_product_to_options.option.productoptionsoption.translation` 
    WHERE 
      `swp_product_options_product_to_options.option.productoptionsoption.translation`.language_id = : languageId
  ) `swp_product_options_product_to_options.option.productoptionsoption.swp_product_options_options_translation` ON `swp_product_options_product_to_options.option.productoptionsoption.swp_product_options_options_translation`.`swp_product_options_options_id` = `swp_product_options_product_to_options.option.productoptionsoption`.`id` 
  AND `swp_product_options_product_to_options.option.productoptionsoption.swp_product_options_options_translation`.swp_product_options_options_version_id = `swp_product_options_product_to_options.option.productoptionsoption`.version_id 
WHERE 
  (
    `swp_product_options_product_to_options`.`version_id` = : version
  ) 
  AND (
    (
      `swp_product_options_product_to_options`.`product_id` IN (
        : param_036c3aa5fe584332a2dcf1ca0ccf868f
      )
    )
  )