6899990a112ea: POST https://beta.jinchangxiao.com/vue/setting/list-role at 2025-08-11 03:17:30 pm by 124.64.23.198
Log Messages
总计455条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:17:30.069 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:17:30.070 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:17:30.070 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:17:30.070 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:17:30.070 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:17:30.070 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.070 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:17:30.070 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:17:30.071 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:17:30.071 | trace | yii\web\Application::handleRequest | Route requested: 'vue/setting/list-role' |
| 15:17:30.071 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:17:30.071 | info | yii\web\Session::open | Session started |
| 15:17:30.071 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5252 |
| 15:17:30.072 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:17:30.076 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.076 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:17:30.076 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:17:30.077 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.077 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:17:30.077 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:17:30.079 | trace | yii\base\Controller::runAction | Route to run: vue/setting/list-role |
| 15:17:30.079 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.079 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_items" |
| 15:17:30.081 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_rules" |
| 15:17:30.081 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_item_child" |
| 15:17:30.083 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_assignments" ORDER BY "user_id" |
| 15:17:30.085 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:17:30.085 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:17:30.085 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SettingController::actionListRole() |
| 15:17:30.085 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id") "c" |
| 15:17:30.086 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id" LIMIT 20 |
| 15:17:30.087 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name" IN ('Admin', 'GM', 'Engineer', 'AccountManager', 'TechDirector', 'SalesManager', 'SalesDirector', 'CommercialAttache', 'ProjectManager', 'StoreKeeper', 'Accountant', 'Dispatcher', 'Operator', 'Treasurer', '软件开发', '人力资源', '电话销售', '运营总监') |
| 15:17:30.088 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.088 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.088 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_groups" ORDER BY "level", "id" |
| 15:17:30.089 | info | yii\db\Command::query | SELECT "id", "name", "email" FROM "a57be577deb434"."tbl_users" 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:17:30.091 | info | yii\db\Command::query | SELECT "sales_id", "group_id" FROM "a57be577deb434"."tbl_sales_group_relationships" "sgr" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON sgr.sales_id = u.id GROUP BY "sales_id", "group_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:17:30.091 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.092 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:17:30.092 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" |
| 15:17:30.093 | info | yii\db\Command::query | SELECT "a"."user_id", "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE (a.item_name = b.name) AND ("a"."user_id" IN (5258, 5049, 1000, 5083, 5301, 1017, 1018, 5022, 1028, 5209, 5030, 5026, 5293, 5250, 5298, 5309, 5016, 1010, 5356, 5329, 5074, 5065, 1002, 5086, 5080, 1011, 1019, 5050, 5299, 5125, 5101, 5303, 5302, 5085, 5332, 5047, 5419, 1016, 1026, 5259, 5028, 1012, 5249, 5096, 5070, 5448, 5102, 5063, 5095, 5420, 5445, 5082, 5073, 1029, 1027, 5446, 1001, 5037, 5087, 1008, 5123, 5048, 5043, 5094, 5045, 5230, 5031, 5088, 5208, 5305, 5078, 1003, 5294, 5357, 5044, 5024, 5351, 1030, 5076, 5135, 5300, 1007, 5027, 5089, 5311, 5029, 5411, 1021, 1020, 5066, 5069, 5079, 5252, 5364, 5071, 1009, 5295, 5248, 1013, 1015, 5128, 5404, 5203, 1025, 5413, 5023, 5124, 1022, 5126, 5032, 5075, 5388, 5064, 1004, 5025, 5105, 5072, 5081, 5033, 5062, 5440, 5359, 5104, 5360, 5247, 5393, 5409, 5412, 5015, 5229, 1005, 5304, 5296, 5449, 5358, 1023, 1006, 5333, 5297, 1014, 5093)) AND ("b"."type"=1) ORDER BY "user_id" |
| 15:17:30.095 | info | yii\db\Command::query | SELECT "u"."id" AS "id" FROM "a57be577deb434"."tbl_users" "u" 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:17:30.096 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (sales_id IS NOT NULL) |
| 15:17:30.096 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (group_id IS NOT NULL) |
| 15:17:30.097 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (sales_id IS NOT NULL) |
| 15:17:30.097 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5049 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:17:30.097 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (group_id IS NOT NULL) |
| 15:17:30.098 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.098 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.099 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1000) AND (group_id IS NOT NULL) |
| 15:17:30.099 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.100 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.100 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5083) AND (group_id IS NOT NULL) |
| 15:17:30.101 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (sales_id IS NOT NULL) |
| 15:17:30.101 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5301 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:17:30.102 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (group_id IS NOT NULL) |
| 15:17:30.102 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (sales_id IS NOT NULL) |
| 15:17:30.102 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.103 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (group_id IS NOT NULL) |
| 15:17:30.103 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (sales_id IS NOT NULL) |
| 15:17:30.104 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (group_id IS NOT NULL) |
| 15:17:30.104 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (sales_id IS NOT NULL) |
| 15:17:30.104 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5022 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:17:30.105 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (group_id IS NOT NULL) |
| 15:17:30.105 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (sales_id IS NOT NULL) |
| 15:17:30.106 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (group_id IS NOT NULL) |
| 15:17:30.106 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (sales_id IS NOT NULL) |
| 15:17:30.106 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5209 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:17:30.107 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (group_id IS NOT NULL) |
| 15:17:30.107 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.107 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.108 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5030) AND (group_id IS NOT NULL) |
| 15:17:30.109 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (sales_id IS NOT NULL) |
| 15:17:30.109 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5026 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:17:30.109 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (group_id IS NOT NULL) |
| 15:17:30.110 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (sales_id IS NOT NULL) |
| 15:17:30.110 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5293 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:17:30.110 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (group_id IS NOT NULL) |
| 15:17:30.111 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.111 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.112 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5250) AND (group_id IS NOT NULL) |
| 15:17:30.112 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (sales_id IS NOT NULL) |
| 15:17:30.113 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.113 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (group_id IS NOT NULL) |
| 15:17:30.114 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (sales_id IS NOT NULL) |
| 15:17:30.114 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5309, 5311) 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:17:30.114 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (group_id IS NOT NULL) |
| 15:17:30.115 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.115 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.116 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5016) AND (group_id IS NOT NULL) |
| 15:17:30.116 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (sales_id IS NOT NULL) |
| 15:17:30.117 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (group_id IS NOT NULL) |
| 15:17:30.117 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (sales_id IS NOT NULL) |
| 15:17:30.117 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5356 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:17:30.118 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (group_id IS NOT NULL) |
| 15:17:30.118 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (sales_id IS NOT NULL) |
| 15:17:30.119 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5329, 5311, 5357, 5358, 5359, 5364, 5449) 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:17:30.119 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (group_id IS NOT NULL) |
| 15:17:30.119 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (sales_id IS NOT NULL) |
| 15:17:30.120 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1008, 5026, 5088, 1005, 5062, 5096, 1006, 5074, 5295, 5072, 1003, 1004, 5087, 5089, 5076, 5093, 5123, 5128, 5203, 5203, 5295, 5209, 5209, 5208, 5208, 5229, 5230, 5302, 5304, 5309, 5294, 5301, 5294, 5299, 5300, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.120 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (group_id IS NOT NULL) |
| 15:17:30.121 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.121 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.122 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5065) AND (group_id IS NOT NULL) |
| 15:17:30.122 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.122 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.123 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1002) AND (group_id IS NOT NULL) |
| 15:17:30.124 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (sales_id IS NOT NULL) |
| 15:17:30.124 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 1005, 1008, 5026, 1004, 5076, 5072, 5088, 5062, 5295, 5074, 5096, 5087, 5089, 5093, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5295, 5229, 5230, 5302, 5304, 5309, 5294, 5301, 5294, 5299, 5300, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.125 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (group_id IS NOT NULL) |
| 15:17:30.125 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (sales_id IS NOT NULL) |
| 15:17:30.125 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (group_id IS NOT NULL) |
| 15:17:30.126 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (sales_id IS NOT NULL) |
| 15:17:30.126 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.127 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (group_id IS NOT NULL) |
| 15:17:30.127 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (sales_id IS NOT NULL) |
| 15:17:30.128 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (group_id IS NOT NULL) |
| 15:17:30.128 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (sales_id IS NOT NULL) |
| 15:17:30.128 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (group_id IS NOT NULL) |
| 15:17:30.129 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (sales_id IS NOT NULL) |
| 15:17:30.129 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5299 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:17:30.129 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (group_id IS NOT NULL) |
| 15:17:30.130 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (sales_id IS NOT NULL) |
| 15:17:30.130 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) 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:17:30.131 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (group_id IS NOT NULL) |
| 15:17:30.132 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (sales_id IS NOT NULL) |
| 15:17:30.132 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5295, 1001, 1003, 1006, 5062, 1005, 5074, 5087, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5299, 5294, 5294, 5301, 5300, 5302, 5303, 5304, 5309, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.133 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (group_id IS NOT NULL) |
| 15:17:30.133 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (sales_id IS NOT NULL) |
| 15:17:30.134 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5303 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:17:30.134 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (group_id IS NOT NULL) |
| 15:17:30.134 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (sales_id IS NOT NULL) |
| 15:17:30.135 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5302 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:17:30.135 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (group_id IS NOT NULL) |
| 15:17:30.135 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (sales_id IS NOT NULL) |
| 15:17:30.136 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5064, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.136 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (group_id IS NOT NULL) |
| 15:17:30.137 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (sales_id IS NOT NULL) |
| 15:17:30.137 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5332 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:17:30.138 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (group_id IS NOT NULL) |
| 15:17:30.138 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (sales_id IS NOT NULL) |
| 15:17:30.138 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5047 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:17:30.139 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (group_id IS NOT NULL) |
| 15:17:30.139 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (sales_id IS NOT NULL) |
| 15:17:30.139 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (group_id IS NOT NULL) |
| 15:17:30.140 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (sales_id IS NOT NULL) |
| 15:17:30.140 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5072, 5088, 5295, 5062, 5096, 1004, 1001, 1003, 5026, 1005, 1006, 1008, 5087, 5089, 5299, 5076, 5093, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5295, 5229, 5230, 5302, 5304, 5309, 5294, 5294, 5301, 5300, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.141 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (group_id IS NOT NULL) |
| 15:17:30.141 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (sales_id IS NOT NULL) |
| 15:17:30.142 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1026 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:17:30.142 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (group_id IS NOT NULL) |
| 15:17:30.142 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.143 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.143 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5259) AND (group_id IS NOT NULL) |
| 15:17:30.144 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (sales_id IS NOT NULL) |
| 15:17:30.144 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (group_id IS NOT NULL) |
| 15:17:30.145 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.145 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.146 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1012) AND (group_id IS NOT NULL) |
| 15:17:30.146 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (sales_id IS NOT NULL) |
| 15:17:30.147 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1004, 1005, 1006, 5096, 5295, 5299, 5300, 5301, 5302, 5303, 5094, 1003, 1008, 5026, 5062, 5072, 5074, 5076, 5087, 5088, 5089, 5093, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5304, 5309, 5311, 5329, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.147 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (group_id IS NOT NULL) |
| 15:17:30.147 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (sales_id IS NOT NULL) |
| 15:17:30.148 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5096 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:17:30.148 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (group_id IS NOT NULL) |
| 15:17:30.149 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (sales_id IS NOT NULL) |
| 15:17:30.149 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5070 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:17:30.149 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (group_id IS NOT NULL) |
| 15:17:30.150 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (sales_id IS NOT NULL) |
| 15:17:30.150 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5448 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:17:30.150 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (group_id IS NOT NULL) |
| 15:17:30.151 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (sales_id IS NOT NULL) |
| 15:17:30.151 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5074, 5087, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096, 5295, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5299, 5294, 5294, 5300, 5301, 5302, 5303, 5304, 5309, 5311, 5329, 5094, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.152 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (group_id IS NOT NULL) |
| 15:17:30.152 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (sales_id IS NOT NULL) |
| 15:17:30.153 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (group_id IS NOT NULL) |
| 15:17:30.153 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.154 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.154 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5095) AND (group_id IS NOT NULL) |
| 15:17:30.155 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (sales_id IS NOT NULL) |
| 15:17:30.155 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5420 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:17:30.155 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (group_id IS NOT NULL) |
| 15:17:30.156 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (sales_id IS NOT NULL) |
| 15:17:30.156 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (group_id IS NOT NULL) |
| 15:17:30.157 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (sales_id IS NOT NULL) |
| 15:17:30.157 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5087, 1001, 1003, 1006, 1005, 1008, 5026, 1004, 5076, 5072, 5088, 5062, 5295, 5089, 5096, 5093, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5302, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5304, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.158 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (group_id IS NOT NULL) |
| 15:17:30.158 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (sales_id IS NOT NULL) |
| 15:17:30.158 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (group_id IS NOT NULL) |
| 15:17:30.159 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (sales_id IS NOT NULL) |
| 15:17:30.159 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1029 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:17:30.159 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (group_id IS NOT NULL) |
| 15:17:30.160 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (sales_id IS NOT NULL) |
| 15:17:30.160 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (group_id IS NOT NULL) |
| 15:17:30.161 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (sales_id IS NOT NULL) |
| 15:17:30.161 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (group_id IS NOT NULL) |
| 15:17:30.161 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.162 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.162 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1001) AND (group_id IS NOT NULL) |
| 15:17:30.163 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (sales_id IS NOT NULL) |
| 15:17:30.163 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5037 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:17:30.164 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (group_id IS NOT NULL) |
| 15:17:30.164 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (sales_id IS NOT NULL) |
| 15:17:30.164 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5087 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:17:30.165 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (group_id IS NOT NULL) |
| 15:17:30.165 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (sales_id IS NOT NULL) |
| 15:17:30.165 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1008 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:17:30.166 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (group_id IS NOT NULL) |
| 15:17:30.166 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (sales_id IS NOT NULL) |
| 15:17:30.167 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) 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:17:30.167 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (group_id IS NOT NULL) |
| 15:17:30.167 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (sales_id IS NOT NULL) |
| 15:17:30.168 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5048 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:17:30.168 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (group_id IS NOT NULL) |
| 15:17:30.169 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (sales_id IS NOT NULL) |
| 15:17:30.169 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5043 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:17:30.169 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (group_id IS NOT NULL) |
| 15:17:30.170 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.170 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.171 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5094) AND (group_id IS NOT NULL) |
| 15:17:30.171 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (sales_id IS NOT NULL) |
| 15:17:30.171 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5045 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:17:30.172 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (group_id IS NOT NULL) |
| 15:17:30.172 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (sales_id IS NOT NULL) |
| 15:17:30.173 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5230 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:17:30.173 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (group_id IS NOT NULL) |
| 15:17:30.173 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (sales_id IS NOT NULL) |
| 15:17:30.174 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5031 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:17:30.174 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (group_id IS NOT NULL) |
| 15:17:30.174 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (sales_id IS NOT NULL) |
| 15:17:30.175 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5088 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:17:30.175 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (group_id IS NOT NULL) |
| 15:17:30.175 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (sales_id IS NOT NULL) |
| 15:17:30.176 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5208 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:17:30.176 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (group_id IS NOT NULL) |
| 15:17:30.177 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (sales_id IS NOT NULL) |
| 15:17:30.177 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1004, 1005, 1006, 5096, 5295, 5299, 5300, 5301, 5302, 5304, 5094, 1003, 5309, 1008, 5026, 5062, 5072, 5074, 5076, 5087, 5088, 5089, 5093, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5303, 5311, 5329, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.178 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (group_id IS NOT NULL) |
| 15:17:30.178 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.178 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.179 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5078) AND (group_id IS NOT NULL) |
| 15:17:30.179 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (sales_id IS NOT NULL) |
| 15:17:30.180 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1003, 5209, 5203) 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:17:30.180 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (group_id IS NOT NULL) |
| 15:17:30.181 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (sales_id IS NOT NULL) |
| 15:17:30.181 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5294 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:17:30.181 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (group_id IS NOT NULL) |
| 15:17:30.182 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (sales_id IS NOT NULL) |
| 15:17:30.182 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5357 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:17:30.182 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (group_id IS NOT NULL) |
| 15:17:30.183 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (sales_id IS NOT NULL) |
| 15:17:30.183 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5044 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:17:30.184 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (group_id IS NOT NULL) |
| 15:17:30.184 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (sales_id IS NOT NULL) |
| 15:17:30.184 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (group_id IS NOT NULL) |
| 15:17:30.185 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.185 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.186 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5351) AND (group_id IS NOT NULL) |
| 15:17:30.186 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (sales_id IS NOT NULL) |
| 15:17:30.186 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1030 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:17:30.187 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (group_id IS NOT NULL) |
| 15:17:30.187 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (sales_id IS NOT NULL) |
| 15:17:30.188 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5076 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:17:30.188 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (group_id IS NOT NULL) |
| 15:17:30.188 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.189 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.189 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5135) AND (group_id IS NOT NULL) |
| 15:17:30.190 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (sales_id IS NOT NULL) |
| 15:17:30.190 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5300, 5309, 5311) 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:17:30.190 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (group_id IS NOT NULL) |
| 15:17:30.191 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (sales_id IS NOT NULL) |
| 15:17:30.191 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1007 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:17:30.192 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (group_id IS NOT NULL) |
| 15:17:30.192 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (sales_id IS NOT NULL) |
| 15:17:30.192 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5027 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:17:30.193 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (group_id IS NOT NULL) |
| 15:17:30.193 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (sales_id IS NOT NULL) |
| 15:17:30.193 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5089 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:17:30.194 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (group_id IS NOT NULL) |
| 15:17:30.194 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (sales_id IS NOT NULL) |
| 15:17:30.195 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5311, 1001, 5295, 5300, 5309, 5064, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.195 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (group_id IS NOT NULL) |
| 15:17:30.196 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.196 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.197 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5029) AND (group_id IS NOT NULL) |
| 15:17:30.197 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (sales_id IS NOT NULL) |
| 15:17:30.197 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 1013, 5087, 5409, 1001, 5295, 5300, 5311, 5064, 5329, 5332, 5359, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 5358, 5364, 5412, 5412, 5420, 5420, 5448, 5448, 5449) 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:17:30.198 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (group_id IS NOT NULL) |
| 15:17:30.198 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (sales_id IS NOT NULL) |
| 15:17:30.199 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (group_id IS NOT NULL) |
| 15:17:30.199 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (sales_id IS NOT NULL) |
| 15:17:30.200 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1003, 1008, 1001, 1005, 5026, 1006, 5072, 5088, 5062, 5096, 1004, 5295, 5087, 5089, 5076, 5093, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5295, 5229, 5230, 5302, 5304, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.200 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (group_id IS NOT NULL) |
| 15:17:30.200 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (sales_id IS NOT NULL) |
| 15:17:30.201 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5066 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:17:30.201 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (group_id IS NOT NULL) |
| 15:17:30.202 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (sales_id IS NOT NULL) |
| 15:17:30.202 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5069 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:17:30.202 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (group_id IS NOT NULL) |
| 15:17:30.203 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.203 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.204 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5079) AND (group_id IS NOT NULL) |
| 15:17:30.204 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (sales_id IS NOT NULL) |
| 15:17:30.204 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.205 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (group_id IS NOT NULL) |
| 15:17:30.205 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (sales_id IS NOT NULL) |
| 15:17:30.206 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5364 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:17:30.206 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (group_id IS NOT NULL) |
| 15:17:30.206 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (sales_id IS NOT NULL) |
| 15:17:30.207 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (group_id IS NOT NULL) |
| 15:17:30.207 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (sales_id IS NOT NULL) |
| 15:17:30.208 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1009 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:17:30.208 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (group_id IS NOT NULL) |
| 15:17:30.208 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (sales_id IS NOT NULL) |
| 15:17:30.209 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5295, 5311) 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:17:30.209 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (group_id IS NOT NULL) |
| 15:17:30.209 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (sales_id IS NOT NULL) |
| 15:17:30.210 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.210 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (group_id IS NOT NULL) |
| 15:17:30.211 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (sales_id IS NOT NULL) |
| 15:17:30.211 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.212 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (group_id IS NOT NULL) |
| 15:17:30.212 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (sales_id IS NOT NULL) |
| 15:17:30.213 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.213 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (group_id IS NOT NULL) |
| 15:17:30.214 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (sales_id IS NOT NULL) |
| 15:17:30.214 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5128 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:17:30.214 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (group_id IS NOT NULL) |
| 15:17:30.215 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (sales_id IS NOT NULL) |
| 15:17:30.215 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (group_id IS NOT NULL) |
| 15:17:30.215 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (sales_id IS NOT NULL) |
| 15:17:30.216 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5203 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:17:30.216 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (group_id IS NOT NULL) |
| 15:17:30.216 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (sales_id IS NOT NULL) |
| 15:17:30.217 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1025 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:17:30.217 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (group_id IS NOT NULL) |
| 15:17:30.218 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (sales_id IS NOT NULL) |
| 15:17:30.218 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 1013, 5087, 5412, 1001, 5295, 5300, 5311, 5064, 5329, 5332, 5359, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 5358, 5364, 5409, 5420, 5420, 5448, 5448, 5449) 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:17:30.218 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (group_id IS NOT NULL) |
| 15:17:30.219 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (sales_id IS NOT NULL) |
| 15:17:30.219 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5072, 1001, 1008, 1003, 1006, 1005, 5026, 1004, 5088, 5087, 5295, 5076, 5089, 5093, 5096, 5062, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5295, 5230, 5302, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5304, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.220 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (group_id IS NOT NULL) |
| 15:17:30.220 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (sales_id IS NOT NULL) |
| 15:17:30.221 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) 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:17:30.221 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (group_id IS NOT NULL) |
| 15:17:30.221 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (sales_id IS NOT NULL) |
| 15:17:30.222 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.222 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (group_id IS NOT NULL) |
| 15:17:30.223 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (sales_id IS NOT NULL) |
| 15:17:30.223 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (group_id IS NOT NULL) |
| 15:17:30.224 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (sales_id IS NOT NULL) |
| 15:17:30.224 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5032 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:17:30.225 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (group_id IS NOT NULL) |
| 15:17:30.225 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (sales_id IS NOT NULL) |
| 15:17:30.225 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5075 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:17:30.226 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (group_id IS NOT NULL) |
| 15:17:30.226 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (sales_id IS NOT NULL) |
| 15:17:30.226 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 5329, 5332, 5358, 5359, 5364, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.227 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (group_id IS NOT NULL) |
| 15:17:30.227 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.228 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.228 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5064) AND (group_id IS NOT NULL) |
| 15:17:30.229 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (sales_id IS NOT NULL) |
| 15:17:30.229 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 5049, 5022, 5047, 1026, 5070, 1029, 5037, 5048, 5043, 5045, 5031, 5044, 1030, 1007, 5027, 5066, 5069, 1009, 1025, 5032, 5075, 5033, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.230 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (group_id IS NOT NULL) |
| 15:17:30.230 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.231 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.231 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5025) AND (group_id IS NOT NULL) |
| 15:17:30.232 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (sales_id IS NOT NULL) |
| 15:17:30.232 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (group_id IS NOT NULL) |
| 15:17:30.232 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (sales_id IS NOT NULL) |
| 15:17:30.233 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5072 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:17:30.233 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (group_id IS NOT NULL) |
| 15:17:30.234 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (sales_id IS NOT NULL) |
| 15:17:30.234 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 1005, 1008, 5026, 1004, 5076, 5072, 5088, 5062, 5096, 5074, 5295, 5087, 5089, 5093, 5123, 5128, 5203, 5203, 5295, 5209, 5209, 5208, 5208, 5229, 5230, 5302, 5304, 5309, 5294, 5301, 5294, 5299, 5300, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.235 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (group_id IS NOT NULL) |
| 15:17:30.235 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (sales_id IS NOT NULL) |
| 15:17:30.235 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5033 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:17:30.236 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (group_id IS NOT NULL) |
| 15:17:30.236 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (sales_id IS NOT NULL) |
| 15:17:30.237 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5072, 1008, 1003, 1001, 5026, 1005, 1006, 1004, 5088, 5087, 5076, 5295, 5089, 5062, 5093, 5096, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5302, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5304, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.237 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (group_id IS NOT NULL) |
| 15:17:30.238 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (sales_id IS NOT NULL) |
| 15:17:30.238 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (group_id IS NOT NULL) |
| 15:17:30.238 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (sales_id IS NOT NULL) |
| 15:17:30.239 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5359 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:17:30.239 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (group_id IS NOT NULL) |
| 15:17:30.239 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.240 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.240 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5104) AND (group_id IS NOT NULL) |
| 15:17:30.241 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (sales_id IS NOT NULL) |
| 15:17:30.241 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 5332, 5329, 5357, 5358, 5359, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.242 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (group_id IS NOT NULL) |
| 15:17:30.242 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (sales_id IS NOT NULL) |
| 15:17:30.243 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5064, 1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.243 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (group_id IS NOT NULL) |
| 15:17:30.244 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.244 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.245 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5393) AND (group_id IS NOT NULL) |
| 15:17:30.245 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (sales_id IS NOT NULL) |
| 15:17:30.245 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5409 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:17:30.246 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (group_id IS NOT NULL) |
| 15:17:30.246 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.247 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.247 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5412) AND (group_id IS NOT NULL) |
| 15:17:30.247 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (sales_id IS NOT NULL) |
| 15:17:30.248 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5332, 5329, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.249 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (group_id IS NOT NULL) |
| 15:17:30.249 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (sales_id IS NOT NULL) |
| 15:17:30.249 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5229 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:17:30.250 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (group_id IS NOT NULL) |
| 15:17:30.250 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (sales_id IS NOT NULL) |
| 15:17:30.250 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1005, 1004, 1013, 5087, 1001, 5295, 5300, 5311, 5329, 5332, 5359, 5364, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 5358, 5049, 5022, 5047, 1026, 5070, 1029, 5037, 5048, 5043, 5045, 5031, 5044, 1030, 1007, 5027, 5066, 5069, 1009, 1025, 5032, 5075, 5033, 5409, 5409, 5409, 5412, 5412, 5412, 5420, 5420, 5420, 5448, 5448, 5448, 5449, 5449) 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:17:30.251 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (group_id IS NOT NULL) |
| 15:17:30.252 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (sales_id IS NOT NULL) |
| 15:17:30.252 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5304 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:17:30.252 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (group_id IS NOT NULL) |
| 15:17:30.253 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (sales_id IS NOT NULL) |
| 15:17:30.253 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5311, 5064, 5332, 5449, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5329, 5356, 5357, 5358, 5359, 5364, 5409, 5412, 5420, 5448) 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:17:30.254 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (group_id IS NOT NULL) |
| 15:17:30.254 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (sales_id IS NOT NULL) |
| 15:17:30.254 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5449 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:17:30.255 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (group_id IS NOT NULL) |
| 15:17:30.255 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (sales_id IS NOT NULL) |
| 15:17:30.255 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5358 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:17:30.256 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (group_id IS NOT NULL) |
| 15:17:30.256 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (sales_id IS NOT NULL) |
| 15:17:30.257 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.257 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (group_id IS NOT NULL) |
| 15:17:30.257 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (sales_id IS NOT NULL) |
| 15:17:30.258 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1006 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:17:30.258 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (group_id IS NOT NULL) |
| 15:17:30.259 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 15:17:30.259 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5449, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) 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:17:30.260 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5333) AND (group_id IS NOT NULL) |
| 15:17:30.260 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (sales_id IS NOT NULL) |
| 15:17:30.260 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1004, 1005, 1006, 5096, 5295, 5299, 5300, 5301, 5302, 5303, 5094, 1003, 1008, 5026, 5062, 5072, 5074, 5076, 5087, 5088, 5089, 5093, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5304, 5309, 5064, 5311, 5329, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.261 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (group_id IS NOT NULL) |
| 15:17:30.261 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (sales_id IS NOT NULL) |
| 15:17:30.262 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449) 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:17:30.262 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (group_id IS NOT NULL) |
| 15:17:30.263 | info | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (sales_id IS NOT NULL) |
| 15:17:30.263 | info | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5093 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:17:30.264 | info | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (group_id IS NOT NULL) |
| 15:17:30.264 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 15:17:30.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:17:30.265 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: manageSetting |
| 15:17:30.265 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:17:30.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.266 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.267 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.267 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:17:30.267 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-role', '{"page":"1","web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":{"list":[{"id":77,"name":"Admin","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u7cfb\u7edf\u7ba1\u7406\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2017-01-13 17:56:37","visible":true,"editable":false,"deletable":false,"order":-100,"system":true,"display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458","can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":78,"name":"GM","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u603b\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:53:13","visible":true,"editable":true,"deletable":false,"order":-90,"system":true,"display_name":"\u603b\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":79,"name":"Engineer","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5de5\u7a0b\u5e08)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2025-08-11 15:17:10","visible":true,"editable":true,"deletable":false,"order":-40,"system":true,"display_name":"\u5de5\u7a0b\u5e08","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":81,"name":"AccountManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-03-19 19:16:23","visible":true,"editable":true,"deletable":false,"order":-50,"system":true,"display_name":"\u5ba2\u6237\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":82,"name":"TechDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6280\u672f\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:54:26","visible":true,"editable":true,"deletable":false,"order":-70,"system":true,"display_name":"\u6280\u672f\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":83,"name":"SalesManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-04-25 22:24:33","visible":true,"editable":true,"deletable":false,"order":-60,"system":true,"display_name":"\u9500\u552e\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":84,"name":"SalesDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-03-21 07:10:24","visible":true,"editable":true,"deletable":false,"order":-80,"system":true,"display_name":"\u9500\u552e\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":85,"name":"CommercialAttache","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5546\u52a1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2025-04-28 15:30:46","visible":true,"editable":true,"deletable":false,"order":-20,"system":true,"display_name":"\u5546\u52a1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":92,"name":"ProjectManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9879\u76ee\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2025-04-08 17:21:57","visible":true,"editable":true,"deletable":false,"order":-9,"system":true,"display_name":"\u9879\u76ee\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":86,"name":"StoreKeeper","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5e93\u7ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-27 11:24:21","updated_at":"2024-08-22 16:14:58","visible":true,"editable":true,"deletable":false,"order":-10,"system":true,"display_name":"\u5e93\u7ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":99,"name":"Accountant","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u4f1a\u8ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2017-04-25 23:29:27","updated_at":"2025-08-08 19:04:54","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u4f1a\u8ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":161,"name":"Dispatcher","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6d3e\u5355\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2018-09-18 10:46:37","updated_at":"2022-11-07 17:37:14","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u6d3e\u5355\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":175,"name":"Operator","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u8fd0\u8425)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2019-12-02 18:25:10","updated_at":"2022-11-07 17:55:50","visible":true,"editable":true,"deletable":false,"order":-7,"system":true,"display_name":"\u5ba2\u6237\u8fd0\u8425","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":283,"name":"Treasurer","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u8d22\u52a1\u4eba\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2025-08-04 10:34:21","updated_at":"2025-08-11 15:17:29","visible":true,"editable":true,"deletable":false,"order":-20,"system":true,"display_name":"\u8d22\u52a1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":101,"name":"\u8f6f\u4ef6\u5f00\u53d1","type":1,"description":"","rule_name":"","data":"","created_at":"2017-05-25 16:47:52","updated_at":"2024-11-07 21:01:21","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8f6f\u4ef6\u5f00\u53d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":110,"name":"\u4eba\u529b\u8d44\u6e90","type":1,"description":"","rule_name":"","data":"","created_at":"2017-09-06 17:54:48","updated_at":"2025-04-10 10:37:21","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u4eba\u529b\u8d44\u6e90","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":174,"name":"\u7535\u8bdd\u9500\u552e","type":1,"description":"","rule_name":"","data":"","created_at":"2019-10-08 09:18:30","updated_at":"2022-11-07 17:56:59","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u7535\u8bdd\u9500\u552e","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":182,"name":"\u8fd0\u8425\u603b\u76d1","type":1,"description":"","rule_name":"","data":"","created_at":"2019-12-03 19:52:10","updated_at":"2022-11-07 17:57:11","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8fd0\u8425\u603b\u76d1","can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":18,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-11 15:17:30') RETURNING "id" |
| 15:17:30.269 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:17:30.269 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |