Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• EasyAdmin
• Configuration

Query Metrics

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
         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
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
         ORDER BY mv.nom ASC;

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 article_photo a1_ ON a0_.id = a1_.article_id WHERE a0_.publie = 1 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 article_photo a1_ ON a0_.id = a1_.article_id
WHERE
  a0_.publie = 1
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 article_photo a1_ ON a0_.id = a1_.article_id WHERE a0_.publie = 1 ORDER BY a0_.date_creation DESC, a1_.photo_par_defaut DESC LIMIT 12 OFFSET 24;

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
         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
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
         ORDER BY mrq.nom ASC;

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.publie = 1

[]

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.publie = 1

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.publie = 1;

SELECT f0_.id AS id_0, f0_.num_famille_erp AS num_famille_erp_1, f0_.code AS code_2, f0_.nom AS nom_3, f1_.id AS id_4, f1_.num_famille_erp AS num_famille_erp_5, f1_.code AS code_6, f1_.nom AS nom_7, f0_.parent_id AS parent_id_8, f1_.parent_id AS parent_id_9 FROM famille_article f0_ LEFT JOIN famille_article f1_ ON f0_.id = f1_.parent_id WHERE f0_.parent_id IS NULL ORDER BY f0_.nom ASC

[]

SELECT
  f0_.id AS id_0,
  f0_.num_famille_erp AS num_famille_erp_1,
  f0_.code AS code_2,
  f0_.nom AS nom_3,
  f1_.id AS id_4,
  f1_.num_famille_erp AS num_famille_erp_5,
  f1_.code AS code_6,
  f1_.nom AS nom_7,
  f0_.parent_id AS parent_id_8,
  f1_.parent_id AS parent_id_9
FROM
  famille_article f0_
  LEFT JOIN famille_article f1_ ON f0_.id = f1_.parent_id
WHERE
  f0_.parent_id IS NULL
ORDER BY
  f0_.nom ASC

SELECT f0_.id AS id_0, f0_.num_famille_erp AS num_famille_erp_1, f0_.code AS code_2, f0_.nom AS nom_3, f1_.id AS id_4, f1_.num_famille_erp AS num_famille_erp_5, f1_.code AS code_6, f1_.nom AS nom_7, f0_.parent_id AS parent_id_8, f1_.parent_id AS parent_id_9 FROM famille_article f0_ LEFT JOIN famille_article f1_ ON f0_.id = f1_.parent_id WHERE f0_.parent_id IS NULL ORDER BY f0_.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.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_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_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;