Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM user t0 WHERE t0.id = ?

[
  15
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM user t0 WHERE t0.id = 15;

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ?

[
  "%DIOURBEL%"
]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%';

SELECT DISTINCT a0_.id AS id_0, a0_.date_signature AS date_signature_1 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ? ORDER BY a0_.date_signature DESC LIMIT 50 OFFSET 100

[
  "%DIOURBEL%"
]

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.date_signature AS date_signature_1
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?
ORDER BY
  a0_.date_signature DESC
LIMIT
  50
OFFSET
  100

SELECT DISTINCT a0_.id AS id_0, a0_.date_signature AS date_signature_1 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%' ORDER BY a0_.date_signature DESC LIMIT 50 OFFSET 100;

SELECT a0_.id AS id_0, a0_.recipisse AS recipisse_1, a0_.date_signature AS date_signature_2, a0_.denomination AS denomination_3, a0_.sigle AS sigle_4, a0_.adresse AS adresse_5, a0_.geolocalisation AS geolocalisation_6, a0_.nom_president AS nom_president_7, a0_.nom_secretaire AS nom_secretaire_8, a0_.telephone_secretaire AS telephone_secretaire_9, a0_.nom_tresorier AS nom_tresorier_10, a0_.telephone_tresorier AS telephone_tresorier_11, a0_.fichier_recipisse AS fichier_recipisse_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.objet AS objet_15, a0_.telephone_president AS telephone_president_16, a0_.is_file_detected AS is_file_detected_17, a0_.latitude AS latitude_18, a0_.longitude AS longitude_19, a0_.departement_id AS departement_id_20 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.date_signature DESC

[
  "%DIOURBEL%"
  575
  576
  570
  571
  572
  558
  559
  560
  543
  544
  545
  546
  547
  548
  549
  550
  556
  557
  538
  536
  537
  523
  524
  520
  521
  522
  508
  509
  503
  504
  505
  677
  663
  664
  665
  666
  667
  668
  645
  646
  647
  648
  649
  644
  641
  642
  636
  634
  633
  702
]

SELECT
  a0_.id AS id_0,
  a0_.recipisse AS recipisse_1,
  a0_.date_signature AS date_signature_2,
  a0_.denomination AS denomination_3,
  a0_.sigle AS sigle_4,
  a0_.adresse AS adresse_5,
  a0_.geolocalisation AS geolocalisation_6,
  a0_.nom_president AS nom_president_7,
  a0_.nom_secretaire AS nom_secretaire_8,
  a0_.telephone_secretaire AS telephone_secretaire_9,
  a0_.nom_tresorier AS nom_tresorier_10,
  a0_.telephone_tresorier AS telephone_tresorier_11,
  a0_.fichier_recipisse AS fichier_recipisse_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  a0_.objet AS objet_15,
  a0_.telephone_president AS telephone_president_16,
  a0_.is_file_detected AS is_file_detected_17,
  a0_.latitude AS latitude_18,
  a0_.longitude AS longitude_19,
  a0_.departement_id AS departement_id_20
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.date_signature DESC

SELECT a0_.id AS id_0, a0_.recipisse AS recipisse_1, a0_.date_signature AS date_signature_2, a0_.denomination AS denomination_3, a0_.sigle AS sigle_4, a0_.adresse AS adresse_5, a0_.geolocalisation AS geolocalisation_6, a0_.nom_president AS nom_president_7, a0_.nom_secretaire AS nom_secretaire_8, a0_.telephone_secretaire AS telephone_secretaire_9, a0_.nom_tresorier AS nom_tresorier_10, a0_.telephone_tresorier AS telephone_tresorier_11, a0_.fichier_recipisse AS fichier_recipisse_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.objet AS objet_15, a0_.telephone_president AS telephone_president_16, a0_.is_file_detected AS is_file_detected_17, a0_.latitude AS latitude_18, a0_.longitude AS longitude_19, a0_.departement_id AS departement_id_20 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%' AND a0_.id IN (575, 576, 570, 571, 572, 558, 559, 560, 543, 544, 545, 546, 547, 548, 549, 550, 556, 557, 538, 536, 537, 523, 524, 520, 521, 522, 508, 509, 503, 504, 505, 677, 663, 664, 665, 666, 667, 668, 645, 646, 647, 648, 649, 644, 641, 642, 636, 634, 633, 702) ORDER BY a0_.date_signature DESC;

SELECT COUNT(a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE ?

[
  "%DIOURBEL%"
]

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  association a0_
  INNER JOIN departement d1_ ON a0_.departement_id = d1_.id
WHERE
  d1_.nom_departement LIKE ?

SELECT COUNT(a0_.id) AS sclr_0 FROM association a0_ INNER JOIN departement d1_ ON a0_.departement_id = d1_.id WHERE d1_.nom_departement LIKE '%DIOURBEL%';

SELECT t0.id AS id_1, t0.nom_departement AS nom_departement_2 FROM departement t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.nom_departement AS nom_departement_2
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_departement AS nom_departement_2 FROM departement t0 WHERE t0.id = 1;