https://rusticavoyages.com/detail/282

Query Metrics

4 Database Queries
4 Different statements
4.42 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.83 ms
(41.53%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.maps AS maps_3, t0.star AS star_4, t0.maxenfant AS maxenfant_5, t0.minenfant AS minenfant_6, t0.shortdesc AS shortdesc_7, t0.visite AS visite_8, t0.longdesc AS longdesc_9, t0.etat AS etat_10, t0.pays_id AS pays_id_11, t0.ville_id AS ville_id_12 FROM hotel t0 WHERE t0.id = ?
Parameters:
[
  "282"
]
0.94 ms
(21.23%)
1
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.maps AS maps_2, h0_.star AS star_3, h0_.maxenfant AS maxenfant_4, h0_.minenfant AS minenfant_5, h0_.shortdesc AS shortdesc_6, h0_.visite AS visite_7, h0_.longdesc AS longdesc_8, h0_.etat AS etat_9, h0_.pays_id AS pays_id_10, h0_.ville_id AS ville_id_11 FROM hotel h0_ WHERE h0_.id = ? AND h0_.etat = 1
Parameters:
[
  282
]
0.90 ms
(20.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_id AS hotel_id_3 FROM imageshotels t0 WHERE t0.hotel_id = ?
Parameters:
[
  282
]
0.74 ms
(16.80%)
1
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.maps AS maps_2, h0_.star AS star_3, h0_.maxenfant AS maxenfant_4, h0_.minenfant AS minenfant_5, h0_.shortdesc AS shortdesc_6, h0_.visite AS visite_7, h0_.longdesc AS longdesc_8, h0_.etat AS etat_9, h0_.pays_id AS pays_id_10, h0_.ville_id AS ville_id_11 FROM hotel h0_ WHERE h0_.etat = 1
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\Hotel
  • The mappings App\Entity\Hotel#ville and App\Entity\Villes#hotels are inconsistent with each other.
App\Entity\Pays No errors.
App\Entity\Villes
  • The association App\Entity\Villes#hotels refers to the owning side field App\Entity\Hotel#villes which does not exist.
App\Entity\Hotelroom
  • The association App\Entity\Hotelroom#chambre refers to the inverse side field App\Entity\Chambre#hotelrooms which does not exist.
App\Entity\Hotelprice No errors.
App\Entity\Hotelarrangement No errors.
App\Entity\Imageshotels No errors.
App\Entity\Hotelsupplement
  • The association App\Entity\Hotelsupplement#supplement refers to the inverse side field App\Entity\Supplements#hotelsupplements which does not exist.
App\Entity\Reservationhotel
  • The association App\Entity\Reservationhotel#client refers to the inverse side field App\Entity\Client#reservationhotels which does not exist.
App\Entity\Service No errors.