https://test.paomdisyart.com/productos/categoria/3

Query Metrics

4 Database Queries
4 Different statements
2.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.94 ms
(41.40%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.descripcion_completa AS descripcion_completa_5, t0.destacado AS destacado_6, t0.activo AS activo_7, t0.codigo AS codigo_8, t0.stock AS stock_9, t0.precio_usd AS precio_usd_10, t0.portada_id AS portada_id_11 FROM producto t0 INNER JOIN producto_categoria ON t0.id = producto_categoria.producto_id WHERE producto_categoria.categoria_id = ?
Parameters:
[
  3
]
0.51 ms
(22.46%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.precio AS precio_3, p0_.descripcion_completa AS descripcion_completa_4, p0_.destacado AS destacado_5, p0_.activo AS activo_6, p0_.codigo AS codigo_7, p0_.stock AS stock_8, p0_.precio_usd AS precio_usd_9, p0_.portada_id AS portada_id_10 FROM producto p0_ WHERE p0_.activo = 1 ORDER BY p0_.id DESC
Parameters:
[]
0.46 ms
(20.35%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.36 ms
(15.79%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.flagproducto AS flagproducto_4, t0.activo AS activo_5, t0.imagen_id AS imagen_id_6 FROM categoria t0 ORDER BY t0.nombre ASC
Parameters:
[]

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\Producto No errors.
App\Entity\Categoria No errors.
App\Entity\Parametro No errors.
App\Entity\Imagen No errors.
App\Entity\Curso No errors.
App\Entity\ProductosCarrito No errors.