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
  LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`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(`product`.`stock`) DESC,
  MAX(`product.unit`.`id`) 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 LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`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(`product`.`stock`) DESC, MAX(`product.unit`.`id`) DESC LIMIT 10;

SELECT

  /*product.product_number, 
                     rule.name, 
                     rule.priority, 
                     price.price,*/
  rule.id AS rule_id,
  price.quantity_start,
  price.quantity_end
FROM
  product_price price
  LEFT JOIN product ON product.id = price.product_id
  LEFT JOIN rule ON rule.id = price.rule_id
WHERE
  (
    price.product_id = ?
    OR product.parent_id = ?
  )
  AND price.rule_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  price.quantity_start,
  price.quantity_end
ORDER BY
  rule.priority DESC

SELECT /*product.product_number, 
                   rule.name, 
                   rule.priority, 
                   price.price,*/ 
                   rule.id AS rule_id, 
                   price.quantity_start, 
                   price.quantity_end
            FROM product_price price
            LEFT JOIN product ON product.id = price.product_id
            LEFT JOIN rule ON rule.id = price.rule_id
            WHERE (price.product_id = '\0\0\0\0\0\0\0\0\0\0\0\0\0F' OR product.parent_id = '\0\0\0\0\0\0\0\0\0\0\0\0\0F')
                AND price.rule_id IN (0x018EBDD989627376A72C231160F964C1, 0x018B5C5059FF7938AE5A7CEF7FBEA729, 0x018B6064F6147381A8A5DD450DE18FED, 0x018B606601787049AF369FD4E1BA25B8, 0x018B6066861A731DA7533DF6CD4C300F, 0x018B6669C9537AF59F7A0BFC807D94F6, 0x5587D54D389445E5B02656FEEB5C1481, 0x9B5963C95A30447A9E2549380EF00622, 0xB225D19ABA744AD58FC04D964667B2C4, 0x3B3F36B4207A4F5DB60D2E0DEA32B76F, 0x9B996690A6094DC09B5E9F5FA3DAB931)
            GROUP BY price.quantity_start, price.quantity_end
            ORDER BY rule.priority DESC
        ;

SELECT
  `customer`.`id` as `customer.id`,
  `customer`.`customer_group_id` as `customer.groupId`,
  `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`,
  `customer`.`sales_channel_id` as `customer.salesChannelId`,
  `customer`.`language_id` as `customer.languageId`,
  `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`,
  `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`,
  `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`,
  `customer`.`auto_increment` as `customer.autoIncrement`,
  `customer`.`customer_number` as `customer.customerNumber`,
  `customer`.`salutation_id` as `customer.salutationId`,
  `customer`.`first_name` as `customer.firstName`,
  `customer`.`last_name` as `customer.lastName`,
  `customer`.`company` as `customer.company`,
  `customer`.`password` as `customer.password`,
  `customer`.`email` as `customer.email`,
  `customer`.`title` as `customer.title`,
  `customer`.`vat_ids` as `customer.vatIds`,
  `customer`.`affiliate_code` as `customer.affiliateCode`,
  `customer`.`campaign_code` as `customer.campaignCode`,
  `customer`.`active` as `customer.active`,
  `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`,
  `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`,
  `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`,
  `customer`.`hash` as `customer.hash`,
  `customer`.`guest` as `customer.guest`,
  `customer`.`first_login` as `customer.firstLogin`,
  `customer`.`last_login` as `customer.lastLogin`,
  `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`,
  `customer`.`birthday` as `customer.birthday`,
  `customer`.`last_order_date` as `customer.lastOrderDate`,
  `customer`.`order_count` as `customer.orderCount`,
  `customer`.`order_total_amount` as `customer.orderTotalAmount`,
  `customer`.`review_count` as `customer.reviewCount`,
  `customer`.`custom_fields` as `customer.customFields`,
  `customer`.`legacy_password` as `customer.legacyPassword`,
  `customer`.`legacy_encoder` as `customer.legacyEncoder`,
  `customer`.`remote_address` as `customer.remoteAddress`,
  `customer`.`tag_ids` as `customer.tagIds`,
  `customer`.`requested_customer_group_id` as `customer.requestedGroupId`,
  `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`,
  `customer`.`account_type` as `customer.accountType`,
  `customer`.`created_by_id` as `customer.createdById`,
  `customer`.`updated_by_id` as `customer.updatedById`,
  `customer`.`created_at` as `customer.createdAt`,
  `customer`.`updated_at` as `customer.updatedAt`
FROM
  `customer`

SELECT `customer`.`id` as `customer.id`, `customer`.`customer_group_id` as `customer.groupId`, `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` as `customer.salesChannelId`, `customer`.`language_id` as `customer.languageId`, `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`, `customer`.`auto_increment` as `customer.autoIncrement`, `customer`.`customer_number` as `customer.customerNumber`, `customer`.`salutation_id` as `customer.salutationId`, `customer`.`first_name` as `customer.firstName`, `customer`.`last_name` as `customer.lastName`, `customer`.`company` as `customer.company`, `customer`.`password` as `customer.password`, `customer`.`email` as `customer.email`, `customer`.`title` as `customer.title`, `customer`.`vat_ids` as `customer.vatIds`, `customer`.`affiliate_code` as `customer.affiliateCode`, `customer`.`campaign_code` as `customer.campaignCode`, `customer`.`active` as `customer.active`, `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`, `customer`.`hash` as `customer.hash`, `customer`.`guest` as `customer.guest`, `customer`.`first_login` as `customer.firstLogin`, `customer`.`last_login` as `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`, `customer`.`birthday` as `customer.birthday`, `customer`.`last_order_date` as `customer.lastOrderDate`, `customer`.`order_count` as `customer.orderCount`, `customer`.`order_total_amount` as `customer.orderTotalAmount`, `customer`.`review_count` as `customer.reviewCount`, `customer`.`custom_fields` as `customer.customFields`, `customer`.`legacy_password` as `customer.legacyPassword`, `customer`.`legacy_encoder` as `customer.legacyEncoder`, `customer`.`remote_address` as `customer.remoteAddress`, `customer`.`tag_ids` as `customer.tagIds`, `customer`.`requested_customer_group_id` as `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`, `customer`.`account_type` as `customer.accountType`, `customer`.`created_by_id` as `customer.createdById`, `customer`.`updated_by_id` as `customer.updatedById`, `customer`.`created_at` as `customer.createdAt`, `customer`.`updated_at` as `customer.updatedAt` FROM `customer`;

SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`write_access` as `app.integration.writeAccess`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label as `app.translation.label`,
      `app.translation`.description as `app.translation.description`,
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields as `app.translation.customFields`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  `app`.`id` IN (?)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (0x0193D9F4E9CD72D597608DDDB537944C);

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;