ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c142a42a969: POST https://beta.jinchangxiao.com/v2/rating/list at 2025-09-10 05:19:32 pm by 114.246.239.150

Log Messages

总计32条数据
TimeLevelCategoryMessage
 
17:19:32.174traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:19:32.174traceyii\base\Module::getModuleLoading module: debug
17:19:32.174traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:19:32.174traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:19:32.174traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:19:32.174traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.174traceyii\base\Module::getModuleLoading module: gii
17:19:32.174traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:19:32.175traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:19:32.175traceyii\web\Application::handleRequestRoute requested: 'v2/rating/list'
17:19:32.175traceyii\base\Module::getModuleLoading module: v2
17:19:32.175infoyii\web\Session::openSession started
17:19:32.176infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:19:32.178infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
17:19:32.181traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.181traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:19:32.182traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.182traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:19:32.182infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:19:32.184traceyii\base\Controller::runActionRoute to run: v2/rating/list
17:19:32.184traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.185traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:19:32.185traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\RatingController::actionList()
17:19:32.185traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.186traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.187infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.*, CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC) "c"
17:19:32.188infoyii\db\Command::querySELECT r.*, CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC LIMIT 10 OFFSET 20
17:19:32.190traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.190traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:19:32.190traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:19:32.190traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:19:32.190infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/rating/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","page":"3","token":"fe8b514c098ebfd9db6aa84055297eff","posttime":"1757495972"}', '{"code":200,"data":{"list":[{"id":323,"title":"2025\u5e742\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-03-03 08:55:13","created_by":1001,"created_at":"2025-02-24 11:46:48","updated_at":"2025-03-03 08:55:23","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":322,"title":"2024\u5e7412\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:13","created_by":1001,"created_at":"2024-12-18 14:40:00","updated_at":"2025-01-03 17:11:23","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":321,"title":"2024\u5e7412\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:20","created_by":1001,"created_at":"2024-12-18 14:39:17","updated_at":"2025-01-03 17:11:30","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":320,"title":"2024\u5e7412\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:22","created_by":1001,"created_at":"2024-12-18 14:38:40","updated_at":"2025-01-03 17:11:32","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":319,"title":"2024\u5e7411\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 15:53:19","created_by":1001,"created_at":"2024-11-07 09:25:55","updated_at":"2024-11-29 15:53:29","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":318,"title":"2024\u5e7411\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 16:48:09","created_by":1001,"created_at":"2024-11-07 09:25:06","updated_at":"2024-11-29 16:48:19","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":317,"title":"2024\u5e7411\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 16:48:13","created_by":1001,"created_at":"2024-11-07 09:24:17","updated_at":"2024-11-29 16:48:23","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":316,"title":"2024\u5e7410\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:09","created_by":1001,"created_at":"2024-10-21 17:55:04","updated_at":"2024-11-01 16:15:19","strategy_id":52,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":315,"title":"2024\u5e7410\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:11","created_by":1001,"created_at":"2024-10-21 17:54:15","updated_at":"2024-11-01 16:15:21","strategy_id":51,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":314,"title":"2024\u5e7410\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:13","created_by":1001,"created_at":"2024-10-21 17:53:29","updated_at":"2024-11-01 16:15:23","strategy_id":50,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false}],"pagenation":{"totalcount":234,"thispage":3,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 17:19:32') RETURNING "id"