Query Metrics
5
Database Queries
4
Different statements
1.34 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.46 ms (34.59%) |
2 |
SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, m1_.CODMODIFICADOR AS CODMODIFICADOR_2, m1_.POSICION AS POSICION_3, m1_.INCPRECIO AS INCPRECIO_4, p2_.PNETO AS PNETO_5, i3_.IVA AS IVA_6, i3_.TIPOIVA AS TIPOIVA_7 FROM articulos a0_ INNER JOIN modificadoreslin m1_ ON (m1_.CODARTICULOCOM = a0_.CODARTICULO) INNER JOIN preciosventa p2_ ON (a0_.CODARTICULO = p2_.CODARTICULO) INNER JOIN impuestos i3_ ON (a0_.TIPOIMPUESTO = i3_.TIPOIVA) WHERE m1_.CODMODIFICADOR = ? AND p2_.IDTARIFAV = 1 ORDER BY m1_.POSICION ASC
Parameters:
[
111
]
|
0.33 ms (24.55%) |
1 |
SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, p1_.PNETO AS PNETO_2, i2_.IVA AS IVA_3, i2_.TIPOIVA AS TIPOIVA_4, f3_.CODFAVORITO AS CODFAVORITO_5 FROM articulos a0_ INNER JOIN preciosventa p1_ ON (a0_.CODARTICULO = p1_.CODARTICULO) INNER JOIN impuestos i2_ ON (a0_.TIPOIMPUESTO = i2_.TIPOIVA) INNER JOIN favoritoslin f3_ ON (a0_.CODARTICULO = f3_.CODARTICULO) WHERE a0_.CODARTICULO = ? AND p1_.IDTARIFAV = 1 AND f3_.CODFAVORITO = ?
Parameters:
[ 318 205 ] |
0.32 ms (23.97%) |
1 |
SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, m1_.MULTISELEC AS MULTISELEC_2, m1_.POSICION AS POSICION_3, m1_.LIMITE AS LIMITE_4, m1_.MINIMO AS MINIMO_5, m1_.AUTO AS AUTO_6, m2_.CODMODIFICADOR AS CODMODIFICADOR_7, m2_.DESCRIPCION AS DESCRIPCION_8 FROM articulos a0_ INNER JOIN modificadoresarticulos m1_ ON (a0_.CODARTICULO = m1_.CODARTICULO) INNER JOIN modificadorescab m2_ ON (m1_.CODMODIFICADOR = m2_.CODMODIFICADOR) WHERE a0_.CODARTICULO = ? ORDER BY m1_.POSICION ASC
Parameters:
[
318
]
|
0.23 ms (16.89%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
19
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Cabecera | No errors. |
App\Entity\Domicilios | No errors. |
App\Entity\Articulos | No errors. |
App\Entity\Preciosventa | No errors. |
App\Entity\Impuestos | No errors. |
App\Entity\Favoritoslin | No errors. |
App\Entity\Modificadoresarticulos | No errors. |
App\Entity\Modificadorescab | No errors. |
App\Entity\Modificadoreslin | No errors. |