Symfony Profiler

SELECT
  t0.IDDevise AS IDDevise_1,
  t0.LibelleDevise AS LibelleDevise_2,
  t0.EstActif AS EstActif_3,
  t0.TauxConversion AS TauxConversion_4,
  t0.Symbole AS Symbole_5
FROM
  devise t0
WHERE
  t0.LibelleDevise = ?
LIMIT
  1

SELECT t0.IDDevise AS IDDevise_1, t0.LibelleDevise AS LibelleDevise_2, t0.EstActif AS EstActif_3, t0.TauxConversion AS TauxConversion_4, t0.Symbole AS Symbole_5 FROM devise t0 WHERE t0.LibelleDevise = 'US Dollar' LIMIT 1;

SELECT
  t0.IDUniteMesure AS IDUniteMesure_1,
  t0.Libelle_FR AS Libelle_FR_2,
  t0.EstActif AS EstActif_3,
  t0.Tauxconversion AS Tauxconversion_4,
  t0.Libelle_EN AS Libelle_EN_5,
  t0.Libelle_LU AS Libelle_LU_6,
  t0.Symbole AS Symbole_7
FROM
  unitemesure t0
WHERE
  t0.Libelle_EN = ?
LIMIT
  1

SELECT t0.IDUniteMesure AS IDUniteMesure_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.Tauxconversion AS Tauxconversion_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Symbole AS Symbole_7 FROM unitemesure t0 WHERE t0.Libelle_EN = 'Square foot' LIMIT 1;

SELECT
  p0_.IDPropriete AS IDPropriete_0,
  p0_.Reference AS Reference_1,
  p0_.TitreFR AS TitreFR_2,
  p0_.DescriptionLongueFR AS DescriptionLongueFR_3,
  p0_.Prix AS Prix_4,
  p0_.AncienPrix AS AncienPrix_5,
  p0_.Localisation AS Localisation_6,
  p0_.Adresse AS Adresse_7,
  p0_.NbChambres AS NbChambres_8,
  p0_.NbSalleBains AS NbSalleBains_9,
  p0_.Surface AS Surface_10,
  p0_.Parking AS Parking_11,
  p0_.EstActif AS EstActif_12,
  p0_.AnneeConstruction AS AnneeConstruction_13,
  p0_.DateCreation AS DateCreation_14,
  p0_.DateModif AS DateModif_15,
  p0_.NomProprietaire AS NomProprietaire_16,
  p0_.AdresseProprietaire AS AdresseProprietaire_17,
  p0_.TelProprietaire AS TelProprietaire_18,
  p0_.EmailProprietaire AS EmailProprietaire_19,
  p0_.TitreEN AS TitreEN_20,
  p0_.TitreLU AS TitreLU_21,
  p0_.DescCourteFR AS DescCourteFR_22,
  p0_.DescCourteEN AS DescCourteEN_23,
  p0_.DescCourteLU AS DescCourteLU_24,
  p0_.DescriptionLongEN AS DescriptionLongEN_25,
  p0_.DescriptionLongLU AS DescriptionLongLU_26,
  (
    CASE WHEN p0_.Prix >= ? THEN
      p0_.Prix - ?
    ELSE
      ? - p0_.Prix
    END
  ) AS sclr_27,
  p0_.IDStatutPropriete AS IDStatutPropriete_28,
  p0_.IDTypePropriete AS IDTypePropriete_29,
  p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30
FROM
  propriete p0_
WHERE
  p0_.IDTypePropriete = ?
  AND p0_.IDPropriete <> ?
  AND p0_.EstActif = 1
ORDER BY
  sclr_27 ASC
LIMIT
  3

