Symfony Profiler

SELECT
  t0.date_creation AS date_creation_1,
  t0.date_maj AS date_maj_2,
  t0.id AS id_3,
  t0.photo AS photo_4,
  t0.display AS display_5
FROM
  slider t0
WHERE
  t0.display = ?

SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.photo AS photo_4, t0.display AS display_5 FROM slider t0 WHERE t0.display = 1;

SELECT
  COUNT(o0_.id) AS sclr_0,
  r1_.nom AS nom_1,
  r1_.code AS code_2,
  r1_.centroid AS centroid_3
FROM
  offre o0_
  INNER JOIN departement d2_ ON o0_.departement_id = d2_.id
  AND (o0_.departement_id = d2_.id)
  INNER JOIN region r1_ ON d2_.region_id = r1_.id
  AND (d2_.region_id = r1_.id)
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
GROUP BY
  r1_.nom

SELECT COUNT(o0_.id) AS sclr_0, r1_.nom AS nom_1, r1_.code AS code_2, r1_.centroid AS centroid_3 FROM offre o0_ INNER JOIN departement d2_ ON o0_.departement_id = d2_.id AND (o0_.departement_id = d2_.id) INNER JOIN region r1_ ON d2_.region_id = r1_.id AND (d2_.region_id = r1_.id) WHERE o0_.display_site = 1 AND o0_.archive = 0 GROUP BY r1_.nom;

SELECT
  o0_.date_creation AS date_creation_0,
  o0_.date_maj AS date_maj_1,
  o0_.id AS id_2,
  o0_.display_site AS display_site_3,
  o0_.num_fiche AS num_fiche_4,
  o0_.num_mandat AS num_mandat_5,
  o0_.titre AS titre_6,
  o0_.societe AS societe_7,
  o0_.association AS association_8,
  o0_.exclusivite AS exclusivite_9,
  o0_.adresse_bien AS adresse_bien_10,
  o0_.cp_bien AS cp_bien_11,
  o0_.ville_bien AS ville_bien_12,
  o0_.photo1 AS photo1_13,
  o0_.photo2 AS photo2_14,
  o0_.prix AS prix_15,
  o0_.stock AS stock_16,
  o0_.prix_impression AS prix_impression_17,
  o0_.stock_impression AS stock_impression_18,
  o0_.garde AS garde_19,
  o0_.desc_publicite AS desc_publicite_20,
  o0_.avis AS avis_21,
  o0_.desc_locaux AS desc_locaux_22,
  o0_.situation_geo AS situation_geo_23,
  o0_.desc_logement AS desc_logement_24,
  o0_.loyer AS loyer_25,
  o0_.employes AS employes_26,
  o0_.ouverture AS ouverture_27,
  o0_.fermeture AS fermeture_28,
  o0_.ca12mois_montant AS ca12mois_montant_29,
  o0_.ca12mois_date AS ca12mois_date_30,
  o0_.ca12mois_environ AS ca12mois_environ_31,
  o0_.ca12mois_ttc AS ca12mois_ttc_32,
  o0_.ca_description AS ca_description_33,
  o0_.ca_size AS ca_size_34,
  o0_.virtual_vendeur_nom AS virtual_vendeur_nom_35,
  o0_.archive AS archive_36,
  o0_.admin AS admin_37,
  o0_.send AS send_38,
  o0_.valid AS valid_39,
  o0_.display AS display_40,
  o0_.mandat AS mandat_41,
  o0_.mandat_date AS mandat_date_42,
  o0_.mandat_new_date AS mandat_new_date_43,
  o0_.bilan1 AS bilan1_44,
  o0_.bilan1_date AS bilan1_date_45,
  o0_.bilan1_new_date AS bilan1_new_date_46,
  o0_.bilan2 AS bilan2_47,
  o0_.bilan2_date AS bilan2_date_48,
  o0_.bilan2_new_date AS bilan2_new_date_49,
  o0_.salaire AS salaire_50,
  o0_.salaire_date AS salaire_date_51,
  o0_.salaire_new_date AS salaire_new_date_52,
  o0_.ca12 AS ca12_53,
  o0_.ca12_date AS ca12_date_54,
  o0_.ca12_new_date AS ca12_new_date_55,
  o0_.mdl12 AS mdl12_56,
  o0_.mdl12_date AS mdl12_date_57,
  o0_.mdl12_new_date AS mdl12_new_date_58,
  o0_.bail AS bail_59,
  o0_.bail_date AS bail_date_60,
  o0_.bail_new_date AS bail_new_date_61,
  o0_.bail_create AS bail_create_62,
  o0_.negociateur_id AS negociateur_id_63,
  o0_.departement_id AS departement_id_64
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
  AND (
    o0_.admin = 1
    OR o0_.valid = 1
  )
ORDER BY
  o0_.date_creation DESC

SELECT o0_.date_creation AS date_creation_0, o0_.date_maj AS date_maj_1, o0_.id AS id_2, o0_.display_site AS display_site_3, o0_.num_fiche AS num_fiche_4, o0_.num_mandat AS num_mandat_5, o0_.titre AS titre_6, o0_.societe AS societe_7, o0_.association AS association_8, o0_.exclusivite AS exclusivite_9, o0_.adresse_bien AS adresse_bien_10, o0_.cp_bien AS cp_bien_11, o0_.ville_bien AS ville_bien_12, o0_.photo1 AS photo1_13, o0_.photo2 AS photo2_14, o0_.prix AS prix_15, o0_.stock AS stock_16, o0_.prix_impression AS prix_impression_17, o0_.stock_impression AS stock_impression_18, o0_.garde AS garde_19, o0_.desc_publicite AS desc_publicite_20, o0_.avis AS avis_21, o0_.desc_locaux AS desc_locaux_22, o0_.situation_geo AS situation_geo_23, o0_.desc_logement AS desc_logement_24, o0_.loyer AS loyer_25, o0_.employes AS employes_26, o0_.ouverture AS ouverture_27, o0_.fermeture AS fermeture_28, o0_.ca12mois_montant AS ca12mois_montant_29, o0_.ca12mois_date AS ca12mois_date_30, o0_.ca12mois_environ AS ca12mois_environ_31, o0_.ca12mois_ttc AS ca12mois_ttc_32, o0_.ca_description AS ca_description_33, o0_.ca_size AS ca_size_34, o0_.virtual_vendeur_nom AS virtual_vendeur_nom_35, o0_.archive AS archive_36, o0_.admin AS admin_37, o0_.send AS send_38, o0_.valid AS valid_39, o0_.display AS display_40, o0_.mandat AS mandat_41, o0_.mandat_date AS mandat_date_42, o0_.mandat_new_date AS mandat_new_date_43, o0_.bilan1 AS bilan1_44, o0_.bilan1_date AS bilan1_date_45, o0_.bilan1_new_date AS bilan1_new_date_46, o0_.bilan2 AS bilan2_47, o0_.bilan2_date AS bilan2_date_48, o0_.bilan2_new_date AS bilan2_new_date_49, o0_.salaire AS salaire_50, o0_.salaire_date AS salaire_date_51, o0_.salaire_new_date AS salaire_new_date_52, o0_.ca12 AS ca12_53, o0_.ca12_date AS ca12_date_54, o0_.ca12_new_date AS ca12_new_date_55, o0_.mdl12 AS mdl12_56, o0_.mdl12_date AS mdl12_date_57, o0_.mdl12_new_date AS mdl12_new_date_58, o0_.bail AS bail_59, o0_.bail_date AS bail_date_60, o0_.bail_new_date AS bail_new_date_61, o0_.bail_create AS bail_create_62, o0_.negociateur_id AS negociateur_id_63, o0_.departement_id AS departement_id_64 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0 AND (o0_.admin = 1 OR o0_.valid = 1) ORDER BY o0_.date_creation DESC;

