Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.82 ms Query time

0 Invalid entities

Time▼

Count

Info

1.51 ms
(53.68%)

CALL sp_DeviceAuth_getEmpresas()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

CALL sp_DeviceAuth_getEmpresas()

CALL sp_DeviceAuth_getEmpresas();

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 340)
3	App\SIE\Catalogo\CatalogLibrary->tryStoreProcedures (line 190)
4	App\SIE\Catalogo\CatalogLibrary->getResource (line 46)
5	App\SIE\Inventario\Services\SIEAppAuthService->appDoLoginJsonResponse (line 52)
6	App\Controller\Inventario\API\LoginAPIController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.66 ms
(23.34%)

CALL sp_DeviceAuth_getReglas(:appName)

Parameters:

[
  "appName" => "SIE-INV"
]

View formatted query View runnable query Explain query View query backtrace

CALL sp_DeviceAuth_getReglas(:appName)

CALL sp_DeviceAuth_getReglas('SIE-INV');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 340)
3	App\SIE\Catalogo\CatalogLibrary->tryStoreProcedures (line 190)
4	App\SIE\Catalogo\CatalogLibrary->getResource (line 48)
5	App\SIE\Inventario\Services\SIEAppAuthService->appDoLoginJsonResponse (line 52)
6	App\Controller\Inventario\API\LoginAPIController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.65 ms
(22.98%)

CALL sp_DeviceAuth_getUsuarios(:appName)

Parameters:

[
  "appName" => "SIE-INV"
]

View formatted query View runnable query Explain query View query backtrace

CALL sp_DeviceAuth_getUsuarios(:appName)

CALL sp_DeviceAuth_getUsuarios('SIE-INV');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 340)
3	App\SIE\Catalogo\CatalogLibrary->tryStoreProcedures (line 190)
4	App\SIE\Catalogo\CatalogLibrary->getResource (line 47)
5	App\SIE\Inventario\Services\SIEAppAuthService->appDoLoginJsonResponse (line 52)
6	App\Controller\Inventario\API\LoginAPIController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.