Query Metrics
8
Database Queries
8
Different statements
4.50 ms
Query time
8
Invalid entities
Queries
maenar connection
#▲ | Time | Info |
---|---|---|
1 | 1.26 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 => 8139]
|
2 | 0.60 ms |
SELECT t0.id AS id1, t0.rangoinferior AS rangoinferior2, t0.rangointermedioinf AS rangointermedioinf3, t0.rangointermediosup AS rangointermediosup4, t0.rangosuperior AS rangosuperior5, t0.recargo1 AS recargo16, t0.recargo2 AS recargo27, t0.recargo3 AS recargo38, t0.servicioExpress AS servicioExpress9, t0.name AS name10 FROM CategoryDistributor t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
3 | 0.30 ms |
SELECT t0.id AS id1, t0.recargo AS recargo2 FROM servicioDomicilio t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
4 | 0.34 ms |
SELECT t0.id AS id1, t0.tipoIva AS tipoIva2, t0.valor AS valor3, t0.recargo AS recargo4, t0.eliminado AS eliminado5 FROM TipoIVA t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
5 | 0.51 ms |
SELECT t0.id AS id1, t0.texto AS texto2, t0.coste AS coste3, t0.textovisual AS textovisual4 FROM rangosserviciodomicilio t0
Parameters: []
|
6 | 0.42 ms |
SELECT r0_.id AS id0, r0_.texto AS texto1, r0_.coste AS coste2, r0_.textovisual AS textovisual3 FROM rangosserviciodomicilio r0_
Parameters: []
|
7 | 0.56 ms |
SELECT t0.id AS id1, t0.nombre AS nombre2, t0.telefono AS telefono3, t0.email AS email4 FROM gestorZona t0 WHERE t0.id = ?
Parameters: [0 => 3]
|
8 | 0.51 ms |
SELECT t1.id AS id2, t1.firstname AS firstname3, t1.lastname AS lastname4, t1.email AS email5, t1.username AS username6, t1.password AS password7, t1.nif AS nif8, t1.company AS company9, t1.address AS address10, t1.cp AS cp11, t1.localidad AS localidad12, t1.provincia AS provincia13, t1.comunity AS comunity14, t1.phone AS phone15, t1.mphone AS mphone16, t1.salt AS salt17, t1.rol AS rol18, t1.codigorecuperacion AS codigorecuperacion19, t1.pathdnifrontal AS pathdnifrontal20, t1.pathdnitrasera AS pathdnitrasera21, t1.pathfoto AS pathfoto22, t1.pathrgpdfirmadofisico AS pathrgpdfirmadofisico23, t1.pathrgpdfirma AS pathrgpdfirma24, t1.firmadorgpdelectronico AS firmadorgpdelectronico25, t1.tieneCuenta AS tieneCuenta26, t1.tipoFianza AS tipoFianza27, t1.activo AS activo28, t1.bloqueado AS bloqueado29, t1.expirado AS expirado30, t0.gestorzona_id AS gestorzona_id31, t1.tipo FROM gestorZonaUser t0 INNER JOIN User t1 ON t0.id = t1.id WHERE t0.gestorzona_id = ?
Parameters: [0 => 3]
|
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 |
|
Maenar\coreBundle\Entity\Distributor |
|
Maenar\coreBundle\Entity\admin |
|
Maenar\coreBundle\Entity\UserWeb |
|
Maenar\coreBundle\Entity\little |
|
Maenar\coreBundle\Entity\gestorZonaUser |
|
Maenar\coreBundle\Entity\usuarioautorizado | No errors. |
Maenar\coreBundle\Entity\CategoryDistributor |
|
Maenar\coreBundle\Entity\gestorZona | No errors. |
Maenar\orderBundle\Entity\Orders |
|
Maenar\varsBundle\Entity\rangosserviciodomicilio | No errors. |
Maenar\varsBundle\Entity\servicioDomicilio | No errors. |
Maenar\productsBundle\Entity\TipoIVA | No errors. |