ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c4e5b9c4d76: POST https://beta.jinchangxiao.com/v2/user/get-announcement-unread at 2025-09-13 11:32:09 am by 39.157.26.122

Log Messages

总计29条数据
TimeLevelCategoryMessage
 
11:32:09.805traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
11:32:09.805traceyii\base\Module::getModuleLoading module: debug
11:32:09.806traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
11:32:09.806traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
11:32:09.806traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
11:32:09.806traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:32:09.806traceyii\base\Module::getModuleLoading module: gii
11:32:09.806traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
11:32:09.806traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
11:32:09.806traceyii\web\Application::handleRequestRoute requested: 'v2/user/get-announcement-unread'
11:32:09.806traceyii\base\Module::getModuleLoading module: v2
11:32:09.807infoyii\web\Session::openSession started
11:32:09.807infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:32:09.809infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
11:32:09.812traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:32:09.812traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:32:09.812traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:32:09.812traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:32:09.813infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:32:09.814traceyii\base\Controller::runActionRoute to run: v2/user/get-announcement-unread
11:32:09.814traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\UserController::actionGetAnnouncementUnread()
11:32:09.814infoyii\db\Command::querySELECT * FROM "global"."tbl_logins" WHERE "id"=1000
11:32:09.815traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:32:09.815traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:32:09.815infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "a".* FROM "global"."tbl_announcements" "a" LEFT JOIN "global"."tbl_read_announcement" "r" ON a.id = r.announcement_id AND r.user_id = 1000 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2016-10-14 22:23:37') ORDER BY "a"."created_at" DESC) "c"
11:32:09.816infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND ("is_read"=FALSE)
11:32:09.834traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:32:09.834traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:32:09.834infoyii\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, 2, 1149, 'v2/user/get-announcement-unread', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"2","posttime":"1757734272","token":"398594c96cec2913c434398268a2a1a5","version_code":"1149"}', '{"code":200,"data":{"count":2},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-13 11:32:09') RETURNING "id"