Symfony Profiler

SELECT
  *
FROM
  pre2398_leoblogcat_lang c
WHERE
  c.id_lang = '1'

SELECT * FROM pre2398_leoblogcat_lang c WHERE c.id_lang = '1';

SELECT
  *
FROM
  pre2398_leoblog_blog b
  LEFT JOIN pre2398_leoblog_blog_lang l ON b.id_leoblog_blog = l.id_leoblog_blog
WHERE
  l.id_lang = '1'
  AND b.id_leoblogcat = 6
ORDER BY
  b.position DESC

SELECT * FROM pre2398_leoblog_blog b LEFT JOIN pre2398_leoblog_blog_lang l ON b.id_leoblog_blog = l.id_leoblog_blog WHERE l.id_lang = '1' AND b.id_leoblogcat = 6 ORDER BY b.position DESC;

SELECT
  *
FROM
  pre2398_category_lang cl
  INNER JOIN pre2398_category c ON c.id_category = cl.id_category
  AND c.active = 1
  AND c.id_parent = 2
WHERE
  cl.id_lang = '1'

SELECT * FROM pre2398_category_lang cl
        INNER JOIN pre2398_category c ON c.id_category = cl.id_category AND c.active = 1 AND c.id_parent = 2
        WHERE cl.id_lang = '1';

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,
  GROUP_CONCAT(DISTINCT s.name) as suppliers,
  GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
  GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
  GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec
FROM
  pre2398_product p
  INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product
  AND cp.id_category = '12'
  LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
  LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product
  AND i2.position = 2
  LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product
  AND i1.position = 1
  LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image
  AND il2.id_lang = '1'
  LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image
  AND il1.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%'
  LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
  LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
  LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product
  AND lpa4.id_attribute_group = 4
  LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute
  AND pattrl4.id_lang = '1'
  LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product
  AND lpa5.id_attribute_group = 5
  LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute
  AND pattrl5.id_lang = '1'
WHERE
  l.id_lang = '1'
  AND a.category = 'Datasheets'
  AND p.id_category_default != 18
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,
                    GROUP_CONCAT(DISTINCT s.name) as suppliers,
                    GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
                    GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
                    GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec
                    FROM pre2398_product p
                INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '12'
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.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%'
                LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
                LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
                LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4
                LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '1'
                LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5
                LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_category_default != 18 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,
  il1.legend as legend1
FROM
  pre2398_product p
  INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product
  AND cp.id_category = '19'
  LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
  LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product
  AND i1.position = 1
  LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image
  AND il1.id_lang = '1'
WHERE
  l.id_lang = '1'
  AND p.id_category_default != 18
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,
                    il1.legend as legend1
                    FROM pre2398_product p
                INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '19'
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                WHERE l.id_lang = '1' AND p.id_category_default != 18 GROUP BY p.id_product ORDER BY p.id_product;