https://192.168.7.15:8081/jardin/

Query Metrics

61 Database Queries
6 Different statements
18.00 ms Query time
5 Invalid entities

Queries

Group similar statements

maenar connection

# Time Info
1 0.51 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.41 ms
SELECT c0_.id AS id0, c0_.name AS name1, c0_.nameURL AS nameURL2, c0_.codigo AS codigo3, c0_.title AS title4, c0_.metadescription AS metadescription5 FROM Category c0_ WHERE c0_.nameURL = 'jardin'
Parameters: []
3 1.82 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, p0_.tipo AS tipo28, p0_.subcategoria_id AS subcategoria_id29, p0_.tipoIVA_id AS tipoIVA_id30, p1_.contrato_id AS contrato_id31 FROM productalquiler p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id INNER JOIN Subcategory s2_ ON (p0_.activo = 1 AND s2_.id = p0_.subcategoria_id AND s2_.category_id = 8)
Parameters: []
4 1.12 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_.precio AS precio16, p0_.tipo AS tipo17, p0_.subcategoria_id AS subcategoria_id18, p0_.tipoIVA_id AS tipoIVA_id19 FROM productconsumible p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id INNER JOIN Subcategory s2_ ON (p0_.activo = 1 AND s2_.id = p0_.subcategoria_id AND s2_.category_id = 8)
Parameters: []
5 0.90 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]
6 0.33 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]
7 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 => 3]
8 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]
9 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]
10 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 => 6]
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 => 7]
12 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]
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 => 9]
14 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]
15 0.30 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 => 160]
16 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 => 161]
17 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 => 163]
18 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 => 165]
19 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 => 242]
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 => 252]
21 0.29 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 => 253]
22 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 => 558]
23 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 => 657]
24 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 => 658]
25 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 => 659]
26 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 => 720]
27 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 => 166]
28 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 => 176]
29 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 => 177]
30 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 => 178]
31 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 => 469]
32 0.35 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 => 576]
33 0.35 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 => 641]
34 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 => 660]
35 0.29 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 => 661]
36 0.23 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 => 662]
37 0.20 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 => 663]
38 0.19 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 => 664]
39 0.19 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 => 708]
40 0.20 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 => 167]
41 0.20 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 => 168]
42 0.19 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 => 169]
43 0.19 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 => 171]
44 0.19 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 => 172]
45 0.19 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 => 258]
46 0.21 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 => 346]
47 0.21 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 => 368]
48 0.19 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 => 523]
49 0.19 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 => 656]
50 0.19 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 => 173]
51 0.20 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 => 280]
52 0.22 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 => 182]
53 0.19 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 => 183]
54 0.19 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 => 224]
55 0.19 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 => 363]
56 0.22 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 => 446]
57 0.15 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 => 612]
58 0.14 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 => 643]
59 0.18 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 => 270]
60 0.15 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 => 350]
61 0.15 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 => 269]

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\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\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\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\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.