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 = 'shop-service/versandkosten' OR seo_path_info = 'shop-service/versandkosten/')) 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 = 'S1iR1hQAQQEla6w45CErfKqFpeGeoyLV') 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:29:38.573') OR `prems_discount_category_base`.`valid_from` <=> NULL) AND ((`prems_discount_category_base`.`valid_until` >= '2026-08-13 06:29:38.573') 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` = 'S1iR1hQAQQEla6w45CErfKqFpeGeoyLV';

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);

SELECT
  pm.`handler_identifier`,
  LOWER(
    HEX(sc_pm.`payment_method_id`)
  )
FROM
  `sales_channel_payment_method` AS sc_pm
  LEFT JOIN `payment_method` AS pm ON pm.`id` = sc_pm.`payment_method_id`
WHERE
  sc_pm.`sales_channel_id` = ?
  AND pm.`active` = 1

SELECT pm.`handler_identifier`, LOWER(HEX(sc_pm.`payment_method_id`))
                FROM `sales_channel_payment_method` AS sc_pm
                LEFT JOIN `payment_method` AS pm ON pm.`id` = sc_pm.`payment_method_id`
                WHERE sc_pm.`sales_channel_id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND pm.`active` = 1;

SELECT
  `language`.`id`
FROM
  `language`
WHERE
  `language`.`id` IN (?)
LIMIT
  1

SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) LIMIT 1;

SELECT
  `language`.`id` as `language.id`,
  `language`.`parent_id` as `language.parentId`,
  `language`.`locale_id` as `language.localeId`,
  `language`.`translation_code_id` as `language.translationCodeId`,
  `language`.`name` as `language.name`,
  `language`.`active` as `language.active`,
  `language`.`custom_fields` as `language.customFields`,
  `language`.`created_at` as `language.createdAt`,
  `language`.`updated_at` as `language.updatedAt`,
  `language.locale`.`id` as `language.locale.id`,
  `language.locale`.`code` as `language.locale.code`,
  `language.locale`.`created_at` as `language.locale.createdAt`,
  `language.locale`.`updated_at` as `language.locale.updatedAt`,
  `language.locale.translation.name`,
  `language.locale.translation.name` as `language.locale.name`,
  `language.locale.translation.territory`,
  `language.locale.translation.territory` as `language.locale.territory`,
  `language.locale.translation.customFields`,
  `language.locale.translation.customFields` as `language.locale.customFields`
FROM
  `language`
  LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id`
  LEFT JOIN (
    SELECT
      `language.locale.translation`.`locale_id`,
      `language.locale.translation`.`name` as `language.locale.translation.name`,
      `language.locale.translation`.`territory` as `language.locale.translation.territory`,
      `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`
    FROM
      `locale_translation` `language.locale.translation`
    WHERE
      `language.locale.translation`.`language_id` = ?
  ) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id`
WHERE
  `language`.`id` IN (?)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

SELECT
  `language`.`id` as `language.id`,
  `language`.`parent_id` as `language.parentId`,
  `language`.`locale_id` as `language.localeId`,
  `language`.`translation_code_id` as `language.translationCodeId`,
  `language`.`name` as `language.name`,
  `language`.`active` as `language.active`,
  `language`.`custom_fields` as `language.customFields`,
  `language`.`created_at` as `language.createdAt`,
  `language`.`updated_at` as `language.updatedAt`,
  `language.locale`.`id` as `language.locale.id`,
  `language.locale`.`code` as `language.locale.code`,
  `language.locale`.`created_at` as `language.locale.createdAt`,
  `language.locale`.`updated_at` as `language.locale.updatedAt`,
  `language.locale.translation.name`,
  `language.locale.translation.name` as `language.locale.name`,
  `language.locale.translation.territory`,
  `language.locale.translation.territory` as `language.locale.territory`,
  `language.locale.translation.customFields`,
  `language.locale.translation.customFields` as `language.locale.customFields`
FROM
  `language`
  LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id`
  LEFT JOIN (
    SELECT
      `language.locale.translation`.`locale_id`,
      `language.locale.translation`.`name` as `language.locale.translation.name`,
      `language.locale.translation`.`territory` as `language.locale.translation.territory`,
      `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`
    FROM
      `locale_translation` `language.locale.translation`
    WHERE
      `language.locale.translation`.`language_id` = ?
  ) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id`
WHERE
  `language`.`id` IN (?)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

SELECT
  `language`.`id` as `language.id`,
  `language`.`parent_id` as `language.parentId`,
  `language`.`locale_id` as `language.localeId`,
  `language`.`translation_code_id` as `language.translationCodeId`,
  `language`.`name` as `language.name`,
  `language`.`active` as `language.active`,
  `language`.`custom_fields` as `language.customFields`,
  `language`.`created_at` as `language.createdAt`,
  `language`.`updated_at` as `language.updatedAt`,
  `language.locale`.`id` as `language.locale.id`,
  `language.locale`.`code` as `language.locale.code`,
  `language.locale`.`created_at` as `language.locale.createdAt`,
  `language.locale`.`updated_at` as `language.locale.updatedAt`,
  `language.locale.translation.name`,
  `language.locale.translation.name` as `language.locale.name`,
  `language.locale.translation.territory`,
  `language.locale.translation.territory` as `language.locale.territory`,
  `language.locale.translation.customFields`,
  `language.locale.translation.customFields` as `language.locale.customFields`
FROM
  `language`
  LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id`
  LEFT JOIN (
    SELECT
      `language.locale.translation`.`locale_id`,
      `language.locale.translation`.`name` as `language.locale.translation.name`,
      `language.locale.translation`.`territory` as `language.locale.translation.territory`,
      `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`
    FROM
      `locale_translation` `language.locale.translation`
    WHERE
      `language.locale.translation`.`language_id` = ?
  ) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id`
WHERE
  `language`.`id` IN (?)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

SELECT
  `version`
FROM
  `plugin`
WHERE
  `base_class` = ?
LIMIT
  1

SELECT `version` FROM `plugin` WHERE `base_class` = 'Klaviyo\\Integration\\klavi_overd' LIMIT 1;