GET https://dev.uppio.sk/user/reservations/fa27feb2c6a9987c

Query Metrics

8 Database Queries
8 Different statements
1.80 ms Query time
3 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.37 ms
SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.birth_date AS birth_date_7, t0.identity_card AS identity_card_8, t0.roles AS roles_9, t0.hash AS hash_10, t0.password AS password_11, t0.date_created AS date_created_12, t0.date_updated AS date_updated_13, t0.is_verified AS is_verified_14, t0.company_id AS company_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.24 ms
SELECT t0.id AS id_1, t0.date_downloaded AS date_downloaded_2, t0.title AS title_3, t0.description AS description_4, t0.type AS type_5, t0.path AS path_6, t0.file_type AS file_type_7, t0.hash AS hash_8, t0.date_created AS date_created_9, t0.user_id AS user_id_10 FROM user_document t0 WHERE t0.user_id = ?
Parameters:
[
  2
]
3 0.19 ms
SELECT r0_.id AS id_0, r0_.vehicle_type AS vehicle_type_1, r0_.vehicle AS vehicle_2, r0_.place AS place_3, r0_.user AS user_4, r0_.hash AS hash_5, r0_.reservation_id AS reservation_id_6 FROM reservation_relation r0_ WHERE r0_.hash = ?
Parameters:
[
  "fa27feb2c6a9987c"
]
4 0.21 ms
SELECT t0.id AS id_1, t0.street AS street_2, t0.country AS country_3, t0.zip AS zip_4, t0.city AS city_5, t0.state AS state_6, t0.altitude AS altitude_7, t0.name AS name_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10 FROM place t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.17 ms
SELECT t0.id AS id_1, t0.date_update AS date_update_2, t0.technical_data AS technical_data_3, t0.type AS type_4, t0.tag AS tag_5, t0.date_create AS date_create_6 FROM vehicle_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.26 ms
SELECT t0.id AS id_1, t0.insurance_price AS insurance_price_2, t0.operator_price AS operator_price_3, t0.training_price AS training_price_4, t0.additional_items_price AS additional_items_price_5, t0.total_price AS total_price_6, t0.rent_operator AS rent_operator_7, t0.order_training AS order_training_8, t0.insurance_type AS insurance_type_9, t0.insure_storno AS insure_storno_10, t0.status AS status_11, t0.finished_step AS finished_step_12, t0.sale_flag AS sale_flag_13, t0.type AS type_14, t0.notice AS notice_15, t0.start_date_real AS start_date_real_16, t0.finish_date_real AS finish_date_real_17, t0.start_date AS start_date_18, t0.finish_date AS finish_date_19, t0.rent_price AS rent_price_20, t0.date_create AS date_create_21, t22.id AS id_23, t22.vehicle_type AS vehicle_type_24, t22.vehicle AS vehicle_25, t22.place AS place_26, t22.user AS user_27, t22.hash AS hash_28, t22.reservation_id AS reservation_id_29, t30.id AS id_31, t30.price AS price_32, t30.type AS type_33, t30.date_create AS date_create_34, t30.reservation_id AS reservation_id_35 FROM reservation t0 LEFT JOIN reservation_relation t22 ON t22.reservation_id = t0.id LEFT JOIN reservation_insurance t30 ON t30.reservation_id = t0.id WHERE t0.id = ?
Parameters:
[
  35
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.price_interval AS price_interval_5, t0.date_create AS date_create_6 FROM reservation_item t0 INNER JOIN reservation_reservation_items ON t0.id = reservation_reservation_items.reservation_item_id WHERE reservation_reservation_items.reservation_id = ?
Parameters:
[
  35
]
8 0.16 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.note AS note_3, t0.reservation_id AS reservation_id_4, t0.user_id AS user_id_5 FROM reservation_note t0 WHERE t0.reservation_id = ?
Parameters:
[
  35
]

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\User\User 1
App\Entity\Reservation\ReservationRelation 1
App\Entity\Reservation\Reservation 1
App\Entity\Place\Place 1
App\Entity\Vehicle\VehicleType 1
App\Entity\Reservation\ReservationInsurance 1

Entities Mapping

Class Mapping errors
App\Entity\User\User
  • The mappings App\Entity\User\User#userDocuments and App\Entity\User\UserDocument#user are inconsistent with each other.
App\Entity\Company\Company No errors.
App\Entity\Notification\UserNotification No errors.
App\Entity\Reservation\ReservationNote No errors.
App\Entity\User\UserDocument
  • The association App\Entity\User\UserDocument#user refers to the inverse side field App\Entity\User\User#documents which does not exist.
App\Entity\Reservation\ReservationRelation No errors.
App\Entity\Reservation\Reservation No errors.
App\Entity\Place\Place No errors.
App\Entity\Vehicle\VehicleType No errors.
App\Entity\Vehicle\Vehicle
  • The association App\Entity\Vehicle\Vehicle#positions refers to the owning side field App\Entity\Vehicle\VehiclePosition#vehicle which does not exist.
App\Entity\Vehicle\VehiclePrice No errors.
App\Entity\Reservation\ReservationInsurance No errors.
App\Entity\Reservation\ReservationItem No errors.