6a2fabbbbeca7: POST https://beta.jinchangxiao.com/vue/analysis/sales-counts-get-filter at 2026-06-15 03:37:31 pm by 221.216.117.25
Log Messages
总计41条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:37:31.779 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:37:31.779 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:37:31.780 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:37:31.781 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:37:31.781 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:37:31.782 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.785 | info | time tracing start | 1781509051785837056 |
| 15:37:31.786 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:37:31.786 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sales-counts-get-filter' |
| 15:37:31.786 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:37:31.806 | info | yii\web\Session::open | Session started |
| 15:37:31.807 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:37:31.807 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:37:31.809 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.809 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:37:31.810 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:37:31.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.811 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:37:31.811 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:37:31.812 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sales-counts-get-filter |
| 15:37:31.812 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.814 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:37:31.814 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSalesCountsGetFilter() |
| 15:37:31.814 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.815 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.817 | info | yii\db\Command::query | SELECT "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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::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 |
| 15:37:31.818 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.818 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:37:31.819 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 15:37:31.820 | info | yii\db\Command::query | SELECT "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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::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 |
| 15:37:31.821 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 15:37:31.823 | info | yii\db\Command::query | SELECT g.id, g.name, string_agg( sgr.sales_id::varchar, ',') AS list FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE "sgr"."sales_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "g"."id" ORDER BY "sort" |
| 15:37:31.825 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.825 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:37:31.825 | info | yii\db\Command::query | SELECT "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"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::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 |
| 15:37:31.826 | info | yii\db\Command::query | SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by" |
| 15:37:31.827 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.827 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:37:31.828 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-counts-get-filter', '{"web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"filter":{"dataUserId":{"key":"dataUserId","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":0,"key":"1001,1004,1005,1013,5087,5295,5300,5311,5332,5449,5467,5476","name":"\u5168\u90e8","child":[]},{"id":80,"key":"1004,1005,1013,5087","name":"\u5408\u4f19\u4eba","child":[{"key":5087,"name":"\u5218\u5fae"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}]},{"id":1,"key":"1001,5295,5300,5311","name":"\u5218\u4eba\u8bda\u7ec4","child":[{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"}]},{"id":81,"key":"5332","name":"\u4f0a\u5cfb\u8fb0\u7ec4","child":[{"key":5332,"name":"\u970d\u536b\u8d85"}]},{"id":83,"key":"5476","name":"\u91d1\u7545\u900d","child":[{"key":5476,"name":"\u6768\u5dcd"}]},{"id":999999,"key":"5449,5467","name":"\u79bb\u804c\u4eba\u5458","child":[{"key":5467,"name":"\u9a6c\u6668\u5e0c"},{"key":5449,"name":"\u5468\u4e3d\u98de"}]}],"default":1001,"itemKey":"dataUserId","groupKey":"group"}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-15 15:37:31', 42103040) RETURNING "id" |
| 15:37:31.830 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:37:31.830 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |