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 ?

[
  "%MBACKE%"
]

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 '%MBACKE%';

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 150

[
  "%MBACKE%"
]

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
  150

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 '%MBACKE%' ORDER BY a0_.date_signature DESC LIMIT 50 OFFSET 150;

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

[
  "%MBACKE%"
  730
  729
  711
  716
  717
  718
  719
  720
  721
  1040
  1033
  1026
  1022
  1023
  1024
  1025
  1004
  1005
  1007
  1008
  1009
  1010
  1011
  1012
  1013
  1014
  1003
  995
  983
  985
  986
  971
  972
  974
  969
  964
  965
  961
  962
  963
  959
  960
  954
  955
  956
  953
  952
  948
  949
  950
]

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 '%MBACKE%' AND a0_.id IN (730, 729, 711, 716, 717, 718, 719, 720, 721, 1040, 1033, 1026, 1022, 1023, 1024, 1025, 1004, 1005, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1003, 995, 983, 985, 986, 971, 972, 974, 969, 964, 965, 961, 962, 963, 959, 960, 954, 955, 956, 953, 952, 948, 949, 950) 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 ?

[
  "%MBACKE%"
]

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 '%MBACKE%';

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

[
  2
]

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 = 2;