Query Metrics
19
Database Queries
11
Different statements
16.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.70 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.04 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 | 1.30 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:
[
"6"
]
|
| 4 | 0.52 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:
[
"2"
]
|
| 5 | 0.33 ms |
"START TRANSACTION"
Parameters:
[] |
| 6 | 2.03 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-07-22" -1 "Julio 2025" "0025-07-09" "Abonada por el Dr. Allan" 7073.05 null null null null null "2025-07-22 18:08:26" "2025-07-22 18:08:26" null 6 2 4 4 ] |
| 7 | 1.15 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-07-22 18:08:26" "2025-07-22 18:08:26" 518 4 4 ] |
| 8 | 0.22 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-07-22 18:08:26" "2025-07-22 18:08:26" 518 4 4 ] |
| 9 | 0.18 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null null "2025-07-22 18:08:26" "2025-07-22 18:08:26" 518 4 4 ] |
| 10 | 0.28 ms |
INSERT INTO movimiento_archivo (nombre, archivo, create_at, update_at, movimiento_id, create_by_id, update_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Padron 580371 - Julio 2025.pdf" "Padron-580371-Julio-2025-687fd39a0f6ad9.41896060.pdf" "2025-07-22 18:08:26" "2025-07-22 18:08:26" 518 4 4 ] |
| 11 | 0.85 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Nuevo: {"\u0000*\u0000createAt":"22.07.2025 18:08:26","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","id":518,"fecha":"22.07.2025 00:00:00","tipo":-1,"contacto":null,"detalle":"Julio 2025","fechaPago":"09.07.0025 00:00:00","detallePago":"Abonada por el Dr. Allan","categoria":"ID=6","monto":7073.05,"archivos":[2068,2069,2070,2071],"caja":"ID=2","iva":null,"cancelarNumero":null,"cancelarFecha":null}" "Movimiento" 518 4 ] |
| 12 | 0.90 ms |
UPDATE caja SET saldo = ?, update_at = ? WHERE id = ?
Parameters:
[ -16823016.539 "2025-07-22 18:08:26" 2 ] |
| 13 | 1.79 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:
[
2
]
|
| 14 | 0.71 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Modifico: {"\u0000*\u0000createAt":"15.02.2024 17:11:22","\u0000*\u0000createBy":"ID=1","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","id":2,"nombre":"tranferencia","color":"#292929","saldo":-16823016.539,"movimientos":[17,18,20,21,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,105,106,107,108,109,110,111,112,113,114,115,116,118,119,120,121,122,123,124,125,126,127,128,129,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,158,159,160,162,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,186,187,196,204,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,228,242,243,244,249,250,251,252,253,254,255,256,257,258,259,260,261,263,264,265,272,273,292,293,297,298,299,300,301,302,303,304,305,306,307,308,309,314,315,331,336,337,338,339,340,341,342,343,344,345,346,347,348,352,355,356,375,377,380,381,382,383,384,385,386,387,388,389,390,391,392,393,395,399,400,406,407,408,409,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,438,444,448,449,460,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,478,482,483,496,505,512,513,514,515,516,517,518]}" "Caja" 2 4 ] |
| 15 | 0.68 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Nuevo: {"\u0000*\u0000createAt":"22.07.2025 18:08:26","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2068,"movimiento":"ID=518"}" "MovimientoArchivo" 2068 4 ] |
| 16 | 0.60 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Nuevo: {"\u0000*\u0000createAt":"22.07.2025 18:08:26","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2069,"movimiento":"ID=518"}" "MovimientoArchivo" 2069 4 ] |
| 17 | 0.65 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Nuevo: {"\u0000*\u0000createAt":"22.07.2025 18:08:26","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":null,"\u0000*\u0000archivo":null,"id":2070,"movimiento":"ID=518"}" "MovimientoArchivo" 2070 4 ] |
| 18 | 0.58 ms |
INSERT INTO testigo (createdAt, detalle, objeto, obejto_id, usuario_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-07-22 18:08:26" "Nuevo: {"\u0000*\u0000createAt":"22.07.2025 18:08:26","\u0000*\u0000createBy":"ID=4","\u0000*\u0000updateAt":"22.07.2025 18:08:26","\u0000*\u0000updateBy":"ID=4","\u0000*\u0000nombre":"Padron 580371 - Julio 2025.pdf","\u0000*\u0000archivo":"Padron-580371-Julio-2025-687fd39a0f6ad9.41896060.pdf","id":2071,"movimiento":"ID=518"}" "MovimientoArchivo" 2071 4 ] |
| 19 | 0.93 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. |