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_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346375_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607423732_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616412445_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616413078_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622039002_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629280389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642507826_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1685001455_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346371_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606378923_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607952506_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608034991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612945522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620808652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631192197_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346406_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346406_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346408_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346409_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681820337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1756113098_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1558500331_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615911875_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646211291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667812857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874110_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874120_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889217_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889230_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889270_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593762780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594368835_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595512263_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599142075_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632494010_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633079483_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647342007_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647342008_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657031888_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677657367_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677657400_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594718000_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_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_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346374_IS_ACTIVE = TRUE;SET @MIGRATION_1607346375_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;SET @MIGRATION_1685001455_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1607346371_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346374_IS_ACTIVE = TRUE;SET @MIGRATION_1607346405_IS_ACTIVE = TRUE;SET @MIGRATION_1607346405_IS_ACTIVE = TRUE;SET @MIGRATION_1607346406_IS_ACTIVE = TRUE;SET @MIGRATION_1607346406_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346408_IS_ACTIVE = TRUE;SET @MIGRATION_1607346409_IS_ACTIVE = TRUE;SET @MIGRATION_1607346410_IS_ACTIVE = TRUE;SET @MIGRATION_1681820337_IS_ACTIVE = TRUE;SET @MIGRATION_1756113098_IS_ACTIVE = TRUE;SET @MIGRATION_1558500331_IS_ACTIVE = TRUE;SET @MIGRATION_1615911875_IS_ACTIVE = TRUE;SET @MIGRATION_1646211291_IS_ACTIVE = TRUE;SET @MIGRATION_1667812857_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874110_IS_ACTIVE = TRUE;SET @MIGRATION_1589874120_IS_ACTIVE = TRUE;SET @MIGRATION_1589889217_IS_ACTIVE = TRUE;SET @MIGRATION_1589889230_IS_ACTIVE = TRUE;SET @MIGRATION_1589889270_IS_ACTIVE = TRUE;SET @MIGRATION_1593762780_IS_ACTIVE = TRUE;SET @MIGRATION_1594368835_IS_ACTIVE = TRUE;SET @MIGRATION_1595512263_IS_ACTIVE = TRUE;SET @MIGRATION_1599142075_IS_ACTIVE = TRUE;SET @MIGRATION_1632494010_IS_ACTIVE = TRUE;SET @MIGRATION_1633079483_IS_ACTIVE = TRUE;SET @MIGRATION_1647342007_IS_ACTIVE = TRUE;SET @MIGRATION_1647342008_IS_ACTIVE = TRUE;SET @MIGRATION_1657031888_IS_ACTIVE = TRUE;SET @MIGRATION_1677657367_IS_ACTIVE = TRUE;SET @MIGRATION_1677657400_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1594718000_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;

# seo-url::resolve
SELECT 
  id, 
  path_info pathInfo, 
  is_canonical isCanonical 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    (
      sales_channel_id = : sales_channel_id 
      OR sales_channel_id IS NULL
    )
  ) 
  AND (seo_path_info = : seoPath) 
ORDER BY 
  seo_path_info ASC, 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0xD50D5A7A796A43E3BC377A553DF74D6B) AND ((sales_channel_id = 0x41E5AC0A0BCA4DA69BCDC0308221EAE2 OR sales_channel_id IS NULL)) AND (seo_path_info = 'account/register') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  path_info pathInfo, 
  seo_path_info seoPathInfo 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    sales_channel_id = : sales_channel_id
  ) 
  AND (id != : id) 
  AND (path_info = : pathInfo) 
  AND (is_canonical = 1) 
LIMIT 
  1

SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0xD50D5A7A796A43E3BC377A553DF74D6B) AND (sales_channel_id = 0x41E5AC0A0BCA4DA69BCDC0308221EAE2) AND (id != '') AND (path_info = '/account/register') AND (is_canonical = 1) LIMIT 1;

