ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6863b5eea1d9a: POST https://beta.jinchangxiao.com/v2/comment/list at 2025-07-01 06:18:22 pm by 124.64.23.82

Log Messages

总计34条数据
TimeLevelCategoryMessage
 
18:18:22.662traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
18:18:22.662traceyii\base\Module::getModuleLoading module: debug
18:18:22.662traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
18:18:22.663traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
18:18:22.663traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
18:18:22.663traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18:18:22.663traceyii\base\Module::getModuleLoading module: gii
18:18:22.663traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
18:18:22.663traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
18:18:22.663traceyii\web\Application::handleRequestRoute requested: 'v2/comment/list'
18:18:22.663traceyii\base\Module::getModuleLoading module: v2
18:18:22.664infoyii\web\Session::openSession started
18:18:22.664infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:18:22.666infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
18:18:22.669traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18:18:22.669traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
18:18:22.669traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18:18:22.669traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
18:18:22.669infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
18:18:22.671traceyii\base\Controller::runActionRoute to run: v2/comment/list
18:18:22.671traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\CommentController::actionList()
18:18:22.671infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '18' AND object_id = '8264' AND remind_user_id = 1000
18:18:22.689traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18:18:22.689traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
18:18:22.689infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='18') AND ("object_id"='8264') AND ("remind_user_id"=1000)
18:18:22.704infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='18') AND ("object_id"='8264') ORDER BY "created_at" DESC) "c"
18:18:22.723infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='18') AND ("object_id"='8264') ORDER BY "created_at" DESC LIMIT 20
18:18:22.741infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (170168, 170167, 170014) ORDER BY "created_at"
18:18:22.757infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (170168, 170167, 170014))
18:18:22.759infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
18:18:22.759infoyii\db\Command::querySELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
18:18:22.760traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18:18:22.760traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
18:18:22.760infoyii\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, 6, 166, 'v2/comment/list', '{"object_type":"18","object_id":"8264","page":"1","posttime":"1751365103","access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"6","version_code":"166","token":"1551bca634b4b4f4bb06eec74530af6c"}', '{"code":200,"data":{"list":[{"id":170168,"object_id":8264,"object_type":"18","parent":null,"description":"vvv","created_by":1000,"created_at":"2025-07-01 18:18:06","reply_to":null,"is_system":false,"for_user":null,"description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":true},{"id":170167,"object_id":8264,"object_type":"18","parent":null,"description":"hxhcb","created_by":1000,"created_at":"2025-07-01 18:18:00","reply_to":null,"is_system":false,"for_user":null,"description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":true},{"id":170014,"object_id":8264,"object_type":"18","parent":null,"description":"\u66f9\u6c38\u751f\u4e3a\u970d\u4e1c\u9633\u65b0\u5efa\u4e86\u4e00\u4e2aCase","created_by":1000,"created_at":"2025-05-15 15:14:31","reply_to":null,"is_system":true,"for_user":null,"description2":"\u89c1\u89c1\u4f60\u5462","comments":[],"attachmentRelationships":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":true}],"unread":0,"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-01 18:18:22') RETURNING "id"