Symfony Profiler

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`type` = ? AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = ? OR `category.productStream`.`invalid` = ?) AND (`category.cmsPage`.`id` <=> ? OR `category.cmsPage`.`type` = ?)) OR NOT (`category`.`type` <=> ?) OR (`category`.`type` = ? AND NOT (`category.cmsPage`.`type` IN (?)))) AND `category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?))) GROUP BY `category`.`id`

[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"2•ÇjËôÊ®Ó<6±µü,±"
  "page"
  true
  false
  null
  "product_list"
  "page"
  "page"
  "product_list"
  "%|01894ed2c40070099cf25d59f2d1a99e|%"
  1
  4
]

# header::navigation::search-ids
SELECT
  `category`.`id`,
  `category`.`auto_increment`
FROM
  `category`
  LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id`
  LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id`
  AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id`
  LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`
  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id`
  LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`
  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id`
  LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id`
  AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      (
        `category`.`id` = ?
        OR (
          `category`.`type` = ?
          AND (
            IFNULL(
              `category.nestedProducts`.`active`,
              `category.nestedProducts.parent`.`active`
            ) = ?
            OR `category.productStream`.`invalid` = ?
          )
          AND (
            `category.cmsPage`.`id` <=> ?
            OR `category.cmsPage`.`type` = ?
          )
        )
        OR NOT (`category`.`type` <=> ?)
        OR (
          `category`.`type` = ?
          AND NOT (
            `category.cmsPage`.`type` IN (?)
          )
        )
      )
      AND `category`.`path` LIKE ?
      AND (
        `category`.`level` > ?
        AND `category`.`level` <= ?
      )
    )
  )
GROUP BY
  `category`.`id`

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`category`.`id` = 0x3295C76ACBF4CAAED33C36B1B5FC2CB1 OR (`category`.`type` = 'page' AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = 1 OR `category.productStream`.`invalid` = 0) AND (`category.cmsPage`.`id` <=> NULL OR `category.cmsPage`.`type` = 'product_list')) OR NOT (`category`.`type` <=> 'page') OR (`category`.`type` = 'page' AND NOT (`category.cmsPage`.`type` IN ('product_list')))) AND `category`.`path` LIKE '%|01894ed2c40070099cf25d59f2d1a99e|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4))) GROUP BY `category`.`id`;

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`type` = ? AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = ? OR `category.productStream`.`invalid` = ?) AND (`category.cmsPage`.`id` <=> ? OR `category.cmsPage`.`type` = ?)) OR NOT (`category`.`type` <=> ?) OR (`category`.`type` = ? AND NOT (`category.cmsPage`.`type` IN (?)))))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`

[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"2•ÇjËôÊ®Ó<6±µü,±"
  "page"
  true
  false
  null
  "product_list"
  "page"
  "page"
  "product_list"
  b"\x01‰NÒÄ\x00p\tœò]YòÑ©ž"
]

# header::navigation::search-ids
SELECT
  `category`.`id`,
  `category`.`auto_increment`
FROM
  `category`
  LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id`
  LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id`
  AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id`
  LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`
  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id`
  LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`
  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id`
  LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id`
  AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      (
        `category`.`id` = ?
        OR (
          `category`.`type` = ?
          AND (
            IFNULL(
              `category.nestedProducts`.`active`,
              `category.nestedProducts.parent`.`active`
            ) = ?
            OR `category.productStream`.`invalid` = ?
          )
          AND (
            `category.cmsPage`.`id` <=> ?
            OR `category.cmsPage`.`type` = ?
          )
        )
        OR NOT (`category`.`type` <=> ?)
        OR (
          `category`.`type` = ?
          AND NOT (
            `category.cmsPage`.`type` IN (?)
          )
        )
      )
    )
  )
  AND (
    `category`.`id` IN (?)
  )
