Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.num_article_erp AS num_article_erp_1,
  a0_.reference AS reference_2,
  a0_.titre_web AS titre_web_3,
  a0_.description_web AS description_web_4,
  a0_.meta_titre AS meta_titre_5,
  a0_.meta_mots_cles AS meta_mots_cles_6,
  a0_.meta_description AS meta_description_7,
  a0_.reference_oem AS reference_oem_8,
  a0_.ref_marked AS ref_marked_9,
  a0_.prix_vente AS prix_vente_10,
  a0_.prix_achat AS prix_achat_11,
  a0_.unite AS unite_12,
  a0_.notes AS notes_13,
  a0_.stock AS stock_14,
  a0_.nombre_dans_lot AS nombre_dans_lot_15,
  a0_.publie AS publie_16,
  a0_.date_creation AS date_creation_17,
  a0_.date_synchronisation AS date_synchronisation_18,
  a0_.en_stock AS en_stock_19,
  a0_.slug AS slug_20,
  a1_.id AS id_21,
  a1_.id_erp AS id_erp_22,
  a1_.nom_fichier AS nom_fichier_23,
  a1_.photo_par_defaut AS photo_par_defaut_24,
  a1_.nom_fichier_card AS nom_fichier_card_25,
  a0_.marque_id AS marque_id_26,
  a1_.article_id AS article_id_27
FROM
  article a0_
  LEFT JOIN groupe_famille_article_article g2_ ON a0_.id = g2_.article_id
  LEFT JOIN machine_categorie m3_ ON g2_.machine_categorie_id = m3_.id
  LEFT JOIN article_photo a1_ ON a0_.id = a1_.article_id
WHERE
  a0_.publie = 1
  AND m3_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.date_creation DESC,
  a1_.photo_par_defaut DESC
LIMIT
  12
OFFSET
  24

SELECT DISTINCT a0_.id AS id_0, a0_.num_article_erp AS num_article_erp_1, a0_.reference AS reference_2, a0_.titre_web AS titre_web_3, a0_.description_web AS description_web_4, a0_.meta_titre AS meta_titre_5, a0_.meta_mots_cles AS meta_mots_cles_6, a0_.meta_description AS meta_description_7, a0_.reference_oem AS reference_oem_8, a0_.ref_marked AS ref_marked_9, a0_.prix_vente AS prix_vente_10, a0_.prix_achat AS prix_achat_11, a0_.unite AS unite_12, a0_.notes AS notes_13, a0_.stock AS stock_14, a0_.nombre_dans_lot AS nombre_dans_lot_15, a0_.publie AS publie_16, a0_.date_creation AS date_creation_17, a0_.date_synchronisation AS date_synchronisation_18, a0_.en_stock AS en_stock_19, a0_.slug AS slug_20, a1_.id AS id_21, a1_.id_erp AS id_erp_22, a1_.nom_fichier AS nom_fichier_23, a1_.photo_par_defaut AS photo_par_defaut_24, a1_.nom_fichier_card AS nom_fichier_card_25, a0_.marque_id AS marque_id_26, a1_.article_id AS article_id_27 FROM article a0_ LEFT JOIN groupe_famille_article_article g2_ ON a0_.id = g2_.article_id LEFT JOIN machine_categorie m3_ ON g2_.machine_categorie_id = m3_.id LEFT JOIN article_photo a1_ ON a0_.id = a1_.article_id WHERE a0_.publie = 1 AND m3_.id IN (1, 6, 18, 19, 20, 192, 7, 39, 40, 41, 8, 31, 32, 33, 9, 26, 27, 28, 29, 190, 10, 23, 24, 30, 60, 11, 45, 58, 197, 208, 212, 12, 55, 56, 57, 13, 21, 22, 25, 38, 52, 53, 67, 75, 131, 132, 213, 14, 62, 63, 15, 43, 44, 202, 215, 16, 34, 35, 36, 37, 17, 61, 64, 66, 209, 210, 211, 42, 129, 200, 201, 203, 204, 207, 214) ORDER BY a0_.date_creation DESC, a1_.photo_par_defaut DESC LIMIT 12 OFFSET 24;

SELECT
  DISTINCT mv.id,
  mv.nom
FROM
  article a
  INNER JOIN article_application aa ON aa.article_id = a.id
  INNER JOIN modele mdl ON mdl.id = aa.modele_id
  INNER JOIN marque_vehicule mv ON mv.id = mdl.marque_vehicule_id
WHERE
  a.publie = 1
  AND EXISTS (
    SELECT
      1
    FROM
      groupe_famille_article_article gfaa
      INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
    WHERE
      gfaa.article_id = a.id
      AND mc.id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
  )
ORDER BY
  mv.nom ASC

SELECT DISTINCT mv.id, mv.nom
            FROM article a
            INNER JOIN article_application aa ON aa.article_id = a.id
            INNER JOIN modele mdl ON mdl.id = aa.modele_id
            INNER JOIN marque_vehicule mv ON mv.id = mdl.marque_vehicule_id
            WHERE a.publie = 1
         AND EXISTS (
                SELECT 1 FROM groupe_famille_article_article gfaa
                INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
                WHERE gfaa.article_id = a.id AND mc.id IN (1,6,18,19,20,192,7,39,40,41,8,31,32,33,9,26,27,28,29,190,10,23,24,30,60,11,45,58,197,208,212,12,55,56,57,13,21,22,25,38,52,53,67,75,131,132,213,14,62,63,15,43,44,202,215,16,34,35,36,37,17,61,64,66,209,210,211,42,129,200,201,203,204,207,214)
            ) ORDER BY mv.nom ASC;

SELECT
  DISTINCT mrq.id,
  mrq.nom
FROM
  article a
  INNER JOIN marque mrq ON mrq.id = a.marque_id
WHERE
  a.publie = 1
  AND a.marque_id IS NOT NULL
  AND EXISTS (
    SELECT
      1
    FROM
      groupe_famille_article_article gfaa
      INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
    WHERE
      gfaa.article_id = a.id
      AND mc.id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
  )
ORDER BY
  mrq.nom ASC

SELECT DISTINCT mrq.id, mrq.nom
            FROM article a
            INNER JOIN marque mrq ON mrq.id = a.marque_id
            WHERE a.publie = 1
              AND a.marque_id IS NOT NULL
         AND EXISTS (
                SELECT 1 FROM groupe_famille_article_article gfaa
                INNER JOIN machine_categorie mc ON mc.id = gfaa.machine_categorie_id
                WHERE gfaa.article_id = a.id AND mc.id IN (1,6,18,19,20,192,7,39,40,41,8,31,32,33,9,26,27,28,29,190,10,23,24,30,60,11,45,58,197,208,212,12,55,56,57,13,21,22,25,38,52,53,67,75,131,132,213,14,62,63,15,43,44,202,215,16,34,35,36,37,17,61,64,66,209,210,211,42,129,200,201,203,204,207,214)
            ) ORDER BY mrq.nom ASC;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  LEFT JOIN groupe_famille_article_article g1_ ON a0_.id = g1_.article_id
  LEFT JOIN machine_categorie m2_ ON g1_.machine_categorie_id = m2_.id
WHERE
  a0_.publie = 1
  AND m2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN groupe_famille_article_article g1_ ON a0_.id = g1_.article_id LEFT JOIN machine_categorie m2_ ON g1_.machine_categorie_id = m2_.id WHERE a0_.publie = 1 AND m2_.id IN (1, 6, 18, 19, 20, 192, 7, 39, 40, 41, 8, 31, 32, 33, 9, 26, 27, 28, 29, 190, 10, 23, 24, 30, 60, 11, 45, 58, 197, 208, 212, 12, 55, 56, 57, 13, 21, 22, 25, 38, 52, 53, 67, 75, 131, 132, 213, 14, 62, 63, 15, 43, 44, 202, 215, 16, 34, 35, 36, 37, 17, 61, 64, 66, 209, 210, 211, 42, 129, 200, 201, 203, 204, 207, 214);

SELECT
  t0.id AS id_1,
  t0.id_machine_categorie_erp AS id_machine_categorie_erp_2,
  t0.nom AS nom_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  machine_categorie t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = 1;

SELECT
  t0.id AS id_1,
  t0.id_marque_erp AS id_marque_erp_2,
  t0.nom AS nom_3,
  t0.code AS code_4
FROM
  marque t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_marque_erp AS id_marque_erp_2, t0.nom AS nom_3, t0.code AS code_4 FROM marque t0 WHERE t0.id = 84;

SELECT
  t0.id AS id_1,
  t0.id_machine_categorie_erp AS id_machine_categorie_erp_2,
  t0.nom AS nom_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  machine_categorie t0
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id IS NULL ORDER BY t0.nom ASC;

SELECT
  t0.id AS id_1,
  t0.id_machine_categorie_erp AS id_machine_categorie_erp_2,
  t0.nom AS nom_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  machine_categorie t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.slug = '1-materiels-d\'occasion' LIMIT 1;