Query Metrics
13
Database Queries
9
Different statements
18.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.66 ms (46.43%) |
1 |
SELECT COUNT(*) as amount FROM (SELECT translations_messages.key FROM translations_messages WHERE (lower(translations_messages.key) LIKE :filterTerm OR lower(translations_messages.text) LIKE :filterTerm) GROUP BY translations_messages.key) AS a
Parameters:
[ "filterTerm" => "%youarecurrentlynotassignedtoanygroup%" ] |
|
8.54 ms (45.79%) |
1 |
SELECT translations_messages.key FROM translations_messages WHERE (lower(translations_messages.key) LIKE :filterTerm OR lower(translations_messages.text) LIKE :filterTerm) GROUP BY translations_messages.key ORDER BY translations_messages.key ASC LIMIT 25
Parameters:
[ "filterTerm" => "%youarecurrentlynotassignedtoanygroup%" ] |
|
0.36 ms (1.94%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
|
0.32 ms (1.73%) |
2 |
SELECT * FROM translations_messages WHERE `key` = :key AND `language` IN (:languages) ORDER BY `creationDate`
Parameters:
[ "key" => "frontend_Dashboard_Youarecurrentlynotassignedtoanygroup" "languages" => [ "en" "ar" ] ] |
|
0.24 ms (1.27%) |
2 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
|
0.15 ms (0.80%) |
1 |
SELECT * FROM users WHERE `type` = ? AND `name` = ?
Parameters:
[ "user" "admin" ] |
|
0.14 ms (0.78%) |
2 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
|
0.12 ms (0.64%) |
2 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
|
0.12 ms (0.63%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
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.