Query Metrics
4
Database Queries
4
Different statements
4.67 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.10 ms (44.96%) |
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:
[
"287"
]
|
1.04 ms (22.19%) |
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:
[
287
]
|
0.78 ms (16.63%) |
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:
[
287
]
|
0.76 ms (16.22%) |
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 |
|
App\Entity\Pays | No errors. |
App\Entity\Villes |
|
App\Entity\Hotelroom |
|
App\Entity\Hotelprice | No errors. |
App\Entity\Hotelarrangement | No errors. |
App\Entity\Imageshotels | No errors. |
App\Entity\Hotelsupplement |
|
App\Entity\Reservationhotel |
|
App\Entity\Service | No errors. |