68cbd5aa510d2: POST https://beta.jinchangxiao.com/vue/reimbursement/recognize at 2025-09-18 05:49:30 pm by 114.244.128.96
Performance Profiling
Total processing time: 12,059 ms; Peak memory: 7.514 MB. Show Profiling Timeline
总计31条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 17:49:30.343 | 7.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:49:30.338 | 4.8 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:49:42.378 | 2.0 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/reimbursement/recognize', '{"ids":["28338","28342","28340","28339","28341","28343","28344","28345","28346","28347","28348","28349","28350"],"web_access_token":"WzM3QBdjtVe8_r6QQWTTYMXroXbqjcvz"}', '{"code":2000,"result":{"summary":{"invoice_count":13,"amount_count":1473.43},"list":[{"saler_name":"\u5317\u4eac\u81ea\u5982\u4f4f\u623f\u79df\u8d41\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25112000000181039170","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"405.60","invoice_duplicated":true,"attachment_id":28338,"x0":62,"y0":95,"x1":4036,"y1":92,"x2":4042,"y2":2618,"x3":59,"y3":2619},{"saler_name":"\u5317\u4eac\u6ef4\u6ef4\u51fa\u884c\u79d1\u6280\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001088334631","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"73.80","invoice_duplicated":true,"attachment_id":28339,"x0":32,"y0":58,"x1":2870,"y1":60,"x2":2870,"y2":1885,"x3":31,"y3":1885},{"saler_name":"\u5317\u4eac\u6ef4\u6ef4\u51fa\u884c\u79d1\u6280\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001088334733","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"167.19","invoice_duplicated":true,"attachment_id":28340,"x0":30,"y0":57,"x1":2872,"y1":60,"x2":2872,"y2":1887,"x3":30,"y3":1887},{"saler_name":"\u5317\u4eac\u6ef4\u6ef4\u51fa\u884c\u79d1\u6280\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001088334631","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"73.80","invoice_duplicated":true,"attachment_id":28341,"x0":32,"y0":58,"x1":2870,"y1":60,"x2":2870,"y2":1885,"x3":31,"y3":1885},{"saler_name":"\u6ef4\u6ef4\u51fa\u884c\u79d1\u6280\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25127000000326663776","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"137.05","invoice_duplicated":true,"attachment_id":28342,"x0":27,"y0":56,"x1":2858,"y1":59,"x2":2858,"y2":1888,"x3":27,"y3":1888},{"saler_name":"\u5317\u4eac\u4eac\u4e1c\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001086221505","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"42.77","invoice_duplicated":true,"attachment_id":28343,"x0":123,"y0":117,"x1":4043,"y1":107,"x2":4044,"y2":2506,"x3":119,"y3":2513},{"saler_name":"\u5eca\u574a\u4eac\u4e1c\u53cb\u76db\u8d38\u6613\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25137000000347769212","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"55.80","invoice_duplicated":true,"attachment_id":28344,"x0":115,"y0":116,"x1":4037,"y1":108,"x2":4040,"y2":2510,"x3":115,"y3":2517},{"saler_name":"\u5eca\u574a\u4eac\u4e1c\u5409\u7279\u8d38\u6613\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25137000000348898855","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"37.52","invoice_duplicated":true,"attachment_id":28345,"x0":122,"y0":116,"x1":4034,"y1":108,"x2":4036,"y2":2510,"x3":117,"y3":2517},{"saler_name":"\u5317\u4eac\u8f68\u9053\u4ea4\u901a\u5927\u5174\u7ebf\u6295\u8d44\u6709\u9650\u8d23\u4efb\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001083877187","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"6.00","invoice_duplicated":true,"attachment_id":28346,"x0":50,"y0":100,"x1":4064,"y1":103,"x2":4067,"y2":3426,"x3":40,"y3":3421},{"saler_name":"\u5317\u4eac\u5730\u94c1\u5341\u4e8c\u53f7\u7ebf\u6295\u8d44\u6709\u9650\u8d23\u4efb\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001065112683","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"53.00","invoice_duplicated":true,"attachment_id":28347,"x0":49,"y0":103,"x1":4063,"y1":104,"x2":4066,"y2":3423,"x3":39,"y3":3419},{"saler_name":"\u5317\u4eac\u4eac\u6e2f\u5341\u516d\u53f7\u7ebf\u5730\u94c1\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001081283504","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"3.50","invoice_duplicated":true,"attachment_id":28348,"x0":46,"y0":102,"x1":4068,"y1":103,"x2":4072,"y2":3423,"x3":37,"y3":3419},{"saler_name":"\u5317\u4eac\u4eac\u6e2f\u5730\u94c1\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001083915912","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"6.00","invoice_duplicated":true,"attachment_id":28349,"x0":49,"y0":100,"x1":4063,"y1":101,"x2":4066,"y2":3424,"x3":40,"y3":3420},{"saler_name":"\u5317\u4eac\u5e02\u5730\u94c1\u8fd0\u8425\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001088427827","occurrence_at":"2025-08-27 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"411.40","invoice_duplicated":true,"attachment_id":28350,"x0":51,"y0":102,"x1":4061,"y1":105,"x2":4065,"y2":3421,"x3":41,"y3":3416}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-18 17:49:42') RETURNING "id" |
| 17:49:30.352 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:49:30.355 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN ('28338', '28342', '28340', '28339', '28341', '28343', '28344', '28345', '28346', '28347', '28348', '28349', '28350') |
| 17:49:31.396 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25112000000181039170') |
| 17:49:42.376 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001088427827') |
| 17:49:39.081 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001065112683') |
| 17:49:33.920 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25127000000326663776') |
| 17:49:41.293 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001083915912') |
| 17:49:36.772 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25137000000348898855') |
| 17:49:34.860 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001086221505') |
| 17:49:32.020 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001088334631') |
| 17:49:32.686 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001088334733') |
| 17:49:33.315 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001088334631') |
| 17:49:35.892 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25137000000347769212') |
| 17:49:40.191 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001081283504') |
| 17:49:37.901 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='25117000001083877187') |
| 17:49:37.902 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28347 |
| 17:49:41.294 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28350 |
| 17:49:33.316 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28342 |
| 17:49:31.397 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28339 |
| 17:49:35.893 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28345 |
| 17:49:36.773 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28346 |
| 17:49:32.021 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28340 |
| 17:49:40.191 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28349 |
| 17:49:32.687 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28341 |
| 17:49:34.861 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28344 |
| 17:49:39.082 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28348 |
| 17:49:33.920 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28343 |
| 17:49:30.356 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28338 |