Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.83 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.83 ms
(100.00%)

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?

Parameters:

[
  "%ROLE_SUPER_ADMIN%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.roles LIKE ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_SUPER_ADMIN%';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 55)
8	App\EventListener\SuperAdminListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
15	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
serprovit_prod	doctrine.dbal.serprovit_prod_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\User	No errors.
App\Entity\Contacto	No errors.
App\Entity\UserPerfil	No errors.
App\Entity\UserFarm	No errors.
App\Entity\UserSonda	No errors.
App\Entity\UserDevice	No errors.
App\Entity\UserCondicionesAceptacion	No errors.
App\Entity\Integradora	No errors.
App\Entity\Email	No errors.
App\Entity\Phone	No errors.
App\Entity\Direccion	No errors.
App\Entity\ContactRol	No errors.
App\Entity\Perfil	No errors.
App\Entity\Explotacion	No errors.
App\Entity\Sonda	No errors.
App\Entity\Condiciones	No errors.
App\Entity\AppVersion	No errors.
App\Entity\Gateway	No errors.
App\Entity\MaterialVeterinarioPedidoDetalle	No errors.
App\Entity\VisitaEntrada	No errors.
App\Entity\AlbaranMovEntradaDetalleMacho	No errors.
App\Entity\FamiliaMedicamento	No errors.
App\Entity\AuditoriaEncuesta	No errors.
App\Entity\AlbaranTransporte	No errors.
App\Entity\MaterialVeterinario	No errors.
App\Entity\TipoAuditoria	No errors.
App\Entity\Language	No errors.
App\Entity\AlbaranPiensoDetalleArchived	No errors.
App\Entity\SubAlmacenVeterinario	No errors.
App\Entity\ExplotacionProveedor	No errors.
App\Entity\Nave	No errors.
App\Entity\TipoSonda	No errors.
App\Entity\MovimientoInterno	No errors.
App\Entity\ClienteVenta	No errors.
App\Entity\ItinerarioNuevo	No errors.
App\Entity\TypeOfFarmTranslation	No errors.
App\Entity\Logo	No errors.
App\Entity\Medicamento	No errors.
App\Entity\Animal	No errors.
App\Entity\VisitaParte	No errors.
App\Entity\Silo	No errors.
App\Entity\AlbaranMovEntrada	No errors.
App\Entity\UiActionPolicy	No errors.
App\Entity\TypeOfRolTranslation	No errors.
App\Entity\Broker	No errors.
App\Entity\Auditoria	No errors.
App\Entity\TipoGasto	No errors.
App\Entity\AuditoriaExplotacion	No errors.
App\Entity\UiPolicy	No errors.
App\Entity\PedidoPienso	No errors.
App\Entity\ParametrosPedidoMedicina	No errors.
App\Entity\FamiliaMaterialVeterinario	No errors.
App\Entity\Lavadero	No errors.
App\Entity\UserSecurityLog	No errors.
App\Entity\Receta	No errors.
App\Entity\Veterinario	No errors.
App\Entity\NaveSondaLog	No errors.
App\Entity\UserNaveSondaRango	No errors.
App\Entity\ItinerarioAnimal	No errors.
App\Entity\TipoAnimal	No errors.
App\Entity\ItinerarioDestinoAnimal	No errors.
App\Entity\VisitaEncuesta	No errors.
App\Entity\ExplotacionFabrica	No errors.
App\Entity\TarifaVigenciaMedicamento	No errors.
App\Entity\Camion	No errors.
App\Entity\MovimientoNave	No errors.
App\Entity\CarpetaRemotoSincronizacion	No errors.
App\Entity\AlbaranPienso	No errors.
App\Entity\MedicamentoStock	No errors.
App\Entity\TransporteTraspasoPienso	No errors.
App\Entity\AlbaranMovSalida	No errors.
App\Entity\TransportePienso	No errors.
App\Entity\Parametros	No errors.
App\Entity\Mantenimiento	No errors.
App\Entity\MovInternoPienso	No errors.
App\Entity\AuditInventarioP2	No errors.
App\Entity\ProveedorMedicamento	No errors.
App\Entity\PrevisionVentaModuloCarga	No errors.
App\Entity\PedidoPiensoSilo	No errors.
App\Entity\TarifaVigenciaMaterialVeterinario	No errors.
App\Entity\MedicamentoPedido	No errors.
App\Entity\AppVersionCondiciones	No errors.
App\Entity\AlbaranPiensoArchived	No errors.
App\Entity\Agencia	No errors.
App\Entity\TypeOfFarm	No errors.
App\Entity\FabricaPienso	No errors.
App\Entity\Population	No errors.
App\Entity\UserActivityLog	No errors.
App\Entity\AlmacenVeterinario	No errors.
App\Entity\Conductor	No errors.
App\Entity\Remolque	No errors.
App\Entity\PedidoPiensoTransporte	No errors.
App\Entity\MovSalida	No errors.
App\Entity\MovAjuste	No errors.
App\Entity\PasswordReset	No errors.
App\Entity\AutoValidacionPedidoMedicamentoTipoExplotacion	No errors.
App\Entity\Protocolonutricional	No errors.
App\Entity\Tarifa	No errors.
App\Entity\Itinerario	No errors.
App\Entity\EstadoSanitario	No errors.
App\Entity\Bascula	No errors.
App\Entity\Country	No errors.
App\Entity\RelacionPrevisionVentaCamion	No errors.
App\Entity\Zona	No errors.
App\Entity\TypeOfRol	No errors.
App\Entity\FeedTransfer	No errors.
App\Entity\Movimiento	No errors.
App\Entity\AlbaranDeviceNotification	No errors.
App\Entity\TarifaVigencia	No errors.
App\Entity\MovRetiradaSilo	No errors.
App\Entity\AnimalSubtipo	No errors.
App\Entity\TypeOfAlertTranslation	No errors.
App\Entity\TipoPiensoProtocolo	No errors.
App\Entity\NotificationFail	No errors.
App\Entity\MedicamentoAlmacen	No errors.
App\Entity\Intervalo	No errors.
App\Entity\DesplegableNave	No errors.
App\Entity\AlbaranMovEntradaDetalle	No errors.
App\Entity\Funcionalidad	No errors.
App\Entity\TypeOfAlert	No errors.
App\Entity\MovEntrada	No errors.
App\Entity\AlbaranMovSalidaDetalle	No errors.
App\Entity\AccessLog	No errors.
App\Entity\Chofer	No errors.
App\Entity\ExplotacionAlerta	No errors.
App\Entity\AuditoriaTemplate	No errors.
App\Entity\Sala	No errors.
App\Entity\MovimientoBaja	No errors.
App\Entity\ItinerarioDestinoNuevo	No errors.
App\Entity\Diagnostico	No errors.
App\Entity\InformeVisita	No errors.
App\Entity\Crianza	No errors.
App\Entity\UserActionLog	No errors.
App\Entity\FabricanteSensorica	No errors.
App\Entity\LoteMedicamento	No errors.
App\Entity\TipoDireccion	No errors.
App\Entity\MovRetiradaSiloDetalle	No errors.
App\Entity\Bioseguridad	No errors.
App\Entity\AlbaranPiensoDetalle	No errors.
App\Entity\ProveedorTarifa	No errors.
App\Entity\AlbaranTraspasoPienso	The field App\Entity\AlbaranTraspasoPienso#detalles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AlbaranTraspasoPiensoDetalle#albaranTraspaso does not contain the required 'inversedBy="detalles"' attribute.
App\Entity\Albaran	No errors.
App\Entity\TipoPienso	No errors.
App\Entity\Purin	No errors.
App\Entity\NaveSonda	No errors.
App\Entity\Modulo	No errors.
App\Entity\ExplotacionProveedorMaterialVeterinario	No errors.
App\Entity\Visita	No errors.
App\Entity\Matadero	No errors.
App\Entity\VisitaCarga	No errors.
App\Entity\MedicamentoPedidoDetalle	No errors.
App\Entity\AuditoriaPersonalizada	No errors.
App\Entity\RangoModuloCarga	No errors.
App\Entity\TipoVisita	No errors.
App\Entity\TransporteAnimal	No errors.
App\Entity\Province	No errors.
App\Entity\Permiso	No errors.
App\Entity\ValorDesplegableNave	No errors.
App\Entity\AlbaranMovEntradaDetalleHembra	No errors.
App\Entity\NodoTor	No errors.
App\Entity\UiAction	No errors.
App\Entity\AlbaranTraspasoPiensoDetalle	No errors.
App\Entity\ArchivoRemotoSincronizacion	No errors.
App\Entity\Laboratorio	No errors.
App\Entity\NotificationQueue	No errors.
App\Entity\CloudCuenta	No errors.
App\Entity\PrevisionCargaManual	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://dev.ingafood.pigdata.es/robots.txt

Configuration Settings

Theme

Page Width