GET https://cuadrodemandos.smartescrow.eu/api/refresh-all

Response
200 OK
IP
93.174.5.104
Profiled on
Token
c39dd4

Query Metrics

7 Database Queries
5 Different statements
36.09 ms Query time
0 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
32.89 ms
(91.13%) 		3 
UPDATE bank_aggregation SET raw_data = ?, last_refresh_date = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  "{"success":true,"payload":{"user_information":{"ID":"03870098A","name":"GREGORIO LOPEZ TRIVI\u00d1O BARRAS","email":"goro.paginadeinicio@gmail.com","cell_phone":"+34676605313","gender":"male","birth_date":"1982-05-29","address":"MADRID ES D 6 28004 MADRID CL CL VICTOR HUGO 1 6 D","city":"MADRID","country":"ES","postal_code":"28004","birth_place":"ES","marital_status":"single","job":"ESTADISTICOS, MATEMATICOS, ANALISTAS INFORMATICOS Y SIMILARES"},"accounts":[{"uuid":"0557ca858c52105fa4cd3e1210e7a97a172d6ae1","code":"ES5601280091170101783605","name":"Cc Estandar Web","subtype":"checking","interest_rate":null,"currency":"EUR","owners":[{"ID":null,"name":"Gregorio Lopez Trivi\u00f1o Barras","role":"owner"},{"ID":null,"name":"GREGORIO LOPEZ TRIVI\u00d1O BARRAS","role":"owner"}],"balances":{"available":209.65,"current":209.65},"transactions":[{"uuid":"4248a0a3b8f14034c7d1e0624420ae0b03acddc0","value_date":"2025-11-04","operation_date":"2025-11-04","amount":1397.28,"balance":12712.710000000001,"description":"Transf Otras booking.com B.v.","categorization":{"type":11},"additional_info":[]},{"uuid":"1193aee2565c183730d8097a17957dd234d80fb2","value_date":"2025-11-04","operation_date":"2025-11-04","amount":-20,"balance":12692.710000000001,"description":"Trans Inm Asociacion Pe\u00f1a Bar","categorization":{"type":0},"additional_info":[]},{"uuid":"61af418f1df687e02c9aa31210c8eb036d635bc8","value_date":"2025-11-04","operation_date":"2025-11-04","amount":-1000,"balance":11692.710000000001,"description":"Trans Inm Marian Diaz Delgado","categorization":{"type":0},"additional_info":[]},{"uuid":"31c74206644e5928f5c0885997d07b0a0a15b457","value_date":"2025-11-05","operation_date":"2025-11-05","amount":-93.19,"balance":11599.52,"description":"Recib cdad.prop.edf.residenci","categorization":{"type":19},"additional_info":[]},{"uuid":"bec93eba3351125ecb43d340a310513e1a47a33f","value_date":"2025-11-08","operation_date":"2025-11-08","amount":-605,"balance":10994.52,"description":"Trans Inm Dicoher Energy S.l","categorization":{"type":0},"additional_info":[]},{"uuid":"d9bf4dddc31fb5af22f56bf8a2362d1546898131","value_date":"2025-11-10","operation_date":"2025-11-10","amount":-1000,"balance":9994.52,"description":"Trans Inm Maria Angustias Dia","categorization":{"type":0},"additional_info":[]},{"uuid":"35a5f977b3854347889daab5b795fdbca53fb3d1","value_date":"2025-11-10","operation_date":"2025-11-10","amount":-986.15,"balance":9008.37,"description":"Transf Otras gc3 Services Sl","categorization":{"type":5},"additional_info":[]},{"uuid":"eb6638b3cb63626f044d7f73c4f989dabab7c533","value_date":"2025-11-10","operation_date":"2025-11-09","amount":-188.76,"balance":8819.61,"description":"Trans Inm Toletum Business, S","categorization":{"type":0},"additional_info":[]},{"uuid":"1e833ea8ec6e523be5d99f148293761879f36400","value_date":"2025-11-11","operation_date":"2025-11-11","amount":-7834.75,"balance":984.8599999999997,"description":"Trans del Arbol Arquitectos S","categorization":{"type":0},"additional_info":[]},{"uuid":"ab46ad0a5f5ca0183872cfd0bc472f16cc6e9550","value_date":"2025-11-12","operation_date":"2025-11-12","amount":-200,"balance":784.8599999999997,"description":"Trans Inm Marian Diaz Delgado","categorization":{"type":0},"additional_info":[]},{"uuid":"3e13004e0cc421a0f44f37f342be50349affb4d7","value_date":"2025-11-17","operation_date":"2025-11-17","amount":1644.4,"balance":2429.2599999999998,"description":"Trans airbnb Payments Luxembo","categorization":{"type":11},"additional_info":[]},{"uuid":"a7f755a9b410004001c76199ccaca8f7158702a1","value_date":"2025-11-19","operation_date":"2025-11-19","amount":-300,"balance":2129.2599999999998,"description":"Trans Inm Marian Diaz Delgado","categorization":{"type":0},"additional_info":[]},{"uuid":"e9c1bc4d130f3315c9cc974120872a6316c4583c","value_date":"2025-11-26","operation_date":"2025-11-26","amount":-39.72,"balance":2089.54,"description":"Recibo endesa Energia S.a.","categorization":{"type":8},"additional_info":[]},{"uuid":"98735152a1ede42e13e2d4b565201ba4d2cedb56","value_date":"2025-11-27","operation_date":"2025-11-27","amount":-84.94,"balance":2004.6,"description":"Recib emanagua Emp Mixta Muni","categorization":{"type":0},"additional_info":[]},{"uuid":"cf00a2bb58b13ca561b4cf964420c43f6348ee8c","value_date":"2025-11-29","operation_date":"2025-12-01","amount":-1815,"balance":189.59999999999985,"description":"Transf Otras egea Calidad Sl","categorization":{"type":5},"additional_info":[]},{"uuid":"49784622e5e3904693de1417baf802eb11a08cf0","value_date":"2025-12-01","operation_date":"2025-12-01","amount":-93.19,"balance":96.40999999999985,"description":"Recib cdad.prop.edf.residenci","categorization":{"type":19},"additional_info":[]},{"uuid":"a4a8e45acf8394b1926ac04fddc66dcdcdd7c2a5","value_date":"2025-12-10","operation_date":"2025-12-10","amount":1479.26,"balance":1575.6699999999998,"description":"Transf Otras booking.com B.v.","categorization":{"type":11},"additional_info":[]},{"uuid":"5ecc1a632fb16b548fb2065dd609231e2b0feebb","value_date":"2025-12-10","operation_date":"2025-12-10","amount":-650,"balance":925.6699999999998,"description":"Trans Inm Gregorio Lopez Triv","categorization":{"type":0},"additional_info":[]},{"uuid":"0ca1f67b21aee640618d2c535ffd90763a0579e2","value_date":"2025-12-11","operation_date":"2025-12-11","amount":-500,"balance":425.66999999999985,"description":"Trans Inm Maria Angustias Dia","categorization":{"type":0},"additional_info":[]},{"uuid":"51dd81a91449a8c37dd9d4abe65c41c56fd7209c","value_date":"2025-12-20","operation_date":"2025-12-20","amount":-90,"balance":335.66999999999985,"description":"Trans Inm Maria Angustias Dia","categorization":{"type":0},"additional_info":[]},{"uuid":"9f50aab463c713e221a9b8da3b739659be75fbf7","value_date":"2025-12-29","operation_date":"2025-12-29","amount":-93.99,"balance":241.67999999999984,"description":"Recibo endesa Energia S.a.","categorization":{"type":8},"additional_info":[]},{"uuid":"0480f793ce0b77ffd615409e6f6b26829a1c13de","value_date":"2025-12-30","operation_date":"2025-12-30","amount":1450.88,"balance":1692.56,"description":"Transf Otras booking.com B.v.","categorization":{"type":11},"additional_info":[]},{"uuid":"8d17fdd97f73fe284634206839faef43e85d5c8c","value_date":"2025-12-30","operation_date":"2025-12-30","amount":-450,"balance":1242.56,"description":"Trans Inm Gregorio Lopez Triv","categorization":{"type":0},"additional_info":[]},{"uuid":"b1a9ff3c6d3233584f5f91cb3f84792dde6413a5","value_date":"2026-01-02","operation_date":"2026-01-01","amount":-500,"balance":742.56,"description":"Trans Inm Maria Concepcion Ba","categorization":{"type":0},"additional_info":[]},{"uuid":"ea2466c2319e6c5eed788918c0cdd00e3ce51acf","value_date":"2026-01-05","operation_date":"2026-01-05","amount":-87,"balance":655.56,"description":"Recib cdad.prop.edf.residenci","categorization":{"type":19},"additional_info":[]},{"uuid":"b18c3911e8fec018cb24b8f9ab13dcc3aa6e636f","value_date":"2026-01-05","operation_date":"2026-01-05","amount":-10,"balance":645.56,"description":"Recib cdad.prop.edf.residenci","categorization":{"type":19},"additional_info":[]},{"uuid":"18e53a6a9500665237b18a72c503e4d0f64baf08","value_date":"2026-01-07","operation_date":"2026-01-07","amount":-134.31,"balance":511.25,"description":"Trans Inm Toletum Business, S","categorization":{"type":0},"additional_info":[]},{"uuid":"9079ab172681ce218381b0dfe71f122076a37de0","value_date":"2026-01-07","operation_date":"2026-01-07","amount":-392.95,"balance":118.30000000000001,"description":"Trans Inm Gc3 Services Sl","categorization":{"type":5},"additional_info":[]},{"uuid":"a5d58472b998f5fcfb3a2c503cec9e69980f7d48","value_date":"2026-01-29","operation_date":"2026-01-29","amount":-110.38,"balance":7.920000000000016,"description":"Recibo endesa Energia S.a.","categorization":{"type":8},"additional_info":[]},{"uuid":"17c4f4c72f051d31b73bf2ce87059dfe69c3a35f","value_date":"2026-01-29","operation_date":"2026-01-29","amount":300,"balance":307.92,"description":"Trans Inm Gregorio Lopez Triv","categorization":{"type":0},"additional_info":[]},{"uuid":"0c3d9e70557fc312921ad6c5f65932dcef2628ab","value_date":"2026-01-30","operation_date":"2026-01-30","amount":-98.27,"balance":209.65,"description":"Recib emanagua Emp Mixta Muni","categorization":{"type":0},"additional_info":[]}]}],"cards":[],"portfolios":[],"loans":[]},"statistics":{"code":"bankinter","execution_time":22.02300500869751,"operation_id":"","warnings":[],"SESSION":"610697db6825bfd9"}}"
  "2026-01-31 08:00:25"
  "2026-01-31 08:13:55"
  "51c7e4af-a86a-4fd0-af48-b37e7828c948"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(3.25%) 		1 
