Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.58 ms Query time

0 Invalid entities

35 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.58 ms
(100.00%)

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.provider AS provider_3, t0.type AS type_4, t0.label AS label_5, t0.description AS description_6, t0.value AS value_7, t0.sort_order AS sort_order_8, t0.updated_at AS updated_at_9, t0.updated_by_id AS updated_by_id_10 FROM api_setting t0 ORDER BY t0.sort_order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.provider AS provider_3,
  t0.type AS type_4,
  t0.label AS label_5,
  t0.description AS description_6,
  t0.value AS value_7,
  t0.sort_order AS sort_order_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  api_setting t0
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.provider AS provider_3, t0.type AS type_4, t0.label AS label_5, t0.description AS description_6, t0.value AS value_7, t0.sort_order AS sort_order_8, t0.updated_at AS updated_at_9, t0.updated_by_id AS updated_by_id_10 FROM api_setting t0 ORDER BY t0.sort_order ASC;

#	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	App\Repository\ApiSettingRepository->findAllIndexedByKey (line 43)
5	App\Service\Admin\ApiSettingResolver->resolveFromDatabase (line 110)
6	App\Service\Admin\ApiSettingResolver->get (line 63)
7	App\Service\Admin\ApiSettingEnvProcessor->getEnv (line 37)
8	Symfony\Component\DependencyInjection\Container->getEnv (line 378)
9	Symfony\Component\DependencyInjection\EnvVarProcessor->getEnv (line 169)
10	Symfony\Component\DependencyInjection\Container->getEnv (line 378)
11	ContainerLouIoWI\getCfiSessionServiceService->do (line 23)
12	ContainerLouIoWI\App_KernelDevDebugContainer::load (line 729)
13	ContainerLouIoWI\getCfiTenantServiceService->do (line 24)
14	ContainerLouIoWI\App_KernelDevDebugContainer::load (line 729)
15	ContainerLouIoWI\getUserAuthenticationServiceService->do (line 30)
16	ContainerLouIoWI\App_KernelDevDebugContainer::load (line 729)
17	ContainerLouIoWI\getAi_TraceableToolbox_ChatFacturesService->do (line 34)
18	ContainerLouIoWI\App_KernelDevDebugContainer::load (line 729)
19	ContainerLouIoWI\App_KernelDevDebugContainer->ContainerLouIoWI\{closure} (line 798)
20	iterator_to_array (line 72)
21	Symfony\AI\AiBundle\Profiler\DataCollector::__construct (line 72)
22	ContainerLouIoWI\App_KernelDevDebugContainer->get_Container_Private_ProfilerService (line 795)
23	ContainerLouIoWI\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1627)
24	ContainerLouIoWI\App_KernelDevDebugContainer::ContainerLouIoWI\{closure} (line 1094)
25	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
26	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ApiSetting	33
App\Entity\AdminUser	2

Entities Mapping

Class	Mapping errors
App\Entity\ApiSetting	No errors.
App\Entity\AdminUser	No errors.

Symfony Profiler

GET https://my-cfia.com/login

Configuration Settings

Theme

Page Width