Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

472.31 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

217.61 ms
(46.07%)

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;}}}"
]

View formatted query View runnable query Explain query View query backtrace

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
  )

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (60, 1794175776, 'd-g2z6bTPX:sc_release.stable', '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;}}}') ON CONFLICT (item_id) DO UPDATE SET (item_data, item_lifetime, item_time) = (EXCLUDED.item_data, EXCLUDED.item_lifetime, EXCLUDED.item_time);

#	File/Call
1	App\Doctrine\Telemetry\TracingStatement->{closure:App\Doctrine\Telemetry\TracingStatement::execute():32} (line 32)
2	App\Doctrine\Telemetry\QuerySpan->run (line 39)
3	App\Doctrine\Telemetry\TracingStatement::execute (line 32)
4	Doctrine\DBAL\Statement->execute (line 104)
5	Doctrine\DBAL\Statement->executeStatement (line 133)
6	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doSaveInner (line 358)
7	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doSave (line 273)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->commit (line 159)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->save (line 243)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->save (line 131)
11	App\Service\Cli\ScReleaseCatalog->release (line 127)
12	App\Service\Cli\ScReleaseCatalog->default (line 90)
13	App\Controller\InstallController->requested (line 228)
14	App\Controller\InstallController->page (line 48)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
17	Symfony\Component\HttpKernel\Kernel->handle (line 155)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

145.73 ms
(30.85%)

DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)

Parameters:

[
  1794175773
  "d-g2z6bTPX:sc_release.stable"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  cache_items
WHERE
  item_lifetime + item_time <= ?
  AND item_id IN (?)

DELETE FROM cache_items WHERE item_lifetime + item_time <= 1794175773 AND item_id IN ('d-g2z6bTPX:sc_release.stable');

#	File/Call
1	App\Doctrine\Telemetry\TracingStatement->{closure:App\Doctrine\Telemetry\TracingStatement::execute():32} (line 32)
2	App\Doctrine\Telemetry\QuerySpan->run (line 39)
3	App\Doctrine\Telemetry\TracingStatement::execute (line 32)
4	Doctrine\DBAL\Connection->executeStatement (line 902)
5	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doFetch (line 197)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->getItem (line 199)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->getItem (line 85)
8	App\Service\Cli\ScReleaseCatalog->release (line 118)
9	App\Service\Cli\ScReleaseCatalog->default (line 90)
10	App\Controller\InstallController->requested (line 228)
11	App\Controller\InstallController->page (line 48)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
14	Symfony\Component\HttpKernel\Kernel->handle (line 155)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 5)

108.98 ms
(23.07%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1794175773 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:sc_release.stable');

#	File/Call
1	App\Doctrine\Telemetry\TracingStatement->{closure:App\Doctrine\Telemetry\TracingStatement::execute():32} (line 32)
2	App\Doctrine\Telemetry\QuerySpan->run (line 39)
3	App\Doctrine\Telemetry\TracingStatement::execute (line 32)
4	Doctrine\DBAL\Connection->executeQuery (line 800)
5	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doFetch (line 179)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->getItem (line 199)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->getItem (line 85)
8	App\Service\Cli\ScReleaseCatalog->release (line 118)
9	App\Service\Cli\ScReleaseCatalog->default (line 90)
10	App\Controller\InstallController->requested (line 228)
11	App\Controller\InstallController->page (line 48)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
14	Symfony\Component\HttpKernel\Kernel->handle (line 155)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 5)

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.

GET https://staging.someones.computer/install

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping