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_.negociateur_id AS negociateur_id_40,
  o0_.departement_id AS departement_id_41
FROM
  offre o0_
WHERE
  o0_.display_site = 1
  AND o0_.archive = 0
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_.negociateur_id AS negociateur_id_40, o0_.departement_id AS departement_id_41 FROM offre o0_ WHERE o0_.display_site = 1 AND o0_.archive = 0 ORDER BY o0_.date_creation DESC;

SELECT
  a0_.date_creation AS date_creation_0,
  a0_.date_maj AS date_maj_1,
  a0_.id AS id_2,
  a0_.texte AS texte_3,
  a0_.display AS display_4
FROM
  actualite a0_
WHERE
  a0_.display = 1
ORDER BY
  a0_.date_creation DESC
LIMIT
  1

SELECT a0_.date_creation AS date_creation_0, a0_.date_maj AS date_maj_1, a0_.id AS id_2, a0_.texte AS texte_3, a0_.display AS display_4 FROM actualite a0_ WHERE a0_.display = 1 ORDER BY a0_.date_creation DESC LIMIT 1;

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

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

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

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

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

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

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