Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.16 ms Query time

7 Invalid entities

Queries

Group similar statements

maenar connection

#▲	Time	Info
1	1.16 ms	SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ? Parameters: [0 => 39] View formatted query View runnable query Explain query SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ? SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = 39;

#▲

Time

Info

1.16 ms

SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?

Parameters: [0 => 39]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id6, 
  t0.firstname AS firstname7, 
  t0.lastname AS lastname8, 
  t0.email AS email9, 
  t0.username AS username10, 
  t0.password AS password11, 
  t0.nif AS nif12, 
  t0.company AS company13, 
  t0.address AS address14, 
  t0.cp AS cp15, 
  t0.localidad AS localidad16, 
  t0.provincia AS provincia17, 
  t0.comunity AS comunity18, 
  t0.phone AS phone19, 
  t0.mphone AS mphone20, 
  t0.salt AS salt21, 
  t0.rol AS rol22, 
  t0.codigorecuperacion AS codigorecuperacion23, 
  t0.pathdnifrontal AS pathdnifrontal24, 
  t0.pathdnitrasera AS pathdnitrasera25, 
  t0.pathfoto AS pathfoto26, 
  t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, 
  t0.pathrgpdfirma AS pathrgpdfirma28, 
  t0.firmadorgpdelectronico AS firmadorgpdelectronico29, 
  t0.tieneCuenta AS tieneCuenta30, 
  t0.tipoFianza AS tipoFianza31, 
  t0.activo AS activo32, 
  t0.bloqueado AS bloqueado33, 
  t0.expirado AS expirado34, 
  t0.tipo, 
  t1.nombre AS nombre35, 
  t1.latitud AS latitud36, 
  t1.longitud AS longitud37, 
  t1.especial AS especial38, 
  t1.sendSMS AS sendSMS39, 
  t1.entregadirectaacliente AS entregadirectaacliente40, 
  t1.categorydistributor_id AS categorydistributor_id41, 
  t1.gestorZona_id AS gestorZona_id42, 
  t3.pagoWeb AS pagoWeb43, 
  t3.descuento AS descuento44, 
  t3.aceptacondiciones AS aceptacondiciones45, 
  t3.distribuidor_id AS distribuidor_id46, 
  t5.gestorzona_id AS gestorzona_id47 
FROM 
  User t0 
  LEFT JOIN Distributor t1 ON t0.id = t1.id 
  LEFT JOIN admin t2 ON t0.id = t2.id 
  LEFT JOIN UserWeb t3 ON t0.id = t3.id 
  LEFT JOIN little t4 ON t0.id = t4.id 
  LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = 39;

localizacion connection

No database queries were performed.

Database Connections

Name	Service
localizacion	doctrine.dbal.localizacion_connection
maenar	doctrine.dbal.maenar_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
localizacion	doctrine.orm.localizacion_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

localizacion entity manager

No loaded entities.

default entity manager

Class	Mapping errors
Maenar\coreBundle\Entity\User	The field Maenar\coreBundle\Entity\User#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute.
Maenar\coreBundle\Entity\Distributor	The field Maenar\coreBundle\Entity\Distributor#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute. The mappings Maenar\coreBundle\Entity\Distributor#categoryDistributor and Maenar\coreBundle\Entity\CategoryDistributor#distributors are inconsistent with each other.
Maenar\coreBundle\Entity\admin	The field Maenar\coreBundle\Entity\admin#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute.
Maenar\coreBundle\Entity\UserWeb	The field Maenar\coreBundle\Entity\UserWeb#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute.
Maenar\coreBundle\Entity\little	The field Maenar\coreBundle\Entity\little#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute.
Maenar\coreBundle\Entity\gestorZonaUser	The field Maenar\coreBundle\Entity\gestorZonaUser#usuariosautorizados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\coreBundle\Entity\usuarioautorizado#cliente does not contain the required 'inversedBy=usuariosautorizados' attribute.
Maenar\coreBundle\Entity\usuarioautorizado	No errors.
Maenar\coreBundle\Entity\CategoryDistributor	The association Maenar\coreBundle\Entity\CategoryDistributor#distributors refers to the owning side field Maenar\coreBundle\Entity\Distributor#categorydistributor which does not exist.
Maenar\coreBundle\Entity\gestorZona	No errors.