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 50

[
  "%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
  50

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 50;

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%"
  444
  427
  430
  424
  425
  411
  412
  408
  409
  410
  403
  404
  405
  406
  401
  402
  398
  399
  400
  393
  394
  395
  631
  624
  625
  626
  627
  610
  611
  612
  613
  614
  615
  616
  617
  618
  609
  606
  594
  595
  596
  597
  598
  577
  578
  579
  592
  593
  573
  574
]

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 (444, 427, 430, 424, 425, 411, 412, 408, 409, 410, 403, 404, 405, 406, 401, 402, 398, 399, 400, 393, 394, 395, 631, 624, 625, 626, 627, 610, 611, 612, 613, 614, 615, 616, 617, 618, 609, 606, 594, 595, 596, 597, 598, 577, 578, 579, 592, 593, 573, 574) 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;