Symfony Profiler

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

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x019356CCE6FE7214A39E0380AA1D35E6) AND (path_info = '/Garden-Shoes-Movies/Garden-Games-Electronics-Computers/Music-Grocery-Sports/Jewelry-Beauty-Automotive') AND (is_canonical = 1) LIMIT 1;

# 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/019356cd34e673268cbe6fb1cbe7e3ab', '/navigation/019356cd34eb722ea8114de9e94fd5c3', '/navigation/019356cd34ee70fca3407f0ad864805a', '/navigation/019356cd34f8729e9dc6cb296943fb6d', '/navigation/019356cd34fb72f4864543724a2b20e3', '/navigation/019356cd3503710bb2f0c43a8657f7b3', '/navigation/019356cd350573dcac6766ec91e47d2e', '/navigation/019356cd3506727a9ae54bd71b46edd7', '/navigation/019356cd35077076a29b988d0e5ee62c', '/navigation/019356cd351070b3ad7163f25b17cd9e', '/navigation/019356cd34e773439a1d190b837f7050', '/navigation/019356cd34e773439a1d190b83eb9778', '/navigation/019356cd34e773439a1d190b8463e364', '/navigation/019356cd34e773439a1d190b847e22ea', '/navigation/019356cd34e773439a1d190b8517d445', '/navigation/019356cd34e773439a1d190b858059c6', '/navigation/019356cd34e773439a1d190b8671441d', '/navigation/019356cd34e773439a1d190b874bd445', '/navigation/019356cd34e773439a1d190b87f252ba', '/navigation/019356cd34e773439a1d190b88bd0adf', '/navigation/019356cd34e773439a1d190b8999d1b3', '/navigation/019356cd34e773439a1d190b8a0249bd', '/navigation/019356cd34e773439a1d190b8a43fed7', '/navigation/019356cd34e773439a1d190b8ac99bb8', '/navigation/019356cd34e773439a1d190b8b0c5601', '/navigation/019356cd34e773439a1d190b8b9f564c', '/navigation/019356cd34e8724dbaeac2563862bb4e', '/navigation/019356cd34e8724dbaeac256393201a0', '/navigation/019356cd34e8724dbaeac25639e064be', '/navigation/019356cd34e8724dbaeac2563a39dd19', '/navigation/019356cd34e8724dbaeac2563a778731', '/navigation/019356cd34e8724dbaeac2563b21af5b', '/navigation/019356cd34e8724dbaeac2563ba676fa', '/navigation/019356cd34e8724dbaeac2563bca015d', '/navigation/019356cd34e8724dbaeac2563c4cda4f', '/navigation/019356cd34e8724dbaeac2563c8cb021', '/navigation/019356cd34e8724dbaeac2563d2393e3', '/navigation/019356cd34e8724dbaeac2563d85ec49', '/navigation/019356cd34e8724dbaeac2563e1e6a9e', '/navigation/019356cd34e8724dbaeac2563e858fe4', '/navigation/019356cd34e8724dbaeac2563f341b35', '/navigation/019356cd34e8724dbaeac2563ff1f5a1', '/navigation/019356cd34e8724dbaeac256408c0353', '/navigation/019356cd34e97265b6509a7866fae4fb', '/navigation/019356cd34e97265b6509a7867048221', '/navigation/019356cd34e97265b6509a786726b495', '/navigation/019356cd34e97265b6509a7867361d61', '/navigation/019356cd34e97265b6509a78673b78b4', '/navigation/019356cd34e97265b6509a78673f0772', '/navigation/019356cd34e97265b6509a7868113511', '/navigation/019356cd34e97265b6509a78685affaa', '/navigation/019356cd34e97265b6509a7868a91a39', '/navigation/019356cd34e97265b6509a78696061d5', '/navigation/019356cd34e97265b6509a786969c0ee', '/navigation/019356cd34e97265b6509a786a1a1886', '/navigation/019356cd34e97265b6509a786ab2a96d', '/navigation/019356cd34e97265b6509a786b0d6082', '/navigation/019356cd34e97265b6509a786b227906', '/navigation/019356cd34e97265b6509a786b40b710', '/navigation/019356cd34e97265b6509a786bea6a5e', '/navigation/019356cd34e97265b6509a786c0057d3', '/navigation/019356cd34ea71f98bf8590ffcaa26e8', '/navigation/019356cd34ea71f98bf8590ffcfe3e8b', '/navigation/019356cd34ea71f98bf8590ffdb10475', '/navigation/019356cd34ea71f98bf8590ffe0b0621', '/navigation/019356cd34ea71f98bf8590ffe7d925f', '/navigation/019356cd34ea71f98bf8590fff4ab6f0', '/navigation/019356cd34ea71f98bf8591000009ed6', '/navigation/019356cd34ea71f98bf85910007f4511', '/navigation/019356cd34ea71f98bf859100117accd', '/navigation/019356cd34ea71f98bf859100203e47e', '/navigation/019356cd34ea71f98bf85910020c8d0f', '/navigation/019356cd34ea71f98bf85910030365f4', '/navigation/019356cd34ea71f98bf85910038007e9', '/navigation/019356cd34ea71f98bf85910046d0ede', '/navigation/019356cd34ea71f98bf8591004900d2c', '/navigation/019356cd34ea71f98bf85910053d8e90', '/navigation/019356cd34ea71f98bf859100615557b', '/navigation/019356cd34ea71f98bf8591006bdb316', '/navigation/019356cd34ea71f98bf859100754358d', '/navigation/019356cd34eb722ea8114de9e757658a', '/navigation/019356cd34eb722ea8114de9e7dd7d22', '/navigation/019356cd34eb722ea8114de9e89d520f', '/navigation/019356cd34eb722ea8114de9ea33bbf6', '/navigation/019356cd34eb722ea8114de9eb183b90', '/navigation/019356cd34eb722ea8114de9eb975ffb', '/navigation/019356cd34eb722ea8114de9ec2af0f8', '/navigation/019356cd34eb722ea8114de9ecd918e1', '/navigation/019356cd34eb722ea8114de9ed7ebee6', '/navigation/019356cd34eb722ea8114de9ee183500', '/navigation/019356cd34eb722ea8114de9eecd80be', '/navigation/019356cd34eb722ea8114de9ef43bf9f', '/navigation/019356cd34eb722ea8114de9efe1ae6f', '/navigation/019356cd34eb722ea8114de9f03a85e4', '/navigation/019356cd34eb722ea8114de9f0ebd8e9', '/navigation/019356cd34eb722ea8114de9f153489c', '/navigation/019356cd34eb722ea8114de9f1ebf969', '/navigation/019356cd34ec73008746cff13d95c4bc', '/navigation/019356cd34ec73008746cff13e60a39c', '/navigation/019356cd34ec73008746cff13e8ff5bd', '/navigation/019356cd34ec73008746cff13eea6814', '/navigation/019356cd34ec73008746cff13f99875b', '/navigation/019356cd34ec73008746cff14002a0e1', '/navigation/019356cd34ec73008746cff140d6f5a2', '/navigation/019356cd34ec73008746cff1412cc566', '/navigation/019356cd34ec73008746cff1415c8db8', '/navigation/019356cd34ec73008746cff142554f82', '/navigation/019356cd34ec73008746cff14259f01e', '/navigation/019356cd34ec73008746cff143073a59', '/navigation/019356cd34ec73008746cff1439392f6', '/navigation/019356cd34ec73008746cff14466cabe', '/navigation/019356cd34ec73008746cff144bc00c9', '/navigation/019356cd34ec73008746cff14576dd9a', '/navigation/019356cd34ec73008746cff1457ac9f2', '/navigation/019356cd34ec73008746cff145a639ba', '/navigation/019356cd34ec73008746cff14624148a', '/navigation/019356cd34ec73008746cff1464c4783', '/navigation/019356cd34ed70eb82a2e4b2b27ecf3f', '/navigation/019356cd34ed70eb82a2e4b2b2d9fbe5', '/navigation/019356cd34ed70eb82a2e4b2b3aee923', '/navigation/019356cd34ed70eb82a2e4b2b45bd8ca', '/navigation/019356cd34ed70eb82a2e4b2b46a1a76', '/navigation/019356cd34ed70eb82a2e4b2b4b6dc98', '/navigation/019356cd34ed70eb82a2e4b2b562f5ab', '/navigation/019356cd34ed70eb82a2e4b2b5d38678', '/navigation/019356cd34ed70eb82a2e4b2b600c9d9', '/navigation/019356cd34ed70eb82a2e4b2b6d9dd20', '/navigation/019356cd34ed70eb82a2e4b2b7a8e031', '/navigation/019356cd34ed70eb82a2e4b2b884530d', '/navigation/019356cd34ed70eb82a2e4b2b8aac96a', '/navigation/019356cd34ed70eb82a2e4b2b92ad1a5', '/navigation/019356cd34ed70eb82a2e4b2b97c95e6', '/navigation/019356cd34ed70eb82a2e4b2ba3c25e1', '/navigation/019356cd34ed70eb82a2e4b2bb07ed06', '/navigation/019356cd34ed70eb82a2e4b2bb6b9c06', '/navigation/019356cd34ed70eb82a2e4b2bc1f5f26', '/navigation/019356cd34ee70fca3407f0ad0b2344b', '/navigation/019356cd34ee70fca3407f0ad1a18fa5', '/navigation/019356cd34ee70fca3407f0ad1f24dcf', '/navigation/019356cd34ee70fca3407f0ad21d9d49', '/navigation/019356cd34ee70fca3407f0ad2796033', '/navigation/019356cd34ee70fca3407f0ad2b3354e', '/navigation/019356cd34ee70fca3407f0ad304a2dc', '/navigation/019356cd34ee70fca3407f0ad3d92429', '/navigation/019356cd34ee70fca3407f0ad47799d6', '/navigation/019356cd34ee70fca3407f0ad48cea16', '/navigation/019356cd34ee70fca3407f0ad56e031b', '/navigation/019356cd34ee70fca3407f0ad5ae23f8', '/navigation/019356cd34ee70fca3407f0ad5fda53c', '/navigation/019356cd34ee70fca3407f0ad66fdfd3', '/navigation/019356cd34ee70fca3407f0ad76c82bb', '/navigation/019356cd34ee70fca3407f0ad7f8cafd', '/navigation/019356cd34ef718e869c3fe488f3ced5', '/navigation/019356cd34ef718e869c3fe48918e3cd', '/navigation/019356cd34ef718e869c3fe489644e47', '/navigation/019356cd34ef718e869c3fe48aaee4e5', '/navigation/019356cd34ef718e869c3fe48c7732ac', '/navigation/019356cd34ef718e869c3fe48cbe21b8', '/navigation/019356cd34ef718e869c3fe490387061', '/navigation/019356cd34f070ae92337a63aad8e50d', '/navigation/019356cd34f070ae92337a63ab7c1c09', '/navigation/019356cd34f070ae92337a63ae2aefd7', '/navigation/019356cd34f070ae92337a63b0f5b5c6', '/navigation/019356cd34f172a18aab09d538832f3a', '/navigation/019356cd34f172a18aab09d53adb3316', '/navigation/019356cd34f172a18aab09d53bc3157f', '/navigation/019356cd34f172a18aab09d53bf05273', '/navigation/019356cd34f172a18aab09d53c4cf45d', '/navigation/019356cd34f172a18aab09d53e538274', '/navigation/019356cd34f172a18aab09d53fcee6cc', '/navigation/019356cd34f27250ba288ee8babe6533', '/navigation/019356cd34f27250ba288ee8bb5d6573', '/navigation/019356cd34f27250ba288ee8bdbc8bac', '/navigation/019356cd34f27250ba288ee8bf103898', '/navigation/019356cd34f27250ba288ee8c118d8e4', '/navigation/019356cd34f27250ba288ee8c1ed004a', '/navigation/019356cd34f37188ac80319cc325d396', '/navigation/019356cd34f37188ac80319cc5833756', '/navigation/019356cd34f37188ac80319cc84572f6', '/navigation/019356cd34f37188ac80319cca876a9b', '/navigation/019356cd34f37188ac80319ccb1faf99', '/navigation/019356cd34f47388a56b28fe9571f443', '/navigation/019356cd34f47388a56b28fe9673b2aa', '/navigation/019356cd34f47388a56b28fe96b91646', '/navigation/019356cd34f47388a56b28fe96ef3eee', '/navigation/019356cd34f47388a56b28fe995a4217', '/navigation/019356cd34f47388a56b28fe9bf4b00e', '/navigation/019356cd34f5712cab2b84ad8d28c4e6', '/navigation/019356cd34f5712cab2b84ad902fb958', '/navigation/019356cd34f5712cab2b84ad932f4651', '/navigation/019356cd34f5712cab2b84ad959beb7f', '/navigation/019356cd34f5712cab2b84ad968ac71d', '/navigation/019356cd34f5712cab2b84ad96d6e90d', '/navigation/019356cd34f673258930bbf2acd48865', '/navigation/019356cd34f673258930bbf2aef334e2', '/navigation/019356cd34f673258930bbf2b18d9c49', '/navigation/019356cd34f673258930bbf2b5f91d2d', '/navigation/019356cd34f77352a4875ec6c526e85b', '/navigation/019356cd34f77352a4875ec6c6042752', '/navigation/019356cd34f77352a4875ec6c799f006', '/navigation/019356cd34f77352a4875ec6cafb939f', '/navigation/019356cd34f77352a4875ec6cc574981', '/navigation/019356cd34f8729e9dc6cb296704165f', '/navigation/019356cd34f8729e9dc6cb2967b6dc24', '/navigation/019356cd34f8729e9dc6cb2968407018', '/navigation/019356cd34f8729e9dc6cb2969b85a35', '/navigation/019356cd34f8729e9dc6cb296a649270', '/navigation/019356cd34f8729e9dc6cb296aa05301', '/navigation/019356cd34f8729e9dc6cb296b92d06d', '/navigation/019356cd34f8729e9dc6cb296c3912a5', '/navigation/019356cd34f8729e9dc6cb296cc91622', '/navigation/019356cd34f8729e9dc6cb296d29114c', '/navigation/019356cd34f8729e9dc6cb296d8223d0', '/navigation/019356cd34f972a2896e51a031be110e', '/navigation/019356cd34f972a2896e51a0327a5691', '/navigation/019356cd34f972a2896e51a0329fc782', '/navigation/019356cd34f972a2896e51a0332c924a', '/navigation/019356cd34f972a2896e51a0335abe83', '/navigation/019356cd34f972a2896e51a0343d76f8', '/navigation/019356cd34f972a2896e51a035060cdb', '/navigation/019356cd34f972a2896e51a0353e8b6e', '/navigation/019356cd34f972a2896e51a035a4c58d', '/navigation/019356cd34f972a2896e51a035c33feb', '/navigation/019356cd34f972a2896e51a035d7de5a', '/navigation/019356cd34f972a2896e51a035e30eb3', '/navigation/019356cd34f972a2896e51a0366d9021', '/navigation/019356cd34f972a2896e51a03677090c', '/navigation/019356cd34f972a2896e51a0370d55fa', '/navigation/019356cd34f972a2896e51a0374c6026', '/navigation/019356cd34f972a2896e51a0377781ec', '/navigation/019356cd34f972a2896e51a03798b39e', '/navigation/019356cd34f972a2896e51a038868ccf', '/navigation/019356cd34fa70dda4aae153cf2ae378', '/navigation/019356cd34fa70dda4aae153cf449e3f', '/navigation/019356cd34fa70dda4aae153cfcf8373', '/navigation/019356cd34fa70dda4aae153d026c7e3', '/navigation/019356cd34fa70dda4aae153d043c599', '/navigation/019356cd34fa70dda4aae153d11fcc62', '/navigation/019356cd34fa70dda4aae153d1c5b7b3', '/navigation/019356cd34fa70dda4aae153d1f93e5b', '/navigation/019356cd34fa70dda4aae153d254fa57', '/navigation/019356cd34fa70dda4aae153d2d116d7', '/navigation/019356cd34fa70dda4aae153d3cb58eb', '/navigation/019356cd34fa70dda4aae153d4126511', '/navigation/019356cd34fa70dda4aae153d5031fde', '/navigation/019356cd34fa70dda4aae153d525fd0f', '/navigation/019356cd34fa70dda4aae153d59200f1', '/navigation/019356cd34fa70dda4aae153d6394e9a', '/navigation/019356cd34fa70dda4aae153d6c2de41', '/navigation/019356cd34fb72f48645437241e2387f', '/navigation/019356cd34fb72f48645437242dbb68b', '/navigation/019356cd34fb72f486454372433bf3f2', '/navigation/019356cd34fb72f48645437243de43f6', '/navigation/019356cd34fb72f48645437244cefeb6', '/navigation/019356cd34fb72f48645437245a4f2d0', '/navigation/019356cd34fb72f4864543724695f7a2', '/navigation/019356cd34fb72f48645437246a7b268', '/navigation/019356cd34fb72f48645437247421437', '/navigation/019356cd34fb72f48645437247bdff83', '/navigation/019356cd34fb72f4864543724834c5b0', '/navigation/019356cd34fb72f48645437248cf32ec', '/navigation/019356cd34fb72f48645437249235692', '/navigation/019356cd34fb72f48645437249d83685', '/navigation/019356cd34fb72f4864543724ab45a0f', '/navigation/019356cd34fb72f4864543724b0fd4ad', '/navigation/019356cd34fb72f4864543724b4d32fe', '/navigation/019356cd34fc73d6ac5ecb19300c6692', '/navigation/019356cd34fc73d6ac5ecb1930898e93', '/navigation/019356cd34fc73d6ac5ecb1932e9c3f8', '/navigation/019356cd34fc73d6ac5ecb1933ea370b', '/navigation/019356cd34fc73d6ac5ecb1934683549', '/navigation/019356cd34fd7047b74d64b14a913daf', '/navigation/019356cd34fd7047b74d64b14bd7031c', '/navigation/019356cd34fd7047b74d64b14d600440', '/navigation/019356cd34fd7047b74d64b14ffd377d', '/navigation/019356cd34fe72669d3f3e7d4f238ba1', '/navigation/019356cd34fe72669d3f3e7d4f64332e', '/navigation/019356cd34fe72669d3f3e7d50b1bbd8', '/navigation/019356cd34fe72669d3f3e7d5310c984', '/navigation/019356cd34fe72669d3f3e7d54b838a5', '/navigation/019356cd34ff730e877fade0a1b0a763', '/navigation/019356cd34ff730e877fade0a1da245b', '/navigation/019356cd34ff730e877fade0a605f9e2', '/navigation/019356cd34ff730e877fade0a802b6cc', '/navigation/019356cd34ff730e877fade0a9924c5e', '/navigation/019356cd34ff730e877fade0aa58b7df', '/navigation/019356cd3500722eb4007c750c55a245', '/navigation/019356cd3500722eb4007c750f7672a7', '/navigation/019356cd3500722eb4007c751090d3b4', '/navigation/019356cd3500722eb4007c75125dc183', '/navigation/019356cd350172f2a6676ba142ab208a', '/navigation/019356cd350172f2a6676ba1436db262', '/navigation/019356cd350172f2a6676ba14397c242', '/navigation/019356cd350172f2a6676ba146c9ef95', '/navigation/019356cd350172f2a6676ba147e6e9d8', '/navigation/019356cd350172f2a6676ba148921dd5', '/navigation/019356cd3502729eb1df8549fd552113', '/navigation/019356cd3502729eb1df854a014874e2', '/navigation/019356cd3502729eb1df854a0241f8af', '/navigation/019356cd3502729eb1df854a038ac1b8', '/navigation/019356cd3503710bb2f0c43a8192385e', '/navigation/019356cd3503710bb2f0c43a82ca2bd7', '/navigation/019356cd3503710bb2f0c43a86a2e547', '/navigation/019356cd3503710bb2f0c43a877d811a', '/navigation/019356cd3503710bb2f0c43a884226f1', '/navigation/019356cd3503710bb2f0c43a88e92412', '/navigation/019356cd3503710bb2f0c43a89069b5e', '/navigation/019356cd3503710bb2f0c43a8950ff55', '/navigation/019356cd3503710bb2f0c43a899083ec', '/navigation/019356cd3503710bb2f0c43a8a886484', '/navigation/019356cd350472cd8cb3f0b648528567', '/navigation/019356cd350472cd8cb3f0b6489d13e1', '/navigation/019356cd350472cd8cb3f0b648dd6ed1', '/navigation/019356cd350472cd8cb3f0b648e6d3b2', '/navigation/019356cd350472cd8cb3f0b6496d7ae3', '/navigation/019356cd350472cd8cb3f0b649f166bd', '/navigation/019356cd350472cd8cb3f0b64a5bf52d', '/navigation/019356cd350472cd8cb3f0b64b1f1407', '/navigation/019356cd350472cd8cb3f0b64bd626c3', '/navigation/019356cd350472cd8cb3f0b64c776d8a', '/navigation/019356cd350472cd8cb3f0b64d117c05', '/navigation/019356cd350472cd8cb3f0b64db12fd0', '/navigation/019356cd350472cd8cb3f0b64e3da480', '/navigation/019356cd350472cd8cb3f0b64e4bd55b', '/navigation/019356cd350472cd8cb3f0b64ea9e1e9', '/navigation/019356cd350472cd8cb3f0b64f2627a7', '/navigation/019356cd350472cd8cb3f0b64ff9a7bb', '/navigation/019356cd350573dcac6766ec8a57c72c', '/navigation/019356cd350573dcac6766ec8b0210e7', '/navigation/019356cd350573dcac6766ec8b579d6e', '/navigation/019356cd350573dcac6766ec8c25ddcd', '/navigation/019356cd350573dcac6766ec8d25ba53', '/navigation/019356cd350573dcac6766ec8df81db2', '/navigation/019356cd350573dcac6766ec8e1846d7', '/navigation/019356cd350573dcac6766ec8ec951ba', '/navigation/019356cd350573dcac6766ec8fc6491a', '/navigation/019356cd350573dcac6766ec9034f07a', '/navigation/019356cd350573dcac6766ec90c524f4', '/navigation/019356cd350573dcac6766ec913fc4bd', '/navigation/019356cd350573dcac6766ec91799ccc', '/navigation/019356cd350573dcac6766ec927bec94', '/navigation/019356cd350573dcac6766ec92e08451', '/navigation/019356cd350573dcac6766ec93bff814', '/navigation/019356cd350573dcac6766ec94839b76', '/navigation/019356cd3506727a9ae54bd718419bd4', '/navigation/019356cd3506727a9ae54bd7189ea5a5', '/navigation/019356cd3506727a9ae54bd7194577bc', '/navigation/019356cd3506727a9ae54bd7195b0d0a', '/navigation/019356cd3506727a9ae54bd71a297bae', '/navigation/019356cd3506727a9ae54bd71abbe4e9', '/navigation/019356cd3506727a9ae54bd71c010524', '/navigation/019356cd3506727a9ae54bd71c427ab0', '/navigation/019356cd3506727a9ae54bd71d15a1f0', '/navigation/019356cd3506727a9ae54bd71da20b4a', '/navigation/019356cd3506727a9ae54bd71dd31237', '/navigation/019356cd3506727a9ae54bd71ecabe04', '/navigation/019356cd3506727a9ae54bd71f37ebc3', '/navigation/019356cd3506727a9ae54bd71ff0b582', '/navigation/019356cd3506727a9ae54bd720937d23', '/navigation/019356cd35077076a29b988d0bc4ec04', '/navigation/019356cd35077076a29b988d0c20bfe5', '/navigation/019356cd35077076a29b988d0c866b75', '/navigation/019356cd35077076a29b988d0cb66b7c', '/navigation/019356cd35077076a29b988d0cdae6ce', '/navigation/019356cd35077076a29b988d0d5d6ac9', '/navigation/019356cd35077076a29b988d0e0e5517', '/navigation/019356cd35077076a29b988d0ec3fd00', '/navigation/019356cd35077076a29b988d0f75142d', '/navigation/019356cd35077076a29b988d0fa87531', '/navigation/019356cd35077076a29b988d11eb50d7', '/navigation/019356cd35087359820b6c9512bfafc5', '/navigation/019356cd35087359820b6c95151ee1ed', '/navigation/019356cd35087359820b6c95176f3ac8', '/navigation/019356cd35087359820b6c951823cb7d', '/navigation/019356cd3509733d8a9e131b6b15d667', '/navigation/019356cd3509733d8a9e131b6cf96af5', '/navigation/019356cd3509733d8a9e131b6e8db4e3', '/navigation/019356cd3509733d8a9e131b6ecf3464', '/navigation/019356cd3509733d8a9e131b6fcc6405', '/navigation/019356cd3509733d8a9e131b71394b65', '/navigation/019356cd350a71729ba49da76ca30239', '/navigation/019356cd350a71729ba49da76f3f149c', '/navigation/019356cd350a71729ba49da77112a090', '/navigation/019356cd350a71729ba49da771a0381f', '/navigation/019356cd350b71ecb3a01056af2ae5cb', '/navigation/019356cd350b71ecb3a01056b088d665', '/navigation/019356cd350b71ecb3a01056b29217d3', '/navigation/019356cd350b71ecb3a01056b4a7968d', '/navigation/019356cd350b71ecb3a01056b58468fb', '/navigation/019356cd350b71ecb3a01056b5ce32ab', '/navigation/019356cd350c738eb2e63e3fcb9e5df8', '/navigation/019356cd350c738eb2e63e3fce47c70f', '/navigation/019356cd350c738eb2e63e3fd064af4e', '/navigation/019356cd350c738eb2e63e3fd09ee799', '/navigation/019356cd350c738eb2e63e3fd26774bb', '/navigation/019356cd350d73dcaa329475b7e2437c', '/navigation/019356cd350d73dcaa329475b8297e63', '/navigation/019356cd350d73dcaa329475b85ac475', '/navigation/019356cd350d73dcaa329475bad7ed12', '/navigation/019356cd350e73b69de6acf64a3ec8af', '/navigation/019356cd350e73b69de6acf64bde0596', '/navigation/019356cd350e73b69de6acf64d6f0c42', '/navigation/019356cd350e73b69de6acf64e5c7988', '/navigation/019356cd350e73b69de6acf651ccae8a', '/navigation/019356cd350f7054b8efd4c2545e9b06', '/navigation/019356cd350f7054b8efd4c258476b75', '/navigation/019356cd350f7054b8efd4c2586371a0', '/navigation/019356cd350f7054b8efd4c25c2c77c7', '/navigation/019356cd351070b3ad7163f25b223cb6', '/navigation/019356cd351070b3ad7163f25bb731da', '/navigation/019356cd351070b3ad7163f25c461a24', '/navigation/019356cd351070b3ad7163f25c5824bf', '/navigation/019356cd351070b3ad7163f25c5da5c4', '/navigation/019356cd351070b3ad7163f25cabd505', '/navigation/019356cd351070b3ad7163f25d0cd6bd', '/navigation/019356cd351070b3ad7163f25d1201be', '/navigation/019356cd351070b3ad7163f25dc9c6a0', '/navigation/019356cd351070b3ad7163f25ea8cacf', '/navigation/019356cd351070b3ad7163f25ed3719d', '/navigation/019356cd351070b3ad7163f25f863d7f', '/navigation/019356cd351172248f6c831fad8dcdfa')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x019356CCE6FE7214A39E0380AA1D35E6 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x019356CCE6FE7214A39E0380AA1D35E6 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'Garden-Shoes-Movies/Garden-Games-Electronics-Computers/Music-Grocery-Sports/Jewelry-Beauty-Automotive' OR seo_path_info = 'Garden-Shoes-Movies/Garden-Games-Electronics-Computers/Music-Grocery-Sports/Jewelry-Beauty-Automotive/'));

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

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

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

