Query Metrics
9
Database Queries
3
Different statements
1.88 ms
Query time
0
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
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.type = ? ORDER BY t0.id DESC
Parameters:
[
2
]
|
| 2 | 0.20 ms |
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.type = ? ORDER BY t0.id DESC LIMIT 4
Parameters:
[
1
]
|
| 3 | 0.27 ms |
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.id = ?
Parameters:
[
33
]
|
| 4 | 0.18 ms |
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.id = ?
Parameters:
[
20
]
|
| 5 | 0.18 ms |
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.id = ?
Parameters:
[
11
]
|
| 6 | 0.17 ms |
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.id = ?
Parameters:
[
346
]
|
| 7 | 0.17 ms |
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.id = ?
Parameters:
[
292
]
|
| 8 | 0.16 ms |
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.id = ?
Parameters:
[
16
]
|
| 9 | 0.17 ms |
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.id = ?
Parameters:
[
169
]
|
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\HotelVideo | 8 |
| App\Entity\Hotel | 7 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\HotelVideo | No errors. |
| App\Entity\Hotel | No errors. |