Query Metrics

57 Database Queries
12 Different statements
8.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
2.51 ms
(31.35%)
18
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1791369346
  [
    "\x00tags\x00object_11"
    "object_11"
  ]
]
1.68 ms
(21.05%)
12
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:
[
  "/productTypes/mixers/basinMixers/%"
]
1.17 ms
(14.65%)
7
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
  11
]
1.15 ms
(14.43%)
12
SELECT id FROM tree_locks WHERE id IN (1,11,10) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[]
0.34 ms
(4.22%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  15
]
0.26 ms
(3.30%)
1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '11' AND  objects.o_type IN ('object','folder') ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 50
Parameters:
[]
0.25 ms
(3.10%)
1
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  15
]
0.22 ms
(2.70%)
1
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PROD_TYPE"
]
0.12 ms
(1.54%)
1
SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '11' AND  objects.o_type IN ('object','folder')
Parameters:
[]
0.10 ms
(1.30%)
1
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  15
]
0.10 ms
(1.20%)
1
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  15
]
0.09 ms
(1.16%)
1
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
  11
]

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

No loaded entities.