Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.link = 'poppers' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.link AS link_4,
  t0.position AS position_5,
  t0.title AS title_6,
  t0.icon AS icon_7,
  t0.thumbnail AS thumbnail_8,
  t0.image AS image_9,
  t0.margin AS margin_10,
  t0.description AS description_11,
  t0.parent_id AS parent_id_12
FROM
  categories t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 WHERE t0.parent_id = 80;

SELECT
  COUNT(DISTINCT p.reference) as nbProducts,
  min(pr.price) as priceMin,
  max(pr.price) as priceMax
FROM
  `products` as p
  INNER JOIN prices as pr
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (145, 146, 147, 148, 159, 177)
  )
  AND p.id = pr.product_id
  AND pr.selected = 1
  AND p.active = 1
  AND p.valid = 1

SELECT COUNT(DISTINCT p.reference) as nbProducts, min(pr.price) as priceMin, max(pr.price) as priceMax 
                FROM `products` as p
                INNER JOIN prices as pr
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (145,146,147,148,159,177))
                AND p.id = pr.product_id
                AND pr.selected = 1
                AND p.active = 1
                AND p.valid = 1;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  `products` as p
  INNER JOIN product_features as pf
  INNER JOIN features_lines as fl
  INNER JOIN features_list as flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (145, 146, 147, 148, 159, 177)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Couleur'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM `products` as p
                INNER JOIN product_features as pf
                INNER JOIN features_lines as fl
                INNER JOIN features_list as flist
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (145,146,147,148,159,177))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id 
                AND flist.feature = 'Couleur'
                ORDER BY fl.value ASC;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  products p
  INNER JOIN product_features pf
  INNER JOIN features_lines fl
  INNER JOIN features_list flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (145, 146, 147, 148, 159, 177)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Taille'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM products p 
                INNER JOIN product_features pf 
                INNER JOIN features_lines fl 
                INNER JOIN features_list flist 
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (145,146,147,148,159,177))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id 
                AND flist.feature = 'Taille'
                ORDER BY fl.value ASC;

SELECT
  distinct fl.id as id,
  fl.value as name,
  fl.data as code
FROM
  products p
  INNER JOIN product_features pf
  INNER JOIN features_lines fl
  INNER JOIN features_list flist
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (145, 146, 147, 148, 159, 177)
  )
  AND pf.product_id = p.id
  AND pf.feature_line_id = fl.id
  AND p.active = 1
  AND p.valid = 1
  AND flist.id = fl.attribute_id
  AND flist.feature = 'Matière'
ORDER BY
  fl.value ASC

SELECT distinct fl.id as id, fl.value as name, fl.data as code
                FROM products p 
                INNER JOIN product_features pf 
                INNER JOIN features_lines fl 
                INNER JOIN features_list flist 
                WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (145,146,147,148,159,177))
                AND pf.product_id = p.id 
                AND pf.feature_line_id = fl.id 
                AND p.active = 1 
                AND p.valid = 1
                AND flist.id = fl.attribute_id
                AND flist.feature = 'Matière'
                ORDER BY fl.value ASC;

SELECT
  distinct b.id,
  b.name
FROM
  products p
  INNER JOIN brand b
WHERE
  p.id IN (
    SELECT
      products_id
    FROM
      categories_products
    WHERE
      categories_id IN (145, 146, 147, 148, 159, 177)
  )
  AND b.id = p.brand_id
  AND p.active = 1
  AND p.valid = 1
ORDER BY
  b.name ASC

SELECT distinct b.id, b.name
            FROM products p
            INNER JOIN brand b
            WHERE p.id IN (SELECT products_id FROM categories_products WHERE categories_id IN (145,146,147,148,159,177))
            AND b.id = p.brand_id
            AND p.active = 1
            AND p.valid = 1
            ORDER BY b.name ASC
        ;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.content AS content_3,
  p0_.created_at AS created_at_4,
  p0_.active AS active_5,
  p0_.code_ean AS code_ean_6,
  p0_.last_modification AS last_modification_7,
  p0_.old_price AS old_price_8,
  p0_.promo AS promo_9,
  p0_.top AS top_10,
  p0_.weight AS weight_11,
  p0_.reference AS reference_12,
  p0_.valid AS valid_13,
  p0_.tvarate AS tvarate_14,
  (
    CASE WHEN SUM(s1_.quantity) > 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_15,
  p0_.brand_id AS brand_id_16
FROM
  products p0_
  INNER JOIN stock s1_ ON (s1_.product_id = p0_.id)
  INNER JOIN categories_products c2_
WHERE
  c2_.categories_id IN (?, ?, ?, ?, ?, ?)
  AND c2_.products_id = p0_.id
  AND p0_.active = 1
  AND p0_.valid = 1
GROUP BY
  p0_.reference
ORDER BY
  sclr_15 DESC,
  p0_.name ASC
LIMIT
  24
OFFSET
  48

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.active AS active_5, p0_.code_ean AS code_ean_6, p0_.last_modification AS last_modification_7, p0_.old_price AS old_price_8, p0_.promo AS promo_9, p0_.top AS top_10, p0_.weight AS weight_11, p0_.reference AS reference_12, p0_.valid AS valid_13, p0_.tvarate AS tvarate_14, (CASE WHEN SUM(s1_.quantity) > 0 THEN 1 ELSE 0 END) AS sclr_15, p0_.brand_id AS brand_id_16 FROM products p0_ INNER JOIN stock s1_ ON (s1_.product_id = p0_.id) INNER JOIN categories_products c2_ WHERE c2_.categories_id IN ('145', '146', '147', '148', '159', '177') AND c2_.products_id = p0_.id AND p0_.active = 1 AND p0_.valid = 1 GROUP BY p0_.reference ORDER BY sclr_15 DESC, p0_.name ASC LIMIT 24 OFFSET 48;