Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url_img AS url_img_3,
  t0.id_categorie AS id_categorie_4
FROM
  sous_categories t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = 9 LIMIT 1;

SELECT
  s0_.id AS id_0
FROM
  sous_categories s0_
WHERE
  s0_.id_categorie = ?
  OR s0_.id_categorie = ?

SELECT s0_.id AS id_0 FROM sous_categories s0_ WHERE s0_.id_categorie = 1 OR s0_.id_categorie = 2;

SELECT
  t0.id AS id_1,
  t0.date_ajout AS date_ajout_2,
  t0.titre AS titre_3,
  t0.ref AS ref_4,
  t0.description AS description_5,
  t0.prix_achat AS prix_achat_6,
  t0.marge AS marge_7,
  t0.prix_ht AS prix_ht_8,
  t0.prix_ttc AS prix_ttc_9,
  t0.tva AS tva_10,
  t0.prix_promo AS prix_promo_11,
  t0.prix_pro AS prix_pro_12,
  t0.prix_pro_ttc AS prix_pro_ttc_13,
  t0.min_qte AS min_qte_14,
  t0.unite AS unite_15,
  t0.img_principale AS img_principale_16,
  t0.id_sous_categorie AS id_sous_categorie_17,
  t0.etat AS etat_18,
  t0.ordre AS ordre_19
FROM
  articles t0
WHERE
  t0.id_sous_categorie IN (?, ?, ?)
  AND t0.etat = ?
LIMIT
  8

SELECT t0.id AS id_1, t0.date_ajout AS date_ajout_2, t0.titre AS titre_3, t0.ref AS ref_4, t0.description AS description_5, t0.prix_achat AS prix_achat_6, t0.marge AS marge_7, t0.prix_ht AS prix_ht_8, t0.prix_ttc AS prix_ttc_9, t0.tva AS tva_10, t0.prix_promo AS prix_promo_11, t0.prix_pro AS prix_pro_12, t0.prix_pro_ttc AS prix_pro_ttc_13, t0.min_qte AS min_qte_14, t0.unite AS unite_15, t0.img_principale AS img_principale_16, t0.id_sous_categorie AS id_sous_categorie_17, t0.etat AS etat_18, t0.ordre AS ordre_19 FROM articles t0 WHERE t0.id_sous_categorie IN (5, 9, 10) AND t0.etat = 1 LIMIT 8;

SELECT
  a0_.id AS id_0,
  a0_.date_ajout AS date_ajout_1,
  a0_.titre AS titre_2,
  a0_.ref AS ref_3,
  a0_.description AS description_4,
  a0_.prix_achat AS prix_achat_5,
  a0_.marge AS marge_6,
  a0_.prix_ht AS prix_ht_7,
  a0_.prix_ttc AS prix_ttc_8,
  a0_.tva AS tva_9,
  a0_.prix_promo AS prix_promo_10,
  a0_.prix_pro AS prix_pro_11,
  a0_.prix_pro_ttc AS prix_pro_ttc_12,
  a0_.min_qte AS min_qte_13,
  a0_.unite AS unite_14,
  a0_.img_principale AS img_principale_15,
  a0_.id_sous_categorie AS id_sous_categorie_16,
  a0_.etat AS etat_17,
  a0_.ordre AS ordre_18,
  s1_.titre AS titre_19
FROM
  articles a0_
  INNER JOIN sous_categories s1_ ON (a0_.id_sous_categorie = s1_.id)
WHERE
  a0_.prix_promo > 0
  AND a0_.prix_promo < a0_.prix_ttc
  AND a0_.etat = 1
LIMIT
  20

SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18, s1_.titre AS titre_19 FROM articles a0_ INNER JOIN sous_categories s1_ ON (a0_.id_sous_categorie = s1_.id) WHERE a0_.prix_promo > 0 AND a0_.prix_promo < a0_.prix_ttc AND a0_.etat = 1 LIMIT 20;

SELECT
  a0_.id AS id_0,
  a0_.date_ajout AS date_ajout_1,
  a0_.titre AS titre_2,
  a0_.ref AS ref_3,
  a0_.description AS description_4,
  a0_.prix_achat AS prix_achat_5,
  a0_.marge AS marge_6,
  a0_.prix_ht AS prix_ht_7,
  a0_.prix_ttc AS prix_ttc_8,
  a0_.tva AS tva_9,
  a0_.prix_promo AS prix_promo_10,
  a0_.prix_pro AS prix_pro_11,
  a0_.prix_pro_ttc AS prix_pro_ttc_12,
  a0_.min_qte AS min_qte_13,
  a0_.unite AS unite_14,
  a0_.img_principale AS img_principale_15,
  a0_.id_sous_categorie AS id_sous_categorie_16,
  a0_.etat AS etat_17,
  a0_.ordre AS ordre_18
FROM
  articles a0_
WHERE
  a0_.prix_promo > 0
  AND a0_.prix_promo < a0_.prix_ttc
  AND a0_.etat = 1
ORDER BY
  a0_.date_ajout DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18 FROM articles a0_ WHERE a0_.prix_promo > 0 AND a0_.prix_promo < a0_.prix_ttc AND a0_.etat = 1 ORDER BY a0_.date_ajout DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.date_ajout AS date_ajout_1,
  a0_.titre AS titre_2,
  a0_.ref AS ref_3,
  a0_.description AS description_4,
  a0_.prix_achat AS prix_achat_5,
  a0_.marge AS marge_6,
  a0_.prix_ht AS prix_ht_7,
  a0_.prix_ttc AS prix_ttc_8,
  a0_.tva AS tva_9,
  a0_.prix_promo AS prix_promo_10,
  a0_.prix_pro AS prix_pro_11,
  a0_.prix_pro_ttc AS prix_pro_ttc_12,
  a0_.min_qte AS min_qte_13,
  a0_.unite AS unite_14,
  a0_.img_principale AS img_principale_15,
  a0_.id_sous_categorie AS id_sous_categorie_16,
  a0_.etat AS etat_17,
  a0_.ordre AS ordre_18,
  s1_.titre AS titre_19
