Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

104.56 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

68.09 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:

[
  1794177451
  "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 > 1794177451 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\HomeController->index (line 57)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
13	Symfony\Component\HttpKernel\Kernel->handle (line 155)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

36.46 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:

[
  1794177451
  "d-g2z6bTPX:test_suite_metrics.ffbacda85ff4"
]

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 > 1794177451 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('d-g2z6bTPX:test_suite_metrics.ffbacda85ff4');

#	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\AbstractAdapter->contractsGet (line 48)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 83)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 31)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 64)
11	App\Service\Testing\TestSuiteMetrics->getSnapshot (line 81)
12	Twig\Extension\CoreExtension->getAttribute (line 1996)
13	__TwigTemplate_4da6952713f5fba70249a9b5ee3b7ab7::doDisplay (line 53)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Extension\CoreExtension->include (line 1575)
19	__TwigTemplate_4f34876bb48dbceacb2d87ade2964db7::block_body (line 191)
20	Twig\Template->yieldBlock (line 493)
21	__TwigTemplate_d2e6dfe1650f78db3bfe6a6118f02034->doDisplay (line 631)
22	Twig\Template->yield (line 461)
23	__TwigTemplate_4f34876bb48dbceacb2d87ade2964db7->doDisplay (line 61)
24	Twig\Template->yield (line 461)
25	Twig\Template->display (line 416)
26	Twig\Template->render (line 431)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Environment->render (line 343)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
32	App\Controller\HomeController->index (line 53)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
35	Symfony\Component\HttpKernel\Kernel->handle (line 155)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
37	require_once (line 32)
38	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/

Configuration Settings

Theme

Page Width