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 = 'a boire' LIMIT 1;

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 = 14 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.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.id = 50;

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 = 50 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.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.id = 139;

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 = 139;

SELECT 
  t0.id AS id_1, 
  t0.date_created AS date_created_2, 
  t0.name AS name_3, 
  t0.url_name AS url_name_4, 
  t0.description AS description_5, 
  t0.logo_id AS logo_id_6, 
  t0.banner_id AS banner_id_7 
FROM 
  company_association t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.description AS description_5, t0.logo_id AS logo_id_6, t0.banner_id AS banner_id_7 FROM company_association t0 WHERE t0.id = 21 LIMIT 1;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 139 OR p0_.sub_category_id = 139 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.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 = 50;

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 = 55;

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 = 56;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 50 OR p0_.sub_category_id = 50 OR p0_.sub_category_id IN (55, 56, 139)) 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.placement ASC;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 55 OR p0_.sub_category_id = 55 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.placement ASC;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 50 OR p0_.sub_category_id = 50 OR p0_.sub_category_id IN (55, 56, 139)) 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.placement ASC;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 56 OR p0_.sub_category_id = 56 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.placement ASC;

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 category c3_ ON p0_.sub_category_id = c3_.id 
  LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id 
  LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id 
  LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id 
  LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id 
  LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_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 
  AND c7_.url_name = ? 
ORDER BY 
  c3_.placement ASC

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 category c3_ ON p0_.sub_category_id = c3_.id LEFT JOIN category c4_ ON c3_.sub_category_id = c4_.id LEFT JOIN pricing_product p6_ ON p0_.id = p6_.product_id LEFT JOIN pricing p5_ ON p5_.id = p6_.pricing_id LEFT JOIN company_association_company c8_ ON c1_.id = c8_.company_id LEFT JOIN company_association c7_ ON c7_.id = c8_.company_association_id WHERE (p0_.categories_id = 50 OR p0_.sub_category_id = 50 OR p0_.sub_category_id IN (55, 56, 139)) 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 AND c7_.url_name = 'aliment-snack' ORDER BY c3_.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.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.id = 41;

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 = 41 AND c0_.placement > 0 ORDER BY c0_.placement ASC;