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/0196eb797b4f72c2853f137d8672d7f7', '/navigation/0196eb797b5171fab979697470a9ab14', '/navigation/0196eb797b5b72978783d3b67c58ae50', '/navigation/0196eb797b5f7240b84e8f845c96c08a', '/navigation/0196eb797b69737980d2aa835ec50a8d', '/navigation/0196eb797b6b71ba8ac1f7441c5a758c', '/navigation/0196eb797b6f70bc9be06277a570e550', '/navigation/0196eb797b8472299fe5de6203647dc6', '/navigation/0196eb797b85706198c9a4d7cd5a9c6e', '/navigation/0196eb797b9671a38ceb9be997621914', '/navigation/0196eb797b5070cba2a19c0abd1ce27d', '/navigation/0196eb797b5070cba2a19c0abd9b3a36', '/navigation/0196eb797b5070cba2a19c0abdc9ed48', '/navigation/0196eb797b5070cba2a19c0abde35aa4', '/navigation/0196eb797b5171fab9796974664e2b13', '/navigation/0196eb797b5171fab979697466cc58d3', '/navigation/0196eb797b5171fab97969746781258d', '/navigation/0196eb797b5171fab9796974687b9084', '/navigation/0196eb797b5171fab9796974696aad1e', '/navigation/0196eb797b5171fab979697469bfb2e3', '/navigation/0196eb797b5171fab97969746a3bd026', '/navigation/0196eb797b5171fab97969746a70e2e2', '/navigation/0196eb797b5171fab97969746b293a72', '/navigation/0196eb797b5171fab97969746c00b99e', '/navigation/0196eb797b5171fab97969746cd85468', '/navigation/0196eb797b5171fab97969746d856882', '/navigation/0196eb797b5171fab97969746e12af4c', '/navigation/0196eb797b5171fab97969746e905986', '/navigation/0196eb797b5171fab97969746e9d47ba', '/navigation/0196eb797b5171fab97969746eee0df8', '/navigation/0196eb797b5171fab97969746fd0bf33', '/navigation/0196eb797b5171fab97969746ff13c30', '/navigation/0196eb797b52711aa14445f656ba8a47', '/navigation/0196eb797b52711aa14445f656bd8a20', '/navigation/0196eb797b52711aa14445f65754e6e9', '/navigation/0196eb797b52711aa14445f65874fd2e', '/navigation/0196eb797b52711aa14445f659d8dcc6', '/navigation/0196eb797b52711aa14445f65c0ca6d9', '/navigation/0196eb797b52711aa14445f65c5307b9', '/navigation/0196eb797b52711aa14445f65d14b146', '/navigation/0196eb797b5371c6ac8daf91f8ea871e', '/navigation/0196eb797b5371c6ac8daf91fa5ba38b', '/navigation/0196eb797b5371c6ac8daf91faa9db7d', '/navigation/0196eb797b5371c6ac8daf91fbc8c35d', '/navigation/0196eb797b5371c6ac8daf91fd8fdacd', '/navigation/0196eb797b5472998d9944dd0bee0357', '/navigation/0196eb797b5472998d9944dd0bfffa48', '/navigation/0196eb797b5472998d9944dd0edd3c4c', '/navigation/0196eb797b5472998d9944dd1146784d', '/navigation/0196eb797b5472998d9944dd14628027', '/navigation/0196eb797b5571128899e82d195559d2', '/navigation/0196eb797b5571128899e82d1c6a20b9', '/navigation/0196eb797b5571128899e82d1cb9c94b', '/navigation/0196eb797b5571128899e82d1d9a2fe5', '/navigation/0196eb797b5571128899e82d1f8beb80', '/navigation/0196eb797b567203b77a20bf81efd293', '/navigation/0196eb797b567203b77a20bf832f4d0f', '/navigation/0196eb797b567203b77a20bf8502dcc8', '/navigation/0196eb797b567203b77a20bf85f613fe', '/navigation/0196eb797b567203b77a20bf86c4dd3d', '/navigation/0196eb797b577085bc49d1f91c8f2434', '/navigation/0196eb797b577085bc49d1f91fc3774e', '/navigation/0196eb797b577085bc49d1f9202fed64', '/navigation/0196eb797b577085bc49d1f9223703a6', '/navigation/0196eb797b5872d58f4720aee6785a97', '/navigation/0196eb797b5872d58f4720aee6e723f1', '/navigation/0196eb797b5872d58f4720aee9514cea', '/navigation/0196eb797b5872d58f4720aeeb813363', '/navigation/0196eb797b5872d58f4720aeee5d8783', '/navigation/0196eb797b5972b29b524077d48e7de4', '/navigation/0196eb797b5972b29b524077d6844bfd', '/navigation/0196eb797b5972b29b524077d7123576', '/navigation/0196eb797b5972b29b524077d7c00767', '/navigation/0196eb797b5972b29b524077dbf7ba2f', '/navigation/0196eb797b5a718abb9b4a563e1b365e', '/navigation/0196eb797b5a718abb9b4a56405b7e78', '/navigation/0196eb797b5a718abb9b4a56431930a2', '/navigation/0196eb797b5a718abb9b4a564511a871', '/navigation/0196eb797b5b72978783d3b6770f906a', '/navigation/0196eb797b5b72978783d3b67a3eff0d', '/navigation/0196eb797b5b72978783d3b67d2b1e9a', '/navigation/0196eb797b5b72978783d3b67ddaf8c1', '/navigation/0196eb797b5b72978783d3b67e253a56', '/navigation/0196eb797b5b72978783d3b67edd8ec3', '/navigation/0196eb797b5b72978783d3b67fd864a0', '/navigation/0196eb797b5b72978783d3b6808da6cd', '/navigation/0196eb797b5b72978783d3b6812201cb', '/navigation/0196eb797b5c705190f300d2619292e2', '/navigation/0196eb797b5c705190f300d262500aad', '/navigation/0196eb797b5c705190f300d262d447f7', '/navigation/0196eb797b5c705190f300d2630fe16f', '/navigation/0196eb797b5c705190f300d2637d6902', '/navigation/0196eb797b5c705190f300d2644a0642', '/navigation/0196eb797b5c705190f300d264a27e92', '/navigation/0196eb797b5c705190f300d265538c64', '/navigation/0196eb797b5c705190f300d265a825f1', '/navigation/0196eb797b5c705190f300d266966e0b', '/navigation/0196eb797b5c705190f300d266e0cf35', '/navigation/0196eb797b5c705190f300d2671a1554', '/navigation/0196eb797b5c705190f300d2671d09d4', '/navigation/0196eb797b5c705190f300d267b4a5fc', '/navigation/0196eb797b5c705190f300d267cfe5a8', '/navigation/0196eb797b5c705190f300d26830c1a2', '/navigation/0196eb797b5c705190f300d2689d148f', '/navigation/0196eb797b5c705190f300d2698a4da8', '/navigation/0196eb797b5c705190f300d269ff251d', '/navigation/0196eb797b5c705190f300d26aab0863', '/navigation/0196eb797b5d71d2b532f5122fe514f6', '/navigation/0196eb797b5d71d2b532f512307f2cf6', '/navigation/0196eb797b5d71d2b532f51230d760f0', '/navigation/0196eb797b5d71d2b532f512310f59e4', '/navigation/0196eb797b5d71d2b532f5123174020e', '/navigation/0196eb797b5d71d2b532f51231b63e23', '/navigation/0196eb797b5d71d2b532f51232516bfb', '/navigation/0196eb797b5d71d2b532f51232dd9c94', '/navigation/0196eb797b5d71d2b532f51232eddc1e', '/navigation/0196eb797b5d71d2b532f51232fcfbb5', '/navigation/0196eb797b5d71d2b532f5123391ff3a', '/navigation/0196eb797b5d71d2b532f51233ae07b0', '/navigation/0196eb797b5d71d2b532f51234309af9', '/navigation/0196eb797b5d71d2b532f512346d2083', '/navigation/0196eb797b5d71d2b532f51234a55e31', '/navigation/0196eb797b5d71d2b532f512353681ab', '/navigation/0196eb797b5d71d2b532f512356625e2', '/navigation/0196eb797b5e73beabb19ddb1271dc63', '/navigation/0196eb797b5e73beabb19ddb13260f65', '/navigation/0196eb797b5e73beabb19ddb13d364d0', '/navigation/0196eb797b5e73beabb19ddb14052de9', '/navigation/0196eb797b5e73beabb19ddb14ee1f27', '/navigation/0196eb797b5e73beabb19ddb14fee37e', '/navigation/0196eb797b5e73beabb19ddb15ace3c5', '/navigation/0196eb797b5e73beabb19ddb15d8ff75', '/navigation/0196eb797b5e73beabb19ddb15e705f1', '/navigation/0196eb797b5e73beabb19ddb16a3dad1', '/navigation/0196eb797b5e73beabb19ddb171eb806', '/navigation/0196eb797b5e73beabb19ddb17d0e81c', '/navigation/0196eb797b5e73beabb19ddb18435380', '/navigation/0196eb797b5e73beabb19ddb18d95775', '/navigation/0196eb797b5e73beabb19ddb1972597e', '/navigation/0196eb797b5e73beabb19ddb199fbce5', '/navigation/0196eb797b5f7240b84e8f845d123a85', '/navigation/0196eb797b5f7240b84e8f845da06616', '/navigation/0196eb797b5f7240b84e8f845e15b118', '/navigation/0196eb797b5f7240b84e8f846008b0e5', '/navigation/0196eb797b5f7240b84e8f8461e25fc1', '/navigation/0196eb797b5f7240b84e8f8463ab5454', '/navigation/0196eb797b6070f2806af51a060d5cad', '/navigation/0196eb797b6070f2806af51a06351159', '/navigation/0196eb797b6070f2806af51a07fbd06f', '/navigation/0196eb797b6070f2806af51a099c6e52', '/navigation/0196eb797b6070f2806af51a0a5e9e88', '/navigation/0196eb797b6070f2806af51a0c83cb39', '/navigation/0196eb797b61721fb4fd064981a12be3', '/navigation/0196eb797b61721fb4fd06498355e45c', '/navigation/0196eb797b61721fb4fd0649867c14a8', '/navigation/0196eb797b6271429e2731fe51f3aead', '/navigation/0196eb797b6271429e2731fe52f21500', '/navigation/0196eb797b6271429e2731fe5380c1ab', '/navigation/0196eb797b6271429e2731fe56896527', '/navigation/0196eb797b6271429e2731fe57abdf8e', '/navigation/0196eb797b6271429e2731fe5828a169', '/navigation/0196eb797b6271429e2731fe5992fd70', '/navigation/0196eb797b63719ba030b61042186a52', '/navigation/0196eb797b63719ba030b61043f38601', '/navigation/0196eb797b63719ba030b610443a40db', '/navigation/0196eb797b63719ba030b6104742a9d0', '/navigation/0196eb797b64738bbe07a759daa00d81', '/navigation/0196eb797b64738bbe07a759de14da79', '/navigation/0196eb797b64738bbe07a759e07be13a', '/navigation/0196eb797b64738bbe07a759e1479fac', '/navigation/0196eb797b657252a71436eed5696199', '/navigation/0196eb797b657252a71436eed6f2af56', '/navigation/0196eb797b657252a71436eed9d34a2b', '/navigation/0196eb797b657252a71436eeda164c10', '/navigation/0196eb797b6672da9d8a6636e4168149', '/navigation/0196eb797b6672da9d8a6636e61480f3', '/navigation/0196eb797b6672da9d8a6636e93b834f', '/navigation/0196eb797b6672da9d8a6636ebb0f559', '/navigation/0196eb797b6773958427a30aea63a644', '/navigation/0196eb797b6773958427a30aeb34a233', '/navigation/0196eb797b6773958427a30aebe35ebc', '/navigation/0196eb797b6773958427a30aed7af07b', '/navigation/0196eb797b687081ae3ac792e4e17753', '/navigation/0196eb797b687081ae3ac792e523bd81', '/navigation/0196eb797b687081ae3ac792e63e8806', '/navigation/0196eb797b687081ae3ac792e98d8928', '/navigation/0196eb797b69737980d2aa8358739f94', '/navigation/0196eb797b69737980d2aa835874adbc', '/navigation/0196eb797b69737980d2aa835a58fff5', '/navigation/0196eb797b69737980d2aa835c5d49ee', '/navigation/0196eb797b69737980d2aa835d982fdb', '/navigation/0196eb797b69737980d2aa835f1d8b25', '/navigation/0196eb797b69737980d2aa836003ac66', '/navigation/0196eb797b69737980d2aa8360bb3f55', '/navigation/0196eb797b6a700d8313adaac2407560', '/navigation/0196eb797b6a700d8313adaac2bcfd17', '/navigation/0196eb797b6a700d8313adaac3813b98', '/navigation/0196eb797b6a700d8313adaac383ad4f', '/navigation/0196eb797b6a700d8313adaac45998f4', '/navigation/0196eb797b6a700d8313adaac4b5b58a', '/navigation/0196eb797b6a700d8313adaac58a5b12', '/navigation/0196eb797b6a700d8313adaac5dea001', '/navigation/0196eb797b6a700d8313adaac60d8d98', '/navigation/0196eb797b6a700d8313adaac6553203', '/navigation/0196eb797b6a700d8313adaac65ad32c', '/navigation/0196eb797b6a700d8313adaac69d6990', '/navigation/0196eb797b6a700d8313adaac74d710d', '/navigation/0196eb797b6a700d8313adaac777c85b', '/navigation/0196eb797b6a700d8313adaac7b1e8c3', '/navigation/0196eb797b6a700d8313adaac7c09229', '/navigation/0196eb797b6b71ba8ac1f7441c90de50', '/navigation/0196eb797b6b71ba8ac1f7441d5179f9', '/navigation/0196eb797b6b71ba8ac1f7441e4d2468', '/navigation/0196eb797b6b71ba8ac1f7441e817d65', '/navigation/0196eb797b6b71ba8ac1f7441ea6882c', '/navigation/0196eb797b6b71ba8ac1f7441ed771ab', '/navigation/0196eb797b6b71ba8ac1f7441f370109', '/navigation/0196eb797b6b71ba8ac1f7441f94c25b', '/navigation/0196eb797b6b71ba8ac1f7441fcf5975', '/navigation/0196eb797b6b71ba8ac1f74420340e3e', '/navigation/0196eb797b6b71ba8ac1f74420d79c73', '/navigation/0196eb797b6b71ba8ac1f74421c58d75', '/navigation/0196eb797b6b71ba8ac1f74422aff8e8', '/navigation/0196eb797b6b71ba8ac1f74423958947', '/navigation/0196eb797b6b71ba8ac1f74423db2588', '/navigation/0196eb797b6b71ba8ac1f7442477f013', '/navigation/0196eb797b6b71ba8ac1f744251f0371', '/navigation/0196eb797b6c70c5937129c36d38c711', '/navigation/0196eb797b6c70c5937129c36dfd18ce', '/navigation/0196eb797b6c70c5937129c36e0a20b2', '/navigation/0196eb797b6c70c5937129c36e99e237', '/navigation/0196eb797b6c70c5937129c36e9c512a', '/navigation/0196eb797b6c70c5937129c36f843d22', '/navigation/0196eb797b6c70c5937129c37032b7f2', '/navigation/0196eb797b6c70c5937129c3705fe273', '/navigation/0196eb797b6c70c5937129c37119be7d', '/navigation/0196eb797b6c70c5937129c3718534a6', '/navigation/0196eb797b6c70c5937129c37258084d', '/navigation/0196eb797b6c70c5937129c373364da1', '/navigation/0196eb797b6c70c5937129c3733c38aa', '/navigation/0196eb797b6c70c5937129c373c21846', '/navigation/0196eb797b6c70c5937129c3746da72f', '/navigation/0196eb797b6c70c5937129c3747cb5ad', '/navigation/0196eb797b6d73bebc2d03a1b0008a77', '/navigation/0196eb797b6d73bebc2d03a1b0ab7599', '/navigation/0196eb797b6d73bebc2d03a1b1796a3e', '/navigation/0196eb797b6d73bebc2d03a1b1cbe03d', '/navigation/0196eb797b6d73bebc2d03a1b21f8058', '/navigation/0196eb797b6d73bebc2d03a1b2f1ed26', '/navigation/0196eb797b6d73bebc2d03a1b315dd96', '/navigation/0196eb797b6d73bebc2d03a1b37e1393', '/navigation/0196eb797b6d73bebc2d03a1b414d7c2', '/navigation/0196eb797b6d73bebc2d03a1b44f8a20', '/navigation/0196eb797b6d73bebc2d03a1b494f70e', '/navigation/0196eb797b6d73bebc2d03a1b4ca1f87', '/navigation/0196eb797b6d73bebc2d03a1b592073e', '/navigation/0196eb797b6d73bebc2d03a1b614e181', '/navigation/0196eb797b6d73bebc2d03a1b653e347', '/navigation/0196eb797b6d73bebc2d03a1b698f560', '/navigation/0196eb797b6e722aac77c24ddf14ea82', '/navigation/0196eb797b6e722aac77c24ddf8011b6', '/navigation/0196eb797b6e722aac77c24ddf9a0a31', '/navigation/0196eb797b6e722aac77c24de094025d', '/navigation/0196eb797b6e722aac77c24de15b3c38', '/navigation/0196eb797b6e722aac77c24de175f099', '/navigation/0196eb797b6e722aac77c24de1e786b6', '/navigation/0196eb797b6e722aac77c24de248c58d', '/navigation/0196eb797b6e722aac77c24de24d27d5', '/navigation/0196eb797b6e722aac77c24de301a088', '/navigation/0196eb797b6e722aac77c24de30b57c4', '/navigation/0196eb797b6e722aac77c24de325850c', '/navigation/0196eb797b6e722aac77c24de3a14d90', '/navigation/0196eb797b6e722aac77c24de3dd4b81', '/navigation/0196eb797b6e722aac77c24de47d12c8', '/navigation/0196eb797b6e722aac77c24de4dc1b67', '/navigation/0196eb797b6e722aac77c24de5460246', '/navigation/0196eb797b6e722aac77c24de55751eb', '/navigation/0196eb797b6f70bc9be062779d2ad0e0', '/navigation/0196eb797b6f70bc9be062779d9b3ada', '/navigation/0196eb797b6f70bc9be062779e37d0aa', '/navigation/0196eb797b6f70bc9be062779efecbfc', '/navigation/0196eb797b6f70bc9be062779fb47828', '/navigation/0196eb797b6f70bc9be062779fdc7053', '/navigation/0196eb797b6f70bc9be06277a0213d16', '/navigation/0196eb797b6f70bc9be06277a0e6fcb8', '/navigation/0196eb797b6f70bc9be06277a1b74843', '/navigation/0196eb797b6f70bc9be06277a1e30f85', '/navigation/0196eb797b6f70bc9be06277a209a5d1', '/navigation/0196eb797b6f70bc9be06277a23c3345', '/navigation/0196eb797b6f70bc9be06277a2d8a42a', '/navigation/0196eb797b6f70bc9be06277a367bb68', '/navigation/0196eb797b6f70bc9be06277a414c286', '/navigation/0196eb797b6f70bc9be06277a4b92071', '/navigation/0196eb797b6f70bc9be06277a5e824cd', '/navigation/0196eb797b7071aeb6cf97ea873e0ece', '/navigation/0196eb797b7071aeb6cf97ea87734e34', '/navigation/0196eb797b7071aeb6cf97ea89299710', '/navigation/0196eb797b7071aeb6cf97ea8c18b819', '/navigation/0196eb797b7171ec913fdb3e8de8a7bf', '/navigation/0196eb797b7171ec913fdb3e905ac2cb', '/navigation/0196eb797b7171ec913fdb3e9241eca5', '/navigation/0196eb797b7171ec913fdb3e9271ea04', '/navigation/0196eb797b7171ec913fdb3e94a27f71', '/navigation/0196eb797b72729db93a65ed25a5b804', '/navigation/0196eb797b72729db93a65ed2940acfa', '/navigation/0196eb797b72729db93a65ed2b58c6d9', '/navigation/0196eb797b73724ca36e8056ed7f98c4', '/navigation/0196eb797b73724ca36e8056ede48a1b', '/navigation/0196eb797b73724ca36e8056efb403b3', '/navigation/0196eb797b73724ca36e8056f2746efc', '/navigation/0196eb797b73724ca36e8056f5732e4f', '/navigation/0196eb797b7471189416b6d9393d3a2d', '/navigation/0196eb797b7471189416b6d939fa4097', '/navigation/0196eb797b7471189416b6d93a238bb0', '/navigation/0196eb797b7471189416b6d93d6f79e8', '/navigation/0196eb797b7471189416b6d93eabde59', '/navigation/0196eb797b7471189416b6d9400711ae', '/navigation/0196eb797b7471189416b6d940d007be', '/navigation/0196eb797b7573d4b33f58aa880121de', '/navigation/0196eb797b7573d4b33f58aa8ab59012', '/navigation/0196eb797b7573d4b33f58aa8b6f8d38', '/navigation/0196eb797b7573d4b33f58aa8d402ce3', '/navigation/0196eb797b76737c847ad02e756d638a', '/navigation/0196eb797b76737c847ad02e78a1c505', '/navigation/0196eb797b76737c847ad02e7af4db76', '/navigation/0196eb797b777335be9d6dbc6c6b83fd', '/navigation/0196eb797b777335be9d6dbc6ccb2a30', '/navigation/0196eb797b777335be9d6dbc6d96aa0f', '/navigation/0196eb797b777335be9d6dbc6fb19b4c', '/navigation/0196eb797b777335be9d6dbc7033a607', '/navigation/0196eb797b777335be9d6dbc705112b6', '/navigation/0196eb797b7870fe834512d06f853492', '/navigation/0196eb797b7870fe834512d07247a849', '/navigation/0196eb797b7870fe834512d072a36267', '/navigation/0196eb797b7870fe834512d0737ddadd', '/navigation/0196eb797b7971a0bef5be91e7083bfc', '/navigation/0196eb797b7971a0bef5be91e9e80f32', '/navigation/0196eb797b7971a0bef5be91ec34b41b', '/navigation/0196eb797b7971a0bef5be91ec6c2779', '/navigation/0196eb797b7971a0bef5be91ec72c3d5', '/navigation/0196eb797b7a734b959aa4b5396d639e', '/navigation/0196eb797b7a734b959aa4b53b16459b', '/navigation/0196eb797b7a734b959aa4b53cff6b6a', '/navigation/0196eb797b7b72b9a8299b8f2666112a', '/navigation/0196eb797b7b72b9a8299b8f2687b2b8', '/navigation/0196eb797b7b72b9a8299b8f2895a8e9', '/navigation/0196eb797b7b72b9a8299b8f2adbdfcb', '/navigation/0196eb797b7b72b9a8299b8f2e3d269c', '/navigation/0196eb797b7c719d8ce1e0c27dab96fc', '/navigation/0196eb797b7c719d8ce1e0c27e1e40a7', '/navigation/0196eb797b7c719d8ce1e0c27f9023e6', '/navigation/0196eb797b7c719d8ce1e0c281de1ce2', '/navigation/0196eb797b7c719d8ce1e0c281f8e580', '/navigation/0196eb797b7c719d8ce1e0c282f8017c', '/navigation/0196eb797b7d72ca8039d07279cca63b', '/navigation/0196eb797b7d72ca8039d0727c33e123', '/navigation/0196eb797b7d72ca8039d0727caa7d93', '/navigation/0196eb797b7d72ca8039d0727e66c5ad', '/navigation/0196eb797b7d72ca8039d07280b8c422', '/navigation/0196eb797b7e712ca28402f687c32c30', '/navigation/0196eb797b7e712ca28402f688a01448', '/navigation/0196eb797b7e712ca28402f688cbbace', '/navigation/0196eb797b7e712ca28402f68b244c25', '/navigation/0196eb797b7e712ca28402f68d2a20f4', '/navigation/0196eb797b7e712ca28402f68f96aabe', '/navigation/0196eb797b7f7117a11c2ca01e7d51da', '/navigation/0196eb797b7f7117a11c2ca0211cb68f', '/navigation/0196eb797b7f7117a11c2ca022866b91', '/navigation/0196eb797b7f7117a11c2ca024fcd2c5', '/navigation/0196eb797b8071daa04f9e0a6746316f', '/navigation/0196eb797b8071daa04f9e0a67cdc593', '/navigation/0196eb797b8071daa04f9e0a6b0c041b', '/navigation/0196eb797b8071daa04f9e0a6e928b24', '/navigation/0196eb797b8173a7bee43be3528b754d', '/navigation/0196eb797b8173a7bee43be352afb2be', '/navigation/0196eb797b8173a7bee43be352d5f05e', '/navigation/0196eb797b8173a7bee43be3544588ad', '/navigation/0196eb797b8173a7bee43be3564ac36a', '/navigation/0196eb797b8270e9b6a793a83ff47493', '/navigation/0196eb797b8270e9b6a793a8409eab5d', '/navigation/0196eb797b8270e9b6a793a8431c3561', '/navigation/0196eb797b8270e9b6a793a843c87651', '/navigation/0196eb797b8270e9b6a793a84417de9f', '/navigation/0196eb797b83735fab053eb5c32d7060', '/navigation/0196eb797b83735fab053eb5c4d2794b', '/navigation/0196eb797b83735fab053eb5c5257f38', '/navigation/0196eb797b83735fab053eb5c6ba32c0', '/navigation/0196eb797b83735fab053eb5c964154e', '/navigation/0196eb797b8472299fe5de62021ed5bc', '/navigation/0196eb797b8472299fe5de62044aebd9', '/navigation/0196eb797b8472299fe5de6204bd142a', '/navigation/0196eb797b8472299fe5de620562c076', '/navigation/0196eb797b8472299fe5de6205eb0df7', '/navigation/0196eb797b8472299fe5de620646cfd5', '/navigation/0196eb797b8472299fe5de62070446a7', '/navigation/0196eb797b8472299fe5de62072a75c8', '/navigation/0196eb797b8472299fe5de62076661cf', '/navigation/0196eb797b85706198c9a4d7ca9a0260', '/navigation/0196eb797b85706198c9a4d7cb0a851d', '/navigation/0196eb797b85706198c9a4d7cbbf0249', '/navigation/0196eb797b85706198c9a4d7cbc2aab3', '/navigation/0196eb797b85706198c9a4d7cbe002b0', '/navigation/0196eb797b85706198c9a4d7ccc4c97f', '/navigation/0196eb797b85706198c9a4d7cdaba37c', '/navigation/0196eb797b85706198c9a4d7cdca5d83', '/navigation/0196eb797b85706198c9a4d7ce58eb5b', '/navigation/0196eb797b85706198c9a4d7d0eb45be', '/navigation/0196eb797b8672bba2ae001b9eb62164', '/navigation/0196eb797b8672bba2ae001b9f2a0011', '/navigation/0196eb797b8672bba2ae001ba1e23e9f', '/navigation/0196eb797b8672bba2ae001ba5924e8f', '/navigation/0196eb797b8770b59357175f02684028', '/navigation/0196eb797b8770b59357175f02c17bb7', '/navigation/0196eb797b8770b59357175f0735ca33', '/navigation/0196eb797b8871188c99d7ddf4b9731a', '/navigation/0196eb797b8871188c99d7ddf588146c', '/navigation/0196eb797b8871188c99d7ddf71ae443', '/navigation/0196eb797b8871188c99d7ddf9af0f59', '/navigation/0196eb797b8871188c99d7ddfa0a84a8', '/navigation/0196eb797b8871188c99d7ddfac72a17', '/navigation/0196eb797b8871188c99d7ddfc506f52', '/navigation/0196eb797b89729797366801275382d0', '/navigation/0196eb797b8972979736680127f0198b', '/navigation/0196eb797b897297973668012aada19c', '/navigation/0196eb797b8a7174a49382628419f834', '/navigation/0196eb797b8a7174a4938262876a93f7', '/navigation/0196eb797b8a7174a4938262894bd226', '/navigation/0196eb797b8a7174a49382628a289c6d', '/navigation/0196eb797b8a7174a49382628ade891f', '/navigation/0196eb797b8b71f68eb5029ad389693f', '/navigation/0196eb797b8b71f68eb5029ad60a975c', '/navigation/0196eb797b8b71f68eb5029ad6b6f55f', '/navigation/0196eb797b8b71f68eb5029ad93c7f7b', '/navigation/0196eb797b8c70c4b7dd14355141cd31', '/navigation/0196eb797b8c70c4b7dd143552bc34fa', '/navigation/0196eb797b8c70c4b7dd1435570606e3', '/navigation/0196eb797b8d71b2b4ce0b06d485bb58', '/navigation/0196eb797b8d71b2b4ce0b06d4906d12', '/navigation/0196eb797b8d71b2b4ce0b06d6c770e6', '/navigation/0196eb797b8d71b2b4ce0b06d929499f', '/navigation/0196eb797b8d71b2b4ce0b06da4dc26a', '/navigation/0196eb797b8e71e7977e95767cb5e1a1', '/navigation/0196eb797b8e71e7977e95767da352d0', '/navigation/0196eb797b8e71e7977e95767fda6c29', '/navigation/0196eb797b8e71e7977e9576822cf96b', '/navigation/0196eb797b8e71e7977e957685769d35', '/navigation/0196eb797b8f7038b39fd41bb8503596', '/navigation/0196eb797b8f7038b39fd41bb8c462bd', '/navigation/0196eb797b8f7038b39fd41bba671505', '/navigation/0196eb797b8f7038b39fd41bbc8aa0fb', '/navigation/0196eb797b9071dcb5db5279329c875b', '/navigation/0196eb797b9071dcb5db527933f04b34', '/navigation/0196eb797b9071dcb5db527937511d6b', '/navigation/0196eb797b9071dcb5db52793771a30d', '/navigation/0196eb797b9071dcb5db527937cb0026', '/navigation/0196eb797b9171b2968398653fdd42c6', '/navigation/0196eb797b9171b29683986540f3d951', '/navigation/0196eb797b9171b296839865439eeb24', '/navigation/0196eb797b9171b29683986546d2d07f', '/navigation/0196eb797b9171b29683986547861834', '/navigation/0196eb797b927037b741e35af7a46976', '/navigation/0196eb797b927037b741e35afa7cbcd9', '/navigation/0196eb797b927037b741e35afb8a36f1', '/navigation/0196eb797b927037b741e35afe34a3e9', '/navigation/0196eb797b9373e6a0e6cd4670b6dcdb', '/navigation/0196eb797b9373e6a0e6cd46721a2772', '/navigation/0196eb797b9373e6a0e6cd4672768525', '/navigation/0196eb797b9373e6a0e6cd4674ba5d10', '/navigation/0196eb797b94726285f921a28f418597', '/navigation/0196eb797b94726285f921a2901c9d2b', '/navigation/0196eb797b94726285f921a291b1c809', '/navigation/0196eb797b94726285f921a292529a2c', '/navigation/0196eb797b94726285f921a2941f8ce3', '/navigation/0196eb797b957276ac59cd74c5cb0475', '/navigation/0196eb797b957276ac59cd74c65bfaa1', '/navigation/0196eb797b957276ac59cd74c77bd05f', '/navigation/0196eb797b957276ac59cd74c9bede14', '/navigation/0196eb797b9671a38ceb9be9962dbc82', '/navigation/0196eb797b9671a38ceb9be997ddbf5f', '/navigation/0196eb797b9671a38ceb9be99828e7a1', '/navigation/0196eb797b9671a38ceb9be9982e6d93', '/navigation/0196eb797b9671a38ceb9be998931da7', '/navigation/0196eb797b9671a38ceb9be9992a2d03', '/navigation/0196eb797b9671a38ceb9be9999166f7', '/navigation/0196eb797b9671a38ceb9be99a02faca', '/navigation/0196eb797b9671a38ceb9be99aa3b63c', '/navigation/0196eb797b9671a38ceb9be99b84ed25', '/navigation/0196eb797b977199b7ba460e4f0322a9', '/navigation/0196eb797b977199b7ba460e4f614439', '/navigation/0196eb797b977199b7ba460e4f7fc509', '/navigation/0196eb797b977199b7ba460e50746cf1', '/navigation/0196eb797b977199b7ba460e50fc028a', '/navigation/0196eb797b977199b7ba460e51eb5b4f', '/navigation/0196eb797b977199b7ba460e52206e7c', '/navigation/0196eb797b977199b7ba460e527090d6', '/navigation/0196eb797b977199b7ba460e53101dc1', '/navigation/0196eb797b977199b7ba460e53de686d', '/navigation/0196eb797b977199b7ba460e54bcf6bc', '/navigation/0196eb797b977199b7ba460e54f6f362', '/navigation/0196eb797b977199b7ba460e55382aff', '/navigation/0196eb797b977199b7ba460e55a2ae65', '/navigation/0196eb797b977199b7ba460e5697c9f8', '/navigation/0196eb797b9873349474087458c229ba', '/navigation/0196eb797b98733494740874596aa988', '/navigation/0196eb797b98733494740874598c18d6', '/navigation/0196eb797b98733494740874599017d1', '/navigation/0196eb797b987334947408745a0855e6', '/navigation/0196eb797b987334947408745a78e263', '/navigation/0196eb797b987334947408745af075ac', '/navigation/0196eb797b987334947408745b239c26', '/navigation/0196eb797b987334947408745b442668', '/navigation/0196eb797b987334947408745c2d750d', '/navigation/0196eb797b987334947408745c877549', '/navigation/0196eb797b987334947408745ca16c8d', '/navigation/0196eb797b987334947408745d8b9b20', '/navigation/0196eb797b987334947408745d9a6108', '/navigation/0196eb797b987334947408745e49a85f', '/navigation/0196eb797b987334947408745f02aa78', '/navigation/0196eb797b9970828cd3327fe8a99bca', '/navigation/0196eb797b9970828cd3327fe98cd576', '/navigation/0196eb797b9970828cd3327fe9cddd30', '/navigation/0196eb797b9970828cd3327fea99ba9c', '/navigation/0196eb797b9970828cd3327feb501e81')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x0196EB792C3B734896F1C1997871E120 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# header::navigation::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.title`,
  `category.media.translation.title` as `category.media.title`,
  `category.media.translation.alt`,
  `category.media.translation.alt` as `category.media.alt`,
  `category.media.translation.customFields`,
  `category.media.translation.customFields` as `category.media.customFields`,
  `category.translation.name`,
  `category.translation.name` as `category.name`,
  `category.translation.breadcrumb`,
  `category.translation.breadcrumb` as `category.breadcrumb`,
  `category.translation.slotConfig`,
  `category.translation.slotConfig` as `category.slotConfig`,
  `category.translation.linkType`,
  `category.translation.linkType` as `category.linkType`,
  `category.translation.internalLink`,
  `category.translation.internalLink` as `category.internalLink`,
  `category.translation.externalLink`,
  `category.translation.externalLink` as `category.externalLink`,
  `category.translation.linkNewTab`,
  `category.translation.linkNewTab` as `category.linkNewTab`,
  `category.translation.description`,
  `category.translation.description` as `category.description`,
  `category.translation.metaTitle`,
  `category.translation.metaTitle` as `category.metaTitle`,
  `category.translation.metaDescription`,
  `category.translation.metaDescription` as `category.metaDescription`,
  `category.translation.keywords`,
  `category.translation.keywords` as `category.keywords`,
  `category.translation.customFields`,
  `category.translation.customFields` as `category.customFields`
