ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90f7c41a74: POST https://beta.jinchangxiao.com/vue/reimbursement/verify at 2025-09-16 03:19:24 pm by 114.244.128.96

Database Queries

总计29条数据
TimeDurationTypeQuery
  
15:19:24.2722.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:19:24.2751.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:19:24.2780.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8170'

[+] Explain
15:19:24.2791.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=8170) ORDER BY "id"

[+] Explain
15:19:24.2820.9 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursement_verify_rels" SET "status"=1, "verify_at"='now()' WHERE "id"=29408

[+] Explain
15:19:24.2831.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ReimbursementVerifyRels', 29408, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.244.128.96')

[+] Explain
15:19:24.2851.3 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=8170) ORDER BY "id") "c"

[+] Explain
15:19:24.2860.9 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "status"=2, "updated_at"='now()' WHERE "id"=8170

[+] Explain
15:19:24.2870.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Reimbursements', 8170, 'a:2:{s:6:"status";i:2;s:13:"occurrence_at";s:19:"2025-09-17 00:00:00";}', '', 1001, '114.244.128.96')

[+] Explain
15:19:24.2880.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8170

[+] Explain
15:19:24.2890.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:19:24.2891.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=8170) ORDER BY "id"

[+] Explain
15:19:24.2910.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8170

[+] Explain
15:19:24.2921.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8170 ORDER BY "id"

[+] Explain
15:19:24.2930.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8170

[+] Explain
15:19:24.2940.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
15:19:24.2941.0 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20', 8170, '刘人诚 通过了这个报销', TRUE, '费用报销ERP审核拒绝需要同步业务段状态2') RETURNING "id"

[+] Explain
15:19:24.2960.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 191409, 'a:11:{s:2:"id";i:191409;s:9:"object_id";i:8170;s:11:"object_type";s:2:"20";s:6:"parent";N;s:11:"description";s:31:"刘人诚 通过了这个报销";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:55:"费用报销ERP审核拒绝需要同步业务段状态2";}', '', 1001, '114.244.128.96')

[+] Explain
15:19:24.2960.2 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)

[+] Explain
15:19:24.2970.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=8170

[+] Explain
15:19:24.2970.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id"=185)

[+] Explain
15:19:24.2980.7 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "next_verify_user"=NULL WHERE "id"=8170

[+] Explain
15:19:24.2990.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Reimbursements', 8170, 'a:1:{s:13:"occurrence_at";s:19:"2025-09-17 00:00:00";}', '', 1001, '114.244.128.96')

[+] Explain
15:19:24.3000.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8170

[+] Explain
15:19:24.3012.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE ("created_at" >= '2025-09-16 00:00:00') AND ("created_at" <= '2025-09-16 23:59:59') AND ("serial_no" LIKE '%XJFYD-20250916-%') AND (LENGTH(serial_no) = 20) ORDER BY "serial_no" DESC

[+] Explain
15:19:24.3042.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8170)

[+] Explain
15:19:24.3061.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8170)

[+] Explain
15:19:24.3080.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=8170)

[+] Explain
15:19:24.3081.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1001, 5, 'vue/reimbursement/verify', '{"id":"8170","web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":"","data":null,"status":0,"msg":[{"name":"error","success":"","error":"Trying to get property of non-object","trace":{"name":"PHP Notice","message":"Trying to get property of non-object","code":8,"type":"yii\\base\\ErrorException","file":"\/var\/www\/beta\/models\/Reimbursements.php","line":822,"stack-trace":["#0 \/var\/www\/beta\/models\/Reimbursements.php(822): yii\\base\\ErrorHandler->handleError(8, ''Trying to get p...'', ''\/var\/www\/beta\/m...'', 822, Array)","#1 \/var\/www\/beta\/models\/Reimbursements.php(1791): app\\models\\Reimbursements->afterVerify()","#2 \/var\/www\/beta\/modules\/vue\/controllers\/ReimbursementController.php(1674): app\\models\\Reimbursements->verifyModel()","#3 [internal function]: app\\modules\\vue\\controllers\\ReimbursementController->actionVerify()","#4 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''verify'', Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/reimburseme...'', Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#9 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#10 {main}"]}}]}', TRUE, '2025-09-16 15:19:24') RETURNING "id"

[+] Explain