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 = 'bien-etre-lubrifiant-creme-masturbation' 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 = 83;

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
  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 (174)
  )
  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 (174))
                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 (174)
  )
  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 (174))
                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 (174)
  )
  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 (174))
                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 (174)
  )
  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 (174))
                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 (174)
  )
  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 (174))
            AND b.id = p.brand_id
            AND p.active = 1
            AND p.valid = 1
            ORDER BY b.name ASC
        ;