Symfony Profiler

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  navigation n0_
WHERE
  n0_.position = ?

SELECT COUNT(n0_.id) AS sclr_0 FROM navigation n0_ WHERE n0_.position = 'HEADER';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.lft AS lft_4,
  t0.lvl AS lvl_5,
  t0.rgt AS rgt_6,
  t0.og_title AS og_title_7,
  t0.og_description AS og_description_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.tree_root AS tree_root_11,
  t0.parent_id AS parent_id_12
FROM
  category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = 1 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.perex AS perex_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.promotional_price AS promotional_price_6,
  t0.og_title AS og_title_7,
  t0.og_description AS og_description_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.producer_id AS producer_id_11,
  t13.id AS id_12,
  t13.title AS title_14,
  t13.perex AS perex_15,
  t13.description AS description_16,
  t13.website AS website_17,
  t13.og_title AS og_title_18,
  t13.og_description AS og_description_19,
  t13.active AS active_20,
  t13.deleted AS deleted_21,
  t0.availability_id AS availability_id_22,
  t24.id AS id_23,
  t24.title AS title_25,
  t24.description AS description_26,
  t24.type AS type_27,
  t24.days AS days_28,
  t24.active AS active_29,
  t24.main AS main_30,
  t24.deleted AS deleted_31,
  t0.unit_id AS unit_id_32,
  t34.id AS id_33,
  t34.title AS title_35,
  t34.shortcut AS shortcut_36,
  t34.active AS active_37,
  t34.main AS main_38,
  t34.deleted AS deleted_39,
  t0.vat_id AS vat_id_40,
  t42.id AS id_41,
  t42.title AS title_43,
  t42.type AS type_44,
  t42.rate AS rate_45,
  t42.active AS active_46,
  t42.main AS main_47,
  t42.deleted AS deleted_48,
  t0.product_type_id AS product_type_id_49,
  t51.id AS id_50,
  t51.title AS title_52,
  t51.active AS active_53,
  t51.deleted AS deleted_54,
  t0.type
FROM
  catalogue_product t0
  LEFT JOIN catalogue_producer t13 ON t0.producer_id = t13.id
  LEFT JOIN setup_availability t24 ON t0.availability_id = t24.id
  LEFT JOIN setup_unit t34 ON t0.unit_id = t34.id
  LEFT JOIN setup_vat t42 ON t0.vat_id = t42.id
  LEFT JOIN catalogue_product_type t51 ON t0.product_type_id = t51.id
WHERE
  t0.id = ?
  AND t0.type IN ('SIMPLE', 'VARIANT')

SELECT t0.id AS id_1, t0.title AS title_2, t0.perex AS perex_3, t0.description AS description_4, t0.price AS price_5, t0.promotional_price AS promotional_price_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.producer_id AS producer_id_11, t13.id AS id_12, t13.title AS title_14, t13.perex AS perex_15, t13.description AS description_16, t13.website AS website_17, t13.og_title AS og_title_18, t13.og_description AS og_description_19, t13.active AS active_20, t13.deleted AS deleted_21, t0.availability_id AS availability_id_22, t24.id AS id_23, t24.title AS title_25, t24.description AS description_26, t24.type AS type_27, t24.days AS days_28, t24.active AS active_29, t24.main AS main_30, t24.deleted AS deleted_31, t0.unit_id AS unit_id_32, t34.id AS id_33, t34.title AS title_35, t34.shortcut AS shortcut_36, t34.active AS active_37, t34.main AS main_38, t34.deleted AS deleted_39, t0.vat_id AS vat_id_40, t42.id AS id_41, t42.title AS title_43, t42.type AS type_44, t42.rate AS rate_45, t42.active AS active_46, t42.main AS main_47, t42.deleted AS deleted_48, t0.product_type_id AS product_type_id_49, t51.id AS id_50, t51.title AS title_52, t51.active AS active_53, t51.deleted AS deleted_54, t0.type FROM catalogue_product t0 LEFT JOIN catalogue_producer t13 ON t0.producer_id = t13.id LEFT JOIN setup_availability t24 ON t0.availability_id = t24.id LEFT JOIN setup_unit t34 ON t0.unit_id = t34.id LEFT JOIN setup_vat t42 ON t0.vat_id = t42.id LEFT JOIN catalogue_product_type t51 ON t0.product_type_id = t51.id WHERE t0.id = '504' AND t0.type IN ('SIMPLE', 'VARIANT');

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.deleted AS deleted_3,
  t0.navigation_id AS navigation_id_4,
  t5.id AS id_6,
  t5.position AS position_7,
  t5.title AS title_8,
  t5.active AS active_9,
  t5.deleted AS deleted_10,
  t0.category_id AS category_id_11,
  t12.id AS id_13,
  t12.title AS title_14,
  t12.description AS description_15,
  t12.lft AS lft_16,
  t12.lvl AS lvl_17,
  t12.rgt AS rgt_18,
  t12.og_title AS og_title_19,
  t12.og_description AS og_description_20,
  t12.active AS active_21,
  t12.deleted AS deleted_22,
  t12.tree_root AS tree_root_23,
  t12.parent_id AS parent_id_24
