ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a20eba7cc275: POST https://beta.jinchangxiao.com/v2/task/get-filter-case at 2026-06-04 11:06:15 am by 43.224.72.82

Log Messages

总计30条数据
TimeLevelCategoryMessage
 
11:06:15.835traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
11:06:15.835traceyii\base\Module::getModuleLoading module: debug
11:06:15.836traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
11:06:15.836traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
11:06:15.836traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
11:06:15.836traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.836infotime tracing start1780542375836766976
11:06:15.837traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
11:06:15.837traceyii\web\Application::handleRequestRoute requested: 'v2/task/get-filter-case'
11:06:15.837traceyii\base\Module::getModuleLoading module: v2
11:06:15.838infoyii\web\Session::openSession started
11:06:15.838infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:06:15.838infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
11:06:15.840traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.840traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:06:15.840traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.841traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:06:15.841infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:06:15.843traceyii\base\Controller::runActionRoute to run: v2/task/get-filter-case
11:06:15.843traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\TaskController::actionGetFilterCase()
11:06:15.843infoyii\db\Command::querySELECT distinct c.deduct_points_from FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_remind_dates" "crd" ON crd.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_case_remind_receivers" "crr" ON crr.remind_date_id = crd.id WHERE "crr"."user_id"=1000
11:06:15.847traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.849traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.851infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "user_status" FROM "a57be577deb434"."tbl_users" WHERE (("id" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR (0=1)) AND ("user_status"='1') ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:06:15.853infoyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-04 11:06:15, 2026-06-04 11:06:15]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:06:15.856traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.857traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:06:15.858traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:06:15.858traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:06:15.859infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 273, 'v2/task/get-filter-case', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"0","version_code":"273","token":"7863832a6e4c67b197fb76608848150b","posttime":"1780542376"}', '{"code":200,"data":[{"key":"CaseSearch[case_type]","name":"Case\u7c7b\u578b","value":[{"key":1,"name":"\u552e\u524d\u54a8\u8be2"},{"key":2,"name":"\u5b9e\u65bd\u670d\u52a1"}],"default":""},{"key":"CaseSearch[sales_rep]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5332,"name":"\u970d\u536b\u8d85"},{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5087,"name":"\u5218\u5fae"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":5476,"name":"\u6768\u5dcd"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}]},{"key":"CaseSearch[last_engineer]","name":"\u5de5\u7a0b\u5e08","value":[{"key":5085,"name":"\u970d\u4e1c\u9633"},{"key":5248,"name":"\u6587\u4f73\u9f99"},{"key":1015,"name":"\u5434\u660a"},{"key":1022,"name":"\u5f90\u7855"},{"key":5064,"name":"\u59da\u96ea\u7eaf"},{"key":1023,"name":"\u5468\u5b50\u5065"}]},{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"updated_at","name":"\u66f4\u65b0\u65f6\u95f4"},{"key":"created_at","name":"\u521b\u5efa\u65f6\u95f4"},{"key":"end_at","name":"\u7ed3\u675f\u65f6\u95f4"}]},{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"43.224.72.82","ua":"jinchangxiao\/2.3.173 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-06-04 11:06:15', 22824960) RETURNING "id"