Symfony Profiler

SELECT
  p.id_product AS id_product,
  p.id_category_default AS category_default,
  p.reference AS reference,
  l.link_rewrite AS link_rewrite,
  l.name AS name,
  l.description_short AS description,
  i1.id_image AS id_image1,
  i2.id_image AS id_image2,
  il1.legend AS legend1,
  il2.legend AS legend2,
  a.file_name AS file_name,
  -- Sub-query for suppliers
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT s.name
        ORDER BY
          s.name
      )
    FROM
      pre2398_supplier s
      INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier
    WHERE
      ps.id_product = p.id_product
  ) AS suppliers,
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT s.id_supplier
        ORDER BY
          s.id_supplier
      )
    FROM
      pre2398_supplier s
      INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier
    WHERE
      ps.id_product = p.id_product
  ) AS id_suppliers,
  -- Sub-query for attribute cap
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT pattrl4.id_attribute
        ORDER BY
          pattrl4.id_attribute
      )
    FROM
      pre2398_layered_product_attribute lpa4
      INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
    WHERE
      lpa4.id_product = p.id_product
      AND lpa4.id_attribute_group = 4
      AND pattrl4.id_lang = :id_lang
  ) AS id_attr_cap,
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT pattrl4.name
        ORDER BY
          pattrl4.name
      )
    FROM
      pre2398_layered_product_attribute lpa4
      INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
    WHERE
      lpa4.id_product = p.id_product
      AND lpa4.id_attribute_group = 4
      AND pattrl4.id_lang = :id_lang
  ) AS attr_cap,
  -- Sub-query for attribute prec
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT pattrl5.id_attribute
        ORDER BY
          pattrl5.id_attribute
      )
    FROM
      pre2398_layered_product_attribute lpa5
      INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
    WHERE
      lpa5.id_product = p.id_product
      AND lpa5.id_attribute_group = 5
      AND pattrl5.id_lang = :id_lang
  ) AS id_attr_prec,
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT pattrl5.name
        ORDER BY
          pattrl5.name
      )
    FROM
      pre2398_layered_product_attribute lpa5
      INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
    WHERE
      lpa5.id_product = p.id_product
      AND lpa5.id_attribute_group = 5
      AND pattrl5.id_lang = :id_lang
  ) AS attr_prec,
  -- Sub-query for features
  (
    SELECT
      GROUP_CONCAT(
        DISTINCT fp.id_feature_value
        ORDER BY
          fp.id_feature_value
      )
    FROM
      pre2398_feature_product fp
    WHERE
      fp.id_product = p.id_product
  ) AS id_feat
FROM
  pre2398_product p
  INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product
  AND cp.id_category = :category
  LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
  AND l.id_lang = :id_lang
  LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product
  AND i1.position = 1
  LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product
  AND i2.position = 2
  LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image
  AND il1.id_lang = :id_lang
  LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image
  AND il2.id_lang = :id_lang
  LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product
  LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment
  AND a.file_name LIKE :file_name
WHERE
  a.category = 'Datasheets'
GROUP BY
  p.id_product
ORDER BY
  p.id_product

SELECT 
                p.id_product AS id_product,
                p.id_category_default AS category_default,
                p.reference AS reference,
                l.link_rewrite AS link_rewrite,
                l.name AS name,
                l.description_short AS description,
                i1.id_image AS id_image1,
                i2.id_image AS id_image2,
                il1.legend AS legend1,
                il2.legend AS legend2,
                a.file_name AS file_name,

                -- Sub-query for suppliers
                (SELECT GROUP_CONCAT(DISTINCT s.name ORDER BY s.name)
                    FROM pre2398_supplier s
                    INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier
                    WHERE ps.id_product = p.id_product
                ) AS suppliers,

                (SELECT GROUP_CONCAT(DISTINCT s.id_supplier ORDER BY s.id_supplier)
                    FROM pre2398_supplier s
                    INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier
                    WHERE ps.id_product = p.id_product
                ) AS id_suppliers,

                -- Sub-query for attribute cap
                (SELECT GROUP_CONCAT(DISTINCT pattrl4.id_attribute ORDER BY pattrl4.id_attribute)
                    FROM pre2398_layered_product_attribute lpa4
                    INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
                    WHERE lpa4.id_product = p.id_product
                    AND lpa4.id_attribute_group = 4
                    AND pattrl4.id_lang = 1
                ) AS id_attr_cap,

                (SELECT GROUP_CONCAT(DISTINCT pattrl4.name ORDER BY pattrl4.name)
                FROM pre2398_layered_product_attribute lpa4
                INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
                WHERE lpa4.id_product = p.id_product
                AND lpa4.id_attribute_group = 4
                AND pattrl4.id_lang = 1
                ) AS attr_cap,

                -- Sub-query for attribute prec
                (SELECT GROUP_CONCAT(DISTINCT pattrl5.id_attribute ORDER BY pattrl5.id_attribute)
                FROM pre2398_layered_product_attribute lpa5
                INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
                WHERE lpa5.id_product = p.id_product
                AND lpa5.id_attribute_group = 5
                AND pattrl5.id_lang = 1
                ) AS id_attr_prec,

                (SELECT GROUP_CONCAT(DISTINCT pattrl5.name ORDER BY pattrl5.name)
                FROM pre2398_layered_product_attribute lpa5
                INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
                WHERE lpa5.id_product = p.id_product
                AND lpa5.id_attribute_group = 5
                AND pattrl5.id_lang = 1
                ) AS attr_prec,

                -- Sub-query for features
                (SELECT GROUP_CONCAT(DISTINCT fp.id_feature_value ORDER BY fp.id_feature_value)
                FROM pre2398_feature_product fp
                WHERE fp.id_product = p.id_product
                ) AS id_feat

            FROM pre2398_product p
            INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = 13
            LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product AND l.id_lang = 1
            LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
            LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2
            LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = 1
            LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = 1
            LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product
            LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name LIKE '%fr%'

            WHERE a.category = 'Datasheets'
            GROUP BY p.id_product
            ORDER BY p.id_product;