SELECT p0_.IDPropriete AS IDPropriete_0, p0_.Reference AS Reference_1, p0_.TitreFR AS TitreFR_2, p0_.DescriptionLongueFR AS DescriptionLongueFR_3, p0_.Prix AS Prix_4, p0_.AncienPrix AS AncienPrix_5, p0_.Localisation AS Localisation_6, p0_.Adresse AS Adresse_7, p0_.NbChambres AS NbChambres_8, p0_.NbSalleBains AS NbSalleBains_9, p0_.Surface AS Surface_10, p0_.Parking AS Parking_11, p0_.EstActif AS EstActif_12, p0_.AnneeConstruction AS AnneeConstruction_13, p0_.DateCreation AS DateCreation_14, p0_.DateModif AS DateModif_15, p0_.NomProprietaire AS NomProprietaire_16, p0_.AdresseProprietaire AS AdresseProprietaire_17, p0_.TelProprietaire AS TelProprietaire_18, p0_.EmailProprietaire AS EmailProprietaire_19, p0_.TitreEN AS TitreEN_20, p0_.TitreLU AS TitreLU_21, p0_.DescCourteFR AS DescCourteFR_22, p0_.DescCourteEN AS DescCourteEN_23, p0_.DescCourteLU AS DescCourteLU_24, p0_.DescriptionLongEN AS DescriptionLongEN_25, p0_.DescriptionLongLU AS DescriptionLongLU_26, (CASE WHEN p0_.Prix >= 390000 THEN p0_.Prix - 390000 ELSE 390000 - p0_.Prix END) AS sclr_27, p0_.IDStatutPropriete AS IDStatutPropriete_28, p0_.IDTypePropriete AS IDTypePropriete_29, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete p0_ WHERE p0_.IDTypePropriete = 3 AND p0_.IDPropriete <> 33 AND p0_.EstActif = 1 ORDER BY sclr_27 ASC LIMIT 3;

SELECT
  p0_.IDPropriete AS IDPropriete_0,
  p0_.Reference AS Reference_1,
  p0_.TitreFR AS TitreFR_2,
  p0_.DescriptionLongueFR AS DescriptionLongueFR_3,
  p0_.Prix AS Prix_4,
  p0_.AncienPrix AS AncienPrix_5,
  p0_.Localisation AS Localisation_6,
  p0_.Adresse AS Adresse_7,
  p0_.NbChambres AS NbChambres_8,
  p0_.NbSalleBains AS NbSalleBains_9,
  p0_.Surface AS Surface_10,
  p0_.Parking AS Parking_11,
  p0_.EstActif AS EstActif_12,
  p0_.AnneeConstruction AS AnneeConstruction_13,
  p0_.DateCreation AS DateCreation_14,
  p0_.DateModif AS DateModif_15,
  p0_.NomProprietaire AS NomProprietaire_16,
  p0_.AdresseProprietaire AS AdresseProprietaire_17,
  p0_.TelProprietaire AS TelProprietaire_18,
  p0_.EmailProprietaire AS EmailProprietaire_19,
  p0_.TitreEN AS TitreEN_20,
  p0_.TitreLU AS TitreLU_21,
  p0_.DescCourteFR AS DescCourteFR_22,
  p0_.DescCourteEN AS DescCourteEN_23,
  p0_.DescCourteLU AS DescCourteLU_24,
  p0_.DescriptionLongEN AS DescriptionLongEN_25,
  p0_.DescriptionLongLU AS DescriptionLongLU_26,
  (
    CASE WHEN p0_.Prix >= ? THEN
      p0_.Prix - ?
    ELSE
      ? - p0_.Prix
    END
  ) AS sclr_27,
  p0_.IDStatutPropriete AS IDStatutPropriete_28,
  p0_.IDTypePropriete AS IDTypePropriete_29,
  p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30
FROM
  propriete p0_
WHERE
  p0_.IDPropriete NOT IN (?, ?, ?)
  AND p0_.EstActif = 1
ORDER BY
  sclr_27 ASC
LIMIT
  1

SELECT p0_.IDPropriete AS IDPropriete_0, p0_.Reference AS Reference_1, p0_.TitreFR AS TitreFR_2, p0_.DescriptionLongueFR AS DescriptionLongueFR_3, p0_.Prix AS Prix_4, p0_.AncienPrix AS AncienPrix_5, p0_.Localisation AS Localisation_6, p0_.Adresse AS Adresse_7, p0_.NbChambres AS NbChambres_8, p0_.NbSalleBains AS NbSalleBains_9, p0_.Surface AS Surface_10, p0_.Parking AS Parking_11, p0_.EstActif AS EstActif_12, p0_.AnneeConstruction AS AnneeConstruction_13, p0_.DateCreation AS DateCreation_14, p0_.DateModif AS DateModif_15, p0_.NomProprietaire AS NomProprietaire_16, p0_.AdresseProprietaire AS AdresseProprietaire_17, p0_.TelProprietaire AS TelProprietaire_18, p0_.EmailProprietaire AS EmailProprietaire_19, p0_.TitreEN AS TitreEN_20, p0_.TitreLU AS TitreLU_21, p0_.DescCourteFR AS DescCourteFR_22, p0_.DescCourteEN AS DescCourteEN_23, p0_.DescCourteLU AS DescCourteLU_24, p0_.DescriptionLongEN AS DescriptionLongEN_25, p0_.DescriptionLongLU AS DescriptionLongLU_26, (CASE WHEN p0_.Prix >= 390000 THEN p0_.Prix - 390000 ELSE 390000 - p0_.Prix END) AS sclr_27, p0_.IDStatutPropriete AS IDStatutPropriete_28, p0_.IDTypePropriete AS IDTypePropriete_29, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete p0_ WHERE p0_.IDPropriete NOT IN (12, 9, 33) AND p0_.EstActif = 1 ORDER BY sclr_27 ASC LIMIT 1;

