Query Metrics
27
Database Queries
4
Different statements
5.98 ms
Query time
10
Invalid entities
Grouped Statements
maenar connection
Time▼ | Count | Info |
---|---|---|
4.00 ms (66.93%) |
24 |
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 => 302]
|
0.98 ms (16.32%) |
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 alquilertoconsumible a3_ ON p1_.id = a3_.productconsumible_id INNER JOIN productalquiler p2_ ON p2_.id = a3_.productalquiler_id LEFT JOIN Product p4_ ON p2_.id = p4_.id WHERE p4_.id = 138 AND p4_.activo = 1 GROUP BY p0_.id ORDER BY p0_.nombre ASC
Parameters: []
|
0.81 ms (13.54%) |
1 |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Parameters: [0 => 2]
|
0.19 ms (3.22%) |
1 |
SELECT t0.id AS id1, t0.tipoIva AS tipoIva2, t0.valor AS valor3, t0.recargo AS recargo4, t0.eliminado AS eliminado5 FROM TipoIVA t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
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\coreBundle\Entity\User |
|
Maenar\coreBundle\Entity\Distributor |
|
Maenar\coreBundle\Entity\admin |
|
Maenar\coreBundle\Entity\UserWeb |
|
Maenar\coreBundle\Entity\little |
|
Maenar\coreBundle\Entity\gestorZonaUser |
|
Maenar\coreBundle\Entity\usuarioautorizado | No errors. |
Maenar\coreBundle\Entity\CategoryDistributor |
|
Maenar\coreBundle\Entity\gestorZona | No errors. |
Maenar\productsBundle\Entity\Product |
|
Maenar\productsBundle\Entity\productconsumible |
|
Maenar\productsBundle\Entity\productalquiler |
|
Maenar\productsBundle\Entity\Subcategory | No errors. |
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. |