Query Metrics
14
Database Queries
9
Different statements
1.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.46 ms (23.46%) |
1 |
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters:
[ "pimdev.kosmelita.lt" "%"pimdev.kosmelita.lt"%" ] |
|
0.35 ms (17.98%) |
4 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/pimcore-datahub-import-export/magento_options/" "retrieve" ] |
|
0.25 ms (12.88%) |
3 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/pimcore-datahub-import-export/magento_options/retrieve"
]
|
|
0.19 ms (9.67%) |
1 |
SELECT definition FROM classificationstore_keys cs WHERE cs.name = ?
Parameters:
[
"attr_antak_prod_tipas"
]
|
|
0.17 ms (8.76%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.15 ms (7.68%) |
1 |
SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1
]
|
|
0.14 ms (7.17%) |
1 |
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1
]
|
|
0.14 ms (6.93%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.11 ms (5.45%) |
1 |
SELECT id,domains FROM sites
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore_translation_provider_interfaces | doctrine.orm.pimcore_translation_provider_interfaces_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.