Query Metrics
4
Database Queries
4
Different statements
1.45 ms
Query time
0
Invalid entities
55
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.62 ms (42.87%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.adress AS adress_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.parking_slots_count AS parking_slots_count_7, t0.parking_slots_cost AS parking_slots_cost_8, t0.db_event_ticket AS db_event_ticket_9, t0.mostly_booked_by AS mostly_booked_by_10, t0.theme AS theme_11, t0.stars AS stars_12, t0.rating_booking_com AS rating_booking_com_13, t0.rating_booking_com_date AS rating_booking_com_date_14, t0.furnishing AS furnishing_15, t0.last_renovation AS last_renovation_16, t0.internet_speed AS internet_speed_17, t0.social_program AS social_program_18, t0.unique_features AS unique_features_19, t0.event_rooms_count AS event_rooms_count_20, t0.biggest_event_rooms_size AS biggest_event_rooms_size_21, t0.rooms_count AS rooms_count_22, t0.email AS email_23, t0.website AS website_24, t0.max_person_count AS max_person_count_25, t0.price_single_room_breakfast AS price_single_room_breakfast_26, t0.price_conference_package AS price_conference_package_27, t0.distance_airport AS distance_airport_28, t0.distance_main_station AS distance_main_station_29, t0.distance_local_station AS distance_local_station_30, t0.distance_city_center AS distance_city_center_31, t0.distance_highway AS distance_highway_32, t0.distance_fair AS distance_fair_33, t0.distance_public_transport AS distance_public_transport_34, t0.slug AS slug_35, t0.priority AS priority_36, t0.paused AS paused_37, t0.hotel_chain AS hotel_chain_38 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"hotel-wutzschleife"
]
|
|
0.34 ms (23.58%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.sort_order AS sort_order_4, t0.path AS path_5, t0.hotel_id AS hotel_id_6 FROM hotel_image t0 WHERE t0.hotel_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
30
]
|
|
0.32 ms (22.20%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.sort_order AS sort_order_4, t0.type AS type_5, t0.hotel_id AS hotel_id_6 FROM hotel_video t0 WHERE t0.hotel_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
30
]
|
|
0.16 ms (11.35%) |
1 |
SELECT t0.id AS id_1, t0.distance AS distance_2, t0.title AS title_3, t0.hotel_id AS hotel_id_4 FROM distance t0 WHERE t0.hotel_id = ?
Parameters:
[
30
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\HotelImage | 50 |
| App\Entity\HotelVideo | 4 |
| App\Entity\Hotel | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Hotel | No errors. |
| App\Entity\HotelVideo | No errors. |
| App\Entity\HotelImage | No errors. |
| App\Entity\Distance | No errors. |