Symfony Profiler

# theme-service::load-config::read
SELECT
  `theme`.`id` as `theme.id`,
  `theme`.`technical_name` as `theme.technicalName`,
  `theme`.`name` as `theme.name`,
  `theme`.`author` as `theme.author`,
  `theme`.`preview_media_id` as `theme.previewMediaId`,
  `theme`.`parent_theme_id` as `theme.parentThemeId`,
  `theme`.`theme_json` as `theme.themeJson`,
  `theme`.`base_config` as `theme.baseConfig`,
  `theme`.`config_values` as `theme.configValues`,
  `theme`.`active` as `theme.active`,
  `theme`.`created_at` as `theme.createdAt`,
  `theme`.`updated_at` as `theme.updatedAt`,
  `theme.translation.description`,
  `theme.translation.description` as `theme.description`,
  `theme.translation.labels`,
  `theme.translation.labels` as `theme.labels`,
  `theme.translation.helpTexts`,
  `theme.translation.helpTexts` as `theme.helpTexts`,
  `theme.translation.customFields`,
  `theme.translation.customFields` as `theme.customFields`
FROM
  `theme`
  LEFT JOIN (
    SELECT
      `theme.translation`.`theme_id`,
      `theme.translation`.`description` as `theme.translation.description`,
      `theme.translation`.`labels` as `theme.translation.labels`,
      `theme.translation`.`help_texts` as `theme.translation.helpTexts`,
      `theme.translation`.`custom_fields` as `theme.translation.customFields`
    FROM
      `theme_translation` `theme.translation`
    WHERE
      `theme.translation`.`language_id` = ?
  ) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`

# theme-service::load-config::read
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.description`, `theme.translation.description` as `theme.description`, `theme.translation.labels`, `theme.translation.labels` as `theme.labels`, `theme.translation.helpTexts`, `theme.translation.helpTexts` as `theme.helpTexts`, `theme.translation.customFields`, `theme.translation.customFields` as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`;

# header::navigation::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.title`,
  `category.media.translation.title` as `category.media.title`,
  `category.media.translation.alt`,
  `category.media.translation.alt` as `category.media.alt`,
  `category.media.translation.customFields`,
  `category.media.translation.customFields` as `category.media.customFields`,
  `category.translation.name`,
  `category.translation.name` as `category.name`,
  `category.translation.breadcrumb`,
  `category.translation.breadcrumb` as `category.breadcrumb`,
  `category.translation.slotConfig`,
  `category.translation.slotConfig` as `category.slotConfig`,
  `category.translation.linkType`,
  `category.translation.linkType` as `category.linkType`,
  `category.translation.internalLink`,
  `category.translation.internalLink` as `category.internalLink`,
  `category.translation.externalLink`,
  `category.translation.externalLink` as `category.externalLink`,
  `category.translation.linkNewTab`,
  `category.translation.linkNewTab` as `category.linkNewTab`,
  `category.translation.description`,
  `category.translation.description` as `category.description`,
  `category.translation.metaTitle`,
  `category.translation.metaTitle` as `category.metaTitle`,
  `category.translation.metaDescription`,
  `category.translation.metaDescription` as `category.metaDescription`,
  `category.translation.keywords`,
  `category.translation.keywords` as `category.keywords`,
  `category.translation.customFields`,
  `category.translation.customFields` as `category.customFields`
FROM
  `category`
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`
    FROM
      `category_translation` `category.translation`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.`media_id`,
      `category.media.translation`.`alt` as `category.media.translation.alt`,
      `category.media.translation`.`title` as `category.media.translation.title`,
      `category.media.translation`.`custom_fields` as `category.media.translation.customFields`
    FROM
      `media_translation` `category.media.translation`
    WHERE
      `category.media.translation`.`language_id` = ?
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category`.`path` LIKE ?
      AND (
        `category`.`level` > ?
        AND `category`.`level` <= ?
      )
    )
  )

# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|7a6eb531e6c14fe1b04f1a4b01014355|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4)));

