Query Metrics

158 Database Queries
10 Different statements
53.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.16 ms
(37.67%)
60
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/VehiclePrices/1CCESYUKA1Y0FK50/%"
]
16.89 ms
(31.56%)
60
SELECT id FROM tree_locks WHERE id IN (1,28) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[]
13.13 ms
(24.54%)
31
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
  28
]
0.82 ms
(1.53%)
1
SELECT COUNT(*) AS `totalCount` FROM `objects` WHERE (objects.o_parentId = '28' AND  objects.o_type IN ('object','folder'))
Parameters:
[]
0.75 ms
(1.40%)
1
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE (objects.o_parentId = '28' AND  objects.o_type IN ('object','folder')) ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC  LIMIT 30
Parameters:
[]
0.45 ms
(0.84%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  2
]
0.40 ms
(0.75%)
1
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  2
]
0.33 ms
(0.61%)
1
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  2
]
0.29 ms
(0.55%)
1
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  2
]
0.29 ms
(0.54%)
1
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
  28
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping