Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.19 ms Query time

0 Invalid entities

4 Managed entities

0 Cache hits

1 Cache misses

1 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(51.22%)

SELECT p0_.id AS id_0, p0_.cost AS cost_1, p0_.currency AS currency_2, p0_.packageName AS packageName_3, p0_.credits AS credits_4, p0_.enabled AS enabled_5, p0_.labelText AS labelText_6, p0_.termOfMembership AS termOfMembership_7, p0_.vxsPackage AS vxsPackage_8, p0_.vxsSite AS vxsSite_9, p0_.metaInfo AS metaInfo_10, p0_.rebillInto_id AS rebillInto_id_11, p0_.rebilledFrom_id AS rebilledFrom_id_12, p0_.satellite_id AS satellite_id_13 FROM PaymentPackage p0_ WHERE p0_.enabled = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.cost AS cost_1,
  p0_.currency AS currency_2,
  p0_.packageName AS packageName_3,
  p0_.credits AS credits_4,
  p0_.enabled AS enabled_5,
  p0_.labelText AS labelText_6,
  p0_.termOfMembership AS termOfMembership_7,
  p0_.vxsPackage AS vxsPackage_8,
  p0_.vxsSite AS vxsSite_9,
  p0_.metaInfo AS metaInfo_10,
  p0_.rebillInto_id AS rebillInto_id_11,
  p0_.rebilledFrom_id AS rebilledFrom_id_12,
  p0_.satellite_id AS satellite_id_13
FROM
  PaymentPackage p0_
WHERE
  p0_.enabled = ?

SELECT p0_.id AS id_0, p0_.cost AS cost_1, p0_.currency AS currency_2, p0_.packageName AS packageName_3, p0_.credits AS credits_4, p0_.enabled AS enabled_5, p0_.labelText AS labelText_6, p0_.termOfMembership AS termOfMembership_7, p0_.vxsPackage AS vxsPackage_8, p0_.vxsSite AS vxsSite_9, p0_.metaInfo AS metaInfo_10, p0_.rebillInto_id AS rebillInto_id_11, p0_.rebilledFrom_id AS rebilledFrom_id_12, p0_.satellite_id AS satellite_id_13 FROM PaymentPackage p0_ WHERE p0_.enabled = '1';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Netperv\DataLayerBundle\Repository\AbstractRepository->filterResults (line 155)
7	App\Service\Payment\PaymentPackageProvider->getEnabledPackages (line 28)
8	App\Controller\Registration\RegistrationController->createEntity (line 72)
9	Netperv\WebAppBundle\Controller\CRUD\CreateController->provideEntity (line 61)
10	Netperv\WebAppBundle\Controller\CRUD\FormController->handleRequest (line 176)
11	Netperv\WebAppBundle\Controller\CRUD\ActionController->executeAction (line 46)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.58 ms
(48.78%)

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.currency AS currency_3, t0.packageName AS packageName_4, t0.credits AS credits_5, t0.enabled AS enabled_6, t0.labelText AS labelText_7, t0.termOfMembership AS termOfMembership_8, t0.vxsPackage AS vxsPackage_9, t0.vxsSite AS vxsSite_10, t0.metaInfo AS metaInfo_11, t0.rebillInto_id AS rebillInto_id_12, t0.rebilledFrom_id AS rebilledFrom_id_13, t0.satellite_id AS satellite_id_14 FROM PaymentPackage t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.currency AS currency_3,
  t0.packageName AS packageName_4,
  t0.credits AS credits_5,
  t0.enabled AS enabled_6,
  t0.labelText AS labelText_7,
  t0.termOfMembership AS termOfMembership_8,
  t0.vxsPackage AS vxsPackage_9,
  t0.vxsSite AS vxsSite_10,
  t0.metaInfo AS metaInfo_11,
  t0.rebillInto_id AS rebillInto_id_12,
  t0.rebilledFrom_id AS rebilledFrom_id_13,
  t0.satellite_id AS satellite_id_14
FROM
  PaymentPackage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.currency AS currency_3, t0.packageName AS packageName_4, t0.credits AS credits_5, t0.enabled AS enabled_6, t0.labelText AS labelText_7, t0.termOfMembership AS termOfMembership_8, t0.vxsPackage AS vxsPackage_9, t0.vxsSite AS vxsSite_10, t0.metaInfo AS metaInfo_11, t0.rebillInto_id AS rebillInto_id_12, t0.rebilledFrom_id AS rebilledFrom_id_13, t0.satellite_id AS satellite_id_14 FROM PaymentPackage t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadById (line 394)
4	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
5	Netperv\PaymentBundle\Entity\PaymentPackage::getCost (line 92)
6	Netperv\PaymentBundle\Entity\PaymentPackage->getCostRebill (line 119)
7	Netperv\PaymentBundle\Entity\PaymentPackage->getCostRebillFloat (line 124)
8	Netperv\PaymentBundle\Doctrine\Listener\PaymentPackageListener->postLoad (line 26)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3203)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
15	Doctrine\ORM\AbstractQuery->execute (line 891)
16	Doctrine\ORM\AbstractQuery->getResult (line 689)
17	Netperv\DataLayerBundle\Repository\AbstractRepository->filterResults (line 155)
18	App\Service\Payment\PaymentPackageProvider->getEnabledPackages (line 28)
19	App\Controller\Registration\RegistrationController->createEntity (line 72)
20	Netperv\WebAppBundle\Controller\CRUD\CreateController->provideEntity (line 61)
21	Netperv\WebAppBundle\Controller\CRUD\FormController->handleRequest (line 176)
22	Netperv\WebAppBundle\Controller\CRUD\ActionController->executeAction (line 46)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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

0 Hits

1 Misses

1 Puts

Number of cache misses

Region	Misses
cache_user	1

Number of cache puts

Region	Puts
cache_user	1

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PaymentPackage	3
App\Entity\Satellite	1

Entities Mapping

Class	Mapping errors
App\Entity\Verification	No errors.
App\Entity\PaymentPackage	No errors.
Netperv\UserBundle\Entity\User	No errors.
App\Entity\User	No errors.
App\Entity\Satellite	No errors.
Netperv\UploadsBundle\Entity\FileEntity	No errors.
App\Entity\GalleryImage	No errors.