Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c1_.id AS id_2
FROM
  categories c0_
  LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id
WHERE
  c0_.parent_id = ?
  AND c0_.is_suspended = 0

SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 885 AND c0_.is_suspended = 0;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.title AS title_1
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.price_pdv > 0
ORDER BY
  p0_.title ASC
LIMIT
  20 OFFSET 3460

SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 1270, 1271, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1272, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1291, 1292, 1273, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 3460;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 12465;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.price_pdv > 0

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 1270, 1271, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1272, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1291, 1292, 1273, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301) AND p0_.price_pdv > 0;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1
FROM
  categories c0_
WHERE
  c0_.is_suspended = 0
  AND c0_.parent_id = ?
ORDER BY
  c0_.title ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = 885 ORDER BY c0_.title ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.sku AS sku_2,
  p0_.barcode AS barcode_3,
  p0_.product_key AS product_key_4,
  p0_.price_pdv AS price_pdv_5,
  p0_.price AS price_6,
  p0_.vat AS vat_7,
  p0_.is_out_of_stock AS is_out_of_stock_8,
  p0_.is_new AS is_new_9,
  p0_.is_discount AS is_discount_10,
  p0_.is_super_product AS is_super_product_11,
  p0_.is_outlet AS is_outlet_12,
  p0_.is_suspended AS is_suspended_13,
  c1_.title AS title_14,
  i2_.thumbnail_100x100 AS thumbnail_100x100_15,
  i2_.thumbnail_500x500 AS thumbnail_500x500_16
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.price_pdv > 0
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.title ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 1270, 1271, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1272, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1291, 1292, 1273, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1300, 1301) AND p0_.price_pdv > 0 AND p0_.id IN (12465, 12260, 12263, 12261, 12262, 10670, 10486, 12071, 12509, 11455, 12072, 38578, 13792, 18686, 34479, 11994, 11995, 11996, 11997, 11990) ORDER BY p0_.title ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1
FROM
  categories c0_
WHERE
  c0_.is_suspended = 0
  AND c0_.parent_id = ?
ORDER BY
  c0_.title ASC

SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = 885 ORDER BY c0_.title ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title2 AS title2_3,
  t0.title3 AS title3_4,
  t0.is_suspended AS is_suspended_5,
  t0.description AS description_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.edit_by_id AS edit_by_id_12,
  t0.parent_id AS parent_id_13,
  t0.choice_id AS choice_id_14
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = '885';