Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.18 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(59.07%)

SELECT t0.id AS id_1, t0.nombre_tarifa AS nombre_tarifa_2, t0.coste_entrante AS coste_entrante_3, t0.coste_saliente AS coste_saliente_4, t0.coste_fijo_lucia AS coste_fijo_lucia_5, t0.coste_desarrollo AS coste_desarrollo_6, t0.puesta_marcha_f1_f2 AS puesta_marcha_f1_f2_7, t0.coste_fijo_tickets AS coste_fijo_tickets_8 FROM tarifa t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_tarifa AS nombre_tarifa_2,
  t0.coste_entrante AS coste_entrante_3,
  t0.coste_saliente AS coste_saliente_4,
  t0.coste_fijo_lucia AS coste_fijo_lucia_5,
  t0.coste_desarrollo AS coste_desarrollo_6,
  t0.puesta_marcha_f1_f2 AS puesta_marcha_f1_f2_7,
  t0.coste_fijo_tickets AS coste_fijo_tickets_8
FROM
  tarifa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_tarifa AS nombre_tarifa_2, t0.coste_entrante AS coste_entrante_3, t0.coste_saliente AS coste_saliente_4, t0.coste_fijo_lucia AS coste_fijo_lucia_5, t0.coste_desarrollo AS coste_desarrollo_6, t0.puesta_marcha_f1_f2 AS puesta_marcha_f1_f2_7, t0.coste_fijo_tickets AS coste_fijo_tickets_8 FROM tarifa t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\RecogidaDatosController->index (line 82)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.89 ms
(40.93%)

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.message AS message_3, t0.scheduled_start AS scheduled_start_4, t0.scheduled_end AS scheduled_end_5, t0.updated_at AS updated_at_6, t0.updated_by_id AS updated_by_id_7 FROM maintenance_config t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.message AS message_3,
  t0.scheduled_start AS scheduled_start_4,
  t0.scheduled_end AS scheduled_end_5,
  t0.updated_at AS updated_at_6,
  t0.updated_by_id AS updated_by_id_7
FROM
  maintenance_config t0
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.message AS message_3, t0.scheduled_start AS scheduled_start_4, t0.scheduled_end AS scheduled_end_5, t0.updated_at AS updated_at_6, t0.updated_by_id AS updated_by_id_7 FROM maintenance_config t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\MaintenanceConfigRepository->getCurrentConfig (line 24)
5	App\EventListener\MaintenanceListener->onKernelRequest (line 45)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\MaintenanceConfig	1
App\Entity\User	1
App\Entity\Tarifa	1

Entities Mapping

Class	Mapping errors
App\Entity\MaintenanceConfig	No errors.
App\Entity\User	No errors.
App\Entity\Tarifa	The field 'App\Entity\Tarifa#costeEntrante' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tarifa#costeSaliente' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tarifa#costeFijoLucia' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tarifa#costeDesarrollo' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tarifa#puestaMarchaF1F2' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Tarifa#costeFijoTickets' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://pre.secretia.es/recogida-datos

Configuration Settings

Theme

Page Width