GET https://www.wattine-immobilier.com/annonce/93-hossegor-entre-lac-et-mer-immobilier-maison-a-vendre-plages/fr

Query Metrics

3 Database Queries
3 Different statements
7.39 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.28 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.title AS title_3, t0.mots_cles AS mots_cles_4, t0.keyword AS keyword_5, t0.description AS description_6, t0.property_description AS property_description_7, t0.reference AS reference_8, t0.prix AS prix_9, t0.prix_visible AS prix_visible_10, t0.titre_vendu AS titre_vendu_11, t0.title_vendu AS title_vendu_12, t0.created_at AS created_at_13, t0.titre_text AS titre_text_14, t0.title_text AS title_text_15, t0.excellence AS excellence_16, t0.new_date AS new_date_17, t0.slug AS slug_18, t0.slug_en AS slug_en_19, t0.status_id AS status_id_20 FROM annonce t0 WHERE t0.id = ?
Parameters:
[
  93
]
2 1.31 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.order_index AS order_index_3, t0.annonce_id AS annonce_id_4 FROM photos t0 WHERE t0.annonce_id = ? ORDER BY t0.order_index ASC
Parameters:
[
  93
]
3 3.80 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.title AS title_3, t0.mots_cles AS mots_cles_4, t0.keyword AS keyword_5, t0.description AS description_6, t0.property_description AS property_description_7, t0.reference AS reference_8, t0.prix AS prix_9, t0.prix_visible AS prix_visible_10, t0.titre_vendu AS titre_vendu_11, t0.title_vendu AS title_vendu_12, t0.created_at AS created_at_13, t0.titre_text AS titre_text_14, t0.title_text AS title_text_15, t0.excellence AS excellence_16, t0.new_date AS new_date_17, t0.slug AS slug_18, t0.slug_en AS slug_en_19, t0.status_id AS status_id_20 FROM annonce t0 ORDER BY t0.prix DESC
Parameters:
[]

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\Annonce
  • The mappings App\Entity\Annonce#contacts and App\Entity\Contact#annonces are inconsistent with each other.
App\Entity\Status No errors.
App\Entity\Photo No errors.
App\Entity\Contact
  • The association App\Entity\Contact#annonces refers to the inverse side field App\Entity\Annonce#contact which does not exist.