6a42621600cd1: POST https://beta.jinchangxiao.com/vue/dashboard/get-main at 2026-06-29 08:16:21 pm by 111.194.208.14
Performance Profiling
Total processing time: 501 ms; Peak memory: 8.242 MB. Show Profiling Timeline
总计433条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 20:16:22.212 | 10.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (sales_id IS NOT NULL) |
| 20:16:22.276 | 10.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (group_id IS NOT NULL) |
| 20:16:22.263 | 10.1 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=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 |
| 20:16:22.249 | 9.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (sales_id IS NOT NULL) |
| 20:16:22.313 | 9.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5029) AND (group_id IS NOT NULL) |
| 20:16:22.360 | 9.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (sales_id IS NOT NULL) |
| 20:16:22.302 | 8.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.349 | 7.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (group_id IS NOT NULL) |
| 20:16:22.292 | 7.1 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 20:16:22.327 | 6.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (sales_id IS NOT NULL) |
| 20:16:22.238 | 6.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (group_id IS NOT NULL) |
| 20:16:22.338 | 6.2 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.227 | 6.1 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 |
| 20:16:22.200 | 6.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5135) AND (group_id IS NOT NULL) |
| 20:16:22.063 | 4.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.487 | 3.3 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/get-main', '{"web_access_token":"ROro5dfSSS00h8isamNfV7qu7bppSyw4"}', '{"code":2000,"result":{"deployment":"saas","logo":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png","user":{"id":1001,"avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","version":"3.1.98","enterpriseName":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","userName":"\u5218\u4eba\u8bda","role":"\u89d2\u8272: \u7cfb\u7edf\u7ba1\u7406\u5458, \u8d22\u52a1\u4e13\u5458, \u5ba2\u6237\u7ecf\u7406","day":"2026-06-29 \u661f\u671f\u4e00","week":"2026\u5e7406\u670829\u65e5 \u7b2c27\u5468","is_sales":true,"score":"18","is_engineer":false,"e_score":0,"is_account_manager":true,"expiry_date":"2325-12-31 00:00:00","will_expired":false,"currentfascalyear_from":"2026-01-01 00:00:00","currentfascalyear_to":"2026-12-31 23:59:59","is_expired":true,"lunarDay":"\u5341\u4e94","lunarMonth":"\u4e94\u6708","lunarYear":"\u4e19\u5348\u5e74","clientCheckSame":true,"tax_start_at":"2024-08-01 00:00","erp_start_at":"2025-08-08 14:34:58","erp_decimal_point":2,"view_product_cost":true,"manage_ledger":false},"can_visit_account":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:140.0) Gecko\/20100101 Firefox\/140.0"}', FALSE, '2026-06-29 20:16:22', 481648896) RETURNING "id" |
| 20:16:22.481 | 2.8 ms | yii\db\Command::query | SELECT ( (CASE WHEN srsb.budget_base > 0 THEN floor(u.budget_count * 10 / srsb.budget_base) ELSE 0 END) + (CASE WHEN srsb.profit_base > 0 THEN floor(u.profit_count * 10 / srsb.profit_base) ELSE 0 END) + (CASE WHEN srsb.bargain_base > 0 THEN floor(u.bargain_count * 10 / srsb.bargain_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_budget_base > 0 THEN floor(u.opportunity_budget_count * 10 / srsb.opportunity_budget_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_base > 0 THEN floor(u.opportunity_count * 10 / srsb.opportunity_base) ELSE 0 END) + work_log_score ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_sales_rep_score_bases" "srsb" ON 1 = 1 WHERE "u"."id"=1001 GROUP BY "u"."id", "srsb"."id" |
| 20:16:22.024 | 2.4 ms | yii\db\Command::query | SELECT "a"."user_id", "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE (a.item_name = b.name) AND ("a"."user_id" IN (5258, 5049, 1000, 5500, 5497, 5083, 5301, 1017, 5499, 1018, 5022, 1028, 5209, 5030, 5026, 5293, 5250, 5298, 5309, 5016, 1010, 5356, 5329, 5074, 5086, 5065, 1002, 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, 5467, 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, 5461, 5023, 5124, 1022, 5126, 5032, 5075, 5476, 5388, 5064, 1004, 5025, 5105, 5072, 5081, 5033, 5062, 5440, 5359, 5104, 5360, 5247, 5393, 5412, 5409, 5015, 5229, 1005, 5304, 5296, 5449, 5358, 1023, 1006, 5333, 5297, 1014, 5093)) AND ("b"."type"=1) ORDER BY "user_id" |
| 20:16:22.378 | 2.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5079) AND (group_id IS NOT NULL) |
| 20:16:22.153 | 1.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (group_id IS NOT NULL) |
| 20:16:22.026 | 1.2 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 |
| 20:16:22.409 | 1.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (sales_id IS NOT NULL) |
| 20:16:22.053 | 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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.095 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (group_id IS NOT NULL) |
| 20:16:22.166 | 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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.008 | 1.0 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 20:16:22.130 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (sales_id IS NOT NULL) |
| 20:16:22.049 | 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) |
| 20:16:22.155 | 0.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (sales_id IS NOT NULL) |
| 20:16:22.020 | 0.8 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 |
| 20:16:22.056 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (sales_id IS NOT NULL) |
| 20:16:22.014 | 0.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 20:16:22.059 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (sales_id IS NOT NULL) |
| 20:16:22.129 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5448) AND (group_id IS NOT NULL) |
| 20:16:22.068 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (sales_id IS NOT NULL) |
| 20:16:22.161 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (sales_id IS NOT NULL) |
| 20:16:22.048 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (group_id IS NOT NULL) |
| 20:16:22.055 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5030) AND (group_id IS NOT NULL) |
| 20:16:22.018 | 0.8 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 |
| 20:16:22.060 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (group_id IS NOT NULL) |
| 20:16:22.047 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (sales_id IS NOT NULL) |
| 20:16:22.168 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (sales_id IS NOT NULL) |
| 20:16:22.403 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (group_id IS NOT NULL) |
| 20:16:22.433 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (sales_id IS NOT NULL) |
| 20:16:22.371 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.058 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (group_id IS NOT NULL) |
| 20:16:22.174 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (group_id IS NOT NULL) |
| 20:16:22.071 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (sales_id IS NOT NULL) |
| 20:16:22.134 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.160 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (group_id IS NOT NULL) |
| 20:16:22.167 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5094) AND (group_id IS NOT NULL) |
| 20:16:22.067 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5250) AND (group_id IS NOT NULL) |
| 20:16:22.032 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.148 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.157 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (group_id IS NOT NULL) |
| 20:16:22.377 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.117 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.037 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.420 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.164 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (group_id IS NOT NULL) |
| 20:16:22.074 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.051 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (group_id IS NOT NULL) |
| 20:16:22.088 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.086 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.136 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (sales_id IS NOT NULL) |
| 20:16:22.439 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.182 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.194 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.424 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.120 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.173 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (sales_id IS NOT NULL) |
| 20:16:22.199 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.445 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.455 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.468 | 0.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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.447 | 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, 5499, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5500, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5467, 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 |
| 20:16:22.069 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.091 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.159 | 0.6 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 |
| 20:16:22.458 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (sales_id IS NOT NULL) |
| 20:16:22.140 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.100 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.070 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (group_id IS NOT NULL) |
| 20:16:22.381 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.158 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (sales_id IS NOT NULL) |
| 20:16:22.113 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.081 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.084 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.131 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.041 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.122 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.180 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.406 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.430 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.434 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.061 | 0.6 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 20:16:22.369 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (group_id IS NOT NULL) |
| 20:16:22.370 | 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) |
| 20:16:22.391 | 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, 5409, 5409, 5412, 5412, 5420, 5420, 5448, 5448, 5449, 5449, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.389 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.106 | 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, 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.394 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.143 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (sales_id IS NOT NULL) |
| 20:16:22.441 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.171 | 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) |
| 20:16:22.411 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.152 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (sales_id IS NOT NULL) |
| 20:16:22.443 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.177 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (group_id IS NOT NULL) |
| 20:16:22.477 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 20:16:22.451 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.060 | 0.6 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 |
| 20:16:22.470 | 0.6 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.472 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.464 | 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.028 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (sales_id IS NOT NULL) |
| 20:16:22.175 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (sales_id IS NOT NULL) |
| 20:16:22.083 | 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) |
| 20:16:22.016 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:16:22.206 | 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) |
| 20:16:22.402 | 0.5 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, 5467, 5467, 5476, 5476, 5499, 5499, 5500, 5500) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.052 | 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" |
| 20:16:22.140 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (sales_id IS NOT NULL) |
| 20:16:22.417 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5476) AND (sales_id IS NOT NULL) |
| 20:16:22.079 | 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) |
| 20:16:22.172 | 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) |
| 20:16:22.146 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (sales_id IS NOT NULL) |
| 20:16:22.102 | 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) |
| 20:16:22.391 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (sales_id IS NOT NULL) |
| 20:16:22.099 | 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) |
| 20:16:22.041 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (sales_id IS NOT NULL) |
| 20:16:22.073 | 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) |
| 20:16:22.429 | 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) |
| 20:16:22.373 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (sales_id IS NOT NULL) |
| 20:16:22.389 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (sales_id IS NOT NULL) |
| 20:16:22.427 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (sales_id IS NOT NULL) |
| 20:16:22.047 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (group_id IS NOT NULL) |
| 20:16:22.081 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (sales_id IS NOT NULL) |
| 20:16:22.393 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (sales_id IS NOT NULL) |
| 20:16:22.090 | 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) |
| 20:16:22.029 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (sales_id IS NOT NULL) |
| 20:16:22.170 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (group_id IS NOT NULL) |
| 20:16:22.459 | 0.5 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 |
| 20:16:22.111 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (sales_id IS NOT NULL) |
| 20:16:22.471 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (sales_id IS NOT NULL) |
| 20:16:22.029 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (group_id IS NOT NULL) |
| 20:16:22.122 | 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) |
| 20:16:22.448 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (sales_id IS NOT NULL) |
| 20:16:22.463 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (sales_id IS NOT NULL) |
| 20:16:22.374 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (sales_id IS NOT NULL) |
| 20:16:22.093 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (sales_id IS NOT NULL) |
| 20:16:22.039 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (sales_id IS NOT NULL) |
| 20:16:22.183 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5078) AND (group_id IS NOT NULL) |
| 20:16:22.405 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (sales_id IS NOT NULL) |
| 20:16:22.169 | 0.5 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 |
| 20:16:22.132 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (sales_id IS NOT NULL) |
| 20:16:22.380 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (sales_id IS NOT NULL) |
| 20:16:22.107 | 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) |
| 20:16:22.034 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5500) AND (sales_id IS NOT NULL) |
| 20:16:22.046 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5022) AND (sales_id IS NOT NULL) |
| 20:16:22.112 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (sales_id IS NOT NULL) |
| 20:16:22.127 | 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) |
| 20:16:22.145 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (sales_id IS NOT NULL) |
| 20:16:22.188 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (sales_id IS NOT NULL) |
| 20:16:22.107 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (group_id IS NOT NULL) |
| 20:16:22.031 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5049) AND (group_id IS NOT NULL) |
| 20:16:22.105 | 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) |
| 20:16:22.044 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (sales_id IS NOT NULL) |
| 20:16:22.057 | 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 |
| 20:16:22.397 | 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) |
| 20:16:22.179 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (sales_id IS NOT NULL) |
| 20:16:22.183 | 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) |
| 20:16:22.098 | 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) |
| 20:16:22.426 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (sales_id IS NOT NULL) |
| 20:16:22.124 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (sales_id IS NOT NULL) |
| 20:16:22.192 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (sales_id IS NOT NULL) |
| 20:16:22.440 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (sales_id IS NOT NULL) |
| 20:16:22.442 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (sales_id IS NOT NULL) |
| 20:16:22.469 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (sales_id IS NOT NULL) |
| 20:16:22.043 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5499) AND (sales_id IS NOT NULL) |
| 20:16:22.104 | 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) |
| 20:16:22.163 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (sales_id IS NOT NULL) |
| 20:16:22.177 | 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) |
| 20:16:22.450 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (sales_id IS NOT NULL) |
| 20:16:22.404 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5461) AND (sales_id IS NOT NULL) |
| 20:16:22.040 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5301) AND (group_id IS NOT NULL) |
| 20:16:22.114 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (sales_id IS NOT NULL) |
| 20:16:22.165 | 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" |
| 20:16:22.418 | 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) |
| 20:16:22.401 | 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) |
| 20:16:22.465 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (sales_id IS NOT NULL) |
| 20:16:22.473 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (sales_id IS NOT NULL) |
| 20:16:22.462 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (sales_id IS NOT NULL) |
| 20:16:22.096 | 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) |
| 20:16:22.195 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (sales_id IS NOT NULL) |
| 20:16:22.125 | 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) |
| 20:16:22.425 | 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) |
| 20:16:22.444 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (group_id IS NOT NULL) |
| 20:16:22.138 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (sales_id IS NOT NULL) |
| 20:16:22.142 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (sales_id IS NOT NULL) |
| 20:16:22.144 | 0.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 |
| 20:16:22.400 | 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) |
| 20:16:22.208 | 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) |
| 20:16:22.077 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (sales_id IS NOT NULL) |
| 20:16:22.156 | 0.5 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 |
| 20:16:22.387 | 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) |
| 20:16:22.099 | 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) |
| 20:16:22.384 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (sales_id IS NOT NULL) |
| 20:16:22.076 | 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) |
| 20:16:22.398 | 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) |
| 20:16:22.413 | 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) |
| 20:16:22.422 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (sales_id IS NOT NULL) |
| 20:16:22.452 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (sales_id IS NOT NULL) |
| 20:16:22.035 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5500) AND (group_id IS NOT NULL) |
| 20:16:22.132 | 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) |
| 20:16:22.128 | 0.5 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 |
| 20:16:22.460 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (sales_id IS NOT NULL) |
| 20:16:22.187 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (sales_id IS NOT NULL) |
| 20:16:22.385 | 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) |
| 20:16:22.407 | 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) |
| 20:16:22.103 | 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) |
| 20:16:22.184 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (group_id IS NOT NULL) |
| 20:16:22.382 | 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) |
| 20:16:22.415 | 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) |
| 20:16:22.150 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (sales_id IS NOT NULL) |
| 20:16:22.395 | 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) |
| 20:16:22.456 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (sales_id IS NOT NULL) |
| 20:16:22.035 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5497) AND (sales_id IS NOT NULL) |
| 20:16:22.089 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (sales_id IS NOT NULL) |
| 20:16:22.197 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (sales_id IS NOT NULL) |
| 20:16:22.210 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (group_id IS NOT NULL) |
| 20:16:22.431 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (sales_id IS NOT NULL) |
| 20:16:22.190 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (sales_id IS NOT NULL) |
| 20:16:22.185 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5467) AND (sales_id IS NOT NULL) |
| 20:16:22.210 | 0.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) |
| 20:16:22.109 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (sales_id IS NOT NULL) |
| 20:16:22.435 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (sales_id IS NOT NULL) |
| 20:16:22.118 | 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) |
| 20:16:22.193 | 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) |
| 20:16:22.412 | 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) |
| 20:16:22.033 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1000) AND (group_id IS NOT NULL) |
| 20:16:22.051 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5209 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.436 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (sales_id IS NOT NULL) |
| 20:16:22.145 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (group_id IS NOT NULL) |
| 20:16:22.181 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (group_id IS NOT NULL) |
| 20:16:22.094 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (sales_id IS NOT NULL) |
| 20:16:22.138 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (group_id IS NOT NULL) |
| 20:16:22.118 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5259) AND (group_id IS NOT NULL) |
| 20:16:22.136 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5095) AND (group_id IS NOT NULL) |
| 20:16:22.372 | 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) |
| 20:16:22.084 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (group_id IS NOT NULL) |
| 20:16:22.381 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (group_id IS NOT NULL) |
| 20:16:22.401 | 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) |
| 20:16:22.469 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5333) AND (group_id IS NOT NULL) |
| 20:16:22.465 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1023) AND (group_id IS NOT NULL) |
| 20:16:22.089 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1002) AND (group_id IS NOT NULL) |
| 20:16:22.119 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (group_id IS NOT NULL) |
| 20:16:22.463 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (group_id IS NOT NULL) |
| 20:16:22.473 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (group_id IS NOT NULL) |
| 20:16:22.162 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (group_id IS NOT NULL) |
| 20:16:22.384 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (group_id IS NOT NULL) |
| 20:16:22.406 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (group_id IS NOT NULL) |
| 20:16:22.434 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (group_id IS NOT NULL) |
| 20:16:22.075 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5016) AND (group_id IS NOT NULL) |
| 20:16:22.086 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5065) AND (group_id IS NOT NULL) |
| 20:16:22.109 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (group_id IS NOT NULL) |
| 20:16:22.110 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (group_id IS NOT NULL) |
| 20:16:22.196 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (group_id IS NOT NULL) |
| 20:16:22.394 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (group_id IS NOT NULL) |
| 20:16:22.105 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (group_id IS NOT NULL) |
| 20:16:22.471 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (group_id IS NOT NULL) |
| 20:16:22.442 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (group_id IS NOT NULL) |
| 20:16:22.452 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (group_id IS NOT NULL) |
| 20:16:22.455 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (group_id IS NOT NULL) |
| 20:16:22.038 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5083) AND (group_id IS NOT NULL) |
| 20:16:22.123 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (group_id IS NOT NULL) |
| 20:16:22.125 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (group_id IS NOT NULL) |
| 20:16:22.208 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (group_id IS NOT NULL) |
| 20:16:22.412 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (group_id IS NOT NULL) |
| 20:16:22.413 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (group_id IS NOT NULL) |
| 20:16:22.439 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5104) AND (group_id IS NOT NULL) |
| 20:16:22.446 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5393) AND (group_id IS NOT NULL) |
| 20:16:22.112 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (group_id IS NOT NULL) |
| 20:16:22.386 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (group_id IS NOT NULL) |
| 20:16:22.174 | 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 |
| 20:16:22.376 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (group_id IS NOT NULL) |
| 20:16:22.474 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (group_id IS NOT NULL) |
| 20:16:22.453 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (group_id IS NOT NULL) |
| 20:16:22.178 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (group_id IS NOT NULL) |
| 20:16:22.436 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (group_id IS NOT NULL) |
| 20:16:22.467 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (group_id IS NOT NULL) |
| 20:16:22.116 | 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) |
| 20:16:22.486 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:16:22.195 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5351) AND (group_id IS NOT NULL) |
| 20:16:22.414 | 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) |
| 20:16:22.450 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (group_id IS NOT NULL) |
| 20:16:22.142 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (group_id IS NOT NULL) |
| 20:16:22.076 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (group_id IS NOT NULL) |
| 20:16:22.114 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (group_id IS NOT NULL) |
| 20:16:22.090 | 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) |
| 20:16:22.127 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (group_id IS NOT NULL) |
| 20:16:22.101 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (group_id IS NOT NULL) |
| 20:16:22.146 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (group_id IS NOT NULL) |
| 20:16:22.190 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (group_id IS NOT NULL) |
| 20:16:22.426 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (group_id IS NOT NULL) |
| 20:16:22.092 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (group_id IS NOT NULL) |
| 20:16:22.188 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (group_id IS NOT NULL) |
| 20:16:22.141 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (group_id IS NOT NULL) |
| 20:16:22.390 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (group_id IS NOT NULL) |
| 20:16:22.421 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5064) AND (group_id IS NOT NULL) |
| 20:16:22.448 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5412) AND (group_id IS NOT NULL) |
| 20:16:22.082 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (group_id IS NOT NULL) |
| 20:16:22.392 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (group_id IS NOT NULL) |
| 20:16:22.044 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5499) AND (group_id IS NOT NULL) |
| 20:16:22.097 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (group_id IS NOT NULL) |
| 20:16:22.149 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1001) AND (group_id IS NOT NULL) |
| 20:16:22.121 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1012) AND (group_id IS NOT NULL) |
| 20:16:22.374 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (group_id IS NOT NULL) |
| 20:16:22.042 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (group_id IS NOT NULL) |
| 20:16:22.457 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (group_id IS NOT NULL) |
| 20:16:22.459 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (group_id IS NOT NULL) |
| 20:16:22.163 | 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 |
| 20:16:22.430 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (group_id IS NOT NULL) |
| 20:16:22.461 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5449) AND (group_id IS NOT NULL) |
| 20:16:22.008 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 20:16:22.151 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (group_id IS NOT NULL) |
| 20:16:22.388 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (group_id IS NOT NULL) |
| 20:16:22.036 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5497) AND (group_id IS NOT NULL) |
| 20:16:22.383 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (group_id IS NOT NULL) |
| 20:16:22.399 | 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) |
| 20:16:22.418 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5476) AND (group_id IS NOT NULL) |
| 20:16:22.423 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (group_id IS NOT NULL) |
| 20:16:22.437 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (group_id IS NOT NULL) |
| 20:16:22.432 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (group_id IS NOT NULL) |
| 20:16:22.045 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (group_id IS NOT NULL) |
| 20:16:22.080 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (group_id IS NOT NULL) |
| 20:16:22.133 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (group_id IS NOT NULL) |
| 20:16:22.147 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (group_id IS NOT NULL) |
| 20:16:22.396 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (group_id IS NOT NULL) |
| 20:16:22.408 | 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) |
| 20:16:22.416 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (group_id IS NOT NULL) |
| 20:16:22.078 | 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) |
| 20:16:22.139 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (group_id IS NOT NULL) |
| 20:16:22.198 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (group_id IS NOT NULL) |
| 20:16:22.428 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (group_id IS NOT NULL) |
| 20:16:22.191 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (group_id IS NOT NULL) |
| 20:16:22.093 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (group_id IS NOT NULL) |
| 20:16:22.186 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5467) AND (group_id IS NOT NULL) |
| 20:16:22.211 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (group_id IS NOT NULL) |
| 20:16:22.404 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5461) AND (group_id IS NOT NULL) |
| 20:16:22.397 | 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) |
| 20:16:22.209 | 0.4 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 |
| 20:16:22.419 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (group_id IS NOT NULL) |
| 20:16:22.098 | 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 |
| 20:16:22.171 | 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 |
| 20:16:22.408 | 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 |
| 20:16:22.148 | 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" |
| 20:16:22.022 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" |
| 20:16:22.162 | 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 |
| 20:16:22.017 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_groups" ORDER BY "level", "id" |
| 20:16:22.072 | 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 |
| 20:16:22.031 | 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" |
| 20:16:22.037 | 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" |
| 20:16:22.420 | 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" |
| 20:16:22.074 | 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" |
| 20:16:22.424 | 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" |
| 20:16:22.079 | 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 |
| 20:16:22.134 | 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" |
| 20:16:22.120 | 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" |
| 20:16:22.087 | 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" |
| 20:16:22.484 | 0.3 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 20:16:22.386 | 0.3 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 |
| 20:16:22.085 | 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" |
| 20:16:22.376 | 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" |
| 20:16:22.181 | 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" |
| 20:16:22.199 | 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" |
| 20:16:22.116 | 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" |
| 20:16:22.475 | 0.3 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 20:16:22.373 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5066 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.444 | 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" |
| 20:16:22.438 | 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" |
| 20:16:22.446 | 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" |
| 20:16:22.207 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5300, 5309, 5311) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.193 | 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" |
| 20:16:22.078 | 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 |
| 20:16:22.432 | 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 |
| 20:16:22.457 | 0.3 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 |
| 20:16:22.102 | 0.3 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 |
| 20:16:22.115 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1026 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.454 | 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" |
| 20:16:22.467 | 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" |
| 20:16:22.191 | 0.3 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 |
| 20:16:22.151 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5037 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.096 | 0.3 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 |
| 20:16:22.184 | 0.3 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 |
| 20:16:22.383 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5364 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.399 | 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 |
| 20:16:22.428 | 0.3 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 |
| 20:16:22.461 | 0.3 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 |
| 20:16:22.396 | 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 |
| 20:16:22.030 | 0.3 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 |
| 20:16:22.437 | 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 |
| 20:16:22.186 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5467 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.387 | 0.3 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 |
| 20:16:22.416 | 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 |
| 20:16:22.198 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5076 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.110 | 0.3 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 |
| 20:16:22.211 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5027 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.034 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5500 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.453 | 0.3 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 |
| 20:16:22.137 | 0.3 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 |
| 20:16:22.039 | 0.3 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 |
| 20:16:22.104 | 0.3 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 |
| 20:16:22.176 | 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 |
| 20:16:22.152 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5087 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.108 | 0.3 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 |
| 20:16:22.178 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5208 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.375 | 0.3 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 |
| 20:16:22.046 | 0.3 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 |
| 20:16:22.449 | 0.3 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 |
| 20:16:22.043 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5499 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.196 | 0.3 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 |
| 20:16:22.400 | 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 |
| 20:16:22.466 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1006 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.189 | 0.3 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 |
| 20:16:22.124 | 0.3 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 |
| 20:16:22.417 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5476 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.462 | 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 |
| 20:16:22.414 | 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 |
| 20:16:22.422 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1004 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.474 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5093 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.126 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5070 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 20:16:22.187 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5294 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |