Symfony Profiler

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      `product`.`parent_id` = ?
      AND `product`.`available` = ?
      AND JSON_CONTAINS(
        IFNULL(
          `product`.`option_ids`, `product.parent`.`option_ids`
        ),
        JSON_ARRAY(?)
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
LIMIT
  1

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` = 0xD8E6EC7BEB4A4D4A99D180B112CDED95 AND `product`.`available` = 1 AND JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('0c7fb8199db74a7aa20ec17a274eb670')) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x67D79825561D4007A766D27CBBF1BDF6 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) LIMIT 1;

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

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.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`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) AS `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.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`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) AS `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x67D79825561D4007A766D27CBBF1BDF6 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0xCF70D2E92DFF4D608E8882D86BE6A0B5 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0)));

# product-listing-route::loading::search-ids
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 `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
GROUP BY
  `product`.`display_group`
ORDER BY
  MAX(`product`.`sales`) DESC,
  MIN(`product`.`id`) ASC
LIMIT
  50

# product-listing-route::loading::search-ids
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 `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x67D79825561D4007A766D27CBBF1BDF6 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0xCF70D2E92DFF4D608E8882D86BE6A0B5 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) GROUP BY `product`.`display_group` ORDER BY MAX(`product`.`sales`) DESC, MIN(`product`.`id`) ASC LIMIT 50;

SELECT
  `product_configurator_setting`.`id` AS `product_configurator_setting.id`,
  `product_configurator_setting`.`version_id` AS `product_configurator_setting.versionId`,
  `product_configurator_setting`.`product_id` AS `product_configurator_setting.productId`,
  `product_configurator_setting`.`product_version_id` AS `product_configurator_setting.productVersionId`,
  `product_configurator_setting`.`media_id` AS `product_configurator_setting.mediaId`,
  `product_configurator_setting`.`property_group_option_id` AS `product_configurator_setting.optionId`,
  `product_configurator_setting`.`price` AS `product_configurator_setting.price`,
  `product_configurator_setting`.`position` AS `product_configurator_setting.position`,
  `product_configurator_setting`.`custom_fields` AS `product_configurator_setting.customFields`,
  `product_configurator_setting`.`created_at` AS `product_configurator_setting.createdAt`,
  `product_configurator_setting`.`updated_at` AS `product_configurator_setting.updatedAt`,
  `product_configurator_setting.option`.`id` AS `product_configurator_setting.option.id`,
  `product_configurator_setting.option`.`property_group_id` AS `product_configurator_setting.option.groupId`,
  `product_configurator_setting.option`.`color_hex_code` AS `product_configurator_setting.option.colorHexCode`,
  `product_configurator_setting.option`.`media_id` AS `product_configurator_setting.option.mediaId`,
  `product_configurator_setting.option`.`created_at` AS `product_configurator_setting.option.createdAt`,
  `product_configurator_setting.option`.`updated_at` AS `product_configurator_setting.option.updatedAt`,
  `product_configurator_setting.option.group`.`id` AS `product_configurator_setting.option.group.id`,
  `product_configurator_setting.option.group`.`display_type` AS `product_configurator_setting.option.group.displayType`,
  `product_configurator_setting.option.group`.`sorting_type` AS `product_configurator_setting.option.group.sortingType`,
  `product_configurator_setting.option.group`.`filterable` AS `product_configurator_setting.option.group.filterable`,
  `product_configurator_setting.option.group`.`visible_on_product_detail_page` AS `product_configurator_setting.option.group.visibleOnProductDetailPage`,
  `product_configurator_setting.option.group`.`created_at` AS `product_configurator_setting.option.group.createdAt`,
  `product_configurator_setting.option.group`.`updated_at` AS `product_configurator_setting.option.group.updatedAt`,
  `product_configurator_setting.option.group.translation.name`,
  COALESCE(
    `product_configurator_setting.option.group.translation.name`,
    `product_configurator_setting.option.group.translation.name`
  ) AS `product_configurator_setting.option.group.name`,
  `product_configurator_setting.option.group.translation.description`,
  COALESCE(
    `product_configurator_setting.option.group.translation.description`,
    `product_configurator_setting.option.group.translation.description`
  ) AS `product_configurator_setting.option.group.description`,
  `product_configurator_setting.option.group.translation.position`,
  COALESCE(
    `product_configurator_setting.option.group.translation.position`,
    `product_configurator_setting.option.group.translation.position`
  ) AS `product_configurator_setting.option.group.position`,
  `product_configurator_setting.option.group.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.group.translation.customFields`,
    `product_configurator_setting.option.group.translation.customFields`
  ) AS `product_configurator_setting.option.group.customFields`,
  `product_configurator_setting.option.group.translation.createdAt`,
  `product_configurator_setting.option.group.translation.updatedAt`,
  `product_configurator_setting.option.group.translation.propertyGroupId`,
  `product_configurator_setting.option.group.translation.languageId`,
  `product_configurator_setting.option.media`.`id` AS `product_configurator_setting.option.media.id`,
  `product_configurator_setting.option.media`.`user_id` AS `product_configurator_setting.option.media.userId`,
  `product_configurator_setting.option.media`.`media_folder_id` AS `product_configurator_setting.option.media.mediaFolderId`,
  `product_configurator_setting.option.media`.`mime_type` AS `product_configurator_setting.option.media.mimeType`,
  `product_configurator_setting.option.media`.`file_extension` AS `product_configurator_setting.option.media.fileExtension`,
  `product_configurator_setting.option.media`.`uploaded_at` AS `product_configurator_setting.option.media.uploadedAt`,
  `product_configurator_setting.option.media`.`file_name` AS `product_configurator_setting.option.media.fileName`,
  `product_configurator_setting.option.media`.`file_size` AS `product_configurator_setting.option.media.fileSize`,
  `product_configurator_setting.option.media`.`media_type` AS `product_configurator_setting.option.media.mediaTypeRaw`,
  `product_configurator_setting.option.media`.`meta_data` AS `product_configurator_setting.option.media.metaData`,
  `product_configurator_setting.option.media`.`config` AS `product_configurator_setting.option.media.config`,
  `product_configurator_setting.option.media`.`path` AS `product_configurator_setting.option.media.path`,
  `product_configurator_setting.option.media`.`private` AS `product_configurator_setting.option.media.private`,
  `product_configurator_setting.option.media`.`thumbnails_ro` AS `product_configurator_setting.option.media.thumbnailsRo`,
  `product_configurator_setting.option.media`.`created_at` AS `product_configurator_setting.option.media.createdAt`,
  `product_configurator_setting.option.media`.`updated_at` AS `product_configurator_setting.option.media.updatedAt`,
  `product_configurator_setting.option.media.translation.title`,
  COALESCE(
    `product_configurator_setting.option.media.translation.title`,
    `product_configurator_setting.option.media.translation.title`
  ) AS `product_configurator_setting.option.media.title`,
  `product_configurator_setting.option.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.option.media.translation.alt`,
    `product_configurator_setting.option.media.translation.alt`
  ) AS `product_configurator_setting.option.media.alt`,
  `product_configurator_setting.option.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.media.translation.customFields`,
    `product_configurator_setting.option.media.translation.customFields`
  ) AS `product_configurator_setting.option.media.customFields`,
  `product_configurator_setting.option.media.translation.createdAt`,
  `product_configurator_setting.option.media.translation.updatedAt`,
  `product_configurator_setting.option.media.translation.mediaId`,
  `product_configurator_setting.option.media.translation.languageId`,
  `product_configurator_setting.option.translation.name`,
  COALESCE(
    `product_configurator_setting.option.translation.name`,
    `product_configurator_setting.option.translation.name`
  ) AS `product_configurator_setting.option.name`,
  `product_configurator_setting.option.translation.position`,
  COALESCE(
    `product_configurator_setting.option.translation.position`,
    `product_configurator_setting.option.translation.position`
  ) AS `product_configurator_setting.option.position`,
  `product_configurator_setting.option.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.translation.customFields`,
    `product_configurator_setting.option.translation.customFields`
  ) AS `product_configurator_setting.option.customFields`,
  `product_configurator_setting.option.translation.createdAt`,
  `product_configurator_setting.option.translation.updatedAt`,
  `product_configurator_setting.option.translation.propertyGroupOptionId`,
  `product_configurator_setting.option.translation.languageId`,
  `product_configurator_setting.media`.`id` AS `product_configurator_setting.media.id`,
  `product_configurator_setting.media`.`user_id` AS `product_configurator_setting.media.userId`,
  `product_configurator_setting.media`.`media_folder_id` AS `product_configurator_setting.media.mediaFolderId`,
  `product_configurator_setting.media`.`mime_type` AS `product_configurator_setting.media.mimeType`,
  `product_configurator_setting.media`.`file_extension` AS `product_configurator_setting.media.fileExtension`,
  `product_configurator_setting.media`.`uploaded_at` AS `product_configurator_setting.media.uploadedAt`,
  `product_configurator_setting.media`.`file_name` AS `product_configurator_setting.media.fileName`,
  `product_configurator_setting.media`.`file_size` AS `product_configurator_setting.media.fileSize`,
  `product_configurator_setting.media`.`media_type` AS `product_configurator_setting.media.mediaTypeRaw`,
  `product_configurator_setting.media`.`meta_data` AS `product_configurator_setting.media.metaData`,
  `product_configurator_setting.media`.`config` AS `product_configurator_setting.media.config`,
  `product_configurator_setting.media`.`path` AS `product_configurator_setting.media.path`,
  `product_configurator_setting.media`.`private` AS `product_configurator_setting.media.private`,
  `product_configurator_setting.media`.`thumbnails_ro` AS `product_configurator_setting.media.thumbnailsRo`,
  `product_configurator_setting.media`.`created_at` AS `product_configurator_setting.media.createdAt`,
  `product_configurator_setting.media`.`updated_at` AS `product_configurator_setting.media.updatedAt`,
  `product_configurator_setting.media.translation.title`,
  COALESCE(
    `product_configurator_setting.media.translation.title`,
    `product_configurator_setting.media.translation.title`
  ) AS `product_configurator_setting.media.title`,
  `product_configurator_setting.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.media.translation.alt`,
    `product_configurator_setting.media.translation.alt`
  ) AS `product_configurator_setting.media.alt`,
  `product_configurator_setting.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.media.translation.customFields`,
    `product_configurator_setting.media.translation.customFields`
  ) AS `product_configurator_setting.media.customFields`,
  `product_configurator_setting.media.translation.createdAt`,
  `product_configurator_setting.media.translation.updatedAt`,
  `product_configurator_setting.media.translation.mediaId`,
  `product_configurator_setting.media.translation.languageId`
FROM
  `product_configurator_setting`
  LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.translation`.property_group_option_id,
      `product_configurator_setting.option.translation`.name AS `product_configurator_setting.option.translation.name`,
      `product_configurator_setting.option.translation`.position AS `product_configurator_setting.option.translation.position`,
      `product_configurator_setting.option.translation`.custom_fields AS `product_configurator_setting.option.translation.customFields`,
      `product_configurator_setting.option.translation`.created_at AS `product_configurator_setting.option.translation.createdAt`,
      `product_configurator_setting.option.translation`.updated_at AS `product_configurator_setting.option.translation.updatedAt`,
      `product_configurator_setting.option.translation`.property_group_option_id AS `product_configurator_setting.option.translation.propertyGroupOptionId`,
      `product_configurator_setting.option.translation`.language_id AS `product_configurator_setting.option.translation.languageId`
    FROM
      `property_group_option_translation` `product_configurator_setting.option.translation`
    WHERE
      `product_configurator_setting.option.translation`.language_id = ?
  ) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.group.translation`.property_group_id,
      `product_configurator_setting.option.group.translation`.name AS `product_configurator_setting.option.group.translation.name`,
      `product_configurator_setting.option.group.translation`.description AS `product_configurator_setting.option.group.translation.description`,
      `product_configurator_setting.option.group.translation`.position AS `product_configurator_setting.option.group.translation.position`,
      `product_configurator_setting.option.group.translation`.custom_fields AS `product_configurator_setting.option.group.translation.customFields`,
      `product_configurator_setting.option.group.translation`.created_at AS `product_configurator_setting.option.group.translation.createdAt`,
      `product_configurator_setting.option.group.translation`.updated_at AS `product_configurator_setting.option.group.translation.updatedAt`,
      `product_configurator_setting.option.group.translation`.property_group_id AS `product_configurator_setting.option.group.translation.propertyGroupId`,
      `product_configurator_setting.option.group.translation`.language_id AS `product_configurator_setting.option.group.translation.languageId`
    FROM
      `property_group_translation` `product_configurator_setting.option.group.translation`
    WHERE
      `product_configurator_setting.option.group.translation`.language_id = ?
  ) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.media.translation`.media_id,
      `product_configurator_setting.option.media.translation`.title AS `product_configurator_setting.option.media.translation.title`,
      `product_configurator_setting.option.media.translation`.alt AS `product_configurator_setting.option.media.translation.alt`,
      `product_configurator_setting.option.media.translation`.custom_fields AS `product_configurator_setting.option.media.translation.customFields`,
      `product_configurator_setting.option.media.translation`.created_at AS `product_configurator_setting.option.media.translation.createdAt`,
      `product_configurator_setting.option.media.translation`.updated_at AS `product_configurator_setting.option.media.translation.updatedAt`,
      `product_configurator_setting.option.media.translation`.media_id AS `product_configurator_setting.option.media.translation.mediaId`,
      `product_configurator_setting.option.media.translation`.language_id AS `product_configurator_setting.option.media.translation.languageId`
    FROM
      `media_translation` `product_configurator_setting.option.media.translation`
    WHERE
      `product_configurator_setting.option.media.translation`.language_id = ?
  ) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.media.translation`.media_id,
      `product_configurator_setting.media.translation`.title AS `product_configurator_setting.media.translation.title`,
      `product_configurator_setting.media.translation`.alt AS `product_configurator_setting.media.translation.alt`,
      `product_configurator_setting.media.translation`.custom_fields AS `product_configurator_setting.media.translation.customFields`,
      `product_configurator_setting.media.translation`.created_at AS `product_configurator_setting.media.translation.createdAt`,
      `product_configurator_setting.media.translation`.updated_at AS `product_configurator_setting.media.translation.updatedAt`,
      `product_configurator_setting.media.translation`.media_id AS `product_configurator_setting.media.translation.mediaId`,
      `product_configurator_setting.media.translation`.language_id AS `product_configurator_setting.media.translation.languageId`
    FROM
      `media_translation` `product_configurator_setting.media.translation`
    WHERE
      `product_configurator_setting.media.translation`.language_id = ?
  ) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id`
WHERE
  (
    `product_configurator_setting`.`version_id` = ?
  )
  AND (
    (
      `product_configurator_setting`.`product_id` = ?
    )
  )

SELECT `product_configurator_setting`.`id` AS `product_configurator_setting.id`, `product_configurator_setting`.`version_id` AS `product_configurator_setting.versionId`, `product_configurator_setting`.`product_id` AS `product_configurator_setting.productId`, `product_configurator_setting`.`product_version_id` AS `product_configurator_setting.productVersionId`, `product_configurator_setting`.`media_id` AS `product_configurator_setting.mediaId`, `product_configurator_setting`.`property_group_option_id` AS `product_configurator_setting.optionId`, `product_configurator_setting`.`price` AS `product_configurator_setting.price`, `product_configurator_setting`.`position` AS `product_configurator_setting.position`, `product_configurator_setting`.`custom_fields` AS `product_configurator_setting.customFields`, `product_configurator_setting`.`created_at` AS `product_configurator_setting.createdAt`, `product_configurator_setting`.`updated_at` AS `product_configurator_setting.updatedAt`, `product_configurator_setting.option`.`id` AS `product_configurator_setting.option.id`, `product_configurator_setting.option`.`property_group_id` AS `product_configurator_setting.option.groupId`, `product_configurator_setting.option`.`color_hex_code` AS `product_configurator_setting.option.colorHexCode`, `product_configurator_setting.option`.`media_id` AS `product_configurator_setting.option.mediaId`, `product_configurator_setting.option`.`created_at` AS `product_configurator_setting.option.createdAt`, `product_configurator_setting.option`.`updated_at` AS `product_configurator_setting.option.updatedAt`, `product_configurator_setting.option.group`.`id` AS `product_configurator_setting.option.group.id`, `product_configurator_setting.option.group`.`display_type` AS `product_configurator_setting.option.group.displayType`, `product_configurator_setting.option.group`.`sorting_type` AS `product_configurator_setting.option.group.sortingType`, `product_configurator_setting.option.group`.`filterable` AS `product_configurator_setting.option.group.filterable`, `product_configurator_setting.option.group`.`visible_on_product_detail_page` AS `product_configurator_setting.option.group.visibleOnProductDetailPage`, `product_configurator_setting.option.group`.`created_at` AS `product_configurator_setting.option.group.createdAt`, `product_configurator_setting.option.group`.`updated_at` AS `product_configurator_setting.option.group.updatedAt`, `product_configurator_setting.option.group.translation.name`, COALESCE(`product_configurator_setting.option.group.translation.name`,`product_configurator_setting.option.group.translation.name`) AS `product_configurator_setting.option.group.name`, `product_configurator_setting.option.group.translation.description`, COALESCE(`product_configurator_setting.option.group.translation.description`,`product_configurator_setting.option.group.translation.description`) AS `product_configurator_setting.option.group.description`, `product_configurator_setting.option.group.translation.position`, COALESCE(`product_configurator_setting.option.group.translation.position`,`product_configurator_setting.option.group.translation.position`) AS `product_configurator_setting.option.group.position`, `product_configurator_setting.option.group.translation.customFields`, COALESCE(`product_configurator_setting.option.group.translation.customFields`,`product_configurator_setting.option.group.translation.customFields`) AS `product_configurator_setting.option.group.customFields`, `product_configurator_setting.option.group.translation.createdAt`, `product_configurator_setting.option.group.translation.updatedAt`, `product_configurator_setting.option.group.translation.propertyGroupId`, `product_configurator_setting.option.group.translation.languageId`, `product_configurator_setting.option.media`.`id` AS `product_configurator_setting.option.media.id`, `product_configurator_setting.option.media`.`user_id` AS `product_configurator_setting.option.media.userId`, `product_configurator_setting.option.media`.`media_folder_id` AS `product_configurator_setting.option.media.mediaFolderId`, `product_configurator_setting.option.media`.`mime_type` AS `product_configurator_setting.option.media.mimeType`, `product_configurator_setting.option.media`.`file_extension` AS `product_configurator_setting.option.media.fileExtension`, `product_configurator_setting.option.media`.`uploaded_at` AS `product_configurator_setting.option.media.uploadedAt`, `product_configurator_setting.option.media`.`file_name` AS `product_configurator_setting.option.media.fileName`, `product_configurator_setting.option.media`.`file_size` AS `product_configurator_setting.option.media.fileSize`, `product_configurator_setting.option.media`.`media_type` AS `product_configurator_setting.option.media.mediaTypeRaw`, `product_configurator_setting.option.media`.`meta_data` AS `product_configurator_setting.option.media.metaData`, `product_configurator_setting.option.media`.`config` AS `product_configurator_setting.option.media.config`, `product_configurator_setting.option.media`.`path` AS `product_configurator_setting.option.media.path`, `product_configurator_setting.option.media`.`private` AS `product_configurator_setting.option.media.private`, `product_configurator_setting.option.media`.`thumbnails_ro` AS `product_configurator_setting.option.media.thumbnailsRo`, `product_configurator_setting.option.media`.`created_at` AS `product_configurator_setting.option.media.createdAt`, `product_configurator_setting.option.media`.`updated_at` AS `product_configurator_setting.option.media.updatedAt`, `product_configurator_setting.option.media.translation.title`, COALESCE(`product_configurator_setting.option.media.translation.title`,`product_configurator_setting.option.media.translation.title`) AS `product_configurator_setting.option.media.title`, `product_configurator_setting.option.media.translation.alt`, COALESCE(`product_configurator_setting.option.media.translation.alt`,`product_configurator_setting.option.media.translation.alt`) AS `product_configurator_setting.option.media.alt`, `product_configurator_setting.option.media.translation.customFields`, COALESCE(`product_configurator_setting.option.media.translation.customFields`,`product_configurator_setting.option.media.translation.customFields`) AS `product_configurator_setting.option.media.customFields`, `product_configurator_setting.option.media.translation.createdAt`, `product_configurator_setting.option.media.translation.updatedAt`, `product_configurator_setting.option.media.translation.mediaId`, `product_configurator_setting.option.media.translation.languageId`, `product_configurator_setting.option.translation.name`, COALESCE(`product_configurator_setting.option.translation.name`,`product_configurator_setting.option.translation.name`) AS `product_configurator_setting.option.name`, `product_configurator_setting.option.translation.position`, COALESCE(`product_configurator_setting.option.translation.position`,`product_configurator_setting.option.translation.position`) AS `product_configurator_setting.option.position`, `product_configurator_setting.option.translation.customFields`, COALESCE(`product_configurator_setting.option.translation.customFields`,`product_configurator_setting.option.translation.customFields`) AS `product_configurator_setting.option.customFields`, `product_configurator_setting.option.translation.createdAt`, `product_configurator_setting.option.translation.updatedAt`, `product_configurator_setting.option.translation.propertyGroupOptionId`, `product_configurator_setting.option.translation.languageId`, `product_configurator_setting.media`.`id` AS `product_configurator_setting.media.id`, `product_configurator_setting.media`.`user_id` AS `product_configurator_setting.media.userId`, `product_configurator_setting.media`.`media_folder_id` AS `product_configurator_setting.media.mediaFolderId`, `product_configurator_setting.media`.`mime_type` AS `product_configurator_setting.media.mimeType`, `product_configurator_setting.media`.`file_extension` AS `product_configurator_setting.media.fileExtension`, `product_configurator_setting.media`.`uploaded_at` AS `product_configurator_setting.media.uploadedAt`, `product_configurator_setting.media`.`file_name` AS `product_configurator_setting.media.fileName`, `product_configurator_setting.media`.`file_size` AS `product_configurator_setting.media.fileSize`, `product_configurator_setting.media`.`media_type` AS `product_configurator_setting.media.mediaTypeRaw`, `product_configurator_setting.media`.`meta_data` AS `product_configurator_setting.media.metaData`, `product_configurator_setting.media`.`config` AS `product_configurator_setting.media.config`, `product_configurator_setting.media`.`path` AS `product_configurator_setting.media.path`, `product_configurator_setting.media`.`private` AS `product_configurator_setting.media.private`, `product_configurator_setting.media`.`thumbnails_ro` AS `product_configurator_setting.media.thumbnailsRo`, `product_configurator_setting.media`.`created_at` AS `product_configurator_setting.media.createdAt`, `product_configurator_setting.media`.`updated_at` AS `product_configurator_setting.media.updatedAt`, `product_configurator_setting.media.translation.title`, COALESCE(`product_configurator_setting.media.translation.title`,`product_configurator_setting.media.translation.title`) AS `product_configurator_setting.media.title`, `product_configurator_setting.media.translation.alt`, COALESCE(`product_configurator_setting.media.translation.alt`,`product_configurator_setting.media.translation.alt`) AS `product_configurator_setting.media.alt`, `product_configurator_setting.media.translation.customFields`, COALESCE(`product_configurator_setting.media.translation.customFields`,`product_configurator_setting.media.translation.customFields`) AS `product_configurator_setting.media.customFields`, `product_configurator_setting.media.translation.createdAt`, `product_configurator_setting.media.translation.updatedAt`, `product_configurator_setting.media.translation.mediaId`, `product_configurator_setting.media.translation.languageId` FROM `product_configurator_setting` LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.translation`.property_group_option_id, `product_configurator_setting.option.translation`.name AS `product_configurator_setting.option.translation.name`, `product_configurator_setting.option.translation`.position AS `product_configurator_setting.option.translation.position`, `product_configurator_setting.option.translation`.custom_fields AS `product_configurator_setting.option.translation.customFields`, `product_configurator_setting.option.translation`.created_at AS `product_configurator_setting.option.translation.createdAt`, `product_configurator_setting.option.translation`.updated_at AS `product_configurator_setting.option.translation.updatedAt`, `product_configurator_setting.option.translation`.property_group_option_id AS `product_configurator_setting.option.translation.propertyGroupOptionId`, `product_configurator_setting.option.translation`.language_id AS `product_configurator_setting.option.translation.languageId` FROM `property_group_option_translation` `product_configurator_setting.option.translation` WHERE `product_configurator_setting.option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.group.translation`.property_group_id, `product_configurator_setting.option.group.translation`.name AS `product_configurator_setting.option.group.translation.name`, `product_configurator_setting.option.group.translation`.description AS `product_configurator_setting.option.group.translation.description`, `product_configurator_setting.option.group.translation`.position AS `product_configurator_setting.option.group.translation.position`, `product_configurator_setting.option.group.translation`.custom_fields AS `product_configurator_setting.option.group.translation.customFields`, `product_configurator_setting.option.group.translation`.created_at AS `product_configurator_setting.option.group.translation.createdAt`, `product_configurator_setting.option.group.translation`.updated_at AS `product_configurator_setting.option.group.translation.updatedAt`, `product_configurator_setting.option.group.translation`.property_group_id AS `product_configurator_setting.option.group.translation.propertyGroupId`, `product_configurator_setting.option.group.translation`.language_id AS `product_configurator_setting.option.group.translation.languageId` FROM `property_group_translation` `product_configurator_setting.option.group.translation` WHERE `product_configurator_setting.option.group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.media.translation`.media_id, `product_configurator_setting.option.media.translation`.title AS `product_configurator_setting.option.media.translation.title`, `product_configurator_setting.option.media.translation`.alt AS `product_configurator_setting.option.media.translation.alt`, `product_configurator_setting.option.media.translation`.custom_fields AS `product_configurator_setting.option.media.translation.customFields`, `product_configurator_setting.option.media.translation`.created_at AS `product_configurator_setting.option.media.translation.createdAt`, `product_configurator_setting.option.media.translation`.updated_at AS `product_configurator_setting.option.media.translation.updatedAt`, `product_configurator_setting.option.media.translation`.media_id AS `product_configurator_setting.option.media.translation.mediaId`, `product_configurator_setting.option.media.translation`.language_id AS `product_configurator_setting.option.media.translation.languageId` FROM `media_translation` `product_configurator_setting.option.media.translation` WHERE `product_configurator_setting.option.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.media.translation`.media_id, `product_configurator_setting.media.translation`.title AS `product_configurator_setting.media.translation.title`, `product_configurator_setting.media.translation`.alt AS `product_configurator_setting.media.translation.alt`, `product_configurator_setting.media.translation`.custom_fields AS `product_configurator_setting.media.translation.customFields`, `product_configurator_setting.media.translation`.created_at AS `product_configurator_setting.media.translation.createdAt`, `product_configurator_setting.media.translation`.updated_at AS `product_configurator_setting.media.translation.updatedAt`, `product_configurator_setting.media.translation`.media_id AS `product_configurator_setting.media.translation.mediaId`, `product_configurator_setting.media.translation`.language_id AS `product_configurator_setting.media.translation.languageId` FROM `media_translation` `product_configurator_setting.media.translation` WHERE `product_configurator_setting.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id` WHERE (`product_configurator_setting`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_configurator_setting`.`product_id` = 0xD8E6EC7BEB4A4D4A99D180B112CDED95));