# base-context-factory::cash-rounding::search-ids
SELECT
  `currency_country_rounding`.`id`
FROM
  `currency_country_rounding`
WHERE
  (
    `currency_country_rounding`.`currency_id` = ?
    AND `currency_country_rounding`.`country_id` = ?
  )
LIMIT
  1

# base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA AND `currency_country_rounding`.`country_id` = 0x019356CC4EB0707F9D28129D5998D41E) LIMIT 1;

# base-context-factory::sales-channel::read
SELECT
  `sales_channel`.`id` as `sales_channel.id`,
  `sales_channel`.`type_id` as `sales_channel.typeId`,
  `sales_channel`.`language_id` as `sales_channel.languageId`,
  `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`,
  `sales_channel`.`currency_id` as `sales_channel.currencyId`,
  `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`,
  `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`,
  `sales_channel`.`country_id` as `sales_channel.countryId`,
  `sales_channel`.`analytics_id` as `sales_channel.analyticsId`,
  `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`,
  `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`,
  `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`,
  `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`,
  `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`,
  `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`,
  `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`,
  `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`,
  `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`,
  `sales_channel`.`short_name` as `sales_channel.shortName`,
  `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`,
  `sales_channel`.`access_key` as `sales_channel.accessKey`,
  `sales_channel`.`configuration` as `sales_channel.configuration`,
  `sales_channel`.`active` as `sales_channel.active`,
  `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`,
  `sales_channel`.`maintenance` as `sales_channel.maintenance`,
  `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`,
  `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`,
  `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`,
  `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`,
  `sales_channel`.`created_at` as `sales_channel.createdAt`,
  `sales_channel`.`updated_at` as `sales_channel.updatedAt`,
  `sales_channel.currency`.`id` as `sales_channel.currency.id`,
  `sales_channel.currency`.`factor` as `sales_channel.currency.factor`,
  `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`,
  `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`,
  `sales_channel.currency`.`position` as `sales_channel.currency.position`,
  `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`,
  `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`,
  `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`,
  `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`,
  `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`,
  `sales_channel.currency.translation.shortName`,
  `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`,
  `sales_channel.currency.translation.name`,
  `sales_channel.currency.translation.name` as `sales_channel.currency.name`,
  `sales_channel.currency.translation.customFields`,
  `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`,
  `sales_channel.translation.name`,
  `sales_channel.translation.name` as `sales_channel.name`,
  `sales_channel.translation.homeSlotConfig`,
  `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`,
  `sales_channel.translation.homeEnabled`,
  `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`,
  `sales_channel.translation.homeName`,
  `sales_channel.translation.homeName` as `sales_channel.homeName`,
  `sales_channel.translation.homeMetaTitle`,
  `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`,
  `sales_channel.translation.homeMetaDescription`,
  `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`,
  `sales_channel.translation.homeKeywords`,
  `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`,
  `sales_channel.translation.customFields`,
  `sales_channel.translation.customFields` as `sales_channel.customFields`
FROM
  `sales_channel`
  LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel.translation`.`sales_channel_id`,
      `sales_channel.translation`.`name` as `sales_channel.translation.name`,
      `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`,
      `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`,
      `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`,
      `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`,
      `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`,
      `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`,
      `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords`
    FROM
      `sales_channel_translation` `sales_channel.translation`
    WHERE
      `sales_channel.translation`.`language_id` = ?
  ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel.currency.translation`.`currency_id`,
      `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`,
      `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`,
      `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields`
    FROM
      `currency_translation` `sales_channel.currency.translation`
    WHERE
      `sales_channel.currency.translation`.`language_id` = ?
  ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id`
WHERE
  `sales_channel`.`id` IN (?)