SELECT
  `payment_method`.`id` as `payment_method.id`,
  `payment_method`.`plugin_id` as `payment_method.pluginId`,
  `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`,
  `payment_method`.`position` as `payment_method.position`,
  `payment_method`.`active` as `payment_method.active`,
  `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`,
  `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`,
  `payment_method`.`media_id` as `payment_method.mediaId`,
  `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`,
  `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`,
  `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`,
  `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`,
  `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`,
  `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`,
  `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`,
  `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`,
  `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`,
  `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`,
  `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`,
  `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`,
  `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`,
  `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`,
  `payment_method.appPaymentMethod.app`.`id` as `payment_method.appPaymentMethod.app.id`,
  `payment_method.appPaymentMethod.app`.`name` as `payment_method.appPaymentMethod.app.name`,
  `payment_method.appPaymentMethod.app`.`path` as `payment_method.appPaymentMethod.app.path`,
  `payment_method.appPaymentMethod.app`.`author` as `payment_method.appPaymentMethod.app.author`,
  `payment_method.appPaymentMethod.app`.`copyright` as `payment_method.appPaymentMethod.app.copyright`,
  `payment_method.appPaymentMethod.app`.`license` as `payment_method.appPaymentMethod.app.license`,
  `payment_method.appPaymentMethod.app`.`active` as `payment_method.appPaymentMethod.app.active`,
  `payment_method.appPaymentMethod.app`.`configurable` as `payment_method.appPaymentMethod.app.configurable`,
  `payment_method.appPaymentMethod.app`.`privacy` as `payment_method.appPaymentMethod.app.privacy`,
  `payment_method.appPaymentMethod.app`.`version` as `payment_method.appPaymentMethod.app.version`,
  `payment_method.appPaymentMethod.app`.`icon` as `payment_method.appPaymentMethod.app.iconRaw`,
  `payment_method.appPaymentMethod.app`.`app_secret` as `payment_method.appPaymentMethod.app.appSecret`,
  `payment_method.appPaymentMethod.app`.`modules` as `payment_method.appPaymentMethod.app.modules`,
  `payment_method.appPaymentMethod.app`.`main_module` as `payment_method.appPaymentMethod.app.mainModule`,
  `payment_method.appPaymentMethod.app`.`cookies` as `payment_method.appPaymentMethod.app.cookies`,
  `payment_method.appPaymentMethod.app`.`allow_disable` as `payment_method.appPaymentMethod.app.allowDisable`,
  `payment_method.appPaymentMethod.app`.`base_app_url` as `payment_method.appPaymentMethod.app.baseAppUrl`,
  `payment_method.appPaymentMethod.app`.`allowed_hosts` as `payment_method.appPaymentMethod.app.allowedHosts`,
  `payment_method.appPaymentMethod.app`.`template_load_priority` as `payment_method.appPaymentMethod.app.templateLoadPriority`,
  `payment_method.appPaymentMethod.app`.`checkout_gateway_url` as `payment_method.appPaymentMethod.app.checkoutGatewayUrl`,
  `payment_method.appPaymentMethod.app`.`in_app_purchases_gateway_url` as `payment_method.appPaymentMethod.app.inAppPurchasesGatewayUrl`,
  `payment_method.appPaymentMethod.app`.`source_type` as `payment_method.appPaymentMethod.app.sourceType`,
  `payment_method.appPaymentMethod.app`.`source_config` as `payment_method.appPaymentMethod.app.sourceConfig`,
  `payment_method.appPaymentMethod.app`.`self_managed` as `payment_method.appPaymentMethod.app.selfManaged`,
  `payment_method.appPaymentMethod.app`.`integration_id` as `payment_method.appPaymentMethod.app.integrationId`,
  `payment_method.appPaymentMethod.app.integration`.`id` as `payment_method.appPaymentMethod.app.integration.id`,
  `payment_method.appPaymentMethod.app.integration`.`label` as `payment_method.appPaymentMethod.app.integration.label`,
  `payment_method.appPaymentMethod.app.integration`.`access_key` as `payment_method.appPaymentMethod.app.integration.accessKey`,
  `payment_method.appPaymentMethod.app.integration`.`secret_access_key` as `payment_method.appPaymentMethod.app.integration.secretAccessKey`,
  `payment_method.appPaymentMethod.app.integration`.`last_usage_at` as `payment_method.appPaymentMethod.app.integration.lastUsageAt`,
  `payment_method.appPaymentMethod.app.integration`.`admin` as `payment_method.appPaymentMethod.app.integration.admin`,
  `payment_method.appPaymentMethod.app.integration`.`custom_fields` as `payment_method.appPaymentMethod.app.integration.customFields`,
  `payment_method.appPaymentMethod.app.integration`.`deleted_at` as `payment_method.appPaymentMethod.app.integration.deletedAt`,
  `payment_method.appPaymentMethod.app.integration`.`created_at` as `payment_method.appPaymentMethod.app.integration.createdAt`,
  `payment_method.appPaymentMethod.app.integration`.`updated_at` as `payment_method.appPaymentMethod.app.integration.updatedAt`,
  `payment_method.appPaymentMethod.app`.`acl_role_id` as `payment_method.appPaymentMethod.app.aclRoleId`,
  `payment_method.appPaymentMethod.app.aclRole`.`id` as `payment_method.appPaymentMethod.app.aclRole.id`,
  `payment_method.appPaymentMethod.app.aclRole`.`name` as `payment_method.appPaymentMethod.app.aclRole.name`,
  `payment_method.appPaymentMethod.app.aclRole`.`description` as `payment_method.appPaymentMethod.app.aclRole.description`,
  `payment_method.appPaymentMethod.app.aclRole`.`privileges` as `payment_method.appPaymentMethod.app.aclRole.privileges`,
  `payment_method.appPaymentMethod.app.aclRole`.`deleted_at` as `payment_method.appPaymentMethod.app.aclRole.deletedAt`,
  `payment_method.appPaymentMethod.app.aclRole`.`created_at` as `payment_method.appPaymentMethod.app.aclRole.createdAt`,
  `payment_method.appPaymentMethod.app.aclRole`.`updated_at` as `payment_method.appPaymentMethod.app.aclRole.updatedAt`,
  `payment_method.appPaymentMethod.app`.`created_at` as `payment_method.appPaymentMethod.app.createdAt`,
  `payment_method.appPaymentMethod.app`.`updated_at` as `payment_method.appPaymentMethod.app.updatedAt`,
  `payment_method.appPaymentMethod.app.translation.label`,
  `payment_method.appPaymentMethod.app.translation.label` as `payment_method.appPaymentMethod.app.label`,
  `payment_method.appPaymentMethod.app.translation.description`,
  `payment_method.appPaymentMethod.app.translation.description` as `payment_method.appPaymentMethod.app.description`,
  `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`,
  `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions` as `payment_method.appPaymentMethod.app.privacyPolicyExtensions`,
  `payment_method.appPaymentMethod.app.translation.customFields`,
  `payment_method.appPaymentMethod.app.translation.customFields` as `payment_method.appPaymentMethod.app.customFields`,
  `payment_method`.`technical_name` as `payment_method.technicalName`,
  `payment_method`.`created_at` as `payment_method.createdAt`,
  `payment_method`.`updated_at` as `payment_method.updatedAt`,
  `payment_method.media`.`id` as `payment_method.media.id`,
  `payment_method.media`.`user_id` as `payment_method.media.userId`,
  `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`,
  `payment_method.media`.`mime_type` as `payment_method.media.mimeType`,
  `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`,
  `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`,
  `payment_method.media`.`file_name` as `payment_method.media.fileName`,
  `payment_method.media`.`file_size` as `payment_method.media.fileSize`,
  `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`,
  `payment_method.media`.`meta_data` as `payment_method.media.metaData`,
  `payment_method.media`.`config` as `payment_method.media.config`,
  `payment_method.media`.`path` as `payment_method.media.path`,
  `payment_method.media`.`private` as `payment_method.media.private`,
  `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`,
  `payment_method.media`.`created_at` as `payment_method.media.createdAt`,
  `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`,
  `payment_method.media.translation.title`,
  `payment_method.media.translation.title` as `payment_method.media.title`,
  `payment_method.media.translation.alt`,
  `payment_method.media.translation.alt` as `payment_method.media.alt`,
  `payment_method.media.translation.customFields`,
  `payment_method.media.translation.customFields` as `payment_method.media.customFields`,
  `payment_method.translation.name`,
  `payment_method.translation.name` as `payment_method.name`,
  `payment_method.translation.distinguishableName`,
  `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`,
  `payment_method.translation.description`,
  `payment_method.translation.description` as `payment_method.description`,
  `payment_method.translation.customFields`,
  `payment_method.translation.customFields` as `payment_method.customFields`
