Symfony Profiler

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

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/019759b80a3c71d5a4bcd92c0ec4afa5', '/navigation/019759b80a3a7396a5778aaf39e0ff72', '/navigation/019759b80a4170cbad8085a2842416b3', '/navigation/019759b80a54702eb1e6ce83ad7f8ba4', '/navigation/019759b80a6370a6a5680919213f187d', '/navigation/019759b80a66716bb31a5f0dced34c8e', '/navigation/019759b80a70725f99f61f9d17fd4dc4', '/navigation/019759b80a7570669094348af10f8aea', '/navigation/019759b80a7c71a8a481c2d53e9ecf2c', '/navigation/019759b80a7e72419276f75eb3ac5016', '/navigation/019759b80a7f7015a97eec2c257dd1c9', '/navigation/019759b80a3b73579f10ef23ed146218', '/navigation/019759b80a3b73579f10ef23ed216bf2', '/navigation/019759b80a3b73579f10ef23ed7de16e', '/navigation/019759b80a3b73579f10ef23ee6558f4', '/navigation/019759b80a3b73579f10ef23ef491b38', '/navigation/019759b80a3b73579f10ef23f01e1e9e', '/navigation/019759b80a3b73579f10ef23f0f56fc8', '/navigation/019759b80a3b73579f10ef23f1a6b1d1', '/navigation/019759b80a3b73579f10ef23f24b868a', '/navigation/019759b80a3c71d5a4bcd92c0cf98bfe', '/navigation/019759b80a3c71d5a4bcd92c0dd9942d', '/navigation/019759b80a3c71d5a4bcd92c0e6eb991', '/navigation/019759b80a3c71d5a4bcd92c0ebf12e1', '/navigation/019759b80a3c71d5a4bcd92c0f8795eb', '/navigation/019759b80a3c71d5a4bcd92c0fd9a148', '/navigation/019759b80a3c71d5a4bcd92c1016eff6', '/navigation/019759b80a3c71d5a4bcd92c1057a863', '/navigation/019759b80a3c71d5a4bcd92c11259e2e', '/navigation/019759b80a3c71d5a4bcd92c11a92f08', '/navigation/019759b80a3c71d5a4bcd92c12852db4', '/navigation/019759b80a3c71d5a4bcd92c134ef4fe', '/navigation/019759b80a3c71d5a4bcd92c135b3384', '/navigation/019759b80a3c71d5a4bcd92c14119b56', '/navigation/019759b80a3c71d5a4bcd92c141858ac', '/navigation/019759b80a3d7265a7fb48efea05ec13', '/navigation/019759b80a3d7265a7fb48efea2007ef', '/navigation/019759b80a3d7265a7fb48efea66080e', '/navigation/019759b80a3d7265a7fb48efead04373', '/navigation/019759b80a3d7265a7fb48efeaf8b7ae', '/navigation/019759b80a3d7265a7fb48efebbc4e8a', '/navigation/019759b80a3d7265a7fb48efebbf836d', '/navigation/019759b80a3d7265a7fb48efec20cc6a', '/navigation/019759b80a3d7265a7fb48efecca5afe', '/navigation/019759b80a3d7265a7fb48efed0cca7f', '/navigation/019759b80a3d7265a7fb48efed7db706', '/navigation/019759b80a3d7265a7fb48efed88928a', '/navigation/019759b80a3d7265a7fb48efee06dd1d', '/navigation/019759b80a3d7265a7fb48efee750f68', '/navigation/019759b80a3e724ab337bf375a2c619d', '/navigation/019759b80a3e724ab337bf375a553675', '/navigation/019759b80a3e724ab337bf375a684a38', '/navigation/019759b80a3e724ab337bf375a8dddad', '/navigation/019759b80a3e724ab337bf375af75d69', '/navigation/019759b80a3e724ab337bf375b9881d4', '/navigation/019759b80a3e724ab337bf375c872219', '/navigation/019759b80a3e724ab337bf375d43d511', '/navigation/019759b80a3e724ab337bf375d8d602a', '/navigation/019759b80a3e724ab337bf375e4ed026', '/navigation/019759b80a3e724ab337bf375ead6bcc', '/navigation/019759b80a3e724ab337bf375f3fb738', '/navigation/019759b80a3e724ab337bf37603a48a4', '/navigation/019759b80a3e724ab337bf37611e2c23', '/navigation/019759b80a3f72828581220e8d5e96d1', '/navigation/019759b80a3f72828581220e8d848803', '/navigation/019759b80a3f72828581220e8e06a233', '/navigation/019759b80a3f72828581220e8e61ba69', '/navigation/019759b80a3f72828581220e8f4eadb3', '/navigation/019759b80a3f72828581220e901306a5', '/navigation/019759b80a3f72828581220e907df24b', '/navigation/019759b80a3f72828581220e913057fa', '/navigation/019759b80a3f72828581220e914be835', '/navigation/019759b80a3f72828581220e91c0bf71', '/navigation/019759b80a3f72828581220e9202f047', '/navigation/019759b80a3f72828581220e92b660b8', '/navigation/019759b80a3f72828581220e937c2dd2', '/navigation/019759b80a407138993711f65ee43af8', '/navigation/019759b80a407138993711f65f249001', '/navigation/019759b80a407138993711f65f765f9b', '/navigation/019759b80a407138993711f65fceacaa', '/navigation/019759b80a407138993711f65ff3ed42', '/navigation/019759b80a407138993711f660b3fc3d', '/navigation/019759b80a407138993711f660ee1311', '/navigation/019759b80a407138993711f661d6196a', '/navigation/019759b80a407138993711f662a08572', '/navigation/019759b80a407138993711f662e6f46e', '/navigation/019759b80a407138993711f6631bc3d2', '/navigation/019759b80a407138993711f663f76d92', '/navigation/019759b80a407138993711f6644ab772', '/navigation/019759b80a4170cbad8085a28361806f', '/navigation/019759b80a4170cbad8085a2836ac460', '/navigation/019759b80a4170cbad8085a283efa6e6', '/navigation/019759b80a4170cbad8085a284377bbb', '/navigation/019759b80a4170cbad8085a2851a5923', '/navigation/019759b80a4170cbad8085a285b0ded8', '/navigation/019759b80a4170cbad8085a28739a81b', '/navigation/019759b80a4170cbad8085a28973e856', '/navigation/019759b80a42715b9b4f846cf7547592', '/navigation/019759b80a42715b9b4f846cf80cd62e', '/navigation/019759b80a42715b9b4f846cfa756672', '/navigation/019759b80a4371d1ad85f6c0e2ca4802', '/navigation/019759b80a4371d1ad85f6c0e4cc3e09', '/navigation/019759b80a4371d1ad85f6c0e71bda69', '/navigation/019759b80a4470e9a3f563a03f434fa8', '/navigation/019759b80a4470e9a3f563a040e62e90', '/navigation/019759b80a4470e9a3f563a0437571ca', '/navigation/019759b80a4470e9a3f563a046edb4b0', '/navigation/019759b80a45723089aaf91acdcdbc06', '/navigation/019759b80a45723089aaf91ace5ca5a9', '/navigation/019759b80a45723089aaf91acf192a24', '/navigation/019759b80a45723089aaf91ad1a219ed', '/navigation/019759b80a45723089aaf91ad3a84e32', '/navigation/019759b80a4670b69433ea73b07d44a9', '/navigation/019759b80a4670b69433ea73b0cfd155', '/navigation/019759b80a47732d86a28ff547b97441', '/navigation/019759b80a47732d86a28ff54a908189', '/navigation/019759b80a47732d86a28ff54dc982b4', '/navigation/019759b80a4871c6a94a91272fc67f78', '/navigation/019759b80a4871c6a94a91272ff40631', '/navigation/019759b80a4871c6a94a912731418347', '/navigation/019759b80a497033beca4cd610c073df', '/navigation/019759b80a497033beca4cd612395661', '/navigation/019759b80a497033beca4cd612e598a3', '/navigation/019759b80a497033beca4cd61348779e', '/navigation/019759b80a497033beca4cd614d3a3a4', '/navigation/019759b80a4a73bcac6f3924ed4380a2', '/navigation/019759b80a4a73bcac6f3924ef885104', '/navigation/019759b80a4a73bcac6f3924f3271e4b', '/navigation/019759b80a4a73bcac6f3924f3e42dea', '/navigation/019759b80a4a73bcac6f3924f4585b35', '/navigation/019759b80a4b7307bda21e19c2840edf', '/navigation/019759b80a4b7307bda21e19c5bede91', '/navigation/019759b80a4c730f8a5892800bcea87c', '/navigation/019759b80a4c730f8a5892800c721641', '/navigation/019759b80a4c730f8a5892800fffd0cc', '/navigation/019759b80a4d717a99794fcf76e90d07', '/navigation/019759b80a4d717a99794fcf7843de78', '/navigation/019759b80a4d717a99794fcf7c47f4f8', '/navigation/019759b80a4e705a8bf667eaa9bdc146', '/navigation/019759b80a4e705a8bf667eaa9faaa69', '/navigation/019759b80a4e705a8bf667eaaadc7bb4', '/navigation/019759b80a4e705a8bf667eaad97ad19', '/navigation/019759b80a4e705a8bf667eab075495f', '/navigation/019759b80a4f7237884f3eca5707a72b', '/navigation/019759b80a4f7237884f3eca58f00c74', '/navigation/019759b80a4f7237884f3eca5938cf68', '/navigation/019759b80a4f7237884f3eca5a523b2e', '/navigation/019759b80a507315a316fbce5f64e2b7', '/navigation/019759b80a507315a316fbce600f1348', '/navigation/019759b80a507315a316fbce60c26c70', '/navigation/019759b80a507315a316fbce631fd55f', '/navigation/019759b80a507315a316fbce6454d735', '/navigation/019759b80a5171cd928defdccc70a60d', '/navigation/019759b80a5171cd928defdccd6f9f17', '/navigation/019759b80a5171cd928defdcce9dedc2', '/navigation/019759b80a5270b58ecaccf26c3e3e79', '/navigation/019759b80a5270b58ecaccf26fa0e9ea', '/navigation/019759b80a5270b58ecaccf270464d19', '/navigation/019759b80a537347b61e1665d20d8fee', '/navigation/019759b80a537347b61e1665d6797d88', '/navigation/019759b80a537347b61e1665d69d8605', '/navigation/019759b80a54702eb1e6ce83aa58f69e', '/navigation/019759b80a54702eb1e6ce83ae27901a', '/navigation/019759b80a54702eb1e6ce83ae5b32d2', '/navigation/019759b80a54702eb1e6ce83af4bb83c', '/navigation/019759b80a557155b733a0c5f31577c9', '/navigation/019759b80a557155b733a0c5f4b4bada', '/navigation/019759b80a557155b733a0c5f89da2aa', '/navigation/019759b80a5673bc9587467a8620c402', '/navigation/019759b80a5673bc9587467a880bbdd0', '/navigation/019759b80a5673bc9587467a8874e059', '/navigation/019759b80a5673bc9587467a8aa0a7d1', '/navigation/019759b80a5773df9265f1da9788939f', '/navigation/019759b80a5773df9265f1da98688094', '/navigation/019759b80a5773df9265f1da9ad4477c', '/navigation/019759b80a5773df9265f1da9e3e0ec4', '/navigation/019759b80a5871059cff1d49da33ca62', '/navigation/019759b80a5871059cff1d49dafc09ca', '/navigation/019759b80a5871059cff1d49ded99a95', '/navigation/019759b80a597202a5eec87ce4365acc', '/navigation/019759b80a597202a5eec87ce4c13f24', '/navigation/019759b80a597202a5eec87ce7d0a075', '/navigation/019759b80a5a7046a9f019fa5133aac6', '/navigation/019759b80a5a7046a9f019fa52d634ac', '/navigation/019759b80a5a7046a9f019fa53bf916a', '/navigation/019759b80a5b70aeb94e30baaa68dac6', '/navigation/019759b80a5b70aeb94e30baaac5cbf3', '/navigation/019759b80a5b70aeb94e30baab2c36cb', '/navigation/019759b80a5b70aeb94e30baacb0944b', '/navigation/019759b80a5b70aeb94e30baae4aeb78', '/navigation/019759b80a5b70aeb94e30baae87f82a', '/navigation/019759b80a5c71f19045aa891ed620fe', '/navigation/019759b80a5c71f19045aa89216b48cb', '/navigation/019759b80a5c71f19045aa8922169529', '/navigation/019759b80a5c71f19045aa89258b3604', '/navigation/019759b80a5d70aeb89013a5345f86f5', '/navigation/019759b80a5d70aeb89013a53512b526', '/navigation/019759b80a5d70aeb89013a537ea5193', '/navigation/019759b80a5d70aeb89013a53998d4cc', '/navigation/019759b80a5d70aeb89013a53b141262', '/navigation/019759b80a5e70f89363ca3dc058786b', '/navigation/019759b80a5e70f89363ca3dc11766de', '/navigation/019759b80a5e70f89363ca3dc2e66e55', '/navigation/019759b80a5e70f89363ca3dc554bf30', '/navigation/019759b80a5f70cba66b0a2ac1bcf1a4', '/navigation/019759b80a5f70cba66b0a2ac2bbf6fb', '/navigation/019759b80a5f70cba66b0a2ac4901ee6', '/navigation/019759b80a60727c8218b4fe68f50c57', '/navigation/019759b80a60727c8218b4fe6c1f865d', '/navigation/019759b80a60727c8218b4fe6dd47b95', '/navigation/019759b80a61715ca4d248c74254718f', '/navigation/019759b80a61715ca4d248c7430536b2', '/navigation/019759b80a61715ca4d248c746997ac8', '/navigation/019759b80a61715ca4d248c747c0658b', '/navigation/019759b80a627364ade8c4904fd22cca', '/navigation/019759b80a627364ade8c49050989e16', '/navigation/019759b80a627364ade8c49052c34b02', '/navigation/019759b80a627364ade8c49055ee51b7', '/navigation/019759b80a627364ade8c4905655ef25', '/navigation/019759b80a6370a6a56809192066e410', '/navigation/019759b80a6370a6a56809192207e070', '/navigation/019759b80a6370a6a56809192237c8aa', '/navigation/019759b80a6370a6a568091922d29dd1', '/navigation/019759b80a6370a6a56809192373fcc4', '/navigation/019759b80a647288a83f7244a0a7570d', '/navigation/019759b80a647288a83f7244a172c69a', '/navigation/019759b80a647288a83f7244a1e41e5c', '/navigation/019759b80a647288a83f7244a2b8a163', '/navigation/019759b80a647288a83f7244a3575808', '/navigation/019759b80a647288a83f7244a4154150', '/navigation/019759b80a647288a83f7244a45d54ca', '/navigation/019759b80a647288a83f7244a557f842', '/navigation/019759b80a647288a83f7244a6337a6e', '/navigation/019759b80a647288a83f7244a6d45079', '/navigation/019759b80a647288a83f7244a7222f6e', '/navigation/019759b80a647288a83f7244a813fbb0', '/navigation/019759b80a647288a83f7244a8433b9e', '/navigation/019759b80a6570d1bad7418497f191e9', '/navigation/019759b80a6570d1bad7418498dedb3e', '/navigation/019759b80a6570d1bad7418499aa3518', '/navigation/019759b80a6570d1bad741849a03340c', '/navigation/019759b80a6570d1bad741849a3e204b', '/navigation/019759b80a6570d1bad741849a59c3f8', '/navigation/019759b80a6570d1bad741849a78f061', '/navigation/019759b80a6570d1bad741849b102e90', '/navigation/019759b80a6570d1bad741849b9e0983', '/navigation/019759b80a6570d1bad741849c052b9e', '/navigation/019759b80a6570d1bad741849c5952de', '/navigation/019759b80a6570d1bad741849d22f68b', '/navigation/019759b80a6570d1bad741849e08d083', '/navigation/019759b80a66716bb31a5f0dceb6e99e', '/navigation/019759b80a66716bb31a5f0dcf8ce620', '/navigation/019759b80a66716bb31a5f0dd0179bd5', '/navigation/019759b80a66716bb31a5f0dd11185e3', '/navigation/019759b80a66716bb31a5f0dd356e5ca', '/navigation/019759b80a6773e5a1d10255cad1df1e', '/navigation/019759b80a6773e5a1d10255cdcc522e', '/navigation/019759b80a68706c84d05741b875bb54', '/navigation/019759b80a68706c84d05741bc32f58d', '/navigation/019759b80a68706c84d05741bcffa042', '/navigation/019759b80a6971dbb5cfaed77c7956d5', '/navigation/019759b80a6971dbb5cfaed7804ab401', '/navigation/019759b80a6971dbb5cfaed7821a9438', '/navigation/019759b80a6a732fad6cec970953cb6a', '/navigation/019759b80a6a732fad6cec970b95a237', '/navigation/019759b80a6a732fad6cec970c89291e', '/navigation/019759b80a6b7279b1c560db09e2f437', '/navigation/019759b80a6b7279b1c560db0a71b9d5', '/navigation/019759b80a6b7279b1c560db0b0b7251', '/navigation/019759b80a6b7279b1c560db0da6ccab', '/navigation/019759b80a6c70efa65d822528ef0013', '/navigation/019759b80a6c70efa65d8225290e4760', '/navigation/019759b80a6c70efa65d82252ca40bdd', '/navigation/019759b80a6c70efa65d82252f0fb8ee', '/navigation/019759b80a6d713785faab2411f7c152', '/navigation/019759b80a6d713785faab2413bbb4d6', '/navigation/019759b80a6d713785faab2416789d71', '/navigation/019759b80a6e71cda3640a8c432939a2', '/navigation/019759b80a6e71cda3640a8c4594dc51', '/navigation/019759b80a6e71cda3640a8c45ede2c4', '/navigation/019759b80a6f72b8b45d0b0488552abd', '/navigation/019759b80a6f72b8b45d0b048c1aa638', '/navigation/019759b80a6f72b8b45d0b048ecd1764', '/navigation/019759b80a70725f99f61f9d18804018', '/navigation/019759b80a70725f99f61f9d1915ab11', '/navigation/019759b80a70725f99f61f9d19b8afa5', '/navigation/019759b80a70725f99f61f9d19d92a6a', '/navigation/019759b80a70725f99f61f9d19e3f085', '/navigation/019759b80a70725f99f61f9d1a1ac8e9', '/navigation/019759b80a70725f99f61f9d1a9ccb8e', '/navigation/019759b80a70725f99f61f9d1aa9c718', '/navigation/019759b80a70725f99f61f9d1affabc1', '/navigation/019759b80a70725f99f61f9d1ba1b529', '/navigation/019759b80a70725f99f61f9d1c039a8c', '/navigation/019759b80a70725f99f61f9d1cde40fd', '/navigation/019759b80a7173e6be46ce4db642035f', '/navigation/019759b80a7173e6be46ce4db6757132', '/navigation/019759b80a7173e6be46ce4db772bea6', '/navigation/019759b80a7173e6be46ce4db78142ca', '/navigation/019759b80a7173e6be46ce4db7ec86ba', '/navigation/019759b80a7173e6be46ce4db82c3edc', '/navigation/019759b80a7173e6be46ce4db8dafdee', '/navigation/019759b80a7173e6be46ce4db8e13674', '/navigation/019759b80a7173e6be46ce4db9cd6237', '/navigation/019759b80a7173e6be46ce4db9e431f3', '/navigation/019759b80a7173e6be46ce4dba71d58b', '/navigation/019759b80a7173e6be46ce4dbad37a8f', '/navigation/019759b80a72738295ab1353c3a69f43', '/navigation/019759b80a72738295ab1353c3bab63c', '/navigation/019759b80a72738295ab1353c3da4273', '/navigation/019759b80a72738295ab1353c3de7db4', '/navigation/019759b80a72738295ab1353c3e48b0a', '/navigation/019759b80a72738295ab1353c4a5e512', '/navigation/019759b80a72738295ab1353c53256b4', '/navigation/019759b80a72738295ab1353c5ff96c6', '/navigation/019759b80a72738295ab1353c69e89e1', '/navigation/019759b80a72738295ab1353c7106906', '/navigation/019759b80a72738295ab1353c799837a', '/navigation/019759b80a737338b7a766245dafc0e3', '/navigation/019759b80a737338b7a766245e65b7c4', '/navigation/019759b80a737338b7a766245e7f6936', '/navigation/019759b80a737338b7a766245f228143', '/navigation/019759b80a737338b7a766245f4c0c9e', '/navigation/019759b80a737338b7a766245fb67788', '/navigation/019759b80a737338b7a7662460233576', '/navigation/019759b80a737338b7a76624605eb148', '/navigation/019759b80a737338b7a7662460c504b9', '/navigation/019759b80a737338b7a766246168a43c', '/navigation/019759b80a737338b7a7662461bd14b4', '/navigation/019759b80a737338b7a7662462370e26', '/navigation/019759b80a7472969a1bb2bd32a65844', '/navigation/019759b80a7472969a1bb2bd3398dcd1', '/navigation/019759b80a7472969a1bb2bd34740759', '/navigation/019759b80a7472969a1bb2bd3492f87f', '/navigation/019759b80a7472969a1bb2bd354943d1', '/navigation/019759b80a7472969a1bb2bd355de51d', '/navigation/019759b80a7472969a1bb2bd35f1540a', '/navigation/019759b80a7472969a1bb2bd361c438b', '/navigation/019759b80a7472969a1bb2bd369fba22', '/navigation/019759b80a7472969a1bb2bd3744b4a2', '/navigation/019759b80a7472969a1bb2bd38252645', '/navigation/019759b80a7472969a1bb2bd38ed594c', '/navigation/019759b80a7472969a1bb2bd39325a11', '/navigation/019759b80a7472969a1bb2bd399c97a5', '/navigation/019759b80a7570669094348af030381e', '/navigation/019759b80a7570669094348af0885aed', '/navigation/019759b80a7570669094348af095a1b9', '/navigation/019759b80a7570669094348af20507b6', '/navigation/019759b80a7570669094348af2c04faf', '/navigation/019759b80a7570669094348af2fb17f0', '/navigation/019759b80a7570669094348af3a5df60', '/navigation/019759b80a7570669094348af3e93c45', '/navigation/019759b80a7570669094348af4af7afc', '/navigation/019759b80a7570669094348af54136b5', '/navigation/019759b80a7570669094348af5e6d6d5', '/navigation/019759b80a76700ea74136d35cb83b38', '/navigation/019759b80a76700ea74136d35daff027', '/navigation/019759b80a76700ea74136d35ddf1848', '/navigation/019759b80a76700ea74136d35eb6fc6a', '/navigation/019759b80a76700ea74136d35f9577db', '/navigation/019759b80a76700ea74136d360456fa5', '/navigation/019759b80a76700ea74136d3611397ab', '/navigation/019759b80a76700ea74136d361fb6cea', '/navigation/019759b80a76700ea74136d362173b2d', '/navigation/019759b80a76700ea74136d362fccee1', '/navigation/019759b80a76700ea74136d3631058ba', '/navigation/019759b80a76700ea74136d363d8be7f', '/navigation/019759b80a76700ea74136d364b93152', '/navigation/019759b80a76700ea74136d3656a3460', '/navigation/019759b80a77733c83946829f77cb7e0', '/navigation/019759b80a77733c83946829f839e9e2', '/navigation/019759b80a77733c83946829f89a8115', '/navigation/019759b80a77733c83946829f96e3090', '/navigation/019759b80a77733c83946829fa01f7a2', '/navigation/019759b80a77733c83946829fa7b24b1', '/navigation/019759b80a77733c83946829fb456c7e', '/navigation/019759b80a77733c83946829fbd22cdd', '/navigation/019759b80a77733c83946829fc719eb4', '/navigation/019759b80a77733c83946829fd1bb385', '/navigation/019759b80a77733c83946829fdbd4583', '/navigation/019759b80a77733c83946829fe4ff607', '/navigation/019759b80a78712d92dc601a3eec02c5', '/navigation/019759b80a78712d92dc601a3faf6788', '/navigation/019759b80a78712d92dc601a3fe686d4', '/navigation/019759b80a78712d92dc601a400c4d0f', '/navigation/019759b80a78712d92dc601a4016a4c2', '/navigation/019759b80a78712d92dc601a40d6e878', '/navigation/019759b80a78712d92dc601a4170376a', '/navigation/019759b80a78712d92dc601a418ad48d', '/navigation/019759b80a78712d92dc601a41a730c0', '/navigation/019759b80a78712d92dc601a42727788', '/navigation/019759b80a78712d92dc601a4365c65f', '/navigation/019759b80a78712d92dc601a438427e4', '/navigation/019759b80a7973ec87e4c8daa5a7ae30', '/navigation/019759b80a7973ec87e4c8daa5d3d194', '/navigation/019759b80a7973ec87e4c8daa695e932', '/navigation/019759b80a7973ec87e4c8daa6a95297', '/navigation/019759b80a7973ec87e4c8daa6d6945b', '/navigation/019759b80a7973ec87e4c8daa76501a2', '/navigation/019759b80a7973ec87e4c8daa837e022', '/navigation/019759b80a7973ec87e4c8daa90c3137', '/navigation/019759b80a7973ec87e4c8daa942d52f', '/navigation/019759b80a7973ec87e4c8daa9644740', '/navigation/019759b80a7973ec87e4c8daa9824280', '/navigation/019759b80a7973ec87e4c8daaa365958', '/navigation/019759b80a7a72f3b528766fb1b8ddf5', '/navigation/019759b80a7a72f3b528766fb29a6b6a', '/navigation/019759b80a7a72f3b528766fb385e5ca', '/navigation/019759b80a7a72f3b528766fb4593a2d', '/navigation/019759b80a7a72f3b528766fb50e51ac', '/navigation/019759b80a7a72f3b528766fb5aa691d', '/navigation/019759b80a7a72f3b528766fb66caf44', '/navigation/019759b80a7a72f3b528766fb7554a4b', '/navigation/019759b80a7a72f3b528766fb776f1b8', '/navigation/019759b80a7a72f3b528766fb7841158', '/navigation/019759b80a7a72f3b528766fb83dbc82', '/navigation/019759b80a7a72f3b528766fb8ee195f', '/navigation/019759b80a7b7051a2b98417d7781780', '/navigation/019759b80a7b7051a2b98417d8507ccd', '/navigation/019759b80a7b7051a2b98417d8c8d77f', '/navigation/019759b80a7b7051a2b98417d9bc4fe2', '/navigation/019759b80a7b7051a2b98417d9d144bd', '/navigation/019759b80a7b7051a2b98417da5bb18c', '/navigation/019759b80a7b7051a2b98417dae8c20f', '/navigation/019759b80a7b7051a2b98417dba6e617', '/navigation/019759b80a7b7051a2b98417dc851511', '/navigation/019759b80a7b7051a2b98417dcc16087', '/navigation/019759b80a7b7051a2b98417dd5b81c0', '/navigation/019759b80a7c71a8a481c2d53cd8d024', '/navigation/019759b80a7c71a8a481c2d53d328bb9', '/navigation/019759b80a7c71a8a481c2d53d89c899', '/navigation/019759b80a7c71a8a481c2d53e86f5d0', '/navigation/019759b80a7c71a8a481c2d53f6691a6', '/navigation/019759b80a7c71a8a481c2d53fa33d48', '/navigation/019759b80a7c71a8a481c2d53fa77acb', '/navigation/019759b80a7c71a8a481c2d53fe6880d', '/navigation/019759b80a7c71a8a481c2d540c133a6', '/navigation/019759b80a7c71a8a481c2d5414238c8', '/navigation/019759b80a7d71d2be1423d530f085c3', '/navigation/019759b80a7d71d2be1423d531622f54', '/navigation/019759b80a7d71d2be1423d5321fbbed', '/navigation/019759b80a7d71d2be1423d532a537f7', '/navigation/019759b80a7d71d2be1423d5336c10d3', '/navigation/019759b80a7d71d2be1423d53437b6a1', '/navigation/019759b80a7d71d2be1423d534fecde5', '/navigation/019759b80a7d71d2be1423d53530f4b2', '/navigation/019759b80a7d71d2be1423d535cd6e9e', '/navigation/019759b80a7d71d2be1423d535f41a1f', '/navigation/019759b80a7d71d2be1423d536ec295d', '/navigation/019759b80a7d71d2be1423d5379ca9e1', '/navigation/019759b80a7d71d2be1423d537afe829', '/navigation/019759b80a7e72419276f75eb12c8b2c', '/navigation/019759b80a7e72419276f75eb194dee1', '/navigation/019759b80a7e72419276f75eb2101b61', '/navigation/019759b80a7e72419276f75eb303a1f8', '/navigation/019759b80a7e72419276f75eb44d11a3', '/navigation/019759b80a7e72419276f75eb490ba72', '/navigation/019759b80a7e72419276f75eb51d8525', '/navigation/019759b80a7e72419276f75eb61bc826', '/navigation/019759b80a7e72419276f75eb6dc616a', '/navigation/019759b80a7e72419276f75eb7b63d7f', '/navigation/019759b80a7e72419276f75eb806a1c2', '/navigation/019759b80a7e72419276f75eb8118e7d', '/navigation/019759b80a7f7015a97eec2c20578eeb', '/navigation/019759b80a7f7015a97eec2c2139fb2e', '/navigation/019759b80a7f7015a97eec2c21489d0c', '/navigation/019759b80a7f7015a97eec2c223753e2', '/navigation/019759b80a7f7015a97eec2c22fe6ee5', '/navigation/019759b80a7f7015a97eec2c23e7e84f', '/navigation/019759b80a7f7015a97eec2c24df3c07', '/navigation/019759b80a7f7015a97eec2c2674ec29', '/navigation/019759b80a7f7015a97eec2c26b6ed15', '/navigation/019759b80a7f7015a97eec2c27955702', '/navigation/019759b80a7f7015a97eec2c2880a990', '/navigation/019759b80a7f7015a97eec2c2953c932', '/navigation/019759b80a7f7015a97eec2c2a13487d', '/navigation/019759b80a8071dfa7b4c06e7196bc93', '/navigation/019759b80a8071dfa7b4c06e726b8dbe', '/navigation/019759b80a8071dfa7b4c06e72b0d90a', '/navigation/019759b80a8071dfa7b4c06e72f73cfa', '/navigation/019759b80a8071dfa7b4c06e737a4146', '/navigation/019759b80a8071dfa7b4c06e744c30cf', '/navigation/019759b80a8071dfa7b4c06e752b81cb', '/navigation/019759b80a8071dfa7b4c06e75811092', '/navigation/019759b80a8071dfa7b4c06e75db4e1b', '/navigation/019759b80a8071dfa7b4c06e75e4d162', '/navigation/019759b80a8071dfa7b4c06e76bb8ed5', '/navigation/019759b80a8071dfa7b4c06e7771782c', '/navigation/019759b80a81710e8bcc98a5e13deb93', '/navigation/019759b80a81710e8bcc98a5e1f9be1d', '/navigation/019759b80a81710e8bcc98a5e26108ec', '/navigation/019759b80a81710e8bcc98a5e31b25ab', '/navigation/019759b80a81710e8bcc98a5e38ceb85', '/navigation/019759b80a81710e8bcc98a5e3e1232a', '/navigation/019759b80a81710e8bcc98a5e4835798', '/navigation/019759b80a81710e8bcc98a5e49aa337', '/navigation/019759b80a81710e8bcc98a5e58ea861', '/navigation/019759b80a81710e8bcc98a5e5d24bfa', '/navigation/019759b80a81710e8bcc98a5e619025e', '/navigation/019759b80a81710e8bcc98a5e6518a0d', '/navigation/019759b80a81710e8bcc98a5e6858ff3', '/navigation/019759b80a8270878212744afec596e7', '/navigation/019759b80a8270878212744affb1e487', '/navigation/019759b80a8270878212744afff78fe2', '/navigation/019759b80a8270878212744b006ca160', '/navigation/019759b80a8270878212744b00a81aaa', '/navigation/019759b80a8270878212744b00acaa83', '/navigation/019759b80a8270878212744b00f78c52', '/navigation/019759b80a8270878212744b01e9fd29', '/navigation/019759b80a8270878212744b020435c5', '/navigation/019759b80a8270878212744b022f0f31', '/navigation/019759b80a8270878212744b02dd08b0', '/navigation/019759b80a8270878212744b0334bc0a', '/navigation/019759b80a837313a44224c2eda5c439', '/detail/019759b8191b73f1bc602ad7d4d5d657', '/detail/019759b8192170cc922a44c09246bd51', '/detail/019759b81907720a93802b7d8087b608', '/detail/019759b8190372d9b7cc691c5fae1de3', '/detail/019759b819157173838fe4e919f52675', '/detail/019759b8190970468c7c9e6c2358ce3f', '/detail/019759b8191d71b38764af64a2a8a254', '/detail/019759b819117337b9364fbe1f2870b3', '/detail/019759b818ff71e79552c8b18e1d9c58', '/detail/019759b8190b71a489abb08a138fd08f', '/detail/019759b81919719cb19af44275701ad4', '/detail/019759b8190572fe83ed6c694e582ba3', '/detail/019759b81901738a887755e9e96f97a9', '/detail/019759b8191370b6b59cbed558de329a', '/detail/019759b8192471c2af56fc62d390a9b3', '/detail/019759b8190f737d903817fd917c9e1d', '/detail/019759b819177010a761a0168a36de0c', '/detail/019759b8191f70e98a3ac198acdccbcb', '/detail/019759b818fd70c6b9c8085ec8955d4c', '/detail/019759b8190d7056ac27dbe0fc9d6bf1')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x019759B7D02C70E3B5D760FCE793727F OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# 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`,
  `product.manufacturer.translation.name` as `product.manufacturer.name`,
  `product.manufacturer.translation.description`,
  `product.manufacturer.translation.description` as `product.manufacturer.description`,
  `product.manufacturer.translation.customFields`,
  `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`,
  (
    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`,
  `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`,
  `product.unit.translation.shortCode` as `product.unit.shortCode`,
  `product.unit.translation.name`,
  `product.unit.translation.name` as `product.unit.name`,
  `product.unit.translation.customFields`,
  `product.unit.translation.customFields` as `product.unit.customFields`,
  `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`,
  `product.deliveryTime.translation.name` as `product.deliveryTime.name`,
  `product.deliveryTime.translation.customFields`,
  `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`,
  `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`.`file_hash` as `product.cover.media.fileHash`,
  `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`,
  `product.cover.media.translation.title` as `product.cover.media.title`,
  `product.cover.media.translation.alt`,
  `product.cover.media.translation.alt` as `product.cover.media.alt`,
  `product.cover.media.translation.customFields`,
  `product.cover.media.translation.customFields` as `product.cover.media.customFields`,
  `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`
  ) 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 `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.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`
  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`
    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`
    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`
    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`.`alt` as `product.cover.media.translation.alt`,
      `product.cover.media.translation`.`title` as `product.cover.media.translation.title`,
      `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`
    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 (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )

# 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`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (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`, `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`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `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`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `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`.`file_hash` as `product.cover.media.fileHash`, `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`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `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`) 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 `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.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` 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` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0x019759B8191B73F1BC602AD7D4D5D657, 0x019759B8192170CC922A44C09246BD51, 0x019759B81907720A93802B7D8087B608, 0x019759B8190372D9B7CC691C5FAE1DE3, 0x019759B819157173838FE4E919F52675, 0x019759B8190970468C7C9E6C2358CE3F, 0x019759B8191D71B38764AF64A2A8A254, 0x019759B819117337B9364FBE1F2870B3, 0x019759B818FF71E79552C8B18E1D9C58, 0x019759B8190B71A489ABB08A138FD08F, 0x019759B81919719CB19AF44275701AD4, 0x019759B8190572FE83ED6C694E582BA3, 0x019759B81901738A887755E9E96F97A9, 0x019759B8191370B6B59CBED558DE329A, 0x019759B8192471C2AF56FC62D390A9B3, 0x019759B8190F737D903817FD917C9E1D, 0x019759B819177010A761A0168A36DE0C, 0x019759B8191F70E98A3AC198ACDCCBCB, 0x019759B818FD70C6B9C8085EC8955D4C, 0x019759B8190D7056AC27DBE0FC9D6BF1));