Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.71 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.42 ms

SELECT s0_.value AS value_0, s1_.value AS value_1, s2_.value AS value_2, s3_.value AS value_3, s4_.value AS value_4 FROM settings s0_ INNER JOIN settings s1_ INNER JOIN settings s2_ INNER JOIN settings s3_ INNER JOIN settings s4_ WHERE s0_.name = ? AND s1_.name = ? AND s2_.name = ? AND s3_.name = ? AND s4_.name = ?

Parameters:

[
  "auction.live.status"
  "auction.live.fair.warning"
  "auction.live.lot.number"
  "auction.live.current.bid"
  "auction.live.current.bid.number"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.value AS value_0,
  s1_.value AS value_1,
  s2_.value AS value_2,
  s3_.value AS value_3,
  s4_.value AS value_4
FROM
  settings s0_
  INNER JOIN settings s1_
  INNER JOIN settings s2_
  INNER JOIN settings s3_
  INNER JOIN settings s4_
WHERE
  s0_.name = ?
  AND s1_.name = ?
  AND s2_.name = ?
  AND s3_.name = ?
  AND s4_.name = ?

SELECT s0_.value AS value_0, s1_.value AS value_1, s2_.value AS value_2, s3_.value AS value_3, s4_.value AS value_4 FROM settings s0_ INNER JOIN settings s1_ INNER JOIN settings s2_ INNER JOIN settings s3_ INNER JOIN settings s4_ WHERE s0_.name = 'auction.live.status' AND s1_.name = 'auction.live.fair.warning' AND s2_.name = 'auction.live.lot.number' AND s3_.name = 'auction.live.current.bid' AND s4_.name = 'auction.live.current.bid.number';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 62)
7	App\Helpers\LiveAuction->init (line 39)
8	App\Helpers\LiveAuction->__construct (line 22)
9	ContainerCJvoKP6\getLiveAuctionService::do (line 431)
10	ContainerCJvoKP6\App_KernelDevDebugContainer->load (line 408)
11	Symfony\Component\DependencyInjection\Container->getService (line 40)
12	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 174)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.29 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.number AS number_2,
  a0_.index_id AS index_id_3,
  a0_.active AS active_4,
  a0_.visible AS visible_5,
  a0_.created_by AS created_by_6,
  a0_.created_date AS created_date_7,
  a0_.modified_by AS modified_by_8,
  a0_.modified_date AS modified_date_9
FROM
  auctions a0_
WHERE
  a0_.active = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\AuctionsRepository->findActive (line 126)
8	App\Service\BaseControllerService->App\Service\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 104)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 127)
16	App\Service\BaseControllerService->getCurrentAuction (line 75)
17	App\Helpers\LiveAuction->init (line 39)
18	App\Helpers\LiveAuction->__construct (line 22)
19	ContainerCJvoKP6\getLiveAuctionService::do (line 431)
20	ContainerCJvoKP6\App_KernelDevDebugContainer->load (line 408)
21	Symfony\Component\DependencyInjection\Container->getService (line 40)
22	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
23	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
24	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
25	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
26	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 174)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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.

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\Auctions	No errors.
App\Entity\AuctionBidNumbers	No errors.
App\Entity\AuctionDays	No errors.
App\Entity\Catalogue	No errors.
App\Entity\Categories	No errors.
App\Entity\AuctionWins	No errors.

Symfony Profiler

GET https://www.test.cr-art-auctions.be/

Configuration Settings

Theme