SELECT 
  `id`, 
  `old_url`, 
  `new_url`, 
  `old_url_regex`, 
  `search_url_by`, 
  `temporary`, 
  : url0 REGEXP `old_url_regex` as regex0, 
  : url2 REGEXP `old_url_regex` as regex2, 
  : url3 REGEXP `old_url_regex` as regex3 
FROM 
  `acris_seo_redirect` 
WHERE 
  `active` = : active 
  AND (
    (
      NOT (
        `search_url_by` = : searchByUrlRegex
      ) 
      AND (
        (
          `old_url` = : url0 
          OR `old_url` = : url2 
          OR `old_url` = : url3
        )
      )
    ) 
    OR (
      `search_url_by` = : searchByUrlRegex 
      AND (
        (
          : url0 REGEXP `old_url_regex` 
          OR : url2 REGEXP `old_url_regex` 
          OR : url3 REGEXP `old_url_regex`
        )
      )
    )
  ) 
LIMIT 
  6;

SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, '/account/register' REGEXP `old_url_regex` as regex0, 'https://dvdw.generationshop.dev/account/register' REGEXP `old_url_regex` as regex2, 'dvdw.generationshop.dev/account/register' REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex') AND ((`old_url` = '/account/register' OR `old_url` = 'https://dvdw.generationshop.dev/account/register' OR `old_url` = 'dvdw.generationshop.dev/account/register'))) OR (`search_url_by` = 'regex' AND (('/account/register' REGEXP `old_url_regex` OR 'https://dvdw.generationshop.dev/account/register' REGEXP `old_url_regex` OR 'dvdw.generationshop.dev/account/register' REGEXP `old_url_regex`)))) LIMIT 6;;

SELECT 
  * 
FROM 
  sales_channel_api_context 
WHERE 
  (sales_channel_id IS NULL) 
  AND (token = : token) 
LIMIT 
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id IS NULL) AND (token = 'JRkOg9dIqG3D4zNUTGDHwN8sQ27UPWOB') LIMIT 1;

SELECT 
  `dvdw_event`.`id` 
FROM 
  `dvdw_event` 
WHERE 
  (
    (
      `dvdw_event`.`end_date` >= : param_a65b644c1d90487eb95c1d54f1cc58e7
    ) 
    AND (
      JSON_CONTAINS(
        `dvdw_event`.`sales_channel_ids`, 
        JSON_ARRAY(
          : param_b411980aea1e46288dd4a7cf0a5773f9
        )
      )
    )
  ) 
ORDER BY 
  `dvdw_event`.`end_date` ASC 
LIMIT 
  1

SELECT `dvdw_event`.`id` FROM `dvdw_event` WHERE ((`dvdw_event`.`end_date` >= '2025-09-16 11:13:57.079') AND (JSON_CONTAINS(`dvdw_event`.`sales_channel_ids`, JSON_ARRAY('41e5ac0a0bca4da69bcdc0308221eae2')))) ORDER BY `dvdw_event`.`end_date` ASC LIMIT 1;

