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/0196e653080173a58831fba67b6f0f58', '/navigation/0196e65307ce719fab57a434fee61759', '/navigation/0196e65307d972d8a721378dcb4ff888', '/navigation/0196e65307e7720697a08d4ca0f081c0', '/navigation/0196e65307f672818699342c2ee93be1', '/navigation/0196e65307f87279953e02199ec2ca69', '/navigation/0196e65307fe720cb60feb38fcca3731', '/navigation/0196e65307ff714caaf4e1a6decf69c6', '/navigation/0196e653080370108efe5b9f8bb748f9', '/navigation/0196e65308047001a12c3038cb5fd1e5', '/navigation/0196e653080673ae9376c87f580b6d7b', '/navigation/0196e65307cf71ffb8bf40af8caebd5f', '/navigation/0196e65307cf71ffb8bf40af8d520fdf', '/navigation/0196e65307cf71ffb8bf40af8e1692a7', '/navigation/0196e65307cf71ffb8bf40af8ff5209f', '/navigation/0196e65307cf71ffb8bf40af92c9ea82', '/navigation/0196e65307d071b6a98e0ad2a71acc2a', '/navigation/0196e65307d071b6a98e0ad2a9d56fe3', '/navigation/0196e65307d071b6a98e0ad2ac00d1d5', '/navigation/0196e65307d071b6a98e0ad2ac20bb28', '/navigation/0196e65307d171e48cc33480636f40d3', '/navigation/0196e65307d171e48cc3348065541e76', '/navigation/0196e65307d171e48cc3348065dec82f', '/navigation/0196e65307d171e48cc3348066732110', '/navigation/0196e65307d171e48cc3348068db8994', '/navigation/0196e65307d171e48cc3348068dbfc2f', '/navigation/0196e65307d171e48cc33480690e99c0', '/navigation/0196e65307d171e48cc334806b1551b9', '/navigation/0196e65307d2707d80d0320f4eb16d57', '/navigation/0196e65307d2707d80d0320f4f4211db', '/navigation/0196e65307d2707d80d0320f517b25de', '/navigation/0196e65307d2707d80d0320f53a9025f', '/navigation/0196e65307d2707d80d0320f56243900', '/navigation/0196e65307d2707d80d0320f56a570ac', '/navigation/0196e65307d3711ea396251145ed92b2', '/navigation/0196e65307d3711ea3962511484aeddb', '/navigation/0196e65307d3711ea39625114b5e8f08', '/navigation/0196e65307d47088943d7aee444ea847', '/navigation/0196e65307d47088943d7aee4462ff1a', '/navigation/0196e65307d47088943d7aee46a76b54', '/navigation/0196e65307d47088943d7aee48e3fdbe', '/navigation/0196e65307d571c6a9ad152164f223cc', '/navigation/0196e65307d571c6a9ad152167854804', '/navigation/0196e65307d571c6a9ad152167de6b8c', '/navigation/0196e65307d571c6a9ad15216961efe9', '/navigation/0196e65307d6724780d7a11bb10dec13', '/navigation/0196e65307d6724780d7a11bb350163e', '/navigation/0196e65307d6724780d7a11bb4ff0427', '/navigation/0196e65307d6724780d7a11bb795514e', '/navigation/0196e65307d6724780d7a11bb8096759', '/navigation/0196e65307d6724780d7a11bb81fb703', '/navigation/0196e65307d7717cb20579cf008ad0f1', '/navigation/0196e65307d7717cb20579cf032bddba', '/navigation/0196e65307d7717cb20579cf05f78a97', '/navigation/0196e65307d7717cb20579cf06ee373a', '/navigation/0196e65307d87256b6f2ea305e226769', '/navigation/0196e65307d87256b6f2ea305efc7b21', '/navigation/0196e65307d87256b6f2ea305fd13aec', '/navigation/0196e65307d87256b6f2ea306458425c', '/navigation/0196e65307d87256b6f2ea3066441dde', '/navigation/0196e65307d972d8a721378dcbe1bf3d', '/navigation/0196e65307d972d8a721378dcc73b3a0', '/navigation/0196e65307d972d8a721378dcd0bfc90', '/navigation/0196e65307d972d8a721378dceeaab78', '/navigation/0196e65307d972d8a721378dd0b91809', '/navigation/0196e65307d972d8a721378dd101222c', '/navigation/0196e65307da7277a6ad4a22dcf9bee4', '/navigation/0196e65307da7277a6ad4a22dfed4271', '/navigation/0196e65307da7277a6ad4a22e1be45f5', '/navigation/0196e65307da7277a6ad4a22e41f8949', '/navigation/0196e65307da7277a6ad4a22e4d29cac', '/navigation/0196e65307da7277a6ad4a22e587b21b', '/navigation/0196e65307db73728cd54e819db5e890', '/navigation/0196e65307db73728cd54e81a05ba9c0', '/navigation/0196e65307db73728cd54e81a06b2ac1', '/navigation/0196e65307db73728cd54e81a416d560', '/navigation/0196e65307db73728cd54e81a5799af9', '/navigation/0196e65307dc715dad24cf24f80ebb93', '/navigation/0196e65307dc715dad24cf24fbba56c0', '/navigation/0196e65307dc715dad24cf24fc83e634', '/navigation/0196e65307dc715dad24cf24fff8a0cf', '/navigation/0196e65307dd71739f3539739b700ff9', '/navigation/0196e65307dd71739f3539739e86cbfd', '/navigation/0196e65307dd71739f353973a0da7f13', '/navigation/0196e65307de732b8e2b0e54de34d3b9', '/navigation/0196e65307de732b8e2b0e54de512c51', '/navigation/0196e65307de732b8e2b0e54e1d70d14', '/navigation/0196e65307de732b8e2b0e54e3cf72bf', '/navigation/0196e65307df707986e777bab66432c3', '/navigation/0196e65307df707986e777bab77c3a3f', '/navigation/0196e65307df707986e777bab7b3cadf', '/navigation/0196e65307df707986e777bab7c2de3b', '/navigation/0196e65307df707986e777baba5470af', '/navigation/0196e65307e070448991d18c16b262c1', '/navigation/0196e65307e070448991d18c18b6f02c', '/navigation/0196e65307e070448991d18c1aa8f884', '/navigation/0196e65307e070448991d18c1d3fcd05', '/navigation/0196e65307e070448991d18c1df0ab18', '/navigation/0196e65307e1704392a7b4139e15cc65', '/navigation/0196e65307e1704392a7b4139fcabbd0', '/navigation/0196e65307e1704392a7b413a0cf9b7d', '/navigation/0196e65307e1704392a7b413a3374e11', '/navigation/0196e65307e273ebb2728894f2e0287a', '/navigation/0196e65307e273ebb2728894f3db1241', '/navigation/0196e65307e273ebb2728894f82de29b', '/navigation/0196e65307e273ebb2728894fb4f3c47', '/navigation/0196e65307e370c4b0d2503eadd1e260', '/navigation/0196e65307e370c4b0d2503eae4f91d0', '/navigation/0196e65307e370c4b0d2503eaf4c88ea', '/navigation/0196e65307e370c4b0d2503eb3683616', '/navigation/0196e65307e370c4b0d2503eb5e7b460', '/navigation/0196e65307e471e386b3f5a0af869707', '/navigation/0196e65307e471e386b3f5a0aff54c83', '/navigation/0196e65307e471e386b3f5a0b3d6b120', '/navigation/0196e65307e471e386b3f5a0b6acaf31', '/navigation/0196e65307e471e386b3f5a0b8abeb73', '/navigation/0196e65307e471e386b3f5a0b910fa09', '/navigation/0196e65307e572b9ae0a2bab743a2cc3', '/navigation/0196e65307e572b9ae0a2bab7701df81', '/navigation/0196e65307e572b9ae0a2bab782e3dbc', '/navigation/0196e65307e572b9ae0a2bab7ab6065a', '/navigation/0196e65307e6734382ccef728ec78b9d', '/navigation/0196e65307e6734382ccef728fb35332', '/navigation/0196e65307e6734382ccef7293493adb', '/navigation/0196e65307e6734382ccef7295d59538', '/navigation/0196e65307e7720697a08d4ca16cd72a', '/navigation/0196e65307e7720697a08d4ca232ace7', '/navigation/0196e65307e7720697a08d4ca262a1b6', '/navigation/0196e65307e7720697a08d4ca555a8ff', '/navigation/0196e65307e870fa93ccb2511c4c6cbd', '/navigation/0196e65307e870fa93ccb2511c7cc63c', '/navigation/0196e65307e870fa93ccb2511dff0af6', '/navigation/0196e65307e870fa93ccb2511fad1c55', '/navigation/0196e65307e870fa93ccb2512288107e', '/navigation/0196e65307e970a3a84d6dd7a2391074', '/navigation/0196e65307e970a3a84d6dd7a5790254', '/navigation/0196e65307e970a3a84d6dd7a5c3fb04', '/navigation/0196e65307e970a3a84d6dd7a6772c0b', '/navigation/0196e65307e970a3a84d6dd7a82d8bd6', '/navigation/0196e65307ea711985c4190679bef5bb', '/navigation/0196e65307ea711985c419067c1e42ba', '/navigation/0196e65307ea711985c419067f7fae4c', '/navigation/0196e65307ea711985c41906800e18d6', '/navigation/0196e65307eb713b96dad710930a690f', '/navigation/0196e65307eb713b96dad71096063807', '/navigation/0196e65307eb713b96dad710986b967e', '/navigation/0196e65307ec708791d6366a28ba2c44', '/navigation/0196e65307ec708791d6366a2ab583d4', '/navigation/0196e65307ec708791d6366a2b03f0ba', '/navigation/0196e65307ec708791d6366a2d7e103c', '/navigation/0196e65307ec708791d6366a30101623', '/navigation/0196e65307ed73ee92063c8f3b7841d6', '/navigation/0196e65307ed73ee92063c8f3e5d5c2e', '/navigation/0196e65307ed73ee92063c8f4160b7cc', '/navigation/0196e65307ed73ee92063c8f416ca0fd', '/navigation/0196e65307ee7254973c861721552ba1', '/navigation/0196e65307ee7254973c8617248f319d', '/navigation/0196e65307ee7254973c861727665a8c', '/navigation/0196e65307ee7254973c8617277bf685', '/navigation/0196e65307ef715784865c4071e50dd6', '/navigation/0196e65307ef715784865c40742042cb', '/navigation/0196e65307ef715784865c4075dd65d6', '/navigation/0196e65307ef715784865c40761bbc45', '/navigation/0196e65307ef715784865c40768fdb5b', '/navigation/0196e65307ef715784865c4077d4ccc2', '/navigation/0196e65307f070978fc582e7e8c2b082', '/navigation/0196e65307f070978fc582e7eb42738d', '/navigation/0196e65307f070978fc582e7ef2128eb', '/navigation/0196e65307f171f3841bf66c58d25116', '/navigation/0196e65307f171f3841bf66c5914211f', '/navigation/0196e65307f171f3841bf66c5c907b67', '/navigation/0196e65307f171f3841bf66c5ec51e50', '/navigation/0196e65307f272fab9a83858f9b543eb', '/navigation/0196e65307f272fab9a83858fc4a42af', '/navigation/0196e65307f272fab9a83858ff4b1da1', '/navigation/0196e65307f272fab9a83858ffb0e26d', '/navigation/0196e65307f371a68cd34a1125540a9a', '/navigation/0196e65307f371a68cd34a1127c77823', '/navigation/0196e65307f371a68cd34a11288f11b1', '/navigation/0196e65307f371a68cd34a112b6fefba', '/navigation/0196e65307f371a68cd34a112d19f96e', '/navigation/0196e65307f371a68cd34a112d2953a4', '/navigation/0196e65307f47302942bed97fc0cb310', '/navigation/0196e65307f47302942bed97fe242914', '/navigation/0196e65307f47302942bed97ffedf268', '/navigation/0196e65307f47302942bed980378dfb1', '/navigation/0196e65307f570f3a1ec37c3c18eb3c2', '/navigation/0196e65307f570f3a1ec37c3c1c7a8d2', '/navigation/0196e65307f570f3a1ec37c3c5213eac', '/navigation/0196e65307f570f3a1ec37c3c6e2beb4', '/navigation/0196e65307f570f3a1ec37c3c7515338', '/navigation/0196e65307f672818699342c2c8de04d', '/navigation/0196e65307f672818699342c2facb5d1', '/navigation/0196e65307f672818699342c2ffdb46e', '/navigation/0196e65307f672818699342c300a288b', '/navigation/0196e65307f672818699342c30ab1592', '/navigation/0196e65307f672818699342c30f91f52', '/navigation/0196e65307f672818699342c31a2dcbe', '/navigation/0196e65307f770a8ac4acd1d90c6030c', '/navigation/0196e65307f770a8ac4acd1d91aedda4', '/navigation/0196e65307f770a8ac4acd1d920786f1', '/navigation/0196e65307f770a8ac4acd1d92da6279', '/navigation/0196e65307f770a8ac4acd1d933b4f47', '/navigation/0196e65307f770a8ac4acd1d93e20822', '/navigation/0196e65307f770a8ac4acd1d94456fd4', '/navigation/0196e65307f770a8ac4acd1d94a5a943', '/navigation/0196e65307f770a8ac4acd1d952bd7dd', '/navigation/0196e65307f770a8ac4acd1d95959eeb', '/navigation/0196e65307f770a8ac4acd1d95bfd1ca', '/navigation/0196e65307f770a8ac4acd1d95d30245', '/navigation/0196e65307f770a8ac4acd1d9694ea94', '/navigation/0196e65307f770a8ac4acd1d97798638', '/navigation/0196e65307f770a8ac4acd1d97ff502d', '/navigation/0196e65307f770a8ac4acd1d9856c372', '/navigation/0196e65307f87279953e021998e675bb', '/navigation/0196e65307f87279953e021998eebe4f', '/navigation/0196e65307f87279953e02199980f561', '/navigation/0196e65307f87279953e0219999edec1', '/navigation/0196e65307f87279953e021999d8640d', '/navigation/0196e65307f87279953e02199a4e50c3', '/navigation/0196e65307f87279953e02199ab0d3cb', '/navigation/0196e65307f87279953e02199b20d564', '/navigation/0196e65307f87279953e02199b6aaba5', '/navigation/0196e65307f87279953e02199c2ee132', '/navigation/0196e65307f87279953e02199c6b6245', '/navigation/0196e65307f87279953e02199cabcb53', '/navigation/0196e65307f87279953e02199d88470c', '/navigation/0196e65307f87279953e02199e4db582', '/navigation/0196e65307f970308c5dfcdcd81db73c', '/navigation/0196e65307f970308c5dfcdcd8499434', '/navigation/0196e65307f970308c5dfcdcd8ae70de', '/navigation/0196e65307f970308c5dfcdcd8fe72d5', '/navigation/0196e65307f970308c5dfcdcd92e90c9', '/navigation/0196e65307f970308c5dfcdcd9c0651d', '/navigation/0196e65307f970308c5dfcdcda8b2392', '/navigation/0196e65307f970308c5dfcdcdb82db46', '/navigation/0196e65307f970308c5dfcdcdc2f8b68', '/navigation/0196e65307f970308c5dfcdcdc9c3c26', '/navigation/0196e65307f970308c5dfcdcdd161905', '/navigation/0196e65307f970308c5dfcdcdda943d6', '/navigation/0196e65307f970308c5dfcdcde3e82dc', '/navigation/0196e65307f970308c5dfcdcdee5f662', '/navigation/0196e65307f970308c5dfcdcdfad1d33', '/navigation/0196e65307f970308c5dfcdce06b6ceb', '/navigation/0196e65307f970308c5dfcdce0dd2e94', '/navigation/0196e65307fa7399bee979bb7c02e29a', '/navigation/0196e65307fa7399bee979bb7c5a3ac5', '/navigation/0196e65307fa7399bee979bb7cb00a90', '/navigation/0196e65307fa7399bee979bb7ce1bb48', '/navigation/0196e65307fa7399bee979bb7dceb185', '/navigation/0196e65307fa7399bee979bb7e06e2f8', '/navigation/0196e65307fa7399bee979bb7e390083', '/navigation/0196e65307fa7399bee979bb7ec6e782', '/navigation/0196e65307fa7399bee979bb7ee8d0f7', '/navigation/0196e65307fa7399bee979bb7f4937dc', '/navigation/0196e65307fa7399bee979bb7f5c66a6', '/navigation/0196e65307fa7399bee979bb7fba8f91', '/navigation/0196e65307fa7399bee979bb80012178', '/navigation/0196e65307fa7399bee979bb805978a3', '/navigation/0196e65307fa7399bee979bb8144aa00', '/navigation/0196e65307fa7399bee979bb81bf73f4', '/navigation/0196e65307fb72619d8ba4d70ab684ee', '/navigation/0196e65307fb72619d8ba4d70aca62dd', '/navigation/0196e65307fb72619d8ba4d70bc7a0d1', '/navigation/0196e65307fb72619d8ba4d70c08845b', '/navigation/0196e65307fb72619d8ba4d70c9d91c0', '/navigation/0196e65307fb72619d8ba4d70cbff95e', '/navigation/0196e65307fb72619d8ba4d70d6e8694', '/navigation/0196e65307fb72619d8ba4d70dff76f2', '/navigation/0196e65307fb72619d8ba4d70e1e9084', '/navigation/0196e65307fb72619d8ba4d70e8333d9', '/navigation/0196e65307fb72619d8ba4d70f31fcfb', '/navigation/0196e65307fb72619d8ba4d7100a2725', '/navigation/0196e65307fb72619d8ba4d710dba124', '/navigation/0196e65307fb72619d8ba4d7118ce853', '/navigation/0196e65307fb72619d8ba4d71256b1c3', '/navigation/0196e65307fb72619d8ba4d712941496', '/navigation/0196e65307fc7145a4520bf0a69c387d', '/navigation/0196e65307fc7145a4520bf0a78669d0', '/navigation/0196e65307fc7145a4520bf0a78a3ec6', '/navigation/0196e65307fc7145a4520bf0a7ce0399', '/navigation/0196e65307fc7145a4520bf0a7e3f7ef', '/navigation/0196e65307fc7145a4520bf0a8062e4b', '/navigation/0196e65307fc7145a4520bf0a8ed0c5b', '/navigation/0196e65307fc7145a4520bf0a98e76b4', '/navigation/0196e65307fc7145a4520bf0aa4b56af', '/navigation/0196e65307fc7145a4520bf0aaad9ac5', '/navigation/0196e65307fc7145a4520bf0aadf5e4d', '/navigation/0196e65307fc7145a4520bf0abd2ba76', '/navigation/0196e65307fc7145a4520bf0abe35d22', '/navigation/0196e65307fc7145a4520bf0acbbe629', '/navigation/0196e65307fc7145a4520bf0acde933b', '/navigation/0196e65307fd711080c4b6e3d4544f2a', '/navigation/0196e65307fd711080c4b6e3d49c3e59', '/navigation/0196e65307fd711080c4b6e3d569f656', '/navigation/0196e65307fd711080c4b6e3d626ae17', '/navigation/0196e65307fd711080c4b6e3d6a3d15e', '/navigation/0196e65307fd711080c4b6e3d7779647', '/navigation/0196e65307fd711080c4b6e3d83acfa8', '/navigation/0196e65307fd711080c4b6e3d885ebb6', '/navigation/0196e65307fd711080c4b6e3d8b78a96', '/navigation/0196e65307fd711080c4b6e3d9227524', '/navigation/0196e65307fd711080c4b6e3d9f382a0', '/navigation/0196e65307fd711080c4b6e3da10495f', '/navigation/0196e65307fd711080c4b6e3dae225b9', '/navigation/0196e65307fd711080c4b6e3db1f1796', '/navigation/0196e65307fd711080c4b6e3dc021959', '/navigation/0196e65307fe720cb60feb38f83b1bac', '/navigation/0196e65307fe720cb60feb38f86962ae', '/navigation/0196e65307fe720cb60feb38f8ef8742', '/navigation/0196e65307fe720cb60feb38f9dd95bb', '/navigation/0196e65307fe720cb60feb38fa1dcf83', '/navigation/0196e65307fe720cb60feb38fa992d49', '/navigation/0196e65307fe720cb60feb38fae4fa82', '/navigation/0196e65307fe720cb60feb38fbdb1cb3', '/navigation/0196e65307fe720cb60feb38fc1fb346', '/navigation/0196e65307fe720cb60feb38fd5e8433', '/navigation/0196e65307fe720cb60feb38fdf82e21', '/navigation/0196e65307fe720cb60feb38fe2b3b1f', '/navigation/0196e65307fe720cb60feb38fe4441e9', '/navigation/0196e65307fe720cb60feb38fed9d47d', '/navigation/0196e65307ff714caaf4e1a6dcbf2664', '/navigation/0196e65307ff714caaf4e1a6dcd58471', '/navigation/0196e65307ff714caaf4e1a6dd56f8d1', '/navigation/0196e65307ff714caaf4e1a6de0eea7e', '/navigation/0196e65307ff714caaf4e1a6de143e00', '/navigation/0196e65307ff714caaf4e1a6dec3552f', '/navigation/0196e65307ff714caaf4e1a6df57304b', '/navigation/0196e65307ff714caaf4e1a6dfb1d93b', '/navigation/0196e65307ff714caaf4e1a6e0991d48', '/navigation/0196e65307ff714caaf4e1a6e13cd979', '/navigation/0196e65307ff714caaf4e1a6e18aeca1', '/navigation/0196e65307ff714caaf4e1a6e1bbfa0a', '/navigation/0196e65307ff714caaf4e1a6e212cfd4', '/navigation/0196e65307ff714caaf4e1a6e251d30e', '/navigation/0196e65307ff714caaf4e1a6e2d6f941', '/navigation/0196e65307ff714caaf4e1a6e3373676', '/navigation/0196e6530800709b918fe479b366be2f', '/navigation/0196e6530800709b918fe479b41eb90f', '/navigation/0196e6530800709b918fe479b42c3b95', '/navigation/0196e6530800709b918fe479b5050458', '/navigation/0196e6530800709b918fe479b5efdbe1', '/navigation/0196e6530800709b918fe479b629f62e', '/navigation/0196e6530800709b918fe479b6d6996e', '/navigation/0196e6530800709b918fe479b77b465b', '/navigation/0196e6530800709b918fe479b77db3b9', '/navigation/0196e6530800709b918fe479b7ae3428', '/navigation/0196e6530800709b918fe479b7e220db', '/navigation/0196e6530800709b918fe479b8b72916', '/navigation/0196e6530800709b918fe479b8d6f813', '/navigation/0196e6530800709b918fe479b9290bba', '/navigation/0196e6530800709b918fe479b99388f3', '/navigation/0196e6530800709b918fe479ba3e0321', '/navigation/0196e6530800709b918fe479bb3c2517', '/navigation/0196e653080173a58831fba67978fd1a', '/navigation/0196e653080173a58831fba679c44d3d', '/navigation/0196e653080173a58831fba67aa9f56a', '/navigation/0196e653080173a58831fba67bbcafe5', '/navigation/0196e653080173a58831fba67be4cad9', '/navigation/0196e653080173a58831fba67c6be7ce', '/navigation/0196e653080173a58831fba67cb26979', '/navigation/0196e653080173a58831fba67d7882aa', '/navigation/0196e653080173a58831fba67d82a8d6', '/navigation/0196e653080173a58831fba67dd458e2', '/navigation/0196e653080173a58831fba67e85ba8b', '/navigation/0196e653080173a58831fba67f03ef76', '/navigation/0196e653080173a58831fba67f801542', '/navigation/0196e653080273cfbcb93b4adf79a492', '/navigation/0196e653080273cfbcb93b4adfe6ec27', '/navigation/0196e653080273cfbcb93b4ae031df5d', '/navigation/0196e653080273cfbcb93b4ae1133cb9', '/navigation/0196e653080273cfbcb93b4ae20dece1', '/navigation/0196e653080273cfbcb93b4ae2da0fa0', '/navigation/0196e653080273cfbcb93b4ae3b3f5c6', '/navigation/0196e653080273cfbcb93b4ae44aee90', '/navigation/0196e653080273cfbcb93b4ae46d5f76', '/navigation/0196e653080273cfbcb93b4ae54a8d16', '/navigation/0196e653080273cfbcb93b4ae623acc7', '/navigation/0196e653080273cfbcb93b4ae687f680', '/navigation/0196e653080273cfbcb93b4ae783edb8', '/navigation/0196e653080273cfbcb93b4ae7b25209', '/navigation/0196e653080273cfbcb93b4ae886b750', '/navigation/0196e653080273cfbcb93b4ae8a988d1', '/navigation/0196e653080370108efe5b9f8b7a5797', '/navigation/0196e653080370108efe5b9f8c433391', '/navigation/0196e653080370108efe5b9f8ce7852c', '/navigation/0196e653080370108efe5b9f8d3621d6', '/navigation/0196e653080370108efe5b9f8d8de1b7', '/navigation/0196e653080370108efe5b9f8e46fcfe', '/navigation/0196e653080370108efe5b9f8e762077', '/navigation/0196e653080370108efe5b9f8f239562', '/navigation/0196e653080370108efe5b9f901aab5b', '/navigation/0196e653080370108efe5b9f902ea422', '/navigation/0196e653080370108efe5b9f905351e7', '/navigation/0196e653080370108efe5b9f90a2e957', '/navigation/0196e653080370108efe5b9f90b4a716', '/navigation/0196e65308047001a12c3038c6bcb813', '/navigation/0196e65308047001a12c3038c6f6e098', '/navigation/0196e65308047001a12c3038c7e11b6f', '/navigation/0196e65308047001a12c3038c83af77d', '/navigation/0196e65308047001a12c3038c89bd8e1', '/navigation/0196e65308047001a12c3038c8c67d00', '/navigation/0196e65308047001a12c3038c96d2290', '/navigation/0196e65308047001a12c3038c9abcdf4', '/navigation/0196e65308047001a12c3038ca5d7e1e', '/navigation/0196e65308047001a12c3038caf5e912', '/navigation/0196e65308047001a12c3038cb64d8c5', '/navigation/0196e65308047001a12c3038cc573b67', '/navigation/0196e65308047001a12c3038cd24250a', '/navigation/0196e65308047001a12c3038cd765b72', '/navigation/0196e653080571548d1213ba20f0b60a', '/navigation/0196e653080571548d1213ba213ee40b', '/navigation/0196e653080571548d1213ba218fb462', '/navigation/0196e653080571548d1213ba21d7d17c', '/navigation/0196e653080571548d1213ba22828d76', '/navigation/0196e653080571548d1213ba228c00f8', '/navigation/0196e653080571548d1213ba22f36e25', '/navigation/0196e653080571548d1213ba23f1e52e', '/navigation/0196e653080571548d1213ba24a0f9b3', '/navigation/0196e653080571548d1213ba24e8a620', '/navigation/0196e653080571548d1213ba24e90e28', '/navigation/0196e653080571548d1213ba25918b95', '/navigation/0196e653080571548d1213ba2621472b', '/navigation/0196e653080571548d1213ba26a73fc3', '/navigation/0196e653080571548d1213ba26c584dc', '/navigation/0196e653080571548d1213ba272b2553', '/navigation/0196e653080673ae9376c87f57738911', '/navigation/0196e653080673ae9376c87f5899d9c2', '/navigation/0196e653080673ae9376c87f591a9859', '/navigation/0196e653080673ae9376c87f59ee7237', '/navigation/0196e653080673ae9376c87f5a14d71d', '/navigation/0196e653080673ae9376c87f5a4ca1d2', '/navigation/0196e653080673ae9376c87f5b027923', '/navigation/0196e653080673ae9376c87f5b194c27', '/navigation/0196e653080673ae9376c87f5b79bf81', '/navigation/0196e653080673ae9376c87f5bc95624', '/navigation/0196e653080673ae9376c87f5c9da377', '/navigation/0196e653080673ae9376c87f5d3195e8', '/navigation/0196e653080673ae9376c87f5db983ea', '/navigation/0196e653080673ae9376c87f5e617764', '/navigation/0196e653080773f580b50e053af8cacc', '/navigation/0196e653080773f580b50e053bd170cc', '/navigation/0196e653080773f580b50e053c4cbf9f', '/navigation/0196e653080773f580b50e053cb11b78', '/navigation/0196e653080773f580b50e053d5ddca9', '/navigation/0196e653080773f580b50e053d8954fe', '/navigation/0196e653080773f580b50e053df299be', '/navigation/0196e653080773f580b50e053e39e071', '/navigation/0196e653080773f580b50e053f04b244', '/navigation/0196e653080773f580b50e053f4090b0', '/navigation/0196e653080773f580b50e05401c8b39', '/navigation/0196e653080773f580b50e05404b8ff1', '/navigation/0196e653080773f580b50e0540e3f89d')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x0196E652B72872D483D0DE57DD989B24 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# product-listing-route::loading::aggregation::options
SELECT
  LOWER(
    HEX(`product.options`.`id`)
  ) as `options.key`,
  COUNT(`product`.`id`) as `options.count`
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 `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`
  AND `product`.`version_id` = `product.options.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`
  LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`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` <=> ?)
    )
  )
