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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id`
  LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id`
  AND IFNULL(
    `product`.`product_manufacturer_version_id`,
    `product.parent`.`product_manufacturer_version_id`
  ) = `product.manufacturer`.`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(`product.tax`.`id`) DESC,
  MAX(`product.manufacturer`.`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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`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(`product.tax`.`id`) DESC, MAX(`product.manufacturer`.`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\0
' OR product.parent_id = '\0\0\0\0\0\0\0\0\0\0\0\0\0
')
                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
  `neti_gmso_product_scaling`.`id` as `neti_gmso_product_scaling.id`,
  `neti_gmso_product_scaling`.`product_id` as `neti_gmso_product_scaling.productId`,
  `neti_gmso_product_scaling`.`customer_group_id` as `neti_gmso_product_scaling.customerGroupId`,
  `neti_gmso_product_scaling.customerGroup`.`id` as `neti_gmso_product_scaling.customerGroup.id`,
  `neti_gmso_product_scaling.customerGroup`.`display_gross` as `neti_gmso_product_scaling.customerGroup.displayGross`,
  `neti_gmso_product_scaling.customerGroup`.`registration_active` as `neti_gmso_product_scaling.customerGroup.registrationActive`,
  `neti_gmso_product_scaling.customerGroup`.`created_at` as `neti_gmso_product_scaling.customerGroup.createdAt`,
  `neti_gmso_product_scaling.customerGroup`.`updated_at` as `neti_gmso_product_scaling.customerGroup.updatedAt`,
  `neti_gmso_product_scaling.customerGroup.translation.name`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.name`,
    `neti_gmso_product_scaling.customerGroup.translation.name`
  ) as `neti_gmso_product_scaling.customerGroup.name`,
  `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`,
    `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`
  ) as `neti_gmso_product_scaling.customerGroup.registrationTitle`,
  `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`,
    `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`
  ) as `neti_gmso_product_scaling.customerGroup.registrationIntroduction`,
  `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`,
    `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`
  ) as `neti_gmso_product_scaling.customerGroup.registrationOnlyCompanyRegistration`,
  `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`,
    `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`
  ) as `neti_gmso_product_scaling.customerGroup.registrationSeoMetaDescription`,
  `neti_gmso_product_scaling.customerGroup.translation.customFields`,
  COALESCE(
    `neti_gmso_product_scaling.customerGroup.translation.customFields`,
    `neti_gmso_product_scaling.customerGroup.translation.customFields`
  ) as `neti_gmso_product_scaling.customerGroup.customFields`,
  `neti_gmso_product_scaling.customerGroup.translation.createdAt`,
  `neti_gmso_product_scaling.customerGroup.translation.updatedAt`,
  `neti_gmso_product_scaling.customerGroup.translation.customerGroupId`,
  `neti_gmso_product_scaling.customerGroup.translation.languageId`,
  `neti_gmso_product_scaling`.`product_version_id` as `neti_gmso_product_scaling.productVersionId`,
  `neti_gmso_product_scaling`.`minimum_purchase` as `neti_gmso_product_scaling.minimumPurchase`,
  `neti_gmso_product_scaling`.`maximum_purchase` as `neti_gmso_product_scaling.maximumPurchase`,
  `neti_gmso_product_scaling`.`scaling` as `neti_gmso_product_scaling.scaling`,
  `neti_gmso_product_scaling`.`created_at` as `neti_gmso_product_scaling.createdAt`,
  `neti_gmso_product_scaling`.`updated_at` as `neti_gmso_product_scaling.updatedAt`
FROM
  `neti_gmso_product_scaling`
  LEFT JOIN `customer_group` `neti_gmso_product_scaling.customerGroup` ON `neti_gmso_product_scaling`.`customer_group_id` = `neti_gmso_product_scaling.customerGroup`.`id`
  LEFT JOIN (
    SELECT
      `neti_gmso_product_scaling.customerGroup.translation`.customer_group_id,
      `neti_gmso_product_scaling.customerGroup.translation`.name as `neti_gmso_product_scaling.customerGroup.translation.name`,
      `neti_gmso_product_scaling.customerGroup.translation`.registration_title as `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`,
      `neti_gmso_product_scaling.customerGroup.translation`.registration_introduction as `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`,
      `neti_gmso_product_scaling.customerGroup.translation`.registration_only_company_registration as `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`,
      `neti_gmso_product_scaling.customerGroup.translation`.registration_seo_meta_description as `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`,
      `neti_gmso_product_scaling.customerGroup.translation`.custom_fields as `neti_gmso_product_scaling.customerGroup.translation.customFields`,
      `neti_gmso_product_scaling.customerGroup.translation`.created_at as `neti_gmso_product_scaling.customerGroup.translation.createdAt`,
      `neti_gmso_product_scaling.customerGroup.translation`.updated_at as `neti_gmso_product_scaling.customerGroup.translation.updatedAt`,
      `neti_gmso_product_scaling.customerGroup.translation`.customer_group_id as `neti_gmso_product_scaling.customerGroup.translation.customerGroupId`,
      `neti_gmso_product_scaling.customerGroup.translation`.language_id as `neti_gmso_product_scaling.customerGroup.translation.languageId`
    FROM
      `customer_group_translation` `neti_gmso_product_scaling.customerGroup.translation`
    WHERE
      `neti_gmso_product_scaling.customerGroup.translation`.language_id = ?
  ) `neti_gmso_product_scaling.customerGroup.customer_group_translation` ON `neti_gmso_product_scaling.customerGroup.customer_group_translation`.`customer_group_id` = `neti_gmso_product_scaling.customerGroup`.`id`
WHERE
  (
    `neti_gmso_product_scaling`.`product_id` = ?
  )

SELECT `neti_gmso_product_scaling`.`id` as `neti_gmso_product_scaling.id`, `neti_gmso_product_scaling`.`product_id` as `neti_gmso_product_scaling.productId`, `neti_gmso_product_scaling`.`customer_group_id` as `neti_gmso_product_scaling.customerGroupId`, `neti_gmso_product_scaling.customerGroup`.`id` as `neti_gmso_product_scaling.customerGroup.id`, `neti_gmso_product_scaling.customerGroup`.`display_gross` as `neti_gmso_product_scaling.customerGroup.displayGross`, `neti_gmso_product_scaling.customerGroup`.`registration_active` as `neti_gmso_product_scaling.customerGroup.registrationActive`, `neti_gmso_product_scaling.customerGroup`.`created_at` as `neti_gmso_product_scaling.customerGroup.createdAt`, `neti_gmso_product_scaling.customerGroup`.`updated_at` as `neti_gmso_product_scaling.customerGroup.updatedAt`, `neti_gmso_product_scaling.customerGroup.translation.name`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.name`,`neti_gmso_product_scaling.customerGroup.translation.name`) as `neti_gmso_product_scaling.customerGroup.name`, `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.registrationTitle`,`neti_gmso_product_scaling.customerGroup.translation.registrationTitle`) as `neti_gmso_product_scaling.customerGroup.registrationTitle`, `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`,`neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`) as `neti_gmso_product_scaling.customerGroup.registrationIntroduction`, `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`,`neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`) as `neti_gmso_product_scaling.customerGroup.registrationOnlyCompanyRegistration`, `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`,`neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`) as `neti_gmso_product_scaling.customerGroup.registrationSeoMetaDescription`, `neti_gmso_product_scaling.customerGroup.translation.customFields`, COALESCE(`neti_gmso_product_scaling.customerGroup.translation.customFields`,`neti_gmso_product_scaling.customerGroup.translation.customFields`) as `neti_gmso_product_scaling.customerGroup.customFields`, `neti_gmso_product_scaling.customerGroup.translation.createdAt`, `neti_gmso_product_scaling.customerGroup.translation.updatedAt`, `neti_gmso_product_scaling.customerGroup.translation.customerGroupId`, `neti_gmso_product_scaling.customerGroup.translation.languageId`, `neti_gmso_product_scaling`.`product_version_id` as `neti_gmso_product_scaling.productVersionId`, `neti_gmso_product_scaling`.`minimum_purchase` as `neti_gmso_product_scaling.minimumPurchase`, `neti_gmso_product_scaling`.`maximum_purchase` as `neti_gmso_product_scaling.maximumPurchase`, `neti_gmso_product_scaling`.`scaling` as `neti_gmso_product_scaling.scaling`, `neti_gmso_product_scaling`.`created_at` as `neti_gmso_product_scaling.createdAt`, `neti_gmso_product_scaling`.`updated_at` as `neti_gmso_product_scaling.updatedAt` FROM `neti_gmso_product_scaling` LEFT JOIN `customer_group` `neti_gmso_product_scaling.customerGroup` ON `neti_gmso_product_scaling`.`customer_group_id` = `neti_gmso_product_scaling.customerGroup`.`id` LEFT JOIN (SELECT `neti_gmso_product_scaling.customerGroup.translation`.customer_group_id, `neti_gmso_product_scaling.customerGroup.translation`.name as `neti_gmso_product_scaling.customerGroup.translation.name`, `neti_gmso_product_scaling.customerGroup.translation`.registration_title as `neti_gmso_product_scaling.customerGroup.translation.registrationTitle`, `neti_gmso_product_scaling.customerGroup.translation`.registration_introduction as `neti_gmso_product_scaling.customerGroup.translation.registrationIntroduction`, `neti_gmso_product_scaling.customerGroup.translation`.registration_only_company_registration as `neti_gmso_product_scaling.customerGroup.translation.registrationOnlyCompanyRegistration`, `neti_gmso_product_scaling.customerGroup.translation`.registration_seo_meta_description as `neti_gmso_product_scaling.customerGroup.translation.registrationSeoMetaDescription`, `neti_gmso_product_scaling.customerGroup.translation`.custom_fields as `neti_gmso_product_scaling.customerGroup.translation.customFields`, `neti_gmso_product_scaling.customerGroup.translation`.created_at as `neti_gmso_product_scaling.customerGroup.translation.createdAt`, `neti_gmso_product_scaling.customerGroup.translation`.updated_at as `neti_gmso_product_scaling.customerGroup.translation.updatedAt`, `neti_gmso_product_scaling.customerGroup.translation`.customer_group_id as `neti_gmso_product_scaling.customerGroup.translation.customerGroupId`, `neti_gmso_product_scaling.customerGroup.translation`.language_id as `neti_gmso_product_scaling.customerGroup.translation.languageId` FROM `customer_group_translation` `neti_gmso_product_scaling.customerGroup.translation` WHERE `neti_gmso_product_scaling.customerGroup.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `neti_gmso_product_scaling.customerGroup.customer_group_translation` ON `neti_gmso_product_scaling.customerGroup.customer_group_translation`.`customer_group_id` = `neti_gmso_product_scaling.customerGroup`.`id` WHERE (`neti_gmso_product_scaling`.`product_id` = '\0\0\0\0\0\0\0\0\0\0\0\0\0 H');

SELECT
  `acris_discount_group`.`id`
FROM
  `acris_discount_group`
  LEFT JOIN `acris_discount_dynamic_groups` `acris_discount_group.productStreams.mapping` ON `acris_discount_group`.`id` = `acris_discount_group.productStreams.mapping`.`discount_group_id`
  LEFT JOIN `acris_discount_group_rule` `acris_discount_group.rules.mapping` ON `acris_discount_group`.`id` = `acris_discount_group.rules.mapping`.`discount_group_id`
  LEFT JOIN `product_stream` `acris_discount_group.productStreams` ON `acris_discount_group.productStreams.mapping`.`product_stream_id` = `acris_discount_group.productStreams`.`id`
  LEFT JOIN `rule` `acris_discount_group.rules` ON `acris_discount_group.rules.mapping`.`rule_id` = `acris_discount_group.rules`.`id`
WHERE
  (
    `acris_discount_group`.`version_id` = ?
  )
  AND (
    (
      (
        `acris_discount_group`.`active` = ?
        AND (
          (
            `acris_discount_group`.`active_from` <=> ?
            AND `acris_discount_group`.`active_until` <=> ?
          )
          OR (
            `acris_discount_group`.`active_from` <=> ?
            AND (
              `acris_discount_group`.`active_until` > ?
            )
          )
          OR (
            (
              `acris_discount_group`.`active_from` <= ?
            )
            AND `acris_discount_group`.`active_until` <=> ?
          )
          OR (
            (
              `acris_discount_group`.`active_from` <= ?
            )
            AND (
              `acris_discount_group`.`active_until` > ?
            )
          )
        )
        AND (
          `acris_discount_group`.`customer_assignment_type` = ?
          OR (
            `acris_discount_group`.`customer_assignment_type` = ?
            AND `acris_discount_group.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          )
        )
        AND (
          (
            `acris_discount_group`.`product_assignment_type` = ?
            AND `acris_discount_group`.`product_id` = ?
          )
          OR (
            `acris_discount_group`.`product_assignment_type` = ?
            AND `acris_discount_group.productStreams`.`id` IN (?, ?, ?, ?, ?, ?)
            AND NOT (
              `acris_discount_group.productStreams`.`id` <=> ?
            )
          )
          OR `acris_discount_group`.`product_assignment_type` = ?
          OR `acris_discount_group`.`product_assignment_type` = ?
        )
      )
    )
  )
GROUP BY
  `acris_discount_group`.`id`
ORDER BY
  MAX(
    `acris_discount_group`.`priority`
  ) DESC

SELECT `acris_discount_group`.`id` FROM `acris_discount_group` LEFT JOIN `acris_discount_dynamic_groups` `acris_discount_group.productStreams.mapping` ON `acris_discount_group`.`id` = `acris_discount_group.productStreams.mapping`.`discount_group_id`  LEFT JOIN `acris_discount_group_rule` `acris_discount_group.rules.mapping` ON `acris_discount_group`.`id` = `acris_discount_group.rules.mapping`.`discount_group_id`  LEFT JOIN `product_stream` `acris_discount_group.productStreams` ON `acris_discount_group.productStreams.mapping`.`product_stream_id` = `acris_discount_group.productStreams`.`id`  LEFT JOIN `rule` `acris_discount_group.rules` ON `acris_discount_group.rules.mapping`.`rule_id` = `acris_discount_group.rules`.`id`  WHERE (`acris_discount_group`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`acris_discount_group`.`active` = 1 AND ((`acris_discount_group`.`active_from` <=> NULL AND `acris_discount_group`.`active_until` <=> NULL) OR (`acris_discount_group`.`active_from` <=> NULL AND (`acris_discount_group`.`active_until` > '2025-07-08 18:58:02')) OR ((`acris_discount_group`.`active_from` <= '2025-07-08 18:58:02') AND `acris_discount_group`.`active_until` <=> NULL) OR ((`acris_discount_group`.`active_from` <= '2025-07-08 18:58:02') AND (`acris_discount_group`.`active_until` > '2025-07-08 18:58:02'))) AND (`acris_discount_group`.`customer_assignment_type` = 'everyCustomer' OR (`acris_discount_group`.`customer_assignment_type` = 'rules' AND `acris_discount_group.rules`.`id` IN (0x018EBDD989627376A72C231160F964C1, 0x018B5C5059FF7938AE5A7CEF7FBEA729, 0x018B6064F6147381A8A5DD450DE18FED, 0x018B606601787049AF369FD4E1BA25B8, 0x018B6066861A731DA7533DF6CD4C300F, 0x018B6669C9537AF59F7A0BFC807D94F6, 0x5587D54D389445E5B02656FEEB5C1481, 0x9B5963C95A30447A9E2549380EF00622, 0xB225D19ABA744AD58FC04D964667B2C4, 0x3B3F36B4207A4F5DB60D2E0DEA32B76F, 0x9B996690A6094DC09B5E9F5FA3DAB931))) AND ((`acris_discount_group`.`product_assignment_type` = 'product' AND `acris_discount_group`.`product_id` = '\0\0\0\0\0\0\0\0\0\0\0\0\0 H') OR (`acris_discount_group`.`product_assignment_type` = 'dynamicProductGroup' AND `acris_discount_group.productStreams`.`id` IN (0x018D55DC5C147F97BA360CE4D59935E6, 0x018DC70DAC277B20994F4C331FA15439, 0x018FEDE9DC1D79C98A53067F6F3F95A0, 0x01927B2954657F53B83C30AF3667DB15, 0x01929EBB0256722686ABD858132C559A, 0xC7BB481E749E4A87BFEE8FD1EA112F12) AND NOT (`acris_discount_group.productStreams`.`id` <=> NULL)) OR `acris_discount_group`.`product_assignment_type` = 'everyProduct' OR `acris_discount_group`.`product_assignment_type` = 'materialGroup')))) GROUP BY `acris_discount_group`.`id` ORDER BY MAX(`acris_discount_group`.`priority`) DESC;

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

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