https://callcenter.calcoweb.net/articulo?codarticulo=318&fav=205

Query Metrics

5 Database Queries
4 Different statements
1.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 ms
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
]
2 0.33 ms
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
]
3 0.32 ms
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
]
4 0.25 ms
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
]
5 0.21 ms
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:
[
  112
]

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