Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.commission AS commission_5,
  t0.for_product_type AS for_product_type_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  flexy_categoryproduct t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.id = '4';

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN article a1_ ON p0_.id = a1_.id
  LEFT JOIN shop_product s2_ ON p0_.id = s2_.id
  LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id
  LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id
WHERE
  f3_.id = 4
  AND p0_.is_published = 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id WHERE f3_.id = 4 AND p0_.is_published = 1;

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN article a1_ ON p0_.id = a1_.id
  LEFT JOIN shop_product s2_ ON p0_.id = s2_.id
  LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id
  LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id
WHERE
  f3_.id = 4
  AND p0_.is_published = 1
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id LEFT JOIN product_category_product p4_ ON p0_.id = p4_.product_id LEFT JOIN flexy_categoryproduct f3_ ON f3_.id = p4_.category_product_id WHERE f3_.id = 4 AND p0_.is_published = 1 LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.commission AS commission_5,
  t0.for_product_type AS for_product_type_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  flexy_categoryproduct t0
WHERE
  t0.parent_category_id IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.lien AS lien_3,
  t0.emplacement AS emplacement_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_text_white AS is_text_white_6,
  t0.petit_titre AS petit_titre_7,
  t0.grand_titre AS grand_titre_8,
  t0.texte_prix AS texte_prix_9,
  t0.titre_btn AS titre_btn_10
FROM
  pub_banner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.lien AS lien_3, t0.emplacement AS emplacement_4, t0.is_enabled AS is_enabled_5, t0.is_text_white AS is_text_white_6, t0.petit_titre AS petit_titre_7, t0.grand_titre AS grand_titre_8, t0.texte_prix AS texte_prix_9, t0.titre_btn AS titre_btn_10 FROM pub_banner t0 WHERE t0.id = '8';