Query Metrics
9 Database Queries
8 Different statements
16.88 ms Query time
0 Invalid entities
0 Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 5.83 ms (34.53%) | 1 | SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [ "/de/" "animation" ] |
| 3.39 ms (20.07%) | 1 | SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [ "/de/animation" "path" "auto_create" "/de/animation" "path_query" "https://web8146.sportalpen.ms.mynet.at/de/animation" "entire_uri" ] |
| 2.03 ms (12.00%) | 2 | SELECT name FROM classes WHERE id = ? Parameters: [
"CONF_HOTEL"
] |
| 1.73 ms (10.23%) | 1 | SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] |
| 1.39 ms (8.21%) | 1 | SELECT * FROM object_url_slugs WHERE slug = '/de/animation' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] |
| 1.30 ms (7.71%) | 1 | SELECT * FROM properties WHERE ( (cid IN (1,2) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [
160
] |
| 0.90 ms (5.35%) | 1 | SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 0.32 ms (1.90%) | 1 | SELECT * FROM tmp_store WHERE id = ? Parameters: [
"maintenance_mode"
] |
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.