SELECT 
  `dvdw_event`.`id` as `dvdw_event.id`, 
  `dvdw_event`.`price` as `dvdw_event.price`, 
  `dvdw_event`.`start_date_promo_show` as `dvdw_event.startDatePromoShow`, 
  `dvdw_event`.`start_date_promo_use` as `dvdw_event.startDatePromoUse`, 
  `dvdw_event`.`start_date_promo_end` as `dvdw_event.startDatePromoEnd`, 
  `dvdw_event`.`end_date` as `dvdw_event.endDate`, 
  `dvdw_event`.`sales_channel_ids` as `dvdw_event.salesChannelIds`, 
  `dvdw_event`.`cover_id` as `dvdw_event.coverId`, 
  `dvdw_event`.`media_id` as `dvdw_event.mediaId`, 
  `dvdw_event`.`video_id` as `dvdw_event.videoId`, 
  `dvdw_event`.`created_at` as `dvdw_event.createdAt`, 
  `dvdw_event`.`updated_at` as `dvdw_event.updatedAt`, 
  `dvdw_event.translation.fallback_1.title`, 
  `dvdw_event.translation.title`, 
  COALESCE(
    `dvdw_event.translation.fallback_1.title`, 
    `dvdw_event.translation.title`, 
    `dvdw_event.translation.title`
  ) as `dvdw_event.title`, 
  `dvdw_event.translation.fallback_1.description`, 
  `dvdw_event.translation.description`, 
  COALESCE(
    `dvdw_event.translation.fallback_1.description`, 
    `dvdw_event.translation.description`, 
    `dvdw_event.translation.description`
  ) as `dvdw_event.description`, 
  `dvdw_event.translation.fallback_1.content`, 
  `dvdw_event.translation.content`, 
  COALESCE(
    `dvdw_event.translation.fallback_1.content`, 
    `dvdw_event.translation.content`, 
    `dvdw_event.translation.content`
  ) as `dvdw_event.content`, 
  `dvdw_event.translation.fallback_1.deadlineContent`, 
  `dvdw_event.translation.deadlineContent`, 
  COALESCE(
    `dvdw_event.translation.fallback_1.deadlineContent`, 
    `dvdw_event.translation.deadlineContent`, 
    `dvdw_event.translation.deadlineContent`
  ) as `dvdw_event.deadlineContent`, 
  `dvdw_event.translation.fallback_1.createdAt`, 
  `dvdw_event.translation.createdAt`, 
  `dvdw_event.translation.fallback_1.updatedAt`, 
  `dvdw_event.translation.updatedAt`, 
  `dvdw_event.translation.fallback_1.dvdwEventId`, 
  `dvdw_event.translation.dvdwEventId`, 
  `dvdw_event.translation.fallback_1.languageId`, 
  `dvdw_event.translation.languageId` 
FROM 
  `dvdw_event` 
  LEFT JOIN (
    SELECT 
      `dvdw_event.translation`.dvdw_event_id, 
      `dvdw_event.translation`.title as `dvdw_event.translation.title`, 
      `dvdw_event.translation`.description as `dvdw_event.translation.description`, 
      `dvdw_event.translation`.content as `dvdw_event.translation.content`, 
      `dvdw_event.translation`.deadline_content as `dvdw_event.translation.deadlineContent`, 
      `dvdw_event.translation`.created_at as `dvdw_event.translation.createdAt`, 
      `dvdw_event.translation`.updated_at as `dvdw_event.translation.updatedAt`, 
      `dvdw_event.translation`.dvdw_event_id as `dvdw_event.translation.dvdwEventId`, 
      `dvdw_event.translation`.language_id as `dvdw_event.translation.languageId`, 
      `dvdw_event.translation.fallback_1`.title as `dvdw_event.translation.fallback_1.title`, 
      `dvdw_event.translation.fallback_1`.description as `dvdw_event.translation.fallback_1.description`, 
      `dvdw_event.translation.fallback_1`.content as `dvdw_event.translation.fallback_1.content`, 
      `dvdw_event.translation.fallback_1`.deadline_content as `dvdw_event.translation.fallback_1.deadlineContent`, 
      `dvdw_event.translation.fallback_1`.created_at as `dvdw_event.translation.fallback_1.createdAt`, 
      `dvdw_event.translation.fallback_1`.updated_at as `dvdw_event.translation.fallback_1.updatedAt`, 
      `dvdw_event.translation.fallback_1`.dvdw_event_id as `dvdw_event.translation.fallback_1.dvdwEventId`, 
      `dvdw_event.translation.fallback_1`.language_id as `dvdw_event.translation.fallback_1.languageId` 
    FROM 
      `dvdw_event_translation` `dvdw_event.translation` 
      LEFT JOIN `dvdw_event_translation` `dvdw_event.translation.fallback_1` ON `dvdw_event.translation`.`dvdw_event_id` = `dvdw_event.translation.fallback_1`.`dvdw_event_id` 
      AND `dvdw_event.translation.fallback_1`.language_id = : languageId1 
    WHERE 
      `dvdw_event.translation`.language_id = : languageId
  ) `dvdw_event.dvdw_event_translation` ON `dvdw_event.dvdw_event_translation`.`dvdw_event_id` = `dvdw_event`.`id` 
