Symfony Profiler

# 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.netiAccessManagerCategoryRule`.`id` as `category.netiAccessManagerCategoryRule.id`,
  `category.netiAccessManagerCategoryRule`.`category_id` as `category.netiAccessManagerCategoryRule.categoryId`,
  `category.netiAccessManagerCategoryRule`.`category_version_id` as `category.netiAccessManagerCategoryRule.categoryVersionId`,
  `category.netiAccessManagerCategoryRule`.`rule_id` as `category.netiAccessManagerCategoryRule.ruleId`,
  `category.netiAccessManagerCategoryRule`.`created_at` as `category.netiAccessManagerCategoryRule.createdAt`,
  `category.netiAccessManagerCategoryRule`.`updated_at` as `category.netiAccessManagerCategoryRule.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`,
  COALESCE(
    `category.media.translation.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `category.media.translation.createdAt`,
  `category.media.translation.updatedAt`,
  `category.media.translation.mediaId`,
  `category.media.translation.languageId`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name as `category.translation.name`,
      `category.translation`.breadcrumb as `category.translation.breadcrumb`,
      `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`,
      `category.translation`.custom_fields as `category.translation.customFields`,
      `category.translation`.created_at as `category.translation.createdAt`,
      `category.translation`.updated_at as `category.translation.updatedAt`,
      `category.translation`.category_id as `category.translation.categoryId`,
      `category.translation`.language_id as `category.translation.languageId`,
      `category.translation`.category_version_id as `category.translation.categoryVersionId`
    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 `neti_access_manager_category_rule` `category.netiAccessManagerCategoryRule` ON `category`.`id` = `category.netiAccessManagerCategoryRule`.`category_id`
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.media_id,
      `category.media.translation`.title as `category.media.translation.title`,
      `category.media.translation`.alt as `category.media.translation.alt`,
      `category.media.translation`.custom_fields as `category.media.translation.customFields`,
      `category.media.translation`.created_at as `category.media.translation.createdAt`,
      `category.media.translation`.updated_at as `category.media.translation.updatedAt`,
      `category.media.translation`.media_id as `category.media.translation.mediaId`,
      `category.media.translation`.language_id as `category.media.translation.languageId`
    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.netiAccessManagerCategoryRule`.`id` as `category.netiAccessManagerCategoryRule.id`, `category.netiAccessManagerCategoryRule`.`category_id` as `category.netiAccessManagerCategoryRule.categoryId`, `category.netiAccessManagerCategoryRule`.`category_version_id` as `category.netiAccessManagerCategoryRule.categoryVersionId`, `category.netiAccessManagerCategoryRule`.`rule_id` as `category.netiAccessManagerCategoryRule.ruleId`, `category.netiAccessManagerCategoryRule`.`created_at` as `category.netiAccessManagerCategoryRule.createdAt`, `category.netiAccessManagerCategoryRule`.`updated_at` as `category.netiAccessManagerCategoryRule.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`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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 `neti_access_manager_category_rule` `category.netiAccessManagerCategoryRule` ON `category`.`id` = `category.netiAccessManagerCategoryRule`.`category_id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` 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 '%|018fb99362aa7536afc0bb8feb2f4400|%' AND (`category`.`level` > 1 AND `category`.`level` <= 7)));

