Query Metrics
3
Database Queries
3
Different statements
14.47 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.53 ms (38.26%) |
1 |
SELECT cv.id, cv.nombre, cv.precio, cv.imagen, cv.duracion_clases, cv.dias_semana, cv.duracion_cada_clase, cv.en_transmision, p.nombre AS profesor FROM clases_en_vivo cv LEFT JOIN profesores p ON p.id = cv.profesor WHERE cv.estado = "Activo" ORDER BY cv.en_transmision DESC, cv.nombre ASC
Parameters:
[] |
|
4.61 ms (31.88%) |
1 |
SELECT id, nombre FROM categorias
Parameters:
[] |
|
4.32 ms (29.86%) |
1 |
SELECT c.id, c.nombre, c.descripcion_corta, c.precio, c.precio_oferta, c.imagen_portada, c.estado, c.calificacion, c.categoria, cat.nombre AS categoria_nombre, p.nombre AS profesor FROM cursos c LEFT JOIN categorias cat ON c.categoria = cat.id LEFT JOIN profesores p ON c.profesor = p.id WHERE c.estado = "Activo" ORDER BY c.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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.