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.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
  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 = 29;

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 29;

SELECT
  DISTINCT i0_.id AS id_0
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?
LIMIT
  35

SELECT DISTINCT i0_.id AS id_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 29 LIMIT 35;

SELECT
  i0_.id AS id_0,
  i0_.nom AS nom_1,
  i0_.the_statut_id AS the_statut_id_2,
  i0_.reference AS reference_3,
  i0_.reference_index AS reference_index_4,
  i0_.reference_bailleur AS reference_bailleur_5,
  i0_.bailleur_id AS bailleur_id_6,
  i0_.adresse_id AS adresse_id_7,
  i0_.client_id AS client_id_8,
  i0_.agence_id AS agence_id_9
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT i0_.id AS id_0, i0_.nom AS nom_1, i0_.the_statut_id AS the_statut_id_2, i0_.reference AS reference_3, i0_.reference_index AS reference_index_4, i0_.reference_bailleur AS reference_bailleur_5, i0_.bailleur_id AS bailleur_id_6, i0_.adresse_id AS adresse_id_7, i0_.client_id AS client_id_8, i0_.agence_id AS agence_id_9 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 29 AND i0_.id IN (433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467);

SELECT
  b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.raison_sociale AS raison_sociale_2,
  b0_.siret AS siret_3,
  b0_.reference_index AS reference_index_4,
  b0_.telephone AS telephone_5,
  b0_.logo AS logo_6,
  b0_.updated_at AS updated_at_7,
  b0_.email AS email_8,
  b0_.the_statut_id AS the_statut_id_9,
  b0_.secteurs_id AS secteurs_id_10,
  b0_.client_id AS client_id_11
FROM
  bailleurs b0_
  LEFT JOIN bailleurs_adresses b2_ ON b0_.id = b2_.bailleurs_id
  LEFT JOIN adresses a1_ ON a1_.id = b2_.adresses_id
WHERE
  b0_.client_id = ?

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.raison_sociale AS raison_sociale_2, b0_.siret AS siret_3, b0_.reference_index AS reference_index_4, b0_.telephone AS telephone_5, b0_.logo AS logo_6, b0_.updated_at AS updated_at_7, b0_.email AS email_8, b0_.the_statut_id AS the_statut_id_9, b0_.secteurs_id AS secteurs_id_10, b0_.client_id AS client_id_11 FROM bailleurs b0_ LEFT JOIN bailleurs_adresses b2_ ON b0_.id = b2_.bailleurs_id LEFT JOIN adresses a1_ ON a1_.id = b2_.adresses_id WHERE b0_.client_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.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 = 474;

SELECT
  t0.id AS id_1,
  t0.information_acces AS information_acces_2,
  t0.commande_id AS commande_id_3,
  t0.intervention_site_id AS intervention_site_id_4,
  t0.contact_id AS contact_id_5
FROM
  commande_site t0
WHERE
  t0.intervention_site_id = ?

SELECT t0.id AS id_1, t0.information_acces AS information_acces_2, t0.commande_id AS commande_id_3, t0.intervention_site_id AS intervention_site_id_4, t0.contact_id AS contact_id_5 FROM commande_site t0 WHERE t0.intervention_site_id = 433;

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.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.fonction_id AS fonction_id_6,
  t0.bailleurs_id AS bailleurs_id_7,
  t0.client_id AS client_id_8
FROM
  contacts t0
  INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id
WHERE
  intervention_site_contacts.intervention_site_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, t0.fonction_id AS fonction_id_6, t0.bailleurs_id AS bailleurs_id_7, t0.client_id AS client_id_8 FROM contacts t0 INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id WHERE intervention_site_contacts.intervention_site_id = 433;

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

SELECT
  t0.id AS id_1,
  t0.information_acces AS information_acces_2,
  t0.commande_id AS commande_id_3,
  t0.intervention_site_id AS intervention_site_id_4,
  t0.contact_id AS contact_id_5
FROM
  commande_site t0
WHERE
  t0.intervention_site_id = ?

SELECT t0.id AS id_1, t0.information_acces AS information_acces_2, t0.commande_id AS commande_id_3, t0.intervention_site_id AS intervention_site_id_4, t0.contact_id AS contact_id_5 FROM commande_site t0 WHERE t0.intervention_site_id = 434;

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

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,
  t0.fonction_id AS fonction_id_6,
  t0.bailleurs_id AS bailleurs_id_7,
  t0.client_id AS client_id_8
FROM
  contacts t0
  INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id
WHERE
  intervention_site_contacts.intervention_site_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, t0.fonction_id AS fonction_id_6, t0.bailleurs_id AS bailleurs_id_7, t0.client_id AS client_id_8 FROM contacts t0 INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id WHERE intervention_site_contacts.intervention_site_id = 434;

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

SELECT
  t0.id AS id_1,
  t0.information_acces AS information_acces_2,
  t0.commande_id AS commande_id_3,
  t0.intervention_site_id AS intervention_site_id_4,
  t0.contact_id AS contact_id_5
FROM
  commande_site t0
WHERE
  t0.intervention_site_id = ?

SELECT t0.id AS id_1, t0.information_acces AS information_acces_2, t0.commande_id AS commande_id_3, t0.intervention_site_id AS intervention_site_id_4, t0.contact_id AS contact_id_5 FROM commande_site t0 WHERE t0.intervention_site_id = 435;

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