Symfony Profiler

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 = 266 AND t0.type IN ('SIMPLE', 'VARIANT');

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 (266);

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.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 = 122;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.perex AS perex_2,
  c0_.description AS description_3,
  c0_.website AS website_4,
  c0_.og_title AS og_title_5,
  c0_.og_description AS og_description_6,
  c0_.active AS active_7,
  c0_.deleted AS deleted_8
FROM
  catalogue_producer c0_
  INNER JOIN catalogue_product c1_ ON c0_.id = c1_.producer_id
  AND c1_.type IN ('SIMPLE', 'VARIANT')
  INNER JOIN category_product c2_ ON c1_.id = c2_.product_id
  INNER JOIN category c3_ ON c2_.category_id = c3_.id
WHERE
  c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.title ASC

SELECT DISTINCT c0_.id AS id_0, c0_.title AS title_1, c0_.perex AS perex_2, c0_.description AS description_3, c0_.website AS website_4, c0_.og_title AS og_title_5, c0_.og_description AS og_description_6, c0_.active AS active_7, c0_.deleted AS deleted_8 FROM catalogue_producer c0_ INNER JOIN catalogue_product c1_ ON c0_.id = c1_.producer_id AND c1_.type IN ('SIMPLE', 'VARIANT') INNER JOIN category_product c2_ ON c1_.id = c2_.product_id INNER JOIN category c3_ ON c2_.category_id = c3_.id WHERE c3_.id IN (103, 104, 105, 106, 108, 109, 110, 112) ORDER BY c0_.title ASC;

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.category_id = ?
ORDER BY
  t0.featured DESC,
  t0.sort ASC

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.category_id = 104 ORDER BY t0.featured DESC, t0.sort ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.perex AS perex_2,
  c0_.description AS description_3,
  c0_.price AS price_4,
  c0_.promotional_price AS promotional_price_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_.type AS type_10,
  c0_.producer_id AS producer_id_11,
  c0_.availability_id AS availability_id_12,
  c0_.unit_id AS unit_id_13,
  c0_.vat_id AS vat_id_14,
  c0_.product_type_id AS product_type_id_15
FROM
  catalogue_product c0_
  INNER JOIN category_product c1_ ON c0_.id = c1_.product_id
  INNER JOIN category c2_ ON c1_.category_id = c2_.id
WHERE
  (
    c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
    AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND c0_.type IN ('SIMPLE', 'VARIANT')

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.perex AS perex_2, c0_.description AS description_3, c0_.price AS price_4, c0_.promotional_price AS promotional_price_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_.type AS type_10, c0_.producer_id AS producer_id_11, c0_.availability_id AS availability_id_12, c0_.unit_id AS unit_id_13, c0_.vat_id AS vat_id_14, c0_.product_type_id AS product_type_id_15 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (103, 104, 105, 106, 108, 109, 110, 112) AND c0_.id IN (397, 398, 399, 400, 416, 122, 198, 199, 200, 201, 202, 203)) AND c0_.type IN ('SIMPLE', 'VARIANT');

SELECT
  c0_.id AS id_0
FROM
  category c0_
WHERE
  c0_.lft >= ?
  AND c0_.rgt <= ?

SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft >= 202 AND c0_.rgt <= 217;

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
  FLOOR(
    MIN(c0_.price)
  ) AS sclr_0,
  CEIL(
    MAX(c0_.price)
  ) AS sclr_1
FROM
  category c1_
  INNER JOIN category_product c2_ ON c1_.id = c2_.category_id
  INNER JOIN catalogue_product c0_ ON c2_.product_id = c0_.id
  AND c0_.type IN ('SIMPLE', 'VARIANT')
WHERE
  c1_.lft >= ?
  AND c1_.rgt <= ?

SELECT FLOOR(MIN(c0_.price)) AS sclr_0, CEIL(MAX(c0_.price)) AS sclr_1 FROM category c1_ INNER JOIN category_product c2_ ON c1_.id = c2_.category_id INNER JOIN catalogue_product c0_ ON c2_.product_id = c0_.id AND c0_.type IN ('SIMPLE', 'VARIANT') WHERE c1_.lft >= 202 AND c1_.rgt <= 217;

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 (122, 198, 199, 200, 201, 202, 203, 397, 398, 399, 400, 416);

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

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.id = '103';

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  catalogue_product c0_
  INNER JOIN category_product c1_ ON c0_.id = c1_.product_id
  INNER JOIN category c2_ ON c1_.category_id = c2_.id
WHERE
  (
    c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND c0_.type IN ('SIMPLE', 'VARIANT')

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (103, 104, 105, 106, 108, 109, 110, 112)) AND c0_.type IN ('SIMPLE', 'VARIANT');

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.rate AS rate_4,
  t0.active AS active_5,
  t0.main AS main_6,
  t0.deleted AS deleted_7
FROM
  setup_vat t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.rate AS rate_4, t0.active AS active_5, t0.main AS main_6, t0.deleted AS deleted_7 FROM setup_vat t0 WHERE t0.id IN (1);

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 <= 202
  AND c0_.rgt >= 217
  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 <= 202 AND c0_.rgt >= 217 AND c0_.tree_root = 2 ORDER BY c0_.lft ASC;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  catalogue_product c0_
  INNER JOIN category_product c1_ ON c0_.id = c1_.product_id
  INNER JOIN category c2_ ON c1_.category_id = c2_.id
WHERE
  (
    c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND c0_.type IN ('SIMPLE', 'VARIANT')
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0 FROM catalogue_product c0_ INNER JOIN category_product c1_ ON c0_.id = c1_.product_id INNER JOIN category c2_ ON c1_.category_id = c2_.id WHERE (c2_.id IN (103, 104, 105, 106, 108, 109, 110, 112)) AND c0_.type IN ('SIMPLE', 'VARIANT') LIMIT 12;

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
  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';