Query Metrics
18
Database Queries
8
Different statements
8.39 ms
Query time
7
Invalid entities
Grouped Statements
maenar connection
Time▼ | Count | Info |
---|---|---|
3.80 ms (45.32%) |
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.33 ms (15.87%) |
1 |
SELECT t0.id AS id4, t0.nombre AS nombre5, t0.nombreURL AS nombreURL6, t0.fechaAlta AS fechaAlta7, t0.codigo AS codigo8, t0.pathqr AS pathqr9, t0.descripcion AS descripcion10, t0.especificaciones AS especificaciones11, t0.eliminado AS eliminado12, t0.stockTotal AS stockTotal13, t0.stockReal AS stockReal14, t0.mostrarPrincipal AS mostrarPrincipal15, t0.title AS title16, t0.metadescription AS metadescription17, t0.activo AS activo18, t0.md5qr AS md5qr19, t0.subcategoria_id AS subcategoria_id20, t0.tipoIVA_id AS tipoIVA_id21, t0.tipo, t1.precioDia AS precioDia22, t1.fianza AS fianza23, t1.descuento37 AS descuento3724, t1.descuento830 AS descuento83025, t1.descuento31 AS descuento3126, t1.desgaste AS desgaste27, t1.tipoDesgaste AS tipoDesgaste28, t1.precioDesgaste AS precioDesgaste29, t1.precioSuciedad AS precioSuciedad30, t1.precioRecargo AS precioRecargo31, t1.suplementoTorre AS suplementoTorre32, t1.mostrarrotura AS mostrarrotura33, t1.contrato_id AS contrato_id34, t2.precio AS precio35, t3.precio AS precio36 FROM Product t0 LEFT JOIN productalquiler t1 ON t0.id = t1.id LEFT JOIN productconsumible t2 ON t0.id = t2.id LEFT JOIN productsegundamano t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters: [0 => 258]
|
1.10 ms (13.11%) |
1 |
SELECT t1.id AS id2, t1.nombre AS nombre3, t1.nombreURL AS nombreURL4, t1.fechaAlta AS fechaAlta5, t1.codigo AS codigo6, t1.pathqr AS pathqr7, t1.descripcion AS descripcion8, t1.especificaciones AS especificaciones9, t1.eliminado AS eliminado10, t1.stockTotal AS stockTotal11, t1.stockReal AS stockReal12, t1.mostrarPrincipal AS mostrarPrincipal13, t1.title AS title14, t1.metadescription AS metadescription15, t1.activo AS activo16, t1.md5qr AS md5qr17, t0.precioDia AS precioDia18, t0.fianza AS fianza19, t0.descuento37 AS descuento3720, t0.descuento830 AS descuento83021, t0.descuento31 AS descuento3122, t0.desgaste AS desgaste23, t0.tipoDesgaste AS tipoDesgaste24, t0.precioDesgaste AS precioDesgaste25, t0.precioSuciedad AS precioSuciedad26, t0.precioRecargo AS precioRecargo27, t0.suplementoTorre AS suplementoTorre28, t0.mostrarrotura AS mostrarrotura29, t1.subcategoria_id AS subcategoria_id30, t1.tipoIVA_id AS tipoIVA_id31, t0.contrato_id AS contrato_id32, t1.tipo FROM productalquiler t0 INNER JOIN Product t1 ON t0.id = t1.id INNER JOIN alquilertoalquiler ON t0.id = alquilertoalquiler.relation_product_id WHERE alquilertoalquiler.product_id = ? ORDER BY t1.nombre ASC
Parameters: [0 => 258]
|
0.67 ms (7.98%) |
2 |
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]
|
0.55 ms (6.58%) |
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.33 ms (3.95%) |
1 |
SELECT t0.id AS id1, t0.diasminimos AS diasminimos2, t0.productalquiler_id AS productalquiler_id3, t0.categoriadistribuidor_id AS categoriadistribuidor_id4 FROM alquilercategoriadistribuidor t0 WHERE t0.productalquiler_id = ?
Parameters: [0 => 258]
|
0.31 ms (3.73%) |
1 |
SELECT t0.id AS id1, t0.url AS url2, t0.titulo AS titulo3, t0.ispublic AS ispublic4, t0.product_id AS product_id5 FROM video t0 WHERE t0.product_id = ?
Parameters: [0 => 258]
|
0.29 ms (3.46%) |
1 |
SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.ispublic AS ispublic4, t0.product_id AS product_id5 FROM pdfs t0 WHERE t0.product_id = ?
Parameters: [0 => 258]
|
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\productconsumible |
|
Maenar\productsBundle\Entity\productsegundamano |
|
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 |
|
Maenar\coreBundle\Entity\CategoryDistributor |
|