POST https://admin.receptiongo.com/t/greenslo/guests/62/delete

Query Metrics

7 Database Queries
7 Different statements
11.00 ms Query time
1 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 1.82 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token AS token_5 FROM admin t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 2.52 ms
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.check_in_time AS check_in_time_4, t0.check_out_time AS check_out_time_5, t0.is_auto_send AS is_auto_send_6, t0.slug AS slug_7, t0.booking_provider AS booking_provider_8, t0.payment_provider AS payment_provider_9, t0.smart_lock_provider AS smart_lock_provider_10, t0.tourism_registry_provider AS tourism_registry_provider_11, t0.ai_assistant_provider AS ai_assistant_provider_12, t0.city_tax_under7 AS city_tax_under7_13, t0.city_tax7_to18 AS city_tax7_to18_14, t0.city_tax18_and_over AS city_tax18_and_over_15, t0.admin_id AS admin_id_16 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "greenslo"
]
3 0.93 ms
SELECT t0.id AS id_1, t0.booking_id AS booking_id_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.document_number AS document_number_5, t0.document_type AS document_type_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.registration_date AS registration_date_10, t0.check_in_date AS check_in_date_11, t0.check_in_time AS check_in_time_12, t0.check_out_date AS check_out_date_13, t0.check_out_time AS check_out_time_14, t0.city_tax_exemption AS city_tax_exemption_15, t0.referer AS referer_16, t0.property_name AS property_name_17, t0.is_reported AS is_reported_18, t0.hotel_id AS hotel_id_19, t0.room_id AS room_id_20 FROM guest t0 WHERE t0.id = ?
Parameters:
[
  "62"
]
4 0.52 ms
"START TRANSACTION"
Parameters:
[]
5 0.92 ms
UPDATE hotel SET city_tax_under7 = ?, city_tax7_to18 = ?, city_tax18_and_over = ? WHERE id = ?
Parameters:
[
  0.0
  1.57
  3.13
  1
]
6 1.36 ms
DELETE FROM guest WHERE id = ?
Parameters:
[
  62
]
7 2.92 ms
"COMMIT"
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\Admin 1
App\Entity\Hotel 1
App\Entity\Room 1
App\Entity\Guest 0

Entities Mapping

Class Mapping errors
App\Entity\Admin No errors.
App\Entity\Hotel
  • The field 'App\Entity\Hotel#cityTaxUnder7' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Hotel#cityTax7To18' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Hotel#cityTax18AndOver' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Info No errors.
App\Entity\Guest No errors.
App\Entity\Room No errors.