WHERE 
  `dvdw_event`.`id` IN (: ids)

SELECT `dvdw_event`.`id` as `dvdw_event.id`, `dvdw_event`.`price` as `dvdw_event.price`, `dvdw_event`.`start_date_promo_show` as `dvdw_event.startDatePromoShow`, `dvdw_event`.`start_date_promo_use` as `dvdw_event.startDatePromoUse`, `dvdw_event`.`start_date_promo_end` as `dvdw_event.startDatePromoEnd`, `dvdw_event`.`end_date` as `dvdw_event.endDate`, `dvdw_event`.`sales_channel_ids` as `dvdw_event.salesChannelIds`, `dvdw_event`.`cover_id` as `dvdw_event.coverId`, `dvdw_event`.`media_id` as `dvdw_event.mediaId`, `dvdw_event`.`video_id` as `dvdw_event.videoId`, `dvdw_event`.`created_at` as `dvdw_event.createdAt`, `dvdw_event`.`updated_at` as `dvdw_event.updatedAt`, `dvdw_event.translation.fallback_1.title`, `dvdw_event.translation.title`, COALESCE(`dvdw_event.translation.fallback_1.title`,`dvdw_event.translation.title`,`dvdw_event.translation.title`) as `dvdw_event.title`, `dvdw_event.translation.fallback_1.description`, `dvdw_event.translation.description`, COALESCE(`dvdw_event.translation.fallback_1.description`,`dvdw_event.translation.description`,`dvdw_event.translation.description`) as `dvdw_event.description`, `dvdw_event.translation.fallback_1.content`, `dvdw_event.translation.content`, COALESCE(`dvdw_event.translation.fallback_1.content`,`dvdw_event.translation.content`,`dvdw_event.translation.content`) as `dvdw_event.content`, `dvdw_event.translation.fallback_1.deadlineContent`, `dvdw_event.translation.deadlineContent`, COALESCE(`dvdw_event.translation.fallback_1.deadlineContent`,`dvdw_event.translation.deadlineContent`,`dvdw_event.translation.deadlineContent`) as `dvdw_event.deadlineContent`, `dvdw_event.translation.fallback_1.createdAt`, `dvdw_event.translation.createdAt`, `dvdw_event.translation.fallback_1.updatedAt`, `dvdw_event.translation.updatedAt`, `dvdw_event.translation.fallback_1.dvdwEventId`, `dvdw_event.translation.dvdwEventId`, `dvdw_event.translation.fallback_1.languageId`, `dvdw_event.translation.languageId` FROM `dvdw_event` LEFT JOIN (SELECT `dvdw_event.translation`.dvdw_event_id, `dvdw_event.translation`.title as `dvdw_event.translation.title`, `dvdw_event.translation`.description as `dvdw_event.translation.description`, `dvdw_event.translation`.content as `dvdw_event.translation.content`, `dvdw_event.translation`.deadline_content as `dvdw_event.translation.deadlineContent`, `dvdw_event.translation`.created_at as `dvdw_event.translation.createdAt`, `dvdw_event.translation`.updated_at as `dvdw_event.translation.updatedAt`, `dvdw_event.translation`.dvdw_event_id as `dvdw_event.translation.dvdwEventId`, `dvdw_event.translation`.language_id as `dvdw_event.translation.languageId`, `dvdw_event.translation.fallback_1`.title as `dvdw_event.translation.fallback_1.title`, `dvdw_event.translation.fallback_1`.description as `dvdw_event.translation.fallback_1.description`, `dvdw_event.translation.fallback_1`.content as `dvdw_event.translation.fallback_1.content`, `dvdw_event.translation.fallback_1`.deadline_content as `dvdw_event.translation.fallback_1.deadlineContent`, `dvdw_event.translation.fallback_1`.created_at as `dvdw_event.translation.fallback_1.createdAt`, `dvdw_event.translation.fallback_1`.updated_at as `dvdw_event.translation.fallback_1.updatedAt`, `dvdw_event.translation.fallback_1`.dvdw_event_id as `dvdw_event.translation.fallback_1.dvdwEventId`, `dvdw_event.translation.fallback_1`.language_id as `dvdw_event.translation.fallback_1.languageId` FROM `dvdw_event_translation` `dvdw_event.translation` LEFT JOIN `dvdw_event_translation` `dvdw_event.translation.fallback_1` ON `dvdw_event.translation`.`dvdw_event_id` = `dvdw_event.translation.fallback_1`.`dvdw_event_id` AND `dvdw_event.translation.fallback_1`.language_id = 0xD50D5A7A796A43E3BC377A553DF74D6B WHERE `dvdw_event.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `dvdw_event.dvdw_event_translation` ON `dvdw_event.dvdw_event_translation`.`dvdw_event_id` = `dvdw_event`.`id` WHERE `dvdw_event`.`id` IN (0x1A0C27D0FF5B480EB49C557CEE8D2B2C);

SELECT 
  `dvdw_participation`.`id` as `dvdw_participation.id`, 
  `dvdw_participation`.`order_line_item_id` as `dvdw_participation.orderLineItemId`, 
  `dvdw_participation`.`order_line_item_version_id` as `dvdw_participation.orderLineItemVersionId`, 
  `dvdw_participation`.`product_id` as `dvdw_participation.productId`, 
  `dvdw_participation`.`product_version_id` as `dvdw_participation.productVersionId`, 
  `dvdw_participation`.`dvdw_event_id` as `dvdw_participation.dvdwEventId`, 
  `dvdw_participation`.`dvdw_promotion_id` as `dvdw_participation.dvdwPromotionId`, 
  `dvdw_participation`.`created_at` as `dvdw_participation.createdAt`, 
  `dvdw_participation`.`updated_at` as `dvdw_participation.updatedAt` 
FROM 
  `dvdw_participation` 
WHERE 
  (
    `dvdw_participation`.`dvdw_event_id` IN (
      : param_f7c40cf925504d0b9789bba569d79a0a
    )
  )

SELECT `dvdw_participation`.`id` as `dvdw_participation.id`, `dvdw_participation`.`order_line_item_id` as `dvdw_participation.orderLineItemId`, `dvdw_participation`.`order_line_item_version_id` as `dvdw_participation.orderLineItemVersionId`, `dvdw_participation`.`product_id` as `dvdw_participation.productId`, `dvdw_participation`.`product_version_id` as `dvdw_participation.productVersionId`, `dvdw_participation`.`dvdw_event_id` as `dvdw_participation.dvdwEventId`, `dvdw_participation`.`dvdw_promotion_id` as `dvdw_participation.dvdwPromotionId`, `dvdw_participation`.`created_at` as `dvdw_participation.createdAt`, `dvdw_participation`.`updated_at` as `dvdw_participation.updatedAt` FROM `dvdw_participation` WHERE (`dvdw_participation`.`dvdw_event_id` IN (0x1A0C27D0FF5B480EB49C557CEE8D2B2C));

SHOW COLUMNS 
FROM 
  `cart` 
WHERE 
  `Field` LIKE : column

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

#cart-persister::load
SELECT 
  `cart`.`cart` as payload, 
  `cart`.`rule_ids`, 
  0 as `compressed` 
FROM 
  cart 
WHERE 
  `token` = : token

#cart-persister::load
                SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = 'JRkOg9dIqG3D4zNUTGDHwN8sQ27UPWOB';

# cart::promotion::search-ids
SELECT 
  `promotion`.`id` 
FROM 
  `promotion` 
  LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` 
WHERE 
  (
    (
      `promotion`.`active` = : param_5b55b05b2012450b95b88fcdf6d6b5a4 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_fd033104e03a45c3bc6cf9ebdcd0d5b3 
      AND (
        (
          `promotion`.`valid_from` <=> : param_df7a8dde0b4e48e6b98b6db1dc46bb67 
          AND `promotion`.`valid_until` <=> : param_a9d63468e1a9439bba886dfa4a8c6759
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_5b52cc9638b14551aef02b6ec5628bc3 
          AND (
            `promotion`.`valid_until` > : param_e1c600b8db074649b0705e2a7eb3bbb8
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_df2d61dc967a47c9aafb1f4e1cd25d62
          ) 
          AND `promotion`.`valid_until` <=> : param_51016a5c009143d18b359b7bd13dab3e
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_24a119facf3449aeb34fddf91e140c96
          ) 
          AND (
            `promotion`.`valid_until` > : param_928fbcf5f7e34ceaa918cfa40304438b
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_ab1cad2508114f27be6a02f564f65e2d
    )
  ) 
GROUP BY 
  `promotion`.`id` 
ORDER BY 
  MAX(`promotion`.`priority`) DESC

# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = 1 AND `promotion.salesChannels`.`sales_channel_id` = 0x41E5AC0A0BCA4DA69BCDC0308221EAE2 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2025-09-16 11:13:57')) OR ((`promotion`.`valid_from` <= '2025-09-16 11:13:57') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-09-16 11:13:57') AND (`promotion`.`valid_until` > '2025-09-16 11:13:57'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

# cart::shipping-methods::read
SELECT 
  `shipping_method`.`id` as `shipping_method.id`, 
  `shipping_method`.`active` as `shipping_method.active`, 
  `shipping_method`.`position` as `shipping_method.position`, 
  `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, 
  `shipping_method`.`media_id` as `shipping_method.mediaId`, 
  `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, 
  `shipping_method`.`tax_type` as `shipping_method.taxType`, 
  `shipping_method`.`tax_id` as `shipping_method.taxId`, 
  `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, 
  `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, 
  `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, 
  `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, 
  `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, 
  `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, 
  `shipping_method.deliveryTime.translation.fallback_1.name`, 
  `shipping_method.deliveryTime.translation.name`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.name`, 
    `shipping_method.deliveryTime.translation.name`, 
    `shipping_method.deliveryTime.translation.name`
  ) as `shipping_method.deliveryTime.name`, 
  `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
  `shipping_method.deliveryTime.translation.customFields`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`
  ) as `shipping_method.deliveryTime.customFields`, 
  `shipping_method.deliveryTime.translation.fallback_1.createdAt`, 
  `shipping_method.deliveryTime.translation.createdAt`, 
  `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, 
  `shipping_method.deliveryTime.translation.updatedAt`, 
  `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.fallback_1.languageId`, 
  `shipping_method.deliveryTime.translation.languageId`, 
  `shipping_method`.`created_at` as `shipping_method.createdAt`, 
  `shipping_method`.`updated_at` as `shipping_method.updatedAt`, 
  `shipping_method.tax`.`id` as `shipping_method.tax.id`, 
  `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, 
  `shipping_method.tax`.`name` as `shipping_method.tax.name`, 
  `shipping_method.tax`.`position` as `shipping_method.tax.position`, 
  `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, 
  `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, 
  `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, 
  `shipping_method.translation.fallback_1.name`, 
  `shipping_method.translation.name`, 
  COALESCE(
    `shipping_method.translation.fallback_1.name`, 
    `shipping_method.translation.name`, 
    `shipping_method.translation.name`
  ) as `shipping_method.name`, 
  `shipping_method.translation.fallback_1.description`, 
  `shipping_method.translation.description`, 
  COALESCE(
    `shipping_method.translation.fallback_1.description`, 
    `shipping_method.translation.description`, 
    `shipping_method.translation.description`
  ) as `shipping_method.description`, 
  `shipping_method.translation.fallback_1.trackingUrl`, 
  `shipping_method.translation.trackingUrl`, 
  COALESCE(
    `shipping_method.translation.fallback_1.trackingUrl`, 
    `shipping_method.translation.trackingUrl`, 
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`, 
  `shipping_method.translation.fallback_1.customFields`, 
  `shipping_method.translation.customFields`, 
  COALESCE(
    `shipping_method.translation.fallback_1.customFields`, 
    `shipping_method.translation.customFields`, 
    `shipping_method.translation.customFields`
  ) as `shipping_method.customFields`, 
  `shipping_method.translation.fallback_1.createdAt`, 
  `shipping_method.translation.createdAt`, 
  `shipping_method.translation.fallback_1.updatedAt`, 
  `shipping_method.translation.updatedAt`, 
  `shipping_method.translation.fallback_1.shippingMethodId`, 
  `shipping_method.translation.shippingMethodId`, 
  `shipping_method.translation.fallback_1.languageId`, 
  `shipping_method.translation.languageId` 
FROM 
  `shipping_method` 
  LEFT JOIN (
    SELECT 
      `shipping_method.translation`.shipping_method_id, 
      `shipping_method.translation`.name as `shipping_method.translation.name`, 
      `shipping_method.translation`.description as `shipping_method.translation.description`, 
      `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, 
      `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, 
      `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, 
      `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, 
      `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, 
      `shipping_method.translation`.language_id as `shipping_method.translation.languageId`, 
      `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, 
      `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, 
      `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, 
      `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, 
      `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, 
      `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, 
      `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, 
      `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` 
    FROM 
      `shipping_method_translation` `shipping_method.translation` 
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` 
      AND `shipping_method.translation.fallback_1`.language_id = : languageId1 
    WHERE 
      `shipping_method.translation`.language_id = : languageId
  ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` 
  LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` 
  LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` 
  LEFT JOIN (
    SELECT 
      `shipping_method.deliveryTime.translation`.delivery_time_id, 
      `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, 
      `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, 
      `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, 
      `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, 
      `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, 
      `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId`, 
      `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, 
      `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
      `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, 
      `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, 
      `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, 
      `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` 
    FROM 
      `delivery_time_translation` `shipping_method.deliveryTime.translation` 
      LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` 
      AND `shipping_method.deliveryTime.translation.fallback_1`.language_id = : languageId1 
    WHERE 
      `shipping_method.deliveryTime.translation`.language_id = : languageId
  ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` 
WHERE 
  `shipping_method`.`id` IN (: ids)

# cart::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.name`,`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.customFields`,`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1.languageId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.fallback_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.fallback_1.name`,`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.fallback_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.fallback_1.description`,`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.fallback_1.trackingUrl`,`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.fallback_1.customFields`,`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.createdAt`, `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.fallback_1.languageId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId`, `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` AND `shipping_method.translation.fallback_1`.language_id = 0xD50D5A7A796A43E3BC377A553DF74D6B WHERE `shipping_method.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId`, `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_1`.language_id = 0xD50D5A7A796A43E3BC377A553DF74D6B WHERE `shipping_method.deliveryTime.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (0x8EF5D164672A4BD9AF35EC0118CCB1E1);

# cart::shipping-methods::association::prices::read
SELECT 
  `shipping_method_price`.`id` as `shipping_method_price.id`, 
  `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, 
  `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, 
  `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, 
  `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, 
  `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, 
  `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, 
  `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, 
  `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, 
  `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, 
  `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` 
FROM 
  `shipping_method_price` 
WHERE 
  (
    `shipping_method_price`.`shipping_method_id` IN (
      : param_e89ec2be1c004f1888e907fcdcace407
    )
  )

# cart::shipping-methods::association::prices::read
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (0x8EF5D164672A4BD9AF35EC0118CCB1E1));

# 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`.`write_access` as `app.integration.writeAccess`, 
  `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`.`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 = : languageId
  ) `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` = : param_c243e9a87fa9408c96c1c19569e8e503
  )