Query Metrics
2
Database Queries
2
Different statements
45.98 ms
Query time
7
Invalid entities
Queries
maenar connection
#▲ | Time | Info |
---|---|---|
1 | 1.31 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 => 2]
|
2 | 44.67 ms |
SELECT u0_.id AS id0, u0_.firstname AS firstname1, u0_.lastname AS lastname2, u0_.email AS email3, u0_.username AS username4, u0_.password AS password5, u0_.nif AS nif6, u0_.company AS company7, u0_.address AS address8, u0_.cp AS cp9, u0_.localidad AS localidad10, u0_.provincia AS provincia11, u0_.comunity AS comunity12, u0_.phone AS phone13, u0_.mphone AS mphone14, u0_.salt AS salt15, u0_.rol AS rol16, u0_.codigorecuperacion AS codigorecuperacion17, u0_.pathdnifrontal AS pathdnifrontal18, u0_.pathdnitrasera AS pathdnitrasera19, u0_.pathfoto AS pathfoto20, u0_.pathrgpdfirmadofisico AS pathrgpdfirmadofisico21, u0_.pathrgpdfirma AS pathrgpdfirma22, u0_.firmadorgpdelectronico AS firmadorgpdelectronico23, u0_.tieneCuenta AS tieneCuenta24, u0_.tipoFianza AS tipoFianza25, u0_.activo AS activo26, u0_.bloqueado AS bloqueado27, u0_.expirado AS expirado28, u1_.pagoWeb AS pagoWeb29, u1_.descuento AS descuento30, u1_.aceptacondiciones AS aceptacondiciones31, u0_.tipo AS tipo32, u1_.distribuidor_id AS distribuidor_id33 FROM UserWeb u1_ INNER JOIN User u0_ ON u1_.id = u0_.id WHERE 1 = 1 AND (u0_.company LIKE '%andreani%' OR u0_.firstname LIKE '%andreani%' OR u0_.lastname LIKE '%andreani%' OR u0_.nif LIKE '%andreani%')
Parameters: []
|
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. |