Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.74 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.60 ms
(58.38%)

SELECT t0.`data` AS data_1, t0.id AS id_2, t0.`key` AS key_3, t0.organization_id AS organization_id_4 FROM settings t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.`data` AS data_1,
  t0.id AS id_2,
  t0.`key` AS key_3,
  t0.organization_id AS organization_id_4
FROM
  settings t0

SELECT t0.`data` AS data_1, t0.id AS id_2, t0.`key` AS key_3, t0.organization_id AS organization_id_4 FROM settings t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	Jbtronics\SettingsBundle\Storage\ORMStorageAdapter->preloadAllEntityObjects (line 118)
5	Jbtronics\SettingsBundle\Storage\ORMStorageAdapter->load (line 164)
6	Jbtronics\SettingsBundle\Manager\SettingsHydrator->hydrate (line 74)
7	Jbtronics\SettingsBundle\Manager\SettingsManager->getInitializedVersion (line 109)
8	Jbtronics\SettingsBundle\Manager\SettingsManager->get (line 79)
9	Jbtronics\SettingsBundle\Profiler\SettingsCollector->collect (line 61)
10	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
11	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 6)

1.14 ms
(41.62%)

SELECT t0.`data` AS data_1, t0.id AS id_2, t0.`key` AS key_3, t0.organization_id AS organization_id_4 FROM settings t0 WHERE t0.`key` = ? LIMIT 1

Parameters:

[
  "billing"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.`data` AS data_1,
  t0.id AS id_2,
  t0.`key` AS key_3,
  t0.organization_id AS organization_id_4
FROM
  settings t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`data` AS data_1, t0.id AS id_2, t0.`key` AS key_3, t0.organization_id AS organization_id_4 FROM settings t0 WHERE t0.`key` = 'billing' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Jbtronics\SettingsBundle\Storage\ORMStorageAdapter->getEntityObject (line 91)
4	Jbtronics\SettingsBundle\Storage\ORMStorageAdapter->load (line 168)
5	Jbtronics\SettingsBundle\Manager\SettingsHydrator->hydrate (line 74)
6	Jbtronics\SettingsBundle\Manager\SettingsManager->getInitializedVersion (line 109)
7	Jbtronics\SettingsBundle\Manager\SettingsManager->get (line 79)
8	Jbtronics\SettingsBundle\Profiler\SettingsCollector->collect (line 61)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 6)

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

Class	Mapping errors
App\Entity\Admin\User	No errors.
App\Entity\Employee	The field App\Entity\Employee#tasks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Task#assignedGroupMember does not contain the required 'inversedBy="tasks"' attribute.
App\Entity\Planning	No errors.
App\Entity\Reaction	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Address	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Organization	No errors.
Jbtronics\SettingsBundle\Entity\AbstractSettingsORMEntry	No errors.
App\Entity\Settings	No errors.
App\Entity\Task	No errors.
App\Entity\AuditMessage	No errors.
App\Entity\Job	No errors.
App\Entity\AuditProject	No errors.
App\Entity\Project	No errors.
App\Entity\Relation	No errors.
App\Entity\AuditLog	No errors.
App\Entity\AuditProjectMember	No errors.
App\Entity\ControlGroup	No errors.
App\Entity\ClientUser	No errors.
App\Entity\ControlItem	No errors.
App\Entity\Evidence	No errors.
App\Entity\DocumentTemplate	No errors.
App\Entity\OKBForm	No errors.
App\Entity\ClientAssessment	No errors.
App\Entity\ClientAssessmentScreenshot	No errors.
App\Entity\SubServiceOrganization	No errors.
App\Entity\EmailTemplate	No errors.
App\Entity\Invoice	No errors.
App\Entity\InvoiceLine	No errors.
App\Entity\Plan	No errors.
App\Entity\Subscription	No errors.

Symfony Profiler

GET https://www.coachwave.nl/_profiler/435913/search/null

Configuration Settings

Theme

Page Width