689157690c39c: POST https://beta.jinchangxiao.com/vue/history/list-module at 2025-08-05 08:59:21 am by 124.64.23.198
Performance Profiling
Total processing time: 914 ms; Peak memory: 8.042 MB. Show Profiling Timeline
总计414条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 08:59:21.925 | 16.8 ms | yii\db\Command::query | SELECT "user_id", "object_type", sum(num) as num FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1000) AND ("object_type" != 24) AND ("object_type" != 29) AND ("visit_date" >= '2025-07-21') AND ("object_type" IN (23, 9, 21, 10, 22, 1, 19, 20, 37, 18, 101, 34, 7, 11, 12, 13, 25, 26, 16, 28, 29, 30, 10004)) GROUP BY "user_id", "object_type" ORDER BY "num" DESC LIMIT 10 |
| 08:59:21.944 | 13.6 ms | 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', 1000, 5, 'vue/history/list-module', '{"web_access_token":"DkSM59AGtfUwbJa1Lr7tT74KmdPG8nsg"}', '{"code":2000,"result":{"list":[{"id":30,"title":"\u7cfb\u7edf\u8bbe\u7f6e","icon":"icon-xitongshezhi","appName":"settings","isRouteShow":1,"url":"\/setting"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-05 08:59:21') RETURNING "id" |
| 08:59:21.325 | 12.6 ms | 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" |
| 08:59:21.449 | 12.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (sales_id IS NOT NULL) |
| 08:59:21.112 | 12.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5083) AND (group_id IS NOT NULL) |
| 08:59:21.224 | 9.9 ms | 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 |
| 08:59:21.552 | 9.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (group_id IS NOT NULL) |
| 08:59:21.732 | 8.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (group_id IS NOT NULL) |
| 08:59:21.419 | 8.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (sales_id IS NOT NULL) |
| 08:59:21.485 | 8.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (group_id IS NOT NULL) |
| 08:59:21.311 | 7.7 ms | 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 |
| 08:59:21.363 | 7.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (group_id IS NOT NULL) |
| 08:59:21.173 | 7.6 ms | 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 |
| 08:59:21.200 | 7.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (sales_id IS NOT NULL) |
| 08:59:21.441 | 7.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (group_id IS NOT NULL) |
| 08:59:21.397 | 7.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (sales_id IS NOT NULL) |
| 08:59:21.386 | 7.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (group_id IS NOT NULL) |
| 08:59:21.535 | 6.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (sales_id IS NOT NULL) |
| 08:59:21.773 | 6.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (group_id IS NOT NULL) |
| 08:59:21.839 | 6.8 ms | 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 |
| 08:59:21.500 | 6.7 ms | 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 |
| 08:59:21.163 | 6.6 ms | 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" |
| 08:59:21.188 | 6.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5030) AND (group_id IS NOT NULL) |
| 08:59:21.477 | 6.1 ms | 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 |
| 08:59:21.406 | 5.9 ms | 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 |
| 08:59:21.873 | 5.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (sales_id IS NOT NULL) |
| 08:59:21.544 | 5.9 ms | 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 |
| 08:59:21.300 | 5.9 ms | 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" |
| 08:59:21.782 | 5.7 ms | 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" |
| 08:59:21.155 | 5.5 ms | 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 |
| 08:59:21.082 | 5.4 ms | 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" |
| 08:59:21.292 | 5.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (group_id IS NOT NULL) |
| 08:59:21.520 | 5.2 ms | 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 |
| 08:59:21.864 | 5.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (group_id IS NOT NULL) |
| 08:59:21.495 | 4.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (sales_id IS NOT NULL) |
| 08:59:21.603 | 4.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (sales_id IS NOT NULL) |
| 08:59:21.432 | 4.9 ms | 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 |
| 08:59:21.273 | 4.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (sales_id IS NOT NULL) |
| 08:59:21.266 | 4.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5016) AND (group_id IS NOT NULL) |
| 08:59:21.850 | 4.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5412) AND (group_id IS NOT NULL) |
| 08:59:21.350 | 4.5 ms | 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 |
| 08:59:21.527 | 4.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (group_id IS NOT NULL) |
| 08:59:21.063 | 4.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 08:59:21.053 | 4.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 08:59:21.573 | 4.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (group_id IS NOT NULL) |
| 08:59:21.356 | 4.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (group_id IS NOT NULL) |
| 08:59:21.511 | 3.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (group_id IS NOT NULL) |
| 08:59:21.057 | 3.9 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1000 |
| 08:59:21.591 | 3.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1012) AND (group_id IS NOT NULL) |
| 08:59:21.791 | 3.8 ms | 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 |
| 08:59:21.241 | 3.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (sales_id IS NOT NULL) |
| 08:59:21.257 | 3.6 ms | 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" |
| 08:59:21.321 | 3.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5065) AND (group_id IS NOT NULL) |
| 08:59:21.246 | 3.0 ms | 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 |
| 08:59:21.261 | 2.9 ms | 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 |
| 08:59:21.218 | 2.9 ms | 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" |
| 08:59:21.210 | 2.8 ms | 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 |
| 08:59:21.235 | 2.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5250) AND (group_id IS NOT NULL) |
| 08:59:21.597 | 2.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (sales_id IS NOT NULL) |
| 08:59:21.880 | 2.6 ms | 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 |
| 08:59:21.722 | 2.5 ms | 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 |
| 08:59:21.071 | 2.5 ms | 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 |
| 08:59:21.253 | 2.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (group_id IS NOT NULL) |
| 08:59:21.076 | 2.4 ms | 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 |
| 08:59:21.715 | 2.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (sales_id IS NOT NULL) |
| 08:59:21.587 | 2.4 ms | 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 |
| 08:59:21.069 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_groups" ORDER BY "level", "id" |
| 08:59:21.517 | 2.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (sales_id IS NOT NULL) |
| 08:59:21.690 | 2.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (sales_id IS NOT NULL) |
| 08:59:21.361 | 2.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (sales_id IS NOT NULL) |
| 08:59:21.468 | 2.0 ms | 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 |
| 08:59:21.279 | 2.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (group_id IS NOT NULL) |
| 08:59:21.472 | 2.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (group_id IS NOT NULL) |
| 08:59:21.140 | 2.0 ms | 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 |
| 08:59:21.814 | 1.9 ms | 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" |
| 08:59:21.384 | 1.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (sales_id IS NOT NULL) |
| 08:59:21.080 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" |
| 08:59:21.827 | 1.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (group_id IS NOT NULL) |
| 08:59:21.104 | 1.8 ms | 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 |
| 08:59:21.697 | 1.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (group_id IS NOT NULL) |
| 08:59:21.099 | 1.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (group_id IS NOT NULL) |
| 08:59:21.570 | 1.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (group_id IS NOT NULL) |
| 08:59:21.342 | 1.7 ms | 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 |
| 08:59:21.811 | 1.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (group_id IS NOT NULL) |
| 08:59:21.566 | 1.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (sales_id IS NOT NULL) |
| 08:59:21.089 | 1.7 ms | 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 |
| 08:59:21.216 | 1.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (group_id IS NOT NULL) |
| 08:59:21.092 | 1.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (sales_id IS NOT NULL) |
| 08:59:21.666 | 1.5 ms | 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 |
| 08:59:21.601 | 1.4 ms | 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 |
| 08:59:21.130 | 1.4 ms | 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 |
| 08:59:21.199 | 1.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (group_id IS NOT NULL) |
| 08:59:21.804 | 1.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (sales_id IS NOT NULL) |
| 08:59:21.806 | 1.4 ms | 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 |
| 08:59:21.713 | 1.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (group_id IS NOT NULL) |
| 08:59:21.830 | 1.4 ms | 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" |
| 08:59:21.161 | 1.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (group_id IS NOT NULL) |
| 08:59:21.475 | 1.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (sales_id IS NOT NULL) |
| 08:59:21.094 | 1.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (group_id IS NOT NULL) |
| 08:59:21.893 | 1.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (group_id IS NOT NULL) |
| 08:59:21.692 | 1.3 ms | 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 |
| 08:59:21.748 | 1.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (group_id IS NOT NULL) |
| 08:59:21.883 | 1.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (group_id IS NOT NULL) |
| 08:59:21.097 | 1.2 ms | 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 |
| 08:59:21.129 | 1.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (sales_id IS NOT NULL) |
| 08:59:21.725 | 1.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (group_id IS NOT NULL) |
| 08:59:21.885 | 1.1 ms | 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 |
| 08:59:21.125 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (sales_id IS NOT NULL) |
| 08:59:21.110 | 1.1 ms | 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 |
| 08:59:21.107 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1000) AND (group_id IS NOT NULL) |
| 08:59:21.818 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (sales_id IS NOT NULL) |
| 08:59:21.670 | 1.1 ms | 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 |
| 08:59:21.096 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (sales_id IS NOT NULL) |
| 08:59:21.250 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (group_id IS NOT NULL) |
| 08:59:21.710 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (sales_id IS NOT NULL) |
| 08:59:21.108 | 1.1 ms | 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" |
| 08:59:21.749 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (sales_id IS NOT NULL) |
| 08:59:21.136 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (sales_id IS NOT NULL) |
| 08:59:21.138 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (sales_id IS NOT NULL) |
| 08:59:21.290 | 1.0 ms | 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 |
| 08:59:21.196 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (sales_id IS NOT NULL) |
| 08:59:21.344 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1002) AND (group_id IS NOT NULL) |
| 08:59:21.146 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (sales_id IS NOT NULL) |
| 08:59:21.695 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (group_id IS NOT NULL) |
| 08:59:21.148 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (sales_id IS NOT NULL) |
| 08:59:21.861 | 1.0 ms | 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 |
| 08:59:21.770 | 1.0 ms | 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 |
| 08:59:21.128 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (group_id IS NOT NULL) |
| 08:59:21.147 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (group_id IS NOT NULL) |
| 08:59:21.416 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (group_id IS NOT NULL) |
| 08:59:21.381 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (group_id IS NOT NULL) |
| 08:59:21.856 | 1.0 ms | 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 |
| 08:59:21.688 | 1.0 ms | 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 |
| 08:59:21.346 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (sales_id IS NOT NULL) |
| 08:59:21.766 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (group_id IS NOT NULL) |
| 08:59:21.614 | 0.9 ms | 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 |
| 08:59:21.572 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (sales_id IS NOT NULL) |
| 08:59:21.660 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (group_id IS NOT NULL) |
| 08:59:21.379 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (sales_id IS NOT NULL) |
| 08:59:21.718 | 0.9 ms | 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 |
| 08:59:21.102 | 0.9 ms | 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" |
| 08:59:21.197 | 0.9 ms | 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 |
| 08:59:21.892 | 0.9 ms | 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 |
| 08:59:21.817 | 0.9 ms | 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 |
| 08:59:21.135 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (group_id IS NOT NULL) |
| 08:59:21.578 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (sales_id IS NOT NULL) |
| 08:59:21.380 | 0.8 ms | 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 |
| 08:59:21.897 | 0.8 ms | 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 |
| 08:59:21.753 | 0.8 ms | 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 |
| 08:59:21.145 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (group_id IS NOT NULL) |
| 08:59:21.706 | 0.8 ms | 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 |
| 08:59:21.631 | 0.8 ms | 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 |
| 08:59:21.137 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (group_id IS NOT NULL) |
| 08:59:21.657 | 0.8 ms | 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 |
| 08:59:21.664 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (group_id IS NOT NULL) |
| 08:59:21.583 | 0.8 ms | 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 |
| 08:59:21.676 | 0.8 ms | 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 |
| 08:59:21.579 | 0.8 ms | 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 |
| 08:59:21.824 | 0.8 ms | 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 |
| 08:59:21.251 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (sales_id IS NOT NULL) |
| 08:59:21.618 | 0.8 ms | 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 |
| 08:59:21.767 | 0.8 ms | 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 |
| 08:59:21.644 | 0.8 ms | 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 |
| 08:59:21.586 | 0.8 ms | 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" |
| 08:59:21.661 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (sales_id IS NOT NULL) |
| 08:59:21.707 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (sales_id IS NOT NULL) |
| 08:59:21.765 | 0.7 ms | 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 |
| 08:59:21.127 | 0.7 ms | 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 |
| 08:59:21.757 | 0.7 ms | 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 |
| 08:59:21.801 | 0.7 ms | 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 |
| 08:59:21.820 | 0.7 ms | 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 |
| 08:59:21.884 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (sales_id IS NOT NULL) |
| 08:59:21.655 | 0.7 ms | 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 |
| 08:59:21.624 | 0.7 ms | 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 |
| 08:59:21.822 | 0.7 ms | 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 |
| 08:59:21.700 | 0.7 ms | 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 |
| 08:59:21.759 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (sales_id IS NOT NULL) |
| 08:59:21.708 | 0.7 ms | 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 |
| 08:59:21.728 | 0.7 ms | 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 |
| 08:59:21.756 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (group_id IS NOT NULL) |
| 08:59:21.686 | 0.7 ms | 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 |
| 08:59:21.730 | 0.7 ms | 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 |
| 08:59:21.762 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (sales_id IS NOT NULL) |
| 08:59:21.802 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (sales_id IS NOT NULL) |
| 08:59:21.750 | 0.7 ms | 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 |
| 08:59:21.900 | 0.7 ms | 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 |
| 08:59:21.612 | 0.7 ms | 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 |
| 08:59:21.902 | 0.6 ms | 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 |
| 08:59:21.899 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (sales_id IS NOT NULL) |
| 08:59:21.889 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (group_id IS NOT NULL) |
| 08:59:21.602 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (group_id IS NOT NULL) |
| 08:59:21.754 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (group_id IS NOT NULL) |
| 08:59:21.905 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 08:59:21.798 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (sales_id IS NOT NULL) |
| 08:59:21.821 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (sales_id IS NOT NULL) |
| 08:59:21.729 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (sales_id IS NOT NULL) |
| 08:59:21.626 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (sales_id IS NOT NULL) |
| 08:59:21.769 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (sales_id IS NOT NULL) |
| 08:59:21.667 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (group_id IS NOT NULL) |
| 08:59:21.621 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (group_id IS NOT NULL) |
| 08:59:21.891 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (sales_id IS NOT NULL) |
| 08:59:21.727 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (sales_id IS NOT NULL) |
| 08:59:21.701 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (sales_id IS NOT NULL) |
| 08:59:21.284 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (sales_id IS NOT NULL) |
| 08:59:21.623 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (sales_id IS NOT NULL) |
| 08:59:21.699 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (sales_id IS NOT NULL) |
| 08:59:21.754 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (sales_id IS NOT NULL) |
| 08:59:21.857 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (group_id IS NOT NULL) |
| 08:59:21.722 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (sales_id IS NOT NULL) |
| 08:59:21.752 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (sales_id IS NOT NULL) |
| 08:59:21.654 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (sales_id IS NOT NULL) |
| 08:59:21.858 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (sales_id IS NOT NULL) |
| 08:59:21.584 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (sales_id IS NOT NULL) |
| 08:59:21.646 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (sales_id IS NOT NULL) |
| 08:59:21.756 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (sales_id IS NOT NULL) |
| 08:59:21.901 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (sales_id IS NOT NULL) |
| 08:59:21.678 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (sales_id IS NOT NULL) |
| 08:59:21.681 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (sales_id IS NOT NULL) |
| 08:59:21.895 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (sales_id IS NOT NULL) |
| 08:59:21.855 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (sales_id IS NOT NULL) |
| 08:59:21.672 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (sales_id IS NOT NULL) |
| 08:59:21.720 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (sales_id IS NOT NULL) |
| 08:59:21.728 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (group_id IS NOT NULL) |
| 08:59:21.580 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (sales_id IS NOT NULL) |
| 08:59:21.808 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (sales_id IS NOT NULL) |
| 08:59:21.635 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (sales_id IS NOT NULL) |
| 08:59:21.889 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (sales_id IS NOT NULL) |
| 08:59:21.647 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (sales_id IS NOT NULL) |
| 08:59:21.611 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (sales_id IS NOT NULL) |
| 08:59:21.622 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (sales_id IS NOT NULL) |
| 08:59:21.636 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (sales_id IS NOT NULL) |
| 08:59:21.903 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (sales_id IS NOT NULL) |
| 08:59:21.685 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (sales_id IS NOT NULL) |
| 08:59:21.696 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (sales_id IS NOT NULL) |
| 08:59:21.620 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (sales_id IS NOT NULL) |
| 08:59:21.744 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (sales_id IS NOT NULL) |
| 08:59:21.860 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (sales_id IS NOT NULL) |
| 08:59:21.614 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (sales_id IS NOT NULL) |
| 08:59:21.625 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (sales_id IS NOT NULL) |
| 08:59:21.802 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (group_id IS NOT NULL) |
| 08:59:21.638 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (sales_id IS NOT NULL) |
| 08:59:21.286 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (sales_id IS NOT NULL) |
| 08:59:21.629 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (sales_id IS NOT NULL) |
| 08:59:21.760 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (sales_id IS NOT NULL) |
| 08:59:21.891 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (group_id IS NOT NULL) |
| 08:59:21.653 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (sales_id IS NOT NULL) |
| 08:59:21.743 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (sales_id IS NOT NULL) |
| 08:59:21.746 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (sales_id IS NOT NULL) |
| 08:59:21.649 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (sales_id IS NOT NULL) |
| 08:59:21.651 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (sales_id IS NOT NULL) |
| 08:59:21.616 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (sales_id IS NOT NULL) |
| 08:59:21.741 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (sales_id IS NOT NULL) |
| 08:59:21.764 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (sales_id IS NOT NULL) |
| 08:59:21.628 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (sales_id IS NOT NULL) |
| 08:59:21.896 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (group_id IS NOT NULL) |
| 08:59:21.807 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (group_id IS NOT NULL) |
| 08:59:21.633 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (sales_id IS NOT NULL) |
| 08:59:21.742 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (group_id IS NOT NULL) |
| 08:59:21.654 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (group_id IS NOT NULL) |
| 08:59:21.580 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (group_id IS NOT NULL) |
| 08:59:21.818 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5104) AND (group_id IS NOT NULL) |
| 08:59:21.669 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (group_id IS NOT NULL) |
| 08:59:21.797 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (sales_id IS NOT NULL) |
| 08:59:21.681 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (group_id IS NOT NULL) |
| 08:59:21.823 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (group_id IS NOT NULL) |
| 08:59:21.800 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (sales_id IS NOT NULL) |
| 08:59:21.642 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (sales_id IS NOT NULL) |
| 08:59:21.744 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (group_id IS NOT NULL) |
| 08:59:21.615 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (group_id IS NOT NULL) |
| 08:59:21.625 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (group_id IS NOT NULL) |
| 08:59:21.677 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5135) AND (group_id IS NOT NULL) |
| 08:59:21.758 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (group_id IS NOT NULL) |
| 08:59:21.584 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5259) AND (group_id IS NOT NULL) |
| 08:59:21.796 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5025) AND (group_id IS NOT NULL) |
| 08:59:21.286 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (group_id IS NOT NULL) |
| 08:59:21.859 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (group_id IS NOT NULL) |
| 08:59:21.647 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (group_id IS NOT NULL) |
| 08:59:21.721 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (group_id IS NOT NULL) |
| 08:59:21.383 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (sales_id IS NOT NULL) |
| 08:59:21.797 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (group_id IS NOT NULL) |
| 08:59:21.898 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5333) AND (group_id IS NOT NULL) |
| 08:59:21.610 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (sales_id IS NOT NULL) |
| 08:59:21.613 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (group_id IS NOT NULL) |
| 08:59:21.682 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (group_id IS NOT NULL) |
| 08:59:21.617 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (group_id IS NOT NULL) |
| 08:59:21.673 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (group_id IS NOT NULL) |
| 08:59:21.288 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (sales_id IS NOT NULL) |
| 08:59:21.628 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (group_id IS NOT NULL) |
| 08:59:21.649 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (group_id IS NOT NULL) |
| 08:59:21.679 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (group_id IS NOT NULL) |
| 08:59:21.680 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (sales_id IS NOT NULL) |
| 08:59:21.636 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (group_id IS NOT NULL) |
| 08:59:21.638 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (group_id IS NOT NULL) |
| 08:59:21.768 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5064) AND (group_id IS NOT NULL) |
| 08:59:21.622 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (group_id IS NOT NULL) |
| 08:59:21.683 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (sales_id IS NOT NULL) |
| 08:59:21.887 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (sales_id IS NOT NULL) |
| 08:59:21.763 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (group_id IS NOT NULL) |
| 08:59:21.656 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (group_id IS NOT NULL) |
| 08:59:21.709 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (group_id IS NOT NULL) |
| 08:59:21.804 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (group_id IS NOT NULL) |
| 08:59:21.582 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (group_id IS NOT NULL) |
| 08:59:21.674 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (sales_id IS NOT NULL) |
| 08:59:21.809 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (sales_id IS NOT NULL) |
| 08:59:21.634 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (group_id IS NOT NULL) |
| 08:59:21.609 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (group_id IS NOT NULL) |
| 08:59:21.626 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (group_id IS NOT NULL) |
| 08:59:21.632 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1001) AND (group_id IS NOT NULL) |
| 08:59:21.639 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (group_id IS NOT NULL) |
| 08:59:21.703 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (sales_id IS NOT NULL) |
| 08:59:21.712 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (sales_id IS NOT NULL) |
| 08:59:21.826 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (sales_id IS NOT NULL) |
| 08:59:21.820 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (group_id IS NOT NULL) |
| 08:59:21.901 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (group_id IS NOT NULL) |
| 08:59:21.665 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (sales_id IS NOT NULL) |
| 08:59:21.630 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (group_id IS NOT NULL) |
| 08:59:21.640 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (sales_id IS NOT NULL) |
| 08:59:21.629 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (group_id IS NOT NULL) |
| 08:59:21.746 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (group_id IS NOT NULL) |
| 08:59:21.675 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (group_id IS NOT NULL) |
| 08:59:21.585 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (group_id IS NOT NULL) |
| 08:59:21.799 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (group_id IS NOT NULL) |
| 08:59:21.643 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (group_id IS NOT NULL) |
| 08:59:21.650 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (group_id IS NOT NULL) |
| 08:59:21.652 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (group_id IS NOT NULL) |
| 08:59:21.383 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (group_id IS NOT NULL) |
| 08:59:21.659 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (sales_id IS NOT NULL) |
| 08:59:21.671 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5351) AND (group_id IS NOT NULL) |
| 08:59:21.287 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (group_id IS NOT NULL) |
| 08:59:21.619 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5095) AND (group_id IS NOT NULL) |
| 08:59:21.645 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5094) AND (group_id IS NOT NULL) |
| 08:59:21.760 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (group_id IS NOT NULL) |
| 08:59:21.611 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (group_id IS NOT NULL) |
| 08:59:21.663 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (sales_id IS NOT NULL) |
| 08:59:21.686 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (group_id IS NOT NULL) |
| 08:59:21.825 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5393) AND (group_id IS NOT NULL) |
| 08:59:21.639 | 0.5 ms | 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 |
| 08:59:21.703 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (group_id IS NOT NULL) |
| 08:59:21.689 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5029) AND (group_id IS NOT NULL) |
| 08:59:21.707 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5079) AND (group_id IS NOT NULL) |
| 08:59:21.712 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (group_id IS NOT NULL) |
| 08:59:21.701 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (group_id IS NOT NULL) |
| 08:59:21.755 | 0.4 ms | 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 |
| 08:59:21.888 | 0.4 ms | 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 |
| 08:59:21.719 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (group_id IS NOT NULL) |
| 08:59:21.761 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (group_id IS NOT NULL) |
| 08:59:21.668 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (sales_id IS NOT NULL) |
| 08:59:21.904 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (group_id IS NOT NULL) |
| 08:59:21.252 | 0.4 ms | 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 |
| 08:59:21.684 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (group_id IS NOT NULL) |
| 08:59:21.809 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (group_id IS NOT NULL) |
| 08:59:21.887 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (group_id IS NOT NULL) |
| 08:59:21.568 | 0.4 ms | 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 |
| 08:59:21.704 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (group_id IS NOT NULL) |
| 08:59:21.751 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (group_id IS NOT NULL) |
| 08:59:21.658 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5078) AND (group_id IS NOT NULL) |
| 08:59:21.620 | 0.4 ms | 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 |
| 08:59:21.662 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (group_id IS NOT NULL) |
| 08:59:21.641 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (group_id IS NOT NULL) |
| 08:59:21.903 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (group_id IS NOT NULL) |
| 08:59:21.859 | 0.4 ms | 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 |
| 08:59:21.609 | 0.4 ms | 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 |
| 08:59:21.659 | 0.4 ms | 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 |
| 08:59:21.720 | 0.4 ms | 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 |
| 08:59:21.826 | 0.4 ms | 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 |
| 08:59:21.799 | 0.4 ms | 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 |
| 08:59:21.897 | 0.4 ms | 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" |
| 08:59:21.705 | 0.4 ms | 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" |
| 08:59:21.742 | 0.4 ms | 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 |
| 08:59:21.287 | 0.4 ms | 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 |
| 08:59:21.669 | 0.4 ms | 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" |
| 08:59:21.704 | 0.4 ms | 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 |
| 08:59:21.285 | 0.4 ms | 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 |
| 08:59:21.675 | 0.4 ms | 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" |
| 08:59:21.664 | 0.4 ms | 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 |
| 08:59:21.687 | 0.4 ms | 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" |
| 08:59:21.761 | 0.4 ms | 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 |
| 08:59:21.747 | 0.4 ms | 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 |
| 08:59:21.763 | 0.4 ms | 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 |
| 08:59:21.673 | 0.4 ms | 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 |
| 08:59:21.650 | 0.3 ms | 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 |
| 08:59:21.634 | 0.3 ms | 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 |
| 08:59:21.631 | 0.3 ms | 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" |
| 08:59:21.684 | 0.3 ms | 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 |
| 08:59:21.803 | 0.3 ms | 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 |
| 08:59:21.810 | 0.3 ms | 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 |
| 08:59:21.617 | 0.3 ms | 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" |
| 08:59:21.767 | 0.3 ms | 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" |
| 08:59:21.678 | 0.3 ms | 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 |
| 08:59:21.890 | 0.3 ms | 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 |
| 08:59:21.641 | 0.3 ms | 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 |
| 08:59:21.653 | 0.3 ms | 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 |
| 08:59:21.610 | 0.3 ms | 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 |
| 08:59:21.643 | 0.3 ms | 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" |
| 08:59:21.711 | 0.3 ms | 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 |
| 08:59:21.657 | 0.3 ms | 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" |
| 08:59:21.824 | 0.3 ms | 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" |
| 08:59:21.581 | 0.3 ms | 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 |
| 08:59:21.745 | 0.3 ms | 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 |
| 08:59:21.642 | 0.3 ms | 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 |
| 08:59:21.582 | 0.3 ms | 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" |
| 08:59:21.702 | 0.3 ms | 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 |
| 08:59:21.637 | 0.3 ms | 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 |
| 08:59:21.680 | 0.3 ms | 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 |
| 08:59:21.895 | 0.3 ms | 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 |
| 08:59:21.648 | 0.3 ms | 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 |
| 08:59:21.646 | 0.3 ms | 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 |
| 08:59:21.682 | 0.3 ms | 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 |
| 08:59:21.674 | 0.3 ms | 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 |
| 08:59:21.904 | 0.3 ms | 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 |
| 08:59:21.627 | 0.3 ms | 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 |
| 08:59:21.662 | 0.3 ms | 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 |
| 08:59:21.635 | 0.3 ms | 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 |
| 08:59:21.652 | 0.3 ms | 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 |