Query Metrics
19
Database Queries
11
Different statements
58.28 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.99 ms |
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"
]
|
| 2 | 1.10 ms |
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
]
|
| 3 | 0.76 ms |
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_ WHERE m0_.id IN (?)
Parameters:
[
"1"
]
|
| 4 | 0.86 ms |
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_ WHERE c0_.id IN (?)
Parameters:
[
"1"
]
|
| 5 | 3.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 7.32 ms |
INSERT INTO movimiento (fecha, tipo, detalle, fecha_pago, detalle_pago, monto, numero, monto_neto, iva, cancelar_numero, cancelar_fecha, create_at, update_at, contacto_id, categoria_id, caja_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10" -1 "Septiembre 2025" "0025-09-07" "abonado por Cecilia- pagi facil" 16620.28 null null null null null "2025-09-10 15:25:02" "2025-09-10 15:25:02" null 1 1 4 4 ] |
| 7 | 1.40 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-09-10 15:25:02" "2025-09-10 15:25:02" 604 4 4 ] |
| 8 | 2.86 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-09-10 15:25:02" "2025-09-10 15:25:02" 604 4 4 ] |
| 9 | 3.29 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-09-10 15:25:02" "2025-09-10 15:25:02" 604 4 4 ] |
| 10 | 2.35 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Salud Publica - Septiembre 2025.pdf" "Salud-Publica-Septiembre-2025-68c1984e217284.75331861.pdf" "2025-09-10 15:25:02" "2025-09-10 15:25:02" 604 4 4 ] |
| 11 | 5.20 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Nuevo: {"\u0000*\u0000createAt":"10.09.2025 15:25:02","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","id":604,"fecha":"10.09.2025 00:00:00","tipo":-1,"contacto":null,"detalle":"Septiembre 2025","fechaPago":"07.09.0025 00:00:00","detallePago":"abonado por Cecilia- pagi facil","categoria":"ID=1","monto":16620.28,"archivos":[2415,2416,2417,2418],"caja":"ID=1","iva":null,"cancelarNumero":null,"cancelarFecha":null}" "Movimiento" 604 4 ] |
| 12 | 1.71 ms |
UPDATE caja SET saldo = ?, update_at = ? WHERE id = ?
Parameters:
[ -1542236.95 "2025-09-10 15:25:02" 1 ] |
| 13 | 2.85 ms |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.tipo AS tipo_3, t0.detalle AS detalle_4, t0.fecha_pago AS fecha_pago_5, t0.detalle_pago AS detalle_pago_6, t0.monto AS monto_7, t0.numero AS numero_8, t0.monto_neto AS monto_neto_9, t0.iva AS iva_10, t0.cancelar_numero AS cancelar_numero_11, t0.cancelar_fecha AS cancelar_fecha_12, t0.create_at AS create_at_13, t0.update_at AS update_at_14, t0.contacto_id AS contacto_id_15, t0.categoria_id AS categoria_id_16, t0.caja_id AS caja_id_17, t0.create_by_id AS create_by_id_18, t0.update_by_id AS update_by_id_19 FROM movimiento t0 WHERE t0.caja_id = ?
Parameters:
[
1
]
|
| 14 | 2.68 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Modifico: {"\u0000*\u0000createAt":"15.02.2024 17:08:07","\u0000*\u0000createBy":"ID=1","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","id":1,"nombre":"caja de efectivo","color":"#ff1414","saldo":-1542236.95,"movimientos":[1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,19,22,23,24,25,26,42,58,59,60,61,62,79,80,81,82,83,104,117,130,131,132,133,140,165,205,227,267,271,310,335,365,366,374,434,446,477,484,511,604]}" "Caja" 1 4 ] |
| 15 | 2.05 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Nuevo: {"\u0000*\u0000createAt":"10.09.2025 15:25:02","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2415,"movimiento":"ID=604"}" "MovimientoArchivo" 2415 4 ] |
| 16 | 2.33 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Nuevo: {"\u0000*\u0000createAt":"10.09.2025 15:25:02","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2416,"movimiento":"ID=604"}" "MovimientoArchivo" 2416 4 ] |
| 17 | 5.99 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Nuevo: {"\u0000*\u0000createAt":"10.09.2025 15:25:02","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2417,"movimiento":"ID=604"}" "MovimientoArchivo" 2417 4 ] |
| 18 | 2.97 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-09-10 15:25:02" "Nuevo: {"\u0000*\u0000createAt":"10.09.2025 15:25:02","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"10.09.2025 15:25:02","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":"Salud Publica - Septiembre 2025.pdf","\u0000*\u0000archivo":"Salud-Publica-Septiembre-2025-68c1984e217284.75331861.pdf","id":2418,"movimiento":"ID=604"}" "MovimientoArchivo" 2418 4 ] |
| 19 | 8.39 ms |
"COMMIT"
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.
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\Movimiento | No errors. |
| App\Entity\MovimientoCategoria | No errors. |
| App\Entity\Caja | No errors. |
| App\Entity\MovimientoArchivo | No errors. |
| App\Entity\Contacto | No errors. |
| App\Entity\Testigo | No errors. |