FROM
  `payment_method`
  LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id`
  LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.translation`.`payment_method_id`,
      `payment_method.translation`.`name` as `payment_method.translation.name`,
      `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`,
      `payment_method.translation`.`description` as `payment_method.translation.description`,
      `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`
    FROM
      `payment_method_translation` `payment_method.translation`
    WHERE
      `payment_method.translation`.`language_id` = ?
  ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id`
  LEFT JOIN `app` `payment_method.appPaymentMethod.app` ON `payment_method.appPaymentMethod`.`app_id` = `payment_method.appPaymentMethod.app`.`id`
  LEFT JOIN `integration` `payment_method.appPaymentMethod.app.integration` ON `payment_method.appPaymentMethod.app`.`integration_id` = `payment_method.appPaymentMethod.app.integration`.`id`
  LEFT JOIN `acl_role` `payment_method.appPaymentMethod.app.aclRole` ON `payment_method.appPaymentMethod.app`.`acl_role_id` = `payment_method.appPaymentMethod.app.aclRole`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.appPaymentMethod.app.translation`.`app_id`,
      `payment_method.appPaymentMethod.app.translation`.`label` as `payment_method.appPaymentMethod.app.translation.label`,
      `payment_method.appPaymentMethod.app.translation`.`description` as `payment_method.appPaymentMethod.app.translation.description`,
      `payment_method.appPaymentMethod.app.translation`.`privacy_policy_extensions` as `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`,
      `payment_method.appPaymentMethod.app.translation`.`custom_fields` as `payment_method.appPaymentMethod.app.translation.customFields`
    FROM
      `app_translation` `payment_method.appPaymentMethod.app.translation`
    WHERE
      `payment_method.appPaymentMethod.app.translation`.`language_id` = ?
  ) `payment_method.appPaymentMethod.app.app_translation` ON `payment_method.appPaymentMethod.app.app_translation`.`app_id` = `payment_method.appPaymentMethod.app`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.media.translation`.`media_id`,
      `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`,
      `payment_method.media.translation`.`title` as `payment_method.media.translation.title`,
      `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`
    FROM
      `media_translation` `payment_method.media.translation`
    WHERE
      `payment_method.media.translation`.`language_id` = ?
  ) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id`
