Symfony Profiler

SELECT
  `onco_compatibility_filter_object`.`id` as `onco_compatibility_filter_object.id`,
  `onco_compatibility_filter_object`.`parent_id` as `onco_compatibility_filter_object.parentId`,
  `onco_compatibility_filter_object`.`instance_number` as `onco_compatibility_filter_object.instanceNumber`,
  `onco_compatibility_filter_object`.`name` as `onco_compatibility_filter_object.name`,
  `onco_compatibility_filter_object`.`description` as `onco_compatibility_filter_object.description`,
  `onco_compatibility_filter_object`.`image` as `onco_compatibility_filter_object.image`,
  `onco_compatibility_filter_object`.`external_id` as `onco_compatibility_filter_object.externalIds`,
  `onco_compatibility_filter_object`.`kba` as `onco_compatibility_filter_object.kbas`,
  `onco_compatibility_filter_object`.`attribute_1` as `onco_compatibility_filter_object.attribute1`,
  `onco_compatibility_filter_object`.`attribute_2` as `onco_compatibility_filter_object.attribute2`,
  `onco_compatibility_filter_object`.`attribute_3` as `onco_compatibility_filter_object.attribute3`,
  `onco_compatibility_filter_object`.`alias_for_id` as `onco_compatibility_filter_object.aliasFor`,
  `onco_compatibility_filter_object`.`created_at` as `onco_compatibility_filter_object.createdAt`,
  `onco_compatibility_filter_object`.`updated_at` as `onco_compatibility_filter_object.updatedAt`
FROM
  `onco_compatibility_filter_object`
WHERE
  (
    `onco_compatibility_filter_object`.`id` = ?
  )

SELECT `onco_compatibility_filter_object`.`id` as `onco_compatibility_filter_object.id`, `onco_compatibility_filter_object`.`parent_id` as `onco_compatibility_filter_object.parentId`, `onco_compatibility_filter_object`.`instance_number` as `onco_compatibility_filter_object.instanceNumber`, `onco_compatibility_filter_object`.`name` as `onco_compatibility_filter_object.name`, `onco_compatibility_filter_object`.`description` as `onco_compatibility_filter_object.description`, `onco_compatibility_filter_object`.`image` as `onco_compatibility_filter_object.image`, `onco_compatibility_filter_object`.`external_id` as `onco_compatibility_filter_object.externalIds`, `onco_compatibility_filter_object`.`kba` as `onco_compatibility_filter_object.kbas`, `onco_compatibility_filter_object`.`attribute_1` as `onco_compatibility_filter_object.attribute1`, `onco_compatibility_filter_object`.`attribute_2` as `onco_compatibility_filter_object.attribute2`, `onco_compatibility_filter_object`.`attribute_3` as `onco_compatibility_filter_object.attribute3`, `onco_compatibility_filter_object`.`alias_for_id` as `onco_compatibility_filter_object.aliasFor`, `onco_compatibility_filter_object`.`created_at` as `onco_compatibility_filter_object.createdAt`, `onco_compatibility_filter_object`.`updated_at` as `onco_compatibility_filter_object.updatedAt` FROM `onco_compatibility_filter_object` WHERE (`onco_compatibility_filter_object`.`id` = 0x20DBF435069C4997A390244EB0FBABF0);

SELECT
  `onco_compatibility_filter_link`.`id` as `onco_compatibility_filter_link.id`,
  `onco_compatibility_filter_link`.`object_id` as `onco_compatibility_filter_link.objectId`,
  `onco_compatibility_filter_link`.`product_id` as `onco_compatibility_filter_link.productId`,
  `onco_compatibility_filter_link`.`attribute_1` as `onco_compatibility_filter_link.attribute1`,
  `onco_compatibility_filter_link`.`attribute_2` as `onco_compatibility_filter_link.attribute2`,
  `onco_compatibility_filter_link`.`attribute_3` as `onco_compatibility_filter_link.attribute3`,
  `onco_compatibility_filter_link`.`created_at` as `onco_compatibility_filter_link.createdAt`,
  `onco_compatibility_filter_link`.`updated_at` as `onco_compatibility_filter_link.updatedAt`
