Symfony Profiler

# header::navigation::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.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 '%|cc5e5b8ab9b242a0a542274d4e58a308|%' AND (`category`.`level` > 1 AND `category`.`level` <= 6)));

SELECT
  LOWER(
    HEX(`category`.`parent_id`)
  ) as `category-ids.key`,
  COUNT(`category`.`id`) as `category-ids.count`,
  COUNT(DISTINCT `category`.`id`) as `visible-children-count`
FROM
  `category`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category`.`path` LIKE ?
      AND `category`.`level` = ?
      AND `category`.`active` = ?
      AND `category`.`visible` = ?
    )
  )
GROUP BY
  `category`.`parent_id`

SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|cc5e5b8ab9b242a0a542274d4e58a308|%' AND `category`.`level` = 6 AND `category`.`active` = 1 AND `category`.`visible` = 1)) GROUP BY `category`.`parent_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/019201f2dff971f7a858cd9dd0ffd709', '/detail/0191fe1cea6d734e97a0a1fee36a0960', '/navigation/2854ce3914bc438d818cdf7326b4bc4e', '/navigation/29c82640f6fc4496b2d797961f6861b1', '/navigation/8b01e10c3b274fb186096cea430b3971', '/navigation/06868ddabf8a4c8bb57e85345fcabe15', '/navigation/1be4fbcc306245a4b46bec26e19d0611', '/navigation/ed86ad961ad54ddc89cba1c6cbde664c', '/navigation/2102346f67cb4a89a8ec5139f1c7390e', '/navigation/b78a751b7cd7453b95f92f280c5e0cde', '/navigation/e51621d51b034346b8a76b3de682987b', '/navigation/acc4d498cd6843b282958cf9fd56b363', '/navigation/5e373e6422824ca3b8a0ba801a7be113', '/navigation/c0b489452e884f3a8f0625117f5f02c3', '/navigation/db03f8b9dd5c4699bfb61f0e816cbb1c', '/navigation/400c5fd2ab154f0fb1841c08b20e33ba', '/navigation/8366ae4f8af9404ebee8152172d3b950', '/navigation/5c91ef35c7444e20848fe92d68d5cb07', '/navigation/df2c5323a82e47429fa77e2283171a7c', '/navigation/8cf448711af04bc1b72b983e74e5fb51', '/navigation/3d0068734d804d28ad2cf4c02678447e', '/navigation/97450950403b420ea41ca0f5ce16e251', '/navigation/c8823e95ddd74384ad8f98702d06d7aa', '/navigation/a46a273ad7bd403b84cdaacf842a3658', '/navigation/e060510c7ed04b01ba656d07214f6a54', '/navigation/8a722fa321584e2aa785f36bc76c2e1a', '/navigation/609bab1f3f1f469b9142112d9a235340', '/navigation/1a3f150f037945f6977b2550631823d4', '/navigation/a423a922b5774aee9fd91445cf317be3', '/navigation/04d027632a574ab283ab444f96a42e27', '/navigation/89b0c82e7d964b2baa13e40ecade6620', '/navigation/f2c420a8c51f447f896d722b6163b0eb', '/navigation/696b15141ddd443789af6ee1846e9585', '/navigation/70137db5870a4477a4c2f34a337ff446', '/navigation/2fbf5c2b443341a69c690cbe773cdcc9', '/navigation/04d804df5b204b3aafad80640162eb13', '/navigation/76102597297a49b98bf661b115e55c0b', '/navigation/73938a52d808424e9339ce14bef3bbed', '/navigation/ff614fbf214a46b4aa44c1826b8b0e3c', '/navigation/a4afba6fb20b401594c0dade18d4ba74', '/navigation/82d7981f41054425b0a8c56408db5aaf', '/navigation/2292005e71fe44c2a43e2ccb4976ae4d', '/navigation/d96b4ad5555544c38573d8f51c3dcb61', '/navigation/c297c0c271c04ab4b4c91aafff1d2293', '/navigation/58049fa94b9240dd85afcafafe399029', '/navigation/6ec22e8c49014c129e542935f5f86cea', '/navigation/6d203d053b1a4c6698b5e5d34cb44cdf', '/navigation/e1be360f62774afdbd4556b5bf64ff69', '/navigation/ca31566ac67b410ca416655d0124398c', '/navigation/0db07127d0374b469a8f45530b39825a', '/navigation/d7094c6b43ed4d568022884075177f82', '/navigation/822a830ebac545bd873f9d85d6344626', '/navigation/90dac98a6fac47589189ed26b9d0a8aa', '/navigation/682ef6abe0e24f9385cd91b0f947889f', '/navigation/cc2758171cc34adda996036c2c90a2c5', '/navigation/e287fc0ae4c647d9b86b2f9685cbe221', '/navigation/4ae3c88691d046a699cc6ed14ad5d389', '/navigation/5e7bf15894a24edda16f1a7faa4fb36f', '/navigation/18d81a698f224f3b93951b8738586d8f', '/navigation/d986563c5c794ff39493d042a79feaec', '/navigation/4631a81a5b3e4cecbc13e3597bd6508d', '/navigation/0d5bf89a34f04ae394c22b1597433fe8', '/navigation/e1bccdbc250e4102828087901ce65a00', '/navigation/7e962f8bff114a4fa713f2f016b57d8a', '/navigation/6a54a0a90a804547b144c9fb740a9e39', '/navigation/3f6ad35d94764aa2b6565fe1df1ffe79', '/navigation/674d675ce90943ba9efdc4d260c571fd', '/navigation/5e66287a52ca4cddaa16551b01ad9d29', '/navigation/01a1fc0d21d449cba6697c64d1a0f006', '/navigation/aa9cf521970042308bb1d9d6182d49b3', '/navigation/a953fee1f5f548f0854270403e0e9bbb', '/navigation/fe23c7a60e8c49d6a954f0a5d975e7c6', '/navigation/3b8bbe028b294538a335d5358c5a5a5a', '/navigation/259e7af20813490ab2631bd5a84936c9', '/navigation/295f742256fd4043ad9174b7aa3f3f01', '/navigation/5737b5094a1f45b8b3dabb1ee817faae', '/navigation/ac740cb6f8c84e91a59c31210620fba3', '/navigation/e85f6f3d5ad54710b66f4b7d9ef68125', '/navigation/4fa4891fa3a14fd5bd84ec8df131909d', '/navigation/d569d9e39ed0496a9c98e8e517f730ef', '/navigation/acc1cf543826416395b36d5e74e9787a', '/navigation/369b21b32f014d409cc4dc9ca93a80cb', '/navigation/50d03971b02f49dd9557d6330a0ee789', '/navigation/5226d0ae9a3b4b6295f5ef277ff96822', '/navigation/354c330bca0448b9a7fdb4bb22194a93', '/navigation/28f1ee935e504535b1faa133c3a88e6b', '/navigation/2530c32c379d4737bc208bbba06ca54b', '/navigation/46f986c11467495098f01068ea029280', '/navigation/1609128845874b1b8f4c8010781c50e1', '/navigation/01e50eac068e46468c53335187e7680d', '/navigation/9185d1e02afd4c0398fe7703fdc5adbb', '/navigation/33a0366adabe4406a6aebccf7253134f', '/navigation/8b4bc4b5b730404791a1b7d63715b6c5', '/navigation/d597ed85cd514b1693925afd1ab16c17', '/navigation/f48f3ae13cbd4d3f965acf4871c44008', '/navigation/a611c389111540a99c803b573286de72', '/navigation/bfc43596c23e433ebb715e7bd135332b', '/navigation/8df5887c70d74537ab92e6bd6d8ad8e8', '/navigation/46e1dadda1cd483e8a35a9ab20b0b796', '/navigation/7516609cb3994cde952531df1268ecdc', '/navigation/223d18690fb3405ca0436e7ebfaff083', '/navigation/78638cada455469fba2f5e72162ebf89', '/navigation/dcd09e5b105f433ba36fff4fd765a186', '/navigation/cb6ff5c9057b45388b70c46130ffd611', '/navigation/203027b0154f406fbaa202ab179b6653', '/navigation/0a56686d0d1b4a6d8eaf89d961f6df18', '/navigation/671954cb367b45a185e0cf40f15bdb05', '/navigation/322e7de728a542f8b2062262d19ac4e9', '/navigation/528fad7429b545ddb7d74412ac944e25', '/navigation/55545af3213d4b5bbfdaf6d11d8a73dc', '/navigation/9c556231e6ec4f07838350d963f198c8', '/navigation/419e50202c2f426e91f0d1976ed9d23d', '/navigation/be3985b1cf954154849f46f883addbdf', '/navigation/2d83545384994d18a638c710eed909ca', '/navigation/3b37998df4ea489f83ac7fa113635c49', '/navigation/56d76fd33fc34a5a8ee5eb9d6b49d3c3', '/navigation/5e204e0a202346dcb8af0ca3771b92f8', '/navigation/c961455f811f43ab862743bb48a50f78', '/navigation/f04f584a929c4186baef47270cb45faf', '/navigation/4ca8e829eb3d4e7c8d22e25a69e1d5d4', '/navigation/e6732866ab424c3aa46e7422475b6883', '/navigation/0da6096ab0af431786ea5a1d222e35d9', '/navigation/520d096d2b61404da56efb3b4358e910', '/navigation/5d111fc40b0e412ab5379a6159d2bf12', '/navigation/ac9260498dc6437b90ce3cc013dea890', '/navigation/4423c5285a97475a9a11db77971d220a', '/navigation/465a2babbd6740258c37429a800b5e56', '/navigation/e2f08ade21ad4d9d8c90ebd130068ac9', '/navigation/8c9a4c70e23141959d4a29d4afa36113', '/navigation/01d91997479246fdaf05c717e565fcfb', '/navigation/b5926ac2eeb64d50a3da93cc4b32ab5b', '/navigation/3d98fe7b1eb242c3bb95ca75c0f830f9', '/navigation/e2546002293c433b9f84c293e7661acb', '/navigation/dfe1c2f4aa22408fa8b5b4a1d23e8404', '/navigation/c3ec8bdd3e8849498d3e60324ca2087e', '/navigation/0152653bf68f4320a400fbedc8c7d54e', '/navigation/3f58f7768c17457aa953e8d8adebda01', '/navigation/333f363e368f42d8886a32abb6ef14b6', '/navigation/228f97da99db428fa56586b761f993eb', '/navigation/ed14db20d614430cbb75f18adc1b2943', '/navigation/c6f39bdfec11491dade8bcd256612a58', '/navigation/8724bf23472340f894599fce7fd03d86', '/navigation/b0ea276303eb4050933252fe0e176619', '/navigation/69b4c0c782694d6c8d81aa03ed002ec3', '/navigation/6f4218d86dcc4e0f93c1787ab09e5a91', '/navigation/5dbcad74341c4e439b4b996564515d39', '/navigation/2092538877cf49af8b90b8a6007eb5bb', '/navigation/5f6f1e80c1414c20bc066e3fa457e458', '/navigation/b2c7ab72236b485495ffaa722eead045', '/navigation/3c357fae878f4f86b9eab67d6786f97a', '/navigation/ed0ce2e3cc194fde8978effe37856598', '/navigation/5bdb4542982840b19060e55b5fac2055', '/navigation/7f301ade70b0417093a455c7c938e992', '/navigation/1229429623d2437fa67fb432a57b9a34', '/navigation/051ea51e9e4d496aafa41592bcff2859', '/navigation/133bce4ba5cf43e29ff7f909152beede', '/navigation/92f9dc418d5a45e2be495a7035de5602', '/navigation/2bdb85e816e544bb8d11f125c55fbdd0', '/navigation/f36c5707335e41b18faa87104f1d24d1', '/navigation/30f7b0f80a68438cad1eb1f2dd98492c', '/navigation/5b59283eed564ea68464bf36ae6a585f', '/navigation/2159abc450524768b1a8604e778160b8', '/navigation/aef5478a6ebb489d97e7b5a479643474', '/navigation/e60cd1472b894d04bb242b54078c7138', '/navigation/8c8d97987d854a3ca76880ab27eece9d', '/navigation/6a669c29b22e4b7f8330a18e406f69d0', '/navigation/71e04f477a82445ab325128c2a813728', '/navigation/8ae43f3edb0e4d13b1b20241e769dfb3', '/navigation/8f4fd1cb6a934b4283f459191085d622', '/navigation/490faef3dbcf4193835d0968b41bf6cc', '/navigation/725d3afd09264bdd86a89cb4b451d8fb', '/navigation/9d0110055bcf4c3d9e1a8e87b489acdc', '/navigation/a4002f7e0b874f4a989551af31f53b2c', '/detail/f8bce4a52407459b87d276fc6c0ea5ae', '/navigation/c877c25e3ac348c8876d88260e80f273', '/navigation/af881eddc8884135bdcf674ecc76308a', '/detail/cf7da639268645cb9a13cd1bc170904b', '/navigation/3b37f62ecec5448facca2d87220ac91a', '/navigation/4e24437f38604c999b5ad5fcfe885f75', '/navigation/5c4d36c7fcd340cd9acb155b7c8c579e', '/navigation/f55372f1bc5145158993efefd42870c3', '/navigation/e865aec765d540cea9040181864a0751', '/detail/c1d1578c74d94b67a6af92b596203f03', '/navigation/9f7ccacfaf784da2b587d90dcdcbbc3b', '/navigation/f018cf2ba17743f98c88748e8a714596', '/navigation/be89da3bc8fc4fbc96b5feecfd835a28', '/navigation/db305795dd1c416d833e4aaf96fce010', '/navigation/19ea6fb4cdc5453b8fc7c516f2d3cccb', '/navigation/5e0637203ae14523b08b190acaf2c836', '/navigation/1cbfc0ee06d34c1385b3d306b176d0d6', '/navigation/4b660fc829c641298b28459aa3241122', '/navigation/85fc39bc608d4752976d4b53f765b054', '/navigation/2edc4c68f98d4f47a5d70d261ca514e3', '/navigation/11bfa169f21f410b98f236ccb66d6fae', '/navigation/68bfb4675fe9487f8f0d4d77a1088425', '/navigation/77b881510463402a9d749021a2fc3501', '/navigation/d8d90a3ed3e34f938bbb71a05fb2508f', '/detail/3fa58f281647451d989394c2d66df0d7', '/navigation/91aec5bb5de248829e027ae06ff2fdc1', '/navigation/89314aecec2e4eefa0bc374d121d12f4', '/navigation/6e81d04f37fd4a73af2d2cac1d3e9a3f', '/navigation/52c33abb214240d0bd701cd5a5ff1659', '/navigation/ded72c0d4dff4ea4b5647356ad43a622', '/navigation/01a2fd48c499434396ac617c9f2b0e02', '/navigation/831dc307f1684462a13508dbc21f9068', '/navigation/6c955dd1620c4819b3f064917f420c37', '/navigation/e35a9ccb85cc4bdda78ad849a04038bd', '/navigation/7e5a6c8eafb24d919bdaa0821acf3625', '/navigation/3e6fac1cc05d46169a6130a0202137f4', '/detail/d73f027e50ae4599a77a4ba79ebfda82', '/navigation/aa18fd43f3a3475a9f7e149ae916e7b1', '/navigation/e742b79f99bb4f5197543485f2c1e345', '/navigation/3a6bb3664e704ffcb0cade4071f4ecb0', '/navigation/bf107b529963462e950138b177585b5e', '/navigation/c064b3766962414c854a48fe6149052f', '/navigation/187119c38d8443f0b727b5bcd599b78a', '/navigation/7b4a16d412264afdb3a6e3e778d05f3a', '/navigation/efa723ee54e44781a5052dd00e410cff', '/navigation/123d9019f8154daf99a595bf7eb7e30d', '/navigation/e29cfdf303e74a9eb97580a211711a47', '/navigation/ba78a4206ab5436786bd7ad87a0095cc', '/navigation/cb270b64dd3c4d9a90ceb454d1bdd09b', '/navigation/b40b5b0f272e4182bc700b4dacab966d', '/navigation/60123ad350a54d939742197c83dbfe3c', '/navigation/996e61b30166402d82232956717184de', '/navigation/0ba7fcf15fc74dbb85e57d8fd023b25b', '/navigation/56b48b78b1674c829f4137166b314756', '/navigation/6ed30c081efa48dfadfbb7c99686528f', '/navigation/55817c3cee6d42b0a40859a57f04992f', '/navigation/a3be9d3b82a34b86b4ecea534f95afe4', '/navigation/e063c3a58e4f4ff39359ea07bb183094', '/navigation/d08e336998d64f6f88f382b40fd8b75c', '/navigation/09066f0d13ad47e88d4c75d3adb9c97d', '/navigation/57435f87d50044c7a0f6e7b3778893f2', '/navigation/dcd3eab294f24ec084a6a07c98573041', '/navigation/d27baf5083384cbc82f5379d0db70287', '/navigation/0b05797bf1f44470a993a232f4a8283c', '/navigation/0e0e5b918c3d453eb31cafbdc99ad8ca', '/navigation/4f7c1fa1d68f4e84af607f28c9e78800', '/navigation/a8c1a928741d4e06b71f65d82a5dfd57', '/navigation/d36e17da4e954414b1a4a28bbba436d1', '/navigation/d6dbdcd8d9b2460594827d48b5fbd8d8', '/navigation/b34fadd3b4484d71a362178f443a69eb', '/navigation/c609bd931b8a4c5a89e7d217035b7fe3', '/navigation/034ea871406040ddbd83d3fa20815bce', '/navigation/3152fad25c844aa9b623c75cf6a78bbf', '/navigation/c977663642954e268a9963c79d7c7d84', '/navigation/9ce18ec8278e476d8abf514f82bb5bed', '/navigation/3507c7f4e64e4674939359dea2e2f503', '/navigation/4f7753b68361430b8fac3483fdec327a', '/navigation/859c1fe1f23b410dbf22e4c0ba0d4d3b', '/navigation/707c2fec699a4e50902606e1fa9f31f1', '/navigation/49d16f8bee0649ff8a3a66b42c19bbb4', '/navigation/8021e969a37341049d73f7536b10e46f', '/navigation/de04d65279844a3999ede0af94be179d', '/navigation/ad85a4b41a984e9dbb541984f2c5fc74', '/navigation/951a5bd20e9a4459b28d4c54b8e5e9a2', '/navigation/29aaafa23ee7423b987ca0f995d41287', '/navigation/c9b1d435c9984606aa057493dac271ff', '/navigation/e9189fbe375b483e980618a611673340', '/navigation/84efb6df11224763a81ff89e1c368de5', '/navigation/768fb5f11b604cea95f11ed4638182ca', '/navigation/b041e0be982a48d5af1dc463e1fac919', '/navigation/c43edf8449b44d6fac145e0cc2aebb74', '/navigation/1a4709bea4e44f879811f768b3d458c4', '/navigation/e3fb282bd0e74dafa78cfbeb7e236608', '/navigation/a1d8afcc2bcd498891f911ca6dd7c630', '/navigation/5e359b379ae1418c8969d1bb1cbb426e', '/navigation/c30b591b071d4a698cac643cb690d2a6', '/navigation/cb6a1aaa97f34d5fa803ae0147fa748e', '/navigation/40455166b82f47e38325ee9ab456ee7b', '/navigation/d7caeb83e3a3482b870973c9bf58476f', '/navigation/c728580892b44349bb12913417be40b7', '/navigation/b1aceb1119c040dcb5886f682b428779', '/navigation/d76f064a6f4b4a8ebc62b4eaf8eace9b', '/navigation/15f34f21867c408db0961ec10781f7d8', '/navigation/01948e73dac140679c7a0021cdb187ce', '/navigation/fb9e5c7c4284415e9d6e0f5dacac075b', '/navigation/e19278f9d10541439b2f4ede5018c404', '/navigation/05f55e20813d4dbaad9de8f1f19b3b3b', '/navigation/8fcafda321ec4d94a66ff3f10eb31007', '/navigation/3ac140a809b843e584263d8e729522b0', '/navigation/5c9a871f40414cc7b169f002d2334511', '/navigation/11c673db2acf4a40bf4f8e5c2af66df1', '/navigation/d06c4f9528e7401cb49ca44ab1c51825', '/navigation/95d2c4b39a1d47a982f2cbb5a3b386fc', '/navigation/2957f900136b4eb5ab30aca28fe8bbf8', '/navigation/b2540129e66447458a4c14e260f150bd', '/navigation/5e16cf5bb75c4a57b1c9193c5412e08a', '/navigation/240501b3b0364ac89777361a9f3095e3', '/navigation/9b2bbffbc92446769693a6ff247f9197', '/navigation/365b8afd284c420f9f123e696502e6a5', '/navigation/680fa88adff74213b0df8cd666f2f025', '/navigation/4b58196a988344e486df78266a8cabd4', '/navigation/840aa3c0e7a14be49fec43739f9ad467', '/navigation/da31492725bd41e3bc622dbaf047f330', '/navigation/d9ce13d793704309bf6d709b7248b362', '/navigation/f0c8d7661f0c4491b99921225b8d6561', '/navigation/4a993247381d468782ff5a09eb426bbf', '/navigation/bdc46e57bcba4567bdf4c95f0147c626', '/navigation/348b8cdcc7d64c51a4757cd368e68969', '/navigation/8092d7f96d164554921805230af76cf4', '/navigation/3ce5c8ce86b6464abb10ffa1db8711cd', '/navigation/4deaf2fcfa464d83aff1dc3f4c709bfc', '/navigation/f57a0c9db0ca4da9b6cd97569778878c', '/navigation/cf8c98a5f25e4d038f9d71fb7fd0d1a6', '/navigation/2d50a6823a58417faf61fbf154192e41', '/navigation/39fb2425e33f48ed8440ed5b4a0642fc', '/navigation/a745652690614261988d0f6a0f78d85f', '/navigation/67c82f3d8f004b65aee86b816835dafb', '/navigation/019300c2f82d73489b1b1a807537aad6', '/navigation/019300c55d1d7e618eb10dc727742ee9', '/navigation/019300c57b477111bd1ae21fe87302fa')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x87C46B0A1E164BDABDEE97C5D2C42655 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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`.`created_at` as `product.createdAt`,
  `product`.`updated_at` as `product.updatedAt`,
  `product.translation.metaDescription`,
  `product.parent.translation.metaDescription`,
  COALESCE(
    `product.translation.metaDescription`,
    `product.parent.translation.metaDescription`
  ) as `product.metaDescription`,
  `product.translation.name`,
  `product.parent.translation.name`,
  COALESCE(
    `product.translation.name`, `product.parent.translation.name`
  ) as `product.name`,
  `product.translation.keywords`,
  `product.parent.translation.keywords`,
  COALESCE(
    `product.translation.keywords`,
    `product.parent.translation.keywords`
  ) as `product.keywords`,
  `product.translation.description`,
  `product.parent.translation.description`,
  COALESCE(
    `product.translation.description`,
    `product.parent.translation.description`
  ) as `product.description`,
  `product.translation.metaTitle`,
  `product.parent.translation.metaTitle`,
  COALESCE(
    `product.translation.metaTitle`,
    `product.parent.translation.metaTitle`
  ) as `product.metaTitle`,
  `product.translation.packUnit`,
  `product.parent.translation.packUnit`,
  COALESCE(
    `product.translation.packUnit`,
    `product.parent.translation.packUnit`
  ) as `product.packUnit`,
  `product.translation.packUnitPlural`,
  `product.parent.translation.packUnitPlural`,
  COALESCE(
    `product.translation.packUnitPlural`,
    `product.parent.translation.packUnitPlural`
  ) as `product.packUnitPlural`,
  `product.translation.customSearchKeywords`,
  `product.parent.translation.customSearchKeywords`,
  COALESCE(
    `product.translation.customSearchKeywords`,
    `product.parent.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`,
  `product.translation.slotConfig`,
  `product.parent.translation.slotConfig`,
  COALESCE(
    `product.translation.slotConfig`,
    `product.parent.translation.slotConfig`
  ) as `product.slotConfig`,
  `product.translation.customFields`,
  `product.parent.translation.customFields`,
  COALESCE(
    `product.translation.customFields`,
    `product.parent.translation.customFields`
  ) as `product.customFields`
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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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_fields` as `product.translation.customFields`,
      `product.translation`.`slot_config` as `product.translation.slotConfig`,
      `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`
    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_fields` as `product.parent.translation.customFields`,
      `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`,
      `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`
    FROM
      `product_translation` `product.parent.translation`
    WHERE
      `product.parent.translation`.`language_id` = ?
  ) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id`
  AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    `product`.`id` IN (?)
  )

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`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` 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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0x019201F2DFF971F7A858CD9DD0FFD709));