Query Metrics
42 Database Queries
13 Different statements
81.75 ms Query time
0 Invalid entities
0 Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 43.24 ms (52.90%) | 1 | SELECT object_localized_JOB_de.id as id, object_localized_JOB_de.type as `type` FROM object_localized_JOB_de WHERE ((validThrough IS NULL OR UNIX_TIMESTAMP(validThrough) > ?) AND oo_id != ? AND object_localized_JOB_de.type IN ('object','variant','folder')) AND object_localized_JOB_de.published = 1 Parameters: [ 1778741296 217 ] |
| 18.71 ms (22.89%) | 11 | SELECT * FROM object_relations_JOB WHERE src_id = ? Parameters: [
217
] |
| 5.62 ms (6.87%) | 1 | SELECT * FROM translations_messages LIMIT 1; Parameters: [] |
| 3.71 ms (4.54%) | 1 | SELECT * FROM documents_editables WHERE documentId = ? Parameters: [
123
] |
| 2.25 ms (2.75%) | 1 | SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] |
| 1.52 ms (1.87%) | 7 | SELECT customSettings FROM assets WHERE id = ? Parameters: [
124
] |
| 1.48 ms (1.82%) | 4 | SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [
124
] |
| 1.45 ms (1.78%) | 4 | 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/karriere/lehre-tiefbauer-j217" "path" "auto_create" "/de/karriere/lehre-tiefbauer-j217" "path_query" "https://web8765.sportalpen.ms.mynet.at/de/karriere/lehre-tiefbauer-j217" "entire_uri" ] |
| 1.36 ms (1.67%) | 4 | SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 0.94 ms (1.15%) | 4 | SELECT name FROM classes WHERE id = ? Parameters: [
"CONF_PRIVACY"
] |
| 0.75 ms (0.92%) | 2 | SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [ "/de/karriere/" "lehre-tiefbauer-j217" ] |
| 0.38 ms (0.46%) | 1 | SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [
"/de/karriere/lehre-tiefbauer-j217"
] |
| 0.32 ms (0.39%) | 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.