http://immolier.com/

Query Metrics

19 Database Queries
8 Different statements
227.87 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 98.45 ms
SELECT v0_.id AS id_0, v0_.ville_id AS ville_id_1, v0_.ville_departement AS ville_departement_2, v0_.ville_slug AS ville_slug_3, v0_.ville_nom AS ville_nom_4, v0_.ville_nom_simple AS ville_nom_simple_5, v0_.ville_nom_reel AS ville_nom_reel_6, v0_.ville_nom_soundex AS ville_nom_soundex_7, v0_.ville_nom_metaphone AS ville_nom_metaphone_8, v0_.ville_code_postal AS ville_code_postal_9, v0_.ville_commune AS ville_commune_10, v0_.ville_code_commune AS ville_code_commune_11, v0_.ville_arrondissement AS ville_arrondissement_12, v0_.ville_canton AS ville_canton_13, v0_.ville_amdi AS ville_amdi_14, v0_.ville_population_2010 AS ville_population_2010_15, v0_.ville_population_1999 AS ville_population_1999_16, v0_.ville_population_2012 AS ville_population_2012_17, v0_.ville_densite_2010 AS ville_densite_2010_18, v0_.ville_surface AS ville_surface_19, v0_.ville_longitude_deg AS ville_longitude_deg_20, v0_.ville_longitude_grd AS ville_longitude_grd_21, v0_.ville_latitude_grd AS ville_latitude_grd_22, v0_.ville_longitude_dms AS ville_longitude_dms_23, v0_.ville_latitude_dms AS ville_latitude_dms_24, v0_.ville_zmin AS ville_zmin_25, v0_.ville_nom_code_postal AS ville_nom_code_postal_26, v0_.ville_latitude_deg AS ville_latitude_deg_27, v0_.ville_zmax AS ville_zmax_28, v0_.ville_population_2019 AS ville_population_2019_29 FROM villes_france v0_ ORDER BY v0_.ville_population_2012 DESC LIMIT 6
Parameters:
[]
2 7.03 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "PARIS"
  1
]
3 1.29 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "MARSEILLE"
  1
]
4 1.51 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "LYON"
  1
]
5 1.71 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "TOULOUSE"
  1
]
6 1.85 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "NICE"
  1
]
7 1.45 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ? AND t0.etat = ?
Parameters:
[
  "NANTES"
  1
]
8 86.80 ms
SELECT v0_.id AS id_0, v0_.ville_id AS ville_id_1, v0_.ville_departement AS ville_departement_2, v0_.ville_slug AS ville_slug_3, v0_.ville_nom AS ville_nom_4, v0_.ville_nom_simple AS ville_nom_simple_5, v0_.ville_nom_reel AS ville_nom_reel_6, v0_.ville_nom_soundex AS ville_nom_soundex_7, v0_.ville_nom_metaphone AS ville_nom_metaphone_8, v0_.ville_code_postal AS ville_code_postal_9, v0_.ville_commune AS ville_commune_10, v0_.ville_code_commune AS ville_code_commune_11, v0_.ville_arrondissement AS ville_arrondissement_12, v0_.ville_canton AS ville_canton_13, v0_.ville_amdi AS ville_amdi_14, v0_.ville_population_2010 AS ville_population_2010_15, v0_.ville_population_1999 AS ville_population_1999_16, v0_.ville_population_2012 AS ville_population_2012_17, v0_.ville_densite_2010 AS ville_densite_2010_18, v0_.ville_surface AS ville_surface_19, v0_.ville_longitude_deg AS ville_longitude_deg_20, v0_.ville_longitude_grd AS ville_longitude_grd_21, v0_.ville_latitude_grd AS ville_latitude_grd_22, v0_.ville_longitude_dms AS ville_longitude_dms_23, v0_.ville_latitude_dms AS ville_latitude_dms_24, v0_.ville_zmin AS ville_zmin_25, v0_.ville_nom_code_postal AS ville_nom_code_postal_26, v0_.ville_latitude_deg AS ville_latitude_deg_27, v0_.ville_zmax AS ville_zmax_28, v0_.ville_population_2019 AS ville_population_2019_29 FROM villes_france v0_ ORDER BY v0_.ville_population_2012 DESC LIMIT 6
Parameters:
[]
9 1.12 ms
SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.adresse AS adresse_3, t0.prix AS prix_4, t0.description AS description_5, t0.titre AS titre_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.codepostale AS codepostale_9, t0.image AS image_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.dpe AS dpe_14, t0.ges AS ges_15, t0.honoraires AS honoraires_16, t0.ville_slug AS ville_slug_17, t0.ville_code_postal AS ville_code_postal_18, t0.piece AS piece_19, t0.ville AS ville_20, t0.codepostal AS codepostal_21, t0.transaction AS transaction_22, t0.etat AS etat_23, t0.logement AS logement_24, t0.chauffage AS chauffage_25, t0.pieces AS pieces_26, t0.chambres AS chambres_27, t0.charges AS charges_28, t0.quantite AS quantite_29, t0.chambre AS chambre_30, t0.salledebain AS salledebain_31, t0.garage AS garage_32, t0.psedo AS psedo_33, t0.domaine AS domaine_34, t0.user_id AS user_id_35, t0.villes_france_id AS villes_france_id_36, t0.agence_id AS agence_id_37, t0.ville_annonce_id AS ville_annonce_id_38, t0.hotel_id AS hotel_id_39 FROM annonces t0 WHERE t0.ville = ?
Parameters:
[
  "angouleme"
]
10 4.27 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.user_id IS NULL
Parameters:
[]
11 4.43 ms
SELECT v0_.id AS id_0, v0_.adresseip AS adresseip_1, v0_.created_at AS created_at_2, v0_.annonce_id AS annonce_id_3, v0_.user_id AS user_id_4 FROM visiteurs v0_ WHERE v0_.user_id IN (?) OR v0_.adresseip IN (?)
Parameters:
[
  null
  "43.159.152.184"
]
12 1.65 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  1
]
13 5.11 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.commentaire AS commentaire_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.linkedin AS linkedin_7, t0.twitter AS twitter_8, t0.siteweb AS siteweb_9, t0.slug AS slug_10, t0.adresse AS adresse_11, t0.email AS email_12, t0.telephone AS telephone_13, t0.domaine AS domaine_14, t0.franchise_id AS franchise_id_15, t0.villes_france_id AS villes_france_id_16 FROM agences t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 1.65 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  2
]
15 1.25 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  3
]
16 0.80 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  4
]
17 1.01 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  5
]
18 4.88 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.adresse AS adresse_9, t0.telephone AS telephone_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.twitter AS twitter_14, t0.siteperso AS siteperso_15, t0.id_google AS id_google_16, t0.slug AS slug_17, t0.image AS image_18, t0.avarar_google AS avarar_google_19, t0.type AS type_20, t0.psedo AS psedo_21, t0.credits AS credits_22, t0.validation AS validation_23, t0.domaine AS domaine_24, t0.agence_id AS agence_id_25, t0.hotel_id AS hotel_id_26 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
19 1.62 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM post_like t0 WHERE t0.annonce_id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\VillesFrance No errors.
App\Entity\Annonces No errors.
App\Entity\User No errors.
App\Entity\Agences No errors.
App\Entity\Hotels No errors.
App\Entity\Images No errors.
App\Entity\Messages
  • The mappings App\Entity\Messages#recipient and App\Entity\User#messages are inconsistent with each other.
App\Entity\Visiteurs No errors.
App\Entity\Event
  • The mappings App\Entity\Event#intervenant and App\Entity\User#events are inconsistent with each other.
App\Entity\Reservations No errors.
App\Entity\Equipements No errors.
App\Entity\CommentairesLogements No errors.
App\Entity\PostLike No errors.
App\Entity\Franchises No errors.
App\Entity\Contact No errors.
App\Entity\Articles No errors.
App\Entity\Resetemail No errors.
App\Entity\Factures No errors.
App\Entity\Wallet No errors.
App\Entity\Transactions No errors.
App\Entity\Alertes No errors.
App\Entity\CommentairesLocataires
  • The mappings App\Entity\CommentairesLocataires#locataire and App\Entity\User#commentairesLocataires are inconsistent with each other.
App\Entity\CommentairesProprietaires
  • The mappings App\Entity\CommentairesProprietaires#proprietaire and App\Entity\User#commentairesProprietaires are inconsistent with each other.
App\Entity\Recherche No errors.