Query Metrics
61 Database Queries
15 Different statements
94.03 ms Query time
0 Invalid entities
0 Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 25.05 ms (26.64%) | 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: [ 1768023146 179 ] |
| 15.29 ms (16.27%) | 7 | INSERT INTO tmp_store (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (?, ?, ?, ?, ?, ?) Parameters: [ "thumb_71__f5c28a5e6472841662649607654c96ef" "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":17:{s:8:"\x00*\x00items";a:3:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:100;s:6:"height";d:96.996996996997;s:1:"y";d:-14.714714714714715;s:1:"x";d:0.4;}}i:1;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:100;s:6:"height";d:96.996996996997;s:1:"y";d:-14.714714714714715;s:1:"x";d:0.4;}}i:2;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:1290;s:6:"height";i:680;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:9:"\x00*\x00medias";a:1:{s:18:"(min-width: 576px)";a:3:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:100;s:6:"height";d:96.996996996997;s:1:"y";d:-14.714714714714715;s:1:"x";d:0.4;}}i:1;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:100;s:6:"height";d:96.996996996997;s:1:"y";d:-14.714714714714715;s:1:"x";d:0.4;}}i:2;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:1290;s:6:"height";i:680;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}}s:7:"\x00*\x00name";s:79:"top_auto_47a17f662313313ff97a080610c433c3_auto_33ecd247726ffe82d410b1e90f3009f0";s:14:"\x00*\x00description";s:0:"";s:8:"\x00*\x00group";s:0:"";s:9:"\x00*\x00format";s:6:"SOURCE";s:10:"\x00*\x00quality";i:85;s:17:"\x00*\x00highResolution";d:1;s:16:"\x00*\x00preserveColor";b:0;s:26:"\x00*\x00forceProcessICCProfiles";b:0;s:19:"\x00*\x00preserveMetaData";b:0;s:15:"\x00*\x00rasterizeSVG";b:0;s:15:"\x00*\x00downloadable";b:0;s:19:"\x00*\x00modificationDate";i:1706182677;s:15:"\x00*\x00creationDate";i:1706181187;s:17:"\x00*\x00filenameSuffix";s:22:"media--4f35149e--query";s:20:"\x00*\x00preserveAnimation";b:0;}" "thumbnail_deferred" 1768023147 1768627947 1 ] |
| 13.66 ms (14.53%) | 7 | DELETE FROM tmp_store WHERE id = ? Parameters: [
"thumb_71__f5c28a5e6472841662649607654c96ef"
] |
| 6.27 ms (6.67%) | 5 | SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [
78
] |
| 6.17 ms (6.56%) | 1 | SELECT * FROM translations_messages LIMIT 1; Parameters: [] |
| 4.74 ms (5.04%) | 1 | SELECT * FROM object_relations_JOB WHERE src_id = ? Parameters: [
179
] |
| 4.45 ms (4.73%) | 1 | SELECT * FROM documents_editables WHERE documentId = ? Parameters: [
123
] |
| 4.43 ms (4.71%) | 1 | SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] |
| 3.85 ms (4.09%) | 5 | SELECT customSettings FROM assets WHERE id = ? Parameters: [
78
] |
| 3.77 ms (4.01%) | 12 | SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
| 3.57 ms (3.80%) | 9 | SELECT * FROM tmp_store WHERE id = ? Parameters: [
"maintenance_mode"
] |
| 1.36 ms (1.44%) | 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/hochbau-lehrling-j179" "path" "auto_create" "/de/karriere/hochbau-lehrling-j179" "path_query" "https://web8765.sportalpen.ms.mynet.at/de/karriere/hochbau-lehrling-j179" "entire_uri" ] |
| 0.63 ms (0.67%) | 4 | SELECT name FROM classes WHERE id = ? Parameters: [
"CONF_PRIVACY"
] |
| 0.54 ms (0.57%) | 2 | SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [ "/de/karriere/" "hochbau-lehrling-j179" ] |
| 0.25 ms (0.26%) | 1 | SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [
"/de/karriere/hochbau-lehrling-j179"
] |
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.