Query Metrics
5
Database Queries
5
Different statements
14.76 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.36 ms (49.89%) |
1 |
SELECT m0_.id AS id_0, m0_.fecha AS fecha_1, m0_.tipo AS tipo_2, m0_.detalle AS detalle_3, m0_.fecha_pago AS fecha_pago_4, m0_.detalle_pago AS detalle_pago_5, m0_.monto AS monto_6, m0_.numero AS numero_7, m0_.monto_neto AS monto_neto_8, m0_.iva AS iva_9, m0_.cancelar_numero AS cancelar_numero_10, m0_.cancelar_fecha AS cancelar_fecha_11, m0_.create_at AS create_at_12, m0_.update_at AS update_at_13, m0_.contacto_id AS contacto_id_14, m0_.categoria_id AS categoria_id_15, m0_.caja_id AS caja_id_16, m0_.create_by_id AS create_by_id_17, m0_.update_by_id AS update_by_id_18 FROM movimiento m0_ WHERE m0_.fecha >= ? AND m0_.fecha <= ? AND m0_.tipo = -1 ORDER BY m0_.fecha DESC LIMIT 100
Parameters:
[ "2025-07-01 17:32:46" "2025-07-31 17:32:46" ] |
2.23 ms (15.08%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.create_at AS create_at_2, m0_.update_at AS update_at_3, m0_.create_by_id AS create_by_id_4, m0_.update_by_id AS update_by_id_5 FROM movimiento_categoria m0_
Parameters:
[] |
2.18 ms (14.74%) |
1 |
SELECT t0.id AS id_1, t0.nick AS nick_2, t0.password AS password_3, t0.nombre AS nombre_4, t0.dni AS dni_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.direccion AS direccion_8, t0.telefono AS telefono_9, t0.localidad AS localidad_10, t0.visible AS visible_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.create_by_id AS create_by_id_16, t0.update_by_id AS update_by_id_17 FROM usuario t0 WHERE t0.nick = ? LIMIT 1
Parameters:
[
"Cecilia"
]
|
1.70 ms (11.54%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.color AS color_2, c0_.saldo AS saldo_3, c0_.create_at AS create_at_4, c0_.update_at AS update_at_5, c0_.create_by_id AS create_by_id_6, c0_.update_by_id AS update_by_id_7 FROM caja c0_
Parameters:
[] |
1.29 ms (8.75%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.negro AS negro_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.supervisor_id AS supervisor_id_7, t0.create_by_id AS create_by_id_8, t0.update_by_id AS update_by_id_9 FROM usuario_nivel t0 INNER JOIN usuario_usuario_nivel ON t0.id = usuario_usuario_nivel.usuario_nivel_id WHERE usuario_usuario_nivel.usuario_id = ?
Parameters:
[
4
]
|
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\Base | No errors. |
App\Entity\Usuario | No errors. |
App\Entity\UsuarioNivel | No errors. |
App\Entity\Juicio | No errors. |
App\Entity\Evento | No errors. |
App\Entity\MovimientoCategoria | No errors. |
App\Entity\Caja | No errors. |
App\Entity\Movimiento | No errors. |
App\Entity\Contacto | No errors. |
App\Entity\MovimientoArchivo | No errors. |