Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.notification AS notification_5,
  t0.hide_account AS hide_account_6,
  t0.hide_entreprise AS hide_entreprise_7,
  t0.all_programmes AS all_programmes_8,
  t0.couleur AS couleur_9,
  t0.telephone AS telephone_10,
  t0.nom AS nom_11,
  t0.prenom AS prenom_12,
  t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13,
  t0.peut_modifier AS peut_modifier_14,
  t0.entreprise_id AS entreprise_id_15
FROM
  utilisateur 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.notification AS notification_5, t0.hide_account AS hide_account_6, t0.hide_entreprise AS hide_entreprise_7, t0.all_programmes AS all_programmes_8, t0.couleur AS couleur_9, t0.telephone AS telephone_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13, t0.peut_modifier AS peut_modifier_14, t0.entreprise_id AS entreprise_id_15 FROM utilisateur t0 WHERE t0.id = 12;

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lot l0_
  LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id
WHERE
  p1_.id IN (?)

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lot l0_ LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id WHERE p1_.id IN (203);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.adresse AS adresse_5,
  t0.website AS website_6,
  t0.logo AS logo_7,
  t0.logo_admin AS logo_admin_8,
  t0.updated_at AS updated_at_9,
  t0.available_roles AS available_roles_10
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.adresse AS adresse_5, t0.website AS website_6, t0.logo AS logo_7, t0.logo_admin AS logo_admin_8, t0.updated_at AS updated_at_9, t0.available_roles AS available_roles_10 FROM entreprise t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.adresse AS adresse_3,
  t0.ville AS ville_4,
  t0.code_postal AS code_postal_5,
  t0.date_livraison AS date_livraison_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.livraison AS livraison_9,
  t0.visu_livraison AS visu_livraison_10,
  t0.nom AS nom_11,
  t0.image AS image_12,
  t0.brochure AS brochure_13,
  t0.promoteur AS promoteur_14,
  t0.plan_masse AS plan_masse_15,
  t0.type_plan AS type_plan_16,
  t0.zoom_map AS zoom_map_17,
  t0.libelle_brochure AS libelle_brochure_18,
  t0.demande_suppression AS demande_suppression_19,
  t0.note_globale AS note_globale_20,
  t0.entreprise_id AS entreprise_id_21,
  t0.prescripteur_id AS prescripteur_id_22
FROM
  programme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.date_livraison AS date_livraison_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.livraison AS livraison_9, t0.visu_livraison AS visu_livraison_10, t0.nom AS nom_11, t0.image AS image_12, t0.brochure AS brochure_13, t0.promoteur AS promoteur_14, t0.plan_masse AS plan_masse_15, t0.type_plan AS type_plan_16, t0.zoom_map AS zoom_map_17, t0.libelle_brochure AS libelle_brochure_18, t0.demande_suppression AS demande_suppression_19, t0.note_globale AS note_globale_20, t0.entreprise_id AS entreprise_id_21, t0.prescripteur_id AS prescripteur_id_22 FROM programme t0 WHERE t0.id = '203';

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.description_courte AS description_courte_3,
  t0.ordre AS ordre_4,
  t0.show_public AS show_public_5,
  t0.est_un_plan AS est_un_plan_6,
  t0.est_image_admin AS est_image_admin_7,
  t0.lot_id AS lot_id_8,
  t0.programme_id AS programme_id_9,
  t0.piece_jointe_mere_id AS piece_jointe_mere_id_10
FROM
  piece_jointe t0
WHERE
  t0.lot_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.description_courte AS description_courte_3, t0.ordre AS ordre_4, t0.show_public AS show_public_5, t0.est_un_plan AS est_un_plan_6, t0.est_image_admin AS est_image_admin_7, t0.lot_id AS lot_id_8, t0.programme_id AS programme_id_9, t0.piece_jointe_mere_id AS piece_jointe_mere_id_10 FROM piece_jointe t0 WHERE t0.lot_id = 2258 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.description AS description_3,
  t0.date AS date_4,
  t0.lu AS lu_5,
  t0.utilisateur_id AS utilisateur_id_6,
  t0.auteur_id AS auteur_id_7,
  t0.connected_user_id AS connected_user_id_8,
  t0.historique_id AS historique_id_9,
  t0.programme_id AS programme_id_10
FROM
  infos_suivi t0