GROUP BY
  `product.options`.`id`

# product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` 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 `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.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` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x0196E652B72872D483D0DE57DD989B24 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x0196E653080173A58831FBA67B6F0F58 AND NOT (`product`.`display_group` <=> NULL))) GROUP BY `product.options`.`id`;

# base-context-factory::payment-method::read
SELECT
  `payment_method`.`id` as `payment_method.id`,
  `payment_method`.`plugin_id` as `payment_method.pluginId`,
  `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`,
  `payment_method`.`position` as `payment_method.position`,
  `payment_method`.`active` as `payment_method.active`,
  `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`,
  `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`,
  `payment_method`.`media_id` as `payment_method.mediaId`,
  `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`,
  `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`,
  `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`,
  `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`,
  `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`,
  `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`,
  `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`,
  `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`,
  `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`,
  `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`,
  `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`,
  `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`,
  `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`,
  `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`,
  `payment_method`.`technical_name` as `payment_method.technicalName`,
  `payment_method`.`created_at` as `payment_method.createdAt`,
  `payment_method`.`updated_at` as `payment_method.updatedAt`,
  `payment_method.media`.`id` as `payment_method.media.id`,
  `payment_method.media`.`user_id` as `payment_method.media.userId`,
  `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`,
  `payment_method.media`.`mime_type` as `payment_method.media.mimeType`,
  `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`,
  `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`,
  `payment_method.media`.`file_name` as `payment_method.media.fileName`,
  `payment_method.media`.`file_size` as `payment_method.media.fileSize`,
  `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`,
  `payment_method.media`.`meta_data` as `payment_method.media.metaData`,
  `payment_method.media`.`config` as `payment_method.media.config`,
  `payment_method.media`.`path` as `payment_method.media.path`,
  `payment_method.media`.`private` as `payment_method.media.private`,
  `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`,
  `payment_method.media`.`created_at` as `payment_method.media.createdAt`,
  `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`,
  `payment_method.media.translation.title`,
  `payment_method.media.translation.title` as `payment_method.media.title`,
  `payment_method.media.translation.alt`,
  `payment_method.media.translation.alt` as `payment_method.media.alt`,
  `payment_method.media.translation.customFields`,
  `payment_method.media.translation.customFields` as `payment_method.media.customFields`,
  `payment_method.translation.name`,
  `payment_method.translation.name` as `payment_method.name`,
  `payment_method.translation.distinguishableName`,
  `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`,
  `payment_method.translation.description`,
  `payment_method.translation.description` as `payment_method.description`,
  `payment_method.translation.customFields`,
  `payment_method.translation.customFields` as `payment_method.customFields`
