Symfony Profiler

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.image_illustration AS image_illustration_5 
FROM 
  category t0 
WHERE 
  t0.slug = ? 
LIMIT 
  1

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.image_illustration AS image_illustration_5 FROM category t0 WHERE t0.slug = 'parfum-femme' LIMIT 1;

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id_0 
    FROM 
      (
        SELECT 
          p0_.id AS id_0, 
          p0_.nom AS nom_1, 
          p0_.le_slug AS le_slug_2, 
          p0_.petite_info AS petite_info_3, 
          p0_.price AS price_4, 
          p0_.old_price AS old_price_5, 
          p0_.description AS description_6, 
          p0_.stock_disponible AS stock_disponible_7, 
          p0_.stock_minimum AS stock_minimum_8, 
          p0_.stock_de_securite AS stock_de_securite_9, 
          p0_.stock_dalerte AS stock_dalerte_10, 
          p0_.stock_outil AS stock_outil_11, 
          p0_.stock_maximum AS stock_maximum_12, 
          p0_.cout_de_stockage AS cout_de_stockage_13, 
          p1_.id AS id_14, 
          p1_.url AS url_15, 
          p1_.alt AS alt_16, 
          p1_.date_ajout AS date_ajout_17, 
          p1_.est_valide AS est_valide_18, 
          s2_.slug AS slug_19, 
          s2_.id AS id_20, 
          s2_.name AS name_21, 
          s2_.icon AS icon_22, 
          c3_.slug AS slug_23, 
          c3_.id AS id_24, 
          c3_.name AS name_25, 
          c3_.icon AS icon_26, 
          c3_.image_illustration AS image_illustration_27 
        FROM 
          product p0_ 
          LEFT JOIN product_photo p1_ ON p0_.image_principale_id = p1_.id 
          LEFT JOIN sub_category s2_ ON p0_.sub_category_id = s2_.id 
          LEFT JOIN category c3_ ON s2_.category_id = c3_.id 
        WHERE 
          c3_.slug = ? 
        ORDER BY 
          p0_.nom ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.le_slug AS le_slug_2, p0_.petite_info AS petite_info_3, p0_.price AS price_4, p0_.old_price AS old_price_5, p0_.description AS description_6, p0_.stock_disponible AS stock_disponible_7, p0_.stock_minimum AS stock_minimum_8, p0_.stock_de_securite AS stock_de_securite_9, p0_.stock_dalerte AS stock_dalerte_10, p0_.stock_outil AS stock_outil_11, p0_.stock_maximum AS stock_maximum_12, p0_.cout_de_stockage AS cout_de_stockage_13, p1_.id AS id_14, p1_.url AS url_15, p1_.alt AS alt_16, p1_.date_ajout AS date_ajout_17, p1_.est_valide AS est_valide_18, s2_.slug AS slug_19, s2_.id AS id_20, s2_.name AS name_21, s2_.icon AS icon_22, c3_.slug AS slug_23, c3_.id AS id_24, c3_.name AS name_25, c3_.icon AS icon_26, c3_.image_illustration AS image_illustration_27 FROM product p0_ LEFT JOIN product_photo p1_ ON p0_.image_principale_id = p1_.id LEFT JOIN sub_category s2_ ON p0_.sub_category_id = s2_.id LEFT JOIN category c3_ ON s2_.category_id = c3_.id WHERE c3_.slug = 'parfum-femme' ORDER BY p0_.nom ASC) dctrn_result) dctrn_table;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.image_illustration AS image_illustration_5 
FROM 
  category t0

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.image_illustration AS image_illustration_5 FROM category t0;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 1;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 2;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 3;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 4;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 5;

SELECT 
  t0.slug AS slug_1, 
  t0.id AS id_2, 
  t0.name AS name_3, 
  t0.icon AS icon_4, 
  t0.category_id AS category_id_5 
FROM 
  sub_category t0 
WHERE 
  t0.category_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.name AS name_3, t0.icon AS icon_4, t0.category_id AS category_id_5 FROM sub_category t0 WHERE t0.category_id = 6;