SELECT
  t0.IDEquipement AS IDEquipement_1,
  t0.Libelle_FR AS Libelle_FR_2,
  t0.EstActif AS EstActif_3,
  t0.DateCreation AS DateCreation_4,
  t0.Icone AS Icone_5,
  t0.Libelle_EN AS Libelle_EN_6,
  t0.Libelle_LU AS Libelle_LU_7
FROM
  equipement t0
  INNER JOIN propriete_equipement ON t0.IDEquipement = propriete_equipement.IDEquipement
WHERE
  propriete_equipement.IDPropriete = ?

SELECT t0.IDEquipement AS IDEquipement_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.DateCreation AS DateCreation_4, t0.Icone AS Icone_5, t0.Libelle_EN AS Libelle_EN_6, t0.Libelle_LU AS Libelle_LU_7 FROM equipement t0 INNER JOIN propriete_equipement ON t0.IDEquipement = propriete_equipement.IDEquipement WHERE propriete_equipement.IDPropriete = 33;

SELECT
  t0.IDPropriete AS IDPropriete_1,
  t0.Reference AS Reference_2,
  t0.TitreFR AS TitreFR_3,
  t0.DescriptionLongueFR AS DescriptionLongueFR_4,
  t0.Prix AS Prix_5,
  t0.AncienPrix AS AncienPrix_6,
  t0.Localisation AS Localisation_7,
  t0.Adresse AS Adresse_8,
  t0.NbChambres AS NbChambres_9,
  t0.NbSalleBains AS NbSalleBains_10,
  t0.Surface AS Surface_11,
  t0.Parking AS Parking_12,
  t0.EstActif AS EstActif_13,
  t0.AnneeConstruction AS AnneeConstruction_14,
  t0.DateCreation AS DateCreation_15,
  t0.DateModif AS DateModif_16,
  t0.NomProprietaire AS NomProprietaire_17,
  t0.AdresseProprietaire AS AdresseProprietaire_18,
  t0.TelProprietaire AS TelProprietaire_19,
  t0.EmailProprietaire AS EmailProprietaire_20,
  t0.TitreEN AS TitreEN_21,
  t0.TitreLU AS TitreLU_22,
  t0.DescCourteFR AS DescCourteFR_23,
  t0.DescCourteEN AS DescCourteEN_24,
  t0.DescCourteLU AS DescCourteLU_25,
  t0.DescriptionLongEN AS DescriptionLongEN_26,
  t0.DescriptionLongLU AS DescriptionLongLU_27,
  t0.IDStatutPropriete AS IDStatutPropriete_28,
  t0.IDTypePropriete AS IDTypePropriete_29,
  t0.IDUtilisateurCreate AS IDUtilisateurCreate_30
FROM
  propriete t0
WHERE
  t0.IDPropriete = ?

