GET https://www.testzorzi.izvrsna.hr/building-space/1/view

Response
200 OK
IP
216.73.216.180
Profiled on
Token
6f5067

Query Metrics

10 Database Queries
8 Different statements
7.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
2.01 ms
(28.02%) 		3 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.image AS image_6, t0.original_name AS original_name_7, t0.full_document_path AS full_document_path_8, t0.user_created AS user_created_9, t0.user_changed AS user_changed_10, t0.spaceRoom AS spaceRoom_11 FROM space_room_image t0 WHERE t0.spaceRoom = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
1.36 ms
(18.90%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.surface AS surface_6, t0.description AS description_7, t0.maximum_number_of_participants AS maximum_number_of_participants_8, t0.user_created AS user_created_9, t0.user_changed AS user_changed_10, t0.buildingSpace AS buildingSpace_11, t0.doorLock AS doorLock_12, t0.price_list_item AS price_list_item_13 FROM space_room t0 WHERE t0.active = ? AND t0.buildingSpace = ?
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query
0.93 ms
(12.98%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.surface AS surface_6, t0.description AS description_7, t0.user_created AS user_created_8, t0.user_changed AS user_changed_9, t0.building AS building_10, t0.doorLock AS doorLock_11 FROM building_space t0 WHERE t0.id = ?
Parameters: 
[
  "1"
]
View formatted query    View runnable query    Explain query
0.84 ms
(11.66%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.image AS image_6, t0.original_name AS original_name_7, t0.full_document_path AS full_document_path_8, t0.user_created AS user_created_9, t0.user_changed AS user_changed_10, t0.buildingSpace AS buildingSpace_11 FROM building_space_image t0 WHERE t0.buildingSpace = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.58 ms
(8.00%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.address AS address_6, t0.zip_code AS zip_code_7, t0.place AS place_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.user_created AS user_created_11, t0.user_changed AS user_changed_12, t0.doorLock AS doorLock_13, t0.owner AS owner_14, t0.legalPerson AS legalPerson_15 FROM building t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.55 ms
(7.68%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.person_function AS person_function_8, t0.contact AS contact_9, t0.user_created AS user_created_10, t0.user_changed AS user_changed_11, t0.buildingSpace AS buildingSpace_12 FROM building_space_contact_person t0 WHERE t0.buildingSpace = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.46 ms
(6.43%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.person_function AS person_function_7, t0.contact AS contact_8, t0.contact_email AS contact_email_9, t0.user_created AS user_created_10, t0.user_changed AS user_changed_11, t0.buildingSpace AS buildingSpace_12 FROM building_space_responsible_person t0 WHERE t0.buildingSpace = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.46 ms
(6.34%) 		1 
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.document AS document_6, t0.original_name AS original_name_7, t0.full_document_path AS full_document_path_8, t0.sequence AS sequence_9, t0.user_created AS user_created_10, t0.user_changed AS user_changed_11, t0.buildingSpace AS buildingSpace_12 FROM building_space_document t0 WHERE t0.buildingSpace = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Mapped\Entity No errors.
App\Entity\BuildingSpace No errors.
App\Entity\User No errors.
App\Entity\Mapped\NamedEntity No errors.
App\Entity\Building No errors.
App\Entity\Lock No errors.
App\Entity\BuildingSpaceContactPerson No errors.
App\Entity\BuildingSpaceImage No errors.
App\Entity\BuildingSpaceResponsiblePerson No errors.
App\Entity\BuildingSpaceDocument No errors.
App\Entity\SpaceRoom No errors.
App\Entity\PriceListItem No errors.
App\Entity\Reservation No errors.
App\Entity\SpaceRoomContactPerson No errors.
App\Entity\SpaceRoomNonWorkingDay No errors.
App\Entity\SpaceRoomResponsiblePerson No errors.
App\Entity\SpaceRoomWorkDay No errors.
App\Entity\SpaceRoomImage No errors.
App\Entity\SpaceRoomDocument No errors.
App\Entity\LegalPerson No errors.
App\Entity\BuildingContactPerson No errors.
App\Entity\BuildingResponsiblePerson No errors.
App\Entity\BuildingImage No errors.
App\Entity\BuildingDocument No errors.