Symfony Profiler

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

SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.title`,
  `media.translation.title` as `media.title`,
  `media.translation.alt`,
  `media.translation.alt` as `media.alt`,
  `media.translation.customFields`,
  `media.translation.customFields` as `media.customFields`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.`media_id`,
      `media.translation`.`alt` as `media.translation.alt`,
      `media.translation`.`title` as `media.translation.title`,
      `media.translation`.`custom_fields` as `media.translation.customFields`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.`language_id` = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      (
        `media`.`private` = ?
        OR (
          `media`.`private` = ?
          AND `media.mediaFolder.defaultFolder`.`entity` = ?
        )
      )
    )
  )
  AND (
    `media`.`id` IN (?)
  )

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')))) AND (`media`.`id` IN (0xEA38F3BA91614113BDAC9ED320BD80A6));

# 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/f980792f76a548699ce72db64785c4b0', '/navigation/60a087b157a240e88804140d944d480a', '/navigation/1eb6871fbec846498bfbf2d559c08788', '/navigation/dc0dd4defeb84793824e812bc4e5379b', '/navigation/a02753b5dafd421390f0b5fbf927147d', '/navigation/aadf1c34ea4244cf92f0ca43629f5dba', '/navigation/d564deba485a4081a0b9aea86465585d', '/navigation/d7c7b447f5fb42a29cc92d3c54268b6b', '/navigation/e7fdcf8d92d840debb65cf20d78bfdc2', '/navigation/0e6a1410449b4b71b69b5b3cd080e068', '/navigation/086653f64bff4e82bb28e955415d4f9d', '/navigation/007aaa1ba09f4e0cbed021560575b5d7', '/navigation/205cf11f399a42e2b727cc23590273fc', '/navigation/0677b90b8b854cb69b0d4bc9b40f06a8', '/navigation/dad56e105dc2432fb3c57991cfc4673a', '/navigation/89f3c109a61246bba5a9dca258c76b85', '/navigation/aa52c1c3f72d4befb459b43c2aea932c', '/navigation/3f2d9b9d28af493ea53e786185054b12', '/navigation/b054f6175c77426eb8831fe3e78b0917', '/navigation/957532499ed34a62992b3da5d690baf7', '/navigation/5150041160534a929976d60f2bfec14d', '/navigation/f9c676f21cca4cd295e97442358bde43', '/navigation/50355dc91c744089a69935318d018395', '/navigation/265e16adcf0543419612c007cb1c2276', '/navigation/0c1e06b0e12f4cbf8493bb1d244c3bb6', '/navigation/a243537eb5874318b43eeebc6b897db2', '/navigation/2b8559fdf26e4218a79d082cec98fc0d', '/navigation/32973b3a55a841f4bff99ecbbc703050', '/navigation/641416d9d77e40958844e9dbecf791a4', '/navigation/3ff64cf4ecd64f768fe2ce969c85cdc8', '/navigation/d366e5acde0e4a52a67fd424822fbb6f', '/navigation/e7e62eea7e0d49b18331e78a99aefc6f', '/navigation/72ce7f0630cd4df1a659f6f5aa23df20', '/navigation/6e04612b8a864fd6b000742527a1228f', '/navigation/dfe1d99cee3648a1b0b2ad2c5a989cd2', '/navigation/872b153ec6464684aa847bede8487b0c', '/navigation/ce493d476328449498a731effbe309ff', '/navigation/37e6eea334e048e6acab593fd1afa47b', '/navigation/404ba9ccdb714a749ceb5481bf721979', '/navigation/3e83afb4291e436ea75ce9e5ad92190c', '/navigation/71ba73e081f3486692c939148199ce72', '/navigation/b8b674b57f5748acb43ed1abc817f5a4', '/navigation/aea1d7a1632c4780a978e046a47065a0', '/navigation/e81a37639ecc4d938646a1d29e9ff903', '/navigation/0c9fc826b5804d3185bed83bbad49b8c', '/navigation/5d4e778d12924990831c5a9294e7dd4b', '/navigation/626a7e6d4a054dfaa79d4e6f0228a4f2', '/navigation/7553b56cffcc49e0868e5937531a1fff', '/navigation/1f701ade5c5b4944ae621df8bf33fbf0', '/navigation/695426d0d5b04133a0cae06af8239ef3', '/navigation/8cbf18e43a5c4a84a38a8534e06d16ca', '/navigation/6087f13ebf7d4f428911dc392e5e0a3b', '/navigation/c8df10eedc964fd2b4c477b5ff7d1ad5', '/navigation/a795f29223784a3dbd80d933eeb623be', '/navigation/cbab42ef0fac4a1cb194bcab96b28d70', '/navigation/415f793185894db38c4a1560235f7084', '/navigation/958c6c3efb4d411ea7705da3912c62bf', '/navigation/f68ff6b6e1e84551be6cc6057425197b', '/navigation/e31afaac63f545d5878f1d6931cb119a', '/navigation/5978c58290f1455697c62954b1a858b7', '/navigation/34918787a18a4e2fae8aabe91eb1a94e', '/navigation/68ca6fffd3e248c290909e776cce6a37', '/navigation/4ee3469c535344dfb7a663b214dae486', '/navigation/59ec275210c8401f8da640819dffb4f1', '/navigation/c02ca0c19c994568a0c87f3bf3d9db8f', '/navigation/6b42ddb8f7ff48d790489df1c3df5956', '/navigation/a76f80fb4e394fbdbe8f56120fb006b6', '/navigation/688fe3ed63404ae8a904915d54713154', '/navigation/37a6ecd7262341848f65171d505e08b4', '/navigation/f19a43de9dc3494e86d7f4559c8a7434', '/navigation/8b85dcbfa105474eaac860382d09ccdf', '/navigation/66d6729408c3441794815c000b06f54f', '/navigation/d2cfeb7da4cf4df482f5a6e45b6a421e', '/navigation/10315a355fec4d2a85dd9978e69be1e5', '/navigation/c85ad1346c574674a3aa5176b091ccc4', '/navigation/9dec7e6ee71b461b891e09314e439085', '/navigation/adafac58b18f4d36a71f1d908e58ca8f', '/navigation/d0eaa28524e44dd5ba5d89b910b1175c', '/navigation/17c4199f10854b00b87314c559ea3884', '/navigation/d147586bf15d4d538e96929e4e9dd23c', '/navigation/be06f49c30e74f509c26529bf9afda3c', '/navigation/a20124018cea437eb2f6cef6ca37dd48', '/navigation/63c237e0ae454c2688a65e3d89f6271a', '/navigation/78d31fff86304e2381f132622ebd0cf8', '/navigation/554e56d97365411b87967972c608930e', '/navigation/c45f154feacb4b9c91fe9ad21688bf6d', '/navigation/a6ea6c71ac7f41f5992d18f5fbe3768a', '/navigation/4624eca902e04a259f668b706b556ca6', '/navigation/f57bb6c24b07460d89842b3f02a45431', '/navigation/283a32a8c6e7467b9dca3fcf142d5727', '/navigation/67e39f9c8b184e43b80703e227466929', '/navigation/e9f3ff7eda0d42ab92e89ccc477347b6', '/navigation/1704567aa4064327bceba76de82d72dc', '/navigation/8924cb87872e4831bd9c1f35dfb048a0', '/navigation/79801cb81846413fba9762c3ce992079', '/navigation/b1acd53739ec44f498643588d7c46bf9', '/navigation/c34a04d48bbb4a448f422fcf5fb81092', '/navigation/5569bf68bd16461fb30ee2122051ae25', '/navigation/c77a479e09814c97b8c103249dc62599', '/navigation/fae592f23f694947bbde47611fcef362', '/navigation/24e021f4941146b597d0e8e95a0051a0', '/navigation/3392985f18194d1a86ed972526c29191', '/navigation/37574a813ea5415a95c2da752fde85f7', '/navigation/93c9da9d2b5d46098c0f7eaf7ceaa340', '/navigation/d3d15cc46a784a2dad8544fce5475de6', '/navigation/3c1a6f12d187479794f4e84f194940c7', '/navigation/7607b087ea7d4ba1aa122ebfe30c3435', '/navigation/92e68ab110784d4d919e3941be474a06', '/navigation/5a61efa9b0e548759e5d511a6fd5d6bc', '/navigation/c4c7419c6e884cf49f58acf18c3578b8', '/navigation/bf3577df67a846999c5b1679a66cf571', '/navigation/729e3341a7d946b2ac0b47471f596aa1', '/navigation/2e867ed1e66c41c0985f7710ce3fe42c', '/navigation/cdc2a95b2d1c4fc8ace60d9e67b5d4a8', '/navigation/006a3c5ee39c44f98675df13e0d85305', '/navigation/2bad20a0d1714a668c1bd5ea05309997', '/navigation/e0b6d43b024c48698c89a61ebb152533', '/navigation/897d1699c320438e804536b013ba8e5c', '/navigation/7fe589aff0c549e7b52ef6d937c6ac8a', '/navigation/332445df90cc4860be34e68855494641', '/navigation/a7fa5c576c1d4cb280a346c69a5c5b98', '/navigation/47991d6062f74480ab577dc926a99bc2', '/navigation/9a712d2cd98248f78af3a0a2f10db0f0', '/navigation/eadf1df6b07e446da04393ddab32e061', '/navigation/cd3b85076a734b93b38c5492a7c04a7d', '/navigation/06196fcc50334941844cf7c6be633d79', '/navigation/492baa83ef0745ab8f517e476c3deae8', '/navigation/bba03e002c6b42968e6b36dc426948cd', '/navigation/b2897c3361a24cf39e9000893f3917e2', '/navigation/c893c437d12249ada861b917dff0ae12', '/navigation/919734e80f924a30a5895ed7bd024622', '/navigation/b40c40497f1847d1b07c4c05b729aa34', '/navigation/4e5ba0be418e4484bd167f865e53f8a3', '/navigation/c762994a5eb647a4923660b8b9d2ebf3', '/navigation/87098431f25c40b8a06a245916714e4c', '/navigation/e7878f2249464c4fb71ca0ebfbf1591b', '/navigation/2b4b8e7497c748cda4220ae4c7146fef', '/navigation/82efe5881e40448f83be0479691c192c', '/navigation/c5ff9684a25f44999f56782a3c93a04e', '/navigation/a7f4597b984e4781b0b2d8eb154c623d', '/navigation/9e5191e5e7d3464390aa87b50204eff4', '/navigation/c86aed61aadd454daef9afaad5aa33a2', '/navigation/6d9ea2ee199d4bdb92aabca95d7739a4', '/navigation/b34bc0d795d245338b76149a2f4637e3', '/navigation/77a7d661ebd547e9a031b110cf99f6b0', '/navigation/1879b3dd601c48bead288710d9b4010b', '/navigation/1a76f7c591b94d818296b0ce07c8cead', '/navigation/c2c351788b214e338477a5adc1dfbc76', '/navigation/757cf3d59f4043d5beebc9b34bd8550f', '/navigation/3437ae6eede5477882c273d5bd2ae28e', '/navigation/a6f300eb340d4898a2a39fd357372c03', '/navigation/fe847018e0074424bbbfeed91aa8b94a', '/navigation/b674d5d305914718add3ff97fe7c94ff', '/navigation/eb7e824e8e004cff9f4c17c9b3d76808', '/navigation/c094ca525b9a44859c44fa47ca56a261')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xA074A48791544D3E90CD65633B858510 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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

SELECT
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id IS NULL
  and configuration_key IN (?)

SELECT configuration_value FROM system_config WHERE sales_channel_id IS NULL and configuration_key IN ('core.mailerSettings.emailAgent');

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