Query Metrics

4 Database Queries
4 Different statements
25.49 ms Query time
1 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.28 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 0.91 ms
SELECT DISTINCT h0_.id AS id_0 FROM hotel h0_ LIMIT 20
Parameters:
[]
3 0.90 ms
SELECT h0_.id AS id_0, h0_.domain AS domain_1, h0_.name AS name_2, h0_.check_in_time AS check_in_time_3, h0_.check_out_time AS check_out_time_4, h0_.is_auto_send AS is_auto_send_5, h0_.slug AS slug_6, h0_.booking_provider AS booking_provider_7, h0_.payment_provider AS payment_provider_8, h0_.smart_lock_provider AS smart_lock_provider_9, h0_.tourism_registry_provider AS tourism_registry_provider_10, h0_.ai_assistant_provider AS ai_assistant_provider_11, h0_.city_tax_under7 AS city_tax_under7_12, h0_.city_tax7_to18 AS city_tax7_to18_13, h0_.city_tax18_and_over AS city_tax18_and_over_14, h0_.admin_id AS admin_id_15 FROM hotel h0_ WHERE h0_.id IN (?, ?, ?)
Parameters:
[
  1
  2
  3
]
4 22.40 ms
SELECT count(h0_.id) AS sclr_0 FROM hotel h0_
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\Hotel 3
App\Entity\Admin 1

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.