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/01946ce4c89c7219abc8e04b14cf6fde', '/navigation/01946ce4c8a270dba6dd5e99939b37e7', '/navigation/01946ce4c8a373bc8e5cd73beeb44a2b', '/navigation/01946ce4c8a471859e347ad6ba257199', '/navigation/01946ce4c8a57298b8e05232570ff842', '/navigation/01946ce4c8a6711b892e51e488e8544c', '/navigation/01946ce4c8aa711faee4ff505fad8aa0', '/navigation/01946ce4c8b173a2917b518be805df24', '/navigation/01946ce4c8b470629d4ef154e191f47f', '/navigation/01946ce4c8c07203a676f690b8468ab8', '/navigation/01946ce4c89d72df86b32616a929f2c4', '/navigation/01946ce4c89d72df86b32616a9bc2012', '/navigation/01946ce4c89e71e2b345c00db3e26762', '/navigation/01946ce4c89e71e2b345c00db3e84083', '/navigation/01946ce4c89e71e2b345c00db401ad7c', '/navigation/01946ce4c89e71e2b345c00db4d385ad', '/navigation/01946ce4c89e71e2b345c00db4e871de', '/navigation/01946ce4c89e71e2b345c00db56b128a', '/navigation/01946ce4c89e71e2b345c00db5e5d24f', '/navigation/01946ce4c89e71e2b345c00db69eab2f', '/navigation/01946ce4c89e71e2b345c00db6ba2350', '/navigation/01946ce4c89e71e2b345c00db765d39a', '/navigation/01946ce4c89e71e2b345c00db863c137', '/navigation/01946ce4c89e71e2b345c00db8c57cea', '/navigation/01946ce4c89e71e2b345c00db8f82bac', '/navigation/01946ce4c89e71e2b345c00db9531402', '/navigation/01946ce4c89e71e2b345c00db9fce511', '/navigation/01946ce4c89e71e2b345c00dba939116', '/navigation/01946ce4c89e71e2b345c00dbb065afb', '/navigation/01946ce4c89e71e2b345c00dbbfb8db0', '/navigation/01946ce4c89e71e2b345c00dbc2547c1', '/navigation/01946ce4c89f716f839d583eb9a9a0c4', '/navigation/01946ce4c89f716f839d583ebaa4e6ce', '/navigation/01946ce4c89f716f839d583ebadac679', '/navigation/01946ce4c89f716f839d583ebb105de8', '/navigation/01946ce4c89f716f839d583ebbc2fa5b', '/navigation/01946ce4c89f716f839d583ebbd40f8a', '/navigation/01946ce4c89f716f839d583ebc51d843', '/navigation/01946ce4c89f716f839d583ebcbd2099', '/navigation/01946ce4c89f716f839d583ebce175a2', '/navigation/01946ce4c89f716f839d583ebcf41528', '/navigation/01946ce4c89f716f839d583ebd5e7021', '/navigation/01946ce4c89f716f839d583ebe0f6361', '/navigation/01946ce4c89f716f839d583ebe5b78c7', '/navigation/01946ce4c89f716f839d583ebe5d029f', '/navigation/01946ce4c89f716f839d583ebe944635', '/navigation/01946ce4c89f716f839d583ebed8d568', '/navigation/01946ce4c89f716f839d583ebf312e7b', '/navigation/01946ce4c89f716f839d583ebff71d55', '/navigation/01946ce4c8a072e9a84cf3fba371a75d', '/navigation/01946ce4c8a072e9a84cf3fba398834d', '/navigation/01946ce4c8a072e9a84cf3fba448cb10', '/navigation/01946ce4c8a072e9a84cf3fba4f97b1b', '/navigation/01946ce4c8a072e9a84cf3fba5494a93', '/navigation/01946ce4c8a072e9a84cf3fba602f334', '/navigation/01946ce4c8a072e9a84cf3fba6a5a70f', '/navigation/01946ce4c8a072e9a84cf3fba734a315', '/navigation/01946ce4c8a072e9a84cf3fba7c69753', '/navigation/01946ce4c8a072e9a84cf3fba80297a0', '/navigation/01946ce4c8a072e9a84cf3fba8f58320', '/navigation/01946ce4c8a072e9a84cf3fba9c955a0', '/navigation/01946ce4c8a072e9a84cf3fba9f64f06', '/navigation/01946ce4c8a072e9a84cf3fbaa69db86', '/navigation/01946ce4c8a072e9a84cf3fbaa8c011e', '/navigation/01946ce4c8a072e9a84cf3fbaaf33d2a', '/navigation/01946ce4c8a072e9a84cf3fbab2c0a31', '/navigation/01946ce4c8a1704e95891c6102e82e35', '/navigation/01946ce4c8a1704e95891c6103525807', '/navigation/01946ce4c8a1704e95891c61037f87b5', '/navigation/01946ce4c8a1704e95891c610385ece5', '/navigation/01946ce4c8a1704e95891c6103972323', '/navigation/01946ce4c8a1704e95891c610494c550', '/navigation/01946ce4c8a1704e95891c61057dd5ee', '/navigation/01946ce4c8a1704e95891c6105c7dbee', '/navigation/01946ce4c8a1704e95891c6106561c02', '/navigation/01946ce4c8a1704e95891c610658d962', '/navigation/01946ce4c8a1704e95891c61074fb67a', '/navigation/01946ce4c8a1704e95891c6108102c0f', '/navigation/01946ce4c8a1704e95891c6108c9fdd7', '/navigation/01946ce4c8a1704e95891c6109831549', '/navigation/01946ce4c8a1704e95891c610a1013da', '/navigation/01946ce4c8a1704e95891c610a47469d', '/navigation/01946ce4c8a1704e95891c610b252539', '/navigation/01946ce4c8a1704e95891c610bd93f2a', '/navigation/01946ce4c8a1704e95891c610cd06932', '/navigation/01946ce4c8a270dba6dd5e9990726e1b', '/navigation/01946ce4c8a270dba6dd5e9990ea0b54', '/navigation/01946ce4c8a270dba6dd5e9991418cc1', '/navigation/01946ce4c8a270dba6dd5e9991c1246c', '/navigation/01946ce4c8a270dba6dd5e99928f8a09', '/navigation/01946ce4c8a270dba6dd5e9992e98117', '/navigation/01946ce4c8a270dba6dd5e9993ded5c2', '/navigation/01946ce4c8a270dba6dd5e9994d42344', '/navigation/01946ce4c8a270dba6dd5e99955e8508', '/navigation/01946ce4c8a270dba6dd5e9996523900', '/navigation/01946ce4c8a270dba6dd5e99966d103e', '/navigation/01946ce4c8a270dba6dd5e9996c1411c', '/navigation/01946ce4c8a270dba6dd5e9997735f27', '/navigation/01946ce4c8a270dba6dd5e9998462366', '/navigation/01946ce4c8a270dba6dd5e9998f8f157', '/navigation/01946ce4c8a270dba6dd5e999991ef49', '/navigation/01946ce4c8a270dba6dd5e999a378591', '/navigation/01946ce4c8a373bc8e5cd73bea53ae06', '/navigation/01946ce4c8a373bc8e5cd73bea554b9c', '/navigation/01946ce4c8a373bc8e5cd73beac60506', '/navigation/01946ce4c8a373bc8e5cd73beb641346', '/navigation/01946ce4c8a373bc8e5cd73bec58e447', '/navigation/01946ce4c8a373bc8e5cd73becdf543e', '/navigation/01946ce4c8a373bc8e5cd73beda14b98', '/navigation/01946ce4c8a373bc8e5cd73bee34423a', '/navigation/01946ce4c8a373bc8e5cd73beec0b509', '/navigation/01946ce4c8a373bc8e5cd73bef99b3be', '/navigation/01946ce4c8a373bc8e5cd73bf05eb0d8', '/navigation/01946ce4c8a373bc8e5cd73bf1370df4', '/navigation/01946ce4c8a373bc8e5cd73bf1d5faa8', '/navigation/01946ce4c8a373bc8e5cd73bf1e457cd', '/navigation/01946ce4c8a373bc8e5cd73bf1eb00a8', '/navigation/01946ce4c8a373bc8e5cd73bf2d6303e', '/navigation/01946ce4c8a373bc8e5cd73bf38368ba', '/navigation/01946ce4c8a471859e347ad6b4174c20', '/navigation/01946ce4c8a471859e347ad6b4bb053f', '/navigation/01946ce4c8a471859e347ad6b524a22f', '/navigation/01946ce4c8a471859e347ad6b610bf80', '/navigation/01946ce4c8a471859e347ad6b6d9cbf3', '/navigation/01946ce4c8a471859e347ad6b77394da', '/navigation/01946ce4c8a471859e347ad6b7f7325d', '/navigation/01946ce4c8a471859e347ad6b88f7bdf', '/navigation/01946ce4c8a471859e347ad6b8deecef', '/navigation/01946ce4c8a471859e347ad6b91409d5', '/navigation/01946ce4c8a471859e347ad6ba063c62', '/navigation/01946ce4c8a471859e347ad6ba38eebc', '/navigation/01946ce4c8a471859e347ad6bb0127af', '/navigation/01946ce4c8a471859e347ad6bb47dda3', '/navigation/01946ce4c8a471859e347ad6bb9a546a', '/navigation/01946ce4c8a471859e347ad6bc42dd16', '/navigation/01946ce4c8a471859e347ad6bd29b8a8', '/navigation/01946ce4c8a471859e347ad6bdce40b3', '/navigation/01946ce4c8a57298b8e05232549b29e0', '/navigation/01946ce4c8a57298b8e0523254e19cd6', '/navigation/01946ce4c8a57298b8e05232553790b6', '/navigation/01946ce4c8a57298b8e052325618dcc9', '/navigation/01946ce4c8a57298b8e0523257f93478', '/navigation/01946ce4c8a57298b8e0523258cb2a0f', '/navigation/01946ce4c8a57298b8e0523259954859', '/navigation/01946ce4c8a57298b8e0523259c76564', '/navigation/01946ce4c8a57298b8e052325aab44c8', '/navigation/01946ce4c8a57298b8e052325b46d0ab', '/navigation/01946ce4c8a57298b8e052325b65348c', '/navigation/01946ce4c8a57298b8e052325c290e23', '/navigation/01946ce4c8a57298b8e052325c965dd4', '/navigation/01946ce4c8a57298b8e052325cb89d51', '/navigation/01946ce4c8a57298b8e052325d753452', '/navigation/01946ce4c8a57298b8e052325e259ce5', '/navigation/01946ce4c8a57298b8e052325e4f0aca', '/navigation/01946ce4c8a6711b892e51e486118f25', '/navigation/01946ce4c8a6711b892e51e486f797b1', '/navigation/01946ce4c8a6711b892e51e48708c8f4', '/navigation/01946ce4c8a6711b892e51e487ff0882', '/navigation/01946ce4c8a6711b892e51e48820eca2', '/navigation/01946ce4c8a6711b892e51e48825f355', '/navigation/01946ce4c8a6711b892e51e48881feb1', '/navigation/01946ce4c8a6711b892e51e488be923a', '/navigation/01946ce4c8a6711b892e51e488c0d402', '/navigation/01946ce4c8a6711b892e51e4898390d3', '/navigation/01946ce4c8a6711b892e51e489e8176d', '/navigation/01946ce4c8a6711b892e51e48a35cf2f', '/navigation/01946ce4c8a6711b892e51e48aead86e', '/navigation/01946ce4c8a7732794191160dc75cff1', '/navigation/01946ce4c8a7732794191160df3c895a', '/navigation/01946ce4c8a7732794191160e3b6bee0', '/navigation/01946ce4c8a7732794191160e73d0eb7', '/navigation/01946ce4c8a7732794191160e7c97a3b', '/navigation/01946ce4c8a870f1bd6e5b4b479e4844', '/navigation/01946ce4c8a870f1bd6e5b4b49fa40f4', '/navigation/01946ce4c8a870f1bd6e5b4b4bde7ac7', '/navigation/01946ce4c8a971239d42c8a742e2366c', '/navigation/01946ce4c8a971239d42c8a742f6b65d', '/navigation/01946ce4c8a971239d42c8a7435158b1', '/navigation/01946ce4c8a971239d42c8a745eedd22', '/navigation/01946ce4c8a971239d42c8a7496a7285', '/navigation/01946ce4c8aa711faee4ff5057b3beba', '/navigation/01946ce4c8aa711faee4ff50581e2549', '/navigation/01946ce4c8aa711faee4ff50596e3bda', '/navigation/01946ce4c8aa711faee4ff505c2c0ef4', '/navigation/01946ce4c8aa711faee4ff506041a276', '/navigation/01946ce4c8aa711faee4ff5061032340', '/navigation/01946ce4c8ab70e5b3c6179278749756', '/navigation/01946ce4c8ab70e5b3c61792793f6339', '/navigation/01946ce4c8ab70e5b3c617927af2392a', '/navigation/01946ce4c8ab70e5b3c617927bf1bfb8', '/navigation/01946ce4c8ab70e5b3c617927fa4f42d', '/navigation/01946ce4c8ab70e5b3c6179281db5faa', '/navigation/01946ce4c8ab70e5b3c617928207fbe8', '/navigation/01946ce4c8ac718fb9e2301ad7086600', '/navigation/01946ce4c8ac718fb9e2301ada992555', '/navigation/01946ce4c8ac718fb9e2301adab90a65', '/navigation/01946ce4c8ac718fb9e2301adb0541ff', '/navigation/01946ce4c8ac718fb9e2301adc0ae44f', '/navigation/01946ce4c8ad70afaa9e90264ffb6fa8', '/navigation/01946ce4c8ad70afaa9e902651dc6885', '/navigation/01946ce4c8ad70afaa9e90265317618a', '/navigation/01946ce4c8ad70afaa9e9026536503f1', '/navigation/01946ce4c8ad70afaa9e9026561ceee1', '/navigation/01946ce4c8ad70afaa9e90265875a7cc', '/navigation/01946ce4c8ae73bba0d7f21f6994a1c0', '/navigation/01946ce4c8ae73bba0d7f21f6b7251d6', '/navigation/01946ce4c8ae73bba0d7f21f6d0ba4d0', '/navigation/01946ce4c8ae73bba0d7f21f6d4cbd75', '/navigation/01946ce4c8ae73bba0d7f21f6dcfbf64', '/navigation/01946ce4c8ae73bba0d7f21f6fc136f1', '/navigation/01946ce4c8af722cb0655dc9c8b4ef1b', '/navigation/01946ce4c8af722cb0655dc9c8f46e17', '/navigation/01946ce4c8af722cb0655dc9ca8e0c56', '/navigation/01946ce4c8af722cb0655dc9ccb919ae', '/navigation/01946ce4c8af722cb0655dc9ccfd61b1', '/navigation/01946ce4c8b071bdadc263ba50b51758', '/navigation/01946ce4c8b071bdadc263ba528354f4', '/navigation/01946ce4c8b071bdadc263ba529b486d', '/navigation/01946ce4c8b071bdadc263ba53d03a90', '/navigation/01946ce4c8b071bdadc263ba556cc973', '/navigation/01946ce4c8b071bdadc263ba55bc1bc6', '/navigation/01946ce4c8b173a2917b518bdf435696', '/navigation/01946ce4c8b173a2917b518be1501b06', '/navigation/01946ce4c8b173a2917b518be480bc1e', '/navigation/01946ce4c8b273a9ac902ca0ab39dc3c', '/navigation/01946ce4c8b273a9ac902ca0abb131e1', '/navigation/01946ce4c8b273a9ac902ca0abc7ce71', '/navigation/01946ce4c8b273a9ac902ca0ac5e776d', '/navigation/01946ce4c8b273a9ac902ca0ad2fd74b', '/navigation/01946ce4c8b273a9ac902ca0adb71cc9', '/navigation/01946ce4c8b273a9ac902ca0adf5f998', '/navigation/01946ce4c8b273a9ac902ca0aea15e2b', '/navigation/01946ce4c8b273a9ac902ca0af828782', '/navigation/01946ce4c8b273a9ac902ca0aff8b1e6', '/navigation/01946ce4c8b273a9ac902ca0b0bfca65', '/navigation/01946ce4c8b273a9ac902ca0b14d13ed', '/navigation/01946ce4c8b273a9ac902ca0b21323c1', '/navigation/01946ce4c8b273a9ac902ca0b24a3b73', '/navigation/01946ce4c8b273a9ac902ca0b2b390cb', '/navigation/01946ce4c8b273a9ac902ca0b38aa4c8', '/navigation/01946ce4c8b370fe8817900def3be775', '/navigation/01946ce4c8b370fe8817900df009644f', '/navigation/01946ce4c8b370fe8817900df0c0c140', '/navigation/01946ce4c8b370fe8817900df1b75343', '/navigation/01946ce4c8b370fe8817900df1c9b319', '/navigation/01946ce4c8b370fe8817900df28e3643', '/navigation/01946ce4c8b370fe8817900df2c344ef', '/navigation/01946ce4c8b370fe8817900df3b9bada', '/navigation/01946ce4c8b370fe8817900df46162fb', '/navigation/01946ce4c8b370fe8817900df4b1676d', '/navigation/01946ce4c8b370fe8817900df4f80e45', '/navigation/01946ce4c8b370fe8817900df5acdeee', '/navigation/01946ce4c8b370fe8817900df60d24ee', '/navigation/01946ce4c8b370fe8817900df61b65e2', '/navigation/01946ce4c8b370fe8817900df61e7b74', '/navigation/01946ce4c8b370fe8817900df6c3fd4b', '/navigation/01946ce4c8b470629d4ef154db1a0104', '/navigation/01946ce4c8b470629d4ef154db437e0d', '/navigation/01946ce4c8b470629d4ef154dc2d74b1', '/navigation/01946ce4c8b470629d4ef154dce9952a', '/navigation/01946ce4c8b470629d4ef154dd5cdf72', '/navigation/01946ce4c8b470629d4ef154dd7ead6e', '/navigation/01946ce4c8b470629d4ef154dd822255', '/navigation/01946ce4c8b470629d4ef154de04d955', '/navigation/01946ce4c8b470629d4ef154de895f90', '/navigation/01946ce4c8b470629d4ef154defbecc3', '/navigation/01946ce4c8b470629d4ef154dfeb0da6', '/navigation/01946ce4c8b470629d4ef154e050f02d', '/navigation/01946ce4c8b470629d4ef154e0961f0d', '/navigation/01946ce4c8b470629d4ef154e28cace3', '/navigation/01946ce4c8b470629d4ef154e375046f', '/navigation/01946ce4c8b470629d4ef154e42c7bf3', '/navigation/01946ce4c8b573928654d67e3878301d', '/navigation/01946ce4c8b573928654d67e3a61651e', '/navigation/01946ce4c8b573928654d67e3d5f60e9', '/navigation/01946ce4c8b573928654d67e411e2b0a', '/navigation/01946ce4c8b67287af37ae05d9c71701', '/navigation/01946ce4c8b67287af37ae05da272cc9', '/navigation/01946ce4c8b67287af37ae05dd0d0588', '/navigation/01946ce4c8b67287af37ae05de738ff4', '/navigation/01946ce4c8b67287af37ae05df64706c', '/navigation/01946ce4c8b67287af37ae05dff1686e', '/navigation/01946ce4c8b77222b803897b8e5a0639', '/navigation/01946ce4c8b77222b803897b8ffd13c1', '/navigation/01946ce4c8b77222b803897b9098f4bc', '/navigation/01946ce4c8b77222b803897b93447f2c', '/navigation/01946ce4c8b870b7b2a4bd51e8522541', '/navigation/01946ce4c8b870b7b2a4bd51e90d4306', '/navigation/01946ce4c8b870b7b2a4bd51ebc73b62', '/navigation/01946ce4c8b870b7b2a4bd51ed486316', '/navigation/01946ce4c8b9726aaddc64589691a9ec', '/navigation/01946ce4c8b9726aaddc645897690bb8', '/navigation/01946ce4c8b9726aaddc645898637a7f', '/navigation/01946ce4c8b9726aaddc645898f0b6b5', '/navigation/01946ce4c8b9726aaddc645899976c7f', '/navigation/01946ce4c8b9726aaddc64589d8479cb', '/navigation/01946ce4c8ba701ba821910ed370ef05', '/navigation/01946ce4c8ba701ba821910ed4173d72', '/navigation/01946ce4c8ba701ba821910ed6493220', '/navigation/01946ce4c8ba701ba821910ed76afdd9', '/navigation/01946ce4c8bb713f820bf55ae12b32b9', '/navigation/01946ce4c8bb713f820bf55ae45dfa6e', '/navigation/01946ce4c8bb713f820bf55ae5ae75f0', '/navigation/01946ce4c8bb713f820bf55ae67f708a', '/navigation/01946ce4c8bb713f820bf55ae779dc0b', '/navigation/01946ce4c8bb713f820bf55aea628c1c', '/navigation/01946ce4c8bc70e4a1465ebe7bf20b81', '/navigation/01946ce4c8bc70e4a1465ebe7de03951', '/navigation/01946ce4c8bc70e4a1465ebe802b61d8', '/navigation/01946ce4c8bc70e4a1465ebe80c2e6e4', '/navigation/01946ce4c8bc70e4a1465ebe817884d2', '/navigation/01946ce4c8bd70ea9a82ca6abad75a6f', '/navigation/01946ce4c8bd70ea9a82ca6abda72bba', '/navigation/01946ce4c8bd70ea9a82ca6abf11a2bf', '/navigation/01946ce4c8bd70ea9a82ca6ac17c49af', '/navigation/01946ce4c8bd70ea9a82ca6ac19c2342', '/navigation/01946ce4c8be72888b5734264c751c50', '/navigation/01946ce4c8be72888b5734264eaaba44', '/navigation/01946ce4c8be72888b57342651f24724', '/navigation/01946ce4c8bf709eb86e665bb5616718', '/navigation/01946ce4c8bf709eb86e665bb61f80a7', '/navigation/01946ce4c8bf709eb86e665bb9489003', '/navigation/01946ce4c8bf709eb86e665bbb94d339', '/navigation/01946ce4c8bf709eb86e665bbc3a022c', '/navigation/01946ce4c8c07203a676f690b3434727', '/navigation/01946ce4c8c07203a676f690b61cee83', '/navigation/01946ce4c8c07203a676f690b8fb37a0', '/navigation/01946ce4c8c07203a676f690b92342f2', '/navigation/01946ce4c8c07203a676f690b94439a3', '/navigation/01946ce4c8c07203a676f690ba22802c', '/navigation/01946ce4c8c07203a676f690baf55e7f', '/navigation/01946ce4c8c07203a676f690bafb3c9d', '/navigation/01946ce4c8c1726098a3af4098a1748a', '/navigation/01946ce4c8c1726098a3af4099912d38', '/navigation/01946ce4c8c1726098a3af4099f283b5', '/navigation/01946ce4c8c1726098a3af409a2061cc', '/navigation/01946ce4c8c1726098a3af409a366977', '/navigation/01946ce4c8c1726098a3af409ab89475', '/navigation/01946ce4c8c1726098a3af409b01e774', '/navigation/01946ce4c8c1726098a3af409b09af4e', '/navigation/01946ce4c8c1726098a3af409b1049e3', '/navigation/01946ce4c8c1726098a3af409b32d4ff', '/navigation/01946ce4c8c1726098a3af409c09b93a')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x01946CE47842708DB41632A9597DB75F 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 '%|01946ce3d4f573cbb00b391dd4360c0a|%' 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 = 0x01946CE47842708DB41632A9597DB75F) AND (path_info = '/robots.txt') 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 = 0x01946CE47842708DB41632A9597DB75F OR sales_channel_id IS NULL)) AND ((seo_path_info = 'robots.txt' OR seo_path_info = 'robots.txt/'));

# 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`.`id` IN (?)
  )

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

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 '%|01946ce3d4f573cbb00b391dd4360c0a|%' AND `category`.`level` = 5 AND `category`.`active` = 1 AND `category`.`visible` = 1)) GROUP BY `category`.`parent_id`;