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/01934c809704720281fd3b4c503b1cc3', '/navigation/01934c8097017362b9853b32af83a716', '/navigation/01934c80971473349c60690690c94a08', '/navigation/01934c809726727dad9c1869ec2a5c6b', '/navigation/01934c80972772bea6d0607ee61d03b1', '/navigation/01934c8097377015b4d60f8c75b5496b', '/navigation/01934c8097387252afcae1611125be1d', '/navigation/01934c80973c7095bf16d76d81eb4545', '/navigation/01934c809743718491b5ecc877c5154c', '/navigation/01934c8097447329bfb184bc4fa734aa', '/navigation/01934c80974d71f584865b7be97536fc', '/navigation/01934c80970273b1b3f7895dd48c3f83', '/navigation/01934c80970273b1b3f7895dd544e104', '/navigation/01934c80970373c88b44f183c35e1257', '/navigation/01934c80970373c88b44f183c4b3b5e8', '/navigation/01934c80970373c88b44f183c7890ac1', '/navigation/01934c80970373c88b44f183c7e9d266', '/navigation/01934c80970373c88b44f183cb39a337', '/navigation/01934c80970373c88b44f183cc062960', '/navigation/01934c809704720281fd3b4c504a5f32', '/navigation/01934c809704720281fd3b4c5232b3c9', '/navigation/01934c809704720281fd3b4c537c8548', '/navigation/01934c809704720281fd3b4c56ba7a82', '/navigation/01934c80970570388919a0fb1272ba3a', '/navigation/01934c80970570388919a0fb139a184d', '/navigation/01934c80970570388919a0fb13ea6226', '/navigation/01934c80970570388919a0fb163cda82', '/navigation/01934c80970570388919a0fb1881fcaf', '/navigation/01934c80970570388919a0fb191ea37d', '/navigation/01934c809706720dadfc9fa65ff22783', '/navigation/01934c809706720dadfc9fa662c1b7bf', '/navigation/01934c809706720dadfc9fa66645302b', '/navigation/01934c809706720dadfc9fa666d30cee', '/navigation/01934c809706720dadfc9fa66716a364', '/navigation/01934c809706720dadfc9fa668ff84f1', '/navigation/01934c80970772cda8d031432e21ced3', '/navigation/01934c80970772cda8d03143321db6ea', '/navigation/01934c80970772cda8d03143350a7a22', '/navigation/01934c809708733eb058d73197ac3735', '/navigation/01934c809708733eb058d73197ec5208', '/navigation/01934c809708733eb058d7319ae3c12f', '/navigation/01934c809708733eb058d7319d6af7f2', '/navigation/01934c809708733eb058d7319f2f52ef', '/navigation/01934c80970973ada2d865da9feb89be', '/navigation/01934c80970973ada2d865da9ff35872', '/navigation/01934c80970973ada2d865daa10d96d4', '/navigation/01934c80970973ada2d865daa2618beb', '/navigation/01934c80970973ada2d865daa6874d62', '/navigation/01934c80970a7294ac6fcf4b09d57add', '/navigation/01934c80970a7294ac6fcf4b09f128aa', '/navigation/01934c80970a7294ac6fcf4b0b58c04f', '/navigation/01934c80970a7294ac6fcf4b0cd15aaa', '/navigation/01934c80970a7294ac6fcf4b0cf8827c', '/navigation/01934c80970a7294ac6fcf4b0de875bb', '/navigation/01934c80970a7294ac6fcf4b10ac7cbb', '/navigation/01934c80970b73b3b758b4ed46d8f536', '/navigation/01934c80970b73b3b758b4ed4858a741', '/navigation/01934c80970b73b3b758b4ed4950c4e4', '/navigation/01934c80970b73b3b758b4ed4ad4ae59', '/navigation/01934c80970b73b3b758b4ed4d8e1f8a', '/navigation/01934c80970c7021b6b35327724a6a11', '/navigation/01934c80970c7021b6b35327749bdc94', '/navigation/01934c80970c7021b6b3532777b24ef6', '/navigation/01934c80970c7021b6b3532778125704', '/navigation/01934c80970c7021b6b353277a9a1e54', '/navigation/01934c80970d727482fc7e74130d03e0', '/navigation/01934c80970d727482fc7e7413667a19', '/navigation/01934c80970d727482fc7e7416cbc1da', '/navigation/01934c80970d727482fc7e74190d2461', '/navigation/01934c80970e71558e9d47f89be10514', '/navigation/01934c80970e71558e9d47f89e1fa8ac', '/navigation/01934c80970e71558e9d47f89f1b874b', '/navigation/01934c80970e71558e9d47f89fe2ac67', '/navigation/01934c80970e71558e9d47f8a1cac080', '/navigation/01934c80970f702bb23e371059aea622', '/navigation/01934c80970f702bb23e37105cd8cb67', '/navigation/01934c80970f702bb23e37105e9b0675', '/navigation/01934c80970f702bb23e371061910b27', '/navigation/01934c8097107110bfb6ff27fbb12c8c', '/navigation/01934c8097107110bfb6ff27feb9b8b9', '/navigation/01934c8097107110bfb6ff280050dd2f', '/navigation/01934c8097107110bfb6ff2803bc3c51', '/navigation/01934c8097117127a430d21a0c84ce52', '/navigation/01934c8097117127a430d21a0cdb0298', '/navigation/01934c8097117127a430d21a0de0c3b1', '/navigation/01934c8097117127a430d21a11879b6b', '/navigation/01934c8097117127a430d21a12e57284', '/navigation/01934c8097117127a430d21a152bb798', '/navigation/01934c8097117127a430d21a15d208c3', '/navigation/01934c80971271898cfbb7d843d93906', '/navigation/01934c80971271898cfbb7d8450b6fe2', '/navigation/01934c80971271898cfbb7d848ef22ed', '/navigation/01934c80971373949ee6d7364fcb3d5f', '/navigation/01934c80971373949ee6d7365156d9d6', '/navigation/01934c80971373949ee6d73651cd04ca', '/navigation/01934c80971373949ee6d7365474aea8', '/navigation/01934c80971473349c60690689385198', '/navigation/01934c80971473349c6069068b2f27b3', '/navigation/01934c80971473349c6069068bb4a981', '/navigation/01934c80971473349c6069068d5795fd', '/navigation/01934c80971473349c606906915df269', '/navigation/01934c80971570e08caacda0dc49407d', '/navigation/01934c80971570e08caacda0dc790efb', '/navigation/01934c80971570e08caacda0df4c4e41', '/navigation/01934c80971570e08caacda0e0ca02f1', '/navigation/01934c80971570e08caacda0e3bccc4d', '/navigation/01934c809716715d97a1817889c05be6', '/navigation/01934c809716715d97a181788a97ce8d', '/navigation/01934c809716715d97a181788d1b28e5', '/navigation/01934c809716715d97a181788dceeae1', '/navigation/01934c809716715d97a181789012bcb4', '/navigation/01934c80971772d8a58496bf9c3468ef', '/navigation/01934c80971772d8a58496bf9d9592b7', '/navigation/01934c80971772d8a58496bf9fb7f17b', '/navigation/01934c80971772d8a58496bf9fe42678', '/navigation/01934c80971772d8a58496bfa21d028a', '/navigation/01934c80971772d8a58496bfa4320f21', '/navigation/01934c80971870899bedf493c66158c0', '/navigation/01934c80971870899bedf493ca01c079', '/navigation/01934c80971870899bedf493cb005bb0', '/navigation/01934c80971870899bedf493cb4d1080', '/navigation/01934c80971870899bedf493cc31f881', '/navigation/01934c80971870899bedf493ce6f8eca', '/navigation/01934c809719730fb565b126b0081755', '/navigation/01934c809719730fb565b126b24c612b', '/navigation/01934c809719730fb565b126b4d65962', '/navigation/01934c809719730fb565b126b606b6d5', '/navigation/01934c809719730fb565b126b693f104', '/navigation/01934c80971a734c84a90a3cf45a3ec1', '/navigation/01934c80971a734c84a90a3cf649a347', '/navigation/01934c80971a734c84a90a3cf87deba4', '/navigation/01934c80971b7212bec99712a1c1fc41', '/navigation/01934c80971b7212bec99712a42dd7bf', '/navigation/01934c80971b7212bec99712a6edc063', '/navigation/01934c80971b7212bec99712a91db635', '/navigation/01934c80971c71d9b92cbc4bb413b70c', '/navigation/01934c80971c71d9b92cbc4bb500ff3c', '/navigation/01934c80971c71d9b92cbc4bb7fb22d9', '/navigation/01934c80971c71d9b92cbc4bbbb6631c', '/navigation/01934c80971d73faa92cf53eea6ef630', '/navigation/01934c80971d73faa92cf53eeb88dd68', '/navigation/01934c80971d73faa92cf53eedb2a8ad', '/navigation/01934c80971d73faa92cf53eedc84417', '/navigation/01934c80971e7076a32152435ce3168d', '/navigation/01934c80971e7076a32152435ef7c56d', '/navigation/01934c80971e7076a3215243608c95ea', '/navigation/01934c80971e7076a32152436263325a', '/navigation/01934c80971e7076a321524363729f89', '/navigation/01934c80971e7076a32152436462a0b1', '/navigation/01934c80971f7387bfbc69e6cb368c5c', '/navigation/01934c80971f7387bfbc69e6cd3c95b6', '/navigation/01934c80971f7387bfbc69e6cef5e981', '/navigation/01934c80971f7387bfbc69e6cf68c634', '/navigation/01934c80971f7387bfbc69e6d1f96a45', '/navigation/01934c8097207248be62eeea8aa8906d', '/navigation/01934c8097207248be62eeea8c61fa80', '/navigation/01934c8097207248be62eeea8ed7313a', '/navigation/01934c8097207248be62eeea8f6dba53', '/navigation/01934c8097207248be62eeea9027f515', '/navigation/01934c8097217118a7120bcc59c823bb', '/navigation/01934c8097217118a7120bcc5a5616ea', '/navigation/01934c8097217118a7120bcc5c2caac2', '/navigation/01934c8097217118a7120bcc5f7de504', '/navigation/01934c8097217118a7120bcc5fad681e', '/navigation/01934c8097217118a7120bcc607508fb', '/navigation/01934c8097217118a7120bcc61c817c8', '/navigation/01934c80972271db835bae5f0f57098d', '/navigation/01934c80972271db835bae5f12105f95', '/navigation/01934c80972271db835bae5f12685365', '/navigation/01934c80972271db835bae5f13cd602b', '/navigation/01934c80972271db835bae5f1696049d', '/navigation/01934c80972373329f5c08d8f37d7c68', '/navigation/01934c80972373329f5c08d8f70977b3', '/navigation/01934c80972373329f5c08d8f76e74a8', '/navigation/01934c80972373329f5c08d8f7c30044', '/navigation/01934c80972373329f5c08d8f8fe08ac', '/navigation/01934c80972373329f5c08d8faae91a4', '/navigation/01934c809724705cb2732673cb258fce', '/navigation/01934c809724705cb2732673cba3eb85', '/navigation/01934c809724705cb2732673cd76fb3d', '/navigation/01934c809724705cb2732673cfce374a', '/navigation/01934c8097257322a1170e2c313b807c', '/navigation/01934c8097257322a1170e2c315f0155', '/navigation/01934c8097257322a1170e2c334d3f08', '/navigation/01934c8097257322a1170e2c3533d92c', '/navigation/01934c8097257322a1170e2c38f1a71a', '/navigation/01934c8097257322a1170e2c39ec11af', '/navigation/01934c809726727dad9c1869e90a2b5e', '/navigation/01934c809726727dad9c1869e9fa19b0', '/navigation/01934c809726727dad9c1869ec2edce2', '/navigation/01934c809726727dad9c1869ece2e622', '/navigation/01934c809726727dad9c1869ed903b6d', '/navigation/01934c809726727dad9c1869edbe731d', '/navigation/01934c809726727dad9c1869ee178ae8', '/navigation/01934c809726727dad9c1869ef0f8417', '/navigation/01934c809726727dad9c1869ef86a095', '/navigation/01934c80972772bea6d0607ee19fd4b8', '/navigation/01934c80972772bea6d0607ee279a8f4', '/navigation/01934c80972772bea6d0607ee3682b45', '/navigation/01934c80972772bea6d0607ee40409f7', '/navigation/01934c80972772bea6d0607ee4f4ea57', '/navigation/01934c80972772bea6d0607ee59600f8', '/navigation/01934c80972772bea6d0607ee6338fba', '/navigation/01934c80972772bea6d0607ee6a1fb68', '/navigation/01934c80972772bea6d0607ee74056fe', '/navigation/01934c80972772bea6d0607ee9f17d5a', '/navigation/01934c80972871fbb285325f98d10c37', '/navigation/01934c80972871fbb285325f9bbd333a', '/navigation/01934c80972871fbb285325f9f5b9a7f', '/navigation/01934c80972871fbb285325f9fa09dc7', '/navigation/01934c809729713882dc1c1b73a159b5', '/navigation/01934c809729713882dc1c1b749e9978', '/navigation/01934c809729713882dc1c1b77c35bd4', '/navigation/01934c809729713882dc1c1b7c194812', '/navigation/01934c80972a712d95c297d0f7fe53fe', '/navigation/01934c80972a712d95c297d0f8cd0a06', '/navigation/01934c80972a712d95c297d0f903ce9b', '/navigation/01934c80972a712d95c297d0f9e92486', '/navigation/01934c80972a712d95c297d0fbbcaf01', '/navigation/01934c80972a712d95c297d0fcd4d763', '/navigation/01934c80972b70d687f808263b5cd369', '/navigation/01934c80972b70d687f808263b8a6148', '/navigation/01934c80972b70d687f808263d42aed0', '/navigation/01934c80972b70d687f80826400d956c', '/navigation/01934c80972b70d687f80826432b74d8', '/navigation/01934c80972c7354b61cd4e449aaff50', '/navigation/01934c80972c7354b61cd4e44babc986', '/navigation/01934c80972c7354b61cd4e44d4f190f', '/navigation/01934c80972c7354b61cd4e44fbbbd41', '/navigation/01934c80972c7354b61cd4e45193592a', '/navigation/01934c80972c7354b61cd4e4524cad28', '/navigation/01934c80972d7189a3d66f0bfda634a0', '/navigation/01934c80972d7189a3d66f0bffe3f655', '/navigation/01934c80972d7189a3d66f0c002bbae2', '/navigation/01934c80972d7189a3d66f0c036175b7', '/navigation/01934c80972e7155a7abaa614bfbbf91', '/navigation/01934c80972e7155a7abaa614d497ab8', '/navigation/01934c80972e7155a7abaa614ffb0e8a', '/navigation/01934c80972f711ea1d4e32a30572231', '/navigation/01934c80972f711ea1d4e32a306caecc', '/navigation/01934c80972f711ea1d4e32a311bf757', '/navigation/01934c80972f711ea1d4e32a3418de77', '/navigation/01934c80972f711ea1d4e32a362e08bc', '/navigation/01934c80973073f5b5943825d098f55d', '/navigation/01934c80973073f5b5943825d3d12d2f', '/navigation/01934c80973073f5b5943825d4018067', '/navigation/01934c80973073f5b5943825d6cfed39', '/navigation/01934c80973171c1b26e90047ac890ef', '/navigation/01934c80973171c1b26e90047ca936d9', '/navigation/01934c80973171c1b26e90047f910571', '/navigation/01934c80973171c1b26e9004815dc455', '/navigation/01934c809732719cbaed7db837a44430', '/navigation/01934c809732719cbaed7db839551dfd', '/navigation/01934c809732719cbaed7db83a608478', '/navigation/01934c809732719cbaed7db83d2d93e1', '/navigation/01934c809732719cbaed7db83dae8d54', '/navigation/01934c80973370a295f851f189b49023', '/navigation/01934c80973370a295f851f18cd24ca9', '/navigation/01934c80973370a295f851f18ee40058', '/navigation/01934c8097347118ba4f87bf293c8791', '/navigation/01934c8097347118ba4f87bf29a3d6fb', '/navigation/01934c8097347118ba4f87bf29f3b214', '/navigation/01934c8097347118ba4f87bf2adc964b', '/navigation/01934c8097347118ba4f87bf2ce11f8a', '/navigation/01934c8097347118ba4f87bf2dca46ed', '/navigation/01934c8097357207b0846cbd5559b90d', '/navigation/01934c8097357207b0846cbd582ac408', '/navigation/01934c8097357207b0846cbd5b59421d', '/navigation/01934c8097357207b0846cbd5c10deb3', '/navigation/01934c80973670e89cbd388531c63ea3', '/navigation/01934c80973670e89cbd388534302b87', '/navigation/01934c80973670e89cbd3885374564bc', '/navigation/01934c80973670e89cbd38853792efae', '/navigation/01934c8097377015b4d60f8c7340ad98', '/navigation/01934c8097377015b4d60f8c760643b0', '/navigation/01934c8097377015b4d60f8c76798ed7', '/navigation/01934c8097377015b4d60f8c7702b1a2', '/navigation/01934c8097377015b4d60f8c778ff962', '/navigation/01934c8097377015b4d60f8c77e6965d', '/navigation/01934c8097387252afcae1610b7f46b7', '/navigation/01934c8097387252afcae1610be375f9', '/navigation/01934c8097387252afcae1610c142e41', '/navigation/01934c8097387252afcae1610c371852', '/navigation/01934c8097387252afcae1610ce8113d', '/navigation/01934c8097387252afcae1610d26e28d', '/navigation/01934c8097387252afcae1610d929889', '/navigation/01934c8097387252afcae1610e04c181', '/navigation/01934c8097387252afcae1610e548cde', '/navigation/01934c8097387252afcae1610ed89bec', '/navigation/01934c8097387252afcae1610f9de963', '/navigation/01934c8097387252afcae161103db29d', '/navigation/01934c8097387252afcae16111f4712a', '/navigation/01934c8097387252afcae16112d5a413', '/navigation/01934c8097387252afcae16113073aac', '/navigation/01934c8097387252afcae1611371db8a', '/navigation/01934c809739721d92fcaab8b41c4cc4', '/navigation/01934c809739721d92fcaab8b467edb7', '/navigation/01934c809739721d92fcaab8b5615e64', '/navigation/01934c809739721d92fcaab8b5d92980', '/navigation/01934c809739721d92fcaab8b6a78220', '/navigation/01934c809739721d92fcaab8b79db0fe', '/navigation/01934c809739721d92fcaab8b7fcbe7a', '/navigation/01934c809739721d92fcaab8b8765ef0', '/navigation/01934c809739721d92fcaab8b93adc35', '/navigation/01934c809739721d92fcaab8b96a0b2b', '/navigation/01934c809739721d92fcaab8b9f25141', '/navigation/01934c809739721d92fcaab8ba4df0a9', '/navigation/01934c809739721d92fcaab8bac6d2b1', '/navigation/01934c809739721d92fcaab8bb84b088', '/navigation/01934c809739721d92fcaab8bc7f1760', '/navigation/01934c809739721d92fcaab8bd58c856', '/navigation/01934c80973a7227a6ce9c52d2f7b749', '/navigation/01934c80973a7227a6ce9c52d3c613c3', '/navigation/01934c80973a7227a6ce9c52d3c960e6', '/navigation/01934c80973a7227a6ce9c52d462f944', '/navigation/01934c80973a7227a6ce9c52d54fee74', '/navigation/01934c80973a7227a6ce9c52d6382de5', '/navigation/01934c80973a7227a6ce9c52d7367b09', '/navigation/01934c80973a7227a6ce9c52d79c1f3d', '/navigation/01934c80973a7227a6ce9c52d8586e2f', '/navigation/01934c80973a7227a6ce9c52d8d3d54c', '/navigation/01934c80973a7227a6ce9c52d9b0f409', '/navigation/01934c80973a7227a6ce9c52da001577', '/navigation/01934c80973a7227a6ce9c52da98169c', '/navigation/01934c80973a7227a6ce9c52db411140', '/navigation/01934c80973a7227a6ce9c52dc35ea28', '/navigation/01934c80973b71f3bb35a2f936200def', '/navigation/01934c80973b71f3bb35a2f9367a165d', '/navigation/01934c80973b71f3bb35a2f936b7ec8d', '/navigation/01934c80973b71f3bb35a2f936e3c24a', '/navigation/01934c80973b71f3bb35a2f937082b7d', '/navigation/01934c80973b71f3bb35a2f937caa809', '/navigation/01934c80973b71f3bb35a2f937fc0d33', '/navigation/01934c80973b71f3bb35a2f9387a0462', '/navigation/01934c80973b71f3bb35a2f9391153a9', '/navigation/01934c80973b71f3bb35a2f93936c76a', '/navigation/01934c80973b71f3bb35a2f93944c140', '/navigation/01934c80973b71f3bb35a2f939c83c2f', '/navigation/01934c80973b71f3bb35a2f93a5b176c', '/navigation/01934c80973b71f3bb35a2f93a716f7e', '/navigation/01934c80973b71f3bb35a2f93b6208ee', '/navigation/01934c80973c7095bf16d76d7fb4c1b5', '/navigation/01934c80973c7095bf16d76d800a1610', '/navigation/01934c80973c7095bf16d76d80a6e97c', '/navigation/01934c80973c7095bf16d76d8138de69', '/navigation/01934c80973c7095bf16d76d8184c6fc', '/navigation/01934c80973c7095bf16d76d82754948', '/navigation/01934c80973c7095bf16d76d828510d0', '/navigation/01934c80973c7095bf16d76d831bd741', '/navigation/01934c80973c7095bf16d76d8471de38', '/navigation/01934c80973c7095bf16d76d863763ae', '/navigation/01934c80973d716daa7ca447f0919a3f', '/navigation/01934c80973d716daa7ca447f0a04a9a', '/navigation/01934c80973d716daa7ca447f32f53a7', '/navigation/01934c80973d716daa7ca447f569f6db', '/navigation/01934c80973e73768dc720ac4d76f92a', '/navigation/01934c80973e73768dc720ac502c7de4', '/navigation/01934c80973e73768dc720ac51776350', '/navigation/01934c80973e73768dc720ac51a53aff', '/navigation/01934c80973e73768dc720ac53d9c210', '/navigation/01934c80973f72df8f2cb7581cc8b848', '/navigation/01934c80973f72df8f2cb75820358e43', '/navigation/01934c80973f72df8f2cb758210e3156', '/navigation/01934c80973f72df8f2cb758216fadb6', '/navigation/01934c80973f72df8f2cb75821e0b1a0', '/navigation/01934c80974070ef95608e4c1e080905', '/navigation/01934c80974070ef95608e4c1f62eccd', '/navigation/01934c80974070ef95608e4c20bce3c2', '/navigation/01934c80974070ef95608e4c2325255d', '/navigation/01934c80974070ef95608e4c23e2cab1', '/navigation/01934c8097417232a95fd07836e0195b', '/navigation/01934c8097417232a95fd0783960bf50', '/navigation/01934c8097417232a95fd0783b02518d', '/navigation/01934c8097417232a95fd0783bda57c8', '/navigation/01934c8097417232a95fd0783c7986be', '/navigation/01934c8097417232a95fd0783e4958d0', '/navigation/01934c809742716dbcbdd9d7ad94a70e', '/navigation/01934c809742716dbcbdd9d7b08dc564', '/navigation/01934c809742716dbcbdd9d7b13d1af9', '/navigation/01934c809742716dbcbdd9d7b240a269', '/navigation/01934c809742716dbcbdd9d7b2f97b68', '/navigation/01934c809743718491b5ecc8742801fd', '/navigation/01934c809743718491b5ecc8789c086d', '/navigation/01934c809743718491b5ecc879800211', '/navigation/01934c809743718491b5ecc8799ed175', '/navigation/01934c809743718491b5ecc87a37c012', '/navigation/01934c809743718491b5ecc87a73d3e0', '/navigation/01934c809743718491b5ecc87b3921df', '/navigation/01934c8097447329bfb184bc4ceb80d8', '/navigation/01934c8097447329bfb184bc4dbff48f', '/navigation/01934c8097447329bfb184bc4e0db62b', '/navigation/01934c8097447329bfb184bc4e35e6e7', '/navigation/01934c8097447329bfb184bc4e73b9ac', '/navigation/01934c8097447329bfb184bc4eb3cbc0', '/navigation/01934c8097447329bfb184bc4f3b13c3', '/navigation/01934c8097447329bfb184bc4f41c53b', '/navigation/01934c8097447329bfb184bc4fbda10c', '/navigation/01934c8097447329bfb184bc4fc45ff9', '/navigation/01934c8097447329bfb184bc508c6015', '/navigation/01934c80974573f1b524b63643cba211', '/navigation/01934c80974573f1b524b6364778a60e', '/navigation/01934c80974573f1b524b6364ab991a3', '/navigation/01934c80974573f1b524b6364afc9a55', '/navigation/01934c8097467332b80376773871cee4', '/navigation/01934c8097467332b80376773a308fec', '/navigation/01934c8097467332b80376773a74445e', '/navigation/01934c8097467332b80376773c6a7d35', '/navigation/01934c809747715a8bc1d1727b558d24', '/navigation/01934c809747715a8bc1d1727ebfb2ad', '/navigation/01934c80974873e98361ad6012409e4e', '/navigation/01934c80974873e98361ad60157e4d79', '/navigation/01934c80974873e98361ad60163f1652', '/navigation/01934c80974873e98361ad60173b24cb', '/navigation/01934c80974873e98361ad60191635aa', '/navigation/01934c80974973b0843e50920bef47a0', '/navigation/01934c80974973b0843e50920cb9025a', '/navigation/01934c80974973b0843e50920de00ffa', '/navigation/01934c80974973b0843e509211698748', '/navigation/01934c80974a71a48abcc8285b9376e6', '/navigation/01934c80974a71a48abcc8285f1a4817', '/navigation/01934c80974a71a48abcc8285f691115', '/navigation/01934c80974a71a48abcc828616e41b5', '/navigation/01934c80974b71ed9f127601d48991fa', '/navigation/01934c80974b71ed9f127601d6a46697', '/navigation/01934c80974b71ed9f127601d77f8e9e', '/navigation/01934c80974b71ed9f127601d81ea3fe', '/navigation/01934c80974b71ed9f127601d893ae09', '/navigation/01934c80974b71ed9f127601da95e657', '/navigation/01934c80974c7390a84580a70cc28334', '/navigation/01934c80974c7390a84580a70ee7b4e4', '/navigation/01934c80974c7390a84580a7106dc265', '/navigation/01934c80974c7390a84580a710c91725', '/navigation/01934c80974c7390a84580a7136f310c', '/navigation/01934c80974d71f584865b7be7942aa8', '/navigation/01934c80974d71f584865b7bea5e6799', '/navigation/01934c80974d71f584865b7beaf09a06', '/navigation/01934c80974d71f584865b7beb77ab99', '/navigation/01934c80974d71f584865b7beced7e3b', '/navigation/01934c80974e707f8e6f0b52bc130d85', '/navigation/01934c80974e707f8e6f0b52befcaaf5', '/navigation/01934c80974e707f8e6f0b52c0945a52', '/navigation/01934c80974e707f8e6f0b52c1742102', '/navigation/01934c80974f728eb9e27e99e409ba1e', '/navigation/01934c80974f728eb9e27e99e6e9e4f8', '/navigation/01934c80975072509dc1b5fe55c551b8', '/navigation/01934c80975072509dc1b5fe57d022b1', '/navigation/01934c80975072509dc1b5fe5a8ff29f', '/navigation/01934c80975072509dc1b5fe5b2d28e9', '/navigation/01934c80975171e58b81244bc2409588', '/navigation/01934c80975171e58b81244bc53f9a7a', '/navigation/01934c80975171e58b81244bc71e5bf0', '/navigation/01934c80975171e58b81244bc7708e6c', '/navigation/01934c809752731da65382dd7a9e28f1', '/navigation/01934c809752731da65382dd7cc83f09', '/navigation/01934c809752731da65382dd7dc75fc9', '/navigation/01934c809752731da65382dd7ec646d6', '/navigation/01934c80975372448cae5d75bbb5a8be', '/navigation/01934c80975372448cae5d75bdad7983', '/navigation/01934c80975372448cae5d75be30ca3b', '/navigation/01934c80975372448cae5d75be336d80', '/navigation/01934c80975470f2833b63bc066c3a9a', '/navigation/01934c80975470f2833b63bc0a70ff07', '/navigation/01934c80975470f2833b63bc0d034601', '/navigation/01934c809755709eb45b5657cef0ed9e', '/navigation/01934c809755709eb45b5657cf78315f', '/navigation/01934c809755709eb45b5657d168b168', '/navigation/01934c809755709eb45b5657d442dab3', '/navigation/01934c80975670b7b24f3df8e2ab61c7', '/navigation/01934c80975670b7b24f3df8e37e9042', '/navigation/01934c80975670b7b24f3df8e60908a1', '/navigation/01934c80975670b7b24f3df8e98f0402', '/navigation/01934c809757731fa16755e9dd0b74f4', '/navigation/01934c809757731fa16755e9dd7a9be1', '/navigation/01934c809757731fa16755e9dfa13e84', '/navigation/01934c809757731fa16755e9dfad2f9a', '/navigation/01934c809757731fa16755e9e00e01b5', '/navigation/01934c8097587105b21175a95e0ccc60', '/navigation/01934c8097587105b21175a9607908e7', '/navigation/01934c80975970e0a9b719a1ece3010e', '/navigation/01934c80975970e0a9b719a1efaa6e1b', '/navigation/01934c80975970e0a9b719a1f072b233', '/navigation/01934c80975a73b49ecd58c88474ff7a', '/navigation/01934c80975a73b49ecd58c886b61ea1', '/navigation/01934c80975a73b49ecd58c887205b9d', '/navigation/01934c80975a73b49ecd58c8883b60f8', '/navigation/01934c80975a73b49ecd58c888d124cb', '/navigation/01934c80975a73b49ecd58c889479534', '/navigation/01934c80975a73b49ecd58c889b12889', '/navigation/01934c80975b7247aae2d094b3a7783e', '/navigation/01934c80975b7247aae2d094b6a51b30', '/navigation/01934c80975b7247aae2d094b8f66409', '/navigation/01934c80975c7055ae731806f802abb4', '/navigation/01934c80975c7055ae731806f8414944', '/navigation/01934c80975c7055ae731806fa76e613', '/navigation/01934c80975c7055ae731806fccc9332', '/navigation/01934c80975d71259883239569ba7a2b', '/navigation/01934c80975d7125988323956b13a0ce', '/navigation/01934c80975d7125988323956cf7635a', '/navigation/01934c80975d7125988323956d9e37e4', '/navigation/01934c80975e71dc84170f81b3ff4082', '/navigation/01934c80975e71dc84170f81b647aec8', '/navigation/01934c80975e71dc84170f81b6748a62', '/navigation/01934c80975e71dc84170f81b838ceff', '/navigation/01934c80975f72db8a360a1f23aa07c2', '/navigation/01934c80975f72db8a360a1f248223ab', '/navigation/01934c80975f72db8a360a1f261a8f6c', '/navigation/01934c80975f72db8a360a1f2869e317', '/navigation/01934c80976071aabf98a125cbd86a07', '/navigation/01934c80976071aabf98a125cd43c68b', '/navigation/01934c80976071aabf98a125cdd9e0fc', '/navigation/01934c80976071aabf98a125ce97c821', '/navigation/01934c80976071aabf98a125cee388c2', '/navigation/01934c8097617087b91b6e55cc8720da', '/navigation/01934c8097617087b91b6e55cf3d7ed5', '/navigation/01934c8097617087b91b6e55d23c2efd', '/navigation/01934c8097617087b91b6e55d358beed', '/navigation/01934c80976273cfa24b05ee5143ec7e', '/navigation/01934c80976273cfa24b05ee54ace3c0', '/detail/01934c80c87472ebac895d67c83b12c3', '/detail/01934c80d49b7284972fc4d2a792a293', '/detail/01934c80cf6e72098f1dc03dd00014d0', '/detail/01934c80cdf87316834f015779b4a72e', '/detail/01934c80d34d716e8097f1cb13e6b9ef', '/detail/01934c80c88e70feb007c6b084d7c2b6', '/detail/01934c80cf8173bba3c59492cddee272', '/detail/01934c80cc8471378d7bf1f0573adc45', '/detail/01934c80cb3472f991ffa52b1f01a27b', '/detail/01934c80c9ac721997126534a263d0a7', '/detail/01934c80cb437173852165de8dd20040', '/detail/01934c80cb4e71e49a95b7550f59189e', '/detail/01934c80c85772f2ad3529a293acc1b0', '/detail/01934c80c9c4739caa99fdf2737d4699', '/detail/01934c80c88772e98f020ee3fd953eba', '/detail/01934c80ce1b72678ee2db51c575b116', '/detail/01934c80d4747076ba3968f9e63439f2', '/detail/01934c80c9a07021b8c9b681c8646ebe', '/detail/01934c80d30c71e98594a72065963e42', '/detail/01934c80d45d72d9949fdab17ae4895c', '/detail/01934c80cf5273f3970313da87222f8c', '/detail/01934c80d48872c5acc05df3d756acf7', '/detail/01934c80c9cf7057b7af0226b6c0e3da', '/detail/01934c80cf6372f3b9af9cfc1b95c9f5')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x01934C804C7B70FC92A3B6EDBFD15EFA OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# product-listing-route::loading::aggregation::price
SELECT
  MIN(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) as `price.min`,
  MAX(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) as `price.max`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
    )
  )

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb8d37016b31da247d86b9185.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb90a711e9304a2ffc52b1b30.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fccef7339821e31f6627f8423.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01934c7fb96c70488ecd7e7277cd55a7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x01934C804C7B70FC92A3B6EDBFD15EFA AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x01934C809704720281FD3B4C503B1CC3 AND NOT (`product`.`display_group` <=> NULL)));

# 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 '%|01934c7fb91f73659c0f6adfc64626c7|%' AND (`category`.`level` > 1 AND `category`.`level` <= 5)));