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.
App\Entity\Vehiculo	No errors.
App\Entity\EstatusViaje	No errors.
App\Entity\MetodosPago	No errors.
App\Entity\TravelRoute	No errors.
App\Entity\PagosTaxiExpress	No errors.
App\Entity\Domicilio	No errors.
App\Entity\Credenciales	No errors.
App\Entity\Calificacion	No errors.

Symfony Profiler

GET https://taxiexpres.com/admin/cotizacionViaje

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping