Database Queries

总计14条数据
TimeDurationTypeQuery
  
16:27:48.8742.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1000

16:27:48.8771.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

16:27:48.8800.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8145'

16:27:48.8811.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8145

16:27:48.8831.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=8145) ORDER BY "id"

16:27:48.8860.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

16:27:48.8881.6 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=1661

16:27:48.8909.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

16:27:48.9001.2 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id"

16:27:48.9021.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 180896, 'a:5:{s:2:"id";i:180896;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '114.244.128.96')

16:27:48.9030.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 1661, 'a:0:{}', '', 1000, '114.244.128.96')

16:27:48.9040.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=8145

16:27:48.9040.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND (0=1)

16:27:48.9051.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1000, 5, 'vue/reimbursement/delete', '{"id":"8145","web_access_token":"4lmnUHibaD9OEefzriQnJ9ZtXEOZJrDT"}', '{"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":1472,"stack-trace":["#0 \/var\/www\/beta\/models\/Reimbursements.php(1472): yii\\base\\ErrorHandler->handleError(8, ''Trying to get p...'', ''\/var\/www\/beta\/m...'', 1472, Array)","#1 \/var\/www\/beta\/modules\/vue\/controllers\/ReimbursementController.php(1068): app\\models\\Reimbursements->deleteModel()","#2 [internal function]: app\\modules\\vue\\controllers\\ReimbursementController->actionDelete()","#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(''delete'', 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-09-17 16:27:48') RETURNING "id"