Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.variant_code AS variant_code_2,
  t0.size AS size_3,
  t0.system_magazine AS system_magazine_4,
  t0.own_magazine AS own_magazine_5,
  t0.delivery_magazine AS delivery_magazine_6,
  t0.delivery_magazine_date AS delivery_magazine_date_7,
  t0.color_hex AS color_hex_8,
  t0.url AS url_9,
  t0.in_week_magazine AS in_week_magazine_10,
  t0.material AS material_11,
  t0.delivery_magazine_label AS delivery_magazine_label_12,
  t0.product_id AS product_id_13,
  t0.variant_color_id AS variant_color_id_14,
  t0.main_image_id AS main_image_id_15
FROM
  product_variant t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.id = 5932 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price_from AS price_from_2,
  p0_.price_to AS price_to_3
FROM
  price_factor p0_
WHERE
  p0_.price_from <= ?
  AND p0_.price_to > ?
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= '20.76' AND p0_.price_to > '20.76' ORDER BY p0_.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.display_name AS display_name_4
FROM
  settings t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = 'INFO_DATE_FROM' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.amount_from AS amount_from_2,
  t0.amount_to AS amount_to_3,
  t0.margin AS margin_4,
  t0.price_factor_id AS price_factor_id_5
FROM
  price_factor_item t0
WHERE
  t0.price_factor_id = ?

SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.product_code AS product_code_3,
  t0.description AS description_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.url AS url_7,
  t0.weight AS weight_8,
  t0.min_amount AS min_amount_9,
  t0.price_netto AS price_netto_10,
  t0.vat AS vat_11,
  t0.promotional_price AS promotional_price_12,
  t0.homepage AS homepage_13,
  t0.recommended AS recommended_14,
  t0.new AS new_15,
  t0.active AS active_16,
  t0.calculator AS calculator_17,
  t0.supplier_product_id AS supplier_product_id_18,
  t0.bestseller AS bestseller_19,
  t0.final_price AS final_price_20,
  t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21,
  t0.supplier_id AS supplier_id_22,
  t0.main_category_id AS main_category_id_23,
  t0.price_factor_id AS price_factor_id_24,
  t0.handling_cost_id AS handling_cost_id_25,
  t0.main_product_variant_file_id AS main_product_variant_file_id_26,
  t0.canonical_variant_id AS canonical_variant_id_27
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.id = 3307;

SELECT
  r0_.id AS id_0,
  r0_.date AS date_1,
  r0_.rating AS rating_2,
  r0_.description AS description_3,
  r0_.author AS author_4,
  r0_.email AS email_5,
  r0_.status AS status_6,
  r0_.product_id AS product_id_7
FROM
  reviews r0_
WHERE
  r0_.product_id = ?
  AND r0_.status = 1
ORDER BY
  r0_.date DESC
LIMIT
  100

SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.rating AS rating_2, r0_.description AS description_3, r0_.author AS author_4, r0_.email AS email_5, r0_.status AS status_6, r0_.product_id AS product_id_7 FROM reviews r0_ WHERE r0_.product_id = 3307 AND r0_.status = 1 ORDER BY r0_.date DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.variant_code AS variant_code_2,
  t0.size AS size_3,
  t0.system_magazine AS system_magazine_4,
  t0.own_magazine AS own_magazine_5,
  t0.delivery_magazine AS delivery_magazine_6,
  t0.delivery_magazine_date AS delivery_magazine_date_7,
  t0.color_hex AS color_hex_8,
  t0.url AS url_9,
  t0.in_week_magazine AS in_week_magazine_10,
  t0.material AS material_11,
  t0.delivery_magazine_label AS delivery_magazine_label_12,
  t0.product_id AS product_id_13,
  t0.variant_color_id AS variant_color_id_14,
  t0.main_image_id AS main_image_id_15
FROM
  product_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = 3307;

SELECT
  avg(r0_.rating) AS sclr_0
FROM
  reviews r0_
WHERE
  r0_.product_id = ?
  AND r0_.status = 1

SELECT avg(r0_.rating) AS sclr_0 FROM reviews r0_ WHERE r0_.product_id = 3307 AND r0_.status = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.product_code AS product_code_3,
  t0.description AS description_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.url AS url_7,
  t0.weight AS weight_8,
  t0.min_amount AS min_amount_9,
  t0.price_netto AS price_netto_10,
  t0.vat AS vat_11,
  t0.promotional_price AS promotional_price_12,
  t0.homepage AS homepage_13,
  t0.recommended AS recommended_14,
  t0.new AS new_15,
  t0.active AS active_16,
  t0.calculator AS calculator_17,
  t0.supplier_product_id AS supplier_product_id_18,
  t0.bestseller AS bestseller_19,
  t0.final_price AS final_price_20,
  t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21,
  t0.supplier_id AS supplier_id_22,
  t0.main_category_id AS main_category_id_23,
  t0.price_factor_id AS price_factor_id_24,
  t0.handling_cost_id AS handling_cost_id_25,
  t0.main_product_variant_file_id AS main_product_variant_file_id_26,
  t0.canonical_variant_id AS canonical_variant_id_27
FROM
  product t0
WHERE
  t0.main_category_id = ?
LIMIT
  8

SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.main_category_id = 88 LIMIT 8;