Symfony Profiler

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

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 >= 94 AND c0_.rgt <= 123;

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 (12, 23, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81) ORDER BY c0_.title ASC;

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 >= 94 AND c1_.rgt <= 123;

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 >= 94 AND c0_.rgt <= 123;

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 (12, 23, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81)) AND c0_.type IN ('SIMPLE', 'VARIANT');

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
OFFSET
  48

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 (12, 23, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81)) AND c0_.type IN ('SIMPLE', 'VARIANT') LIMIT 12 OFFSET 48;

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 (12, 23, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81) AND c0_.id IN (433, 226, 305)) 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
  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 (226, 305, 433);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.active AS active_3,
  t0.deleted AS deleted_4
FROM
  catalogue_product_type t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.deleted AS deleted_4 FROM catalogue_product_type t0 WHERE t0.id IN (1);

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.deleted AS deleted_3,
  t0.product_type_id AS product_type_id_4,
  t0.parameter_id AS parameter_id_5,
  t6.id AS id_7,
  t6.title AS title_8,
  t6.type AS type_9,
  t6.active AS active_10,
  t6.deleted AS deleted_11,
  t6.unit_id AS unit_id_12
FROM
  catalogue_product_type_parameter t0
  INNER JOIN catalogue_parameter t6 ON t0.parameter_id = t6.id
WHERE
  t0.product_type_id IN (?)

SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted AS deleted_3, t0.product_type_id AS product_type_id_4, t0.parameter_id AS parameter_id_5, t6.id AS id_7, t6.title AS title_8, t6.type AS type_9, t6.active AS active_10, t6.deleted AS deleted_11, t6.unit_id AS unit_id_12 FROM catalogue_product_type_parameter t0 INNER JOIN catalogue_parameter t6 ON t0.parameter_id = t6.id WHERE t0.product_type_id IN (1);

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.active AS active_3,
  t0.deleted AS deleted_4,
  t0.parameter_id AS parameter_id_5
FROM
  catalogue_parameter_value t0
WHERE
  t0.parameter_id IN (?)

SELECT t0.id AS id_1, t0.value AS value_2, t0.active AS active_3, t0.deleted AS deleted_4, t0.parameter_id AS parameter_id_5 FROM catalogue_parameter_value t0 WHERE t0.parameter_id IN (1);

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 (12, 23, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81) ORDER BY c0_.title 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 <= 94
  AND c0_.rgt >= 123
  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 <= 94 AND c0_.rgt >= 123 AND c0_.tree_root = 2 ORDER BY c0_.lft ASC;

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

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.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.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.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 = 2 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 = ?
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 = 3 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 = ?
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 = 4 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 = ?
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 = 5 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 = ?
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 = 12 ORDER BY t0.lft 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 = 23 ORDER BY t0.featured DESC, t0.sort 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')