Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.13 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.58 ms
(51.60%)

SELECT t0.id AS id_1, t0.fecha_grabacion AS fecha_grabacion_2, t0.fecha_factura AS fecha_factura_3, t0.numero_factura AS numero_factura_4, t0.base AS base_5, t0.iva AS iva_6, t0.irpf AS irpf_7, t0.total AS total_8, t0.cobrado_pagado AS cobrado_pagado_9, t0.notas AS notas_10, t0.documento AS documento_11, t0.fecha_descarga AS fecha_descarga_12, t0.tipo_documento_id AS tipo_documento_id_13, t0.proveedor_cliente_id AS proveedor_cliente_id_14, t0.mes_imputacion_id AS mes_imputacion_id_15, t0.cdg_id AS cdg_id_16, t0.empresa_id AS empresa_id_17, t0.refacturar_id AS refacturar_id_18, t0.banco_id AS banco_id_19, t0.usuario_id AS usuario_id_20, t0.lote_id AS lote_id_21, t0.proyecto_id AS proyecto_id_22 FROM asientos t0 WHERE t0.id = ?

Parameters:

[
  "24243"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha_grabacion AS fecha_grabacion_2,
  t0.fecha_factura AS fecha_factura_3,
  t0.numero_factura AS numero_factura_4,
  t0.base AS base_5,
  t0.iva AS iva_6,
  t0.irpf AS irpf_7,
  t0.total AS total_8,
  t0.cobrado_pagado AS cobrado_pagado_9,
  t0.notas AS notas_10,
  t0.documento AS documento_11,
  t0.fecha_descarga AS fecha_descarga_12,
  t0.tipo_documento_id AS tipo_documento_id_13,
  t0.proveedor_cliente_id AS proveedor_cliente_id_14,
  t0.mes_imputacion_id AS mes_imputacion_id_15,
  t0.cdg_id AS cdg_id_16,
  t0.empresa_id AS empresa_id_17,
  t0.refacturar_id AS refacturar_id_18,
  t0.banco_id AS banco_id_19,
  t0.usuario_id AS usuario_id_20,
  t0.lote_id AS lote_id_21,
  t0.proyecto_id AS proyecto_id_22
FROM
  asientos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fecha_grabacion AS fecha_grabacion_2, t0.fecha_factura AS fecha_factura_3, t0.numero_factura AS numero_factura_4, t0.base AS base_5, t0.iva AS iva_6, t0.irpf AS irpf_7, t0.total AS total_8, t0.cobrado_pagado AS cobrado_pagado_9, t0.notas AS notas_10, t0.documento AS documento_11, t0.fecha_descarga AS fecha_descarga_12, t0.tipo_documento_id AS tipo_documento_id_13, t0.proveedor_cliente_id AS proveedor_cliente_id_14, t0.mes_imputacion_id AS mes_imputacion_id_15, t0.cdg_id AS cdg_id_16, t0.empresa_id AS empresa_id_17, t0.refacturar_id AS refacturar_id_18, t0.banco_id AS banco_id_19, t0.usuario_id AS usuario_id_20, t0.lote_id AS lote_id_21, t0.proyecto_id AS proyecto_id_22 FROM asientos t0 WHERE t0.id = '24243';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 505)
