Query Metrics
12
Database Queries
3
Different statements
6.29 ms
Query time
4
Invalid entities
Grouped Statements
maenar connection
Time▼ | Count | Info |
---|---|---|
3.69 ms (58.61%) |
10 |
SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6, t0.category_id AS category_id7 FROM Subcategory t0 WHERE t0.category_id = ?
Parameters: [0 => 1]
|
2.17 ms (34.49%) |
1 |
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, d1_.nombre AS nombre29, d1_.latitud AS latitud30, d1_.longitud AS longitud31, d1_.especial AS especial32, d1_.sendSMS AS sendSMS33, d1_.entregadirectaacliente AS entregadirectaacliente34, u0_.tipo AS tipo35, d1_.categorydistributor_id AS categorydistributor_id36, d1_.gestorZona_id AS gestorZona_id37 FROM Distributor d1_ INNER JOIN User u0_ ON d1_.id = u0_.id WHERE u0_.activo = 1
Parameters: []
|
0.43 ms (6.90%) |
1 |
SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0
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\productsBundle\Entity\Category |
|
Maenar\productsBundle\Entity\Subcategory | No errors. |
Maenar\coreBundle\Entity\User |
|
Maenar\coreBundle\Entity\Distributor |
|
Maenar\coreBundle\Entity\usuarioautorizado | No errors. |
Maenar\coreBundle\Entity\CategoryDistributor |
|
Maenar\coreBundle\Entity\gestorZona | No errors. |