GROUP BY
  `category`.`id`

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`category`.`id` = 0x3295C76ACBF4CAAED33C36B1B5FC2CB1 OR (`category`.`type` = 'page' AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = 1 OR `category.productStream`.`invalid` = 0) AND (`category.cmsPage`.`id` <=> NULL OR `category.cmsPage`.`type` = 'product_list')) OR NOT (`category`.`type` <=> 'page') OR (`category`.`type` = 'page' AND NOT (`category.cmsPage`.`type` IN ('product_list')))))) AND (`category`.`id` IN (0x01894ED2C40070099CF25D59F2D1A99E)) GROUP BY `category`.`id`;

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`type` = ? AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = ? OR `category.productStream`.`invalid` = ?) AND (`category.cmsPage`.`id` <=> ? OR `category.cmsPage`.`type` = ?)) OR NOT (`category`.`type` <=> ?) OR (`category`.`type` = ? AND NOT (`category.cmsPage`.`type` IN (?)))))) AND (`category`.`id` IN (?, ?, ?, ?)) GROUP BY `category`.`id`

[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"2•ÇjËôÊ®Ó<6±µü,±"
  "page"
  true
  false
  null
  "product_list"
  "page"
  "page"
  "product_list"
  b"""
    •\n
    AR´ª:׋Ýk6lÁy
    """
  b"سıÕX▀áJ»7±7í┘ËÕ"
  b"2•ÇjËôÊ®Ó<6±µü,±"
  b"H\x12\x02S\f\x04HH­w]2δí#"
]

# header::navigation::search-ids
SELECT
  `category`.`id`,
  `category`.`auto_increment`
FROM
  `category`
  LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id`
  LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id`
  AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id`
  LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`
  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id`
  LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`
  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id`
  LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id`
  AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      (
        `category`.`id` = ?
        OR (
          `category`.`type` = ?
          AND (
            IFNULL(
              `category.nestedProducts`.`active`,
              `category.nestedProducts.parent`.`active`
            ) = ?
            OR `category.productStream`.`invalid` = ?
          )
          AND (
            `category.cmsPage`.`id` <=> ?
            OR `category.cmsPage`.`type` = ?
          )
        )
        OR NOT (`category`.`type` <=> ?)
        OR (
          `category`.`type` = ?
          AND NOT (
            `category.cmsPage`.`type` IN (?)
          )
        )
      )
    )
  )
  AND (
    `category`.`id` IN (?, ?, ?, ?)
  )
GROUP BY
  `category`.`id`

# header::navigation::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `product_stream` `category.productStream` ON `category`.`product_stream_id` = `category.productStream`.`id` LEFT JOIN `cms_page` `category.cmsPage` ON `category`.`cms_page_id` = `category.cmsPage`.`id` AND `category`.`cms_page_version_id` = `category.cmsPage`.`version_id` LEFT JOIN `product_category_tree` `category.nestedProducts.mapping` ON `category`.`id` = `category.nestedProducts.mapping`.`category_id`  AND `category`.`version_id` = `category.nestedProducts.mapping`.`category_version_id` LEFT JOIN `product` `category.nestedProducts` ON `category.nestedProducts.mapping`.`product_id` = `category.nestedProducts`.`id`  AND `category.nestedProducts`.`version_id` = `category.nestedProducts.mapping`.`product_version_id` LEFT JOIN `product` `category.nestedProducts.parent` ON `category.nestedProducts`.`parent_id` = `category.nestedProducts.parent`.`id` AND `category.nestedProducts`.`parent_version_id` = `category.nestedProducts.parent`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`category`.`id` = 0x3295C76ACBF4CAAED33C36B1B5FC2CB1 OR (`category`.`type` = 'page' AND (IFNULL(`category.nestedProducts`.`active`, `category.nestedProducts.parent`.`active`) = 1 OR `category.productStream`.`invalid` = 0) AND (`category.cmsPage`.`id` <=> NULL OR `category.cmsPage`.`type` = 'product_list')) OR NOT (`category`.`type` <=> 'page') OR (`category`.`type` = 'page' AND NOT (`category.cmsPage`.`type` IN ('product_list')))))) AND (`category`.`id` IN (0x950A4152C2B4AA3AD78BDD6B366CC179, 0x9DFCD5E558DFA04AAF37F137A1D9D3E5, 0x3295C76ACBF4CAAED33C36B1B5FC2CB1, 0x481202530C044848AD775D32CEB4ED23)) GROUP BY `category`.`id`;

# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, 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 `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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x018kÖØà‘«L|}æDÓ{"
  b"\x01ŠJ@ýÄsY•\x04û´ñoss"
  b"\x01Ž`1hÒ{[¥ß¤íí+‘C"
  b"""
    \x02R*+'&û\n
    \x03»\x19òØÙRM
    """
  b"\x07+\x03\v¡&²ô²7O4+éíD"
  b"\t?eà€¢•ø\x07k\x1CW"¤j¢"
  b"""
    \n
    \tÈ„K¨ð“l ½y\x110Ö¶
    """
  b"""
    \n
    ¡ˆ<d\x11÷‡<¸=¬±{\n
    ü
    """
  b"\v´®Áq\x05!Á.çb‰ÙD\x08\x17"
  b"\rÙ\x1CTüC\x05╩ÜÊf§;╚%\x11"
  b"\x0E™±\x1DßøKµ£Ãð;¨\fFR"
  b"\x0FI╚Ø\x1Erÿ╗Ö0x£ÄıØH"
  b"\x12…f¦/\x15M¸še+÷¶\x07ÇÌ"
  b"\x13àùNıÉJCå\x16 {█?t9"
  b"\x13¨ëm÷\x12y╔(±ù!çżA"
  b"\x13■Øä1\x0Ew±:m\x18M┐\x122¾"
  b"\x14\x0FiiÕ!?Ðìà1Hæ.F\x1E"
  b"\x14¿¦»\x14‡^E» (¢\x1EÓ€F"
  b"\x16Ñ═«6+ì'íÏ°ÃÀïC0"
  b"\x17\x00\x00)cñØí5BÓrk{ÀX"
  b"\x17æ!fü…†ß¤Ñ¼\x0E\x17BÀ‹"
  b"\x18+àÅÍÍPr»\x18dÍîM=n"
  b"\x18Ø\x04#†·ž,'ŸÑbß\x02\x05È"
  b"\x19Ê\x14çêc(¤.\x0E±=X^L""
  b"\x1A¥“3ç K¢º“‰|Æ\x0F…T"
  b"\x1C8<Ó\v|)Šµ\x02“­þË{\x18"
  b"\x1D\x7Fz¼\x18ü´9u\x06S™°ÑäŽ"
  b"&e}_ù\x02\r*¾þU‡–¹•„"
  b"(8\x02:wì·ý▄!'\x08¸!Àê"
  b"(Ø \x07fØz#Ì\x0E°ì/q)þ"
  b"(Ý,yUÎ’dV$\v/ð\x10\vÞ"
  b"/P\x0E>uâA¬øØuòÈ\x08(²"
  b"1\rË¿LÎb÷b¢ª¡HÕV½"
  b"1þü\x0EW\f³†\x0F*mK8ÆI\r"
  b"2\x17—Wè—M¦’§šóö¹iõ"
  b"2•ÇjËôÊ®Ó<6±µü,±"
  b"3þ_­ØÍ\x01╗µƒ5\x109\x15!ë"
  b"4\x16§_Lê‘\tP|¬Øâò®ü"
  b"4\x17<│Å\x07°Ø█Ù┬¼æ(0?"
  b"5/â]¯hkÛNÜ¢#É!¬ê"
  b"5zo▀vB┐üZêé,D}Ø─"
  b"5ô¨ÔeæáíÀ_=Š¶XÅQ"
  b"6f\x0EY…kMåŠ!›ÏN'ë£"
  b"7ePªO­G}ƒ\x17N•ö…­\x1F"
  b"7¼/u¿\eÏèE\n\x1AAÂ\x006L"
  b"9\x05—$÷:™i„]þAFÅf\x0E"
  b"9ˆÇøŽ¼µŒlé2¹W¶ó2"
  b"?éJ\x00#\x17µù%Ÿ‚i\nî¤Í"
  b"@\x00‹šS€ü¬Î9v¿|\x08¯["
  b"A«6ý╣│¯µ\tð[É┴B"¹"
  b"CìQ}h¶íÓ\x01[>Üš\x116{"
  b"H\x1DÍ÷ó¥DC˜y€–Nš\x1C£"
  b"I\x18/üµí<§Ûñûı\x1FÛd\x06"
  b"In\x05á® ©ÄeX\x00觹ê("
  b"OJÜ¿ŒofÜüŠ2‚¬+ñ\n"
  b"QNîÊs–N¢¦¢‰\x04nǶ&"
  b"W7Æì.\x07\x16óا¥ÄàÞ\rš"
  b"W~ñ\x15O2@­[›A:§4j\x1E"
  b"X¢ünӟЃõ]A‚¿ˆ‚m"
  b"ZK%ªí%Âî\etÞrÜ\x03ÁN"
  b"cdË­¶ò½ؤì;\n\v\x01"
  b"c’?Iå$\x13CªzËj\x06§Qç"
  b"d.Æ´Àö!sHüÁ>\x1E\e\x18Â"
  b"dŒï¼[æJqˆbFÐœNàê"
  b"fÇÄ2}ÃØ\x13[íÄ\x05\x16s┘\x06"
  b"fðAáj`’‹\x05§â(¨œ7™"
  b"gÆ¡çÎVÓÖútŠ¶Ù¯?×"
  b"hUEn/õjØIËË»OWD="
  b"iË>£\x17£,NaCæeý²\v\x14"
  b"j┴ï\x01ä│G üÊ<lðË¥l"
  b"lâI╠r`«bÒ▒9h1¿9Å"
  b"o¦CJÜ\x0EG%¿MÈ\x03«ê\x1D\x07"
  b"oª€@Ú ï9›c§-\x0EJµu"
  b"oú ›ÄSLlµv\x1C½Táe\x19"
  b"r³*\x1FuK¡À›6•àËlÞ\x7F"
  b"s[É┤Vü%Ýl?gê\x19ÂÓX"
  b"uü\t<\x0EçBöÝÚ¡?ÿ˜ñ\x04"
  b"vÍíªK¸Nõ®ÑîÛü t"
  b"|»Ä\tì™\x0F\x19ÇŒu½\x1E\x06ò\x15"
  b"~¼Á2W\x0F÷àè²'#u_¸É"
  b"\x7F\x10\v{6\t/¹°mûO¬6\t1"
  b"ük\x11,a\x05│Ùı7éè9»H\x18"
  b"üƒFÕ,%v:U╠d$"dC\x17"
  b"‚ÎÉ`–Ô(\e|•Í~tb4–"
  b"ƒš´h µ$¯Ú\x05\x12(“ÂþŽ"
  b"…Mo®^ä)\x11g|sžásD†"
  b"îòzdY¹LÕÆ\x16ÉÄ«u£¶"
  b"î▓+¦\v{í½\x13ÎBÔ.Ýìó"
  b"ì;║t%þ╔îP§,íÁ-75"
  b"ì^ò\x7F)xôH{┘Å¿0·d\x13"
  b"Å\x12\x1CÓ}tq~\v\x1F!Ð"ÓE!"
  b"É<Ú"_╩>ÿî*‗\x15ÈÕDË"
  b"""
    •\n
    AR´ª:׋Ýk6lÁy
    """
  b"—xÕÒ\x19Å\x08\všj\x17¾ð)3\x1C"
  b"˜ríŸÂ/Á‚ÓqÃéí1`”"
  b"š\x11X\x15MúBÊݽ\x06”¤é½È"
  b"Ø╦êÓ\x13vIY\vuSr░@»¡"
  b"صÐO ÿ\x06È╝дU[þf═"
  b"سıÕX▀áJ»7±7í┘ËÕ"
  b"ŸÃ×\x15+©3jg\x0E6Ðíy¼C"
  b" \x1A\x03€Ê<aBŒ&¢1ðäš\t"
  b"¡ÐÆè?\x02s'ØF\x10cô¬X¦"
  b"¢Uz{.”\x19\x7F÷g—\vg\x04\x16—"
  b"óuüÖÉ\x18JúòÐ\r98äêë"
  b"ú¾ÉÏÄLA‗t{·/\e_ç█"
  b"""
    ¤ž”\x11ÖOõ>ÌýКÑ\n
    \x15³
    """
  b"¤ „k\x03ëD¯½7œò¯Å]ù"
  b"¤ò6páƒ??Û\x07|§\v½]f"
  b"¥w\eΓâ\x00Ão|ÙßÐåÞª"
  b"¥¿ÉàydøÝÞ¹_Å„Í–]"
  b"¦fXzý¦èšì'J6WUŠ'"
  b"""
    ­\x13¢ |¤·d)YÜ\fLt\n
    ¶
    """
  b"µÍ?Õ)"I †ÝžnÍ+Ý\x08"
  b"¶ðGšè}$IuCœa$Y'r"
  b"·\r§\t–‚Am·F˜Â\x1Fëg”"
  b"¸:¬#¹R‡2Â<Ç5)Pè€"
  b"»Ëÿ\\x1F\x1DíFÂ](\x11š…ÆÂ"
  b"»ùK4ë2&ŠÚW£¾Pbþ}"
  b"½hoÖ@¾˜ïªà\t\x1F£\x01æ\x13"
  b"ÀÇÇm0½=ÊïÉo@'[Ü\n"
  b"ÁjS úGU0ÙX<4ý5nõ"
  b"Åÿ%Cµ?LÀ­8\x19£gRF{"
  b"Ãß$ƒ³\x03ÙØÝÉî#kÐÖm"
  b"Ëp«7VbWkѬZ¯\x16³ü¤"
  b"═╗À\x1D©6F/ü{]Z\x17│ûÚ"
  b"Ï\x00OÜvú\x1AO%ö.\x0Eµ&\x1C£"
  b"ÏŒ\x1FCæ\x14Ai•v\x7FèFmä)"
  b"Ð‗Uúsú╬¸.\x03¬Øÿ\f~╩"
  b"Ñô‘¤\x04Ö…H€”>\<ÙÊ%"
  b"Ñþ\x17=\x08éY9zß4±×~ˆ×"
  b"Ëòw\x10à¬░RDñ¹Å┘\e¶¯"
  b"ÖE’\x0E9_í­{»í\x0EÊ?âà"
  b"Ö}Š´ôÁ\vò*£Sâxy\x13<"
  b"ÙG¿\x06¨…Û\rG}pq!“Oø"
  b"ÙÔô•èu¢àu¡¤¦á¹w\x0F"
  b"ÝÄY³Š\vMÖœp\x17ÝÕ\x1A£¿"
  b"▀h\x04╬p\x10DZÉÛPöÿ\x10«ð"
  b"àÆA\x19['B[°V¬Vø•=$"
  b"âïRO¿=Ÿæ\x11Õ¨é\x0FïÜœ"
  b"ãi…=÷fúDáí\x0Fö\x13õc½"
  b"õª",█[47T\x00ÉO\x03ϵÑ"
  b"ÚnÈx┌©YZ}¢ñ╦╦¯\x16Å"
  b"ê]/\x1CF\x08#.\x07Óª=™ŽQ5"
  b"íÞ¨*Òu[$ÄáhÅü.½@"
  b"­3½7├\x02\x01¸?\x14$Ið7\x02ì"
  b"ó@ñ±ö[mõµãùM•±\x1D¯"
  b"óÚ:Þ]*@r³ÿŽ¿\x04%€)"
  b"¶W┼E®ÌÏÅ\x18ý¯G\x14Zr└"
  b"¸\x17qc╚3▀¶│Å╚Êç/\x1Eã"
  b"÷f@`ÌR¼o=b\vÎÜ”¤¶"
  b"¨╣\x02³2ë»MðìÕÐÌT÷Å"
  b"¨╦F\x18&ìJv©\x08Z^ª:┌Ç"
  b"û{ŸúTb\x08L_N~… “æ×"
  b"üI\f¤\\x00±$›¾5T¤ýöû"
  b"""
    þŸÂ‰Ãÿ\n
    ñB¶Ó¾­˜©#
    """
]

