Symfony Profiler

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.email = ?
LIMIT
  1

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.email = 'guermassimoheddine@gmail.com' LIMIT 1;

SELECT
  v0_.id AS id_0,
  v0_.created_at AS created_at_1,
  v0_.start_at AS start_at_2,
  v0_.end_at AS end_at_3,
  v0_.reference AS reference_4,
  v0_.reference_index AS reference_index_5,
  v0_.description AS description_6,
  v0_.has_presence_referent AS has_presence_referent_7,
  v0_.has_presence_occupant AS has_presence_occupant_8,
  v0_.occupant_patronyme AS occupant_patronyme_9,
  v0_.referent_patronyme AS referent_patronyme_10,
  v0_.heure AS heure_11,
  v0_.the_statut_id AS the_statut_id_12,
  v0_.duration AS duration_13,
  v0_.datetime_en_attente AS datetime_en_attente_14,
  v0_.datetime_programmee AS datetime_programmee_15,
  v0_.datetime_en_cours AS datetime_en_cours_16,
  v0_.datetime_terminee AS datetime_terminee_17,
  v0_.datetime_cloturee AS datetime_cloturee_18,
  v0_.datetime_annulee AS datetime_annulee_19,
  v0_.responsable_id AS responsable_id_20,
  v0_.client_id AS client_id_21,
  v0_.commande_id AS commande_id_22
FROM
  visite v0_
  LEFT JOIN visites_technicien v2_ ON v0_.id = v2_.visite_id
  LEFT JOIN user_client u1_ ON u1_.id = v2_.user_client_id
  LEFT JOIN user u3_ ON u1_.id = u3_.id
WHERE
  v0_.start_at >= ?
  AND v0_.start_at <= ?
  AND v0_.the_statut_id >= ?
  AND u3_.id = ?

SELECT v0_.id AS id_0, v0_.created_at AS created_at_1, v0_.start_at AS start_at_2, v0_.end_at AS end_at_3, v0_.reference AS reference_4, v0_.reference_index AS reference_index_5, v0_.description AS description_6, v0_.has_presence_referent AS has_presence_referent_7, v0_.has_presence_occupant AS has_presence_occupant_8, v0_.occupant_patronyme AS occupant_patronyme_9, v0_.referent_patronyme AS referent_patronyme_10, v0_.heure AS heure_11, v0_.the_statut_id AS the_statut_id_12, v0_.duration AS duration_13, v0_.datetime_en_attente AS datetime_en_attente_14, v0_.datetime_programmee AS datetime_programmee_15, v0_.datetime_en_cours AS datetime_en_cours_16, v0_.datetime_terminee AS datetime_terminee_17, v0_.datetime_cloturee AS datetime_cloturee_18, v0_.datetime_annulee AS datetime_annulee_19, v0_.responsable_id AS responsable_id_20, v0_.client_id AS client_id_21, v0_.commande_id AS commande_id_22 FROM visite v0_ LEFT JOIN visites_technicien v2_ ON v0_.id = v2_.visite_id LEFT JOIN user_client u1_ ON u1_.id = v2_.user_client_id LEFT JOIN user u3_ ON u1_.id = u3_.id WHERE v0_.start_at >= '2025-06-01 00:00:00' AND v0_.start_at <= '2025-06-30 23:59:59' AND v0_.the_statut_id >= 2 AND u3_.id = 5;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.reference AS reference_3,
  t0.reference_index AS reference_index_4,
  t0.statut AS statut_5,
  t0.informations AS informations_6,
  t0.the_statut_id AS the_statut_id_7,
  t0.the_facturation_id AS the_facturation_id_8,
  t0.recurrence_start_date AS recurrence_start_date_9,
  t0.recurrence_end_date AS recurrence_end_date_10,
  t0.date AS date_11,
  t0.parking AS parking_12,
  t0.bailleur_id AS bailleur_id_13,
  t0.client_id AS client_id_14,
  t15.id AS id_16,
  t15.reference AS reference_17,
  t15.created_at AS created_at_18,
  t15.start_at AS start_at_19,
  t15.end_at AS end_at_20,
  t15.reference_index AS reference_index_21,
  t15.description AS description_22,
  t15.the_statut_id AS the_statut_id_23,
  t15.bailleur_id AS bailleur_id_24,
  t15.responsable_id AS responsable_id_25,
  t15.commande_id AS commande_id_26,
  t15.client_id AS client_id_27,
  t0.contact_bailleur_id AS contact_bailleur_id_28,
  t0.responsable_id AS responsable_id_29,
  t0.agence_id AS agence_id_30
