68ca7cbcf1c2a: POST https://beta.jinchangxiao.com/v2/reimbursement/recognize at 2025-09-17 05:17:48 pm by 223.104.42.217
Database Queries
总计10条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:17:48.994 | 4.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9' |
| 17:17:49.000 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:17:49.019 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("path", "name", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '4cd8302b-c4e6-3584-b5fe-0fd6ffea14b6', '20250917171747.jpeg', 'jpeg', 'image/jpeg', 1902137, '223.104.42.217', NULL) RETURNING "id" |
| 17:17:49.021 | 1.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Attachments', 28166, 'a:10:{s:2:"id";i:28166;s:9:"orig_name";s:19:"20250917171747.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"4cd8302b-c4e6-3584-b5fe-0fd6ffea14b6";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:1902137;s:10:"ip_address";s:14:"223.104.42.217";s:10:"created_by";N;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1000, '223.104.42.217') |
| 17:17:49.191 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28166 |
| 17:17:50.323 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='110023313048853276')) |
| 17:17:50.324 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='110023313048853392')) |
| 17:17:50.325 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='01100230010501690943')) |
| 17:17:50.325 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='25117000001107285189')) |
| 17:17:50.326 | 2.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1149, 'v2/reimbursement/recognize', '{"access_token":"jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9","device_type":"2","posttime":"1758100608","token":"ecd4108bd39078620d485323c80b4ac4","version_code":"1149"}', '{"code":200,"data":{"summary":{"invoice_count":4,"amount_count":165098},"list":[{"saler_name":"\u5317\u4eac\u5929\u9a70\u541b\u6cf0\u5f8b\u5e08\u4e8b\u52a1\u6240","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"110023313048853276","occurrence_at":"2024-07-17 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"15000.00","invoice_duplicated":false,"attachment_id":28166,"x0":102,"y0":59,"x1":558,"y1":53,"x2":585,"y2":819,"x3":131,"y3":826},{"saler_name":"\u5317\u4eac\u5929\u9a70\u541b\u6cf0\u5f8b\u5e08\u4e8b\u52a1\u6240","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"110023313048853392","occurrence_at":"2024-08-06 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"15000.00","invoice_duplicated":false,"attachment_id":28166,"x0":582,"y0":111,"x1":1009,"y1":107,"x2":1030,"y2":828,"x3":606,"y3":834},{"saler_name":"","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u4eba\u6c11\u653f\u5e9c\u65b0\u6751\u8857\u9053\u529e\u4e8b\u5904","serial_no":"01100230010501690943","occurrence_at":"2025-09-08 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"135048.00","invoice_duplicated":false,"attachment_id":28166,"x0":182,"y0":1534,"x1":929,"y1":1490,"x2":956,"y2":1923,"x3":205,"y3":1967},{"saler_name":"\u4e2d\u56fd\u79fb\u52a8\u901a\u4fe1\u96c6\u56e2\u5317\u4eac\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001107285189","occurrence_at":"2025-09-04 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"50.00","invoice_duplicated":false,"attachment_id":28166,"x0":561,"y0":847,"x1":1007,"y1":840,"x2":1016,"y2":1482,"x3":569,"y3":1487}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-17 17:17:50') RETURNING "id" |