Query Metrics
46
Database Queries
6
Different statements
15.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.03 ms (50.51%) |
21 |
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 INNER JOIN producto_categoria ON t0.id = producto_categoria.categoria_id WHERE producto_categoria.producto_id = ?
Parameters:
[
5
]
|
|
6.00 ms (37.72%) |
21 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.url AS url_3, t0.producto_id AS producto_id_4, t0.publicacion_id AS publicacion_id_5, t0.curso_id AS curso_id_6, t0.album_id AS album_id_7 FROM imagen t0 WHERE t0.id = ?
Parameters:
[
165
]
|
|
0.65 ms (4.09%) |
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:
[
7
]
|
|
0.48 ms (3.01%) |
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:
[
"7"
]
|
|
0.40 ms (2.50%) |
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:
[] |
|
0.34 ms (2.16%) |
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:
[] |
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. |
| App\Entity\Publicacion | No errors. |
| App\Entity\Album | No errors. |