Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = 'boucherie' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = 15;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = 58;

SELECT 
  c0_.id AS id_0, 
  c0_.placement AS placement_1, 
  c0_.name AS name_2 
FROM 
  category c0_ 
WHERE 
  c0_.sub_category_id = ? 
  AND c0_.placement > 0 
ORDER BY 
  c0_.placement ASC

SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = 219 AND c0_.placement > 0 ORDER BY c0_.placement ASC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.placement AS placement_3, 
  t0.title AS title_4, 
  t0.description AS description_5, 
  t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, 
  t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, 
  t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, 
  t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, 
  t0.packing_fees_amount AS packing_fees_amount_10, 
  t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, 
  t0.meta_description AS meta_description_12, 
  t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, 
  t0.sub_category_id AS sub_category_id_14, 
  t0.image_id AS image_id_15, 
  t0.banner_id AS banner_id_16 
FROM 
  category t0 
WHERE 
  t0.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = 219;

SELECT 
  p0_.id AS id_0, 
  c1_.id AS id_1, 
  (
    SELECT 
      COUNT(*) 
    FROM 
      cart_product c2_ 
    WHERE 
      c2_.product_id = p0_.id
  ) AS sclr_2, 
  c3_.id AS id_3, 
  c3_.placement AS placement_4, 
  c3_.name AS name_5, 
  c4_.placement AS placement_6, 
  c4_.name AS name_7 
FROM 
  product p0_ 
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id 
  LEFT JOIN company_location c5_ ON c1_.main_location_id = c5_.id 
  LEFT JOIN region r6_ ON c5_.region_id = r6_.id 
  LEFT JOIN diet_product d8_ ON p0_.id = d8_.product_id 
  LEFT JOIN diet d7_ ON d7_.id = d8_.diet_id 
  LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN certification_product c10_ ON p0_.id = c10_.product_id 
  LEFT JOIN certification c9_ ON c9_.id = c10_.certification_id 
  LEFT JOIN conservation c11_ ON p0_.conservation_id = c11_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p13_ ON p0_.id = p13_.product_id 
  LEFT JOIN pricing p12_ ON p12_.id = p13_.pricing_id 
WHERE 
  (
    p0_.categories_id = ? 
    OR p0_.sub_category_id = ? 
    OR p0_.sub_category_id IN (?)
  ) 
  AND p0_.draft <> 1 
  AND p0_.main_image_id IS NOT NULL 
  AND p0_.available = 1 
  AND p0_.is_displayed_in_association_only = 0 
  AND c3_.placement > 0 
  AND c4_.placement > 0 
  AND p0_.is_hri = 0 
  AND p0_.is_consumer = 1 
  AND c1_.show_publicly = 1 
  AND p0_.qty_ready_to_ship > 0 
ORDER BY 
  (
    SELECT 
      COUNT(*) 
    FROM 
      cart_product c2_ 
    WHERE 
      c2_.product_id = p0_.id
  ) DESC

SELECT p0_.id AS id_0, c1_.id AS id_1, (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) AS sclr_2, c3_.id AS id_3, c3_.placement AS placement_4, c3_.name AS name_5, c4_.placement AS placement_6, c4_.name AS name_7 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN company_location c5_ ON c1_.main_location_id = c5_.id LEFT JOIN region r6_ ON c5_.region_id = r6_.id LEFT JOIN diet_product d8_ ON p0_.id = d8_.product_id LEFT JOIN diet d7_ ON d7_.id = d8_.diet_id LEFT JOIN category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN certification_product c10_ ON p0_.id = c10_.product_id LEFT JOIN certification c9_ ON c9_.id = c10_.certification_id LEFT JOIN conservation c11_ ON p0_.conservation_id = c11_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p13_ ON p0_.id = p13_.product_id LEFT JOIN pricing p12_ ON p12_.id = p13_.pricing_id WHERE (p0_.categories_id = 219 OR p0_.sub_category_id = 219 OR p0_.sub_category_id IN ()) AND p0_.draft <> 1 AND p0_.main_image_id IS NOT NULL AND p0_.available = 1 AND p0_.is_displayed_in_association_only = 0 AND c3_.placement > 0 AND c4_.placement > 0 AND p0_.is_hri = 0 AND p0_.is_consumer = 1 AND c1_.show_publicly = 1 AND p0_.qty_ready_to_ship > 0 ORDER BY (SELECT COUNT(*) FROM cart_product c2_ WHERE c2_.product_id = p0_.id) DESC;