https://new.escappart.com/block-nights

Query Metrics

7 Database Queries
7 Different statements
2.37 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.mobile AS mobile_8, t0.activation_code AS activation_code_9 FROM `escappart_user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.19 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.date AS date_3, t0.due_date AS due_date_4, t0.subtotal AS subtotal_5, t0.tax AS tax_6, t0.total AS total_7, t0.notes AS notes_8, t0.year AS year_9, t0.status AS status_10, t0.currency AS currency_11, t0.vat_rate AS vat_rate_12, t0.guest_id AS guest_id_13 FROM `escappart_invoice` t0 WHERE t0.id = ?
Parameters:
[
  "112"
]
3 0.22 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.company AS company_4, t0.email AS email_5, t0.phone AS phone_6, t0.mobile AS mobile_7, t0.vat AS vat_8, t0.location_id AS location_id_9 FROM `escappart_guest` t0 WHERE t0.id = ?
Parameters:
[
  5808
]
4 0.12 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.price AS price_3, t0.quantity AS quantity_4, t0.discount AS discount_5, t0.subtotal AS subtotal_6, t0.unit_price AS unit_price_7, t0.invoice_id AS invoice_id_8 FROM `escappart_item` t0 WHERE t0.invoice_id = ?
Parameters:
[
  112
]
5 0.14 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.description AS description_3, t0.created_time AS created_time_4, t0.invoice_id AS invoice_id_5 FROM `escappart_payment` t0 WHERE t0.invoice_id = ?
Parameters:
[
  112
]
6 1.09 ms
SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.company AS company_3, e0_.email AS email_4, e0_.phone AS phone_5, e0_.mobile AS mobile_6, e0_.vat AS vat_7, e0_.location_id AS location_id_8 FROM `escappart_guest` e0_
Parameters:
[]
7 0.19 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.roles AS roles_3, t0.hotel_id AS hotel_id_4, t0.user_id AS user_id_5 FROM `escappart_hotel_user` t0 WHERE t0.user_id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#messages refers to the owning side field App\Entity\Message#cleaning which does not exist.
App\Entity\HotelUser No errors.
App\Entity\Housekeeping No errors.
App\Entity\Message No errors.
App\Entity\RoomUser No errors.
App\Entity\Season No errors.
App\Entity\Housekeeper No errors.
App\Entity\Booking No errors.
App\Entity\Invoice No errors.
App\Entity\Guest No errors.
App\Entity\Item No errors.
App\Entity\Payment No errors.
App\Entity\Location No errors.
App\Entity\Room No errors.
App\Entity\Hotel No errors.