FROM
  navigation_category t0
  INNER JOIN navigation t5 ON t0.navigation_id = t5.id
  INNER JOIN category t12 ON t0.category_id = t12.id
WHERE
  t0.navigation_id IN (?)

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.deleted AS deleted_3, t0.navigation_id AS navigation_id_4, t5.id AS id_6, t5.position AS position_7, t5.title AS title_8, t5.active AS active_9, t5.deleted AS deleted_10, t0.category_id AS category_id_11, t12.id AS id_13, t12.title AS title_14, t12.description AS description_15, t12.lft AS lft_16, t12.lvl AS lvl_17, t12.rgt AS rgt_18, t12.og_title AS og_title_19, t12.og_description AS og_description_20, t12.active AS active_21, t12.deleted AS deleted_22, t12.tree_root AS tree_root_23, t12.parent_id AS parent_id_24 FROM navigation_category t0 INNER JOIN navigation t5 ON t0.navigation_id = t5.id INNER JOIN category t12 ON t0.category_id = t12.id WHERE t0.navigation_id IN (1);

SELECT
  t0.id AS id_1,
  t0.featured AS featured_2,
  t0.sort AS sort_3,
  t0.category_id AS category_id_4,
  t5.id AS id_6,
  t5.title AS title_7,
  t5.description AS description_8,
  t5.lft AS lft_9,
  t5.lvl AS lvl_10,
  t5.rgt AS rgt_11,
  t5.og_title AS og_title_12,
  t5.og_description AS og_description_13,
  t5.active AS active_14,
  t5.deleted AS deleted_15,
  t5.tree_root AS tree_root_16,
  t5.parent_id AS parent_id_17,
  t0.product_id AS product_id_18
FROM
  category_product t0
  INNER JOIN category t5 ON t0.category_id = t5.id
WHERE
  t0.product_id IN (?)

SELECT t0.id AS id_1, t0.featured AS featured_2, t0.sort AS sort_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.title AS title_7, t5.description AS description_8, t5.lft AS lft_9, t5.lvl AS lvl_10, t5.rgt AS rgt_11, t5.og_title AS og_title_12, t5.og_description AS og_description_13, t5.active AS active_14, t5.deleted AS deleted_15, t5.tree_root AS tree_root_16, t5.parent_id AS parent_id_17, t0.product_id AS product_id_18 FROM category_product t0 INNER JOIN category t5 ON t0.category_id = t5.id WHERE t0.product_id IN (504);

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.description AS description_2,
  c0_.lft AS lft_3,
  c0_.lvl AS lvl_4,
  c0_.rgt AS rgt_5,
  c0_.og_title AS og_title_6,
  c0_.og_description AS og_description_7,
  c0_.active AS active_8,
  c0_.deleted AS deleted_9,
  c0_.tree_root AS tree_root_10,
  c0_.parent_id AS parent_id_11
FROM
  category c0_
WHERE
  c0_.lft <= 75
  AND c0_.rgt >= 76
  AND c0_.tree_root = ?
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.og_title AS og_title_6, c0_.og_description AS og_description_7, c0_.active AS active_8, c0_.deleted AS deleted_9, c0_.tree_root AS tree_root_10, c0_.parent_id AS parent_id_11 FROM category c0_ WHERE c0_.lft <= 75 AND c0_.rgt >= 76 AND c0_.tree_root = 2 ORDER BY c0_.lft ASC;

SELECT
  n0_.id AS id_0,
  n0_.position AS position_1,
  n0_.title AS title_2,
  n0_.active AS active_3,
  n0_.deleted AS deleted_4
FROM
  navigation n0_
WHERE
  n0_.position = ?

SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.title AS title_2, n0_.active AS active_3, n0_.deleted AS deleted_4 FROM navigation n0_ WHERE n0_.position = 'TOP';

SELECT
  t0.id AS id_1,
  t0.filepath AS filepath_2,
  t0.filename AS filename_3,
  t0.type AS type_4,
  t0.thumbnail_type AS thumbnail_type_5,
  t0.size AS size_6,
  t0.thumbnail AS thumbnail_7,
  t0.sort AS sort_8,
  t0.active AS active_9,
  t0.main AS main_10,
  t0.product_id AS product_id_11,
  t0.product_variant_id AS product_variant_id_12,
  t0.producer_id AS producer_id_13
FROM
  image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.filename AS filename_3, t0.type AS type_4, t0.thumbnail_type AS thumbnail_type_5, t0.size AS size_6, t0.thumbnail AS thumbnail_7, t0.sort AS sort_8, t0.active AS active_9, t0.main AS main_10, t0.product_id AS product_id_11, t0.product_variant_id AS product_variant_id_12, t0.producer_id AS producer_id_13 FROM image t0 WHERE t0.product_id = 504;