FROM
  `category`
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`
    FROM
      `category_translation` `category.translation`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.`media_id`,
      `category.media.translation`.`alt` as `category.media.translation.alt`,
      `category.media.translation`.`title` as `category.media.translation.title`,
      `category.media.translation`.`custom_fields` as `category.media.translation.customFields`
    FROM
      `media_translation` `category.media.translation`
    WHERE
      `category.media.translation`.`language_id` = ?
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category`.`path` LIKE ?
      AND (
        `category`.`level` > ?
        AND `category`.`level` <= ?
      )
    )
  )

# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|0196eb786f7c7385b0d0d279f0b7ac97|%' AND (`category`.`level` > 1 AND `category`.`level` <= 5)));

# seo-url::resolve-fallback
SELECT
  path_info pathInfo,
  seo_path_info seoPathInfo
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (sales_channel_id = ?)
  AND (path_info = ?)
  AND (is_canonical = 1)
LIMIT
  1

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x0196EB792C3B734896F1C1997871E120) AND (path_info = '/navigation/019530967494714a8aaeb0847764d39e') AND (is_canonical = 1) LIMIT 1;

# seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x0196EB792C3B734896F1C1997871E120 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'navigation/019530967494714a8aaeb0847764d39e' OR seo_path_info = 'navigation/019530967494714a8aaeb0847764d39e/'));

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

SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|0196eb786f7c7385b0d0d279f0b7ac97|%' AND `category`.`level` = 5 AND `category`.`active` = 1 AND `category`.`visible` = 1)) GROUP BY `category`.`parent_id`;

# base-context-factory::shipping-method::read
SELECT
  `shipping_method`.`id` as `shipping_method.id`,
  `shipping_method`.`active` as `shipping_method.active`,
  `shipping_method`.`position` as `shipping_method.position`,
  `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`,
  `shipping_method`.`media_id` as `shipping_method.mediaId`,
  `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`,
  `shipping_method`.`tax_type` as `shipping_method.taxType`,
  `shipping_method`.`tax_id` as `shipping_method.taxId`,
  `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`,
  `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`,
  `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`,
  `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`,
  `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`,
  `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`,
  `shipping_method.deliveryTime.translation.name`,
  `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`,
  `shipping_method.deliveryTime.translation.customFields`,
  `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`,
  `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`,
  `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`,
  `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`,
  `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`,
  `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`,
  `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`,
  `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`,
  `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`,
  `shipping_method`.`technical_name` as `shipping_method.technicalName`,
  `shipping_method`.`created_at` as `shipping_method.createdAt`,
  `shipping_method`.`updated_at` as `shipping_method.updatedAt`,
  `shipping_method.media`.`id` as `shipping_method.media.id`,
  `shipping_method.media`.`user_id` as `shipping_method.media.userId`,
  `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`,
  `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`,
  `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`,
  `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`,
  `shipping_method.media`.`file_name` as `shipping_method.media.fileName`,
  `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`,
  `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`,
  `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`,
  `shipping_method.media`.`config` as `shipping_method.media.config`,
  `shipping_method.media`.`path` as `shipping_method.media.path`,
  `shipping_method.media`.`private` as `shipping_method.media.private`,
  `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`,
  `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`,
  `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`,
  `shipping_method.media.translation.title`,
  `shipping_method.media.translation.title` as `shipping_method.media.title`,
  `shipping_method.media.translation.alt`,
  `shipping_method.media.translation.alt` as `shipping_method.media.alt`,
  `shipping_method.media.translation.customFields`,
  `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`,
  `shipping_method.translation.name`,
  `shipping_method.translation.name` as `shipping_method.name`,
  `shipping_method.translation.description`,
  `shipping_method.translation.description` as `shipping_method.description`,
  `shipping_method.translation.trackingUrl`,
  `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`,
  `shipping_method.translation.customFields`,
  `shipping_method.translation.customFields` as `shipping_method.customFields`
FROM
  `shipping_method`
  LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
  LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id`
  LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.translation`.`shipping_method_id`,
      `shipping_method.translation`.`name` as `shipping_method.translation.name`,
      `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`,
      `shipping_method.translation`.`description` as `shipping_method.translation.description`,
      `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`
    FROM
      `shipping_method_translation` `shipping_method.translation`
    WHERE
      `shipping_method.translation`.`language_id` = ?
  ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.deliveryTime.translation`.`delivery_time_id`,
      `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`,
      `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields`
    FROM
      `delivery_time_translation` `shipping_method.deliveryTime.translation`
    WHERE
      `shipping_method.deliveryTime.translation`.`language_id` = ?
  ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.media.translation`.`media_id`,
      `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`,
      `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`,
      `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`
    FROM
      `media_translation` `shipping_method.media.translation`
    WHERE
      `shipping_method.media.translation`.`language_id` = ?
  ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id`
WHERE
  `shipping_method`.`id` IN (?)