https://192.168.7.15:8081/

Query Metrics

21 Database Queries
5 Different statements
10.95 ms Query time
6 Invalid entities

Queries

Group similar statements

maenar connection

# Time Info
1 0.53 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 0.75 ms
SELECT t0.id AS id1, t0.nombreEmpresa AS nombreEmpresa2, t0.empresa AS empresa3, t0.lema AS lema4, t0.cif AS cif5, t0.direccion AS direccion6, t0.cp AS cp7, t0.localidad AS localidad8, t0.provincia AS provincia9, t0.telefonoFijo AS telefonoFijo10, t0.telefonoMovil AS telefonoMovil11, t0.fax AS fax12, t0.email AS email13, t0.web AS web14, t0.path AS path15, t0.codigoPortes AS codigoPortes16, t0.video AS video17 FROM Empresa t0 WHERE t0.id = ?
Parameters: [0 => 1]
3 4.05 ms
SELECT p0_.id AS id0, p0_.nombre AS nombre1, p0_.nombreURL AS nombreURL2, p0_.fechaAlta AS fechaAlta3, p0_.codigo AS codigo4, p0_.pathqr AS pathqr5, p0_.descripcion AS descripcion6, p0_.especificaciones AS especificaciones7, p0_.eliminado AS eliminado8, p0_.stockTotal AS stockTotal9, p0_.stockReal AS stockReal10, p0_.mostrarPrincipal AS mostrarPrincipal11, p0_.title AS title12, p0_.metadescription AS metadescription13, p0_.activo AS activo14, p0_.md5qr AS md5qr15, p1_.precioDia AS precioDia16, p1_.fianza AS fianza17, p1_.descuento37 AS descuento3718, p1_.descuento830 AS descuento83019, p1_.descuento31 AS descuento3120, p1_.desgaste AS desgaste21, p1_.tipoDesgaste AS tipoDesgaste22, p1_.precioDesgaste AS precioDesgaste23, p1_.precioSuciedad AS precioSuciedad24, p1_.precioRecargo AS precioRecargo25, p1_.suplementoTorre AS suplementoTorre26, p1_.mostrarrotura AS mostrarrotura27, p2_.precio AS precio28, p3_.precio AS precio29, p0_.tipo AS tipo30, p0_.subcategoria_id AS subcategoria_id31, p0_.tipoIVA_id AS tipoIVA_id32, p1_.contrato_id AS contrato_id33 FROM Product p0_ LEFT JOIN productalquiler p1_ ON p0_.id = p1_.id LEFT JOIN productconsumible p2_ ON p0_.id = p2_.id LEFT JOIN productsegundamano p3_ ON p0_.id = p3_.id WHERE p0_.mostrarPrincipal = 1 AND p0_.activo = 1 ORDER BY p0_.fechaAlta DESC LIMIT 8
Parameters: []
4 0.74 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]
5 0.34 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]
6 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 => 3]
7 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 => 4]
8 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 => 5]
9 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]
10 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 => 7]
11 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 => 8]
12 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 => 9]
13 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 => 10]
14 0.33 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 763]
15 0.26 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 762]
16 0.25 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 754]
17 0.25 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 747]
18 0.27 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 716]
19 0.28 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 705]
20 0.24 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 693]
21 0.25 ms
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = ?
Parameters: [0 => 684]

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\varsBundle\Entity\Empresa No errors.
Maenar\productsBundle\Entity\Product
  • The field Maenar\productsBundle\Entity\Product#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Images#product does not contain the required 'inversedBy=images' attribute.
  • The field Maenar\productsBundle\Entity\Product#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\video#product does not contain the required 'inversedBy=videos' attribute.
  • The field Maenar\productsBundle\Entity\Product#pdfs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\pdfs#product does not contain the required 'inversedBy=pdfs' attribute.
  • The field Maenar\productsBundle\Entity\Product#tags is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Tag#product does not contain the required 'inversedBy=tags' attribute.
Maenar\productsBundle\Entity\productalquiler
  • The field Maenar\productsBundle\Entity\productalquiler#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Images#product does not contain the required 'inversedBy=images' attribute.
  • The field Maenar\productsBundle\Entity\productalquiler#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\video#product does not contain the required 'inversedBy=videos' attribute.
  • The field Maenar\productsBundle\Entity\productalquiler#pdfs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\pdfs#product does not contain the required 'inversedBy=pdfs' attribute.
  • The field Maenar\productsBundle\Entity\productalquiler#tags is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Tag#product does not contain the required 'inversedBy=tags' attribute.
  • The field Maenar\productsBundle\Entity\productalquiler#roturas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\rotura#productalquiler does not contain the required 'inversedBy=roturas' attribute.
  • The field Maenar\productsBundle\Entity\productalquiler#alquilercategoriadistribuidores is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\alquilercategoriadistribuidor#productalquiler does not contain the required 'inversedBy=alquilercategoriadistribuidores' attribute.
Maenar\productsBundle\Entity\productconsumible
  • The field Maenar\productsBundle\Entity\productconsumible#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Images#product does not contain the required 'inversedBy=images' attribute.
  • The field Maenar\productsBundle\Entity\productconsumible#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\video#product does not contain the required 'inversedBy=videos' attribute.
  • The field Maenar\productsBundle\Entity\productconsumible#pdfs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\pdfs#product does not contain the required 'inversedBy=pdfs' attribute.
  • The field Maenar\productsBundle\Entity\productconsumible#tags is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Tag#product does not contain the required 'inversedBy=tags' attribute.
Maenar\productsBundle\Entity\productsegundamano
  • The field Maenar\productsBundle\Entity\productsegundamano#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Images#product does not contain the required 'inversedBy=images' attribute.
  • The field Maenar\productsBundle\Entity\productsegundamano#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\video#product does not contain the required 'inversedBy=videos' attribute.
  • The field Maenar\productsBundle\Entity\productsegundamano#pdfs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\pdfs#product does not contain the required 'inversedBy=pdfs' attribute.
  • The field Maenar\productsBundle\Entity\productsegundamano#tags is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Tag#product does not contain the required 'inversedBy=tags' attribute.
Maenar\productsBundle\Entity\Images No errors.
Maenar\productsBundle\Entity\video No errors.
Maenar\productsBundle\Entity\pdfs No errors.
Maenar\productsBundle\Entity\Tag No errors.
Maenar\productsBundle\Entity\TipoIVA No errors.
Maenar\productsBundle\Entity\rotura No errors.
Maenar\productsBundle\Entity\alquilercategoriadistribuidor No errors.
Maenar\productsBundle\Entity\contrato
  • The field Maenar\productsBundle\Entity\contrato#productos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\productalquiler#contrato does not contain the required 'inversedBy=productos' attribute.