Query Metrics
14
Database Queries
7
Different statements
616.20 ms
Query time
4
Invalid entities
18
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 19.02 ms |
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.nombre AS nombre_4, t0.apellidos AS apellidos_5, t0.password AS password_6, t0.razon AS razon_7, t0.doi AS doi_8, t0.movil AS movil_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.activo AS activo_11, t0.reset_password AS reset_password_12, t0.reset_validez AS reset_validez_13, t0.locale AS locale_14, t0.sesion_id AS sesion_id_15, t0.intentos_login AS intentos_login_16, t0.ultimo_login AS ultimo_login_17, t0.instalador_id AS instalador_id_18, t0.rol AS rol_19, t0.notificar AS notificar_20, t0.paquete_id AS paquete_id_21 FROM usuarios t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 73.65 ms |
SELECT t0.id AS id_1, t0.fecha_caducidad AS fecha_caducidad_2, t0.sesion_id AS sesion_id_3, t0.estado AS estado_4, t0.multiplicador AS multiplicador_5, t0.bruto AS bruto_6, t0.descuento AS descuento_7, t0.usuario_id AS usuario_id_8, t0.modulo_id AS modulo_id_9 FROM usuariosmodulos t0 WHERE t0.usuario_id = ?
Parameters:
[
1
]
|
| 3 | 4.17 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 67.81 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 5 | 11.98 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 6 | 1.42 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 7 | 1.58 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 8 | 2.23 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 9 | 25.31 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 10 | 3.13 ms |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 11 | 147.25 ms |
SELECT DISTINCT mo.codigo FROM escenaspropietarios ep JOIN escenas e ON e.id = ep.escena_id JOIN usuariosmodulos um ON um.usuario_id = e.usuario_id JOIN modulos mo ON mo.id = um.modulo_id WHERE ep.copropietario_id = ? AND ep.estado = 1 AND um.estado = 2
Parameters:
[
1
]
|
| 12 | 15.84 ms |
SELECT t0.id AS id_1, t0.paquete AS paquete_2, t0.visible AS visible_3, t0.activo AS activo_4, t0.precio AS precio_5, t0.duracion AS duracion_6 FROM paquetes t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 13 | 163.01 ms |
call proc_invitacioneshuespedes_wizars (1)
Parameters:
[] |
| 14 | 79.83 ms |
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.hash_notificacion AS hash_notificacion_3, t0.titulo AS titulo_4, t0.contenido AS contenido_5, t0.datos_reemplazo AS datos_reemplazo_6, t0.boton_texto AS boton_texto_7, t0.boton_url AS boton_url_8, t0.icono AS icono_9, t0.icono_class AS icono_class_10, t0.fecha_alta AS fecha_alta_11, t0.omitido AS omitido_12, t0.activo AS activo_13, t0.fecha_omitido AS fecha_omitido_14, t0.usuario_id AS usuario_id_15 FROM notificaciones t0 WHERE t0.usuario_id = ? AND t0.omitido = ? AND t0.activo = ?
Parameters:
[ 1 0 1 ] |
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\UsuarioModulo | 8 |
| App\Entity\Modulo | 8 |
| App\Entity\Usuario | 1 |
| App\Entity\Paquete | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Usuario |
|
| App\Entity\Paquete | No errors. |
| App\Entity\UsuarioModulo | No errors. |
| App\Entity\Modulo |
|
| App\Entity\InvitacionHuesped | No errors. |
| App\Entity\Invitacion |
|
| App\Entity\Escena |
|
| App\Entity\FicheroEnvio | No errors. |
| App\Entity\Notificacion | No errors. |