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_.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.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
  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
  count(DISTINCT p0_.IDPropriete) AS sclr_0
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT count(DISTINCT p0_.IDPropriete) AS sclr_0 FROM propriete p0_ WHERE p0_.EstActif = 1;

SELECT
  DISTINCT p0_.IDPropriete AS IDPropriete_0,
  p0_.IDPropriete AS IDPropriete_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?
ORDER BY
  p0_.IDPropriete DESC
LIMIT
  9

SELECT DISTINCT p0_.IDPropriete AS IDPropriete_0, p0_.IDPropriete AS IDPropriete_1 FROM propriete p0_ WHERE p0_.EstActif = 1 ORDER BY p0_.IDPropriete DESC LIMIT 9;

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,
  p0_.IDStatutPropriete AS IDStatutPropriete_27,
  p0_.IDTypePropriete AS IDTypePropriete_28,
  p0_.IDUtilisateurCreate AS IDUtilisateurCreate_29
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?
  AND p0_.IDPropriete IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.IDPropriete DESC

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, p0_.IDStatutPropriete AS IDStatutPropriete_27, p0_.IDTypePropriete AS IDTypePropriete_28, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_29 FROM propriete p0_ WHERE p0_.EstActif = 1 AND p0_.IDPropriete IN (35, 34, 33, 32, 31, 18, 17, 16, 14) ORDER BY p0_.IDPropriete DESC;

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

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;

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.EstActif = ?

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.EstActif = 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
WHERE
  t0.EstActif = ?

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 WHERE t0.EstActif = 1;

SELECT
  MIN(p0_.Prix) AS sclr_0,
  MAX(p0_.Prix) AS sclr_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT MIN(p0_.Prix) AS sclr_0, MAX(p0_.Prix) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = 1;

SELECT
  MIN(p0_.Surface) AS sclr_0,
  MAX(p0_.Surface) AS sclr_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT MIN(p0_.Surface) AS sclr_0, MAX(p0_.Surface) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = 1;

SELECT
  COUNT(*)
FROM
  propriete t0
WHERE
  t0.EstActif = ?

SELECT COUNT(*) FROM propriete t0 WHERE t0.EstActif = 1;

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.EstActif = ?
ORDER BY
  t0.Prix DESC
LIMIT
  6

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.EstActif = 1 ORDER BY t0.Prix DESC LIMIT 6;

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