Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

0.49 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.31 ms
(63.44%)

SELECT t0.id AS id_1, t0.image_filename AS image_filename_2, t0.register_ip AS register_ip_3, t0.title AS title_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.company AS company_7, t0.zip AS zip_8, t0.country AS country_9, t0.street AS street_10, t0.hnr AS hnr_11, t0.phone AS phone_12, t0.mobil AS mobil_13, t0.notiz AS notiz_14, t0.change_pw AS change_pw_15, t0.must_validated AS must_validated_16, t0.bot_license AS bot_license_17, t0.created_at AS created_at_18, t0.voter AS voter_19, t0.gravatar AS gravatar_20, t0.account_holder_id AS account_holder_id_21 FROM account t0 WHERE t0.account_holder_id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_filename AS image_filename_2,
  t0.register_ip AS register_ip_3,
  t0.title AS title_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.company AS company_7,
  t0.zip AS zip_8,
  t0.country AS country_9,
  t0.street AS street_10,
  t0.hnr AS hnr_11,
  t0.phone AS phone_12,
  t0.mobil AS mobil_13,
  t0.notiz AS notiz_14,
  t0.change_pw AS change_pw_15,
  t0.must_validated AS must_validated_16,
  t0.bot_license AS bot_license_17,
  t0.created_at AS created_at_18,
  t0.voter AS voter_19,
  t0.gravatar AS gravatar_20,
  t0.account_holder_id AS account_holder_id_21
FROM
  account t0
WHERE
  t0.account_holder_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.image_filename AS image_filename_2, t0.register_ip AS register_ip_3, t0.title AS title_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.company AS company_7, t0.zip AS zip_8, t0.country AS country_9, t0.street AS street_10, t0.hnr AS hnr_11, t0.phone AS phone_12, t0.mobil AS mobil_13, t0.notiz AS notiz_14, t0.change_pw AS change_pw_15, t0.must_validated AS must_validated_16, t0.bot_license AS bot_license_17, t0.created_at AS created_at_18, t0.voter AS voter_19, t0.gravatar AS gravatar_20, t0.account_holder_id AS account_holder_id_21 FROM account t0 WHERE t0.account_holder_id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 55)
5	App\EventSubscriber\MenuSubscriber->buildMenu (line 43)
6	App\EventSubscriber\MenuSubscriber->onKernelController (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
13	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 113)

0.18 ms
(36.56%)

SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.designation AS designation_3,
  t0.app AS app_4,
  t0.email AS email_5,
  t0.log AS log_6,
  t0.oauth AS oauth_7,
  t0.register AS register_8,
  t0.design AS design_9
FROM
  system_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 39)
7	App\Service\N8nService->__construct (line 1769)
8	ContainerF4hxHDN\App_KernelDevDebugContainer::getN8nServiceService (line 3726)
9	ContainerF4hxHDN\App_KernelDevDebugContainer::getTwigService (line 928)
10	ContainerF4hxHDN\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1608)
11	ContainerF4hxHDN\App_KernelDevDebugContainer::getDisableProfilerListenerService (line 1163)
12	ContainerF4hxHDN\App_KernelDevDebugContainer::ContainerF4hxHDN\{closure} (line 221)
13	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
14	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 113)

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
App\Entity\SystemSettings	1

Entities Mapping

Class	Mapping errors
App\Entity\SystemSettings	No errors.
App\Entity\Account	No errors.
App\Entity\User	The field App\Entity\User#accounts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Account#accountHolder does not contain the required 'inversedBy="accounts"' attribute.
App\Entity\N8nWorkflows	No errors.
App\Entity\N8nCredential	No errors.
App\Entity\QdrantUploads	No errors.
App\Entity\QdrantCategory	No errors.
App\Entity\ChatBot	No errors.
App\Entity\ChatBotColor	No errors.
App\Entity\AiBotConfig	No errors.
App\Entity\OAuth2UserConsent	No errors.
App\Entity\MediaCategory	No errors.
App\Entity\Media	No errors.

Symfony Profiler

GET https://www.ki-api.test.sparkundsparkling.com/robots.txt

Configuration Settings

Theme

Page Width