Query Metrics
35
Database Queries
6
Different statements
14.91 ms
Query time
5
Invalid entities
Queries
maenar connection
#▲ | Time | Info |
---|---|---|
1 | 0.46 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.52 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 = 'electricidadysoldadura'
Parameters: []
|
3 | 1.91 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 = 5)
Parameters: []
|
4 | 1.23 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 = 5)
Parameters: []
|
5 | 1.05 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.38 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.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 => 3]
|
8 | 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 => 4]
|
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 => 5]
|
10 | 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 => 6]
|
11 | 0.62 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.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 => 8]
|
13 | 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 => 9]
|
14 | 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 => 10]
|
15 | 0.51 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 => 129]
|
16 | 0.37 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 => 130]
|
17 | 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 => 131]
|
18 | 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 => 132]
|
19 | 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 => 239]
|
20 | 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 => 243]
|
21 | 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 => 250]
|
22 | 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 => 360]
|
23 | 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 => 651]
|
24 | 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 => 736]
|
25 | 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 => 759]
|
26 | 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 => 133]
|
27 | 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 => 364]
|
28 | 0.34 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 => 369]
|
29 | 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 => 693]
|
30 | 0.42 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]
|
31 | 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 => 135]
|
32 | 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 => 136]
|
33 | 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 => 137]
|
34 | 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 => 673]
|
35 | 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 => 358]
|
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 |
|