SELECT
  DISTINCT fvl.value AS value,
  fp.id_feature_value AS id_feature,
  COUNT(p.id_product) AS product_count
FROM
  pre2398_product p
  INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product
  AND cp.id_category = '13'
  INNER JOIN pre2398_feature_product fp ON fp.id_product = p.id_product
  INNER JOIN pre2398_feature_value_lang fvl ON fvl.id_feature_value = fp.id_feature_value
  AND fvl.id_lang = '1'
  INNER JOIN pre2398_feature f ON f.id_feature = fp.id_feature
  AND f.position = 0
WHERE
  fvl.id_lang = '1'
GROUP BY
  fp.id_feature_value
ORDER BY
  fvl.value

SELECT DISTINCT 
            fvl.value AS value,
            fp.id_feature_value AS id_feature,
            COUNT(p.id_product) AS product_count
        FROM pre2398_product p
        INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '13'
        INNER JOIN pre2398_feature_product fp ON fp.id_product = p.id_product
        INNER JOIN pre2398_feature_value_lang fvl ON fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = '1'
        INNER JOIN pre2398_feature f ON f.id_feature = fp.id_feature AND f.position = 0
        WHERE fvl.id_lang = '1'
        GROUP BY fp.id_feature_value
        ORDER BY fvl.value;

SELECT
  DISTINCT al.name as name,
  lpa.id_attribute as id_attribute,
  lpa.id_attribute_group as id_attribute_group,
  COUNT(p.id_product) as product_count
FROM
  pre2398_product p
  INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product
  AND cp.id_category = '13'
  AND p.active = 1
  INNER JOIN pre2398_layered_product_attribute lpa ON lpa.id_product = p.id_product
  INNER JOIN pre2398_attribute_lang al ON al.id_attribute = lpa.id_attribute
  AND al.id_lang = '1'
  INNER JOIN pre2398_attribute a ON a.id_attribute = lpa.id_attribute
WHERE
  al.id_lang = '1'
GROUP BY
  lpa.id_attribute
ORDER BY
  a.position

SELECT DISTINCT 
            al.name as name,
            lpa.id_attribute as id_attribute,
            lpa.id_attribute_group as id_attribute_group,
            COUNT(p.id_product) as product_count
        FROM pre2398_product p
        INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '13' AND p.active = 1
        INNER JOIN pre2398_layered_product_attribute lpa ON lpa.id_product = p.id_product
        INNER JOIN pre2398_attribute_lang al ON al.id_attribute = lpa.id_attribute AND al.id_lang = '1'
        INNER JOIN pre2398_attribute a ON a.id_attribute = lpa.id_attribute
        WHERE al.id_lang = '1'
        GROUP BY lpa.id_attribute 
        ORDER BY a.position;

SELECT
  *
FROM
  pre2398_category_lang l
  INNER JOIN pre2398_category c ON l.id_category = c.id_category
WHERE
  l.link_rewrite = 'capteurs-de-pesage'
  AND l.id_lang = '1'

SELECT * FROM pre2398_category_lang l
                INNER JOIN pre2398_category c ON l.id_category = c.id_category  
                WHERE l.link_rewrite = 'capteurs-de-pesage' AND l.id_lang = '1';