SELECT b0_.operation_id AS operation_id_0, b0_.token AS token_1, b0_.code AS code_2, b0_.raw_data AS raw_data_3, b0_.curated_data AS curated_data_4, b0_.last_refresh_date AS last_refresh_date_5, b0_.last_error AS last_error_6, b0_.failed2fa AS failed2fa_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.id AS id_10, b0_.user_id AS user_id_11 FROM bank_aggregation b0_ WHERE (b0_.last_refresh_date IS NULL OR b0_.last_refresh_date < ?) AND b0_.failed2fa = ?
Parameters: 
[
  "2026-01-31 00:00:00"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(2.94%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.77%) 		1 
UPDATE bank_aggregation SET last_error = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  "HTTP 400 - {"error":"Failed to refresh data: No se puede refrescar, Client error: `POST https:\/\/api.wealthreader.com\/entities\/` resulted in a `400 Bad Request` response:\n{\u0022success\u0022:false,\u0022payload\u0022:[],\u0022error\u0022:{\u0022code\u0022:2000,\u0022message\u0022:\u0022La fecha de inicio es anterior a 89 d\\u00edas. Debe realiz (truncated...)\n"}"
  "2026-01-31 08:13:55"
  "465893fb-0fc4-419e-9cc6-e312a615011d"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.91%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\BankAggregation 7
App\Entity\User 4

Entities Mapping

Class Mapping errors
App\Entity\BankAggregation No errors.
App\Entity\User No errors.