# 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`,
  COALESCE(
    `theme.translation.description`,
    `theme.translation.description`
  ) as `theme.description`,
  `theme.translation.labels`,
  COALESCE(
    `theme.translation.labels`, `theme.translation.labels`
  ) as `theme.labels`,
  `theme.translation.helpTexts`,
  COALESCE(
    `theme.translation.helpTexts`, `theme.translation.helpTexts`
  ) as `theme.helpTexts`,
  `theme.translation.customFields`,
  COALESCE(
    `theme.translation.customFields`,
    `theme.translation.customFields`
  ) as `theme.customFields`,
  `theme.translation.createdAt`,
  `theme.translation.updatedAt`,
  `theme.translation.themeId`,
  `theme.translation.languageId`
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`,
      `theme.translation`.created_at as `theme.translation.createdAt`,
      `theme.translation`.updated_at as `theme.translation.updatedAt`,
      `theme.translation`.theme_id as `theme.translation.themeId`,
      `theme.translation`.language_id as `theme.translation.languageId`
    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`, COALESCE(`theme.translation.description`,`theme.translation.description`) as `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) as `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `theme.translation.languageId` 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`, `theme.translation`.created_at as `theme.translation.createdAt`, `theme.translation`.updated_at as `theme.translation.updatedAt`, `theme.translation`.theme_id as `theme.translation.themeId`, `theme.translation`.language_id as `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`;

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

# 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/018fb9ebed5f734aaec657de83a54872', '/navigation/018fb99a5f317aae96d160e4af370d02', '/navigation/018fb99af2577450b65296d2d0fe6d0b', '/navigation/018fb99b03f571d999d678e69fdc4cd0', '/navigation/018fb99baaf57e03a0bd8208b2548999', '/navigation/018fb99b2fbc776aa229b80b1b555fd9', '/navigation/018fb99b6a7178438a56efae29f00b67', '/navigation/018fb99b94e27df4862243ab1b5a7319', '/navigation/018fb99bc6b1734e8a4b3259d5234d6c', '/navigation/018fb9e53b217f049cc770923ac745e7', '/navigation/018fb9e751397b37877eb79ef073acab', '/navigation/018fb9e76c7a74d4a6b13197fd5bf475', '/navigation/018fb9e776e97371ab21391165c3fb4a', '/navigation/018fb9e783377e1ab9ef203df079f676', '/navigation/018fb9e7949974b28b1341e9725dbae3', '/navigation/018fb9e79c687895ac4eef63ecc010f9', '/navigation/018fb9e7a66a7510812d7ba616083daa', '/navigation/018fb9e7b5e17f9da2271e1058df8f49', '/navigation/018fb9e7c4947769bf7bb6d805b19519', '/navigation/018fb9e7d1147ae29d8b7e5ff1d50e72', '/navigation/018fb9e4ff0873eeb17a3b7caba5044f', '/navigation/018fb9e66ba379a4809ed84b118bb800', '/navigation/018fb9e67fbb7c8eadb0d23083e8624e', '/navigation/018fb9e6890d753ebd84bd86a7089e90', '/navigation/018fb9e51c0c74dfb2c5e0c7b340f1b2', '/navigation/018fb9e6ae4a7d78bdf2d34d95e7d117', '/navigation/018fb9e6bd327b4f800ac639c6760796', '/navigation/018fb9e6d17f72a5a30e05629e794f85', '/navigation/018fb9e6e3db790a81a9f27a513ea47d', '/navigation/018fb9e6ed4378afbf32ebc31185d9a7', '/navigation/018fb9e6fa667c5a9d346f1d9488f27e', '/navigation/018fb9e70f147ec2ad82c921cb7c09c5', '/navigation/018fb9e71aef75998a6746ff518905f7', '/navigation/018fb9e72920782bacb1f3b2288259b0', '/navigation/018fb9e5ded579638a1ecd2697b794e1', '/navigation/018fb9eb70047b5180c7f9d26fd3f1f3', '/navigation/018fb9eb7f5a767ea6826ecaa4a9845d', '/navigation/018fb9eb934d7e46b34fd49f1e301bec', '/navigation/018fb9eba04f736c9c2180220dcedf14', '/navigation/018fb9ebd17472c7a73488ca3d0b6aac', '/navigation/018fb9ebe12775e0bd256611fd023eda', '/navigation/018fb9ec0720778195085f6180c93f57', '/navigation/018fb9ec100779e58c0c33ebf7bd8ea8', '/navigation/018fb9e5b41e7f4aa685ed2f8253c0db', '/navigation/018fb9e85171752483d8e4a7f769764c', '/navigation/018fb9e862a277f78c52fd8d7e01b951', '/navigation/018fb9e875657ee6840abe6b73acf1da', '/navigation/018fb9e891e87218976eb8ef1a9d7840', '/navigation/018fb9e8e01478b09fffe7c067353154', '/navigation/018fb9e8f89c7915b11d2c4bf3f87a50', '/navigation/018fb9e90c497af7a82be3955b416f4c', '/navigation/018fb9e93dc67288858fdaef7735e695', '/navigation/018fb9e95ffe7b0db5283e39a1d99bb7', '/navigation/018fb9e972af76c7bb95db95d6185e3a', '/navigation/018fb9e5c57c79229addddac8ef947fb', '/navigation/018fb9e9c4a970748b7ce9f01589e321', '/navigation/018fb9e9dc0a76e7ac71fa9aa4dd91b2', '/navigation/018fb9e9e9bb74c6844bc4ec8262148a', '/navigation/018fb9e9f7e47a97b1d32bf5366b2443', '/navigation/018fb9ea06df72ddbc9e66d57f44dbfa', '/navigation/018fb9ea2a7773d98f2082f5718b4e55', '/navigation/018fb9eac738726caff2c759b64611c7', '/navigation/018fb9eafc5172c8b59739862a263cda', '/navigation/018fb9eb0ff075049c6f1729d18eebc5', '/navigation/018fb9eb165e75c6a3c0cce0fe0ef4af', '/navigation/018fb9eb1e18790ba7ef8259a78d3130', '/navigation/018fb9e5f4e875cba73ab7ddf18e00a0', '/navigation/018fb9ec62a574fd90a6dea6aa6c9c67', '/navigation/018fb9ec74767a8ebd74669cd178e40c', '/navigation/018fb9ec7d5c7f58a1233f2cd161a65a', '/navigation/018fb9ec93617b0a9df933aa3648eafa', '/navigation/018fb9ecaef37024af88838e819841c6', '/navigation/018fb9ecbf7f76888a602b2b8db3bb11', '/navigation/018fb9ed12387022a7f04ec12338c8b5', '/navigation/018fb9ed30e67a6baf11757ce3fbd82e', '/navigation/018fb9ed40a87bffaa90850568e27c5c', '/navigation/018fb9ed4a887e89abc3791205c341a5', '/navigation/018fb9e56aa67806bef694d820bbb6a6', '/navigation/018fb9e809477650a7e8d35060410dd6', '/navigation/018fb9e81670792e8b332e2175319289', '/navigation/018fb9e827687bc6aeafe0378cb2cd99', '/navigation/018fb9e4f58d7b07a14e3f61c88ae3cc', '/navigation/018fb9e62e0d716aaaf0a111bdff7d3f', '/navigation/018fb9e58e9972f3aa746c960c2ccd22', '/navigation/018fb9b53f8672aab81659aa9c1a3599', '/navigation/018fb9e28f997b29ba5c0033ee8c157a', '/navigation/018fb9e2a40778cdbaa660dd2dccac48', '/navigation/018fb9e2bbda7410b69cb7ec147c5bda', '/navigation/018fb9e2c6747369b6290a885b4754e0', '/navigation/018fb9e2cef87904bf3c327ca308591d', '/navigation/018fb9e2f9287ea2a3e4ad8a8efd66f7', '/navigation/018fb9e3086a775e84073a160cab83cc', '/navigation/018fb9e31735780eb9eb077be5a882aa', '/navigation/018fb9e326827b13b1aa53ef3c0e6de5', '/navigation/018fb9e332dc796f8a396514415a13ed', '/navigation/018fb9e342567c6cbbaa1d06045c0f74', '/navigation/018fb9e3523c724cbca3c03b99506e79', '/navigation/018fb9e37001789faaa0f7767cee7432', '/navigation/018fb9b5521d7ad2900f82f4453f4bf5', '/navigation/018fb9e1e8cf7169a39848e5d4211a19', '/navigation/018fb9e1f5787bac8e343e03b0996d67', '/navigation/018fb9e20180775ca156f6e999a2c282', '/navigation/018fb9e20ab974d89a3ea1651a256d20', '/navigation/018fb9e2150c768aaa33fbed4e408761', '/navigation/018fb9e220717f12bc3e92fbd1389648', '/navigation/018fb9e2315972b0bb8a183905e5e6c2', '/navigation/018fb9b58e777801b29ad89ce2aeadce', '/navigation/018fb9e02c477d8aaaedc7b46db5130d', '/navigation/018fb9e04ee87a27ae1769297fbc0703', '/navigation/018fb9e0851f7cb4baeff01a9092400c', '/navigation/018fb9e0a5cc74de82fa21366ddf4e85', '/navigation/018fb9e0b27176a5bc9ed31cae50d218', '/navigation/018fb9e0bcef7102bcd85ad8dc135fb1', '/navigation/018fb9e0ce2273cbaaeaa2c29119961a', '/navigation/018fb9e0e1c0785094b17ad9f9bd01cc', '/navigation/018fb9e0ec35778e8d12cd809ca4ea36', '/navigation/018fb9e1057e791d91e8eaf920d46976', '/navigation/018fb9e113dd7d31ab46beab27a20c80', '/navigation/018fb9e12bd8726cb86aed2c73afe278', '/navigation/018fb9e151657c0b8dea3058e1b07dea', '/navigation/018fb9b59c1a7223bd2ec0efc83d73fe', '/navigation/018fb9df52277ba5976855a26e966597', '/navigation/018fb9df6f7370a0a13c73d9bdc16a11', '/navigation/018fb9df78dd75c58483ac7ff08a72c2', '/navigation/018fb9dfabef7b5baa6e5d702fba4d44', '/navigation/018fb9b529d97e88ad5701526a05ce3a', '/navigation/018fb9e3b814708687169b219d562346', '/navigation/018fb9e3cca572748012d30e08c59c59', '/navigation/018fb9e3f0c57e3b90105e5f4962d3cb', '/navigation/018fb9e3fb17701e829f3fd1a3fb2333', '/navigation/018fb9b5c39c7276844af0cd1b1a3d66', '/navigation/018fb9c9eb967b48bbf9039561fd7fdf', '/navigation/018fb9c9f89571e5a3aa1e95ef432fda', '/navigation/018fb9ca09b87ae4a1e4d243dac324e5', '/navigation/018fb9b5cf447c88b87fc9e8225ebba3', '/navigation/018fb9c8ed697817b79651205b003195', '/navigation/018fb9c901c7731c8a770a9df6003a5e', '/navigation/018fb9c9185d73d9b42be11d9b3566ca', '/navigation/018fb9c932f879398d62df6f3f2e7132', '/navigation/018fb9c9445b7643839f5291d2b3db63', '/navigation/018fb9c972847975b13071cd84a84f07', '/navigation/018fb9b5dc3573e88848529340b48668', '/navigation/018fb9c894267661b17b5111aef43f97', '/navigation/018fb9c8a8c77a76a85a2c2d575b0818', '/navigation/018fb9c8b4f273c2aea88b6d1fc4b184', '/navigation/018fb99df46d7c718582bf6b65809fcb', '/navigation/018fb99f0a7a745b97ea12f5d8a6845c', '/navigation/018fb99f198173df94e8a94799b0f027', '/navigation/018fb99f33c07b9db399ce1e76915c26', '/navigation/018fb99f95277d81b43378719f4ca798', '/navigation/018fb99e026b79769be17e588c0ad5ef', '/navigation/018fb99e5bc77e6dafdf5ef840e76d19', '/navigation/018fb99e76c97b39ae109ce2a0eabdc1', '/navigation/018fb99e84e775fda2a3564e91ffbdd7', '/navigation/018fb99e94d474de8b72168b4099c1b4', '/navigation/018fb99eb33c79bcbf05082afa370085', '/navigation/018fb99eba047dd3b25edeafb7de37a6', '/navigation/018fb99ec26c7ba4a2fefffbb0725078', '/navigation/018fb99ed68879718a4cd44745730974', '/navigation/018fb99ee3297f1ebe750dcda2c20ed7', '/navigation/018fb99e0ffb78908b84f5ae0a14b78c', '/navigation/018fb99e392278408a16cc3acf6359ab', '/navigation/018fb9b30c8b734b8550db227cec1356', '/navigation/018fb9b320f172aa9871a6889d055469', '/navigation/018fb9b3357c7f2ca55a908fe2329cbb', '/navigation/018fb9b392fb7cb19f7ed79d9ffdc9ce', '/navigation/018fb9b3bc2c77e59b61a6b886cb1b1a', '/navigation/018fb9b3d2c878cfbb63ce0640dd4258', '/navigation/018fb9b3f749736e9d88c79c3fe4e8ee', '/navigation/018fb9b40ebf77d9911418c6eea81b54', '/navigation/018fb9b42198798589038c1f43840745', '/navigation/018fb9b449d67a45a2ce32325b8c3720', '/navigation/018fb9ab8fcd71d7ad12c91d0823f646', '/navigation/018fb9ac92607e97aff826f2a11c30d0', '/navigation/018fb9accb307dda8ad7c5d496ae72c6', '/navigation/018fb9ab9c0a7a8bbee3f205aa7385f4', '/navigation/018fb9abfc5779b78691457d2755dc89', '/navigation/018fb9ac4ec77075982a74d5e99ba0d1', '/navigation/018fb9ac6ce779aeb2635eee229953ed', '/navigation/018fb9a8153d7e079f5d37a656b0cf17', '/navigation/018fb9aa73757087aca06138a2c13a2b', '/navigation/018fb9aa85cf7070b9c245379b414269', '/navigation/018fb9aaa95a70e8a3109587de893204', '/navigation/018fb9a825177fab92a0eae91854cd68', '/navigation/018fb9a9fddb736992a82e6abab4dcee', '/navigation/018fb9aa3bc673fcbd30547da2a837f0', '/navigation/018fb9aa49657f149786012740806988', '/navigation/018fb9a83ad57bbd911b7e39a8963978', '/navigation/018fb9a9c1b97474b6de671ac0d43da5', '/navigation/018fb9a9d12a77a7a1e6b1646ab524f0', '/navigation/018fb9a8513172f393a27a191d2c8b48', '/navigation/018fb9a8dd8b7b2eb9ec49f60a13d129', '/navigation/018fb9a8f0a276bca93dd7a13448c282', '/navigation/018fb9a901e275b9979bd758bee7971a', '/navigation/018fb9a924c37baba56198c88b8f4f75', '/navigation/018fb9a931e4725e9e529fb55bf6bcdd', '/navigation/018fb9a94e667a47a823205b6e259425', '/navigation/018fb9a864317aa18c700000ca6cd191', '/navigation/018fb9a8732c766da06cf2ae994e0ca4', '/navigation/018fb9a880697b8992007bce88e8e3c8', '/navigation/018fb9a892c07621b252da4fa386d49a', '/navigation/018fb9a89edd7f0fbf65a8ce90f1e435', '/navigation/018fb9a8ac567d90b08f4cfe9690cc60', '/navigation/018fb9a8b3f677c7961a1697145d6935', '/navigation/018fb99c045075faa61e5126982e880a', '/navigation/018fb99cf37d7b2d9735a4cb5bc66d2f', '/navigation/018fb99d0aea74089dbee1b8804f1eaf', '/navigation/018fb99d1a4c7bcca262db2755f00e11', '/navigation/018fb99d2b6d7f558ed79bf2ad81fde2', '/navigation/018fb99d3e037373ae5bffa0a4e57182', '/navigation/018fb99d4c907b2a8d647954ffbf5f3e', '/navigation/018fb99d5e62778e920482accbf6bf06', '/navigation/018fb99c2aca7e56883d582b96cc46fd', '/navigation/018fb99c57317cb6aa27ab5c090bbad6', '/navigation/018fb99c7da27fdab74981c9bd3cbfc2', '/navigation/018fb99c8b897e83ba0a40b7dfcdabb0', '/navigation/018fb99ca0497b6dadf4ce82c6ad5f06', '/navigation/018fb99cad39726a92679989a47c222e', '/navigation/df0f006873d14d8f91fd8f6b959321c5', '/navigation/47f7b36c20814e249832fb35c1e1b43e', '/navigation/b71b339563944ce48b9832e25be4a49e', '/navigation/d01ec56ca49e4fe5af8bc2f840af25cb', '/navigation/3206a028f7854e0a87975ad54b90845d', '/navigation/0b2ad322abaa46e480c45858f7e43de5', '/navigation/e97b1654f6a5499b85b19c4f1b0f49b5')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xF0FA6820DD87485D8C782713E160C2E7 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS name,
  `script`.`script` AS script,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` = 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

