ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68661dbd03b21: POST https://beta.jinchangxiao.com/v2/reimbursement/save-edit at 2025-07-03 02:05:49 pm by 223.104.41.148

Database Queries

总计26条数据
TimeDurationTypeQuery
  
14:05:49.0193.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'

[+] Explain
14:05:49.0231.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
14:05:49.0250.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='7440'

[+] Explain
14:05:49.0261.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=7440) ORDER BY "id"

[+] Explain
14:05:49.0300.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)

[+] Explain
14:05:49.0310.6 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')

[+] Explain
14:05:49.0310.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3814')

[+] Explain
14:05:49.0320.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
14:05:49.0330.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)

[+] Explain
14:05:49.0330.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')

[+] Explain
14:05:49.0330.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3814')

[+] Explain
14:05:49.0340.9 msUPDATEUPDATE "a57be577deb434"."tbl_reimbursements" SET "occurrence_at"='2025-07-03 14:00', "client_id"=2815, "project_id"=3814, "work_log_id"=NULL, "pre_sales_id"=NULL, "implement_record_id"=NULL WHERE "id"=7440

[+] Explain
14:05:49.0351.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', 7440, 'a:1:{s:13:"occurrence_at";s:19:"2025-07-03 14:00:00";}', '', 1000, '223.104.41.148')

[+] Explain
14:05:49.0361.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7440)

[+] Explain
14:05:49.0381.7 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7440)

[+] Explain
14:05:49.0401.8 msINSERTINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 7440, 24791)

[+] Explain
14:05:49.0420.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7440

[+] Explain
14:05:49.0420.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (184, 374))

[+] Explain
14:05:49.0430.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7440) AND ("term_id"=15)

[+] Explain
14:05:49.0440.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='184')

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

[+] Explain
14:05:49.0452.2 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 7440) RETURNING "id"

[+] Explain
14:05:49.0480.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', 118064, 'a:9:{s:2:"id";i:118064;s:9:"object_id";i:7440;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;}', '', 1000, '223.104.41.148')

[+] Explain
14:05:49.0490.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=7440)

[+] Explain
14:05:49.0490.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=118063

[+] Explain
14:05:49.0491.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1000, 2, 1141, 'v2/reimbursement/save-edit', '{"Reimbursements":{"amount":"123","attachmentFiles":["24791"],"client_id":"2815","description":"","form_costType":"349","form_reimbursementCarbonCopyRels":["5252"],"form_reimbursementSettleRels":["1000"],"form_reimbursementVerifyRels":["1000"],"form_type":"184","id":"7440","implement_record_id":"","occurrence_at":"2025-07-03 14:00","pre_sales_id":"","project_id":"3814","work_log_id":""},"access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"2","posttime":"1751522688","token":"5dde64f148f83a5fc16358f98ec65949","version_code":"1141"}', '{"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":1073,"stack-trace":["#0 \/var\/www\/beta\/models\/Reimbursements.php(1073): yii\\base\\ErrorHandler->handleError(8, ''Trying to get p...'', ''\/var\/www\/beta\/m...'', 1073, Array)","#1 \/var\/www\/beta\/modules\/v2\/controllers\/ReimbursementController.php(601): app\\models\\Reimbursements->saveEditModel()","#2 [internal function]: app\\modules\\v2\\controllers\\ReimbursementController->actionSaveEdit()","#3 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#4 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''save-edit'', Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''v2\/reimbursemen...'', Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#8 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#9 {main}"]}}]}', TRUE, '2025-07-03 14:05:49') RETURNING "id"

[+] Explain