Symfony Profiler

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

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

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

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

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

-- seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )
  AND (seo_url.is_deleted = 0)

-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x018F9AC418C9734B96DFBEAB7E97E724 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'inside-news' OR seo_path_info = 'inside-news/')) AND (seo_url.is_deleted = 0);

INSERT INTO `pickware_license_bundle_plugin_installation` (
  `id`, `installation_id`, `created_at`
)
VALUES
  (
    ?,
    UNHEX(
      CONCAT(
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        "4",
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0x0fff
            )
          ),
          3,
          "0"
        ),
        HEX(
          FLOOR(
            RAND() * 4 + 8
          )
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0x0fff
            )
          ),
          3,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        )
      )
    ),
    UTC_TIMESTAMP(3)
  ) ON DUPLICATE KEY
UPDATE
  `id` = `id`

INSERT INTO `pickware_license_bundle_plugin_installation` (
                `id`,
                `installation_id`,
                `created_at`
            ) VALUES (
                0xB854730116074151886328CC3929A369,
                
        UNHEX(CONCAT(
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            "4",
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            HEX(FLOOR(RAND() * 4 + 8)),
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0")
        )),
                UTC_TIMESTAMP(3)
            ) ON DUPLICATE KEY UPDATE `id` = `id`;

SELECT
  `pickware_license_bundle_plugin_installation`.`id` as `pickware_license_bundle_plugin_installation.id`,
  `pickware_license_bundle_plugin_installation`.`installation_id` as `pickware_license_bundle_plugin_installation.installationId`,
  `pickware_license_bundle_plugin_installation`.`installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid`,
  `pickware_license_bundle_plugin_installation`.`pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken`,
  `pickware_license_bundle_plugin_installation`.`pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense`,
  `pickware_license_bundle_plugin_installation`.`pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease`,
  `pickware_license_bundle_plugin_installation`.`latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError`,
  `pickware_license_bundle_plugin_installation`.`latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError`,
  `pickware_license_bundle_plugin_installation`.`latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError`,
  `pickware_license_bundle_plugin_installation`.`last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt`,
  `pickware_license_bundle_plugin_installation`.`created_at` as `pickware_license_bundle_plugin_installation.createdAt`,
  `pickware_license_bundle_plugin_installation`.`updated_at` as `pickware_license_bundle_plugin_installation.updatedAt`
FROM
  `pickware_license_bundle_plugin_installation`
WHERE
  `pickware_license_bundle_plugin_installation`.`id` IN (?)

SELECT `pickware_license_bundle_plugin_installation`.`id` as `pickware_license_bundle_plugin_installation.id`, `pickware_license_bundle_plugin_installation`.`installation_id` as `pickware_license_bundle_plugin_installation.installationId`, `pickware_license_bundle_plugin_installation`.`installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid`, `pickware_license_bundle_plugin_installation`.`pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken`, `pickware_license_bundle_plugin_installation`.`pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense`, `pickware_license_bundle_plugin_installation`.`pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError`, `pickware_license_bundle_plugin_installation`.`last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt`, `pickware_license_bundle_plugin_installation`.`created_at` as `pickware_license_bundle_plugin_installation.createdAt`, `pickware_license_bundle_plugin_installation`.`updated_at` as `pickware_license_bundle_plugin_installation.updatedAt` FROM `pickware_license_bundle_plugin_installation` WHERE `pickware_license_bundle_plugin_installation`.`id` IN (0xB854730116074151886328CC3929A369);

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x018F9AC418C9734B96DFBEAB7E97E724) AND (token = 'LsBehkU17Hz78MVB13WJmkpsP4IO362B') LIMIT 1;

SELECT
  `prems_discount_category_base`.`id` as `prems_discount_category_base.id`,
  `prems_discount_category_base`.`discount` as `prems_discount_category_base.discount`,
  `prems_discount_category_base`.`active` as `prems_discount_category_base.active`,
  `prems_discount_category_base`.`is_upprice` as `prems_discount_category_base.isUpprice`,
  `prems_discount_category_base`.`valid_from` as `prems_discount_category_base.validFrom`,
  `prems_discount_category_base`.`valid_until` as `prems_discount_category_base.validUntil`,
  `prems_discount_category_base`.`valid_until_visibility` as `prems_discount_category_base.validUntilVisibility`,
  `prems_discount_category_base`.`priority` as `prems_discount_category_base.priority`,
  `prems_discount_category_base`.`type` as `prems_discount_category_base.type`,
  `prems_discount_category_base`.`price_rounding` as `prems_discount_category_base.priceRounding`,
  `prems_discount_category_base`.`number_of_orders` as `prems_discount_category_base.numberOfOrders`,
  `prems_discount_category_base`.`display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage`,
  `prems_discount_category_base`.`display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage`,
  `prems_discount_category_base`.`discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId`,
  `prems_discount_category_base`.`discount_category_ids` as `prems_discount_category_base.discountCategoryIds`,
  `prems_discount_category_base`.`category_ids_mode` as `prems_discount_category_base.categoryIdsMode`,
  `prems_discount_category_base`.`show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing`,
  `prems_discount_category_base`.`listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor`,
  `prems_discount_category_base`.`listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor`,
  `prems_discount_category_base`.`show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing`,
  `prems_discount_category_base`.`listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon`,
  `prems_discount_category_base`.`listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor`,
  `prems_discount_category_base`.`listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor`,
  `prems_discount_category_base`.`show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage`,
  `prems_discount_category_base`.`detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon`,
  `prems_discount_category_base`.`detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor`,
  `prems_discount_category_base`.`detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor`,
  `prems_discount_category_base`.`required_cookie_name` as `prems_discount_category_base.requiredCookieName`,
  `prems_discount_category_base`.`required_cookie_value` as `prems_discount_category_base.requiredCookieValue`,
  `prems_discount_category_base`.`required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName`,
  `prems_discount_category_base`.`required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue`,
  `prems_discount_category_base`.`discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds`,
  `prems_discount_category_base`.`discount_customer_ids` as `prems_discount_category_base.discountCustomerIds`,
  `prems_discount_category_base`.`discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds`,
  `prems_discount_category_base`.`discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds`,
  `prems_discount_category_base`.`block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions`,
  `prems_discount_category_base`.`created_at` as `prems_discount_category_base.createdAt`,
  `prems_discount_category_base`.`updated_at` as `prems_discount_category_base.updatedAt`,
  `prems_discount_category_base.translation.name`,
  `prems_discount_category_base.translation.name` as `prems_discount_category_base.name`,
  `prems_discount_category_base.translation.listingBadgeTitle`,
  `prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle`,
  `prems_discount_category_base.translation.listingInfoboxTitle`,
  `prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle`,
  `prems_discount_category_base.translation.listingInfoboxText`,
  `prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText`,
  `prems_discount_category_base.translation.detailpageInfoboxTitle`,
  `prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle`,
  `prems_discount_category_base.translation.detailpageInfoboxText`,
  `prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText`
FROM
  `prems_discount_category_base`
  LEFT JOIN (
    SELECT
      `prems_discount_category_base.translation`.`prems_discount_category_base_id`,
      `prems_discount_category_base.translation`.`name` as `prems_discount_category_base.translation.name`,
      `prems_discount_category_base.translation`.`listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle`,
      `prems_discount_category_base.translation`.`listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle`,
      `prems_discount_category_base.translation`.`listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText`,
      `prems_discount_category_base.translation`.`detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle`,
      `prems_discount_category_base.translation`.`detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText`
    FROM
      `prems_discount_category_base_translation` `prems_discount_category_base.translation`
    WHERE
      `prems_discount_category_base.translation`.`language_id` = ?
  ) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation`.`prems_discount_category_base_id` = `prems_discount_category_base`.`id`
WHERE
  (
    (
      (
        `prems_discount_category_base`.`valid_from` <= ?
      )
      OR `prems_discount_category_base`.`valid_from` <=> ?
    )
    AND (
      (
        `prems_discount_category_base`.`valid_until` >= ?
      )
      OR `prems_discount_category_base`.`valid_until` <=> ?
    )
    AND `prems_discount_category_base`.`active` = ?
  )

SELECT `prems_discount_category_base`.`id` as `prems_discount_category_base.id`, `prems_discount_category_base`.`discount` as `prems_discount_category_base.discount`, `prems_discount_category_base`.`active` as `prems_discount_category_base.active`, `prems_discount_category_base`.`is_upprice` as `prems_discount_category_base.isUpprice`, `prems_discount_category_base`.`valid_from` as `prems_discount_category_base.validFrom`, `prems_discount_category_base`.`valid_until` as `prems_discount_category_base.validUntil`, `prems_discount_category_base`.`valid_until_visibility` as `prems_discount_category_base.validUntilVisibility`, `prems_discount_category_base`.`priority` as `prems_discount_category_base.priority`, `prems_discount_category_base`.`type` as `prems_discount_category_base.type`, `prems_discount_category_base`.`price_rounding` as `prems_discount_category_base.priceRounding`, `prems_discount_category_base`.`number_of_orders` as `prems_discount_category_base.numberOfOrders`, `prems_discount_category_base`.`display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage`, `prems_discount_category_base`.`display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage`, `prems_discount_category_base`.`discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId`, `prems_discount_category_base`.`discount_category_ids` as `prems_discount_category_base.discountCategoryIds`, `prems_discount_category_base`.`category_ids_mode` as `prems_discount_category_base.categoryIdsMode`, `prems_discount_category_base`.`show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing`, `prems_discount_category_base`.`listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor`, `prems_discount_category_base`.`listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor`, `prems_discount_category_base`.`show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing`, `prems_discount_category_base`.`listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon`, `prems_discount_category_base`.`listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor`, `prems_discount_category_base`.`listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor`, `prems_discount_category_base`.`show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage`, `prems_discount_category_base`.`detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon`, `prems_discount_category_base`.`detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor`, `prems_discount_category_base`.`detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor`, `prems_discount_category_base`.`required_cookie_name` as `prems_discount_category_base.requiredCookieName`, `prems_discount_category_base`.`required_cookie_value` as `prems_discount_category_base.requiredCookieValue`, `prems_discount_category_base`.`required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName`, `prems_discount_category_base`.`required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue`, `prems_discount_category_base`.`discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds`, `prems_discount_category_base`.`discount_customer_ids` as `prems_discount_category_base.discountCustomerIds`, `prems_discount_category_base`.`discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds`, `prems_discount_category_base`.`discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds`, `prems_discount_category_base`.`block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions`, `prems_discount_category_base`.`created_at` as `prems_discount_category_base.createdAt`, `prems_discount_category_base`.`updated_at` as `prems_discount_category_base.updatedAt`, `prems_discount_category_base.translation.name`, `prems_discount_category_base.translation.name` as `prems_discount_category_base.name`, `prems_discount_category_base.translation.listingBadgeTitle`, `prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle`, `prems_discount_category_base.translation.listingInfoboxTitle`, `prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle`, `prems_discount_category_base.translation.listingInfoboxText`, `prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText`, `prems_discount_category_base.translation.detailpageInfoboxTitle`, `prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle`, `prems_discount_category_base.translation.detailpageInfoboxText`, `prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText` FROM `prems_discount_category_base` LEFT JOIN (SELECT `prems_discount_category_base.translation`.`prems_discount_category_base_id`, `prems_discount_category_base.translation`.`name` as `prems_discount_category_base.translation.name`, `prems_discount_category_base.translation`.`listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle`, `prems_discount_category_base.translation`.`listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle`, `prems_discount_category_base.translation`.`listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText`, `prems_discount_category_base.translation`.`detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle`, `prems_discount_category_base.translation`.`detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText` FROM `prems_discount_category_base_translation` `prems_discount_category_base.translation` WHERE `prems_discount_category_base.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation`.`prems_discount_category_base_id` = `prems_discount_category_base`.`id` WHERE (((`prems_discount_category_base`.`valid_from` <= '2026-08-13 06:00:38.845') OR `prems_discount_category_base`.`valid_from` <=> NULL) AND ((`prems_discount_category_base`.`valid_until` >= '2026-08-13 06:00:38.845') OR `prems_discount_category_base`.`valid_until` <=> NULL) AND `prems_discount_category_base`.`active` = 1);

SELECT
  DISTINCT LOWER(
    HEX(discount_product_stream_id)
  ) as discount_product_stream_id
FROM
  prems_discount_category_base
WHERE
  id IN (NULL)

SELECT DISTINCT LOWER(HEX(discount_product_stream_id)) as discount_product_stream_id
    FROM prems_discount_category_base
    WHERE id IN (NULL);

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

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

SELECT
  `sales_channel_country`.`sales_channel_id`,
  `sales_channel_country`.`country_id`
FROM
  `sales_channel_country`
WHERE
  (
    `sales_channel_country`.`sales_channel_id` = ?
    AND `sales_channel_country`.`country_id` = ?
  )

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND `sales_channel_country`.`country_id` = 0x018991743F7870678F8F4A83ADA963B2);

-- landing-page::data::search-ids
SELECT
  `landing_page`.`id`
FROM
  `landing_page`
  LEFT JOIN `swag_dynamic_access_landing_page_rule` `landing_page.swagDynamicAccessRules.mapping` ON `landing_page`.`id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_id`
  AND `landing_page`.`version_id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_version_id`
  LEFT JOIN `landing_page_sales_channel` `landing_page.salesChannels.mapping` ON `landing_page`.`id` = `landing_page.salesChannels.mapping`.`landing_page_id`
  AND `landing_page`.`version_id` = `landing_page.salesChannels.mapping`.`landing_page_version_id`
  LEFT JOIN `rule` `landing_page.swagDynamicAccessRules` ON `landing_page.swagDynamicAccessRules.mapping`.`rule_id` = `landing_page.swagDynamicAccessRules`.`id`
  LEFT JOIN `sales_channel` `landing_page.salesChannels` ON `landing_page.salesChannels.mapping`.`sales_channel_id` = `landing_page.salesChannels`.`id`
WHERE
  (`landing_page`.`version_id` = ?)
  AND (
    (
      `landing_page`.`active` = ?
      AND `landing_page.salesChannels`.`id` = ?
      AND (
        (
          `landing_page.swagDynamicAccessRules`.`id` IN (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?, ?, ?
          )
        )
        OR `landing_page.swagDynamicAccessRules`.`id` <=> ?
      )
    )
  )
  AND (
    `landing_page`.`id` IN (?)
  )
GROUP BY
  `landing_page`.`id`

-- landing-page::data::search-ids
SELECT `landing_page`.`id` FROM `landing_page` LEFT JOIN `swag_dynamic_access_landing_page_rule` `landing_page.swagDynamicAccessRules.mapping` ON `landing_page`.`id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_id`  AND `landing_page`.`version_id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_version_id` LEFT JOIN `landing_page_sales_channel` `landing_page.salesChannels.mapping` ON `landing_page`.`id` = `landing_page.salesChannels.mapping`.`landing_page_id`  AND `landing_page`.`version_id` = `landing_page.salesChannels.mapping`.`landing_page_version_id` LEFT JOIN `rule` `landing_page.swagDynamicAccessRules` ON `landing_page.swagDynamicAccessRules.mapping`.`rule_id` = `landing_page.swagDynamicAccessRules`.`id`  LEFT JOIN `sales_channel` `landing_page.salesChannels` ON `landing_page.salesChannels.mapping`.`sales_channel_id` = `landing_page.salesChannels`.`id`  WHERE (`landing_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`landing_page`.`active` = 1 AND `landing_page.salesChannels`.`id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND ((`landing_page.swagDynamicAccessRules`.`id` IN (0x01899174400972AE8C3AE6D0E4B0C4F9, 0x018991744016704EAC609620C28FC82F, 0x018991748E9272E2A5DF8EE15ABF5E52, 0x018E613131E57619B30F4D2727DA8F85, 0x018991744039701DAF34BDA1AC0B831D, 0x018FA4DF34C27EE39B0D51670CDA4227, 0x018F9ACC203273E8B83A31A523376A5C, 0x018F9ACC2038737BACE4A8D1D558A28B, 0x018F9ACC203E7137BDE6B936EA3F31B6, 0x018F9ACC2045704E82FFCD5707BB8014, 0x018F9ACC204C730C8D9CE2B07E3E3E3B, 0x018F9ACC20517121A96C71787E510506, 0x018F9ACC20577194A35825A4C88A1910, 0x018F9ACC2064735BBA6ABF9647796CDE, 0x018F9ACC2DAF716BB7B3FAA997C2FE01, 0x018F9ACC4D8472C694D90EAB5D67A492, 0x018F9ACC660E72BEBBF0854CF782F19B, 0x018F9ACC66817387AA2F310F51AE1D22, 0x018F9ACC66877346BCC456341FCB0B02, 0x018F9ACC698073E18A7B5E52D1251A88)) OR `landing_page.swagDynamicAccessRules`.`id` <=> NULL))) AND (`landing_page`.`id` IN (0x018E50E5AC6B7579B3A40410ACFB2180)) GROUP BY `landing_page`.`id`;

-- landing-page::data::read
SELECT
  `landing_page`.`id` as `landing_page.id`,
  `landing_page`.`version_id` as `landing_page.versionId`,
  `landing_page`.`active` as `landing_page.active`,
  `landing_page`.`cms_page_id` as `landing_page.cmsPageId`,
  `landing_page`.`cms_page_version_id` as `landing_page.cmsPageVersionId`,
  `landing_page`.`created_at` as `landing_page.createdAt`,
  `landing_page`.`updated_at` as `landing_page.updatedAt`,
  `landing_page.translation.name`,
  `landing_page.translation.name` as `landing_page.name`,
  `landing_page.translation.url`,
  `landing_page.translation.url` as `landing_page.url`,
  `landing_page.translation.slotConfig`,
  `landing_page.translation.slotConfig` as `landing_page.slotConfig`,
  `landing_page.translation.metaTitle`,
  `landing_page.translation.metaTitle` as `landing_page.metaTitle`,
  `landing_page.translation.metaDescription`,
  `landing_page.translation.metaDescription` as `landing_page.metaDescription`,
  `landing_page.translation.keywords`,
  `landing_page.translation.keywords` as `landing_page.keywords`,
  `landing_page.translation.customFields`,
  `landing_page.translation.customFields` as `landing_page.customFields`
FROM
  `landing_page`
  LEFT JOIN (
    SELECT
      `landing_page.translation`.`landing_page_id`,
      `landing_page.translation`.`landing_page_version_id`,
      `landing_page.translation`.`name` as `landing_page.translation.name`,
      `landing_page.translation`.`custom_fields` as `landing_page.translation.customFields`,
      `landing_page.translation`.`slot_config` as `landing_page.translation.slotConfig`,
      `landing_page.translation`.`meta_title` as `landing_page.translation.metaTitle`,
      `landing_page.translation`.`meta_description` as `landing_page.translation.metaDescription`,
      `landing_page.translation`.`keywords` as `landing_page.translation.keywords`,
      `landing_page.translation`.`url` as `landing_page.translation.url`
    FROM
      `landing_page_translation` `landing_page.translation`
    WHERE
      `landing_page.translation`.`language_id` = ?
  ) `landing_page.landing_page_translation` ON `landing_page.landing_page_translation`.`landing_page_id` = `landing_page`.`id`
  AND `landing_page.landing_page_translation`.`landing_page_version_id` = `landing_page`.`version_id`
WHERE
  (`landing_page`.`version_id` = ?)
  AND (
    `landing_page`.`id` IN (?)
  )

-- landing-page::data::read
SELECT `landing_page`.`id` as `landing_page.id`, `landing_page`.`version_id` as `landing_page.versionId`, `landing_page`.`active` as `landing_page.active`, `landing_page`.`cms_page_id` as `landing_page.cmsPageId`, `landing_page`.`cms_page_version_id` as `landing_page.cmsPageVersionId`, `landing_page`.`created_at` as `landing_page.createdAt`, `landing_page`.`updated_at` as `landing_page.updatedAt`, `landing_page.translation.name`, `landing_page.translation.name` as `landing_page.name`, `landing_page.translation.url`, `landing_page.translation.url` as `landing_page.url`, `landing_page.translation.slotConfig`, `landing_page.translation.slotConfig` as `landing_page.slotConfig`, `landing_page.translation.metaTitle`, `landing_page.translation.metaTitle` as `landing_page.metaTitle`, `landing_page.translation.metaDescription`, `landing_page.translation.metaDescription` as `landing_page.metaDescription`, `landing_page.translation.keywords`, `landing_page.translation.keywords` as `landing_page.keywords`, `landing_page.translation.customFields`, `landing_page.translation.customFields` as `landing_page.customFields` FROM `landing_page` LEFT JOIN (SELECT `landing_page.translation`.`landing_page_id`, `landing_page.translation`.`landing_page_version_id`, `landing_page.translation`.`name` as `landing_page.translation.name`, `landing_page.translation`.`custom_fields` as `landing_page.translation.customFields`, `landing_page.translation`.`slot_config` as `landing_page.translation.slotConfig`, `landing_page.translation`.`meta_title` as `landing_page.translation.metaTitle`, `landing_page.translation`.`meta_description` as `landing_page.translation.metaDescription`, `landing_page.translation`.`keywords` as `landing_page.translation.keywords`, `landing_page.translation`.`url` as `landing_page.translation.url` FROM `landing_page_translation` `landing_page.translation` WHERE `landing_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `landing_page.landing_page_translation` ON `landing_page.landing_page_translation`.`landing_page_id` = `landing_page`.`id` AND `landing_page.landing_page_translation`.`landing_page_version_id` = `landing_page`.`version_id` WHERE (`landing_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`landing_page`.`id` IN (0x018E50E5AC6B7579B3A40410ACFB2180));

-- landing-page::data::association::translations::read
SELECT
  `landing_page_translation`.`name` as `landing_page_translation.name`,
  `landing_page_translation`.`url` as `landing_page_translation.url`,
  `landing_page_translation`.`slot_config` as `landing_page_translation.slotConfig`,
  `landing_page_translation`.`meta_title` as `landing_page_translation.metaTitle`,
  `landing_page_translation`.`meta_description` as `landing_page_translation.metaDescription`,
  `landing_page_translation`.`keywords` as `landing_page_translation.keywords`,
  `landing_page_translation`.`custom_fields` as `landing_page_translation.customFields`,
  `landing_page_translation`.`created_at` as `landing_page_translation.createdAt`,
  `landing_page_translation`.`updated_at` as `landing_page_translation.updatedAt`,
  `landing_page_translation`.`landing_page_id` as `landing_page_translation.landingPageId`,
  `landing_page_translation`.`language_id` as `landing_page_translation.languageId`,
  `landing_page_translation`.`landing_page_version_id` as `landing_page_translation.landingPageVersionId`
FROM
  `landing_page_translation`
WHERE
  (
    `landing_page_translation`.`landing_page_version_id` = ?
  )
  AND (
    (
      (
        `landing_page_translation`.`landing_page_id` IN (?)
      )
    )
  )

-- landing-page::data::association::translations::read
SELECT `landing_page_translation`.`name` as `landing_page_translation.name`, `landing_page_translation`.`url` as `landing_page_translation.url`, `landing_page_translation`.`slot_config` as `landing_page_translation.slotConfig`, `landing_page_translation`.`meta_title` as `landing_page_translation.metaTitle`, `landing_page_translation`.`meta_description` as `landing_page_translation.metaDescription`, `landing_page_translation`.`keywords` as `landing_page_translation.keywords`, `landing_page_translation`.`custom_fields` as `landing_page_translation.customFields`, `landing_page_translation`.`created_at` as `landing_page_translation.createdAt`, `landing_page_translation`.`updated_at` as `landing_page_translation.updatedAt`, `landing_page_translation`.`landing_page_id` as `landing_page_translation.landingPageId`, `landing_page_translation`.`language_id` as `landing_page_translation.languageId`, `landing_page_translation`.`landing_page_version_id` as `landing_page_translation.landingPageVersionId` FROM `landing_page_translation` WHERE (`landing_page_translation`.`landing_page_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`landing_page_translation`.`landing_page_id` IN (0x018E50E5AC6B7579B3A40410ACFB2180))));

SELECT
  LOWER(
    HEX(language.parent_id)
  )
FROM
  language
WHERE
  language.id = ?

SELECT LOWER(HEX(language.parent_id)) FROM language WHERE language.id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B;

-- landing-page::cms-page::read
SELECT
  `cms_page`.`id` as `cms_page.id`,
  `cms_page`.`version_id` as `cms_page.versionId`,
  `cms_page`.`type` as `cms_page.type`,
  `cms_page`.`entity` as `cms_page.entity`,
  `cms_page`.`css_class` as `cms_page.cssClass`,
  `cms_page`.`config` as `cms_page.config`,
  `cms_page`.`preview_media_id` as `cms_page.previewMediaId`,
  `cms_page`.`locked` as `cms_page.locked`,
  `cms_page`.`created_at` as `cms_page.createdAt`,
  `cms_page`.`updated_at` as `cms_page.updatedAt`,
  `cms_page.translation.name`,
  `cms_page.translation.name` as `cms_page.name`,
  `cms_page.translation.customFields`,
  `cms_page.translation.customFields` as `cms_page.customFields`
FROM
  `cms_page`
  LEFT JOIN (
    SELECT
      `cms_page.translation`.`cms_page_id`,
      `cms_page.translation`.`cms_page_version_id`,
      `cms_page.translation`.`name` as `cms_page.translation.name`,
      `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields`
    FROM
      `cms_page_translation` `cms_page.translation`
    WHERE
      `cms_page.translation`.`language_id` = ?
  ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id`
  AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id`
WHERE
  (`cms_page`.`version_id` = ?)
  AND (
    `cms_page`.`id` IN (?)
  )

-- landing-page::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`cms_page`.`id` IN (0x018E51521A217B5D83EE4E77C046B6CC));

