Query Metrics
7
Database Queries
3
Different statements
472.31 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 36.08 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:
[ 1794175773 "d-g2z6bTPX:sc_release.stable" ] |
||||||||||||||||||||||||||||||||||
| 2 | 38.49 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1794175773 "d-g2z6bTPX:sc_release.stable" ] |
||||||||||||||||||||||||||||||||||
| 3 | 179.00 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 => 1794175776 0 => "d-g2z6bTPX:sc_release.stable" 1 => "O:25:"App\Service\Cli\ScRelease":3:{s:7:"channel";s:6:"stable";s:7:"version";s:6:"0.1.57";s:9:"artifacts";a:6:{i:0;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:29:"sc_0.1.57_darwin_amd64.tar.gz";s:2:"os";s:6:"darwin";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"8e28bd4d26ab605f0f103a43362e5c0c8e240fa55e79945de89a1771aad4b5f0";s:4:"size";i:4786964;}i:1;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:29:"sc_0.1.57_darwin_arm64.tar.gz";s:2:"os";s:6:"darwin";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"465c65d1fddb004cc287b1fb4c818e7179fda736a88a98d4e92d78acca516ec5";s:4:"size";i:4398837;}i:2;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:28:"sc_0.1.57_linux_amd64.tar.gz";s:2:"os";s:5:"linux";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"5151cf856d8ea63863f6e342e2b1cbc0f3a04688c26de87c5382fc8421da9cfc";s:4:"size";i:4715494;}i:3;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:28:"sc_0.1.57_linux_arm64.tar.gz";s:2:"os";s:5:"linux";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"a87800d6b774a16ad5d564f9481811b5560b7ef688739758ad01830fddc08ba8";s:4:"size";i:4242657;}i:4;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:27:"sc_0.1.57_windows_amd64.zip";s:2:"os";s:7:"windows";s:4:"arch";s:5:"amd64";s:6:"sha256";s:64:"7035c996000c70157bd035fb61d6071ec741e02acd2c54a5bea460adee44f1bc";s:4:"size";i:4860540;}i:5;O:26:"App\Service\Cli\ScArtifact":5:{s:4:"file";s:27:"sc_0.1.57_windows_arm64.zip";s:2:"os";s:7:"windows";s:4:"arch";s:5:"arm64";s:6:"sha256";s:64:"8a40f594d43672d7df464e8a4af5e2dcff84efe51d09feda9b87743658de436a";s:4:"size";i:4326684;}}}" ] |
||||||||||||||||||||||||||||||||||
| 4 | 35.47 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:
[ 1794175776 "d-g2z6bTPX:sc_release.stable" ]
|
||||||||||||||||||||||||||||||||||
| 5 | 37.44 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:
[ 1794175776 "d-g2z6bTPX:sc_release.dev" ]
|
||||||||||||||||||||||||||||||||||
| 6 | 107.24 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1794175776 "d-g2z6bTPX:sc_release.dev" ]
|
||||||||||||||||||||||||||||||||||
| 7 | 38.61 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 => 1794175777 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;}}}" ] |
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.