FROM
  `onco_compatibility_filter_link`
WHERE
  (
    `onco_compatibility_filter_link`.`product_id` = ?
  )

SELECT `onco_compatibility_filter_link`.`id` as `onco_compatibility_filter_link.id`, `onco_compatibility_filter_link`.`object_id` as `onco_compatibility_filter_link.objectId`, `onco_compatibility_filter_link`.`product_id` as `onco_compatibility_filter_link.productId`, `onco_compatibility_filter_link`.`attribute_1` as `onco_compatibility_filter_link.attribute1`, `onco_compatibility_filter_link`.`attribute_2` as `onco_compatibility_filter_link.attribute2`, `onco_compatibility_filter_link`.`attribute_3` as `onco_compatibility_filter_link.attribute3`, `onco_compatibility_filter_link`.`created_at` as `onco_compatibility_filter_link.createdAt`, `onco_compatibility_filter_link`.`updated_at` as `onco_compatibility_filter_link.updatedAt` FROM `onco_compatibility_filter_link` WHERE (`onco_compatibility_filter_link`.`product_id` = 0x00000000000000000000000041896084);

# 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`;

# 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 ('/detail/00000000000000000000000041896084', '/navigation/00000000000000000000000001724376', '/navigation/00000000000000000000000001724388', '/navigation/00000000000000000000000001724391', '/navigation/00000000000000000000000001724396', '/navigation/00000000000000000000000001994501', '/navigation/00000000000000000000000001994517', '/navigation/00000000000000000000000001994523', '/navigation/00000000000000000000000001724377', '/navigation/00000000000000000000000001724379', '/navigation/00000000000000000000000001724380', '/navigation/00000000000000000000000001724381', '/navigation/00000000000000000000000001724382', '/navigation/00000000000000000000000001724383', '/navigation/00000000000000000000000001724385', '/navigation/00000000000000000000000001724386', '/navigation/00000000000000000000000001724387', '/navigation/00000000000000000000000001724394', '/navigation/00000000000000000000000001774525', '/navigation/00000000000000000000000001957201', '/navigation/00000000000000000000000001985226', '/navigation/00000000000000000000000001994489', '/navigation/00000000000000000000000001994490', '/navigation/00000000000000000000000001994491', '/navigation/00000000000000000000000001994492', '/navigation/00000000000000000000000001994493', '/navigation/00000000000000000000000001994494', '/navigation/00000000000000000000000001994495', '/navigation/00000000000000000000000001994496', '/navigation/00000000000000000000000001994497', '/navigation/00000000000000000000000001994498', '/navigation/00000000000000000000000001994499', '/navigation/00000000000000000000000001994500', '/navigation/00000000000000000000000001724441', '/navigation/00000000000000000000000001845183', '/navigation/00000000000000000000000001995203', '/navigation/00000000000000000000000001995204', '/navigation/00000000000000000000000002078985', '/navigation/00000000000000000000000002078986', '/navigation/00000000000000000000000002078987', '/navigation/00000000000000000000000001994502', '/navigation/00000000000000000000000001994503', '/navigation/00000000000000000000000001994504', '/navigation/00000000000000000000000001994622', '/navigation/00000000000000000000000001994675', '/navigation/00000000000000000000000001994677', '/navigation/00000000000000000000000001994678', '/navigation/00000000000000000000000001994679', '/navigation/00000000000000000000000001994680', '/navigation/00000000000000000000000001994681', '/navigation/00000000000000000000000001994682', '/navigation/00000000000000000000000001994623', '/navigation/00000000000000000000000001994683', '/navigation/00000000000000000000000001994684', '/navigation/00000000000000000000000001994685', '/navigation/00000000000000000000000001994686', '/navigation/00000000000000000000000001994687', '/navigation/00000000000000000000000001994688', '/navigation/00000000000000000000000001994689', '/navigation/00000000000000000000000001994690', '/navigation/00000000000000000000000001994691', '/navigation/00000000000000000000000001994692', '/navigation/00000000000000000000000001994693', '/navigation/00000000000000000000000001994694', '/navigation/00000000000000000000000001994695', '/navigation/00000000000000000000000001994624', '/navigation/00000000000000000000000001994696', '/navigation/00000000000000000000000001994697', '/navigation/00000000000000000000000001994698', '/navigation/00000000000000000000000001994699', '/navigation/00000000000000000000000001994700', '/navigation/00000000000000000000000001994701', '/navigation/00000000000000000000000001994702', '/navigation/00000000000000000000000001994703', '/navigation/00000000000000000000000001994625', '/navigation/00000000000000000000000001994704', '/navigation/00000000000000000000000001994705', '/navigation/00000000000000000000000001994706', '/navigation/00000000000000000000000001994707', '/navigation/00000000000000000000000001994708', '/navigation/00000000000000000000000001994709', '/navigation/00000000000000000000000001994710', '/navigation/00000000000000000000000001994626', '/navigation/00000000000000000000000001994711', '/navigation/00000000000000000000000001994627', '/navigation/00000000000000000000000001994712', '/navigation/00000000000000000000000001994713', '/navigation/00000000000000000000000001994714', '/navigation/00000000000000000000000001994715', '/navigation/00000000000000000000000001994716', '/navigation/00000000000000000000000001994717', '/navigation/00000000000000000000000001994718', '/navigation/00000000000000000000000001994719', '/navigation/00000000000000000000000001994720', '/navigation/00000000000000000000000001994721', '/navigation/00000000000000000000000001994722', '/navigation/00000000000000000000000001994723', '/navigation/00000000000000000000000001994724', '/navigation/00000000000000000000000001994725', '/navigation/00000000000000000000000001994726', '/navigation/00000000000000000000000001994727', '/navigation/00000000000000000000000001994728', '/navigation/00000000000000000000000001994628', '/navigation/00000000000000000000000001994729', '/navigation/00000000000000000000000001994730', '/navigation/00000000000000000000000001994731', '/navigation/00000000000000000000000001994732', '/navigation/00000000000000000000000001994733', '/navigation/00000000000000000000000001994734', '/navigation/00000000000000000000000001994735', '/navigation/00000000000000000000000001994629', '/navigation/00000000000000000000000001994736', '/navigation/00000000000000000000000001994737', '/navigation/00000000000000000000000001994738', '/navigation/00000000000000000000000001994739', '/navigation/00000000000000000000000001994740', '/navigation/00000000000000000000000001994741', '/navigation/00000000000000000000000001995083', '/navigation/00000000000000000000000001994630', '/navigation/00000000000000000000000001994742', '/navigation/00000000000000000000000001994743', '/navigation/00000000000000000000000001994744', '/navigation/00000000000000000000000001994745', '/navigation/00000000000000000000000001994746', '/navigation/00000000000000000000000001994747', '/navigation/00000000000000000000000001994749', '/navigation/00000000000000000000000001994750', '/navigation/00000000000000000000000001994631', '/navigation/00000000000000000000000001994751', '/navigation/00000000000000000000000001994752', '/navigation/00000000000000000000000001994753', '/navigation/00000000000000000000000001994754', '/navigation/00000000000000000000000001994755', '/navigation/00000000000000000000000001994756', '/navigation/00000000000000000000000001994757', '/navigation/00000000000000000000000001994758', '/navigation/00000000000000000000000001994759', '/navigation/00000000000000000000000001994760', '/navigation/00000000000000000000000001994761', '/navigation/00000000000000000000000001994762', '/navigation/00000000000000000000000001994763', '/navigation/00000000000000000000000001994764', '/navigation/00000000000000000000000001994765', '/navigation/00000000000000000000000001994766', '/navigation/00000000000000000000000001994767', '/navigation/00000000000000000000000001994768', '/navigation/00000000000000000000000001994769', '/navigation/00000000000000000000000001994770', '/navigation/00000000000000000000000001994771', '/navigation/00000000000000000000000001994772', '/navigation/00000000000000000000000001994773', '/navigation/00000000000000000000000001994774', '/navigation/00000000000000000000000001994775', '/navigation/00000000000000000000000001994776', '/navigation/00000000000000000000000001994632', '/navigation/00000000000000000000000001994777', '/navigation/00000000000000000000000001994778', '/navigation/00000000000000000000000001994779', '/navigation/00000000000000000000000001994780', '/navigation/00000000000000000000000001994781', '/navigation/00000000000000000000000001994782', '/navigation/00000000000000000000000001994783', '/navigation/00000000000000000000000001994784', '/navigation/00000000000000000000000001994785', '/navigation/00000000000000000000000001994786', '/navigation/00000000000000000000000001994787', '/navigation/00000000000000000000000001994788', '/navigation/00000000000000000000000001994789', '/navigation/00000000000000000000000001994790', '/navigation/00000000000000000000000001994791', '/navigation/00000000000000000000000001994633', '/navigation/00000000000000000000000001994792', '/navigation/00000000000000000000000001994793', '/navigation/00000000000000000000000001994794', '/navigation/00000000000000000000000001994795', '/navigation/00000000000000000000000001994796', '/navigation/00000000000000000000000001994797', '/navigation/00000000000000000000000001994798', '/navigation/00000000000000000000000001994799', '/navigation/00000000000000000000000001994800', '/navigation/00000000000000000000000001994801', '/navigation/00000000000000000000000001994802', '/navigation/00000000000000000000000001994634', '/navigation/00000000000000000000000001994803', '/navigation/00000000000000000000000001994804', '/navigation/00000000000000000000000001994805', '/navigation/00000000000000000000000001994806', '/navigation/00000000000000000000000001994807', '/navigation/00000000000000000000000001994808', '/navigation/00000000000000000000000001994809', '/navigation/00000000000000000000000001994810', '/navigation/00000000000000000000000001994811', '/navigation/00000000000000000000000001994812', '/navigation/00000000000000000000000001994813', '/navigation/00000000000000000000000001994814', '/navigation/00000000000000000000000001994815', '/navigation/00000000000000000000000001994816', '/navigation/00000000000000000000000001994817', '/navigation/00000000000000000000000001994818', '/navigation/00000000000000000000000001994819', '/navigation/00000000000000000000000001994820', '/navigation/00000000000000000000000001994821', '/navigation/00000000000000000000000001994635', '/navigation/00000000000000000000000001994822', '/navigation/00000000000000000000000001994636', '/navigation/00000000000000000000000001994823', '/navigation/00000000000000000000000001994824', '/navigation/00000000000000000000000001994825', '/navigation/00000000000000000000000001994826', '/navigation/00000000000000000000000001994827', '/navigation/00000000000000000000000001994828', '/navigation/00000000000000000000000001994829', '/navigation/00000000000000000000000001994830', '/navigation/00000000000000000000000001994831', '/navigation/00000000000000000000000001994832', '/navigation/00000000000000000000000001994833', '/navigation/00000000000000000000000001995090', '/navigation/00000000000000000000000001994637', '/navigation/00000000000000000000000001994834', '/navigation/00000000000000000000000001994835', '/navigation/00000000000000000000000001994836', '/navigation/00000000000000000000000001994638', '/navigation/00000000000000000000000001994837', '/navigation/00000000000000000000000001994838', '/navigation/00000000000000000000000001994839', '/navigation/00000000000000000000000001994840', '/navigation/00000000000000000000000001994841', '/navigation/00000000000000000000000001994842', '/navigation/00000000000000000000000001994843', '/navigation/00000000000000000000000001994639', '/navigation/00000000000000000000000001994844', '/navigation/00000000000000000000000001994640', '/navigation/00000000000000000000000001994845', '/navigation/00000000000000000000000001994847', '/navigation/00000000000000000000000001994848', '/navigation/00000000000000000000000001994849', '/navigation/00000000000000000000000001994850', '/navigation/00000000000000000000000001994851', '/navigation/00000000000000000000000001994852', '/navigation/00000000000000000000000001994854', '/navigation/00000000000000000000000001994855', '/navigation/00000000000000000000000001994641', '/navigation/00000000000000000000000001994857', '/navigation/00000000000000000000000001994858', '/navigation/00000000000000000000000001994859', '/navigation/00000000000000000000000001994860', '/navigation/00000000000000000000000001994861', '/navigation/00000000000000000000000001994862', '/navigation/00000000000000000000000001994863', '/navigation/00000000000000000000000001994864', '/navigation/00000000000000000000000001994865', '/navigation/00000000000000000000000001994866', '/navigation/00000000000000000000000001994867', '/navigation/00000000000000000000000001994868', '/navigation/00000000000000000000000001994642', '/navigation/00000000000000000000000001994869', '/navigation/00000000000000000000000001994870', '/navigation/00000000000000000000000001994871', '/navigation/00000000000000000000000001994872', '/navigation/00000000000000000000000001994873', '/navigation/00000000000000000000000001994643', '/navigation/00000000000000000000000001994874', '/navigation/00000000000000000000000001994875', '/navigation/00000000000000000000000001994876', '/navigation/00000000000000000000000001994877', '/navigation/00000000000000000000000001994878', '/navigation/00000000000000000000000001994879', '/navigation/00000000000000000000000001994880', '/navigation/00000000000000000000000001994881', '/navigation/00000000000000000000000001994644', '/navigation/00000000000000000000000001994882', '/navigation/00000000000000000000000001994883', '/navigation/00000000000000000000000001994884', '/navigation/00000000000000000000000001994885', '/navigation/00000000000000000000000001994886', '/navigation/00000000000000000000000001994887', '/navigation/00000000000000000000000001994888', '/navigation/00000000000000000000000001994889', '/navigation/00000000000000000000000001994890', '/navigation/00000000000000000000000001994891', '/navigation/00000000000000000000000001994892', '/navigation/00000000000000000000000001994893', '/navigation/00000000000000000000000001994894', '/navigation/00000000000000000000000001994896', '/navigation/00000000000000000000000001994898', '/navigation/00000000000000000000000001994645', '/navigation/00000000000000000000000001994899', '/navigation/00000000000000000000000001994900', '/navigation/00000000000000000000000001994901', '/navigation/00000000000000000000000001994902', '/navigation/00000000000000000000000001994903', '/navigation/00000000000000000000000001994904', '/navigation/00000000000000000000000001994905', '/navigation/00000000000000000000000001994906', '/navigation/00000000000000000000000001994907', '/navigation/00000000000000000000000001994908', '/navigation/00000000000000000000000001994909', '/navigation/00000000000000000000000001994910', '/navigation/00000000000000000000000001994911', '/navigation/00000000000000000000000001994912', '/navigation/00000000000000000000000001994913', '/navigation/00000000000000000000000001994914', '/navigation/00000000000000000000000001995087', '/navigation/00000000000000000000000001994646', '/navigation/00000000000000000000000001994915', '/navigation/00000000000000000000000001994916', '/navigation/00000000000000000000000001994917', '/navigation/00000000000000000000000001994918', '/navigation/00000000000000000000000001994919', '/navigation/00000000000000000000000001994920', '/navigation/00000000000000000000000001994921', '/navigation/00000000000000000000000001994922', '/navigation/00000000000000000000000001994923', '/navigation/00000000000000000000000001994924', '/navigation/00000000000000000000000001994925', '/navigation/00000000000000000000000001994926', '/navigation/00000000000000000000000001994927', '/navigation/00000000000000000000000001994928', '/navigation/00000000000000000000000001994929', '/navigation/00000000000000000000000001994930', '/navigation/00000000000000000000000001994931', '/navigation/00000000000000000000000001994932', '/navigation/00000000000000000000000001994933', '/navigation/00000000000000000000000001994934', '/navigation/00000000000000000000000001994935', '/navigation/00000000000000000000000001994647', '/navigation/00000000000000000000000001994936', '/navigation/00000000000000000000000001994937', '/navigation/00000000000000000000000001994938', '/navigation/00000000000000000000000001994939', '/navigation/00000000000000000000000001994940', '/navigation/00000000000000000000000001994941', '/navigation/00000000000000000000000001994942', '/navigation/00000000000000000000000001994943', '/navigation/00000000000000000000000001994944', '/navigation/00000000000000000000000001994945', '/navigation/00000000000000000000000001994946', '/navigation/00000000000000000000000001994947', '/navigation/00000000000000000000000001994948', '/navigation/00000000000000000000000001994949', '/navigation/00000000000000000000000001994950', '/navigation/00000000000000000000000001994951', '/navigation/00000000000000000000000001994952', '/navigation/00000000000000000000000001994953', '/navigation/00000000000000000000000001995084', '/navigation/00000000000000000000000001995085', '/navigation/00000000000000000000000001994648', '/navigation/00000000000000000000000001994954', '/navigation/00000000000000000000000001994955', '/navigation/00000000000000000000000001994956', '/navigation/00000000000000000000000001994957', '/navigation/00000000000000000000000001994958', '/navigation/00000000000000000000000001994959', '/navigation/00000000000000000000000001994960', '/navigation/00000000000000000000000001994961', '/navigation/00000000000000000000000001994649', '/navigation/00000000000000000000000001994962', '/navigation/00000000000000000000000001994650', '/navigation/00000000000000000000000001994963', '/navigation/00000000000000000000000001994964', '/navigation/00000000000000000000000001994965', '/navigation/00000000000000000000000001994966', '/navigation/00000000000000000000000001994967', '/navigation/00000000000000000000000001994968', '/navigation/00000000000000000000000001994969', '/navigation/00000000000000000000000001994970', '/navigation/00000000000000000000000001994651', '/navigation/00000000000000000000000001994971', '/navigation/00000000000000000000000001994972', '/navigation/00000000000000000000000001994973', '/navigation/00000000000000000000000001994974', '/navigation/00000000000000000000000001994975', '/navigation/00000000000000000000000001994976', '/navigation/00000000000000000000000001994977', '/navigation/00000000000000000000000001994978', '/navigation/00000000000000000000000001994979', '/navigation/00000000000000000000000001994980', '/navigation/00000000000000000000000001994652', '/navigation/00000000000000000000000001994981', '/navigation/00000000000000000000000001994653', '/navigation/00000000000000000000000001994982', '/navigation/00000000000000000000000001994983', '/navigation/00000000000000000000000001994984', '/navigation/00000000000000000000000001994985', '/navigation/00000000000000000000000001994986', '/navigation/00000000000000000000000001994987', '/navigation/00000000000000000000000001994988', '/navigation/00000000000000000000000001994989', '/navigation/00000000000000000000000001994654', '/navigation/00000000000000000000000001994990', '/navigation/00000000000000000000000001994991', '/navigation/00000000000000000000000001994992', '/navigation/00000000000000000000000001994993', '/navigation/00000000000000000000000001994994', '/navigation/00000000000000000000000001994995', '/navigation/00000000000000000000000001994996', '/navigation/00000000000000000000000001994997', '/navigation/00000000000000000000000001994998', '/navigation/00000000000000000000000001994999', '/navigation/00000000000000000000000001995000', '/navigation/00000000000000000000000001995001', '/navigation/00000000000000000000000001995002', '/navigation/00000000000000000000000001994655', '/navigation/00000000000000000000000001995003', '/navigation/00000000000000000000000001995004', '/navigation/00000000000000000000000001995005', '/navigation/00000000000000000000000001995006', '/navigation/00000000000000000000000001995007', '/navigation/00000000000000000000000001995008', '/navigation/00000000000000000000000001995009', '/navigation/00000000000000000000000001995010', '/navigation/00000000000000000000000001995011', '/navigation/00000000000000000000000001995012', '/navigation/00000000000000000000000001995013', '/navigation/00000000000000000000000001995014', '/navigation/00000000000000000000000001995015', '/navigation/00000000000000000000000001995016', '/navigation/00000000000000000000000001995017', '/navigation/00000000000000000000000001995018', '/navigation/00000000000000000000000001995019', '/navigation/00000000000000000000000001994656', '/navigation/00000000000000000000000001995020', '/navigation/00000000000000000000000001995021', '/navigation/00000000000000000000000001995022', '/navigation/00000000000000000000000001995023', '/navigation/00000000000000000000000001995024', '/navigation/00000000000000000000000001995025', '/navigation/00000000000000000000000001995026', '/navigation/00000000000000000000000001995027', '/navigation/00000000000000000000000001995028', '/navigation/00000000000000000000000001995029', '/navigation/00000000000000000000000001995030', '/navigation/00000000000000000000000001995031', '/navigation/00000000000000000000000001995032', '/navigation/00000000000000000000000001994657', '/navigation/00000000000000000000000001995033', '/navigation/00000000000000000000000001995034', '/navigation/00000000000000000000000001995035', '/navigation/00000000000000000000000001995036', '/navigation/00000000000000000000000001995038', '/navigation/00000000000000000000000001995039', '/navigation/00000000000000000000000001995040', '/navigation/00000000000000000000000001995041', '/navigation/00000000000000000000000001995042', '/navigation/00000000000000000000000001995043', '/navigation/00000000000000000000000001995044', '/navigation/00000000000000000000000001995046', '/navigation/00000000000000000000000001995047', '/navigation/00000000000000000000000001995048', '/navigation/00000000000000000000000001995049', '/navigation/00000000000000000000000001995050', '/navigation/00000000000000000000000001995051', '/navigation/00000000000000000000000001995052', '/navigation/00000000000000000000000001995053', '/navigation/00000000000000000000000001995054', '/navigation/00000000000000000000000001995055', '/navigation/00000000000000000000000001994505', '/navigation/00000000000000000000000001994658', '/navigation/00000000000000000000000001995056', '/navigation/00000000000000000000000001994659', '/navigation/00000000000000000000000001995057', '/navigation/00000000000000000000000001994661', '/navigation/00000000000000000000000001995059', '/navigation/00000000000000000000000001994662', '/navigation/00000000000000000000000001995060', '/navigation/00000000000000000000000001994663', '/navigation/00000000000000000000000001995061', '/navigation/00000000000000000000000001994664', '/navigation/00000000000000000000000001995062', '/navigation/00000000000000000000000001994665', '/navigation/00000000000000000000000001995063', '/navigation/00000000000000000000000001994666', '/navigation/00000000000000000000000001995064', '/navigation/00000000000000000000000001994667', '/navigation/00000000000000000000000001995065', '/navigation/00000000000000000000000001994668', '/navigation/00000000000000000000000001995067', '/navigation/00000000000000000000000001994669', '/navigation/00000000000000000000000001995068', '/navigation/00000000000000000000000001994670', '/navigation/00000000000000000000000001995069', '/navigation/00000000000000000000000001994671', '/navigation/00000000000000000000000001995070', '/navigation/00000000000000000000000001994672', '/navigation/00000000000000000000000001995071', '/navigation/00000000000000000000000001994673', '/navigation/00000000000000000000000001995072', '/navigation/00000000000000000000000001995073', '/navigation/00000000000000000000000001995074', '/navigation/00000000000000000000000001995075', '/navigation/00000000000000000000000001994507', '/navigation/00000000000000000000000001994519', '/navigation/00000000000000000000000001995082', '/navigation/00000000000000000000000002094846', '/navigation/00000000000000000000000001946155', '/navigation/00000000000000000000000001994520', '/navigation/00000000000000000000000001958323', '/navigation/00000000000000000000000001994524', '/navigation/00000000000000000000000001994528', '/navigation/00000000000000000000000001994531', '/navigation/00000000000000000000000001994532', '/navigation/00000000000000000000000001994533', '/navigation/00000000000000000000000001994535', '/navigation/00000000000000000000000001994549', '/navigation/00000000000000000000000001994571', '/navigation/00000000000000000000000001999523', '/navigation/00000000000000000000000001994536', '/navigation/00000000000000000000000001994537', '/navigation/00000000000000000000000001994538', '/navigation/00000000000000000000000001994540', '/navigation/00000000000000000000000001994564', '/navigation/00000000000000000000000001994580', '/navigation/00000000000000000000000001994541', '/navigation/00000000000000000000000001994542', '/navigation/00000000000000000000000001994543', '/navigation/00000000000000000000000001994544', '/navigation/00000000000000000000000001994545', '/navigation/00000000000000000000000001994548', '/navigation/00000000000000000000000001994550', '/navigation/00000000000000000000000001994560', '/navigation/00000000000000000000000001994561', '/navigation/00000000000000000000000001994566', '/navigation/00000000000000000000000001994570', '/navigation/00000000000000000000000002000223', '/navigation/00000000000000000000000002009546', '/navigation/00000000000000000000000002092218', '/navigation/00000000000000000000000001743118', '/navigation/00000000000000000000000002098090', '/navigation/00000000000000000000000002098766', '/navigation/00000000000000000000000001994522', '/navigation/00000000000000000000000001994551', '/navigation/00000000000000000000000001994552', '/navigation/00000000000000000000000001994553', '/navigation/00000000000000000000000001994554', '/navigation/00000000000000000000000001994555', '/navigation/00000000000000000000000001994556', '/navigation/00000000000000000000000002000795', '/navigation/00000000000000000000000002094845', '/navigation/00000000000000000000000001994558', '/', '/navigation/5507d613f3974866b64d558b39342451', '/navigation/9174b58ea27e496f8e9cefcba40cac29', '/navigation/f971ef3857fb42e781756fba1e3dce5e', '/navigation/bba541c73fde441ebcdbd07fc306d960', '/navigation/44008bc085fd46559a6a82b1a2cf1a62', '/navigation/11890a5a935040ae99a4c58cb9fcdd0e', '/navigation/f859bda54694455a8d10baaec58c5c32', '/navigation/ceafb9867f584615a48e455a894f6b8b', '/navigation/7c2e93a1706f46c997cdcd112ccff324', '/navigation/b835f06ac4d2422ea289d6215a6f69b1', '/navigation/e7c8778ba9fc4785a8311e2ea1e0f6d8', '/navigation/2e332cfbd1de4b03b7321c1020cc2676', '/navigation/42a07277e07d4278b882f9e47493e602', '/navigation/bc19d167515040b48c34a5cb687011eb', '/navigation/8420453b9e044f66960143f8dd935e55', '/navigation/7e36b655d35d40899bf8a82765b23adb', '/navigation/5de4b279abf74b4eb167e2acc5bfc875')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xD74FFD85A6AE42E780AD3554CC15BCE2 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# 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 '%|8d057b42fbf04c6d9cf83d74cc79d1bf|%' AND (`category`.`level` > 1 AND `category`.`level` <= 5)));