http://immolier.com/logement/Vente-Maison-ANGOULEME-120m2-7700-Euros-3

Query Metrics

3 Database Queries
2 Different statements
4.52 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 3.13 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.slug = ? LIMIT 1
Parameters:
[
  "Vente-Maison-ANGOULEME-120m2-7700-Euros-3"
]
2 0.83 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.slug = ? LIMIT 1
Parameters:
[
  "Vente-Maison-ANGOULEME-120m2-7700-Euros-3"
]
3 0.57 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:
[
  1
]

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\Annonces No errors.
App\Entity\User No errors.
App\Entity\VillesFrance 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\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.
App\Entity\Contact No errors.