https://192.168.7.15:8081/jardin/

Query Metrics

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

Grouped Statements

Show all queries

maenar connection

Time Count Info
10.56 ms
(58.69%)
47
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]
3.57 ms
(19.83%)
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]
1.82 ms
(10.13%)
1
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: []
1.12 ms
(6.23%)
1
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: []
0.51 ms
(2.85%)
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: []
0.41 ms
(2.27%)
1
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: []

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.