Query Metrics
5
Database Queries
3
Different statements
199.15 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 38.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:
[ 1794176730 "d-g2z6bTPX:sc_release.dev" ]
|
||||||||||||||||||||||||||||||||||
| 2 | 42.70 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1794176730 "d-g2z6bTPX:sc_release.dev" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 44.51 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON CONFLICT (item_id) DO UPDATE SET (item_data, item_lifetime, item_time) = (EXCLUDED.item_data, EXCLUDED.item_lifetime, EXCLUDED.item_time)
Parameters:
[ 2 => 60 3 => 1794176732 0 => "d-g2z6bTPX:sc_release.dev" 1 => "O:25:"App\Service\Cli\ScRelease":3:{s:7:"channel";s:3:"dev";s:7:"version";s:23:"0.1.58-snapshot-514615b";s:9:"artifacts";a:6:{i:0;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:46:"sc_0.1.58-snapshot-514615b_darwin_amd64.tar.gz";s:2:"os";s:6:"darwin";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"148fb14f55f9a912c3c5d7f08bfb69a900c2997f6bb9c5f628d3102c3f68acfc";s:4:"size";i:4790689;}i:1;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:46:"sc_0.1.58-snapshot-514615b_darwin_arm64.tar.gz";s:2:"os";s:6:"darwin";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"55a635e9f251c777cfe859ee7f7577898a09d58bfff259239f82740bca8210f6";s:4:"size";i:4399494;}i:2;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:45:"sc_0.1.58-snapshot-514615b_linux_amd64.tar.gz";s:2:"os";s:5:"linux";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"485a77058f16731530dbc8956f736677cc2099fce1c7f366e76c48b6696b0ff9";s:4:"size";i:4717101;}i:3;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:45:"sc_0.1.58-snapshot-514615b_linux_arm64.tar.gz";s:2:"os";s:5:"linux";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"b6ddc7820429a9a12d3b00a5f60a8def217d3660af6652d1b82545a5b5b00579";s:4:"size";i:4241524;}i:4;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:44:"sc_0.1.58-snapshot-514615b_windows_amd64.zip";s:2:"os";s:7:"windows";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"531b3681ff85eb55a6050f031b325a002509048c67427a305087de2552b90b1b";s:4:"size";i:4864902;}i:5;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:44:"sc_0.1.58-snapshot-514615b_windows_arm64.zip";s:2:"os";s:7:"windows";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"c822ea4ca3685b799b8aa9ed69327c512caa3da13d8ca72e9f3433d2de8a49b2";s:4:"size";i:4330588;}}}" ] |
||||||||||||||||||||||||||||||||||
| 4 | 37.90 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:
[ 1794176732 "d-g2z6bTPX:sc_release.stable" ]
|
||||||||||||||||||||||||||||||||||
| 5 | 35.62 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:
[ 1794176732 "d-g2z6bTPX:sc_release.dev" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.