WHERE
  t0.utilisateur_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.date AS date_4, t0.lu AS lu_5, t0.utilisateur_id AS utilisateur_id_6, t0.auteur_id AS auteur_id_7, t0.connected_user_id AS connected_user_id_8, t0.historique_id AS historique_id_9, t0.programme_id AS programme_id_10 FROM infos_suivi t0 WHERE t0.utilisateur_id = 12;

SELECT
  l0_.id AS id_0,
  l0_.reference AS reference_1,
  l0_.type AS type_2,
  l0_.adresse AS adresse_3,
  l0_.ville AS ville_4,
  l0_.code_postal AS code_postal_5,
  l0_.prix AS prix_6,
  l0_.date_livraison AS date_livraison_7,
  l0_.titre AS titre_8,
  l0_.description AS description_9,
  l0_.latitude AS latitude_10,
  l0_.longitude AS longitude_11,
  l0_.etage AS etage_12,
  l0_.superficie AS superficie_13,
  l0_.terrasse AS terrasse_14,
  l0_.orientation AS orientation_15,
  l0_.annexes AS annexes_16,
  l0_.livraison AS livraison_17,
  l0_.promoteur AS promoteur_18,
  l0_.programme AS programme_19,
  l0_.image AS image_20,
  l0_.jardin AS jardin_21,
  l0_.terrasse2 AS terrasse2_22,
  l0_.frais_notaire_type AS frais_notaire_type_23,
  l0_.frais_notaire_inclus AS frais_notaire_inclus_24,
  l0_.brochure AS brochure_25,
  l0_.plan_masse AS plan_masse_26,
  l0_.statut AS statut_27,
  l0_.nature AS nature_28,
  l0_.type_moteur_recherche AS type_moteur_recherche_29,
  l0_.etage_moteur_recherche AS etage_moteur_recherche_30,
  l0_.etat_lot AS etat_lot_31,
  l0_.pj_progression AS pj_progression_32,
  l0_.programme_parent_id AS programme_parent_id_33
FROM
  lot l0_
  LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id
WHERE
  p1_.id IN (?)
  AND l0_.id IN (?)
ORDER BY
  l0_.statut ASC,
  l0_.id ASC

SELECT l0_.id AS id_0, l0_.reference AS reference_1, l0_.type AS type_2, l0_.adresse AS adresse_3, l0_.ville AS ville_4, l0_.code_postal AS code_postal_5, l0_.prix AS prix_6, l0_.date_livraison AS date_livraison_7, l0_.titre AS titre_8, l0_.description AS description_9, l0_.latitude AS latitude_10, l0_.longitude AS longitude_11, l0_.etage AS etage_12, l0_.superficie AS superficie_13, l0_.terrasse AS terrasse_14, l0_.orientation AS orientation_15, l0_.annexes AS annexes_16, l0_.livraison AS livraison_17, l0_.promoteur AS promoteur_18, l0_.programme AS programme_19, l0_.image AS image_20, l0_.jardin AS jardin_21, l0_.terrasse2 AS terrasse2_22, l0_.frais_notaire_type AS frais_notaire_type_23, l0_.frais_notaire_inclus AS frais_notaire_inclus_24, l0_.brochure AS brochure_25, l0_.plan_masse AS plan_masse_26, l0_.statut AS statut_27, l0_.nature AS nature_28, l0_.type_moteur_recherche AS type_moteur_recherche_29, l0_.etage_moteur_recherche AS etage_moteur_recherche_30, l0_.etat_lot AS etat_lot_31, l0_.pj_progression AS pj_progression_32, l0_.programme_parent_id AS programme_parent_id_33 FROM lot l0_ LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id WHERE p1_.id IN (203) AND l0_.id IN (2258) ORDER BY l0_.statut ASC, l0_.id ASC;

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.statut AS statut_1,
  l0_.id AS id_2
FROM
  lot l0_
  LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id
WHERE
  p1_.id IN (?)
ORDER BY
  l0_.statut ASC,
  l0_.id ASC
LIMIT
  250

SELECT DISTINCT l0_.id AS id_0, l0_.statut AS statut_1, l0_.id AS id_2 FROM lot l0_ LEFT JOIN programme p1_ ON l0_.programme_parent_id = p1_.id WHERE p1_.id IN (203) ORDER BY l0_.statut ASC, l0_.id ASC LIMIT 250;