Symfony Profiler

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.promoted AS promoted_2
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug LIKE CONCAT('%', ?, '%')
  AND p0_.public = ?
ORDER BY
  p0_.updated_at DESC,
  p0_.promoted DESC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.promoted AS promoted_2 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', 'Srodki-ochrony-roslin', '%') AND p0_.public = 1 ORDER BY p0_.updated_at DESC, p0_.promoted DESC LIMIT 30;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug LIKE CONCAT('%', ?, '%')
  AND p0_.public = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', 'Srodki-ochrony-roslin', '%') AND p0_.public = 1;