POST https://pim.prostopromo.com.ua/admin/object/grid-proxy?_dc=1774815268192&classId=2&folderId=6&xaction=read

Query Metrics

20 Database Queries
11 Different statements
8.48 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
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:
[
  1774815268
  "maintenance_mode"
]
2 0.50 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  2
]
3 0.38 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  2
]
4 0.31 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  2
]
5 0.44 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  2
]
6 0.37 ms
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:
[
  1774815268
  "object_6"
]
7 0.30 ms
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:
[
  1774815268
  "object_6\x01tags\x01"
]
8 0.27 ms
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "2"
]
9 1.58 ms
SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder') ORDER BY `id` ASC   LIMIT 25
Parameters:
[]
10 0.36 ms
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:
[
  1774815268
  "object_12"
]
11 0.38 ms
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:
[
  1774815268
  "object_12\x01tags\x01"
  "class_2\x01tags\x01"
]
12 0.28 ms
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:
[
  1774815268
  "object_18"
]
13 0.32 ms
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:
[
  1774815268
  "object_18\x01tags\x01"
  "class_2\x01tags\x01"
]
14 0.28 ms
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:
[
  1774815268
  "object_1"
]
15 0.26 ms
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:
[
  1774815268
  "object_1\x01tags\x01"
]
16 0.39 ms
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Categories/electronics/%"
]
17 0.36 ms
SELECT id FROM tree_locks WHERE id IN (1,6) AND `type`='object' AND locked = 'propagate' LIMIT 1
Parameters:
[]
18 0.35 ms
SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Categories/phone/%"
]
19 0.32 ms
SELECT id FROM tree_locks WHERE id IN (1,6) AND `type`='object' AND locked = 'propagate' LIMIT 1
Parameters:
[]
20 0.55 ms
SELECT COUNT(*) FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder')
Parameters:
[]

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.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.