Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Emails
• Serializer
• Configuration

Query Metrics

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN (?, ?) AND c1_.sport_id = ? GROUP BY c0_.id

[
  "OK"
  "PUB"
  2
]

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  clubs c0_
  INNER JOIN cours c1_ ON c0_.id = c1_.club_id
WHERE
  c0_.etat IN (?, ?)
  AND c1_.sport_id = ?
GROUP BY
  c0_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN ('OK', 'PUB') AND c1_.sport_id = 2 GROUP BY c0_.id;

SELECT DISTINCT c0_.id AS id_0, c0_.nom AS nom_1 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN (?, ?) AND c1_.sport_id = ? GROUP BY c0_.id ORDER BY c0_.nom ASC LIMIT 10

[
  "OK"
  "PUB"
  2
]

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.nom AS nom_1
FROM
  clubs c0_
  INNER JOIN cours c1_ ON c0_.id = c1_.club_id
WHERE
  c0_.etat IN (?, ?)
  AND c1_.sport_id = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.nom ASC
LIMIT
  10

SELECT DISTINCT c0_.id AS id_0, c0_.nom AS nom_1 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN ('OK', 'PUB') AND c1_.sport_id = 2 GROUP BY c0_.id ORDER BY c0_.nom ASC LIMIT 10;

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.adresse AS adresse_2, c0_.cp AS cp_3, c0_.mail AS mail_4, c0_.tel AS tel_5, c0_.ville AS ville_6, c0_.code AS code_7, c0_.etat AS etat_8, c0_.presentationhtml AS presentationhtml_9, c0_.lienweb AS lienweb_10, c0_.couleur AS couleur_11, c0_.guid AS guid_12, c0_.textfacturepied AS textfacturepied_13, c0_.messbienvenu AS messbienvenu_14, c0_.textinscription AS textinscription_15, c0_.theme_id AS theme_id_16 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN (?, ?) AND c1_.sport_id = ? AND c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.nom ASC

[
  "OK"
  "PUB"
  2
  1
]

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.adresse AS adresse_2,
  c0_.cp AS cp_3,
  c0_.mail AS mail_4,
  c0_.tel AS tel_5,
  c0_.ville AS ville_6,
  c0_.code AS code_7,
  c0_.etat AS etat_8,
  c0_.presentationhtml AS presentationhtml_9,
  c0_.lienweb AS lienweb_10,
  c0_.couleur AS couleur_11,
  c0_.guid AS guid_12,
  c0_.textfacturepied AS textfacturepied_13,
  c0_.messbienvenu AS messbienvenu_14,
  c0_.textinscription AS textinscription_15,
  c0_.theme_id AS theme_id_16
FROM
  clubs c0_
  INNER JOIN cours c1_ ON c0_.id = c1_.club_id
WHERE
  c0_.etat IN (?, ?)
  AND c1_.sport_id = ?
  AND c0_.id IN (?)
GROUP BY
  c0_.id
ORDER BY
  c0_.nom ASC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.adresse AS adresse_2, c0_.cp AS cp_3, c0_.mail AS mail_4, c0_.tel AS tel_5, c0_.ville AS ville_6, c0_.code AS code_7, c0_.etat AS etat_8, c0_.presentationhtml AS presentationhtml_9, c0_.lienweb AS lienweb_10, c0_.couleur AS couleur_11, c0_.guid AS guid_12, c0_.textfacturepied AS textfacturepied_13, c0_.messbienvenu AS messbienvenu_14, c0_.textinscription AS textinscription_15, c0_.theme_id AS theme_id_16 FROM clubs c0_ INNER JOIN cours c1_ ON c0_.id = c1_.club_id WHERE c0_.etat IN ('OK', 'PUB') AND c1_.sport_id = 2 AND c0_.id IN (1) GROUP BY c0_.id ORDER BY c0_.nom ASC;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 ORDER BY t0.nom ASC

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 ORDER BY t0.nom ASC;

SELECT t0.id AS id_1, t0.horaires AS horaires_2, t0.nbplace AS nbplace_3, t0.etat AS etat_4, t0.jour AS jour_5, t0.heure_debut AS heure_debut_6, t0.heure_fin AS heure_fin_7, t0.club_id AS club_id_8, t0.site_id AS site_id_9, t0.sport_id AS sport_id_10, t0.entraineur_id AS entraineur_id_11, t0.niveau_id AS niveau_id_12 FROM cours t0 WHERE t0.club_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.horaires AS horaires_2,
  t0.nbplace AS nbplace_3,
  t0.etat AS etat_4,
  t0.jour AS jour_5,
  t0.heure_debut AS heure_debut_6,
  t0.heure_fin AS heure_fin_7,
  t0.club_id AS club_id_8,
  t0.site_id AS site_id_9,
  t0.sport_id AS sport_id_10,
  t0.entraineur_id AS entraineur_id_11,
  t0.niveau_id AS niveau_id_12
FROM
  cours t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.horaires AS horaires_2, t0.nbplace AS nbplace_3, t0.etat AS etat_4, t0.jour AS jour_5, t0.heure_debut AS heure_debut_6, t0.heure_fin AS heure_fin_7, t0.club_id AS club_id_8, t0.site_id AS site_id_9, t0.sport_id AS sport_id_10, t0.entraineur_id AS entraineur_id_11, t0.niveau_id AS niveau_id_12 FROM cours t0 WHERE t0.club_id = 1;