Query Metrics
5
Database Queries
5
Different statements
2.65 ms
Query time
0
Invalid entities
14
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.90 ms (33.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.has_separate_bedroom AS has_separate_bedroom_4, t0.services AS services_5, t0.active AS active_6, t0.position AS position_7, t0.hotel_id AS hotel_id_8, t0.main_image_id AS main_image_id_9, t0.gallery_id AS gallery_id_10 FROM room t0 WHERE t0.id = ?
Parameters:
[
"841"
]
|
|
0.60 ms (22.53%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.type_event AS type_event_3, t0.ref AS ref_4, t0.name AS name_5, t0.description AS description_6, t0.website AS website_7, t0.stars AS stars_8, t0.you_tube_video_id AS you_tube_video_id_9, t0.phone AS phone_10, t0.email AS email_11, t0.reservation_email AS reservation_email_12, t0.accompanist_email AS accompanist_email_13, t0.trip_advisor_widget AS trip_advisor_widget_14, t0.min_nights AS min_nights_15, t0.google_map_url AS google_map_url_16, t0.check_in_time AS check_in_time_17, t0.check_out_time AS check_out_time_18, t0.teen_age_max AS teen_age_max_19, t0.child_age_max AS child_age_max_20, t0.baby_age_max AS baby_age_max_21, t0.margin AS margin_22, t0.free_for_children_sharing_room AS free_for_children_sharing_room_23, t0.free_age_min AS free_age_min_24, t0.free_age_max AS free_age_max_25, t0.strict_departure_countries AS strict_departure_countries_26, t0.hotel_only_disable AS hotel_only_disable_27, t0.active AS active_28, t0.created_uid AS created_uid_29, t0.updated_uid AS updated_uid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.contact_name AS contact_name_33, t0.contact_email AS contact_email_34, t0.contact_phone AS contact_phone_35, t0.contact_role AS contact_role_36, t0.address_line_1 AS address_line_1_37, t0.address_line_2 AS address_line_2_38, t0.address_postal_code AS address_postal_code_39, t0.address_city AS address_city_40, t0.address_country AS address_country_41, t0.pension_type_id AS pension_type_id_42, t0.default_formule_id AS default_formule_id_43, t0.default_supplement_id AS default_supplement_id_44, t0.booking_fee_id AS booking_fee_id_45, t0.country_id AS country_id_46, t0.home_image_id AS home_image_id_47, t0.main_image_id AS main_image_id_48, t0.gallery_id AS gallery_id_49 FROM hotel t0 WHERE t0.id = ?
Parameters:
[
201
]
|
|
0.42 ms (15.75%) |
1 |
SELECT t0.position AS position_1, t0.enabled AS enabled_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.id AS id_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_item t0 WHERE t0.gallery_id = ? ORDER BY t0.position ASC
Parameters:
[
561
]
|
|
0.39 ms (14.51%) |
1 |
SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.name AS name_3, t0.country AS country_4, t0.active AS active_5, t0.display_home AS display_home_6, t0.sort AS sort_7, t0.city_id AS city_id_8, t0.zone_id AS zone_id_9, t0.main_image_id AS main_image_id_10, t0.gallery_id AS gallery_id_11 FROM country t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.35 ms (13.30%) |
1 |
SELECT t0.name AS name_1, t0.context AS context_2, t0.default_format AS default_format_3, t0.enabled AS enabled_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.id AS id_7, t0.for_tag_id AS for_tag_id_8 FROM media__gallery t0 WHERE t0.id = ?
Parameters:
[
561
]
|
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\Media | 3 |
| App\Entity\Gallery | 3 |
| App\Entity\Room | 1 |
| App\Entity\Hotel | 1 |
| App\Entity\PensionType | 1 |
| App\Entity\Supplement | 1 |
| App\Entity\BookingFee | 1 |
| App\Entity\Country | 1 |
| App\Entity\IataCity | 1 |
| App\Entity\Zone | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Room | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Hotel | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Entity\Media | No errors. |
| Sonata\MediaBundle\Entity\BaseGallery | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Capacity | No errors. |
| App\Entity\SeparateBedroomCapacity | No errors. |
| App\Entity\RoomRate | No errors. |
| App\Entity\StopSale | No errors. |
| App\Entity\OnDemand | No errors. |
| App\Entity\PensionType | No errors. |
| App\Entity\Supplement | No errors. |
| App\Entity\BookingFee | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Transfer | No errors. |
| App\Entity\Promotion | No errors. |
| App\Entity\CancelItem | No errors. |
| App\Entity\IataCity | No errors. |
| App\Entity\Zone | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\GalleryItem | No errors. |