ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68662f682f975: POST https://beta.jinchangxiao.com/vue/reimbursement/save-edit at 2025-07-03 03:21:12 pm by 115.171.251.24

Database Queries

总计44条数据
TimeDurationTypeQuery
  
15:21:12.1982.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
15:21:12.2010.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

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

[+] Explain
15:21:12.2050.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='7442'

[+] Explain
15:21:12.2061.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=7442) ORDER BY "id"

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

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

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

[+] Explain
15:21:12.2110.9 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "status"=0, "amount"=NULL, "occurrence_at"=NULL, "client_id"=NULL, "project_id"=NULL, "work_log_id"=NULL, "pre_sales_id"=NULL, "implement_record_id"=NULL WHERE "id"=7442

[+] Explain
15:21:12.2121.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Reimbursements', 7442, 'a:0:{}', '', 1001, '115.171.251.24')

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

[+] Explain
15:21:12.2151.2 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7442)

[+] Explain
15:21:12.2161.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=7442)

[+] Explain
15:21:12.2181.0 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=7442)

[+] Explain
15:21:12.2190.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7442

[+] Explain
15:21:12.2190.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 365))

[+] Explain
15:21:12.2200.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7442) AND ("term_id"=15)

[+] Explain
15:21:12.2210.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='185')

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

[+] Explain
15:21:12.2221.1 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 185, 7442) RETURNING "id"

[+] Explain
15:21:12.2230.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118092, 'a:9:{s:2:"id";i:118092;s:9:"object_id";i:7442;s:11:"taxonomy_id";s:3:"185";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, '115.171.251.24')

[+] Explain
15:21:12.2240.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=7442)

[+] Explain
15:21:12.2240.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=365

[+] Explain
15:21:12.2250.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='348'

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

[+] Explain
15:21:12.2261.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'type', 7442, 20, 1001, 'now()', '["\u793c\u54c1\u8d39"]', '["\u6d3b\u52a8\u8d39"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u7c7b\u578b","d4":["\u6d3b\u52a8\u8d39 <b>\u53d8\u4e3a<\/b> \u793c\u54c1\u8d39"]}')

[+] Explain
15:21:12.2270.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7442) AND ("object_type"=7)

[+] Explain
15:21:12.2280.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='348')

[+] Explain
15:21:12.2280.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18)

[+] Explain
15:21:12.2280.9 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 348, 7442) RETURNING "id"

[+] Explain
15:21:12.2290.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118093, 'a:9:{s:2:"id";i:118093;s:9:"object_id";i:7442;s:11:"taxonomy_id";s:3:"348";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, '115.171.251.24')

[+] Explain
15:21:12.2301.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=7442 ORDER BY "id"

[+] Explain
15:21:12.2311.4 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=7442

[+] Explain
15:21:12.2330.9 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (7442, 1001, 0)

[+] Explain
15:21:12.2340.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=7442

[+] Explain
15:21:12.2340.8 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=7442

[+] Explain
15:21:12.2350.9 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (7442, 5388)

[+] Explain
15:21:12.2360.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=7442

[+] Explain
15:21:12.2370.9 msDELETEDELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=7442

[+] Explain
15:21:12.2380.9 msINSERTINSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (7442, 1013)

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

[+] Explain
15:21:12.2410.7 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "updated_at"='now()' WHERE "id"=7442

[+] Explain
15:21:12.2410.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', 7442, 'a:0:{}', '', 1001, '115.171.251.24')

[+] Explain
15:21:12.2431.0 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-edit', '{"Reimbursements":{"id":"7442","form_type":"185","form_costType":"348","occurrence_at":"","amount":"","client_id":"","client_name":"","form_reimbursementVerifyRels":["1001"],"form_reimbursementSettleRels":["1013"],"form_reimbursementCarbonCopyRels":["5388"],"description":"","project_id":"","status":"0","work_log_id":"","pre_sales_id":"","implement_record_id":"","files":"","attachmentFiles":""},"web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u62a5\u9500\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-07-03 15:21:12') RETURNING "id"

[+] Explain