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/018d1ccf7ad27d67b879c00ac8a73c8d', '/navigation/018d0d69d68e771b8e641da590102e2f', '/navigation/018d0d69f66d716a8921ad415e39e08c', '/navigation/018d0d6a13597cc4ac60f26c00b9a314', '/navigation/018d0d6a286871f2ab709a84db86b6f1', '/navigation/018db201d355762d8075c757f6bbe1d8', '/navigation/01907311da4c72b78ef854541761651d', '/navigation/01907312cff4737fbe14d06bf406f789', '/navigation/0190a6494e1c77878c4f8603f08ad74b', '/navigation/0190a64a6a6b79838781dc4aad1cce59', '/navigation/0190a64aaaf87696968623812796a456', '/navigation/018d1cca0fc477c7858ae41614282efd', '/navigation/018d1ccb70dd721a9bf6a7692e7ba59d', '/navigation/018d1ccb8e8a7b91b086410da82b6b7a', '/navigation/018d1ccba98371ab99aee87c446fbadc', '/navigation/019082a2f0417eda92e62d54ecb1adee', '/navigation/01932b5658e370658028a75f116279e6', '/navigation/01932ecff9a67792be64243d2f522482', '/navigation/018d1cca96287aa5a4d3a323d680b7d9', '/navigation/018d1ccc7b8f7133b2cdd1bdeb959798', '/navigation/018d1ccc9a1772a4a9a734a6b7f99565', '/navigation/018d1cced0d97d6a99764dd3e170a3a3', '/navigation/018d1ccf34ba702c9e10dd849c1da4f4', '/navigation/018d1ccf5a3970b2a212efb082ae0a51', '/navigation/01932ecfb4457c0e80bf1a83e303e9d7', '/navigation/018d1cd980a77f619e3dedb6b9cc5790', '/navigation/019058eda84d76b4a7a7a41d21ed533d', '/navigation/019058edd9977adaae38404e99ca6080', '/navigation/01904f2f3d45742890c3dd51a5ffa8a3', '/navigation/01904f334493741fa65c4b58c8431421', '/navigation/01904f33743371f09ba969ccba4be140', '/navigation/01904f33936876da82f9502dd9f8341d', '/navigation/01907c9cf727779492968eb6f02628e3', '/navigation/01907c9d57ee73cea7c44920a198c70d', '/navigation/01907caca0b176fcba6ba1d12809d0ce', '/navigation/01907d5a5ee8733daba63a427e0cc404', '/navigation/01914c0dfcfe79c1a9561018509f2647', '/navigation/01914c0fdc8674d8aebf3ab5bb49dae5', '/navigation/019156adf9d7702b86b0102043155df5', '/navigation/019156af43027d7499128bbfead4d40a', '/navigation/018d798ca0337f72bf2011011354cbfe', '/navigation/018d799493bf7c0b88d32b8d549c6e9e', '/navigation/018d7994aa9f7a8fb7b6ae8e54130873', '/navigation/018d7994bca87784a0c3cf968a9fbd7e', '/navigation/018d7994e9a47257b66584cfa12accab', '/navigation/018d7995143e74fdab4465f5d871ea86', '/navigation/018d7995308f71a88e988ed7f031656e', '/navigation/018d79954036770ab9e80b3aacd253ea', '/navigation/018d79955db07a16a7d4d9163b7e5662', '/navigation/018ed1ae9a9772eeb453f96a3967b543', '/navigation/018d7f86fb017fa5b40aecfa435dc9ef', '/navigation/018d7f8af7b076e89cbb170ca60fb70d', '/navigation/018d7f8b56b3739fa5bd22f314b00f3b', '/navigation/018d7f8bcd887723ad65bd245244a3d9', '/navigation/01974f4bf36779c2bae1629f91bec828', '/navigation/018d7f8bfbc2783d9e1e55dcc3025aba', '/navigation/018d7f8c2c8f7c219e034ab5e24f89f3', '/navigation/018d7f8c7e577a539b8249b35ef20977', '/navigation/01978c62dbad7aaa9cd718d3a0ef2790', '/navigation/018d7f8d35dd7d59af65a7edab9ac2b0', '/navigation/018d7f8d78b47d1d87e487e190adb37d', '/navigation/018d7f8e038a7420b6081986a478f96c', '/navigation/018d7f8e1ecb7b7ea903de3c1e864606', '/navigation/018d7f8e6eb0750c9c650ef0cf6e24ca', '/navigation/01978c8123f37ccdb8b26db0797bb857', '/navigation/018d798c137d7c2282d094995d05b93e', '/navigation/018d798f3d3a73ee94592a0efc2fb133', '/navigation/018d798f5c6e70e5ada6fdf991695678', '/navigation/018d798f6aea75489b0f4629e78534c8', '/navigation/018d798f80e9797e8c4f6b18440dbd48', '/navigation/018f05894c157874a4f31ad60699664a', '/navigation/018d798f9c7271a1abb70b5786fd6806', '/navigation/018fc3e2615e7513ab5c162c7ee600c3', '/navigation/019417d4de877b3789dd8f0d86803fc8', '/navigation/018d798c5415797aab7059d6435ee7cc', '/navigation/018d79920c6f77568dd4b02f803abddf', '/navigation/018d7992355570d2aa189e3cc3d909ee', '/navigation/018d7992467e718b980c498af706b080', '/navigation/018d79925e3f79078d435c1c47d65a03', '/navigation/018d7992815c7a6da59df461721d88d3', '/navigation/018d7992a68678f3a46c42c63c4b67f3', '/navigation/018d7992ba8e74d1b01184c76bf3d558', '/navigation/018d7992e5d07b8c8e5ebfffc9152270', '/navigation/018f2ec74e5875f1ab2bbbfc6e49afd1', '/navigation/018f3339d9207c179704000d2fa22eb8', '/navigation/018d798c73e971349ccd39e031af1efa', '/navigation/018d7997db3c797cb8f26537455e5b44', '/navigation/018d7997fa55714faee916781c8eb417', '/navigation/01909b70a946727fbaeb1b9b7af9e94b', '/navigation/018d79980e4c7e04887a79dd743b885f', '/navigation/018d799828be70f7ad3d3df40ad27756', '/navigation/018d7998496b722cb85379057201afd0', '/navigation/018e1e5a25e672acabb6572b599c7f0e', '/navigation/018d799862fc74f8a465c674fa5d45a3', '/navigation/018d799888fd7f0c95390632b99cc36c', '/navigation/018d7998a1477efd891e65b3a89c15db', '/navigation/01907da39f57733bbffd5bb6bde0c67b', '/navigation/018d7998b96b74939209fe3a26058e75', '/navigation/018d7998c110736185bdcf77aa7c1d78', '/navigation/0190790cbc407ff799ab4bdb479d500b', '/navigation/018d798cb3737cf0b9e9bb7447558e3a', '/navigation/018d7996139a7edf88d5b033a1b535cc', '/navigation/018d799627e07a90b6007d312f68ab6f', '/navigation/018d799633f87c98a2a9538287160792', '/navigation/018d7996436d7c9bb270a167256f1cad', '/navigation/018d799650ec7d889b788e01302cde03', '/navigation/018d79967bf27b4a9494bfbbdeb02b7b', '/navigation/018d799692b07e958f2efdd4a80c486a', '/navigation/01941bb5c2c774538ac0b4ca9c970392', '/navigation/018d798c2dfc7866a8e0ecf1308238a8', '/navigation/018d79903c78724696183a7a8debbfa8', '/navigation/018d79907459785b9ca979e8cc82d2e9', '/navigation/018d799095aa7f40a1ba305792fdcbff', '/navigation/018d7990ad35737eb4aabb67ed93d6a9', '/navigation/018d7990ccb07c45aab3739686f28210', '/navigation/018d7990e64b71428dbfdae71b96ff91', '/navigation/018d7991056673e4b0b14e382bc58597', '/navigation/018d7991435e7e419d95de9c529fde5f', '/navigation/018f1a5335247d64b846716eb9bcbce9', '/navigation/018d798be76a759899f82b7657bad8c8', '/navigation/018d798da8327811ae37de17cbad82ba', '/navigation/018d798dd6ff796292913f2632e7d1cb', '/navigation/018d798def1e7f7dbaca72805778da76', '/navigation/018d798e112e75e891abbe52d37895b4', '/navigation/018d798e3afe79bbbcbdcc70b7ce7754', '/navigation/018d798e5b85731392cb6d10036755b7', '/navigation/018d798e7bcc7072822ce9dde90b8d8a', '/navigation/018f0ad75a9f72aa9f7ba1f75a353169', '/navigation/018f0ad78b817050bc65a4d87ae831d8', '/navigation/018d798c87027df8be89dddfc73f1b9c', '/navigation/018d799399de73b6b13819e52c62f52b', '/navigation/018d7993b1d774a8b3d55c5f2f38bc1a', '/navigation/018d7993b9197930aeb3f19554b32e9e', '/navigation/018d7993c3917bfcb77cc05b0f8d6586', '/navigation/018d7994087f730bbde52efd57fdfa4b', '/navigation/018d798cc43977f8ad7bb0e6ca730d30', '/navigation/0191504d46c7720ca2f558ea16007d0c', '/navigation/0191504d9dc07ffe9de628b64db2a800', '/navigation/0191504ddd977809b86aaf45f8d1c014', '/navigation/0191504df72270ac92b7849baac22b21', '/navigation/0191504e0c2b7a0ba4afa1bbc0f3935f', '/navigation/019150769cba7483859b027e61b23f1e', '/navigation/018d8dd96965747e8a9407f2474cdb20', '/navigation/018dfa3560987115903405c6c120e898', '/navigation/018dfa35b9487a68a1e8b37abfaa0348', '/navigation/018dfa35cc127574ae8d9c34a8a09f3a', '/navigation/018dfa35e91c7c3ca1e574acee84ec82', '/navigation/018df052a1bc79019889f086dbd0f979', '/navigation/01909d05b6637c6886a512167f4026d7', '/navigation/018deb48635a7d8b9f28c291f2852e35', '/navigation/018e36ad3a4c79d6bf651506e9517b5f', '/navigation/018e36ad202a710da7cb7620c7456bf2', '/navigation/0190a11f434c7f08a19246996f8705c0', '/navigation/018e36ad53eb7b90a1c8dfc97e8af9fb', '/navigation/018e36ad762c7e3d8c79e38695ad8c2e', '/navigation/018dfa2c2e257ebfbdb08040288f1c78', '/navigation/018e36b6d07f73d184bff599f0aff646', '/navigation/018e36b86a127d719a6e6e602663c2b1', '/navigation/018e36b9013071a48093b39b9319ce35', '/navigation/018eeafb8f4d7a10b0bc17b9610fa5d2', '/navigation/018eeafd1014783d87acd41c9264dfcf', '/navigation/01907d6a2bb67c2a87ec839b7743716f', '/navigation/019417e3e4e37073863356c63867e715', '/navigation/018d1c66795c7f74bc77cecbb853a0fe', '/navigation/018d558f359c77d0ace69a3b1a96a216', '/navigation/018d1c6747b972daad0098a032939cec', '/navigation/018d1c67a20e725d937ebbc53599db2b', '/navigation/018d796947547dfd8d2e2065c8118068', '/navigation/018d1c67f4057fa68bf3c34c781eea72', '/navigation/018d1c6b162974099ba883c6eb8c6cbe', '/navigation/018d8d0be31170a49c81f12f4c4db06f', '/navigation/018d1c6b26737d9186d9d0a48cf587f3', '/navigation/018d1c69d4317b8da3bdb370d3eb65c7', '/navigation/018d1c6c02db7182b7f79c36577eb131', '/navigation/018d1c6c15aa753bb104d935d596d67b', '/navigation/018d21d9b115734da88e8a518a80bf29', '/navigation/018d1c69faba70d39b9396f66c326da8', '/navigation/018d1c6b713b79dcad7ae1ef9af54025', '/navigation/018d1c6b9065757aa32d89cc20c38106', '/navigation/018d1c6b992c7835a9ef66b93c2b73b0', '/navigation/018d69984507787da49ef5d998103dd1', '/navigation/018d1c6ba6a57a87ad9ce6454631898e', '/navigation/018d1c6bb8177718976663aa106987df', '/navigation/018d699829c97b4c8b127d5159fc308c', '/navigation/018d1c6a340e7840a36ac0e829ee2e10', '/navigation/018d1c6c4cea7840859de1279530f240', '/navigation/018d1c6c648e71b2af970330aa2b331d', '/navigation/018d1c6c738974af9d28e4b99f2071bb', '/navigation/018d1c6c7b777bf49b0b3a81764f955b', '/navigation/018d6998dc5074f0a108bdc68793aeb0', '/navigation/018d1c6c81fa7f02a5799aaf469f25e3', '/navigation/018d65680375756d92b612f541212574', '/navigation/018d1c6a52027080a9e3bbccda5f88a6', '/navigation/018dcc8d773c79a69a89d5e8816df1ec', '/navigation/018d1c6cf06975ef8c7137e134d5944c', '/navigation/018d1c6cfb7d7da28862d2e424c39c60', '/navigation/018d69e8955275b587c7702495403a3e', '/navigation/018dc2149a5371f4b372178ff7847c12', '/navigation/018d1c6aaf177472b147aa2fe7b92508', '/navigation/018d1c6d1d227e2a9cb25641d34d39f5', '/navigation/018d1c6d4fab7b8eb80a0de8825240cb', '/navigation/018d1c6d5d15796cb2a4d7fa6314611f', '/detail/01932ed70509713dafc3b6026059fd9f', '/detail/01932ed717a871deb2cc6c51ee296d27', '/detail/01932ed7261a7213bc137e4eb4a50afe', '/detail/01932ed7336671e3981dd653e6f321a4', '/detail/01932ed740ff7349b2004b9f52b5bc5b', '/detail/01932ed74ead71ebb5cc9dd196becd65', '/detail/01932ed792bd720bb368ab1de88c60a2', '/detail/01932ed7d536717384b39b9c78d4b2f7', '/detail/01932ed81afd7219a302041594c21267', '/detail/01932ed85e047312a44c0544a50d28b5', '/detail/01932ed6f3717016b5616cb458436b35', '/detail/01932ed6548c7276907180a421ccc416', '/detail/01932ed663ab7097b62bae3c6a712d6a', '/detail/01932ed671fe737fb77c34b0eb9f3fd8', '/detail/01932ed6804772b4a183368c08b21b49', '/detail/01932ed68f1d70269192d6ab7459fdaa', '/detail/01932ed69d0c73f1991c15b90f13711e', '/detail/01932ed6e107726d803e8118a8b4dfcb', '/detail/01932ed727c8734594009cb5e25b1d41', '/detail/01932ed76d8d7253a6393e2badbf1ba9', '/detail/01932ed7afb873c6961adc223a95adfe', '/detail/01932ed642e473b7a579db39355bd270', '/detail/01932fbecbc7720e836915aa488b065e', '/detail/01932fbedb42706ea109133c46710587', '/detail/01932fbee882727cb20a675874fa4014', '/detail/01932fbef5e672d4b6a6d49b7dea512f', '/detail/01932fbf03d272b08934166259da6eac', '/detail/01932fbf116670b69c87395aec33d9c3', '/detail/01932fbf52f1706a84f961b8e2c4aa50', '/detail/01932fbfa51b739f95700c9593545ceb', '/detail/01932fbfee367014bf5f7af887974e1c', '/detail/01932fc0383f70d586aad91046423c9f', '/detail/01932fbeb6c2706990c566848f1740e0', '/detail/01932a3866757279a73d94428b57d14e', '/detail/01932a387a9e71ebb21413f131a936b0', '/detail/01932a388d3a72dcb9c7b7b4a13083e4', '/detail/01932a389f8e715192f6c012612050bb', '/detail/01932a38b29073dc874af3ec9663d0be', '/detail/01932a38c4b670be946b0156d44b08ab', '/detail/01932a38d79472eab9fae7e63c7fbfd1', '/detail/01932a39552271c19a7de98f5173d54b', '/detail/01932a39c803712186810daedc7f5045', '/detail/01932a3a3f4f708392757f86950c884b', '/detail/01932a3ab8917041be4b58e8baa39953', '/detail/01932a384f13731b833a736d0e05b49b', '/detail/01932a378bed72959ed3b27edb368619', '/detail/01932a379ef2706e9c171600855b19fe', '/detail/01932a37af8170cfadd2654c04ad3d61', '/detail/01932a37d223729b8d7cc87a6c721d56', '/detail/01932a37f3d773219a341b2d050cd0ae', '/detail/01932a381604717e815efcf5aa3e7c85', '/detail/01932a383853710db7aa9a247bd05b13', '/detail/01932a3775b172668cd8cdac4b3c44fa', '/detail/01932fc03e4672c79463e3ea39dde89a', '/detail/01932fc04de67097948bc891512bd747', '/detail/01932fc05c02739f8c3cc0ca5713bbac', '/detail/01932fc06aba73bdb0901ccf94d27904', '/detail/01932fc07a7773f9b89592481bd2b483', '/detail/01932fc0b69f72759ea92fffc0833b48', '/detail/01932fc0f241703eab0b9eefcf453338', '/detail/01932fc12c6370839e9ff06c56d44aa6', '/detail/01932fc1691c7136a597edd8fedcd819', '/detail/01932fc02c32711fb472aa911c8f3e5e', '/detail/01932fc0ce0670eeabd28ee224115c1a', '/detail/01932fc0dd787385b306ebb7c89de05d', '/detail/01932fc0eb3770cda47eb29f74faa43d', '/detail/01932fc0f9657042988395b81f16795e', '/detail/01932fc10877724f927978fa0071739b', '/detail/01932fc116c17364b0d6a177eb95aab8', '/detail/01932fc15dc87088a051789de2a29a30', '/detail/01932fc1a7967244b02cb3812bd3bfb2', '/detail/01932fc1ecd3719bb899bc210ef418e7', '/detail/01932fc232427070bfd41b84bd233664', '/detail/01932fc0baad71a685299bb62e36470b', '/detail/01914c1b821872f480c0cf5bd5bd072d', '/detail/01914c1b8c9b72289c274ac6e484a3ac', '/detail/01914c1b961372f98710f2815e28daca', '/detail/01914c1ba02173d39229773489db2f0c', '/detail/01914c1bbed171d194f28f35c2f57f2f', '/detail/01914c1bdc2170eea70484a77e64f6bf', '/detail/01914c1bf95a730ca11ac68285e592a6', '/detail/01914c1c1584735e9ff64f58f5b2b568', '/detail/01914c1b738b70949f83a6bbc3474c77', '/detail/01915061f94b721ab5a99647c4d42da2', '/detail/0191506203fa73ecbb4b04aedab77922', '/detail/019150620dec7379b009ba28cb4868b0', '/detail/0191506217d07212a91ab668df34917f', '/detail/01915062346573148773c7a288aa199a', '/detail/019150625ab6701ea37383b78a03e999', '/detail/019150627fd171a6b4831f636f858bb6', '/detail/019150629fbc70b5921a44f20c11450f', '/detail/01912d4623f9703cbe61197df1b08676', '/detail/01912d462ea1706194e9139868468e7b', '/detail/01912d46384471389d20f3091444bfef', '/detail/01912d4641a17224bf44f117934f83c6', '/detail/01912d464bc27062bf194313713a3b8e', '/detail/01912d4655ff7065907291500c70dfb9', '/detail/01912d4686d672aa8dc9590202ba0922', '/detail/01912d46ba9173689af166de9acc20e2', '/detail/01912d46edbe73469373502261366b7d', '/detail/01912d471e997116b7789f6cf5394b0f', '/detail/01912d4616c470abbc7af88d8be394e2', '/detail/019154d889cf720a931141a30d0170e4', '/detail/019154d894ce705c900d30e7c856c9df', '/detail/019154d89e8772f7a38e34329f182017', '/detail/019154d8b22d70e284e8d9ba5cf29d72', '/detail/019154d8c6037343a9184ef97f12c8a1', '/detail/019154d8dc5572f080bdc11a0b1e2cbd', '/detail/019154d8f20872c991618acebac48341', '/detail/019154d87c5271d7ad3aef8dae8ea0e5', '/detail/0191550cb68671c5a94106c8568e559f', '/detail/0191550cc1de7254b182a4eca13953a4', '/detail/0191550ccbf072029d621719604ba885', '/detail/0191550cd6037345bb1e62f861021ba2', '/detail/0191550ce03a72c7ae51bd67d05ca8bf', '/detail/0191550cea6f721c9c232f350bc34b08', '/detail/0191550caa3773d1bac102623991d639', '/detail/0191550d5d547333a30adf542969ea65', '/detail/0191550d7037728bbc0eae8a7f33f6e7', '/detail/0191550d7cbc7142ae198acc4e0b2248', '/detail/0191550d92db733687a9600239308eac', '/detail/0191550da85170fcb15fd4702522bee4', '/detail/0191550dbf26701880fabf7bfc129f0b', '/detail/0191550dd4d070f3b0bce384d157ae48', '/detail/0191550d49dc707682449ef12cf45998', '/detail/019154f159d872ec89e65bdf6a3fc0e3', '/detail/019154f1658870a398f2d338f1def28a', '/detail/019154f16f647106a3667da606dc0571', '/detail/019154f1835470c2b7aa7aa3d34ac9a5', '/detail/019154f1a39e737ebf96ff1eb34373db', '/detail/019154f1bfe97202bb79c440c435a3ac', '/detail/019154f1d8d773899ca1c1c810ecd28c', '/detail/019154f14aae73a6b36cda70220c050c', '/detail/01915534dde6703f93f1f065d189704f', '/detail/01915534e984720ca250a036367e5814', '/detail/01915534f42071579368c313587a4345', '/detail/01915534fe8471939e4a53fda6ab4ca3', '/detail/0191553508cc7227b585e173796302ef', '/detail/0191553513557394b96e3b10525d3142', '/detail/01915534cfef706898ae0121ed83f75c', '/detail/0191553527f471688c640efa5f16f670', '/detail/0191553577b97086932ea7ce549b1c32', '/detail/01915535c1bc73748e3fc4b3d6006967', '/detail/019155360b3c72ccad56940e1213b8a2', '/detail/01915536641b7376b5d9c6b7278f1095', '/detail/01905006767273eb979957f2bf5a9fdb', '/detail/0190500682aa72d9985b78c6a888cd8d', '/detail/019050068e0b7250975ad58cbea41847', '/detail/01905006a41c737d8d99b0817a6bb227', '/detail/01905006bb3e713a8b925294b20b2e74', '/detail/01905006d1db70f4bbdc00ef0ca79497', '/detail/01905006e8357188939e3c30358296e2', '/detail/0190500668d07376ac853f6b50a9c93b', '/navigation/018d699780877193928c9aca4e6541db', '/navigation/018d6999f4e07f12a4daa1f82f136ed0', '/navigation/018d699a0b6f7c4e986fd93ab78d54fd', '/navigation/018d699a2507753f94b3e13840f75530', '/navigation/018d699a3ccf79da990026bafb371068', '/navigation/018d6997be1f7d5f966f4bb384577141', '/navigation/018d699934747d28931433d750581d40', '/navigation/018d69994e2f79b7bd52db66969bfae4', '/navigation/018d6999639f7f4097b3f167fb6cc563', '/navigation/018d69997c4f781f9b303629047e69fc', '/navigation/018d6997cbd17c25990872dff8544659', '/navigation/018d6998abc07f0b80f0782c522349b1', '/navigation/018ef21fde9f7fc08d3dd0651ad4e0cb')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x018C87065CBD73169FB857B3ACB9BAFE OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
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 `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      `product`.`parent_id` = ?
      AND `product`.`available` = ?
      AND JSON_CONTAINS(
        IFNULL(
          `product`.`option_ids`, `product.parent`.`option_ids`
        ),
        JSON_ARRAY(?)
      )
      AND JSON_CONTAINS(
        IFNULL(
          `product`.`option_ids`, `product.parent`.`option_ids`
        ),
        JSON_ARRAY(?)
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
LIMIT
  1

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` 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 `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` = 0x01932ED6F3717016B5616CB458436B35 AND `product`.`available` = 1 AND JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('018dd536bac172b78cd5bf456cdb5e24')) AND JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('019224232a2f70a58b22f6d7b9c8c156')) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x018C87065CBD73169FB857B3ACB9BAFE AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) LIMIT 1;

# 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 (0x01932ED70509713DAFC3B6026059FD9F, 0x01932ED6548C7276907180A421CCC416, 0x01932FBECBC7720E836915AA488B065E, 0x01932A3866757279A73D94428B57D14E, 0x01932A378BED72959ED3B27EDB368619, 0x01932FC03E4672C79463E3EA39DDE89A, 0x01932FC0CE0670EEABD28EE224115C1A, 0x01914C1B821872F480C0CF5BD5BD072D, 0x01915061F94B721AB5A99647C4D42DA2, 0x01912D4623F9703CBE61197DF1B08676, 0x019154D889CF720A931141A30D0170E4, 0x0191550CB68671C5A94106C8568E559F, 0x0191550D5D547333A30ADF542969EA65, 0x019154F159D872EC89E65BDF6A3FC0E3, 0x01915534DDE6703F93F1F065D189704F, 0x01905006767273EB979957F2BF5A9FDB));