68a1421ab0c9f: POST https://beta.jinchangxiao.com/vue/history/list-module at 2025-08-17 10:44:42 am by 114.254.2.139
Performance Profiling
Total processing time: 691 ms; Peak memory: 8.048 MB. Show Profiling Timeline
总计414条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 10:44:43.142 | 10.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 |
| 10:44:42.979 | 9.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (sales_id IS NOT NULL) |
| 10:44:43.090 | 9.9 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 |
| 10:44:43.055 | 9.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 |
| 10:44:42.965 | 9.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (group_id IS NOT NULL) |
| 10:44:43.020 | 9.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (sales_id IS NOT NULL) |
| 10:44:42.926 | 8.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (sales_id IS NOT NULL) |
| 10:44:43.237 | 7.5 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 |
| 10:44:43.009 | 7.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (group_id IS NOT NULL) |
| 10:44:42.917 | 7.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5095) AND (group_id IS NOT NULL) |
| 10:44:43.044 | 6.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" |
| 10:44:43.033 | 6.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (group_id IS NOT NULL) |
| 10:44:42.943 | 6.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (group_id IS NOT NULL) |
| 10:44:43.121 | 6.9 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 |
| 10:44:43.258 | 6.5 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 |
| 10:44:42.797 | 6.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5030) AND (group_id IS NOT NULL) |
| 10:44:43.282 | 6.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (sales_id IS NOT NULL) |
| 10:44:43.246 | 5.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (group_id IS NOT NULL) |
| 10:44:43.271 | 5.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (group_id IS NOT NULL) |
| 10:44:43.080 | 5.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (sales_id IS NOT NULL) |
| 10:44:43.068 | 5.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1001) AND (group_id IS NOT NULL) |
| 10:44:43.103 | 5.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (group_id IS NOT NULL) |
| 10:44:43.210 | 5.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (sales_id IS NOT NULL) |
| 10:44:42.814 | 5.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 |
| 10:44:42.960 | 5.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) |
| 10:44:42.910 | 5.3 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 |
| 10:44:43.199 | 4.7 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 |
| 10:44:43.404 | 4.5 ms | yii\db\Command::query | SELECT "user_id", "object_type", sum(num) as num FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type" != 24) AND ("object_type" != 29) AND ("visit_date" >= '2025-08-02') 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 |
| 10:44:42.994 | 4.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) |
| 10:44:43.001 | 4.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (sales_id IS NOT NULL) |
| 10:44:42.805 | 4.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) |
| 10:44:42.937 | 3.9 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 |
| 10:44:42.730 | 3.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:44:42.753 | 3.8 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, 1002, 5086, 5065, 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, 5409, 5412, 5393, 5015, 5229, 1005, 5304, 5296, 5449, 5358, 1023, 1006, 5333, 5297, 1014, 5093)) AND ("b"."type"=1) ORDER BY "user_id" |
| 10:44:42.989 | 3.5 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 |
| 10:44:42.727 | 3.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 10:44:43.115 | 3.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (sales_id IS NOT NULL) |
| 10:44:43.133 | 3.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (sales_id IS NOT NULL) |
| 10:44:43.204 | 3.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (group_id IS NOT NULL) |
| 10:44:43.154 | 2.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (sales_id IS NOT NULL) |
| 10:44:42.865 | 2.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (group_id IS NOT NULL) |
| 10:44:42.891 | 2.5 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 |
| 10:44:43.255 | 2.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (sales_id IS NOT NULL) |
| 10:44:42.823 | 2.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5250) AND (group_id IS NOT NULL) |
| 10:44:43.162 | 2.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (group_id IS NOT NULL) |
| 10:44:42.736 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:44:42.954 | 2.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (group_id IS NOT NULL) |
| 10:44:43.299 | 2.1 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 |
| 10:44:42.901 | 2.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (group_id IS NOT NULL) |
| 10:44:42.840 | 2.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 |
| 10:44:42.952 | 1.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (sales_id IS NOT NULL) |
| 10:44:43.291 | 1.9 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 |
| 10:44:43.184 | 1.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (group_id IS NOT NULL) |
| 10:44:43.192 | 1.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (group_id IS NOT NULL) |
| 10:44:43.228 | 1.7 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 |
| 10:44:42.874 | 1.7 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 |
| 10:44:42.893 | 1.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (group_id IS NOT NULL) |
| 10:44:42.793 | 1.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (group_id IS NOT NULL) |
| 10:44:42.886 | 1.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 |
| 10:44:42.746 | 1.5 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 |
| 10:44:42.743 | 1.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 |
| 10:44:42.869 | 1.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (group_id IS NOT NULL) |
| 10:44:43.409 | 1.4 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', 1001, 5, 'vue/history/list-module', '{"web_access_token":"J_fTTUvh2jDo6XmPd_9bAXUosEwOz5LJ"}', '{"code":2000,"result":{"list":[{"id":1,"title":"\u5546\u673a\u4fe1\u606f","icon":"icon-shangjixinxi","appName":"project","isRouteShow":1,"url":"\/project"},{"id":13,"title":"\u91c7\u8d2d\u5408\u540c","icon":"icon-caigouhetong","appName":"purchasecost","isRouteShow":1,"url":"\/contract"},{"id":23,"title":"\u7edf\u8ba1\u5206\u6790","icon":"icon-tongjifenxi","appName":"analysis","isRouteShow":1,"url":"\/analysis"},{"id":30,"title":"\u7cfb\u7edf\u8bbe\u7f6e","icon":"icon-xitongshezhi","appName":"settings","isRouteShow":1,"url":"\/setting"},{"id":37,"title":"\u5ba1\u6279\u7ba1\u7406","icon":"icon-shenpi","appName":"approve","isRouteShow":1,"url":"\/approve"},{"id":7,"title":"\u9500\u552e\u5408\u540c","icon":"icon-xiaoshouhetong","appName":"salesContracts","isRouteShow":1,"url":"\/salesContract"},{"id":25,"title":"\u4ea7\u54c1\u4fe1\u606f","icon":"icon-chanpinxinxi","appName":"products","isRouteShow":1,"url":"\/product"},{"id":20,"title":"\u8d39\u7528\u62a5\u9500","icon":"icon-feiyongbaoxiao","appName":"reimbursementManagement","isRouteShow":1,"url":"\/reimbursement"},{"id":10,"title":"\u5ba2\u6237\u4fe1\u606f","icon":" icon-kehuxinxi","appName":"client","isRouteShow":1,"url":"\/client"},{"id":18,"title":"\u5de5\u5355\u7ba1\u7406","icon":"icon-gongdanguanli","appName":"caseManagement","isRouteShow":1,"url":"\/case"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-17 10:44:43') RETURNING "id" |
| 10:44:43.186 | 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" |
| 10:44:43.167 | 1.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (sales_id IS NOT NULL) |
| 10:44:43.190 | 1.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 |
| 10:44:42.741 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_groups" ORDER BY "level", "id" |
| 10:44:42.900 | 1.3 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 |
| 10:44:43.178 | 1.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 |
| 10:44:42.766 | 1.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" |
| 10:44:42.772 | 1.2 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 |
| 10:44:42.759 | 1.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (sales_id IS NOT NULL) |
| 10:44:42.768 | 1.2 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 |
| 10:44:43.317 | 1.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, 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 |
| 10:44:42.871 | 1.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (sales_id IS NOT NULL) |
| 10:44:43.227 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (sales_id IS NOT NULL) |
| 10:44:43.222 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5351) AND (group_id IS NOT NULL) |
| 10:44:42.779 | 1.1 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 |
| 10:44:43.223 | 1.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (sales_id IS NOT NULL) |
| 10:44:42.796 | 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 |
| 10:44:43.161 | 1.1 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 |
| 10:44:43.373 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (group_id IS NOT NULL) |
| 10:44:42.784 | 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) |
| 10:44:43.232 | 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 |
| 10:44:42.785 | 1.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 |
| 10:44:43.225 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (group_id IS NOT NULL) |
| 10:44:42.751 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" |
| 10:44:42.792 | 1.0 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 |
| 10:44:42.764 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (group_id IS NOT NULL) |
| 10:44:42.769 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1000) AND (group_id IS NOT NULL) |
| 10:44:43.358 | 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 |
| 10:44:42.781 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (group_id IS NOT NULL) |
| 10:44:42.771 | 1.0 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" |
| 10:44:42.777 | 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) |
| 10:44:43.310 | 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 |
| 10:44:42.788 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (sales_id IS NOT NULL) |
| 10:44:43.220 | 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 |
| 10:44:42.789 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (group_id IS NOT NULL) |
| 10:44:42.773 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5083) AND (group_id IS NOT NULL) |
| 10:44:42.783 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (group_id IS NOT NULL) |
| 10:44:42.757 | 0.9 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 |
| 10:44:43.354 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (group_id IS NOT NULL) |
| 10:44:42.790 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (sales_id IS NOT NULL) |
| 10:44:42.787 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (group_id IS NOT NULL) |
| 10:44:43.342 | 0.9 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 |
| 10:44:42.776 | 0.9 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 |
| 10:44:42.775 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (sales_id IS NOT NULL) |
| 10:44:42.782 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (sales_id IS NOT NULL) |
| 10:44:43.296 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (sales_id IS NOT NULL) |
| 10:44:42.907 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (group_id IS NOT NULL) |
| 10:44:43.294 | 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 |
| 10:44:42.958 | 0.8 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 |
| 10:44:42.778 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (sales_id IS NOT NULL) |
| 10:44:43.323 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (group_id IS NOT NULL) |
| 10:44:42.831 | 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 |
| 10:44:43.361 | 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 |
| 10:44:42.883 | 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 |
| 10:44:42.846 | 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 |
| 10:44:43.188 | 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 |
| 10:44:43.225 | 0.8 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 |
| 10:44:42.849 | 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 |
| 10:44:43.182 | 0.8 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 |
| 10:44:42.879 | 0.7 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 |
| 10:44:43.341 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (sales_id IS NOT NULL) |
| 10:44:42.762 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (sales_id IS NOT NULL) |
| 10:44:42.858 | 0.7 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 |
| 10:44:42.904 | 0.7 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 |
| 10:44:42.864 | 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, 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 |
| 10:44:42.959 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (group_id IS NOT NULL) |
| 10:44:42.827 | 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 |
| 10:44:43.367 | 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 |
| 10:44:42.761 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (group_id IS NOT NULL) |
| 10:44:43.326 | 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 |
| 10:44:42.838 | 0.7 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 |
| 10:44:43.304 | 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 |
| 10:44:43.233 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5135) AND (group_id IS NOT NULL) |
| 10:44:43.329 | 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 |
| 10:44:43.194 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (sales_id IS NOT NULL) |
| 10:44:43.371 | 0.7 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 |
| 10:44:43.216 | 0.7 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 |
| 10:44:42.844 | 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, 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 |
| 10:44:43.354 | 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 |
| 10:44:43.331 | 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 |
| 10:44:43.217 | 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) |
| 10:44:43.373 | 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) |
| 10:44:42.878 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (sales_id IS NOT NULL) |
| 10:44:43.315 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5079) AND (group_id IS NOT NULL) |
| 10:44:43.347 | 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 |
| 10:44:43.330 | 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) |
| 10:44:43.153 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5094) AND (group_id IS NOT NULL) |
| 10:44:43.181 | 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) |
| 10:44:42.957 | 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) |
| 10:44:43.370 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (sales_id IS NOT NULL) |
| 10:44:43.316 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (sales_id IS NOT NULL) |
| 10:44:43.340 | 0.6 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 |
| 10:44:43.140 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (sales_id IS NOT NULL) |
| 10:44:42.855 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (group_id IS NOT NULL) |
| 10:44:42.826 | 0.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) |
| 10:44:43.326 | 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) |
| 10:44:42.889 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1012) AND (group_id IS NOT NULL) |
| 10:44:43.356 | 0.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 |
| 10:44:43.365 | 0.6 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 |
| 10:44:43.290 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (sales_id IS NOT NULL) |
| 10:44:42.876 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (sales_id IS NOT NULL) |
| 10:44:42.811 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (group_id IS NOT NULL) |
| 10:44:42.895 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (sales_id IS NOT NULL) |
| 10:44:42.837 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (sales_id IS NOT NULL) |
| 10:44:42.880 | 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) |
| 10:44:43.304 | 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) |
| 10:44:43.328 | 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) |
| 10:44:43.165 | 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) |
| 10:44:43.375 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (sales_id IS NOT NULL) |
| 10:44:43.196 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (sales_id IS NOT NULL) |
| 10:44:42.844 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (group_id IS NOT NULL) |
| 10:44:43.358 | 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) |
| 10:44:43.218 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (sales_id IS NOT NULL) |
| 10:44:42.834 | 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) |
| 10:44:43.230 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (group_id IS NOT NULL) |
| 10:44:43.306 | 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) |
| 10:44:43.368 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (sales_id IS NOT NULL) |
| 10:44:42.843 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (sales_id IS NOT NULL) |
| 10:44:43.308 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (sales_id IS NOT NULL) |
| 10:44:43.363 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (sales_id IS NOT NULL) |
| 10:44:42.852 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (sales_id IS NOT NULL) |
| 10:44:42.851 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (sales_id IS NOT NULL) |
| 10:44:42.906 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (sales_id IS NOT NULL) |
| 10:44:43.131 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (group_id IS NOT NULL) |
| 10:44:43.364 | 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) |
| 10:44:43.346 | 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) |
| 10:44:42.847 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (sales_id IS NOT NULL) |
| 10:44:42.811 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (sales_id IS NOT NULL) |
| 10:44:43.320 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (sales_id IS NOT NULL) |
| 10:44:42.763 | 0.6 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 |
| 10:44:42.848 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (sales_id IS NOT NULL) |
| 10:44:43.334 | 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) |
| 10:44:43.289 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (group_id IS NOT NULL) |
| 10:44:42.868 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (sales_id IS NOT NULL) |
| 10:44:42.904 | 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) |
| 10:44:42.857 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (sales_id IS NOT NULL) |
| 10:44:43.368 | 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) |
| 10:44:43.293 | 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) |
| 10:44:43.324 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (sales_id IS NOT NULL) |
| 10:44:42.876 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (group_id IS NOT NULL) |
| 10:44:43.339 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (sales_id IS NOT NULL) |
| 10:44:42.855 | 0.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) |
| 10:44:42.890 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (sales_id IS NOT NULL) |
| 10:44:43.305 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (group_id IS NOT NULL) |
| 10:44:42.835 | 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) |
| 10:44:43.353 | 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) |
| 10:44:43.132 | 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) |
| 10:44:43.302 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (group_id IS NOT NULL) |
| 10:44:43.330 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (group_id IS NOT NULL) |
| 10:44:43.349 | 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) |
| 10:44:43.366 | 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) |
| 10:44:43.360 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (group_id IS NOT NULL) |
| 10:44:42.828 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (group_id IS NOT NULL) |
| 10:44:43.180 | 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) |
| 10:44:43.341 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (group_id IS NOT NULL) |
| 10:44:43.357 | 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) |
| 10:44:42.899 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (sales_id IS NOT NULL) |
| 10:44:43.236 | 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) |
| 10:44:42.897 | 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) |
| 10:44:43.309 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (group_id IS NOT NULL) |
| 10:44:43.372 | 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) |
| 10:44:43.171 | 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) |
| 10:44:43.189 | 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) |
| 10:44:43.195 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (group_id IS NOT NULL) |
| 10:44:42.852 | 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) |
| 10:44:42.864 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (sales_id IS NOT NULL) |
| 10:44:43.295 | 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) |
| 10:44:43.335 | 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) |
| 10:44:43.138 | 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) |
| 10:44:43.362 | 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) |
| 10:44:42.850 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (group_id IS NOT NULL) |
| 10:44:43.318 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (sales_id IS NOT NULL) |
| 10:44:43.365 | 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) |
| 10:44:42.860 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (sales_id IS NOT NULL) |
| 10:44:43.325 | 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) |
| 10:44:43.327 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (group_id IS NOT NULL) |
| 10:44:42.854 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (sales_id IS NOT NULL) |
| 10:44:42.832 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (sales_id IS NOT NULL) |
| 10:44:43.369 | 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) |
| 10:44:42.862 | 0.5 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 |
| 10:44:43.234 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (sales_id IS NOT NULL) |
| 10:44:42.862 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (sales_id IS NOT NULL) |
| 10:44:42.898 | 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) |
| 10:44:43.387 | 0.5 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 |
| 10:44:43.320 | 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) |
| 10:44:43.322 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (sales_id IS NOT NULL) |
| 10:44:43.337 | 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) |
| 10:44:43.344 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (sales_id IS NOT NULL) |
| 10:44:42.884 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (sales_id IS NOT NULL) |
| 10:44:42.857 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (group_id IS NOT NULL) |
| 10:44:43.363 | 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) |
| 10:44:42.836 | 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) |
| 10:44:42.847 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5065) AND (group_id IS NOT NULL) |
| 10:44:42.810 | 0.5 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 |
| 10:44:43.307 | 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) |
| 10:44:43.137 | 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 |
| 10:44:43.351 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (sales_id IS NOT NULL) |
| 10:44:42.828 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (sales_id IS NOT NULL) |
| 10:44:42.880 | 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) |
| 10:44:42.832 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5016) AND (group_id IS NOT NULL) |
| 10:44:43.141 | 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) |
| 10:44:43.348 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (sales_id IS NOT NULL) |
| 10:44:43.376 | 0.5 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 |
| 10:44:43.303 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (group_id IS NOT NULL) |
| 10:44:43.336 | 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) |
| 10:44:43.383 | 0.5 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 |
| 10:44:43.173 | 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) |
| 10:44:43.339 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (group_id IS NOT NULL) |
| 10:44:43.139 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (group_id IS NOT NULL) |
| 10:44:43.332 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (group_id IS NOT NULL) |
| 10:44:42.861 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (group_id IS NOT NULL) |
| 10:44:42.853 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (group_id IS NOT NULL) |
| 10:44:43.172 | 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) |
| 10:44:43.343 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (group_id IS NOT NULL) |
| 10:44:42.859 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (group_id IS NOT NULL) |
| 10:44:43.348 | 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) |
| 10:44:42.877 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (group_id IS NOT NULL) |
| 10:44:43.302 | 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) |
| 10:44:42.863 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (group_id IS NOT NULL) |
| 10:44:43.382 | 0.5 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 |
| 10:44:42.813 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (group_id IS NOT NULL) |
| 10:44:42.905 | 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) |
| 10:44:42.897 | 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) |
| 10:44:43.396 | 0.5 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 |
| 10:44:42.813 | 0.5 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" |
| 10:44:43.321 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (group_id IS NOT NULL) |
| 10:44:42.833 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (group_id IS NOT NULL) |
| 10:44:42.839 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (group_id IS NOT NULL) |
| 10:44:42.829 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (group_id IS NOT NULL) |
| 10:44:43.133 | 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) |
| 10:44:43.219 | 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) |
| 10:44:43.170 | 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) |
| 10:44:42.842 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1002) AND (group_id IS NOT NULL) |
| 10:44:43.235 | 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) |
| 10:44:43.352 | 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) |
| 10:44:43.167 | 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) |
| 10:44:43.333 | 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) |
| 10:44:43.137 | 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) |
| 10:44:42.856 | 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 |
| 10:44:42.885 | 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) |
| 10:44:43.195 | 0.5 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 |
| 10:44:43.349 | 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) |
| 10:44:43.385 | 0.4 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 |
| 10:44:43.318 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (group_id IS NOT NULL) |
| 10:44:43.337 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (group_id IS NOT NULL) |
| 10:44:43.378 | 0.4 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 |
| 10:44:43.189 | 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) |
| 10:44:43.335 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (group_id IS NOT NULL) |
| 10:44:42.835 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (group_id IS NOT NULL) |
| 10:44:43.351 | 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) |
| 10:44:42.881 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (group_id IS NOT NULL) |
| 10:44:43.345 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5124) AND (group_id IS NOT NULL) |
| 10:44:43.345 | 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 |
| 10:44:43.394 | 0.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 |
| 10:44:43.288 | 0.4 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 |
| 10:44:42.884 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5259) AND (group_id IS NOT NULL) |
| 10:44:43.379 | 0.4 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 |
| 10:44:42.848 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (group_id IS NOT NULL) |
| 10:44:43.397 | 0.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, 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 |
| 10:44:43.399 | 0.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 |
| 10:44:42.830 | 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" |
| 10:44:42.812 | 0.4 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 |
| 10:44:43.170 | 0.4 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 |
| 10:44:43.220 | 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" |
| 10:44:42.854 | 0.4 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 |
| 10:44:43.390 | 0.4 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 |
| 10:44:42.836 | 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 |
| 10:44:43.401 | 0.4 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 10:44:43.166 | 0.4 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 |
| 10:44:43.132 | 0.4 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 |
| 10:44:42.860 | 0.4 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 |
| 10:44:42.898 | 0.4 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 |
| 10:44:42.882 | 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" |
| 10:44:42.881 | 0.4 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 |
| 10:44:42.869 | 0.4 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 |
| 10:44:43.142 | 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" |
| 10:44:43.308 | 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 |
| 10:44:43.322 | 0.4 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 |
| 10:44:43.141 | 0.4 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 |
| 10:44:43.294 | 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" |
| 10:44:43.319 | 0.4 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 |
| 10:44:43.398 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (sales_id IS NOT NULL) |
| 10:44:43.231 | 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" |
| 10:44:43.139 | 0.4 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 |
| 10:44:43.360 | 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" |
| 10:44:42.795 | 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" |
| 10:44:43.324 | 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 |
| 10:44:42.829 | 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 |
| 10:44:42.896 | 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 |
| 10:44:43.235 | 0.4 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 |
| 10:44:43.307 | 0.4 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 |
| 10:44:43.355 | 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" |
| 10:44:42.886 | 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" |
| 10:44:42.908 | 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" |
| 10:44:43.310 | 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" |
| 10:44:43.338 | 0.3 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 |
| 10:44:43.387 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (sales_id IS NOT NULL) |
| 10:44:43.172 | 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 |
| 10:44:43.379 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (sales_id IS NOT NULL) |
| 10:44:42.839 | 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" |
| 10:44:43.397 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (sales_id IS NOT NULL) |
| 10:44:43.333 | 0.3 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 |
| 10:44:43.377 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (sales_id IS NOT NULL) |
| 10:44:43.384 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (sales_id IS NOT NULL) |
| 10:44:43.336 | 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 |
| 10:44:43.389 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (sales_id IS NOT NULL) |
| 10:44:43.352 | 0.3 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 |
| 10:44:42.834 | 0.3 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 |
| 10:44:43.393 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (sales_id IS NOT NULL) |
| 10:44:43.400 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (sales_id IS NOT NULL) |
| 10:44:43.369 | 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 |
| 10:44:43.350 | 0.3 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 |
| 10:44:43.392 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (sales_id IS NOT NULL) |
| 10:44:43.388 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (sales_id IS NOT NULL) |
| 10:44:43.391 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (sales_id IS NOT NULL) |
| 10:44:43.378 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (group_id IS NOT NULL) |
| 10:44:43.386 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (sales_id IS NOT NULL) |
| 10:44:42.845 | 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" |
| 10:44:43.380 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (sales_id IS NOT NULL) |
| 10:44:43.382 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5412) AND (group_id IS NOT NULL) |
| 10:44:43.380 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (group_id IS NOT NULL) |
| 10:44:43.394 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (sales_id IS NOT NULL) |
| 10:44:43.390 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (group_id IS NOT NULL) |
| 10:44:43.385 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (group_id IS NOT NULL) |
| 10:44:43.377 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5104) AND (group_id IS NOT NULL) |
| 10:44:43.388 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (group_id IS NOT NULL) |
| 10:44:43.384 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5393) AND (group_id IS NOT NULL) |
| 10:44:43.393 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (group_id IS NOT NULL) |
| 10:44:43.399 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (group_id IS NOT NULL) |
| 10:44:43.389 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (group_id IS NOT NULL) |
| 10:44:43.376 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (group_id IS NOT NULL) |
| 10:44:43.395 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (group_id IS NOT NULL) |
| 10:44:43.398 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (group_id IS NOT NULL) |
| 10:44:43.394 | 0.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) |
| 10:44:43.386 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (group_id IS NOT NULL) |
| 10:44:43.401 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (group_id IS NOT NULL) |
| 10:44:43.391 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (group_id IS NOT NULL) |
| 10:44:43.381 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (group_id IS NOT NULL) |
| 10:44:43.397 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5333) AND (group_id IS NOT NULL) |
| 10:44:43.392 | 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 |
| 10:44:43.375 | 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 |
| 10:44:43.383 | 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" |
| 10:44:43.376 | 0.2 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" |
| 10:44:43.395 | 0.2 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 |
| 10:44:43.381 | 0.2 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" |
| 10:44:43.396 | 0.2 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" |
| 10:44:43.389 | 0.2 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 |
| 10:44:43.400 | 0.2 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 |
| 10:44:43.381 | 0.2 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 |
| 10:44:43.386 | 0.2 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 |
| 10:44:43.391 | 0.2 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 |