6	App\Controller\AdministracionController->verificarArchivo (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.55 ms
(48.40%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.fecha_creacion AS fecha_creacion_5, t0.nombre AS nombre_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.vincular_empresa AS vincular_empresa_9, t0.perfil_id AS perfil_id_10, t0.poblacion_id AS poblacion_id_11, t0.provincia_id AS provincia_id_12, t0.pais_id AS pais_id_13 FROM usuarios t0 WHERE t0.id = ?

Parameters:

[
  2
]

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,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.nombre AS nombre_6,
  t0.email AS email_7,
  t0.direccion AS direccion_8,
  t0.vincular_empresa AS vincular_empresa_9,
  t0.perfil_id AS perfil_id_10,
  t0.poblacion_id AS poblacion_id_11,
  t0.provincia_id AS provincia_id_12,
  t0.pais_id AS pais_id_13
FROM
  usuarios 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, t0.fecha_creacion AS fecha_creacion_5, t0.nombre AS nombre_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.vincular_empresa AS vincular_empresa_9, t0.perfil_id AS perfil_id_10, t0.poblacion_id AS poblacion_id_11, t0.provincia_id AS provincia_id_12, t0.pais_id AS pais_id_13 FROM usuarios t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Entities Mapping

Class	Mapping errors
App\Entity\Usuarios	The association App\Entity\Usuarios#perfil refers to the inverse side field App\Entity\Perfiles#usuarios which does not exist. The association App\Entity\Usuarios#poblacion refers to the inverse side field App\Entity\Poblaciones#usuarios which does not exist. The association App\Entity\Usuarios#provincia refers to the inverse side field App\Entity\Provincias#usuarios which does not exist. The association App\Entity\Usuarios#pais refers to the inverse side field App\Entity\Paises#usuarios which does not exist.
App\Entity\Perfiles	No errors.
App\Entity\Poblaciones	The field 'App\Entity\Poblaciones#latitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Poblaciones#longitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Poblaciones#altitud' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Poblaciones#provincia refers to the inverse side field App\Entity\Provincias#poblaciones which does not exist.
App\Entity\Provincias	The association App\Entity\Provincias#poblacion refers to the owning side field App\Entity\Poblaciones#provincias which does not exist. The association App\Entity\Provincias#usuario refers to the owning side field App\Entity\Poblaciones#provincias which does not exist. The association App\Entity\Provincias#pais refers to the inverse side field App\Entity\Paises#provincias which does not exist. The association App\Entity\Provincias#codigoPostal refers to the owning side field App\Entity\CodigosPostales#provincias which does not exist.
App\Entity\Paises	The association App\Entity\Paises#usuario refers to the owning side field App\Entity\Usuarios#paises which does not exist. The association App\Entity\Paises#poblacion refers to the owning side field App\Entity\Poblaciones#paises which does not exist. The association App\Entity\Paises#codigoPostal refers to the owning side field App\Entity\CodigosPostales#paises which does not exist.
App\Entity\Asientos	The field 'App\Entity\Asientos#base' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Asientos#iva' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Asientos#irpf' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Asientos#total' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Asientos#tipoDocumento refers to the inverse side field App\Entity\TiposDocumento#asientos which does not exist. The association App\Entity\Asientos#proveedorCliente refers to the inverse side field App\Entity\ProveedoresClientes#asientos which does not exist. The association App\Entity\Asientos#mesImputacion refers to the inverse side field App\Entity\MesesImputacion#asientos which does not exist. The association App\Entity\Asientos#cdg refers to the inverse side field App\Entity\Conceptos#asientos which does not exist. The association App\Entity\Asientos#empresa refers to the inverse side field App\Entity\Empresas#asientos which does not exist. The association App\Entity\Asientos#refacturar refers to the inverse side field App\Entity\Empresas#asientos which does not exist. The association App\Entity\Asientos#banco refers to the inverse side field App\Entity\Bancos#asientos which does not exist. The association App\Entity\Asientos#usuario refers to the inverse side field App\Entity\Usuarios#asientos which does not exist. The association App\Entity\Asientos#lote refers to the inverse side field App\Entity\Lotes#asientos which does not exist. The association App\Entity\Asientos#proyecto refers to the inverse side field App\Entity\Proyectos#asientos which does not exist.
App\Entity\TiposDocumento	No errors.
App\Entity\ProveedoresClientes	No errors.
App\Entity\MesesImputacion	No errors.
App\Entity\Conceptos	No errors.
App\Entity\Empresas	The association App\Entity\Empresas#pais refers to the inverse side field App\Entity\Paises#empresas which does not exist.
App\Entity\Bancos	No errors.
App\Entity\Lotes	The association App\Entity\Lotes#usuario refers to the inverse side field App\Entity\Usuarios#lotes which does not exist. The association App\Entity\Lotes#visador refers to the inverse side field App\Entity\Usuarios#lotes which does not exist.
App\Entity\Proyectos	No errors.

Symfony Profiler

POST https://contabilidad.tasarauto.es/listado/asientos/verificar-archivo?id=24243

Configuration Settings

Theme