Query Metrics
35
Database Queries
6
Different statements
14.91 ms
Query time
5
Invalid entities
Grouped Statements
maenar connection
Time▼ | Count | Info |
---|---|---|
6.50 ms (43.62%) |
21 |
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 => 129]
|
4.29 ms (28.75%) |
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.91 ms (12.79%) |
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 = 5)
Parameters: []
|
1.23 ms (8.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 = 5)
Parameters: []
|
0.52 ms (3.52%) |
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 = 'electricidadysoldadura'
Parameters: []
|
0.46 ms (3.09%) |
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: []
|
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\productsBundle\Entity\Product |
|
Maenar\productsBundle\Entity\productalquiler |
|
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 |
|
Maenar\productsBundle\Entity\contrato |
|