Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 96
• Events
• Routing
• Cache
• Translation 12
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.token_password AS token_password_8,
  t0.token_activate AS token_activate_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.created_at AS created_at_12,
  t0.the_statut_id AS the_statut_id_13,
  t0.mobile AS mobile_14,
  t0.reference AS reference_15,
  t0.the_type_id AS the_type_id_16,
  t0.the_role_principal_id AS the_role_principal_id_17,
  t0.photo AS photo_18,
  t0.updated_at AS updated_at_19,
  t0.discr,
  t2.tarif_horaire AS tarif_horaire_20,
  t2.client_id AS client_id_21,
  t3.client_id AS client_id_22,
  t3.bailleur_id AS bailleur_id_23
FROM
  user t0
  LEFT JOIN user_admin t1 ON t0.id = t1.id
  LEFT JOIN user_client t2 ON t0.id = t2.id
  LEFT JOIN user_bailleur t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = ?

[
  "ROLE_CLIENT_DIRECTION"
]

SELECT
  t0.id AS id_1,
  t0.the_action_id AS the_action_id_2,
  t0.the_user_role_id AS the_user_role_id_3,
  t0.the_module_id AS the_module_id_4
FROM
  permission t0
WHERE
  t0.the_user_role_id = ?

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = 'ROLE_CLIENT_DIRECTION';

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ?

[
  1
]

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1;

SELECT DISTINCT l0_.id AS id_0, i1_.reference AS reference_1 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ? ORDER BY i1_.reference ASC LIMIT 35

[
  1
]

SELECT
  DISTINCT l0_.id AS id_0,
  i1_.reference AS reference_1
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?
ORDER BY
  i1_.reference ASC
LIMIT
  35

SELECT DISTINCT l0_.id AS id_0, i1_.reference AS reference_1 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1 ORDER BY i1_.reference ASC LIMIT 35;

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ? AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i1_.reference ASC

[
  1
  51
  43
  44
  45
  46
  47
  48
  49
  50
  26
  52
  53
  54
  55
  56
  57
  58
  59
  41
  25
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  42
]

SELECT
  l0_.id AS id_0,
  l0_.etage AS etage_1,
  l0_.numero AS numero_2,
  l0_.type_id AS type_id_3,
  l0_.pieces_nb AS pieces_nb_4,
  l0_.reference AS reference_5,
  l0_.surface AS surface_6,
  l0_.occupant_id AS occupant_id_7,
  l0_.intervention_site_id AS intervention_site_id_8
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?
  AND l0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  i1_.reference ASC

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1 AND l0_.id IN (51, 43, 44, 45, 46, 47, 48, 49, 50, 26, 52, 53, 54, 55, 56, 57, 58, 59, 41, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 42) ORDER BY i1_.reference ASC;

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.siret AS siret_4,
  t0.reference_index AS reference_index_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.email AS email_10,
  t0.the_statut_id AS the_statut_id_11,
  t0.stripe_customer_id AS stripe_customer_id_12,
  t0.sous_domaine AS sous_domaine_13,
  t0.capital AS capital_14,
  t0.num_tva_intra AS num_tva_intra_15,
  t0.footer_devis AS footer_devis_16,
  t0.secteurs_id AS secteurs_id_17
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.the_statut_id AS the_statut_id_3,
  t0.reference AS reference_4,
  t0.reference_index AS reference_index_5,
  t0.reference_bailleur AS reference_bailleur_6,
  t0.bailleur_id AS bailleur_id_7,
  t0.adresse_id AS adresse_id_8,
  t0.client_id AS client_id_9,
  t0.agence_id AS agence_id_10
FROM
  intervention_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.id = 7;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.complement AS complement_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.the_type_id AS the_type_id_10 FROM adresses t0 WHERE t0.id = ?

[
  18
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.rue AS rue_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.complement AS complement_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.the_type_id AS the_type_id_10
FROM
  adresses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.complement AS complement_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.the_type_id AS the_type_id_10 FROM adresses t0 WHERE t0.id = 18;