ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68ca71de6c81a: POST https://beta.jinchangxiao.com/vue/reimbursement/save-new at 2025-09-17 04:31:26 pm by 114.244.128.96

Database Queries

总计33条数据
TimeDurationTypeQuery
  
16:31:26.4493.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:31:26.4542.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:31:26.4590.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
16:31:26.4602.0 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3381')

[+] Explain
16:31:26.4620.7 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3914')

[+] Explain
16:31:26.4630.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
16:31:26.4630.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3381')

[+] Explain
16:31:26.4640.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3914')

[+] Explain
16:31:26.4648.4 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursements" ("occurrence_at", "amount", "client_id", "description", "project_id", "status", "work_log_id", "pre_sales_id", "implement_record_id", "created_by", "created_at") VALUES (NULL, NULL, 3381, '', 3914, 0, NULL, NULL, NULL, 1001, 'now()') RETURNING "id"

[+] Explain
16:31:26.47411.4 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Reimbursements', 8177, 'a:18:{s:2:"id";i:8177;s:6:"status";s:1:"0";s:6:"amount";s:0:"";s:13:"occurrence_at";N;s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";s:0:"";s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";s:4:"3381";s:10:"project_id";s:4:"3914";s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";s:0:"";s:12:"pre_sales_id";s:0:"";s:19:"implement_record_id";s:0:"";}', '', 1001, '114.244.128.96')

[+] Explain
16:31:26.4867.8 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8177)

[+] Explain
16:31:26.49611.6 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8177)

[+] Explain
16:31:26.5080.5 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8177) AND ("term_id"=15)

[+] Explain
16:31:26.5100.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='184')

[+] Explain
16:31:26.5100.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15)

[+] Explain
16:31:26.5111.2 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8177) RETURNING "id"

[+] Explain
16:31:26.5121.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 129391, 'a:9:{s:2:"id";i:129391;s:9:"object_id";i:8177;s:11:"taxonomy_id";s:3:"184";s:7:"term_id";i:15;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96')

[+] Explain
16:31:26.5140.4 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8177) AND ("object_type"=7)

[+] Explain
16:31:26.5140.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='349')

[+] Explain
16:31:26.5150.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18)

[+] Explain
16:31:26.5161.3 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 349, 8177) RETURNING "id"

[+] Explain
16:31:26.5171.2 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 129392, 'a:9:{s:2:"id";i:129392;s:9:"object_id";i:8177;s:11:"taxonomy_id";s:3:"349";s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96')

[+] Explain
16:31:26.5191.7 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8177

[+] Explain
16:31:26.5211.1 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8177, 1001, 0)

[+] Explain
16:31:26.5221.2 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8177

[+] Explain
16:31:26.5254.9 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8177, 1013)

[+] Explain
16:31:26.5302.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=8177) ORDER BY "id"

[+] Explain
16:31:26.5340.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
16:31:26.5350.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3381')

[+] Explain
16:31:26.5350.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3914')

[+] Explain
16:31:26.5363.2 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "next_verify_user"=1001 WHERE "id"=8177

[+] Explain
16:31:26.5391.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Reimbursements', 8177, 'a:0:{}', '', 1001, '114.244.128.96')

[+] Explain
16:31:26.5421.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/reimbursement/save-new', '{"Reimbursements":{"id":"","form_type":"184","form_costType":"349","occurrence_at":"","amount":"","client_id":"3381","client_name":"\u5317\u4eac\u4e2d\u4f73\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","form_reimbursementVerifyRels":["1001"],"form_reimbursementSettleRels":["1013"],"description":"","project_id":"3914","status":"0","work_log_id":"","pre_sales_id":"","implement_record_id":"","files":"","attachmentFiles":""},"web_access_token":"dut1vXihUglGelt2KMXELnSbFppny3OV"}', '{"code":2000,"result":{"id":8177},"status":1,"msg":[{"name":"success","success":"\u65b0\u62a5\u9500\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-09-17 16:31:26') RETURNING "id"

[+] Explain