Symfony Profiler

# theme-service::load-config::read
SELECT
  `theme`.`id` as `theme.id`,
  `theme`.`technical_name` as `theme.technicalName`,
  `theme`.`name` as `theme.name`,
  `theme`.`author` as `theme.author`,
  `theme`.`preview_media_id` as `theme.previewMediaId`,
  `theme`.`parent_theme_id` as `theme.parentThemeId`,
  `theme`.`theme_json` as `theme.themeJson`,
  `theme`.`base_config` as `theme.baseConfig`,
  `theme`.`config_values` as `theme.configValues`,
  `theme`.`active` as `theme.active`,
  `theme`.`created_at` as `theme.createdAt`,
  `theme`.`updated_at` as `theme.updatedAt`,
  `theme.translation.description`,
  `theme.translation.description` as `theme.description`,
  `theme.translation.labels`,
  `theme.translation.labels` as `theme.labels`,
  `theme.translation.helpTexts`,
  `theme.translation.helpTexts` as `theme.helpTexts`,
  `theme.translation.customFields`,
  `theme.translation.customFields` as `theme.customFields`
FROM
  `theme`
  LEFT JOIN (
    SELECT
      `theme.translation`.`theme_id`,
      `theme.translation`.`description` as `theme.translation.description`,
      `theme.translation`.`labels` as `theme.translation.labels`,
      `theme.translation`.`help_texts` as `theme.translation.helpTexts`,
      `theme.translation`.`custom_fields` as `theme.translation.customFields`
    FROM
      `theme_translation` `theme.translation`
    WHERE
      `theme.translation`.`language_id` = ?
  ) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`

# theme-service::load-config::read
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.description`, `theme.translation.description` as `theme.description`, `theme.translation.labels`, `theme.translation.labels` as `theme.labels`, `theme.translation.helpTexts`, `theme.translation.helpTexts` as `theme.helpTexts`, `theme.translation.customFields`, `theme.translation.customFields` as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`;

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

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule22d0332e813c44b494554f7aefee53d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea3825e1ddabc44008a8519cbff74baf1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee2326772c46b488686e3091c324f2dd8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee32a4a23f6ec463db81a84afa0f75ef3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0342ac06a07a4d54a294adced4b83531.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0bd9d2eb17a945b4b0a6ac61b146ccc8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea3e94d26366f401db810a476aab25dc3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule22d0332e813c44b494554f7aefee53d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea3825e1ddabc44008a8519cbff74baf1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee2326772c46b488686e3091c324f2dd8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee32a4a23f6ec463db81a84afa0f75ef3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0342ac06a07a4d54a294adced4b83531.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0bd9d2eb17a945b4b0a6ac61b146ccc8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea3e94d26366f401db810a476aab25dc3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule22d0332e813c44b494554f7aefee53d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea3825e1ddabc44008a8519cbff74baf1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee2326772c46b488686e3091c324f2dd8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee32a4a23f6ec463db81a84afa0f75ef3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0342ac06a07a4d54a294adced4b83531.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0bd9d2eb17a945b4b0a6ac61b146ccc8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea3e94d26366f401db810a476aab25dc3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule22d0332e813c44b494554f7aefee53d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea3825e1ddabc44008a8519cbff74baf1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee2326772c46b488686e3091c324f2dd8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee32a4a23f6ec463db81a84afa0f75ef3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0342ac06a07a4d54a294adced4b83531.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0bd9d2eb17a945b4b0a6ac61b146ccc8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea3e94d26366f401db810a476aab25dc3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0xD74FFD85A6AE42E780AD3554CC15BCE2 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x00000000000000000000000001724394 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 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 (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  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/00000000000000000000000001724394', '/navigation/00000000000000000000000001724376', '/navigation/00000000000000000000000001724388', '/navigation/00000000000000000000000001724391', '/navigation/00000000000000000000000001724396', '/navigation/00000000000000000000000001994501', '/navigation/00000000000000000000000001994517', '/navigation/00000000000000000000000001994523', '/navigation/00000000000000000000000001724377', '/navigation/00000000000000000000000001724379', '/navigation/00000000000000000000000001724380', '/navigation/00000000000000000000000001724381', '/navigation/00000000000000000000000001724382', '/navigation/00000000000000000000000001724383', '/navigation/00000000000000000000000001724385', '/navigation/00000000000000000000000001724386', '/navigation/00000000000000000000000001724387', '/navigation/00000000000000000000000001774525', '/navigation/00000000000000000000000001957201', '/navigation/00000000000000000000000001985226', '/navigation/00000000000000000000000001994489', '/navigation/00000000000000000000000001994490', '/navigation/00000000000000000000000001994491', '/navigation/00000000000000000000000001994492', '/navigation/00000000000000000000000001994493', '/navigation/00000000000000000000000001994494', '/navigation/00000000000000000000000001994495', '/navigation/00000000000000000000000001994496', '/navigation/00000000000000000000000001994497', '/navigation/00000000000000000000000001994498', '/navigation/00000000000000000000000001994499', '/navigation/00000000000000000000000001994500', '/navigation/00000000000000000000000001724441', '/navigation/00000000000000000000000001845183', '/navigation/00000000000000000000000001995203', '/navigation/00000000000000000000000001995204', '/navigation/00000000000000000000000002078985', '/navigation/00000000000000000000000002078986', '/navigation/00000000000000000000000002078987', '/navigation/00000000000000000000000001994502', '/navigation/00000000000000000000000001994503', '/navigation/00000000000000000000000001994504', '/navigation/00000000000000000000000001994622', '/navigation/00000000000000000000000001994675', '/navigation/00000000000000000000000001994677', '/navigation/00000000000000000000000001994678', '/navigation/00000000000000000000000001994679', '/navigation/00000000000000000000000001994680', '/navigation/00000000000000000000000001994681', '/navigation/00000000000000000000000001994682', '/navigation/00000000000000000000000001994623', '/navigation/00000000000000000000000001994683', '/navigation/00000000000000000000000001994684', '/navigation/00000000000000000000000001994685', '/navigation/00000000000000000000000001994686', '/navigation/00000000000000000000000001994687', '/navigation/00000000000000000000000001994688', '/navigation/00000000000000000000000001994689', '/navigation/00000000000000000000000001994690', '/navigation/00000000000000000000000001994691', '/navigation/00000000000000000000000001994692', '/navigation/00000000000000000000000001994693', '/navigation/00000000000000000000000001994694', '/navigation/00000000000000000000000001994695', '/navigation/00000000000000000000000001994624', '/navigation/00000000000000000000000001994696', '/navigation/00000000000000000000000001994697', '/navigation/00000000000000000000000001994698', '/navigation/00000000000000000000000001994699', '/navigation/00000000000000000000000001994700', '/navigation/00000000000000000000000001994701', '/navigation/00000000000000000000000001994702', '/navigation/00000000000000000000000001994703', '/navigation/00000000000000000000000001994625', '/navigation/00000000000000000000000001994704', '/navigation/00000000000000000000000001994705', '/navigation/00000000000000000000000001994706', '/navigation/00000000000000000000000001994707', '/navigation/00000000000000000000000001994708', '/navigation/00000000000000000000000001994709', '/navigation/00000000000000000000000001994710', '/navigation/00000000000000000000000001994626', '/navigation/00000000000000000000000001994711', '/navigation/00000000000000000000000001994627', '/navigation/00000000000000000000000001994712', '/navigation/00000000000000000000000001994713', '/navigation/00000000000000000000000001994714', '/navigation/00000000000000000000000001994715', '/navigation/00000000000000000000000001994716', '/navigation/00000000000000000000000001994717', '/navigation/00000000000000000000000001994718', '/navigation/00000000000000000000000001994719', '/navigation/00000000000000000000000001994720', '/navigation/00000000000000000000000001994721', '/navigation/00000000000000000000000001994722', '/navigation/00000000000000000000000001994723', '/navigation/00000000000000000000000001994724', '/navigation/00000000000000000000000001994725', '/navigation/00000000000000000000000001994726', '/navigation/00000000000000000000000001994727', '/navigation/00000000000000000000000001994728', '/navigation/00000000000000000000000001994628', '/navigation/00000000000000000000000001994729', '/navigation/00000000000000000000000001994730', '/navigation/00000000000000000000000001994731', '/navigation/00000000000000000000000001994732', '/navigation/00000000000000000000000001994733', '/navigation/00000000000000000000000001994734', '/navigation/00000000000000000000000001994735', '/navigation/00000000000000000000000001994629', '/navigation/00000000000000000000000001994736', '/navigation/00000000000000000000000001994737', '/navigation/00000000000000000000000001994738', '/navigation/00000000000000000000000001994739', '/navigation/00000000000000000000000001994740', '/navigation/00000000000000000000000001994741', '/navigation/00000000000000000000000001995083', '/navigation/00000000000000000000000001994630', '/navigation/00000000000000000000000001994742', '/navigation/00000000000000000000000001994743', '/navigation/00000000000000000000000001994744', '/navigation/00000000000000000000000001994745', '/navigation/00000000000000000000000001994746', '/navigation/00000000000000000000000001994747', '/navigation/00000000000000000000000001994749', '/navigation/00000000000000000000000001994750', '/navigation/00000000000000000000000001994631', '/navigation/00000000000000000000000001994751', '/navigation/00000000000000000000000001994752', '/navigation/00000000000000000000000001994753', '/navigation/00000000000000000000000001994754', '/navigation/00000000000000000000000001994755', '/navigation/00000000000000000000000001994756', '/navigation/00000000000000000000000001994757', '/navigation/00000000000000000000000001994758', '/navigation/00000000000000000000000001994759', '/navigation/00000000000000000000000001994760', '/navigation/00000000000000000000000001994761', '/navigation/00000000000000000000000001994762', '/navigation/00000000000000000000000001994763', '/navigation/00000000000000000000000001994764', '/navigation/00000000000000000000000001994765', '/navigation/00000000000000000000000001994766', '/navigation/00000000000000000000000001994767', '/navigation/00000000000000000000000001994768', '/navigation/00000000000000000000000001994769', '/navigation/00000000000000000000000001994770', '/navigation/00000000000000000000000001994771', '/navigation/00000000000000000000000001994772', '/navigation/00000000000000000000000001994773', '/navigation/00000000000000000000000001994774', '/navigation/00000000000000000000000001994775', '/navigation/00000000000000000000000001994776', '/navigation/00000000000000000000000001994632', '/navigation/00000000000000000000000001994777', '/navigation/00000000000000000000000001994778', '/navigation/00000000000000000000000001994779', '/navigation/00000000000000000000000001994780', '/navigation/00000000000000000000000001994781', '/navigation/00000000000000000000000001994782', '/navigation/00000000000000000000000001994783', '/navigation/00000000000000000000000001994784', '/navigation/00000000000000000000000001994785', '/navigation/00000000000000000000000001994786', '/navigation/00000000000000000000000001994787', '/navigation/00000000000000000000000001994788', '/navigation/00000000000000000000000001994789', '/navigation/00000000000000000000000001994790', '/navigation/00000000000000000000000001994791', '/navigation/00000000000000000000000001994633', '/navigation/00000000000000000000000001994792', '/navigation/00000000000000000000000001994793', '/navigation/00000000000000000000000001994794', '/navigation/00000000000000000000000001994795', '/navigation/00000000000000000000000001994796', '/navigation/00000000000000000000000001994797', '/navigation/00000000000000000000000001994798', '/navigation/00000000000000000000000001994799', '/navigation/00000000000000000000000001994800', '/navigation/00000000000000000000000001994801', '/navigation/00000000000000000000000001994802', '/navigation/00000000000000000000000001994634', '/navigation/00000000000000000000000001994803', '/navigation/00000000000000000000000001994804', '/navigation/00000000000000000000000001994805', '/navigation/00000000000000000000000001994806', '/navigation/00000000000000000000000001994807', '/navigation/00000000000000000000000001994808', '/navigation/00000000000000000000000001994809', '/navigation/00000000000000000000000001994810', '/navigation/00000000000000000000000001994811', '/navigation/00000000000000000000000001994812', '/navigation/00000000000000000000000001994813', '/navigation/00000000000000000000000001994814', '/navigation/00000000000000000000000001994815', '/navigation/00000000000000000000000001994816', '/navigation/00000000000000000000000001994817', '/navigation/00000000000000000000000001994818', '/navigation/00000000000000000000000001994819', '/navigation/00000000000000000000000001994820', '/navigation/00000000000000000000000001994821', '/navigation/00000000000000000000000001994635', '/navigation/00000000000000000000000001994822', '/navigation/00000000000000000000000001994636', '/navigation/00000000000000000000000001994823', '/navigation/00000000000000000000000001994824', '/navigation/00000000000000000000000001994825', '/navigation/00000000000000000000000001994826', '/navigation/00000000000000000000000001994827', '/navigation/00000000000000000000000001994828', '/navigation/00000000000000000000000001994829', '/navigation/00000000000000000000000001994830', '/navigation/00000000000000000000000001994831', '/navigation/00000000000000000000000001994832', '/navigation/00000000000000000000000001994833', '/navigation/00000000000000000000000001995090', '/navigation/00000000000000000000000001994637', '/navigation/00000000000000000000000001994834', '/navigation/00000000000000000000000001994835', '/navigation/00000000000000000000000001994836', '/navigation/00000000000000000000000001994638', '/navigation/00000000000000000000000001994837', '/navigation/00000000000000000000000001994838', '/navigation/00000000000000000000000001994839', '/navigation/00000000000000000000000001994840', '/navigation/00000000000000000000000001994841', '/navigation/00000000000000000000000001994842', '/navigation/00000000000000000000000001994843', '/navigation/00000000000000000000000001994639', '/navigation/00000000000000000000000001994844', '/navigation/00000000000000000000000001994640', '/navigation/00000000000000000000000001994845', '/navigation/00000000000000000000000001994847', '/navigation/00000000000000000000000001994848', '/navigation/00000000000000000000000001994849', '/navigation/00000000000000000000000001994850', '/navigation/00000000000000000000000001994851', '/navigation/00000000000000000000000001994852', '/navigation/00000000000000000000000001994854', '/navigation/00000000000000000000000001994855', '/navigation/00000000000000000000000001994641', '/navigation/00000000000000000000000001994857', '/navigation/00000000000000000000000001994858', '/navigation/00000000000000000000000001994859', '/navigation/00000000000000000000000001994860', '/navigation/00000000000000000000000001994861', '/navigation/00000000000000000000000001994862', '/navigation/00000000000000000000000001994863', '/navigation/00000000000000000000000001994864', '/navigation/00000000000000000000000001994865', '/navigation/00000000000000000000000001994866', '/navigation/00000000000000000000000001994867', '/navigation/00000000000000000000000001994868', '/navigation/00000000000000000000000001994642', '/navigation/00000000000000000000000001994869', '/navigation/00000000000000000000000001994870', '/navigation/00000000000000000000000001994871', '/navigation/00000000000000000000000001994872', '/navigation/00000000000000000000000001994873', '/navigation/00000000000000000000000001994643', '/navigation/00000000000000000000000001994874', '/navigation/00000000000000000000000001994875', '/navigation/00000000000000000000000001994876', '/navigation/00000000000000000000000001994877', '/navigation/00000000000000000000000001994878', '/navigation/00000000000000000000000001994879', '/navigation/00000000000000000000000001994880', '/navigation/00000000000000000000000001994881', '/navigation/00000000000000000000000001994644', '/navigation/00000000000000000000000001994882', '/navigation/00000000000000000000000001994883', '/navigation/00000000000000000000000001994884', '/navigation/00000000000000000000000001994885', '/navigation/00000000000000000000000001994886', '/navigation/00000000000000000000000001994887', '/navigation/00000000000000000000000001994888', '/navigation/00000000000000000000000001994889', '/navigation/00000000000000000000000001994890', '/navigation/00000000000000000000000001994891', '/navigation/00000000000000000000000001994892', '/navigation/00000000000000000000000001994893', '/navigation/00000000000000000000000001994894', '/navigation/00000000000000000000000001994896', '/navigation/00000000000000000000000001994898', '/navigation/00000000000000000000000001994645', '/navigation/00000000000000000000000001994899', '/navigation/00000000000000000000000001994900', '/navigation/00000000000000000000000001994901', '/navigation/00000000000000000000000001994902', '/navigation/00000000000000000000000001994903', '/navigation/00000000000000000000000001994904', '/navigation/00000000000000000000000001994905', '/navigation/00000000000000000000000001994906', '/navigation/00000000000000000000000001994907', '/navigation/00000000000000000000000001994908', '/navigation/00000000000000000000000001994909', '/navigation/00000000000000000000000001994910', '/navigation/00000000000000000000000001994911', '/navigation/00000000000000000000000001994912', '/navigation/00000000000000000000000001994913', '/navigation/00000000000000000000000001994914', '/navigation/00000000000000000000000001995087', '/navigation/00000000000000000000000001994646', '/navigation/00000000000000000000000001994915', '/navigation/00000000000000000000000001994916', '/navigation/00000000000000000000000001994917', '/navigation/00000000000000000000000001994918', '/navigation/00000000000000000000000001994919', '/navigation/00000000000000000000000001994920', '/navigation/00000000000000000000000001994921', '/navigation/00000000000000000000000001994922', '/navigation/00000000000000000000000001994923', '/navigation/00000000000000000000000001994924', '/navigation/00000000000000000000000001994925', '/navigation/00000000000000000000000001994926', '/navigation/00000000000000000000000001994927', '/navigation/00000000000000000000000001994928', '/navigation/00000000000000000000000001994929', '/navigation/00000000000000000000000001994930', '/navigation/00000000000000000000000001994931', '/navigation/00000000000000000000000001994932', '/navigation/00000000000000000000000001994933', '/navigation/00000000000000000000000001994934', '/navigation/00000000000000000000000001994935', '/navigation/00000000000000000000000001994647', '/navigation/00000000000000000000000001994936', '/navigation/00000000000000000000000001994937', '/navigation/00000000000000000000000001994938', '/navigation/00000000000000000000000001994939', '/navigation/00000000000000000000000001994940', '/navigation/00000000000000000000000001994941', '/navigation/00000000000000000000000001994942', '/navigation/00000000000000000000000001994943', '/navigation/00000000000000000000000001994944', '/navigation/00000000000000000000000001994945', '/navigation/00000000000000000000000001994946', '/navigation/00000000000000000000000001994947', '/navigation/00000000000000000000000001994948', '/navigation/00000000000000000000000001994949', '/navigation/00000000000000000000000001994950', '/navigation/00000000000000000000000001994951', '/navigation/00000000000000000000000001994952', '/navigation/00000000000000000000000001994953', '/navigation/00000000000000000000000001995084', '/navigation/00000000000000000000000001995085', '/navigation/00000000000000000000000001994648', '/navigation/00000000000000000000000001994954', '/navigation/00000000000000000000000001994955', '/navigation/00000000000000000000000001994956', '/navigation/00000000000000000000000001994957', '/navigation/00000000000000000000000001994958', '/navigation/00000000000000000000000001994959', '/navigation/00000000000000000000000001994960', '/navigation/00000000000000000000000001994961', '/navigation/00000000000000000000000001994649', '/navigation/00000000000000000000000001994962', '/navigation/00000000000000000000000001994650', '/navigation/00000000000000000000000001994963', '/navigation/00000000000000000000000001994964', '/navigation/00000000000000000000000001994965', '/navigation/00000000000000000000000001994966', '/navigation/00000000000000000000000001994967', '/navigation/00000000000000000000000001994968', '/navigation/00000000000000000000000001994969', '/navigation/00000000000000000000000001994970', '/navigation/00000000000000000000000001994651', '/navigation/00000000000000000000000001994971', '/navigation/00000000000000000000000001994972', '/navigation/00000000000000000000000001994973', '/navigation/00000000000000000000000001994974', '/navigation/00000000000000000000000001994975', '/navigation/00000000000000000000000001994976', '/navigation/00000000000000000000000001994977', '/navigation/00000000000000000000000001994978', '/navigation/00000000000000000000000001994979', '/navigation/00000000000000000000000001994980', '/navigation/00000000000000000000000001994652', '/navigation/00000000000000000000000001994981', '/navigation/00000000000000000000000001994653', '/navigation/00000000000000000000000001994982', '/navigation/00000000000000000000000001994983', '/navigation/00000000000000000000000001994984', '/navigation/00000000000000000000000001994985', '/navigation/00000000000000000000000001994986', '/navigation/00000000000000000000000001994987', '/navigation/00000000000000000000000001994988', '/navigation/00000000000000000000000001994989', '/navigation/00000000000000000000000001994654', '/navigation/00000000000000000000000001994990', '/navigation/00000000000000000000000001994991', '/navigation/00000000000000000000000001994992', '/navigation/00000000000000000000000001994993', '/navigation/00000000000000000000000001994994', '/navigation/00000000000000000000000001994995', '/navigation/00000000000000000000000001994996', '/navigation/00000000000000000000000001994997', '/navigation/00000000000000000000000001994998', '/navigation/00000000000000000000000001994999', '/navigation/00000000000000000000000001995000', '/navigation/00000000000000000000000001995001', '/navigation/00000000000000000000000001995002', '/navigation/00000000000000000000000001994655', '/navigation/00000000000000000000000001995003', '/navigation/00000000000000000000000001995004', '/navigation/00000000000000000000000001995005', '/navigation/00000000000000000000000001995006', '/navigation/00000000000000000000000001995007', '/navigation/00000000000000000000000001995008', '/navigation/00000000000000000000000001995009', '/navigation/00000000000000000000000001995010', '/navigation/00000000000000000000000001995011', '/navigation/00000000000000000000000001995012', '/navigation/00000000000000000000000001995013', '/navigation/00000000000000000000000001995014', '/navigation/00000000000000000000000001995015', '/navigation/00000000000000000000000001995016', '/navigation/00000000000000000000000001995017', '/navigation/00000000000000000000000001995018', '/navigation/00000000000000000000000001995019', '/navigation/00000000000000000000000001994656', '/navigation/00000000000000000000000001995020', '/navigation/00000000000000000000000001995021', '/navigation/00000000000000000000000001995022', '/navigation/00000000000000000000000001995023', '/navigation/00000000000000000000000001995024', '/navigation/00000000000000000000000001995025', '/navigation/00000000000000000000000001995026', '/navigation/00000000000000000000000001995027', '/navigation/00000000000000000000000001995028', '/navigation/00000000000000000000000001995029', '/navigation/00000000000000000000000001995030', '/navigation/00000000000000000000000001995031', '/navigation/00000000000000000000000001995032', '/navigation/00000000000000000000000001994657', '/navigation/00000000000000000000000001995033', '/navigation/00000000000000000000000001995034', '/navigation/00000000000000000000000001995035', '/navigation/00000000000000000000000001995036', '/navigation/00000000000000000000000001995038', '/navigation/00000000000000000000000001995039', '/navigation/00000000000000000000000001995040', '/navigation/00000000000000000000000001995041', '/navigation/00000000000000000000000001995042', '/navigation/00000000000000000000000001995043', '/navigation/00000000000000000000000001995044', '/navigation/00000000000000000000000001995046', '/navigation/00000000000000000000000001995047', '/navigation/00000000000000000000000001995048', '/navigation/00000000000000000000000001995049', '/navigation/00000000000000000000000001995050', '/navigation/00000000000000000000000001995051', '/navigation/00000000000000000000000001995052', '/navigation/00000000000000000000000001995053', '/navigation/00000000000000000000000001995054', '/navigation/00000000000000000000000001995055', '/navigation/00000000000000000000000001994505', '/navigation/00000000000000000000000001994658', '/navigation/00000000000000000000000001995056', '/navigation/00000000000000000000000001994659', '/navigation/00000000000000000000000001995057', '/navigation/00000000000000000000000001994661', '/navigation/00000000000000000000000001995059', '/navigation/00000000000000000000000001994662', '/navigation/00000000000000000000000001995060', '/navigation/00000000000000000000000001994663', '/navigation/00000000000000000000000001995061', '/navigation/00000000000000000000000001994664', '/navigation/00000000000000000000000001995062', '/navigation/00000000000000000000000001994665', '/navigation/00000000000000000000000001995063', '/navigation/00000000000000000000000001994666', '/navigation/00000000000000000000000001995064', '/navigation/00000000000000000000000001994667', '/navigation/00000000000000000000000001995065', '/navigation/00000000000000000000000001994668', '/navigation/00000000000000000000000001995067', '/navigation/00000000000000000000000001994669', '/navigation/00000000000000000000000001995068', '/navigation/00000000000000000000000001994670', '/navigation/00000000000000000000000001995069', '/navigation/00000000000000000000000001994671', '/navigation/00000000000000000000000001995070', '/navigation/00000000000000000000000001994672', '/navigation/00000000000000000000000001995071', '/navigation/00000000000000000000000001994673', '/navigation/00000000000000000000000001995072', '/navigation/00000000000000000000000001995073', '/navigation/00000000000000000000000001995074', '/navigation/00000000000000000000000001995075', '/navigation/00000000000000000000000001994507', '/navigation/00000000000000000000000001994519', '/navigation/00000000000000000000000001995082', '/navigation/00000000000000000000000002094846', '/navigation/00000000000000000000000001946155', '/navigation/00000000000000000000000001994520', '/navigation/00000000000000000000000001958323', '/navigation/00000000000000000000000001994524', '/navigation/00000000000000000000000001994528', '/navigation/00000000000000000000000001994531', '/navigation/00000000000000000000000001994532', '/navigation/00000000000000000000000001994533', '/navigation/00000000000000000000000001994535', '/navigation/00000000000000000000000001994549', '/navigation/00000000000000000000000001994571', '/navigation/00000000000000000000000001999523', '/navigation/00000000000000000000000001994536', '/navigation/00000000000000000000000001994537', '/navigation/00000000000000000000000001994538', '/navigation/00000000000000000000000001994540', '/navigation/00000000000000000000000001994564', '/navigation/00000000000000000000000001994580', '/navigation/00000000000000000000000001994541', '/navigation/00000000000000000000000001994542', '/navigation/00000000000000000000000001994543', '/navigation/00000000000000000000000001994544', '/navigation/00000000000000000000000001994545', '/navigation/00000000000000000000000001994548', '/navigation/00000000000000000000000001994550', '/navigation/00000000000000000000000001994560', '/navigation/00000000000000000000000001994561', '/navigation/00000000000000000000000001994566', '/navigation/00000000000000000000000001994570', '/navigation/00000000000000000000000002000223', '/navigation/00000000000000000000000002009546', '/navigation/00000000000000000000000002092218', '/navigation/00000000000000000000000001743118', '/navigation/00000000000000000000000002098090', '/navigation/00000000000000000000000002098766', '/navigation/00000000000000000000000001994522', '/navigation/00000000000000000000000001994551', '/navigation/00000000000000000000000001994552', '/navigation/00000000000000000000000001994553', '/navigation/00000000000000000000000001994554', '/navigation/00000000000000000000000001994555', '/navigation/00000000000000000000000001994556', '/navigation/00000000000000000000000002000795', '/navigation/00000000000000000000000002094845', '/navigation/00000000000000000000000001994558', '/detail/00000000000000000000000045747260', '/', '/detail/00000000000000000000000045747258', '/detail/00000000000000000000000045749607', '/detail/00000000000000000000000045747255', '/detail/00000000000000000000000045746624', '/detail/00000000000000000000000045749623', '/detail/00000000000000000000000045749627', '/detail/00000000000000000000000045747252', '/detail/00000000000000000000000059228706', '/detail/00000000000000000000000059228707', '/detail/00000000000000000000000045746328', '/detail/00000000000000000000000059228708', '/detail/00000000000000000000000045746434', '/detail/00000000000000000000000045746341', '/detail/00000000000000000000000045746342', '/detail/00000000000000000000000045747270', '/detail/00000000000000000000000045749614', '/detail/00000000000000000000000045746545', '/detail/00000000000000000000000141789830', '/detail/00000000000000000000000045747259', '/detail/00000000000000000000000141790020', '/detail/00000000000000000000000045746403', '/detail/00000000000000000000000045746402', '/detail/00000000000000000000000141790018', '/navigation/5507d613f3974866b64d558b39342451', '/navigation/9174b58ea27e496f8e9cefcba40cac29', '/navigation/f971ef3857fb42e781756fba1e3dce5e', '/navigation/bba541c73fde441ebcdbd07fc306d960', '/navigation/44008bc085fd46559a6a82b1a2cf1a62', '/navigation/11890a5a935040ae99a4c58cb9fcdd0e', '/navigation/f859bda54694455a8d10baaec58c5c32', '/navigation/ceafb9867f584615a48e455a894f6b8b', '/navigation/7c2e93a1706f46c997cdcd112ccff324', '/navigation/b835f06ac4d2422ea289d6215a6f69b1', '/navigation/e7c8778ba9fc4785a8311e2ea1e0f6d8', '/navigation/2e332cfbd1de4b03b7321c1020cc2676', '/navigation/42a07277e07d4278b882f9e47493e602', '/navigation/bc19d167515040b48c34a5cb687011eb', '/navigation/8420453b9e044f66960143f8dd935e55', '/navigation/7e36b655d35d40899bf8a82765b23adb', '/navigation/5de4b279abf74b4eb167e2acc5bfc875')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xD74FFD85A6AE42E780AD3554CC15BCE2 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);