FROM
  commande t0
  LEFT JOIN inspection t15 ON t15.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.reference AS reference_3, t0.reference_index AS reference_index_4, t0.statut AS statut_5, t0.informations AS informations_6, t0.the_statut_id AS the_statut_id_7, t0.the_facturation_id AS the_facturation_id_8, t0.recurrence_start_date AS recurrence_start_date_9, t0.recurrence_end_date AS recurrence_end_date_10, t0.date AS date_11, t0.parking AS parking_12, t0.bailleur_id AS bailleur_id_13, t0.client_id AS client_id_14, t15.id AS id_16, t15.reference AS reference_17, t15.created_at AS created_at_18, t15.start_at AS start_at_19, t15.end_at AS end_at_20, t15.reference_index AS reference_index_21, t15.description AS description_22, t15.the_statut_id AS the_statut_id_23, t15.bailleur_id AS bailleur_id_24, t15.responsable_id AS responsable_id_25, t15.commande_id AS commande_id_26, t15.client_id AS client_id_27, t0.contact_bailleur_id AS contact_bailleur_id_28, t0.responsable_id AS responsable_id_29, t0.agence_id AS agence_id_30 FROM commande t0 LEFT JOIN inspection t15 ON t15.commande_id = t0.id WHERE t0.id = 12;

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.updated_at AS updated_at_8,
  t0.email AS email_9,
  t0.the_statut_id AS the_statut_id_10,
  t0.secteurs_id AS secteurs_id_11,
  t0.client_id AS client_id_12
FROM
  bailleurs 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.updated_at AS updated_at_8, t0.email AS email_9, t0.the_statut_id AS the_statut_id_10, t0.secteurs_id AS secteurs_id_11, t0.client_id AS client_id_12 FROM bailleurs t0 WHERE t0.id = 1;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.token_password AS token_password_6,
  t1.token_activate AS token_activate_7,
  t1.nom AS nom_8,
  t1.prenom AS prenom_9,
  t1.created_at AS created_at_10,
  t1.the_statut_id AS the_statut_id_11,
  t1.mobile AS mobile_12,
  t1.reference AS reference_13,
  t1.the_type_id AS the_type_id_14,
  t1.the_role_principal_id AS the_role_principal_id_15,
  t1.photo AS photo_16,
  t1.updated_at AS updated_at_17,
  t0.tarif_horaire AS tarif_horaire_18,
  t0.client_id AS client_id_19,
  t1.discr
FROM
  user_client t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN visites_technicien ON t0.id = visites_technicien.user_client_id
WHERE
  visites_technicien.visite_id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.token_password AS token_password_6, t1.token_activate AS token_activate_7, t1.nom AS nom_8, t1.prenom AS prenom_9, t1.created_at AS created_at_10, t1.the_statut_id AS the_statut_id_11, t1.mobile AS mobile_12, t1.reference AS reference_13, t1.the_type_id AS the_type_id_14, t1.the_role_principal_id AS the_role_principal_id_15, t1.photo AS photo_16, t1.updated_at AS updated_at_17, t0.tarif_horaire AS tarif_horaire_18, t0.client_id AS client_id_19, t1.discr FROM user_client t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN visites_technicien ON t0.id = visites_technicien.user_client_id WHERE visites_technicien.visite_id = 13;

SELECT
  t0.id AS id_1,
  t0.visite_id AS visite_id_2,
  t0.commande_lieu_id AS commande_lieu_id_3,
  t0.visite_site_id AS visite_site_id_4,
  t0.lieu_id AS lieu_id_5
FROM
  visite_lieu t0
WHERE
  t0.visite_id = ?

SELECT t0.id AS id_1, t0.visite_id AS visite_id_2, t0.commande_lieu_id AS commande_lieu_id_3, t0.visite_site_id AS visite_site_id_4, t0.lieu_id AS lieu_id_5 FROM visite_lieu t0 WHERE t0.visite_id = 13;

SELECT
  t0.id AS id_1,
  t0.etage AS etage_2,
  t0.numero AS numero_3,
  t0.type_id AS type_id_4,
  t0.pieces_nb AS pieces_nb_5,
  t0.reference AS reference_6,
  t0.surface AS surface_7,
  t0.occupant_id AS occupant_id_8,
  t0.intervention_site_id AS intervention_site_id_9
FROM
  lieu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.etage AS etage_2, t0.numero AS numero_3, t0.type_id AS type_id_4, t0.pieces_nb AS pieces_nb_5, t0.reference AS reference_6, t0.surface AS surface_7, t0.occupant_id AS occupant_id_8, t0.intervention_site_id AS intervention_site_id_9 FROM lieu t0 WHERE t0.id = 2653;

SELECT
  t0.id AS id_1,
  t0.visite_id AS visite_id_2,
  t0.commande_site_id AS commande_site_id_3,
  t0.intervention_site_id AS intervention_site_id_4
FROM
  visite_site t0
WHERE
  t0.visite_id = ?

SELECT t0.id AS id_1, t0.visite_id AS visite_id_2, t0.commande_site_id AS commande_site_id_3, t0.intervention_site_id AS intervention_site_id_4 FROM visite_site t0 WHERE t0.visite_id = 13;

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

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

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.start_at AS start_at_2,
  i0_.end_at AS end_at_3,
  i0_.reference AS reference_4,
  i0_.reference_index AS reference_index_5,
  i0_.description AS description_6,
  i0_.heure AS heure_7,
  i0_.the_statut_id AS the_statut_id_8,
  i0_.document_id AS document_id_9,
  i0_.duration AS duration_10,
  i0_.prix_ht AS prix_ht_11,
  i0_.datetime_en_attente AS datetime_en_attente_12,
  i0_.datetime_programmee AS datetime_programmee_13,
  i0_.datetime_en_cours AS datetime_en_cours_14,
  i0_.datetime_terminee AS datetime_terminee_15,
  i0_.datetime_cloturee AS datetime_cloturee_16,
  i0_.datetime_annulee AS datetime_annulee_17,
  i0_.responsable_id AS responsable_id_18,
  i0_.client_id AS client_id_19,
  i0_.commande_id AS commande_id_20,
  i0_.devis_id AS devis_id_21,
  i0_.bon_commande_id AS bon_commande_id_22,
  i0_.fiche_id AS fiche_id_23,
  i0_.rapport_id AS rapport_id_24,
  i0_.commande_site_id AS commande_site_id_25,
  i0_.commande_lieu_id AS commande_lieu_id_26
FROM
  intervention i0_
  LEFT JOIN interventions_technicien i2_ ON i0_.id = i2_.intervention_id
  LEFT JOIN user_client u1_ ON u1_.id = i2_.user_client_id
  LEFT JOIN user u3_ ON u1_.id = u3_.id
WHERE
  i0_.start_at >= ?
  AND i0_.start_at <= ?
  AND i0_.the_statut_id >= ?
  AND u3_.id = ?

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.start_at AS start_at_2, i0_.end_at AS end_at_3, i0_.reference AS reference_4, i0_.reference_index AS reference_index_5, i0_.description AS description_6, i0_.heure AS heure_7, i0_.the_statut_id AS the_statut_id_8, i0_.document_id AS document_id_9, i0_.duration AS duration_10, i0_.prix_ht AS prix_ht_11, i0_.datetime_en_attente AS datetime_en_attente_12, i0_.datetime_programmee AS datetime_programmee_13, i0_.datetime_en_cours AS datetime_en_cours_14, i0_.datetime_terminee AS datetime_terminee_15, i0_.datetime_cloturee AS datetime_cloturee_16, i0_.datetime_annulee AS datetime_annulee_17, i0_.responsable_id AS responsable_id_18, i0_.client_id AS client_id_19, i0_.commande_id AS commande_id_20, i0_.devis_id AS devis_id_21, i0_.bon_commande_id AS bon_commande_id_22, i0_.fiche_id AS fiche_id_23, i0_.rapport_id AS rapport_id_24, i0_.commande_site_id AS commande_site_id_25, i0_.commande_lieu_id AS commande_lieu_id_26 FROM intervention i0_ LEFT JOIN interventions_technicien i2_ ON i0_.id = i2_.intervention_id LEFT JOIN user_client u1_ ON u1_.id = i2_.user_client_id LEFT JOIN user u3_ ON u1_.id = u3_.id WHERE i0_.start_at >= '2025-06-01 00:00:00' AND i0_.start_at <= '2025-06-30 23:59:59' AND i0_.the_statut_id >= 2 AND u3_.id = 5;