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

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

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;

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%"
  351
  381
  382
  372
  373
  374
  375
  376
  369
  370
  366
  367
  362
  363
  352
  353
  350
  342
  498
  499
  500
  501
  497
  493
  494
  492
  484
  485
  486
  487
  488
  489
  490
  491
  472
  473
  474
  475
  476
  462
  461
  460
  458
  459
  456
  457
  454
  455
  447
  448
]

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 (351, 381, 382, 372, 373, 374, 375, 376, 369, 370, 366, 367, 362, 363, 352, 353, 350, 342, 498, 499, 500, 501, 497, 493, 494, 492, 484, 485, 486, 487, 488, 489, 490, 491, 472, 473, 474, 475, 476, 462, 461, 460, 458, 459, 456, 457, 454, 455, 447, 448) 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;