Query Metrics
4
Database Queries
4
Different statements
1.77 ms
Query time
0
Invalid entities
151
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.81 ms (46.03%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.especialidad AS especialidad_3, t0.categoria AS categoria_4, t0.imagen AS imagen_5, t0.orden AS orden_6, t0.activo AS activo_7 FROM contenido_carpeta t0 ORDER BY t0.especialidad ASC, t0.nombre ASC
Parameters:
[] |
|
0.51 ms (28.57%) |
1 |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.descripcion AS descripcion_3, t0.tipo AS tipo_4, t0.url AS url_5, t0.url_video AS url_video_6, t0.imagen AS imagen_7, t0.especialidad AS especialidad_8, t0.categoria AS categoria_9, t0.orden AS orden_10, t0.activo AS activo_11, t0.creado_en AS creado_en_12, t0.carpeta_id AS carpeta_id_13 FROM contenido_publicacion t0 WHERE t0.id = ?
Parameters:
[
"31"
]
|
|
0.25 ms (14.20%) |
1 |
SELECT t0.id AS id_4, t0.nombre AS nombre_5, t0.apellidos AS apellidos_6, t0.password AS password_7, t0.salt AS salt_8, t0.activo AS activo_9, t0.role AS role_10, t0.email AS email_11, t0.sessionid AS sessionid_12, t0.fechainicio AS fechainicio_13, t0.accesocorrecto AS accesocorrecto_14, t0.password_reset_token AS password_reset_token_15, t0.password_reset_requested_at AS password_reset_requested_at_16, t0.tipo, t2.claseVirtual AS claseVirtual_17, t2.verLibros AS verLibros_18, t2.email_zoom AS email_zoom_19, t2.dni AS dni_20, t2.md5 AS md5_21, t2.deleted AS deleted_22, t2.anio_curso AS anio_curso_23, t2.fecha_baja AS fecha_baja_24, t2.motivo_baja AS motivo_baja_25, t2.modalidad_id AS modalidad_id_26, t2.anio_academico_id AS anio_academico_id_27, t3.puedeVerPreguntasSimulacro AS puedeVerPreguntasSimulacro_28, t3.puedeDarClaseVirtual AS puedeDarClaseVirtual_29 FROM usuario t0 LEFT JOIN administrador t1 ON t0.id = t1.id LEFT JOIN alumno t2 ON t0.id = t2.id LEFT JOIN profesor t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
253
]
|
|
0.20 ms (11.20%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM role t0 INNER JOIN role_usuario ON t0.id = role_usuario.role_id WHERE role_usuario.usuario_id = ?
Parameters:
[
253
]
|
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 |
|---|---|
| App\Entity\Contenido\Carpeta | 143 |
| App\Entity\Core\Role | 6 |
| App\Entity\Usuario\Usuario | 1 |
| App\Entity\Contenido\Publicacion | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Usuario\Usuario | No errors. |
| App\Entity\Usuario\Administrador | No errors. |
| App\Entity\Usuario\Alumno | No errors. |
| App\Entity\Usuario\Profesor | No errors. |
| App\Entity\Test\Modalidad | No errors. |
| App\Entity\Academico\AƱoAcademico | No errors. |
| App\Entity\Core\Role | No errors. |
| App\Entity\Contenido\Publicacion | No errors. |
| App\Entity\Contenido\Carpeta | No errors. |