Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.88 ms Query time

0 Invalid entities

57 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.83 ms

SELECT c0_.id AS id_0, c0_.origen AS origen_1, c0_.destino AS destino_2, c0_.distancia AS distancia_3, c0_.monto_tarifa AS monto_tarifa_4, c0_.ruta AS ruta_5, c0_.config_viaje AS config_viaje_6, c0_.cliente_id AS cliente_id_7, c0_.tarifa_config_id AS tarifa_config_id_8, c0_.driver_id AS driver_id_9 FROM cotizacion_viaje c0_ LEFT JOIN viaje v1_ ON c0_.id = v1_.cotizacion_id WHERE v1_.id IS NULL ORDER BY c0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.origen AS origen_1,
  c0_.destino AS destino_2,
  c0_.distancia AS distancia_3,
  c0_.monto_tarifa AS monto_tarifa_4,
  c0_.ruta AS ruta_5,
  c0_.config_viaje AS config_viaje_6,
  c0_.cliente_id AS cliente_id_7,
  c0_.tarifa_config_id AS tarifa_config_id_8,
  c0_.driver_id AS driver_id_9
FROM
  cotizacion_viaje c0_
  LEFT JOIN viaje v1_ ON c0_.id = v1_.cotizacion_id
WHERE
  v1_.id IS NULL
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.origen AS origen_1, c0_.destino AS destino_2, c0_.distancia AS distancia_3, c0_.monto_tarifa AS monto_tarifa_4, c0_.ruta AS ruta_5, c0_.config_viaje AS config_viaje_6, c0_.cliente_id AS cliente_id_7, c0_.tarifa_config_id AS tarifa_config_id_8, c0_.driver_id AS driver_id_9 FROM cotizacion_viaje c0_ LEFT JOIN viaje v1_ ON c0_.id = v1_.cotizacion_id WHERE v1_.id IS NULL ORDER BY c0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\CotizacionViajeController->index (line 24)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.53 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 73)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 44)
13	Symfony\Bridge\Twig\AppVariable->getUser (line 92)
14	Twig\Extension\CoreExtension->getAttribute (line 1909)
15	__TwigTemplate_9e0672a34dfbdb40fc09d326162a9b1f::doDisplay (line 85)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_5d10f005dbb806284c32f1a0882ddf29->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	App\Controller\CotizacionViajeController->index (line 26)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.52 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.route AS route_2, m0_.icon AS icon_3, m0_.minimum_role AS minimum_role_4, m0_.priority AS priority_5, m0_.active AS active_6 FROM module m0_ ORDER BY m0_.priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.route AS route_2,
  m0_.icon AS icon_3,
  m0_.minimum_role AS minimum_role_4,
  m0_.priority AS priority_5,
  m0_.active AS active_6
FROM
  module m0_
ORDER BY
  m0_.priority ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.route AS route_2, m0_.icon AS icon_3, m0_.minimum_role AS minimum_role_4, m0_.priority AS priority_5, m0_.active AS active_6 FROM module m0_ ORDER BY m0_.priority ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\Utils\MenuValidator->menuItem (line 13)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_74b65346b5b6807064557d3e3b452e51->doDisplay (line 77)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_9e0672a34dfbdb40fc09d326162a9b1f->doDisplay (line 131)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_5d10f005dbb806284c32f1a0882ddf29->doDisplay (line 54)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
27	App\Controller\CotizacionViajeController->index (line 26)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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\CotizacionViaje	41
App\Entity\Cliente	6
App\Entity\Module	6
App\Entity\TarifaConfig	2
App\Entity\Conductor	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\CotizacionViaje	No errors.
App\Entity\Viaje	No errors.
App\Entity\Cliente	No errors.
App\Entity\TarifaConfig	No errors.
App\Entity\Conductor	No errors.
App\Entity\User	No errors.
App\Entity\Module	No errors.

Symfony Profiler

GET https://taxiexpres.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CUtils%255CMenuValidator%253A%253AmenuItem

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping