Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.49 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.23 ms

SELECT t0.id AS id_1, t0.feature_key AS feature_key_2, t0.enabled AS enabled_3, t0.settings AS settings_4 FROM feature t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.feature_key AS feature_key_2,
  t0.enabled AS enabled_3,
  t0.settings AS settings_4
FROM
  feature t0

SELECT t0.id AS id_1, t0.feature_key AS feature_key_2, t0.enabled AS enabled_3, t0.settings AS settings_4 FROM feature t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	ApKnowhow\ApEchoBundle\AI\AiFeatureCatalog->row (line 254)
6	ApKnowhow\ApEchoBundle\AI\AiFeatureCatalog->effectiveConfig (line 130)
7	ContainerPhARcc0\getImageFeatureService->do (line 32)
8	ContainerPhARcc0\App_KernelDevDebugContainer::load (line 736)
9	ContainerPhARcc0\getImageToolService->do (line 23)
10	ContainerPhARcc0\App_KernelDevDebugContainer::load (line 736)
11	ContainerPhARcc0\getAi_TraceableToolbox_DatablockCreatorService->do (line 34)
12	ContainerPhARcc0\App_KernelDevDebugContainer::load (line 736)
13	ContainerPhARcc0\App_KernelDevDebugContainer->{closure:ContainerPhARcc0\App_KernelDevDebugContainer::get_Container_Private_ProfilerService():807} (line 808)
14	iterator_to_array (line 97)
15	Symfony\AI\AiBundle\Profiler\DataCollector::__construct (line 97)
16	ContainerPhARcc0\App_KernelDevDebugContainer->get_Container_Private_ProfilerService (line 805)
17	ContainerPhARcc0\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 2148)
18	ContainerPhARcc0\App_KernelDevDebugContainer::{closure:ContainerPhARcc0\App_KernelDevDebugContainer::getEventDispatcherService():1384} (line 1384)
19	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
20	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.26 ms

SELECT t0.id AS id_1, t0.data AS data_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11 FROM site_settings t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.created_from AS created_from_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by AS updated_by_7,
  t0.updated_from AS updated_from_8,
  t0.deleted_by AS deleted_by_9,
  t0.deleted_from AS deleted_from_10,
  t0.deleted_at AS deleted_at_11
FROM
  site_settings t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.data AS data_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11 FROM site_settings t0 WHERE ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	ApKnowhow\ApEchoBundle\Service\Manager\SiteSettingsManager->getSettings (line 34)
6	ApKnowhow\ApEchoBundle\EventSubscriber\MaintenanceModeSubscriber->onKernelRequest (line 62)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
external	doctrine.dbal.external_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
external	doctrine.orm.external_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
ApKnowhow\ApEchoBundle\Entity\SiteSettings	1

external entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
ApKnowhow\ApEchoBundle\Entity\ImageCategory	No errors.
ApKnowhow\ApEchoBundle\Entity\ImageTemplate	No errors.
ApKnowhow\ApEchoBundle\Entity\Upload	No errors.
ApKnowhow\ApEchoBundle\Entity\ImageOriginal	No errors.
ApKnowhow\ApEchoBundle\Entity\ImageCropped	No errors.
ApKnowhow\ApEchoBundle\Entity\Redirect	No errors.
ApKnowhow\ApEchoBundle\Entity\SiteSettings	No errors.
ApKnowhow\ApEchoBundle\Entity\PageTemplate	No errors.
ApKnowhow\ApEchoBundle\Entity\Page	No errors.
ApKnowhow\ApEchoBundle\Entity\News	No errors.
ApKnowhow\ApEchoBundle\Entity\Event	No errors.
ApKnowhow\ApEchoBundle\Entity\DataBlockTemplate	No errors.
ApKnowhow\ApEchoBundle\Entity\DataBlockCategory	No errors.
ApKnowhow\ApEchoBundle\Entity\Feature	No errors.
ApKnowhow\ApEchoBundle\Entity\DataBlock	No errors.
ApKnowhow\ApEchoBundle\Entity\EmailTemplate	No errors.
ApKnowhow\ApEchoBundle\Entity\Menu	No errors.
ApKnowhow\ApEchoBundle\Entity\Document	No errors.
ApKnowhow\ApEchoBundle\Entity\FormTemplate	No errors.
ApKnowhow\ApEchoBundle\Entity\FormSubmission	No errors.
ApKnowhow\ApEchoBundle\Entity\SiteSearch	No errors.

external entity manager

No loaded entities.

Symfony Profiler

GET https://dev.airmatic.apknowhow.co.uk/content/images/banner/desktop/air03_ff727304-1098-47bb-94ff-ab5cbd5c54ff.webp

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

external entity manager

Entities Mapping

default entity manager

external entity manager