GET https://sandbox.myhomestay2u.com/sitemap.xml

Query Metrics

3 Database Queries
3 Different statements
3.59 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.47 ms
(41.09%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.rental_fee AS rental_fee_3, t0.facilities AS facilities_4, t0.capacity AS capacity_5, t0.beds AS beds_6, t0.archived AS archived_7, t0.id AS id_8, t0.created AS created_9, t0.updated AS updated_10, t0.saved AS saved_11, t0.property_id AS property_id_12, t0.cover_photo_id AS cover_photo_id_13 FROM property_unit t0 WHERE t0.id IN (?)
Parameters:
[
  "4b908bcb"
]
1.11 ms
(30.97%)
1
SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.short_description AS short_description_2, p0_.long_description AS long_description_3, p0_.state AS state_4, p0_.city AS city_5, p0_.area AS area_6, p0_.full_address AS full_address_7, p0_.booking_gap AS booking_gap_8, p0_.whatsapp_number AS whatsapp_number_9, p0_.facilities AS facilities_10, p0_.archived AS archived_11, p0_.poi AS poi_12, p0_.booking_max_nights AS booking_max_nights_13, p0_.location_tag AS location_tag_14, p0_.type AS type_15, p0_.id AS id_16, p0_.created AS created_17, p0_.updated AS updated_18, p0_.saved AS saved_19, p0_.owner_id AS owner_id_20, p0_.single_unit_id AS single_unit_id_21, p0_.cover_photo_id AS cover_photo_id_22 FROM property p0_
Parameters:
[]
1.00 ms
(27.94%)
1
SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.short_description AS short_description_2, p0_.long_description AS long_description_3, p0_.state AS state_4, p0_.city AS city_5, p0_.area AS area_6, p0_.full_address AS full_address_7, p0_.booking_gap AS booking_gap_8, p0_.whatsapp_number AS whatsapp_number_9, p0_.facilities AS facilities_10, p0_.archived AS archived_11, p0_.poi AS poi_12, p0_.booking_max_nights AS booking_max_nights_13, p0_.location_tag AS location_tag_14, p0_.type AS type_15, p0_.id AS id_16, p0_.created AS created_17, p0_.updated AS updated_18, p0_.saved AS saved_19, p0_.owner_id AS owner_id_20, p0_.single_unit_id AS single_unit_id_21, p0_.cover_photo_id AS cover_photo_id_22 FROM property p0_ ORDER BY p0_.saved DESC LIMIT 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PropertyPhoto 2
App\Entity\Property 1
App\Entity\OwnerAccount 1
App\Entity\PropertyUnit 1

Entities Mapping

Class Mapping errors
App\Entity\Property No errors.
App\Entity\OwnerAccount No errors.
App\Entity\PropertyUnit No errors.
App\Entity\PropertyPhoto No errors.
App\Entity\Booking No errors.
App\Entity\BookingRestriction No errors.
App\Entity\PropertyView No errors.