Symfony Profiler

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
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
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          IFNULL(
            `product`.`active`, `product.parent`.`active`
          ) = ?
          AND (`product`.`available_stock` > ?)
          AND (
            IFNULL(
              COALESCE(
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018ebdd989627376a72c231160f964c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b5c5059ff7938ae5a7cef7fbea729.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b6064f6147381a8a5dd450de18fed.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b606601787049af369fd4e1ba25b8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b6066861a731da7533df6cd4c300f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b6669c9537af59f7a0bfc807d94f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule5587d54d389445e5b02656feeb5c1481.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule9b5963c95a30447a9e2549380ef00622.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.ruleb225d19aba744ad58fc04d964667b2c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule3b3f36b4207a4f5db60d2e0dea32b76f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule9b996690a6094dc09b5e9f5fa3dab931.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`,
                                "$.rule018ebdd989627376a72c231160f964c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b5c5059ff7938ae5a7cef7fbea729.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b6064f6147381a8a5dd450de18fed.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b606601787049af369fd4e1ba25b8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b6066861a731da7533df6cd4c300f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b6669c9537af59f7a0bfc807d94f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule5587d54d389445e5b02656feeb5c1481.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule9b5963c95a30447a9e2549380ef00622.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.ruleb225d19aba744ad58fc04d964667b2c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule3b3f36b4207a4f5db60d2e0dea32b76f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule9b996690a6094dc09b5e9f5fa3dab931.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
                )
              )
            ) <= ?
          )
        )
      )
      AND NOT (`product`.`display_group` <=> ?)
      AND (
        NOT (
          `product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        )
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
GROUP BY
  `product`.`display_group`
ORDER BY
  MAX(
    IFNULL(
      `product`.`release_date`, `product.parent`.`release_date`
    )
  ) DESC,
  MAX(`product`.`stock`) DESC
LIMIT
  10

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` 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 WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((IFNULL(`product`.`active`, `product.parent`.`active`) = '1' AND (`product`.`available_stock` > 0) AND (IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018ebdd989627376a72c231160f964c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b5c5059ff7938ae5a7cef7fbea729.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b6064f6147381a8a5dd450de18fed.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b606601787049af369fd4e1ba25b8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b6066861a731da7533df6cd4c300f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b6669c9537af59f7a0bfc807d94f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5587d54d389445e5b02656feeb5c1481.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9b5963c95a30447a9e2549380ef00622.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleb225d19aba744ad58fc04d964667b2c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule3b3f36b4207a4f5db60d2e0dea32b76f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9b996690a6094dc09b5e9f5fa3dab931.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`, "$.rule018ebdd989627376a72c231160f964c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b5c5059ff7938ae5a7cef7fbea729.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b6064f6147381a8a5dd450de18fed.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b606601787049af369fd4e1ba25b8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b6066861a731da7533df6cd4c300f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b6669c9537af59f7a0bfc807d94f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5587d54d389445e5b02656feeb5c1481.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9b5963c95a30447a9e2549380ef00622.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleb225d19aba744ad58fc04d964667b2c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule3b3f36b4207a4f5db60d2e0dea32b76f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9b996690a6094dc09b5e9f5fa3dab931.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))) <= 25))) AND NOT (`product`.`display_group` <=> NULL) AND (NOT (`product`.`id` IN ('\0\0\0\0\0\0\0\0\0\0\0\0\0DQq', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQr', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQs', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQt', '\0\0\0\0\0\0\0\0\0\0\0\0\0DWH', '\0\0\0\0\0\0\0\0\0\0\0\0\0DWI', '\0\0\0\0\0\0\0\0\0\0\0\0\0E
', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eyd', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eye', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eyf'))) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0xCBE4B790714146C0A159D4671C8B61B7 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) GROUP BY `product`.`display_group` ORDER BY MAX(IFNULL(`product`.`release_date`, `product.parent`.`release_date`)) DESC, MAX(`product`.`stock`) DESC LIMIT 10;

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
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
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      `product`.`parent_id` = ?
      AND `product`.`available` = ?
      AND JSON_CONTAINS(
        IFNULL(
          `product`.`option_ids`, `product.parent`.`option_ids`
        ),
        JSON_ARRAY(?)
      )
      AND (
        NOT (
          `product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        )
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
LIMIT
  1

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` 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 WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` = 0x00000000000000000000000006000299 AND `product`.`available` = 1 AND JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('9f064d62cfd20bc4bfe5415e702eefff')) AND (NOT (`product`.`id` IN ('\0\0\0\0\0\0\0\0\0\0\0\0\0DQq', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQr', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQs', '\0\0\0\0\0\0\0\0\0\0\0\0\0DQt', '\0\0\0\0\0\0\0\0\0\0\0\0\0DWH', '\0\0\0\0\0\0\0\0\0\0\0\0\0DWI', '\0\0\0\0\0\0\0\0\0\0\0\0\0E
', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0E', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eyd', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eye', '\0\0\0\0\0\0\0\0\0\0\0\0\0Eyf'))) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0xCBE4B790714146C0A159D4671C8B61B7 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) LIMIT 1;

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/detail/00000000000000000000000000239436', '/navigation/7f6bf9ab7d154cf39eb6650a12f75735', '/navigation/813a4306acaa489bae3fd5537b106a1f', '/navigation/018ba941e20e7f81a46c85d623719396', '/navigation/018ad6f6d6cb7849be5b5aba84f3ebad', '/navigation/c6c6e0c9134b424b8a333918172b47e2', '/navigation/58d8de39ee0c4312935813c3367f0073', '/navigation/3267d01b0ceb48bab9a01a4e2840b2b9', '/navigation/01aa825e598448b1b56c79f55eda3d44', '/navigation/018c81f361427c64b5c41db0f1518861', '/navigation/03e7a0a48adb4d35b058d85269642e0b', '/navigation/d44e5f9a332744a5be86a34a3c4bff85', '/navigation/018b6578d50571feb4c8415ce7473599', '/navigation/018b65792dac754fbddb8c8e6a93477d', '/navigation/018b65797a867c6280a196218b6c2619', '/navigation/018b6579ccc6788698727fbf9a549217', '/navigation/018b657a315473c88f68fd437b54761e', '/navigation/018b657a9256718b9d899d1c6cbe84d0', '/navigation/018b657adf9679ee886de67e3e280cf3', '/navigation/018b657b2ba979239b6c4ec1ec000291', '/navigation/018b657b66e57957aa53ee4b892093d3', '/navigation/018b657ba4b77adb8ad5d4f03a48a09d', '/navigation/018b657c152a7bbda6ba78c77ff76d95', '/navigation/018b657c4d7d7877ab155b0bc51f39d0', '/navigation/018b60f870957b92b40d0f9579ab3e9c', '/navigation/018b60f89e537fdcb37d31ba2a26ef99', '/navigation/018b60f8aa3b7dceaa171e5169de12c0', '/navigation/018b60f8ba9f7fb381d177b70f1185ea', '/navigation/018b60f8c4c578b18d98bde1c8fa495f', '/navigation/018b60f9039772039c667f57153ad020', '/navigation/018b60f90d777aa69a5f1cf98447c2e6', '/navigation/018b60f922b07cb0987390bbbd40a7e3', '/navigation/018b60f94e4a73c0b267b8890b98e98b', '/navigation/018b60f95aae71a8ad10fca2c8d606ff', '/navigation/018b60f9788e7bc19d2264e9b9597d9f', '/navigation/018b60f983e07123872e148454c6ef70', '/navigation/018b60f9b3277df4a777fc5f32f1c9a2', '/navigation/3d88a77c7f8e4979b96ff5d865930367', '/navigation/1f86070d43fdb745d547397b567a707b', '/navigation/2101d27d729547572a22639e29dcf404', '/navigation/018b65d7e716705f8edaea9524b0e789', '/navigation/018b38db8a7e7a90b52587f7162b44ab', '/navigation/018b3c52d049742db50d2afd46d13421', '/navigation/018b658c23697aa1bbfdf15a1d855901', '/navigation/018b658c765379e78468e6fc9216f522', '/navigation/018b658ca64e7a2085d6914f152d7880', '/navigation/018b658f60937c6aabafa49cc6d860dc', '/navigation/018b658fcf0f7029b1f15436f3d0459b', '/navigation/018b659014ce7f24b75306f64bc4d842', '/navigation/018b65906fba76dfafc21fafb5dd89f4', '/navigation/018b6590bcba7bf9b00b19881397b7b6', '/navigation/018b659cf47e7d63bcd147560c4f9abc', '/navigation/018b659d49057acc8d9ff5e09ca31000', '/navigation/018b659d91347dbfbac399282b0951bf', '/navigation/018b659dc1af7ebf9f04b36180216c17', '/navigation/018b659e5c8f7af7b5d4e8b70e99b262', '/navigation/018b659f0f0d7fc9b9e5a64294be1f23', '/navigation/018b611f1b427a4bbee38a4d3d9ebdd4', '/navigation/018b611f8c007f199dccfa96b4cdc124', '/navigation/018b611fb9387da0843c5b0082550684', '/navigation/018b612042b17aff95bc7c193e46ef19', '/navigation/018b612062757d0f8b565e859f0f8389', '/navigation/018b61206bd37f3d92ca3231e4ea9035', '/navigation/018b6120a1557b8a98f41cc1b0e59dd3', '/navigation/018b6120b9fc7465ac237a0bde60cec8', '/navigation/018b6120d7b17c7887eceeed8bc02b7c', '/navigation/018b6120ec407a4bae8b525caba851cb', '/navigation/018b61211ab278cb9e45d8033e193d37', '/navigation/018b6121447b7f76a61e209232f50c30', '/navigation/018b612167da79fd9c4d89ad0d192207', '/navigation/de22c64f0d864ac5968c8c09654fda3a', '/navigation/3b3f8c5b8a7667d2d4a4b47a20e6b0ef', '/navigation/9ecde1849eb81e786f6eeda89408645f', '/navigation/35509e0578451796afb1ee1f42567bcc', '/navigation/ce009ed82bf0545d437f250fece3ff17', '/navigation/351a81969f8dfb677cace1a8e425a164', '/navigation/018b60fffb80722f8fceee7bd0671fa7', '/navigation/018b61002104740db1a921de80027fb7', '/navigation/018bf1b2f9d37fb0ae5bc51bab4d7ef2', '/navigation/018bf1b7524372649f943f66f89fbdfc', '/navigation/018bf1b763577de6adeb9f6107f0468f', '/navigation/018bf1b776e77b7caee865c559500257', '/navigation/018bf1b3383e71cea4ed3a7cf9b2d6a7', '/navigation/018bf1b6401573c6ad842be3449fc975', '/navigation/019270d3b8fe7107830a0faa0ba27995', '/navigation/018d5ef295fe711c97d63d35abab4d3e', '/navigation/018d5ef96509792ebaf6dd8add0557d6', '/navigation/018d5f47341077aab03b83ef8a169237', '/navigation/018d5f4abb627f55a92db0bbb723b80d', '/navigation/018d5f4efb8b744597cf8123a477562f', '/navigation/0192fd08592f7a03accf896dc056e1d6', '/navigation/018d5f5f2b3a7c79a62d3043b93943c1', '/navigation/018d5f6e228e7972943958ddc1e7db2b', '/navigation/018d5fab76a67bbb9f35c5c5b67518ae', '/navigation/018d5fbe1f1f7898a075468b41fca5cd', '/navigation/018d5fcb9024708a8d52bbed6af98d9a', '/navigation/018d5fce1ed87183a8e3954fed5215c9', '/navigation/018d5fd6a63d7cb2bb11c1d041f07d0c', '/navigation/018d5fe0611573b493415cb91ce5d267', '/navigation/018d5fe6791a7ce09e017035aca67c2d', '/navigation/018d6016194470e4afc053c92e6777f6', '/navigation/018d601aceac7ad1a438fdf9c8ab255a', '/navigation/018d60371669786aa62236baedde4838', '/navigation/018d603d35db71048c070d295fdd61d6', '/navigation/0192763923e177d09804b78444bd8d9f', '/navigation/018d63a30c137660af199937a8bf9d20', '/navigation/018e31cc70357de78445d0235977f60f', '/navigation/018d63afbd437fa488e78ff28a475fd3', '/navigation/1ebe7340b01c403080ed86ac2bbca3ba', '/navigation/019135dc7f327c4d9d26a88e62916ce6', '/navigation/018d63bab5f078a5bd65ccd539ea0f99', '/navigation/018d63d2f76770ab81440b75229238b7', '/navigation/018d63e2a84972c7b18e297337148e2f', '/navigation/018d644e7f1e7cd8ae783c55c9a14b6c', '/navigation/018d6477e70b7987b2b488faae7ad6c7', '/navigation/018d6479e96f7a5d9d065a2af3740430', '/navigation/018d6491fea07065b4cad7f92e1978b2', '/navigation/018d64ae0754714a8db7283870aa058e', '/navigation/018d64f62ba07df581e436a64fe24f84', '/navigation/018d64fa53e470f59621dd4c0688b556', '/navigation/018d65005d907595af80e3e17b063fdf', '/navigation/018d687a5ed27fc9a3ec9b74379e3187', '/navigation/018d6881b5e57b2aa3dfd0d16f224514', '/navigation/018d68b446bb755b961b382b07254e67', '/navigation/018d68bf62f2797ba0d5fb8c67407d4b', '/navigation/018d68cb2107709b97382f70144bb1ab', '/navigation/018d68d03c3d705caeb2b54ed7762e0a', '/navigation/018d68f70626747b88a53664bab95913', '/navigation/018d69023ea4705e932628f1efbaa736', '/navigation/018d77f2433b770093f01f26ec0649e9', '/navigation/018d780e7a2b711a828c37603daf615b', '/navigation/018d781d52a177408ee4f5f848ad9503', '/navigation/018d78228d5d798e96739b3595f01ae3', '/navigation/018d78c6743b74d194d34890424857f9', '/navigation/018d78ccb26d7e2b870e751a5f916440', '/navigation/018d78d1b6cb771e9da8a826cfe3da65', '/navigation/018d78dac3e67039ba5f806be6e4c2ff', '/navigation/018d78f124b3749db8e884bf4ff900fc', '/navigation/018d790278b87fe1929a25d24509e354', '/navigation/018d790a951f761cb137513b77b5ad82', '/navigation/018d7940181177b8ae106f355be2daa9', '/navigation/018d7d16e5357ec19375551d1600649c', '/navigation/018d7d1f49b9771e90b61d0088ddb138', '/navigation/018d7d5fb3c171a887fab630a64119d6', '/navigation/018d7d65f2b37d729200c225f435fea1', '/navigation/018d824d869c7ea2956dcf5ed151e38c', '/navigation/018d8274fc2b7bd1a873ca40dc2b59e2', '/navigation/018d9c8d0d2a7f2fabf9dbd147f8f531', '/navigation/018d9c98249b7644bf1cc145f34c54f5', '/navigation/018d9cbe3eee772e8b2e25bf860ea2ad', '/navigation/018d9cc8eac170cd973f23d04e5c5cb6', '/navigation/018d9cd02ce377269d4e64f230302762', '/navigation/018d9cd6b4bf7cb9a00b148d8f451a6a', '/navigation/018d9cfc70c070759a41f6ff4c62f8e0', '/navigation/018d5eed6b59747383d3a7119a2ad670', '/navigation/018d9d00336b73c0b13aa846739771eb', '/navigation/018d9d0fcd8d710d8c9a811812142892', '/navigation/018d9d18a6237e9e9c32df807414e02f', '/navigation/018d9d2033cd7c098b045d3b32fcd287', '/navigation/018d9d261f187e37a9b7e29ab2ccc801', '/navigation/018d9d2c7b4d77a680b16ca1f76f413b', '/navigation/018d9d32a6937190b971ad32c5316474', '/navigation/018d9d3728f375df9d1c1f3b31527050', '/navigation/018d9d4311b37752ba0993f84bc737fb', '/navigation/018d9d46f8477e289eabf78865cc6f48', '/navigation/018d9d78d8a67b6aad6ac3ecd14b244b', '/navigation/018d9d894a03732ab85468e8b823ff25', '/navigation/018d9d8c63507d069fab177d43db7c83', '/navigation/018d9d91352b741ea8458ed9f6596840', '/navigation/018d9d944ba17f378ce2ea12bf2a1328', '/navigation/018d9da5b2e074f494e1ac9b1e6bbd58', '/navigation/018d9da6a31f7c149973b9ec9ab99018', '/navigation/018da1397cf47a84876293daf3aa8f16', '/navigation/018da14776197a88885d3a092e4aaa6d', '/navigation/018da1550d9779a9b388cbcaf2715911', '/navigation/018da19af0aa7224bbad6a4f7f82c717', '/navigation/018da1ad4d517a76a6e8c30188d84924', '/navigation/018da1b534997086951fd307461964e4', '/navigation/018da1b896a5728194c844c885ee1c4e', '/navigation/018da1cfc0417dab829038013e91aa8d', '/navigation/018da1f433e377f88b24e38d54c0694f', '/navigation/018da1fb929b78c880c6032dfc4455d4', '/navigation/018da200a75e74f788f230856ea980dc', '/navigation/018dc12fbcb17a4c8fd3cb2710822288', '/navigation/018da21136957c35adcf5857ba750441', '/navigation/018da22115907734acf979bc6c85d10e', '/navigation/0192fd0080fa7d1b8b9aaf2e09cee875', '/navigation/018da231106f7e979510c5d63594485c', '/navigation/018da27b491c7c7a962895862a5dfd3d', '/navigation/018da281d54d72bc82022865fe214cb6', '/navigation/018da29376d4732993dfad4c140a2d95', '/navigation/018d55dbfd217ae4b6ade46f04b4130f', '/navigation/018da2c63e6e7785b08796a4318a5a74', '/navigation/018da2d1447b71d1977710b012c4bc19', '/navigation/018da2d6a27d742ea196b2596f58577c', '/navigation/018da66107117d688aee87d48da0b14b', '/navigation/0191120f09c9790d9c05b2be9b750ba7', '/navigation/018fe2b5380977cf8613ef8b086a5dcb', '/navigation/018da688cb2e76cc9b41ae391a6ea126', '/navigation/018dc720538671c385d8eebb42b89365', '/navigation/018da6acb1f370c4a679ba9ab8298e6f', '/navigation/018da6b7949f77cd85b6d0783126e5c8', '/navigation/018da6c1045372e28cd62435793a371c', '/navigation/018e31d0ef9778e4a2b8d41b9b4a22b6', '/navigation/018da6ce7e4670df8846407d398d9f27', '/navigation/018da6db563671ee8bec1f71b917089c', '/navigation/018da6e90a987518808690a6bd2e3ec5', '/navigation/0194fe868d557ca18ab51167cf5e2852', '/navigation/018da6ec23e0722aba80ffd2cca7f9c2', '/navigation/018da6f18dbe7e79a524778579779110', '/navigation/018da6fb735677d385178cf6bedce107', '/navigation/018da704fb167b5cb64b8a9dac926aea', '/navigation/018da70bbfa57153b4d48108cc989690', '/navigation/018da71f82fd765c83587631c5149724', '/navigation/018da727997b78d588883738cb022cab', '/navigation/018da73300827adcb469761c76fb2726', '/navigation/018da737cfe679cb917c79b9a02e3464', '/navigation/018dc12fd70077fe9698dbe5c4641b8b', '/navigation/018da743f4f37b748f41fb362b618331', '/navigation/01901065cb4c743196784527b5df9acc', '/navigation/018da74aea8c762db882e37adab1cdfc', '/navigation/018da7766d177762ac59f9e3580e49df', '/navigation/018da77958087c35b03a63a1f3bf3909', '/navigation/018da7b0ceae706693d2e25a95d5f219', '/navigation/018da7b5e4807c718faa96570f858d4e', '/navigation/018da7b9b55a75e3b342dc9bb82c7361', '/navigation/018da7ca70097a88ba3b6160bc37fba3', '/navigation/018da7d2181e7114b19c05094fec124b', '/navigation/018da7d90c3e7fd99865deb5b317aa09', '/navigation/0192fd0b0a897266ad83fafa4c2ba398', '/navigation/018da7df6f917ba5a525ca98b37b5cad', '/navigation/0190bba8e511734d93cbf6ead21cddbe', '/navigation/018da7ecaef47391b786fc665c29b7ff', '/navigation/018dab64407070dca7429351c28181d7', '/navigation/018dab7be5d275b9badb148b25a1a673', '/navigation/018dab92c526772baf2384f607fd4460', '/navigation/018dabaaed6b70c3abd97d51d3f4fef3', '/navigation/018dabf040e972b198f9a0b4df6f15bd', '/navigation/018dac03dd107099a1e6037b5633aec6', '/navigation/018dacd88eee762699872c719f0f2a10', '/navigation/018dad1789b879d59c49b7bc14237ada', '/navigation/018db0b8074676148eb7738cd111a8f4', '/navigation/0195132fbc4778f4b5248a66abaf6041', '/navigation/018db0c28f6b7ec1a87b10b7cbfcfee4', '/navigation/018db0d0e4d573c6b187f2c7d709c6d9', '/navigation/019135dd17337f4a994c934551e0634a', '/navigation/018db0d717ab7d25b0fcb267db8eee0d', '/navigation/018db10bb88a74c8bbefe1c39147a9e6', '/navigation/018db1203cfe7f81bf1ca307309e04ed', '/navigation/018db13b289d7445b8989baa813e622b', '/navigation/018db1410a207fa8a02bbbcd410da1eb', '/navigation/018db1439be97d57b00542c2529d636b', '/navigation/018dcfd7e980710c92460521d5796a9b', '/navigation/018db150d8df75dbb315191375f1bf2b', '/navigation/018db15701617573a22734dc037a368c', '/navigation/018db15b25107bc481d4023c43388a80', '/navigation/018db15ce29270ec926e725ded615c73', '/navigation/018db162ec447db697fbb0faad2a237a', '/navigation/018db1685b3d7023be2fe7b47534b351', '/navigation/018db174205d7187905e9315e4374051', '/navigation/018db1763ff2797f87ef4c7599c509c7', '/navigation/018db182223c738ba486910ac60e3cde', '/navigation/018db1881ded74b2a156e6f3920d011c', '/navigation/018db18d28a270a897585e77d7066f58', '/navigation/018db192f1cb7f018f15393da4911963', '/navigation/018db19786d370dbbe5d8dd667f8f816', '/navigation/018db1aa22ff715f9e47484c2a190d77', '/navigation/018db1fa32fa7e82abb966386ce25dce', '/navigation/018db22865117ce48faf6f48c67871ce', '/navigation/018db20a3e7b7fe083f6498f88186bcb', '/navigation/018db232c5ba72c6861e23214d15ee11', '/navigation/018db234db7279b693680cca4c3717b9', '/navigation/018db23a676b71cf9ed53a26141b094b', '/navigation/018db23cb17d75279ec833f2a3534656', '/navigation/0191120e54897eba8a4a4aed39a1ab31', '/navigation/01951372ad8873e9b7d3a9e597f4e482', '/navigation/018db245c4c87cf784d26b36dd8c06db', '/navigation/018dc0145b6b7e1f85af351866cedda8', '/navigation/018dc033457e78b8aa840c66eeab6ff4', '/navigation/018dc039215977d4ab0a301675ffb39d', '/navigation/018dc03cf4a1770b8e41a27576c5013e', '/navigation/018dc04303287f9cb3c917d2aa097958', '/navigation/018dc05b099f768484753da7f226f7e3', '/navigation/018dc05fe1a5791caebdf22d918f4cbf', '/navigation/018e31f948b67db9b793759ea7a21d50', '/navigation/018dc068674a7c12810530313e4dc3ed', '/navigation/018dc07b165871f1b1a9ae0aa43928f1', '/navigation/018dc08204917be4aea06f8b2f693da3', '/navigation/018dc08ab9107e25943bb9a2fb0971a7', '/navigation/018dc098d7737ea5927a840b4b54e060', '/navigation/018dc0ac6b35789594f9758947c7d0f1', '/navigation/018dc0b7c3eb761b8a7d2c0d793f071b', '/navigation/018dc0cc542c7f5d81beb1db925d7f16', '/navigation/018dc11fa9e97d6c8554dc51f09279a8', '/navigation/018dc12596827d9a9cf4bfa9438bf554', '/navigation/018dc15c3c38753384f6fbfb3c1c4fd6', '/navigation/018dc16474a17a22a7838034b3a4b25d', '/navigation/018dc1912c96705793c90dce1a41cdf1', '/navigation/018dc1a050e9719c9257b11d9d2f5506', '/navigation/018dc1ae905b74aca7284111dc1475d9', '/navigation/018dc1b898b972428977605a54e1bc77', '/navigation/018dc1c655d77af1981fbdf8e791c637', '/navigation/018dc1cb68837797b04e764501248722', '/navigation/018dc1cb89c17846b2a50be414f30dcc', '/navigation/018dc1cba7827ff2915eb98dc40e351e', '/navigation/019228355d987c40a7f7704750b2eb4f', '/navigation/018dc1cbc7617dce949e2b6744edf1f2', '/navigation/0192488469ac71f98b45e4eeee36c799', '/navigation/018e31c8de7a797396efc1e50646f41f', '/navigation/018dc1cbd89579f4a268c3182259339b', '/navigation/018dc1cbf09d7cf1895eecae98686634', '/navigation/018dc1cc1ba175b095bfbff7a0efc9ab', '/navigation/018dc1cc3d55720b8188775560c67482', '/navigation/018dc1cc506a75abb4a68eeabbf75769', '/navigation/0191120d8af97a8890dcc74272a70566', '/navigation/018dc1cc66c974bd8766c618fcbadc86', '/navigation/018dc1cc854a773395329e12d97c598e', '/navigation/018dc1cc9e707508bb293946ae038fe7', '/navigation/018dc1ccb5c774a49796887d6dca10e2', '/navigation/018dc1ccc3d273889bc80ce25d3530ef', '/navigation/018dc1ccd5527cbe92a516086db9eb22', '/navigation/018dc1ccefec7733862ac5cb72a13775', '/navigation/018dc1cd06b07f91857fa26a84f6d884', '/navigation/0190cb07618a76c99a02f4a03c115a90', '/account/recover', '/detail/00000000000000000000000000237745', '/detail/00000000000000000000000000446259', '/detail/00000000000000000000000000446260', '/detail/00000000000000000000000000291383', '/detail/00000000000000000000000000291680', '/detail/00000000000000000000000000446254', '/detail/00000000000000000000000000446255', '/detail/00000000000000000000000000446256', '/detail/00000000000000000000000000321393', '/detail/00000000000000000000000000446252', '/detail/00000000000000000000000000446251', '/detail/00000000000000000000000000446253', '/detail/00000000000000000000000000321857', '/detail/00000000000000000000000000446258', '/detail/00000000000000000000000000446257', '/detail/00000000000000000000000000425883', '/detail/00000000000000000000000000446131', '/detail/00000000000000000000000000446132', '/detail/00000000000000000000000000446133', '/detail/00000000000000000000000000446134', '/detail/00000000000000000000000000446120', '/detail/00000000000000000000000000446121', '/detail/00000000000000000000000000446122', '/detail/00000000000000000000000000446123', '/detail/00000000000000000000000000446109', '/detail/00000000000000000000000000446110', '/detail/00000000000000000000000000446111', '/detail/00000000000000000000000000446112', '/detail/00000000000000000000000000293145', '/detail/00000000000000000000000000293147', '/detail/00000000000000000000000000293146', '/detail/018cf8ee83b07a629eb2b871f238fcee', '/detail/018cf8f213e173659ba32b4580e91120', '/navigation/f58651656190420fb57acac118244896', '/navigation/586a1fc3acb249bbbffa020c9b748bd1', '/navigation/b24d268302304576bc477a47694ec283', '/navigation/0e43a0d3bce84baab8bd6c763070c020', '/navigation/3ceb3b794fcc4e0786b2a8c1419de4d5', '/navigation/e03190eaf20e44d6897ec7f3ee8ba2b4', '/navigation/b4296e37e7134d8495c95b1fc2b9ac5f', '/navigation/02fff446344a47fe9699c7415c605060', '/navigation/9440bcd9688d4eaea084c663223bebc0', '/navigation/571e752085504ec6aa03c6727aec03de')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xCBE4B790714146C0A159D4671C8B61B7 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# 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`,
  COALESCE(
    `category.media.translation.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `category.media.translation.createdAt`,
  `category.media.translation.updatedAt`,
  `category.media.translation.mediaId`,
  `category.media.translation.languageId`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name as `category.translation.name`,
      `category.translation`.breadcrumb as `category.translation.breadcrumb`,
      `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`,
      `category.translation`.custom_fields as `category.translation.customFields`,
      `category.translation`.created_at as `category.translation.createdAt`,
      `category.translation`.updated_at as `category.translation.updatedAt`,
      `category.translation`.category_id as `category.translation.categoryId`,
      `category.translation`.language_id as `category.translation.languageId`,
      `category.translation`.category_version_id as `category.translation.categoryVersionId`
    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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.media_id,
      `category.media.translation`.title as `category.media.translation.title`,
      `category.media.translation`.alt as `category.media.translation.alt`,
      `category.media.translation`.custom_fields as `category.media.translation.customFields`,
      `category.media.translation`.created_at as `category.media.translation.createdAt`,
      `category.media.translation`.updated_at as `category.media.translation.updatedAt`,
      `category.media.translation`.media_id as `category.media.translation.mediaId`,
      `category.media.translation`.language_id as `category.media.translation.languageId`
    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` <= ?
      )
    )
  )