Query Metrics
20
Database Queries
9
Different statements
15.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.35 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:
[ 1765804318 "\x01tags\x01site_domain_6c30d09c5c656e257f4021a6296ded92" "site_domain_6c30d09c5c656e257f4021a6296ded92" ] |
| 2 | 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:
[ 1765804318 "system\x01tags\x01" "site\x01tags\x01" ] |
| 3 | 1.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 4 | 1.35 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/account/" "register" ] |
| 5 | 1.01 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/account/register"
]
|
| 6 | 0.34 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "account" ] |
| 7 | 0.34 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/account"
]
|
| 8 | 0.48 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
| 9 | 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:
[ 1765804318 "\x01tags\x01document_1" "document_1" ] |
| 10 | 0.39 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:
[ 1765804318 "document_1\x01tags\x01" ] |
| 11 | 0.57 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:
[ 1765804318 "\x01tags\x01document_properties_1" "document_properties_1" ] |
| 12 | 0.80 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:
[ 1765804318 "document_properties\x01tags\x01" "document_1\x01tags\x01" ] |
| 13 | 2.11 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "customers" ] |
| 14 | 0.40 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "customers" ] |
| 15 | 0.39 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:
[ 1765804318 "\x01tags\x01object_2" "object_2" ] |
| 16 | 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:
[ 1765804318 "object_2\x01tags\x01" ] |
| 17 | 0.46 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (path = ? and `key` = ?) AND (id is not null) AND objects.type IN ('object','variant','folder') LIMIT 1
Parameters:
[ "/customers/" "6940091e8dc8c" ] |
| 18 | 1.27 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
| 19 | 1.08 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:
[ 1765804318 "\x01tags\x01translation_data_1d19e47125946f5a6366d64de93b5d4f" "translation_data_1d19e47125946f5a6366d64de93b5d4f" ] |
| 20 | 0.41 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:
[ 1765804318 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
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.
Entities Mapping
No mapped entities.