Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.33 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.23 ms
(52.94%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\MobileInterface\DriverMobileController->setCoordinateData (line 376)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.41 ms
(17.64%)

SELECT t0.id AS id_1, t0.client_key AS client_key_2, t0.public_key AS public_key_3, t0.secret_key AS secret_key_4, t0.creation_date AS creation_date_5 FROM credenciales t0 WHERE t0.client_key = ? LIMIT 1

Parameters:

[
  "id_6b4a68f67"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.client_key AS client_key_2,
  t0.public_key AS public_key_3,
  t0.secret_key AS secret_key_4,
  t0.creation_date AS creation_date_5
FROM
  credenciales t0
WHERE
  t0.client_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.client_key AS client_key_2, t0.public_key AS public_key_3, t0.secret_key AS secret_key_4, t0.creation_date AS creation_date_5 FROM credenciales t0 WHERE t0.client_key = 'id_6b4a68f67' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Security\SecurityEncrypt->encryptSecurityAuthenticator (line 28)
5	App\Controller\MobileInterface\DriverMobileController->setCoordinateData (line 367)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.29 ms
(12.36%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.telefono AS telefono_4, t0.mail AS mail_5, t0.inhabilitado AS inhabilitado_6, t0.calificacion AS calificacion_7, t0.posicion AS posicion_8, t0.viaje AS viaje_9, t0.created_date AS created_date_10, t0.firebase_token AS firebase_token_11, t0.step_register AS step_register_12, t0.nip AS nip_13, t0.unique_id AS unique_id_14, t0.working AS working_15, t0.credenciales_id AS credenciales_id_16 FROM conductor t0 WHERE t0.unique_id = ? LIMIT 1

Parameters:

[
  "driver_68c10c1dedb8e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellidos AS apellidos_3,
  t0.telefono AS telefono_4,
  t0.mail AS mail_5,
  t0.inhabilitado AS inhabilitado_6,
  t0.calificacion AS calificacion_7,
  t0.posicion AS posicion_8,
  t0.viaje AS viaje_9,
  t0.created_date AS created_date_10,
  t0.firebase_token AS firebase_token_11,
  t0.step_register AS step_register_12,
  t0.nip AS nip_13,
  t0.unique_id AS unique_id_14,
  t0.working AS working_15,
  t0.credenciales_id AS credenciales_id_16
FROM
  conductor t0
WHERE
  t0.unique_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.telefono AS telefono_4, t0.mail AS mail_5, t0.inhabilitado AS inhabilitado_6, t0.calificacion AS calificacion_7, t0.posicion AS posicion_8, t0.viaje AS viaje_9, t0.created_date AS created_date_10, t0.firebase_token AS firebase_token_11, t0.step_register AS step_register_12, t0.nip AS nip_13, t0.unique_id AS unique_id_14, t0.working AS working_15, t0.credenciales_id AS credenciales_id_16 FROM conductor t0 WHERE t0.unique_id = 'driver_68c10c1dedb8e' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\MobileInterface\DriverMobileController->setCoordinateData (line 370)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.28 ms
(11.97%)

UPDATE conductor SET posicion = ? WHERE id = ?

Parameters:

[
  "[19.055545,-98.160175]"
  34
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  conductor
SET
  posicion = ?
WHERE
  id = ?

UPDATE conductor SET posicion = '[19.055545,-98.160175]' WHERE id = 34;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 496)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 380)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\MobileInterface\DriverMobileController->setCoordinateData (line 376)
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.12 ms
(5.10%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\MobileInterface\DriverMobileController->setCoordinateData (line 376)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\Credenciales	2
App\Entity\Conductor	1

Entities Mapping

Class	Mapping errors
App\Entity\Credenciales	No errors.
App\Entity\Cliente	No errors.
App\Entity\Conductor	No errors.
App\Entity\Calificacion	No errors.
App\Entity\Viaje	No errors.
App\Entity\CotizacionViaje	No errors.

Symfony Profiler

POST https://taxiexpres.com/mobile/driver/setCoordinateData

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping