Query Metrics
12
Database Queries
6
Different statements
3.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.37 ms |
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:
[
"5"
]
|
| 2 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.descripcion AS descripcion_2, c0_.flagproducto AS flagproducto_3, c0_.activo AS activo_4, c0_.imagen_id AS imagen_id_5 FROM categoria c0_ WHERE c0_.flagproducto = 0 AND c0_.activo = 1 ORDER BY c0_.nombre ASC
Parameters:
[] |
| 3 | 0.46 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.activo AS activo_5, t0.destacado AS destacado_6, t0.informacion_adicional AS informacion_adicional_7, t0.flag_publico AS flag_publico_8, t0.precio_usd AS precio_usd_9 FROM curso t0 INNER JOIN curso_categoria ON t0.id = curso_categoria.curso_id WHERE curso_categoria.categoria_id = ?
Parameters:
[
5
]
|
| 4 | 0.34 ms |
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.curso_id = ?
Parameters:
[
34
]
|
| 5 | 0.35 ms |
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 curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
34
]
|
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
34
]
|
| 7 | 0.26 ms |
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.curso_id = ?
Parameters:
[
39
]
|
| 8 | 0.31 ms |
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 curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
39
]
|
| 9 | 0.24 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
39
]
|
| 10 | 0.26 ms |
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.curso_id = ?
Parameters:
[
40
]
|
| 11 | 0.30 ms |
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 curso_categoria ON t0.id = curso_categoria.categoria_id WHERE curso_categoria.curso_id = ?
Parameters:
[
40
]
|
| 12 | 0.23 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.curso_id AS curso_id_5, t0.video_id AS video_id_6 FROM clase t0 WHERE t0.curso_id = ?
Parameters:
[
40
]
|
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\Curso | No errors. |
| App\Entity\Archivo | No errors. |
| App\Entity\Imagen | No errors. |
| App\Entity\Categoria | No errors. |
| App\Entity\Parametro | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Venta | No errors. |
| App\Entity\Estadoventa | No errors. |
| App\Entity\TipoVenta | No errors. |
| App\Entity\Producto | No errors. |
| App\Entity\Clase | No errors. |
| App\Entity\Publicacion | No errors. |
| App\Entity\Album | No errors. |
| App\Entity\Video | No errors. |