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 = ?

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 = 15343;

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 = 'EMAIL' 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 = 'LANDLINE_PHONE' 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 = 'MOBILE_PHONE' 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 = 'FAX_PHONE' LIMIT 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.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 = 3447;

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.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_TO' 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 = 'LANDLINE_PHONE' 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 = 'MOBILE_PHONE' 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 = 'EMAIL' 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_TEXT' 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_COLOR_TEXT' 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_COLOR_BG' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.left_side AS left_side_6,
  t0.right_side AS right_side_7,
  t0.level AS level_8,
  t0.active AS active_9,
  t0.url AS url_10,
  t0.visible_in_horizontal_menu AS visible_in_horizontal_menu_11,
  t0.visible_in_footer AS visible_in_footer_12,
  t0.short_description AS short_description_13,
  t0.parent_id AS parent_id_14,
  t0.price_factor_id AS price_factor_id_15
FROM
  category t0
WHERE
  t0.active = ?
ORDER BY
  t0.left_side ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.left_side AS left_side_6, t0.right_side AS right_side_7, t0.level AS level_8, t0.active AS active_9, t0.url AS url_10, t0.visible_in_horizontal_menu AS visible_in_horizontal_menu_11, t0.visible_in_footer AS visible_in_footer_12, t0.short_description AS short_description_13, t0.parent_id AS parent_id_14, t0.price_factor_id AS price_factor_id_15 FROM category t0 WHERE t0.active = 1 ORDER BY t0.left_side ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.left_side AS left_side_5,
  c0_.right_side AS right_side_6,
  c0_.level AS level_7,
  c0_.active AS active_8,
  c0_.url AS url_9,
  c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10,
  c0_.visible_in_footer AS visible_in_footer_11,
  c0_.short_description AS short_description_12,
  c0_.parent_id AS parent_id_13,
  c0_.price_factor_id AS price_factor_id_14
FROM
  category c0_
WHERE
  c0_.level >= 1
  AND c0_.level <= 3
  AND c0_.active = 1
  AND c0_.visible_in_horizontal_menu = 1
ORDER BY
  c0_.left_side ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.left_side AS left_side_5, c0_.right_side AS right_side_6, c0_.level AS level_7, c0_.active AS active_8, c0_.url AS url_9, c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10, c0_.visible_in_footer AS visible_in_footer_11, c0_.short_description AS short_description_12, c0_.parent_id AS parent_id_13, c0_.price_factor_id AS price_factor_id_14 FROM category c0_ WHERE c0_.level >= 1 AND c0_.level <= 3 AND c0_.active = 1 AND c0_.visible_in_horizontal_menu = 1 ORDER BY c0_.left_side ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.left_side AS left_side_5,
  c0_.right_side AS right_side_6,
  c0_.level AS level_7,
  c0_.active AS active_8,
  c0_.url AS url_9,
  c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10,
  c0_.visible_in_footer AS visible_in_footer_11,
  c0_.short_description AS short_description_12,
  c0_.parent_id AS parent_id_13,
  c0_.price_factor_id AS price_factor_id_14
FROM
  category c0_
WHERE
  c0_.active = 1
  AND c0_.visible_in_footer = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.left_side AS left_side_5, c0_.right_side AS right_side_6, c0_.level AS level_7, c0_.active AS active_8, c0_.url AS url_9, c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10, c0_.visible_in_footer AS visible_in_footer_11, c0_.short_description AS short_description_12, c0_.parent_id AS parent_id_13, c0_.price_factor_id AS price_factor_id_14 FROM category c0_ WHERE c0_.active = 1 AND c0_.visible_in_footer = 1;