Query Metrics

68 Database Queries
15 Different statements
38.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.67 ms
(30.11%)
4
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[
  1 => null
  2 => null
  3 => 300
  4 => 1780342472
]
6.84 ms
(17.65%)
19
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:
[
  1780342472
  [
    "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6"
    "appb5003cab61b59631c83b2e65817e0bebe98e50d6"
  ]
]
5.62 ms
(14.50%)
2
DELETE FROM cache_items WHERE item_id IN (?)
Parameters:
[
  [
    "appb5003cab61b59631c83b2e65817e0bebe98e50d6"
    "\x00tags\x00appb5003cab61b59631c83b2e65817e0bebe98e50d6"
  ]
]
3.68 ms
(9.50%)
10
SELECT tree_locks.id FROM tree_locks INNER JOIN assets ON tree_locks.id = assets.id WHERE assets.path LIKE ? AND tree_locks.type = 'asset' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/custompuzzles/cp-products/kundenfotos/File\_000.jpeg/%"
]
2.84 ms
(7.33%)
10
SELECT id FROM tree_locks WHERE id IN (1,1679,1480,696) AND type='asset' AND locked = 'propagate' LIMIT 1
Parameters:
[]
2.04 ms
(5.26%)
6
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
Parameters:
[
  1684
]
1.67 ms
(4.31%)
6
SELECT `a`.`id` FROM `assets` a  WHERE parentId = ?  LIMIT 1;
Parameters:
[
  1679
]
0.83 ms
(2.15%)
2
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  2
]
0.78 ms
(2.00%)
2
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  2
]
0.66 ms
(1.69%)
1
SELECT assets.id, assets.type FROM assets WHERE (parentId = ?)  ORDER BY FIELD(assets.type, 'folder') DESC, CAST(assets.filename AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 100
Parameters:
[
  1679
]
0.64 ms
(1.64%)
2
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  2
]
0.53 ms
(1.37%)
1
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  2
]
0.43 ms
(1.11%)
1
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[
  "user"
  "custompuzzles"
]
0.29 ms
(0.76%)
1
SELECT COUNT(*) FROM assets WHERE (parentId = ?)
Parameters:
[
  1679
]
0.24 ms
(0.62%)
1
SELECT COUNT(*) AS count FROM assets WHERE parentId = ?
Parameters:
[
  1679
]

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.