Query Metrics

251 Database Queries
12 Different statements
34.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.38 ms
(83.02%)
227
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:
[
  1787151850
  [
    "\x00tags\x00object_2"
    "object_2"
  ]
]
1.94 ms
(5.68%)
1
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '2' AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'FTA920%' AND  objects.o_type IN ('object','folder') ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 100
Parameters:
[]
0.93 ms
(2.73%)
1
SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '2' AND CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE 'FTA920%' AND  objects.o_type IN ('object','folder')
Parameters:
[]
0.78 ms
(2.29%)
6
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:
[
  "/products/FTA92000 Hit Single-lever tall basin mixer/%"
]
0.59 ms
(1.72%)
4
SELECT 1 FROM objects WHERE o_parentId = ? AND o_type IN ('object','folder') LIMIT 1
Parameters:
[
  2
]
0.56 ms
(1.65%)
6
SELECT id FROM tree_locks WHERE id IN (1,2) AND type='object' AND locked = 'propagate' LIMIT 1
Parameters:
[]
0.30 ms
(0.86%)
1
SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = ?
Parameters:
[
  2
]
0.29 ms
(0.85%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  16
]
0.13 ms
(0.39%)
1
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  16
]
0.10 ms
(0.28%)
1
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "35"
]
0.09 ms
(0.27%)
1
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  16
]
0.09 ms
(0.26%)
1
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  16
]

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.