SELECT
  MIN(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MIN(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  MAX(o0_.ca12mois_montant) AS sclr_0
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0

SELECT MAX(o0_.ca12mois_montant) AS sclr_0 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.abreviation AS abreviation_2,
  r0_.code AS code_3,
  r0_.centroid AS centroid_4,
  r0_.position AS position_5
FROM
  region r0_
ORDER BY
  r0_.nom ASC

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.abreviation AS abreviation_2, r0_.code AS code_3, r0_.centroid AS centroid_4, r0_.position AS position_5 FROM region r0_ ORDER BY r0_.nom ASC;

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.abreviation AS abreviation_2,
  d0_.numero AS numero_3,
  d0_.region_id AS region_id_4
FROM
  departement d0_

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.abreviation AS abreviation_2, d0_.numero AS numero_3, d0_.region_id AS region_id_4 FROM departement d0_;

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t1.id = 14368;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 976;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abreviation AS abreviation_3,
  t0.femme AS femme_4
FROM
  civilite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3, t0.femme AS femme_4 FROM civilite t0 WHERE t0.id = 2;

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t1.id = 6630;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 982;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abreviation AS abreviation_3,
  t0.femme AS femme_4
FROM
  civilite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3, t0.femme AS femme_4 FROM civilite t0 WHERE t0.id = 1;

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.date_creation AS date_creation_2, t1.date_maj AS date_maj_3, t1.id AS id_4, t1.prenom AS prenom_5, t1.nom AS nom_6, t1.adresse AS adresse_7, t1.code_postal AS code_postal_8, t1.ville AS ville_9, t1.tel_domicile AS tel_domicile_10, t1.tel_bureau AS tel_bureau_11, t1.tel_mobile AS tel_mobile_12, t1.note_tel_mobile AS note_tel_mobile_13, t1.tel_mobile2 AS tel_mobile2_14, t1.note_tel_mobile2 AS note_tel_mobile2_15, t1.email AS email_16, t1.email2 AS email2_17, t0.secteur AS secteur_18, t0.ville_rattachement AS ville_rattachement_19, t0.photo AS photo_20, t0.display_web AS display_web_21, t0.position AS position_22, t1.civilite_id AS civilite_id_23, t0.utilisateur_id AS utilisateur_id_24, t1.discr FROM negociateur t0 INNER JOIN personne t1 ON t0.id = t1.id WHERE t1.id = 15710;

SELECT
  t0.id AS id_2,
  t0.username AS username_3,
  t0.username_canonical AS username_canonical_4,
  t0.email AS email_5,
  t0.email_canonical AS email_canonical_6,
  t0.enabled AS enabled_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.discr,
  t1.prenom AS prenom_14,
  t1.nom AS nom_15,
  t1.tel AS tel_16
FROM
  fos_user t0
  LEFT JOIN utilisateur_site t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.discr, t1.prenom AS prenom_14, t1.nom AS nom_15, t1.tel AS tel_16 FROM fos_user t0 LEFT JOIN utilisateur_site t1 ON t0.id = t1.id WHERE t0.id = 979;

SELECT
  t1.date_creation AS date_creation_2,
  t1.date_maj AS date_maj_3,
  t1.id AS id_4,
  t1.prenom AS prenom_5,
  t1.nom AS nom_6,
  t1.adresse AS adresse_7,
  t1.code_postal AS code_postal_8,
  t1.ville AS ville_9,
  t1.tel_domicile AS tel_domicile_10,
  t1.tel_bureau AS tel_bureau_11,
  t1.tel_mobile AS tel_mobile_12,
  t1.note_tel_mobile AS note_tel_mobile_13,
  t1.tel_mobile2 AS tel_mobile2_14,
  t1.note_tel_mobile2 AS note_tel_mobile2_15,
  t1.email AS email_16,
  t1.email2 AS email2_17,
  t0.secteur AS secteur_18,
  t0.ville_rattachement AS ville_rattachement_19,
  t0.photo AS photo_20,
  t0.display_web AS display_web_21,
  t0.position AS position_22,
  t1.civilite_id AS civilite_id_23,
  t0.utilisateur_id AS utilisateur_id_24,
  t1.discr
FROM
  negociateur t0
  INNER JOIN personne t1 ON t0.id = t1.id
WHERE
  t1.id = ?