-- landing-page::cms-page::association::sections::read
SELECT
  `cms_section`.`id` as `cms_section.id`,
  `cms_section`.`version_id` as `cms_section.versionId`,
  `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`,
  `cms_section`.`position` as `cms_section.position`,
  `cms_section`.`type` as `cms_section.type`,
  `cms_section`.`locked` as `cms_section.locked`,
  `cms_section`.`name` as `cms_section.name`,
  `cms_section`.`sizing_mode` as `cms_section.sizingMode`,
  `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`,
  `cms_section`.`background_color` as `cms_section.backgroundColor`,
  `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`,
  `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`,
  `cms_section`.`css_class` as `cms_section.cssClass`,
  `cms_section`.`cms_page_id` as `cms_section.pageId`,
  `cms_section`.`visibility` as `cms_section.visibility`,
  `cms_section`.`custom_fields` as `cms_section.customFields`,
  `cms_section`.`created_at` as `cms_section.createdAt`,
  `cms_section`.`updated_at` as `cms_section.updatedAt`,
  `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`,
  `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`,
  `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`,
  `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`,
  `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`,
  `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`,
  `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`,
  `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`,
  `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`,
  `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`,
  `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`,
  `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`,
  `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`,
  `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`,
  `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`,
  `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`,
  `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`,
  `cms_section.backgroundMedia.translation.title`,
  `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`,
  `cms_section.backgroundMedia.translation.alt`,
  `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`,
  `cms_section.backgroundMedia.translation.customFields`,
  `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
  `cms_section`
  LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id`
  LEFT JOIN (
    SELECT
      `cms_section.backgroundMedia.translation`.`media_id`,
      `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`,
      `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`,
      `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`
    FROM
      `media_translation` `cms_section.backgroundMedia.translation`
    WHERE
      `cms_section.backgroundMedia.translation`.`language_id` = ?
  ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id`
WHERE
  (`cms_section`.`version_id` = ?)
  AND (
    (
      (
        `cms_section`.`cms_page_id` IN (?)
      )
    )
  )