FROM
  `payment_method`
  LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id`
  LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.translation`.`payment_method_id`,
      `payment_method.translation`.`name` as `payment_method.translation.name`,
      `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`,
      `payment_method.translation`.`description` as `payment_method.translation.description`,
      `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`
    FROM
      `payment_method_translation` `payment_method.translation`
    WHERE
      `payment_method.translation`.`language_id` = ?
  ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.media.translation`.`media_id`,
      `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`,
      `payment_method.media.translation`.`title` as `payment_method.media.translation.title`,
      `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`
    FROM
      `media_translation` `payment_method.media.translation`
    WHERE
      `payment_method.media.translation`.`language_id` = ?
  ) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id`
WHERE
  `payment_method`.`id` IN (?)

# base-context-factory::payment-method::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (0x0196E657E8B372AEA468BE8FE0D47EF9);

# cart-rule-loader::load-rules::read
SELECT
  `rule`.`id` as `rule.id`,
  `rule`.`name` as `rule.name`,
  `rule`.`priority` as `rule.priority`,
  `rule`.`description` as `rule.description`,
  `rule`.`payload` as `rule.payload`,
  `rule`.`invalid` as `rule.invalid`,
  `rule`.`areas` as `rule.areas`,
  `rule`.`custom_fields` as `rule.customFields`,
  `rule`.`module_types` as `rule.moduleTypes`,
  `rule`.`created_at` as `rule.createdAt`,
  `rule`.`updated_at` as `rule.updatedAt`
FROM
  `rule`
WHERE
  `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?)

# cart-rule-loader::load-rules::read
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x0196E651FB557300B260039D8BE8D513, 0x0196E651FB8D73DFA0D406E9503AED8B, 0x0196E651FC067097A525408CE820A1E7, 0x0196E652194A701CB63FDEC36847D0D9, 0x0196E651FBFE71C29BD7E61D61E0FAA7, 0x0196E651FC0272B5BBCB6FEB03AF5153, 0x0196E6526EB573A2AA36B01F7A4FE911);

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

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