https://192.168.7.15:8081/maenar-distribuidores/

Query Metrics

12 Database Queries
3 Different statements
6.29 ms Query time
4 Invalid entities

Queries

Group similar statements

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
  • The field Maenar\productsBundle\Entity\Category#subcategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Subcategory#category does not contain the required 'inversedBy=subcategories' attribute.
Maenar\productsBundle\Entity\Subcategory No 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\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.