FROM
  articles a0_
  INNER JOIN sous_categories s1_ ON (a0_.id_sous_categorie = s1_.id)

SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18, s1_.titre AS titre_19 FROM articles a0_ INNER JOIN sous_categories s1_ ON (a0_.id_sous_categorie = s1_.id);

SELECT
  s0_.id AS id_0,
  s0_.titre AS titre_1,
  s0_.url_img AS url_img_2,
  s0_.id_categorie AS id_categorie_3
FROM
  sous_categories s0_
WHERE
  s0_.id IN (
    SELECT
      a1_.id_sous_categorie
    FROM
      articles a1_
  )

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.url_img AS url_img_2, s0_.id_categorie AS id_categorie_3 FROM sous_categories s0_ WHERE s0_.id IN (SELECT a1_.id_sous_categorie FROM articles a1_);

SELECT
  t0.id AS id_1,
  t0.date_ajout AS date_ajout_2,
  t0.titre AS titre_3,
  t0.ref AS ref_4,
  t0.description AS description_5,
  t0.prix_achat AS prix_achat_6,
  t0.marge AS marge_7,
  t0.prix_ht AS prix_ht_8,
  t0.prix_ttc AS prix_ttc_9,
  t0.tva AS tva_10,
  t0.prix_promo AS prix_promo_11,
  t0.prix_pro AS prix_pro_12,
  t0.prix_pro_ttc AS prix_pro_ttc_13,
  t0.min_qte AS min_qte_14,
  t0.unite AS unite_15,
  t0.img_principale AS img_principale_16,
  t0.id_sous_categorie AS id_sous_categorie_17,
  t0.etat AS etat_18,
  t0.ordre AS ordre_19
FROM
  articles t0
WHERE
  t0.id_sous_categorie IN (?)
  AND t0.etat = ?
LIMIT
  6

SELECT t0.id AS id_1, t0.date_ajout AS date_ajout_2, t0.titre AS titre_3, t0.ref AS ref_4, t0.description AS description_5, t0.prix_achat AS prix_achat_6, t0.marge AS marge_7, t0.prix_ht AS prix_ht_8, t0.prix_ttc AS prix_ttc_9, t0.tva AS tva_10, t0.prix_promo AS prix_promo_11, t0.prix_pro AS prix_pro_12, t0.prix_pro_ttc AS prix_pro_ttc_13, t0.min_qte AS min_qte_14, t0.unite AS unite_15, t0.img_principale AS img_principale_16, t0.id_sous_categorie AS id_sous_categorie_17, t0.etat AS etat_18, t0.ordre AS ordre_19 FROM articles t0 WHERE t0.id_sous_categorie IN (4) AND t0.etat = 1 LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.date_ajout AS date_ajout_2,
  t0.titre AS titre_3,
  t0.ref AS ref_4,
  t0.description AS description_5,
  t0.prix_achat AS prix_achat_6,
  t0.marge AS marge_7,
  t0.prix_ht AS prix_ht_8,
  t0.prix_ttc AS prix_ttc_9,
  t0.tva AS tva_10,
  t0.prix_promo AS prix_promo_11,
  t0.prix_pro AS prix_pro_12,
  t0.prix_pro_ttc AS prix_pro_ttc_13,
  t0.min_qte AS min_qte_14,
  t0.unite AS unite_15,
  t0.img_principale AS img_principale_16,
  t0.id_sous_categorie AS id_sous_categorie_17,
  t0.etat AS etat_18,
  t0.ordre AS ordre_19
FROM
  articles t0
WHERE
  t0.id_sous_categorie = ?
  AND t0.etat = ?
LIMIT
  4

SELECT t0.id AS id_1, t0.date_ajout AS date_ajout_2, t0.titre AS titre_3, t0.ref AS ref_4, t0.description AS description_5, t0.prix_achat AS prix_achat_6, t0.marge AS marge_7, t0.prix_ht AS prix_ht_8, t0.prix_ttc AS prix_ttc_9, t0.tva AS tva_10, t0.prix_promo AS prix_promo_11, t0.prix_pro AS prix_pro_12, t0.prix_pro_ttc AS prix_pro_ttc_13, t0.min_qte AS min_qte_14, t0.unite AS unite_15, t0.img_principale AS img_principale_16, t0.id_sous_categorie AS id_sous_categorie_17, t0.etat AS etat_18, t0.ordre AS ordre_19 FROM articles t0 WHERE t0.id_sous_categorie = 6 AND t0.etat = 1 LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url_img AS url_img_3
FROM
  categories t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0;

SELECT
  t0.id AS id_1,
  t0.img AS img_2,
  t0.ordre AS ordre_3,
  t0.url AS url_4,
  t0.titre AS titre_5
FROM
  slider t0

SELECT t0.id AS id_1, t0.img AS img_2, t0.ordre AS ordre_3, t0.url AS url_4, t0.titre AS titre_5 FROM slider t0;

SELECT
  s0_.id AS id_0
FROM
  sous_categories s0_
WHERE
  s0_.id_categorie = ?

SELECT s0_.id AS id_0 FROM sous_categories s0_ WHERE s0_.id_categorie = 3;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url_img AS url_img_3,
  t0.id_categorie AS id_categorie_4
FROM
  sous_categories t0
WHERE
  t0.id_categorie = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id_categorie = 4;