SELECT t0.IDPropriete AS IDPropriete_1, t0.Reference AS Reference_2, t0.TitreFR AS TitreFR_3, t0.DescriptionLongueFR AS DescriptionLongueFR_4, t0.Prix AS Prix_5, t0.AncienPrix AS AncienPrix_6, t0.Localisation AS Localisation_7, t0.Adresse AS Adresse_8, t0.NbChambres AS NbChambres_9, t0.NbSalleBains AS NbSalleBains_10, t0.Surface AS Surface_11, t0.Parking AS Parking_12, t0.EstActif AS EstActif_13, t0.AnneeConstruction AS AnneeConstruction_14, t0.DateCreation AS DateCreation_15, t0.DateModif AS DateModif_16, t0.NomProprietaire AS NomProprietaire_17, t0.AdresseProprietaire AS AdresseProprietaire_18, t0.TelProprietaire AS TelProprietaire_19, t0.EmailProprietaire AS EmailProprietaire_20, t0.TitreEN AS TitreEN_21, t0.TitreLU AS TitreLU_22, t0.DescCourteFR AS DescCourteFR_23, t0.DescCourteEN AS DescCourteEN_24, t0.DescCourteLU AS DescCourteLU_25, t0.DescriptionLongEN AS DescriptionLongEN_26, t0.DescriptionLongLU AS DescriptionLongLU_27, t0.IDStatutPropriete AS IDStatutPropriete_28, t0.IDTypePropriete AS IDTypePropriete_29, t0.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete t0 WHERE t0.IDPropriete = '33';

SELECT
  t0.IDImagePropriete AS IDImagePropriete_1,
  t0.LienImage AS LienImage_2,
  t0.EstMiseEnAvant AS EstMiseEnAvant_3,
  t0.EstActif AS EstActif_4,
  t0.DateCreation AS DateCreation_5,
  t0.IDPropriete AS IDPropriete_6
FROM
  imagepropriete t0
WHERE
  t0.IDPropriete = ?

SELECT t0.IDImagePropriete AS IDImagePropriete_1, t0.LienImage AS LienImage_2, t0.EstMiseEnAvant AS EstMiseEnAvant_3, t0.EstActif AS EstActif_4, t0.DateCreation AS DateCreation_5, t0.IDPropriete AS IDPropriete_6 FROM imagepropriete t0 WHERE t0.IDPropriete = 33;

SELECT
  t0.IDParametre AS IDParametre_1,
  t0.Nom AS Nom_2,
  t0.Slug AS Slug_3,
  t0.Valeur AS Valeur_4,
  t0.Type AS Type_5
FROM
  parametre t0
WHERE
  t0.Slug = ?
LIMIT
  1

SELECT t0.IDParametre AS IDParametre_1, t0.Nom AS Nom_2, t0.Slug AS Slug_3, t0.Valeur AS Valeur_4, t0.Type AS Type_5 FROM parametre t0 WHERE t0.Slug = 'social_facebook' LIMIT 1;

SELECT
  t0.IDStatutPropriete AS IDStatutPropriete_1,
  t0.Slug AS Slug_2,
  t0.Libelle_FR AS Libelle_FR_3,
  t0.Libelle_EN AS Libelle_EN_4,
  t0.Libelle_LU AS Libelle_LU_5,
  t0.Couleur AS Couleur_6
FROM
  statutpropriete t0
WHERE
  t0.IDStatutPropriete = ?

SELECT t0.IDStatutPropriete AS IDStatutPropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.Libelle_EN AS Libelle_EN_4, t0.Libelle_LU AS Libelle_LU_5, t0.Couleur AS Couleur_6 FROM statutpropriete t0 WHERE t0.IDStatutPropriete = 3;

SELECT
  p0_.IDParametre AS IDParametre_0,
  p0_.Nom AS Nom_1,
  p0_.Slug AS Slug_2,
  p0_.Valeur AS Valeur_3,
  p0_.Type AS Type_4
FROM
  parametre p0_
WHERE
  p0_.Slug LIKE ?

SELECT p0_.IDParametre AS IDParametre_0, p0_.Nom AS Nom_1, p0_.Slug AS Slug_2, p0_.Valeur AS Valeur_3, p0_.Type AS Type_4 FROM parametre p0_ WHERE p0_.Slug LIKE 'social_%';

SELECT
  t0.IDTypePropriete AS IDTypePropriete_1,
  t0.Slug AS Slug_2,
  t0.Libelle_FR AS Libelle_FR_3,
  t0.EstActif AS EstActif_4,
  t0.Libelle_EN AS Libelle_EN_5,
  t0.Libelle_LU AS Libelle_LU_6,
  t0.Icone AS Icone_7
FROM
  typepropriete t0
WHERE
  t0.IDTypePropriete = ?

SELECT t0.IDTypePropriete AS IDTypePropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.EstActif AS EstActif_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Icone AS Icone_7 FROM typepropriete t0 WHERE t0.IDTypePropriete = 3;