WHERE
  `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?)

SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method.appPaymentMethod.app`.`id` as `payment_method.appPaymentMethod.app.id`, `payment_method.appPaymentMethod.app`.`name` as `payment_method.appPaymentMethod.app.name`, `payment_method.appPaymentMethod.app`.`path` as `payment_method.appPaymentMethod.app.path`, `payment_method.appPaymentMethod.app`.`author` as `payment_method.appPaymentMethod.app.author`, `payment_method.appPaymentMethod.app`.`copyright` as `payment_method.appPaymentMethod.app.copyright`, `payment_method.appPaymentMethod.app`.`license` as `payment_method.appPaymentMethod.app.license`, `payment_method.appPaymentMethod.app`.`active` as `payment_method.appPaymentMethod.app.active`, `payment_method.appPaymentMethod.app`.`configurable` as `payment_method.appPaymentMethod.app.configurable`, `payment_method.appPaymentMethod.app`.`privacy` as `payment_method.appPaymentMethod.app.privacy`, `payment_method.appPaymentMethod.app`.`version` as `payment_method.appPaymentMethod.app.version`, `payment_method.appPaymentMethod.app`.`icon` as `payment_method.appPaymentMethod.app.iconRaw`, `payment_method.appPaymentMethod.app`.`app_secret` as `payment_method.appPaymentMethod.app.appSecret`, `payment_method.appPaymentMethod.app`.`modules` as `payment_method.appPaymentMethod.app.modules`, `payment_method.appPaymentMethod.app`.`main_module` as `payment_method.appPaymentMethod.app.mainModule`, `payment_method.appPaymentMethod.app`.`cookies` as `payment_method.appPaymentMethod.app.cookies`, `payment_method.appPaymentMethod.app`.`allow_disable` as `payment_method.appPaymentMethod.app.allowDisable`, `payment_method.appPaymentMethod.app`.`base_app_url` as `payment_method.appPaymentMethod.app.baseAppUrl`, `payment_method.appPaymentMethod.app`.`allowed_hosts` as `payment_method.appPaymentMethod.app.allowedHosts`, `payment_method.appPaymentMethod.app`.`template_load_priority` as `payment_method.appPaymentMethod.app.templateLoadPriority`, `payment_method.appPaymentMethod.app`.`checkout_gateway_url` as `payment_method.appPaymentMethod.app.checkoutGatewayUrl`, `payment_method.appPaymentMethod.app`.`in_app_purchases_gateway_url` as `payment_method.appPaymentMethod.app.inAppPurchasesGatewayUrl`, `payment_method.appPaymentMethod.app`.`source_type` as `payment_method.appPaymentMethod.app.sourceType`, `payment_method.appPaymentMethod.app`.`source_config` as `payment_method.appPaymentMethod.app.sourceConfig`, `payment_method.appPaymentMethod.app`.`self_managed` as `payment_method.appPaymentMethod.app.selfManaged`, `payment_method.appPaymentMethod.app`.`integration_id` as `payment_method.appPaymentMethod.app.integrationId`, `payment_method.appPaymentMethod.app.integration`.`id` as `payment_method.appPaymentMethod.app.integration.id`, `payment_method.appPaymentMethod.app.integration`.`label` as `payment_method.appPaymentMethod.app.integration.label`, `payment_method.appPaymentMethod.app.integration`.`access_key` as `payment_method.appPaymentMethod.app.integration.accessKey`, `payment_method.appPaymentMethod.app.integration`.`secret_access_key` as `payment_method.appPaymentMethod.app.integration.secretAccessKey`, `payment_method.appPaymentMethod.app.integration`.`last_usage_at` as `payment_method.appPaymentMethod.app.integration.lastUsageAt`, `payment_method.appPaymentMethod.app.integration`.`admin` as `payment_method.appPaymentMethod.app.integration.admin`, `payment_method.appPaymentMethod.app.integration`.`custom_fields` as `payment_method.appPaymentMethod.app.integration.customFields`, `payment_method.appPaymentMethod.app.integration`.`deleted_at` as `payment_method.appPaymentMethod.app.integration.deletedAt`, `payment_method.appPaymentMethod.app.integration`.`created_at` as `payment_method.appPaymentMethod.app.integration.createdAt`, `payment_method.appPaymentMethod.app.integration`.`updated_at` as `payment_method.appPaymentMethod.app.integration.updatedAt`, `payment_method.appPaymentMethod.app`.`acl_role_id` as `payment_method.appPaymentMethod.app.aclRoleId`, `payment_method.appPaymentMethod.app.aclRole`.`id` as `payment_method.appPaymentMethod.app.aclRole.id`, `payment_method.appPaymentMethod.app.aclRole`.`name` as `payment_method.appPaymentMethod.app.aclRole.name`, `payment_method.appPaymentMethod.app.aclRole`.`description` as `payment_method.appPaymentMethod.app.aclRole.description`, `payment_method.appPaymentMethod.app.aclRole`.`privileges` as `payment_method.appPaymentMethod.app.aclRole.privileges`, `payment_method.appPaymentMethod.app.aclRole`.`deleted_at` as `payment_method.appPaymentMethod.app.aclRole.deletedAt`, `payment_method.appPaymentMethod.app.aclRole`.`created_at` as `payment_method.appPaymentMethod.app.aclRole.createdAt`, `payment_method.appPaymentMethod.app.aclRole`.`updated_at` as `payment_method.appPaymentMethod.app.aclRole.updatedAt`, `payment_method.appPaymentMethod.app`.`created_at` as `payment_method.appPaymentMethod.app.createdAt`, `payment_method.appPaymentMethod.app`.`updated_at` as `payment_method.appPaymentMethod.app.updatedAt`, `payment_method.appPaymentMethod.app.translation.label`, `payment_method.appPaymentMethod.app.translation.label` as `payment_method.appPaymentMethod.app.label`, `payment_method.appPaymentMethod.app.translation.description`, `payment_method.appPaymentMethod.app.translation.description` as `payment_method.appPaymentMethod.app.description`, `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions` as `payment_method.appPaymentMethod.app.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation.customFields`, `payment_method.appPaymentMethod.app.translation.customFields` as `payment_method.appPaymentMethod.app.customFields`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app` `payment_method.appPaymentMethod.app` ON `payment_method.appPaymentMethod`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN `integration` `payment_method.appPaymentMethod.app.integration` ON `payment_method.appPaymentMethod.app`.`integration_id` = `payment_method.appPaymentMethod.app.integration`.`id` LEFT JOIN `acl_role` `payment_method.appPaymentMethod.app.aclRole` ON `payment_method.appPaymentMethod.app`.`acl_role_id` = `payment_method.appPaymentMethod.app.aclRole`.`id` LEFT JOIN (SELECT `payment_method.appPaymentMethod.app.translation`.`app_id`, `payment_method.appPaymentMethod.app.translation`.`label` as `payment_method.appPaymentMethod.app.translation.label`, `payment_method.appPaymentMethod.app.translation`.`description` as `payment_method.appPaymentMethod.app.translation.description`, `payment_method.appPaymentMethod.app.translation`.`privacy_policy_extensions` as `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation`.`custom_fields` as `payment_method.appPaymentMethod.app.translation.customFields` FROM `app_translation` `payment_method.appPaymentMethod.app.translation` WHERE `payment_method.appPaymentMethod.app.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.appPaymentMethod.app.app_translation` ON `payment_method.appPaymentMethod.app.app_translation`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (0x2EB76B63B549A0DE4FAE2D0677C09062, 0x90D9E1A23C9F439AAE38CD63600F2CA6, 0xEC7FAE0127114E92BE41DA746D10BA4F, 0xA21678F0520940A28C5ABAD940D6C6E6, 0xFE088A05E62C4C0A824C7679A508F3DA, 0xEDE05B719B214143A4CB1C0216B852DE, 0xC5A51AE7B0DE4A14A9D6E0F0DE57EA97);

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/9ce87174d11c4c30b91dc1b548c7c65c', '/navigation/5c41ba70ff6848ed8e1f3e71197fede1', '/navigation/0d1e688faceb4ad4973452fa19f0fad3', '/navigation/37c9f4ebdc3749c6bc867fa6a6be7850', '/navigation/18ee12a594d648ee992d59d8b06814bb', '/navigation/0a37d5aaab18493b86fd92283e521116', '/navigation/c8abcf852a7f4bbab4b283f227c19186', '/navigation/da2bd7bab60d427b9ad6a8ff5d6d41f5', '/navigation/f93a5150a6e44b54bca9b705c4461629', '/navigation/dc2cde3edf7344c0a02ff89fdf145973', '/navigation/98d8930335974f328b9dc024274df1fa', '/navigation/8d617babcc824407be65f433120d4475', '/navigation/a8ef1573cd6341f2b3370060b8fab0fa', '/navigation/f63b83eab113462db329b2e556e0f707', '/navigation/d05d936531ff4f249af9a2760a4c3298', '/navigation/3b14a38f986540f99222941e010345b1', '/navigation/3b5fc3292d5d4e43ad8cffdef72fffc8', '/navigation/b3490710233746dd89b883a5b426d1ff', '/navigation/7564f911ca3f463ea6d71dc2bae38d8e', '/navigation/f1aaa440d9c24807a13d4824892e601a', '/navigation/77d0bc92baae47d9ae85a24e8580b3a1', '/navigation/517fe4876cfd445a816b729adfd234a5', '/navigation/b28c80b0624b42fe988b362778fd6ece', '/navigation/38bb944f75c94e41b48d314f9a7fac7a', '/navigation/ba9f753ce079492daee5e93b7995da8b', '/navigation/ba0028a7eb0c42adb94495eb2981a056', '/navigation/63966e3b1f354c51911ea73986428706', '/navigation/16b2dc19278f4c54814c1dea757cc95f', '/navigation/59f22cdd0ac348819424dc010bb00323', '/navigation/c402cf77325f4e538859d5464020b04d', '/navigation/1b57942ae8184dff9fa37f4962865beb', '/navigation/8fe606d72c664c569b61d63ba02b0efb', '/navigation/24eb9ee454064c3f9cea64a08600a8d2', '/navigation/7688bfd161f74af2abe182202082c0e1', '/navigation/cef2a24d9eb548d59c27ac888e030e4d', '/navigation/2e5766d5c380458e869a449c40a9c2f1', '/navigation/452aed62fa894c499a21e0fbf6b73d68', '/navigation/b609d61955044b9cbce6a03f873e3beb', '/navigation/249aaf170dee46c598fad04107e07d7d', '/navigation/7f68f0c553cd4f728d25ac6818734329', '/navigation/7c7349fe1f4942808b5665734c76c5f0', '/navigation/b1d0473d7f6b46c69ee5795f2007703f', '/navigation/1aa7ac59e2a54bf18765f9ae9898ea74', '/navigation/da8e49c4455e4a4580a113e46d847177', '/navigation/34fc58044fe5470f8a05b63cfccef252', '/navigation/7bba69950ea246d5a51848a37545a465', '/navigation/5716766de74b4642bd8d32303c033e62', '/navigation/7c4ea376bf8d432681e8960f6cfe9ad6', '/navigation/b6b22800f0754b5e93eb8a23a32bb8f3', '/navigation/15f84f73f75648efab9f2658fdc785de', '/navigation/741bd587b3634882b45248ff85055a7f', '/navigation/b9357de02d0e4c3895f54d5b329f457b', '/navigation/38515bdc76e5469ca5957fb24fa9fea0', '/navigation/d44eeedebad1472298add405017eac59', '/navigation/fad7f80993e246e89713c78badb95f97', '/navigation/3e89ed99295c4347b43c8e506c042793', '/navigation/db507833703c4108ad9888c15863dbf8', '/navigation/11715eb2f0c94d18809d9133f6fc0d57', '/navigation/32fa1e3e522840d9b799340c123079b1', '/navigation/fa27500e41594f5facdb9de0f918dd26', '/navigation/72a0fe1342c34e6c92ee2c32fbf89f4c', '/navigation/d93d9f1d6d514c07817238d9506d3d37', '/navigation/dea9c1dec57443afae4598a53726c1cc', '/navigation/7dacbbc7dab241fbb1ff8e76713107b1', '/navigation/4449de09b0f149a2bf6729ed7c7acb3b', '/navigation/912b8c38d2c2492aa47c6361b2888709', '/navigation/a593905fe4384a55b1746a7a59a7b14e', '/navigation/10bce8ec3a6b4b7581f9c11a75da488f', '/navigation/389c88fe523c41318e7c1062fc058f07', '/navigation/7e0dfd523c17497496f12ee49484f441', '/navigation/a5fb924345304ec7bcd0d020e9c17bd4', '/navigation/24f20bdcff24490c95bf5d1c4a78273b', '/navigation/d11940f24d2446ce8175aa9f1b6c2a01', '/navigation/327f5771ae734e13ab17dd6e05258bfc', '/navigation/3fe3e0e40dca46b48f80a9240524f131', '/navigation/25a27693a8694f199e9475c1436a203c', '/navigation/b07fe67e874d4a57bbe1dba39872de38', '/navigation/100985b58acb45d1b97deecbe0284b56', '/navigation/f333d0be0a5148eba31a844e10b19675', '/navigation/d90916c05abd477894d2730b6ead388e', '/navigation/b9c52fcad79642e7b1e01031ced3514c', '/navigation/70df7a52480c4df89bcbbc0591116a85', '/navigation/ac636b2f0dce4d8a9c6e0b26ba739991', '/navigation/09726efd2e344d018809521dc6e9f03a', '/navigation/8023dd2561634aeaa69eb5448a1fddb1', '/navigation/f0319948306740a9961314dfb0042847', '/navigation/185fc4e943d74763bbdffccc4cd237d0', '/navigation/122370a56a5a426ab9d3582446fedc8f', '/navigation/03aa0fae3ec0478ca47afbd4679b306e', '/navigation/4dd5115f4ffb430faca63284fc094990', '/navigation/3d4d205f9f5a44efa0714016481edfb5', '/navigation/7a70ef5d4ff84d66aa8ccf833d830f0d', '/navigation/11b3beb192cb449a92e3c3decb25626f', '/navigation/ac1e4e69602e412a905f04f1fa58b315', '/navigation/d7b370d6a9064d079599cff954d0bf5f', '/navigation/3799fee02d6b44c1a7af612e99ce05f7', '/navigation/c54dedf32db9422eb766fd2a95f63641', '/navigation/9e2e9f8817e54b179f44bf3a9e7109d6', '/navigation/6dadada8d4d94eb5938f243da894edd3', '/navigation/f703f58965c54cf9bd30f67910ae73bd', '/navigation/fb5f54ffba38466b82dd7561a21a470f', '/navigation/7d920e836fb9480383f0db0b0f31bcfb', '/navigation/6cbb13e8319746b295252ba231f8ccb5', '/navigation/7a583eeae3a54e998097e0b02f061034', '/navigation/79b6e0bd43834f758d2d68b062b15599', '/navigation/1a82802962e5424d913045102136ad62', '/navigation/3eecadf730784bce97fb236a617cea2f', '/navigation/47dde8d5bfe942eeb220229fdf01a9b0', '/navigation/495919f5c5eb4df6b56e2329fa36205c', '/navigation/655a95a52adf44cfae2f8ec407f01eb7', '/navigation/7056b260a9f046cd8361e4612d152544', '/navigation/7a7a8b02b4c847dba459dc2366449402', '/navigation/b4317ddf192942b4acf974638a55a6e7', '/navigation/bb148ef9bf534effb04df41d9f089cd9', '/navigation/c300f54d8a3f40e4b9250de87b6774c8', '/navigation/cad63ca25101457a9fb5782144226bdf', '/navigation/d9951e7cf66f40bdac0fe62db927cd5e', '/navigation/e58a3aab928d4234b4afa6704a5b9e89', '/navigation/ed611dc48e2e46ea9c138e6af435a250', '/navigation/f6eda2b35b03409dbde24d63c1cff3bb', '/navigation/3b9ca2a595914abd8b89d80d5fb563f7', '/navigation/865218d0f2d04fdfabc863b168572c3a', '/navigation/ec045db7e794414bb2e0da9628f1889b', '/navigation/7ff8a7dbef2741f79d605a3956a41695', '/navigation/0e1e5f01bd674feca89e1975461bfba2', '/navigation/e9e0a5ae436745258bfd2962889e6261', '/navigation/dbc0ebcdd64949d3b12b45828a4e02dc', '/navigation/52cd5881af234f82b070d5322e07fb2f', '/navigation/1aa0606d749646b8b85b831e215979d8', '/navigation/e4e99c24bd6248c3b058d52cc3846a73', '/navigation/4301bfc49e2e4b0fabb7faf7bf193cd9', '/navigation/90cc615d7f964de294fd2c08db2f11da', '/navigation/638b1a8c89eb447fa5b9309e23c516c6', '/navigation/c241adafc7f4489591b5a900e1f74b3d', '/navigation/3d56978cc322445ea797e2d293f59d14', '/navigation/7bdc35385b6d4d62a6617931054eaf40', '/navigation/7dbee4d90ffd4ea3812a9e5708a31ea5', '/navigation/f5c0f5aad87b448e92ebef350429f394', '/navigation/a4d7a72ce94d4e5bb6a3d6d4132cb7d5', '/navigation/b1578057db48402e962d47b8952efdad', '/navigation/61f69521a9364a0dbfcdaede58699994', '/navigation/f508a3368f8d4b52aa4c43ad190e1652', '/navigation/d7e5330e9ee34783a062c4bd03a30e47', '/navigation/85cc4880c91c48b39809047f9d40eaa9', '/navigation/40b5eb1cd4254595a1c267cc39c22ed9', '/navigation/60f67c2e667547bd920d81011bd2d1e0', '/navigation/773e378645384c43a953c4657b52ac2d', '/navigation/a80248dda2c948139d69ba6b17aaa7b2', '/navigation/a65df1804b32440bacd41f2c6c7bf050', '/navigation/2f89d3634eb34a4fa8f48d7f34223060', '/navigation/3c8c5cace09e46739dc8edb921056a11', '/navigation/4f4e44a80ccb423fbfdee3a533c8912e', '/navigation/c2995806171d411abf4d6c1e2e4ce19f', '/navigation/bb00cf016ce940d59231e84e5cc22411', '/navigation/4c461f5c87c84957af7414ee63691064', '/navigation/36942c06013140d69eed3c3d449bfd2f', '/navigation/f5db809d9ced4862a5c78175128851b5', '/navigation/ac7385cf33424bdeb8be20cd6005edb8', '/navigation/97b82eaf669c48668d7ee1178a5e7c89', '/navigation/2b6e8ffd55194259816ffb3487e84455', '/navigation/96e1ddd87550479a97ca53a03072f6ba', '/navigation/65b04047845740db99095816574dc1a7', '/navigation/32b456c296ef497faee5d38ea21221b1', '/navigation/7aab82cefbc840baa65d5f91ba15bfee', '/navigation/b89dfd2888b24ff196a2283bca3b7132', '/navigation/7c4ee2a0fe2c4a5e96a5cb5bd1feb88b', '/navigation/01d5c06b6e414f51a3e0636af2b9c8b7', '/navigation/2afaffe811b54d57a7a9534bb8b911cf', '/navigation/53aa0e82e8944be1a220404d1673784e', '/navigation/5f44ee6aed8f470d822989d83652630e', '/navigation/63e0194e02254830a75a30188a32b24c', '/navigation/754e16e6cfe74659857778d69c2a5aa1', '/navigation/b71fd1af9f524a278889f8884255aaf6', '/navigation/c0bae8c1a1604c31b149a79f8ee17386', '/navigation/9a4994cee0094c329f4d9d143ba37328', '/navigation/fbaf4ebe6c7b44d799b65d9d14ab272a', '/navigation/856608b7b8b84727878bfc4d2e70ffd6', '/navigation/ad044b2c094e449cbe32ff35383f3cc3', '/navigation/3dbc31a7768d46d9a638a915d9584c9e', '/navigation/56b94fe951cc455c93098ffbf2701c8a', '/navigation/d12169cf59194894a1c4a3984a7a6864', '/navigation/a581d7b492d647d3bfda04e5a15429c5', '/navigation/cd288aa5274549669165dfa78bde4f7e', '/navigation/ebdb4cf2cc7a4f8dbe00fa428b8ae24b', '/navigation/9f826c0034fd4655ab2f7ef9d049a095', '/navigation/18b75ef8dc4f4529b5ce977ebd9a379e', '/navigation/f79bbfd3896f40aeace09999bf8c84d9', '/navigation/083913607b3d4b698b5967d2fe59d79f', '/navigation/09adc366b5434d958b49206bac6a9a13')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x2A40648F0F2543B48E555C2D326694B8 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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`.`checkout_gateway_url` as `app.checkoutGatewayUrl`,
  `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`,
  `app`.`source_type` as `app.sourceType`,
  `app`.`source_config` as `app.sourceConfig`,
  `app`.`self_managed` as `app.selfManaged`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`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`,
  `app.translation.label` as `app.label`,
  `app.translation.description`,
  `app.translation.description` as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  `app.translation.customFields` as `app.customFields`
FROM
  `app`
  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`
  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`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.`language_id` = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
WHERE
  (
    `app`.`active` = ?
    AND NOT (
      `app`.`checkout_gateway_url` <=> ?
    )
  )