# 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`,
  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 `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.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 `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 (0x01386BD6D8E091C2AB4C7C7DE644D37B, 0x018A4A40FDC473599504FBB4F16F7373, 0x018E603168D27B5BA5DFA4EDED2B9143, 0x02522A2B2726FB0A03BB19F2D8D9524D, 0x072B030BA126B2F4B2374F342BE9ED44, 0x093F65E080A295F8076B1C5722A46AA2, 0x0A09C8844BA8F0936C20BD791130D6B6, 0x0AA1883C6411F7873CB83DACB17B0AFC, 0x0BB4AEC1710521C12EE76289D9440817, 0x0DEB1C54814305CA9AD266F53BC82511, 0x0E99B11DDFF84BB5A3C3F03BA80C4652, 0x0F49C89D1E7298BB9930789C8ED59D48, 0x128566A62F154DB89A652BF7B607C7CC, 0x1385974ED5904A438616FF7BDB3F7439, 0x13F9896DF61279C928F19721878FAC41, 0x13FE9D84310E77F13A6D184DBF1232F3, 0x140F6969D5213FD0ECE03148E62E461E, 0x14BFA6BB14875E45BBA028A21ED38046, 0x16A5CDAE362B8D27A1D8F8C7B78B4330, 0x1700002963A49DA13542E0726B7BB758, 0x17E62166FC8586DFA4D1BC0E1742C08B, 0x182BE0C5CDCD5072BB1864CDEE4D3D6E, 0x18D8042386B79E2C279FD162DF0205C8, 0x19CA14E7EA6328A42E0EB13D585E4C22, 0x1AA59333E7A04BA2BA93897CC60F8554, 0x1C383CD30B7C298AB50293ADFECB7B18, 0x1D7F7ABC18FCB43975065399B0D1E48E, 0x26657D5FF9020D2ABEFE558796B99584, 0x2838023A778DFAECDC212708F721B788, 0x289DFF07669D7A23DE0EF88D2F7129E7, 0x28DD2C7955CE926456240B2FF0100BDE, 0x2F500E3E758341AA9B9D7595D40828FD, 0x310DCBBF4CCE62F762A2AAA148D556BD, 0x31FEFC0E570CB3860F2A6D4B38C6490D, 0x32179757E8974DA692A79AF3F6B969F5, 0x3295C76ACBF4CAAED33C36B1B5FC2CB1, 0x33E75FF09DD601BBE69F351039152189, 0x3416A75F4CEA9109507CACD8E2F2AEFC, 0x34173CB38F07F89DDBEBC2AC9128303F, 0x352FE25DAF686BDB4EDCA223C921ACEA, 0x357A6FDF7642BF815A88822C447D9DC4, 0x35F4A8D465E6E1EDC05F3D8AB658C551, 0x36660E59856B4DE58A219BCF4E27EBA3, 0x376550AA4FAD477D83174E95F685AD1F, 0x37BC2F75BF1BCFE8450A1A41C200364C, 0x39059724F73A9969845DFE4146C5660E, 0x3988C7F88EBCB58C6CE932B957B6F332, 0x3FE94A002317B5F9259F82690AEEA4CD, 0x40008B9A5380FCACCE3976BF7C08AF5B, 0x41AE36ECB9B3EEE609D05B90C14222FB, 0x43EC517D68B6EDD3015B3EDC9A11367B, 0x481DCDF7F3A54443987980964E9A1CA3, 0x49182F81E6A13CF5EAA496D51FEA6406, 0x496E05E1AEA0A9C4655800E8A7B9EA28, 0x4F4ADCBF8C6F66DCFC8A3282AC2BF10A, 0x514EEECA73964EA2A6A289046EC7B626, 0x5737C6EC2E0716F3D8A7A5C4E0DE0D9A, 0x577EF1154F3240AD5B9B413AA7346A1E, 0x58A2FC6ED39FD083F55D4182BF88826D, 0x5A4B25AAED25C2EE1B74DE72DC03C14E, 0x6364D3F0F495B6AB9DCF8D3B5C6E0B01, 0x63923F49E5241343AA7ACB6A06A751E7, 0x642E92EFB79421734881B53E1E1B18B6, 0x648CEFBC5BE64A71886246D09C4EE0EA, 0x66808E327DC79D135BA18E051673D906, 0x66F041E16A60928B05A7E228A89C3799, 0x67C6A1E7CE56D3D6FA748AB6D9AF3FD7, 0x6855456E2FE46A9D49D3D3AF4F57443D, 0x69CB3EA317A32C4E6143E665FDB20B14, 0x6AC18B0184B3472081D23C6CD0D3BE6C, 0x6C8349CC7260AE62E3B1396831A8398F, 0x6FA6434ADC0E4725BF4DC803ABEA1D07, 0x6FAA8040DA20EF399B63A72D0E4AB575, 0x6FFAA09BC4534C6CB5761CBD54E16519, 0x72B32A1F754BA1C09B3695E0CB6CDE7F, 0x735B90B4568125ED6C3F678819B6E058, 0x75FC093C0EE742F6DDDAA13FFF98F104, 0x76D6A1A64BF74EE4A9A5C7A9EA81FF74, 0x7CBBC409EC990F19C78C75BD1E06F215, 0x7EACB532570FF6858AFD2723755FF790, 0x7F100B7B36092FB9B06DFB4FAC360931, 0x816B112C6105B3EBD537828A39AF4818, 0x819F46E52C25763A55CC642422644317, 0x82CEC96096D4281B7C95CD7E74623496, 0x839AB46820B524AFDA05122893C2FE8E, 0x854D6FAE5EE42911677C739EE1734486, 0x8C957A6459FB4CE59216908EAE759CF4, 0x8CB22BDD0B7BA1AB13D742E22EED8DA2, 0x8D3BBA7425E7C98C50F52CA1B52D3735, 0x8D5E957F297893487BD98FA830FA6413, 0x8F121CE07D74717E0B1F21D122E04521, 0x903CE9225FCA3E988C2AF215D4E544D3, 0x950A4152C2B4AA3AD78BDD6B366CC179, 0x9778D5D219C5080B9A6A17BEF029331C, 0x9872ED9FC22FC182D371C3E9ED316094, 0x9A1158154DFA42CADDBD0694A4E9BDC8, 0x9DCB88E0137649590B755372B040AFAD, 0x9DE6D14FFF9806D4BCD1EF555BE766CD, 0x9DFCD5E558DFA04AAF37F137A1D9D3E5, 0x9FC3D7152BA9336A670E36D0ED79BC43, 0xA01A0380CA3C61428C26A231F0E49A09, 0xA1D0C6E83F027327D8461063F4AC58A6, 0xA2557A7B2E94197FF767970B67041697, 0xA275819990184AA395D10D3938848889, 0xA3F390D88E4C41F2747BFA2F1B5F87DB, 0xA49E9411D64FF53ECCFDD09AD10A15B3, 0xA4A0846B03EB44AFBD379CF2AFC55DF9, 0xA4F23670E1833F3FDB077CA70BBD5D66, 0xA5771BCE93E200C36F7CD9DFD0E5DEAA, 0xA5BFC9E07964F8DDDEB95FC584CD965D, 0xA666587AFDA6E89AEC274A3657558A27, 0xAD13A2A07CA4B7642959DC0C4C740AB6, 0xB5CD3FD52922492086DD9E6ECD2BDD08, 0xB6F0479AE87D244975439C6124592772, 0xB70DA7099682416DB74698C21FEB6794, 0xB83AAC23B9528732C23CC7352950E880, 0xBBCBFF5C1F1DED46C25D28119A85C6C2, 0xBBF94B34EB32268ADA57A3BE5062FE7D, 0xBD686FD640BE98EFAAE0091FA301E613, 0xC0C7C76D30BD3DCAEFC96F40275BDC0A, 0xC16A5320FA475530D9583C34FD356EF5, 0xC5FF2543B53F4CC0AD3819A36752467B, 0xC7E1249FFC03EB9DED908C236BD1996D, 0xCB70AB375662576BD1AC5AAF16B3FCA4, 0xCDBBB71DB836462F817B5D5A17B396E9, 0xCF004FDC76FA1A4F25F62E0EB5261CA3, 0xCF8C1F43E614416995767FE8466DE429, 0xD1F255A373A3CEF72E03AA9D980C7ECA, 0xD1F491A404D6854880943E5C3CD9CA25, 0xD1FE173D08E959397ADF34B1D77E88D7, 0xD395771085AAB05244A4FB8FD91BF4EE, 0xD645920E395FEDAD7BBBED0ECA3FE2E0, 0xD67D8AB4F4C10BF22AA353E27879133C, 0xD947BF06A885DB0D477D707121934FF8, 0xD9D4F495E875A2E075A1A4A6E1B9770F, 0xDDC459B38A0B4DD69C7017DDD51AA3BF, 0xDF6804CE7010445A90EA50949810AED0, 0xE0C641195B27425BB056AC56F8953D24, 0xE2EF524FBF3D9FE611D5A8E90FEFDC9C, 0xE369853DF766FA44E1ED0FF613F563BD, 0xE4A6222CDB5B34375400904F03D8E6A5, 0xE96ED478DAB8595A7DBDA4CBCBEE168F, 0xEA5D2F1C4608232E07D3AA3D998E5135, 0xEDDEA82AD2755B24C4E168C5FC2EBD40, 0xF033AB37C30201F73F142449D037028D, 0xF340F1B1F65B6DF5B5E3F94D95B11DAF, 0xF3DA3ADE5D2A4072B3FF8EBF04258029, 0xF457C545A9DED88F18ECEE47145A72C0, 0xF7177163C833DFF4B38FC8D2872F1EC6, 0xF7664060CC52BC6F3D620BCEDC94A4B6, 0xF9B902FC3289AF4DD08DE5D1DE54F68F, 0xF9CB4618268D4A76B8085A5EA63ADA80, 0xFB7B9FFA5462084C5F4E7E85A093E6D7, 0xFC490CA45C00B1249BBE3554A4FDF6FB, 0xFE9FC289C3FF0AF142B6D3BEAD98A923));

# product-listing-route::loading::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `product_category` `product.categories.mapping`
                  WHERE `product.categories.mapping`.`product_id` = `product`.`categories` AND `product.categories.mapping`.product_version_id = `product`.version_id ) as `product.categories.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, `product.parent.translation`.name as `product.parent.translation.name`, `product.parent.translation`.keywords as `product.parent.translation.keywords`, `product.parent.translation`.description as `product.parent.translation.description`, `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))