Query Metrics
12
Database Queries
3
Different statements
6.29 ms
Query time
4
Invalid entities
Queries
maenar connection
#▲ | Time | Info |
---|---|---|
1 | 0.43 ms |
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: []
|
2 | 2.17 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, 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: []
|
3 | 0.97 ms |
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]
|
4 | 0.35 ms |
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 => 2]
|
5 | 0.31 ms |
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 => 3]
|
6 | 0.32 ms |
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 => 4]
|
7 | 0.29 ms |
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 => 5]
|
8 | 0.29 ms |
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 => 6]
|
9 | 0.30 ms |
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 => 7]
|
10 | 0.29 ms |
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 => 8]
|
11 | 0.28 ms |
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 => 9]
|
12 | 0.27 ms |
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 => 10]
|
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. |