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.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.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.raison_sociale = ?
  AND t0.client_id = ?
LIMIT
  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.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.raison_sociale = 'DOMNIS' AND t0.client_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 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.nom = ?
  AND t0.client_id = ?
LIMIT
  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.nom = 'RESIDENCE DU PETIT BOIS' AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '101';

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.intervention_site_id = ?
ORDER BY
  t0.etage ASC,
  t0.numero ASC

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.intervention_site_id = 433 ORDER BY t0.etage ASC, t0.numero ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '102';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '111';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 594;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '112';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 595;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '121';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 596;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '122';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 597;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;

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_
WHERE
  l0_.reference = ?
  AND l0_.intervention_site_id = ?
  AND l0_.etage = ?
  AND l0_.numero = ?

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_ WHERE l0_.reference = '1001' AND l0_.intervention_site_id = 433 AND l0_.etage = 0 AND l0_.numero = '131';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5
FROM
  occupant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5 FROM occupant t0 WHERE t0.id = 598;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse_id AS adresse_id_3,
  t0.bailleur_id AS bailleur_id_4,
  t0.client_id AS client_id_5
FROM
  agence t0
WHERE
  t0.nom = ?
  AND t0.bailleur_id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_id AS adresse_id_3, t0.bailleur_id AS bailleur_id_4, t0.client_id AS client_id_5 FROM agence t0 WHERE t0.nom = 'SECTEUR NORD' AND t0.bailleur_id = 29 AND t0.client_id = 1 LIMIT 1;