# 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.netiAccessManagerCategoryRule`.`id` as `category.netiAccessManagerCategoryRule.id`,
  `category.netiAccessManagerCategoryRule`.`category_id` as `category.netiAccessManagerCategoryRule.categoryId`,
  `category.netiAccessManagerCategoryRule`.`category_version_id` as `category.netiAccessManagerCategoryRule.categoryVersionId`,
  `category.netiAccessManagerCategoryRule`.`rule_id` as `category.netiAccessManagerCategoryRule.ruleId`,
  `category.netiAccessManagerCategoryRule`.`created_at` as `category.netiAccessManagerCategoryRule.createdAt`,
  `category.netiAccessManagerCategoryRule`.`updated_at` as `category.netiAccessManagerCategoryRule.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`,
  COALESCE(
    `category.media.translation.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `category.media.translation.createdAt`,
  `category.media.translation.updatedAt`,
  `category.media.translation.mediaId`,
  `category.media.translation.languageId`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name as `category.translation.name`,
      `category.translation`.breadcrumb as `category.translation.breadcrumb`,
      `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`,
      `category.translation`.custom_fields as `category.translation.customFields`,
      `category.translation`.created_at as `category.translation.createdAt`,
      `category.translation`.updated_at as `category.translation.updatedAt`,
      `category.translation`.category_id as `category.translation.categoryId`,
      `category.translation`.language_id as `category.translation.languageId`,
      `category.translation`.category_version_id as `category.translation.categoryVersionId`
    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 `neti_access_manager_category_rule` `category.netiAccessManagerCategoryRule` ON `category`.`id` = `category.netiAccessManagerCategoryRule`.`category_id`
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.media_id,
      `category.media.translation`.title as `category.media.translation.title`,
      `category.media.translation`.alt as `category.media.translation.alt`,
      `category.media.translation`.custom_fields as `category.media.translation.customFields`,
      `category.media.translation`.created_at as `category.media.translation.createdAt`,
      `category.media.translation`.updated_at as `category.media.translation.updatedAt`,
      `category.media.translation`.media_id as `category.media.translation.mediaId`,
      `category.media.translation`.language_id as `category.media.translation.languageId`
    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`.`id` IN (?)
  )

# 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.netiAccessManagerCategoryRule`.`id` as `category.netiAccessManagerCategoryRule.id`, `category.netiAccessManagerCategoryRule`.`category_id` as `category.netiAccessManagerCategoryRule.categoryId`, `category.netiAccessManagerCategoryRule`.`category_version_id` as `category.netiAccessManagerCategoryRule.categoryVersionId`, `category.netiAccessManagerCategoryRule`.`rule_id` as `category.netiAccessManagerCategoryRule.ruleId`, `category.netiAccessManagerCategoryRule`.`created_at` as `category.netiAccessManagerCategoryRule.createdAt`, `category.netiAccessManagerCategoryRule`.`updated_at` as `category.netiAccessManagerCategoryRule.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`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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 `neti_access_manager_category_rule` `category.netiAccessManagerCategoryRule` ON `category`.`id` = `category.netiAccessManagerCategoryRule`.`category_id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` 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`.`id` IN (0x018FB99362AA7536AFC0BB8FEB2F4400));