Database Queries

总计24条数据
TimeDurationTypeQuery
  
14:54:33.9852.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

14:54:33.9880.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

14:54:33.9891.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

14:54:33.9920.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='7442'

14:54:33.9931.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=7442) ORDER BY "id"

14:54:33.9960.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

14:54:33.9970.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

14:54:33.9970.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

14:54:33.9980.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

14:54:33.9991.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')

14:54:34.0001.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7442)

14:54:34.0021.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7442)

14:54:34.0031.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=7442)

14:54:34.0041.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=7442)

14:54:34.0060.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7442

14:54:34.0060.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 372))

14:54:34.0071.3 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7442) AND ("term_id"=15)

14:54:34.0080.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='185')

14:54:34.0090.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15)

14:54:34.0091.0 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 185, 7442) RETURNING "id"

14:54:34.0100.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', 118086, 'a:9:{s:2:"id";i:118086;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')

14:54:34.0110.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=7442)

14:54:34.0110.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=118085

14:54:34.0121.0 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/save-edit', '{"Reimbursements":{"id":"7442","form_type":"185","form_costType":"369","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":"","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\/vue\/controllers\/ReimbursementController.php(988): app\\models\\Reimbursements->saveEditModel()","#2 [internal function]: app\\modules\\vue\\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(''vue\/reimburseme...'', 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:54:34') RETURNING "id"