6861e18cc8db9: POST https://beta.jinchangxiao.com/vue/history/list-module at 2025-06-30 08:59:56 am by 124.64.23.82
Performance Profiling
Total processing time: 543 ms; Peak memory: 7.931 MB. Show Profiling Timeline
总计409条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 08:59:56.967 | 12.9 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (sales_id IS NOT NULL) |
| 08:59:57.145 | 11.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (group_id IS NOT NULL) |
| 08:59:57.203 | 8.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.186 | 7.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (group_id IS NOT NULL) |
| 08:59:57.348 | 6.8 ms | yii\db\Command::query | SELECT "user_id", "object_type", sum(num) as num FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type" != 24) AND ("object_type" != 29) AND ("visit_date" >= '2025-06-15') AND ("object_type" IN (23, 9, 21, 10, 22, 1, 19, 20, 37, 18, 101, 34, 7, 11, 12, 13, 25, 26, 16, 28, 29, 30, 10004)) GROUP BY "user_id", "object_type" ORDER BY "num" DESC LIMIT 10 |
| 08:59:57.116 | 6.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5230 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.826 | 5.6 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 08:59:56.989 | 5.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (group_id IS NOT NULL) |
| 08:59:56.937 | 5.2 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (sales_id IS NOT NULL) |
| 08:59:57.197 | 5.1 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:56.946 | 5.0 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.000 | 4.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5299) AND (group_id IS NOT NULL) |
| 08:59:57.092 | 4.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (group_id IS NOT NULL) |
| 08:59:56.832 | 4.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 08:59:56.840 | 4.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 08:59:56.957 | 3.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5086) AND (group_id IS NOT NULL) |
| 08:59:56.859 | 3.5 ms | yii\db\Command::query | SELECT "a"."user_id", "b".* FROM "a57be577deb434"."tbl_auth_assignments" "a", "a57be577deb434"."tbl_auth_items" "b" WHERE (a.item_name = b.name) AND ("a"."user_id" IN (5258, 5049, 1000, 5083, 5301, 1017, 1018, 5022, 1028, 5209, 5030, 5026, 5293, 5250, 5298, 5309, 5016, 1010, 5356, 5329, 5074, 1002, 5065, 5086, 5080, 1011, 1019, 5050, 5299, 5125, 5101, 5303, 5302, 5085, 5332, 5047, 5419, 1016, 1026, 5259, 5028, 1012, 5249, 5096, 5070, 5102, 5063, 5095, 5420, 5445, 5082, 5073, 1029, 1027, 5446, 1001, 5037, 5087, 1008, 5123, 5048, 5043, 5094, 5045, 5230, 5031, 5088, 5208, 5305, 5078, 1003, 5294, 5357, 5044, 5024, 5351, 1030, 5076, 5135, 5300, 1007, 5027, 5089, 5311, 5029, 5411, 1021, 1020, 5066, 5069, 5079, 5252, 5364, 5071, 1009, 5295, 5248, 1013, 1015, 5128, 5404, 5203, 1025, 5413, 5023, 5124, 1022, 5126, 5032, 5075, 5388, 5064, 1004, 5025, 5105, 5072, 5081, 5033, 5062, 5440, 5359, 5104, 5360, 5247, 5393, 5412, 5409, 5015, 5229, 1005, 5304, 5296, 5358, 1023, 1006, 5333, 5297, 1014, 5093)) AND ("b"."type"=1) ORDER BY "user_id" |
| 08:59:57.111 | 3.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (sales_id IS NOT NULL) |
| 08:59:57.136 | 3.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5305) AND (sales_id IS NOT NULL) |
| 08:59:57.213 | 3.2 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5135) AND (group_id IS NOT NULL) |
| 08:59:57.049 | 3.1 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5063) AND (sales_id IS NOT NULL) |
| 08:59:57.251 | 2.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.851 | 2.7 ms | yii\db\Command::query | SELECT "id", "name", "email" FROM "a57be577deb434"."tbl_users" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.087 | 2.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (group_id IS NOT NULL) |
| 08:59:57.043 | 2.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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.099 | 2.6 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.126 | 2.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5230) AND (group_id IS NOT NULL) |
| 08:59:56.847 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_groups" ORDER BY "level", "id" |
| 08:59:56.925 | 2.0 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.105 | 1.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5094) AND (group_id IS NOT NULL) |
| 08:59:57.109 | 1.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (group_id IS NOT NULL) |
| 08:59:57.068 | 1.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1029 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.062 | 1.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (sales_id IS NOT NULL) |
| 08:59:57.340 | 1.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (group_id IS NOT NULL) |
| 08:59:56.986 | 1.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.133 | 1.6 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5208 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.295 | 1.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5062) AND (group_id IS NOT NULL) |
| 08:59:57.081 | 1.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (sales_id IS NOT NULL) |
| 08:59:57.358 | 1.6 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/history/list-module', '{"web_access_token":"SXPCUp7Z_YgHJ45TnvuyG1o7l8nwuHKC"}', '{"code":2000,"result":{"list":[{"id":23,"title":"\u7edf\u8ba1\u5206\u6790","icon":"icon-tongjifenxi","appName":"analysis","isRouteShow":1,"url":"\/analysis"},{"id":1,"title":"\u5546\u673a\u4fe1\u606f","icon":"icon-shangjixinxi","appName":"project","isRouteShow":1,"url":"\/project"},{"id":20,"title":"\u8d39\u7528\u62a5\u9500","icon":"icon-feiyongbaoxiao","appName":"reimbursementManagement","isRouteShow":1,"url":"\/reimbursement"},{"id":37,"title":"\u5ba1\u6279\u7ba1\u7406","icon":"icon-shenpi","appName":"approve","isRouteShow":1,"url":"\/approve"},{"id":30,"title":"\u7cfb\u7edf\u8bbe\u7f6e","icon":"icon-xitongshezhi","appName":"settings","isRouteShow":1,"url":"\/setting"},{"id":7,"title":"\u9500\u552e\u5408\u540c","icon":"icon-xiaoshouhetong","appName":"salesContracts","isRouteShow":1,"url":"\/salesContract"},{"id":10004,"title":"\u7a0e\u8d4b\u7ba1\u7406","icon":"icon-shuiwu","appName":"tax","isRouteShow":1,"url":"\/tax"},{"id":19,"title":"\u5de5\u4f5c\u65e5\u5fd7","icon":"icon-gongzuorizhi","appName":"worklog","isRouteShow":1,"url":"\/worklog"},{"id":11,"title":"\u6587\u6863\u7ba1\u7406","icon":"icon-wendangguanli","appName":"documentManagement","isRouteShow":1,"url":"\/document"},{"id":34,"title":"\u9500\u552e\u8bb0\u5f55","icon":"icon-xiaoshoujilu","appName":"salesOrders","isRouteShow":1,"url":"\/salesOrder"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-30 08:59:57') RETURNING "id" |
| 08:59:57.327 | 1.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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.007 | 1.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5125) AND (sales_id IS NOT NULL) |
| 08:59:57.182 | 1.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5076) AND (sales_id IS NOT NULL) |
| 08:59:57.052 | 1.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) |
| 08:59:57.314 | 1.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (group_id IS NOT NULL) |
| 08:59:56.857 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" |
| 08:59:56.869 | 1.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.894 | 1.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.906 | 1.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.931 | 1.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.280 | 1.2 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.891 | 1.1 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (group_id IS NOT NULL) |
| 08:59:56.855 | 1.1 ms | yii\db\Command::query | SELECT "sales_id", "group_id" FROM "a57be577deb434"."tbl_sales_group_relationships" "sgr" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON sgr.sales_id = u.id GROUP BY "sales_id", "group_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.170 | 1.1 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5357 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.143 | 1.1 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.985 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1011) AND (sales_id IS NOT NULL) |
| 08:59:56.927 | 1.0 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.886 | 1.0 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5026 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.176 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (sales_id IS NOT NULL) |
| 08:59:56.997 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (sales_id IS NOT NULL) |
| 08:59:56.889 | 1.0 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5293) AND (sales_id IS NOT NULL) |
| 08:59:56.910 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (group_id IS NOT NULL) |
| 08:59:56.914 | 1.0 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (group_id IS NOT NULL) |
| 08:59:57.330 | 1.0 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1006 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.318 | 0.9 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.918 | 0.9 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (group_id IS NOT NULL) |
| 08:59:56.890 | 0.9 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5293 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.898 | 0.9 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.922 | 0.9 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.102 | 0.9 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.285 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.892 | 0.8 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.075 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.887 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (group_id IS NOT NULL) |
| 08:59:57.163 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.282 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 5049, 5022, 5047, 1026, 5070, 1029, 5037, 5048, 5043, 5045, 5031, 5044, 1030, 1007, 5027, 5066, 5069, 1009, 1025, 5032, 5075, 5033, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.035 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.300 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.076 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1001) AND (group_id IS NOT NULL) |
| 08:59:57.178 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.031 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.226 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.920 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (sales_id IS NOT NULL) |
| 08:59:56.871 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.237 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.896 | 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) |
| 08:59:57.175 | 0.8 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (group_id IS NOT NULL) |
| 08:59:57.309 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.884 | 0.8 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5409, 5303, 5043, 5123, 5093, 5032, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5094, 5044, 5230, 5229, 5358, 1025, 1007, 1003, 5311, 5089, 1013, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.864 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5258) AND (sales_id IS NOT NULL) |
| 08:59:56.909 | 0.8 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1010) AND (sales_id IS NOT NULL) |
| 08:59:56.916 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5329) AND (sales_id IS NOT NULL) |
| 08:59:56.912 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5356) AND (sales_id IS NOT NULL) |
| 08:59:57.024 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (group_id IS NOT NULL) |
| 08:59:57.064 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5087, 1001, 1003, 1006, 1005, 1008, 5026, 1004, 5076, 5072, 5088, 5062, 5295, 5089, 5096, 5093, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5302, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5304, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.335 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1004, 1005, 1006, 5096, 5295, 5299, 5300, 5301, 5302, 5303, 5094, 1003, 1008, 5026, 5062, 5072, 5074, 5076, 5087, 5088, 5089, 5093, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5304, 5309, 5064, 5311, 5329, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.900 | 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) |
| 08:59:57.307 | 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, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.908 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5016) AND (group_id IS NOT NULL) |
| 08:59:57.313 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.332 | 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, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.249 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.864 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" AS "id" FROM "a57be577deb434"."tbl_users" "u" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.305 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5064, 1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.903 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5309) AND (group_id IS NOT NULL) |
| 08:59:57.011 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5295, 1001, 1003, 1006, 5062, 1005, 5074, 5087, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5299, 5294, 5294, 5301, 5300, 5302, 5303, 5304, 5309, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.183 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5076 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.232 | 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.885 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5026) AND (sales_id IS NOT NULL) |
| 08:59:56.899 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5298) AND (group_id IS NOT NULL) |
| 08:59:56.876 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.895 | 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) |
| 08:59:57.027 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5072, 5088, 5295, 5062, 5096, 1004, 1001, 1003, 5026, 1005, 1006, 1008, 5087, 5089, 5299, 5076, 5093, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5295, 5229, 5230, 5302, 5304, 5309, 5294, 5294, 5301, 5300, 5303, 5064, 5311, 5329, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.270 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (sales_id IS NOT NULL) |
| 08:59:57.060 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 1013, 5087, 5420, 1001, 5295, 5300, 5311, 5329, 5064, 5332, 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, 5359, 5364, 5409, 5412) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.037 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1004, 1005, 1006, 5096, 5295, 5299, 5300, 5301, 5302, 5303, 5094, 1003, 1008, 5026, 5062, 5072, 5074, 5076, 5087, 5088, 5089, 5093, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5304, 5309, 5311, 5329, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.923 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5074) AND (group_id IS NOT NULL) |
| 08:59:57.255 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.929 | 0.7 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1002) AND (group_id IS NOT NULL) |
| 08:59:57.172 | 0.7 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5044) AND (sales_id IS NOT NULL) |
| 08:59:57.240 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.277 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 5329, 5332, 5358, 5359, 5364, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.161 | 0.7 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.294 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5072, 1008, 1003, 1001, 5026, 1005, 1006, 1004, 5088, 5087, 5076, 5295, 5089, 5062, 5093, 5096, 5074, 5123, 5128, 5203, 5203, 5209, 5209, 5208, 5208, 5229, 5230, 5295, 5302, 5299, 5294, 5294, 5301, 5300, 5309, 5303, 5304, 5311, 5329, 5064, 5094, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.302 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 5087, 1001, 5295, 5300, 5311, 5064, 5332, 5329, 5357, 5358, 5359, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.337 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.017 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5064, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.174 | 0.7 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5044 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.056 | 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, 5332, 5031, 5128, 5209, 5022, 5294, 5087, 5072, 5074, 5069, 5412, 5357, 5026, 5364, 5070, 5049, 5293, 1006, 1008, 5075, 5302, 5096, 1005, 5420, 5301, 1004, 5066, 5027, 5203, 5295, 1026, 5045, 5208, 5047, 5309, 5076, 5033, 1001, 5299, 5062, 1029, 5088, 1030) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.293 | 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) |
| 08:59:57.341 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 08:59:57.228 | 0.6 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.264 | 0.6 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1004, 1005, 1013, 5087, 5412, 1001, 5295, 5300, 5311, 5064, 5329, 5332, 5359, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 5309, 5356, 5357, 5358, 5364, 5409, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.323 | 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.917 | 0.6 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5329, 5311, 5357, 5358, 5359, 5364) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.902 | 0.6 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5309, 5311) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.055 | 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" |
| 08:59:57.036 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (sales_id IS NOT NULL) |
| 08:59:56.994 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (sales_id IS NOT NULL) |
| 08:59:57.171 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (group_id IS NOT NULL) |
| 08:59:56.933 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5065) AND (group_id IS NOT NULL) |
| 08:59:57.071 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (group_id IS NOT NULL) |
| 08:59:57.290 | 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.313 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5015) AND (sales_id IS NOT NULL) |
| 08:59:57.282 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (sales_id IS NOT NULL) |
| 08:59:57.010 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (sales_id IS NOT NULL) |
| 08:59:57.168 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5357) AND (sales_id IS NOT NULL) |
| 08:59:57.227 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (sales_id IS NOT NULL) |
| 08:59:56.996 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1019) AND (group_id IS NOT NULL) |
| 08:59:57.072 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (group_id IS NOT NULL) |
| 08:59:57.059 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (sales_id IS NOT NULL) |
| 08:59:57.263 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (sales_id IS NOT NULL) |
| 08:59:57.231 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1020) AND (sales_id IS NOT NULL) |
| 08:59:57.266 | 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) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.289 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5081) AND (sales_id IS NOT NULL) |
| 08:59:57.239 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (sales_id IS NOT NULL) |
| 08:59:57.248 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (sales_id IS NOT NULL) |
| 08:59:57.266 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (sales_id IS NOT NULL) |
| 08:59:57.135 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (group_id IS NOT NULL) |
| 08:59:56.998 | 0.6 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5050) AND (group_id IS NOT NULL) |
| 08:59:56.868 | 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" |
| 08:59:57.311 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (sales_id IS NOT NULL) |
| 08:59:57.129 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (sales_id IS NOT NULL) |
| 08:59:57.216 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (sales_id IS NOT NULL) |
| 08:59:57.277 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (sales_id IS NOT NULL) |
| 08:59:56.913 | 0.6 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5356 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.014 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (sales_id IS NOT NULL) |
| 08:59:57.316 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (sales_id IS NOT NULL) |
| 08:59:57.026 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (sales_id IS NOT NULL) |
| 08:59:57.013 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5303) AND (sales_id IS NOT NULL) |
| 08:59:57.016 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5085) AND (sales_id IS NOT NULL) |
| 08:59:56.904 | 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" |
| 08:59:57.029 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (sales_id IS NOT NULL) |
| 08:59:57.302 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (sales_id IS NOT NULL) |
| 08:59:57.223 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (sales_id IS NOT NULL) |
| 08:59:57.164 | 0.6 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1003) AND (sales_id IS NOT NULL) |
| 08:59:57.322 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (sales_id IS NOT NULL) |
| 08:59:56.999 | 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) |
| 08:59:57.271 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 5295, 5300, 5309, 5311, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5064, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.067 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (sales_id IS NOT NULL) |
| 08:59:56.983 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5080) AND (group_id IS NOT NULL) |
| 08:59:56.875 | 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) |
| 08:59:56.930 | 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" |
| 08:59:57.220 | 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) |
| 08:59:57.268 | 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) |
| 08:59:57.218 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (sales_id IS NOT NULL) |
| 08:59:56.873 | 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) |
| 08:59:57.033 | 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) |
| 08:59:57.260 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (sales_id IS NOT NULL) |
| 08:59:57.130 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (sales_id IS NOT NULL) |
| 08:59:57.224 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5311, 1001, 5295, 5300, 5309, 5064, 5329, 1003, 1006, 1008, 5026, 5062, 5072, 5074, 5076, 5088, 5089, 5093, 5094, 5096, 5123, 5128, 5203, 5208, 5209, 5229, 5230, 5293, 5294, 5299, 5301, 5302, 5303, 5304, 1004, 1005, 5087, 5332, 5356, 5357, 5358, 5358, 5359, 5359, 5364, 5364, 1013, 1013, 5409, 5409, 5412, 5412, 5420, 5420) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.039 | 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) |
| 08:59:57.258 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (sales_id IS NOT NULL) |
| 08:59:57.041 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5070) AND (sales_id IS NOT NULL) |
| 08:59:57.288 | 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) |
| 08:59:57.230 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (sales_id IS NOT NULL) |
| 08:59:56.881 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (sales_id IS NOT NULL) |
| 08:59:57.057 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5095) AND (group_id IS NOT NULL) |
| 08:59:57.222 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (sales_id IS NOT NULL) |
| 08:59:57.334 | 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) |
| 08:59:57.066 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (sales_id IS NOT NULL) |
| 08:59:57.132 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5208) AND (sales_id IS NOT NULL) |
| 08:59:57.233 | 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) |
| 08:59:57.261 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1025) AND (sales_id IS NOT NULL) |
| 08:59:57.250 | 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) |
| 08:59:56.865 | 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) |
| 08:59:56.878 | 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) |
| 08:59:56.877 | 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) |
| 08:59:57.070 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1029) AND (group_id IS NOT NULL) |
| 08:59:57.077 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5037) AND (sales_id IS NOT NULL) |
| 08:59:57.241 | 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) |
| 08:59:57.246 | 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) |
| 08:59:57.299 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (group_id IS NOT NULL) |
| 08:59:56.885 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5030) AND (group_id IS NOT NULL) |
| 08:59:57.070 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1027) AND (sales_id IS NOT NULL) |
| 08:59:57.235 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (sales_id IS NOT NULL) |
| 08:59:57.241 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5252) AND (group_id IS NOT NULL) |
| 08:59:57.067 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5073) AND (group_id IS NOT NULL) |
| 08:59:57.018 | 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) |
| 08:59:57.058 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5420) AND (sales_id IS NOT NULL) |
| 08:59:57.243 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (sales_id IS NOT NULL) |
| 08:59:56.880 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (sales_id IS NOT NULL) |
| 08:59:57.330 | 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) |
| 08:59:57.254 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1013) AND (group_id IS NOT NULL) |
| 08:59:57.312 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5409) AND (group_id IS NOT NULL) |
| 08:59:57.038 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5249) AND (group_id IS NOT NULL) |
| 08:59:57.166 | 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) |
| 08:59:57.304 | 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) |
| 08:59:57.091 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5043) AND (sales_id IS NOT NULL) |
| 08:59:57.257 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5128) AND (sales_id IS NOT NULL) |
| 08:59:57.286 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (sales_id IS NOT NULL) |
| 08:59:57.085 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5048) AND (sales_id IS NOT NULL) |
| 08:59:57.180 | 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) |
| 08:59:56.866 | 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) |
| 08:59:57.036 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1012) AND (group_id IS NOT NULL) |
| 08:59:57.265 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5413) AND (group_id IS NOT NULL) |
| 08:59:57.261 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5203) AND (group_id IS NOT NULL) |
| 08:59:57.289 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5072) AND (group_id IS NOT NULL) |
| 08:59:57.065 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5082) AND (group_id IS NOT NULL) |
| 08:59:57.107 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5045) AND (sales_id IS NOT NULL) |
| 08:59:57.244 | 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) |
| 08:59:57.164 | 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) |
| 08:59:57.233 | 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) |
| 08:59:57.336 | 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) |
| 08:59:57.249 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5248) AND (group_id IS NOT NULL) |
| 08:59:56.872 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5083) AND (group_id IS NOT NULL) |
| 08:59:57.273 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (sales_id IS NOT NULL) |
| 08:59:56.876 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1017) AND (group_id IS NOT NULL) |
| 08:59:57.132 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5088) AND (group_id IS NOT NULL) |
| 08:59:57.061 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5445) AND (group_id IS NOT NULL) |
| 08:59:57.326 | 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) |
| 08:59:56.870 | 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) |
| 08:59:57.040 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5096) AND (group_id IS NOT NULL) |
| 08:59:57.275 | 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) |
| 08:59:57.286 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5025) AND (group_id IS NOT NULL) |
| 08:59:57.263 | 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) |
| 08:59:57.227 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5029) AND (group_id IS NOT NULL) |
| 08:59:57.287 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5105) AND (group_id IS NOT NULL) |
| 08:59:57.221 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5027) AND (group_id IS NOT NULL) |
| 08:59:57.308 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5393) AND (group_id IS NOT NULL) |
| 08:59:57.014 | 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) |
| 08:59:57.281 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5064) AND (group_id IS NOT NULL) |
| 08:59:57.130 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5031) AND (group_id IS NOT NULL) |
| 08:59:57.272 | 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) |
| 08:59:56.880 | 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) |
| 08:59:57.012 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5101) AND (group_id IS NOT NULL) |
| 08:59:57.084 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (sales_id IS NOT NULL) |
| 08:59:57.238 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5079) AND (group_id IS NOT NULL) |
| 08:59:57.028 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1016) AND (group_id IS NOT NULL) |
| 08:59:57.009 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.177 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5024) AND (group_id IS NOT NULL) |
| 08:59:57.230 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1021) AND (group_id IS NOT NULL) |
| 08:59:56.881 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1028) AND (group_id IS NOT NULL) |
| 08:59:57.217 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5300) AND (group_id IS NOT NULL) |
| 08:59:57.024 | 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) |
| 08:59:57.079 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (sales_id IS NOT NULL) |
| 08:59:57.329 | 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) |
| 08:59:57.046 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (group_id IS NOT NULL) |
| 08:59:57.317 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5229) AND (group_id IS NOT NULL) |
| 08:59:57.018 | 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) |
| 08:59:57.032 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5259) AND (group_id IS NOT NULL) |
| 08:59:57.059 | 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) |
| 08:59:57.016 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5302) AND (group_id IS NOT NULL) |
| 08:59:57.020 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5332) AND (group_id IS NOT NULL) |
| 08:59:57.030 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1026) AND (group_id IS NOT NULL) |
| 08:59:57.229 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5411) AND (group_id IS NOT NULL) |
| 08:59:57.324 | 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) |
| 08:59:57.278 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5388) AND (group_id IS NOT NULL) |
| 08:59:57.166 | 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) |
| 08:59:56.878 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1018) AND (group_id IS NOT NULL) |
| 08:59:57.225 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5311) AND (group_id IS NOT NULL) |
| 08:59:56.883 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5209) AND (group_id IS NOT NULL) |
| 08:59:57.338 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1014) AND (group_id IS NOT NULL) |
| 08:59:57.244 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5071) AND (group_id IS NOT NULL) |
| 08:59:56.874 | 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) |
| 08:59:57.083 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1008) AND (group_id IS NOT NULL) |
| 08:59:57.301 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5104) AND (group_id IS NOT NULL) |
| 08:59:57.234 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5066) AND (group_id IS NOT NULL) |
| 08:59:57.259 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5404) AND (group_id IS NOT NULL) |
| 08:59:56.867 | 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) |
| 08:59:57.333 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5333) AND (group_id IS NOT NULL) |
| 08:59:57.033 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5028) AND (group_id IS NOT NULL) |
| 08:59:57.273 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5126) AND (group_id IS NOT NULL) |
| 08:59:57.310 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5412) AND (group_id IS NOT NULL) |
| 08:59:57.276 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5075) AND (group_id IS NOT NULL) |
| 08:59:57.219 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1007) AND (group_id IS NOT NULL) |
| 08:59:57.268 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.283 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1004) AND (group_id IS NOT NULL) |
| 08:59:57.242 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5364) AND (group_id IS NOT NULL) |
| 08:59:57.010 | 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) |
| 08:59:57.167 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5294) AND (group_id IS NOT NULL) |
| 08:59:57.179 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5351) AND (group_id IS NOT NULL) |
| 08:59:57.245 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1009) AND (group_id IS NOT NULL) |
| 08:59:57.271 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1022) AND (group_id IS NOT NULL) |
| 08:59:57.236 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5069) AND (group_id IS NOT NULL) |
| 08:59:57.247 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5295) AND (group_id IS NOT NULL) |
| 08:59:57.323 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5296) AND (group_id IS NOT NULL) |
| 08:59:57.072 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5446) AND (sales_id IS NOT NULL) |
| 08:59:57.325 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5358) AND (group_id IS NOT NULL) |
| 08:59:57.267 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5023) AND (group_id IS NOT NULL) |
| 08:59:57.303 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5360) AND (group_id IS NOT NULL) |
| 08:59:57.321 | 0.5 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5304 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.026 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5419) AND (group_id IS NOT NULL) |
| 08:59:57.181 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1030) AND (group_id IS NOT NULL) |
| 08:59:57.297 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (group_id IS NOT NULL) |
| 08:59:57.336 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5297) AND (group_id IS NOT NULL) |
| 08:59:57.338 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5093) AND (sales_id IS NOT NULL) |
| 08:59:57.320 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1005) AND (group_id IS NOT NULL) |
| 08:59:57.274 | 0.5 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5032) AND (group_id IS NOT NULL) |
| 08:59:57.298 | 0.5 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5359) AND (sales_id IS NOT NULL) |
| 08:59:57.042 | 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) |
| 08:59:57.318 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.269 | 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) |
| 08:59:57.080 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5087) AND (group_id IS NOT NULL) |
| 08:59:57.292 | 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) |
| 08:59:57.085 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5123) AND (group_id IS NOT NULL) |
| 08:59:57.296 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5440) AND (sales_id IS NOT NULL) |
| 08:59:57.321 | 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) |
| 08:59:57.258 | 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) |
| 08:59:57.084 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1001, 1003, 1006, 5062, 1005, 5087, 5074, 5128, 5123, 5026, 5088, 1008, 1004, 5072, 5076, 5089, 5093, 5096) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.217 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (5300, 5309, 5311) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.320 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5304) AND (sales_id IS NOT NULL) |
| 08:59:57.325 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5358 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.078 | 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) |
| 08:59:57.255 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1015) AND (sales_id IS NOT NULL) |
| 08:59:56.999 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5299 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.288 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5072 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.306 | 0.4 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5247) AND (group_id IS NOT NULL) |
| 08:59:57.311 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5409 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.108 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5045 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.256 | 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) |
| 08:59:57.075 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.178 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.317 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5229 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.308 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.274 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5032 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.237 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.039 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5096 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.284 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.291 | 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) |
| 08:59:56.871 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.082 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1008 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.165 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id" IN (1003, 5209, 5203) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.219 | 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 |
| 08:59:57.181 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1030 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.299 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.257 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5128 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.332 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.078 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5037 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.279 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.306 | 0.4 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.042 | 0.4 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5102) AND (sales_id IS NOT NULL) |
| 08:59:57.339 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5093 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.058 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5420 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.298 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5359 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.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" |
| 08:59:57.129 | 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 |
| 08:59:56.867 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5049 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.874 | 0.4 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5301 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.167 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5294 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.247 | 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 |
| 08:59:57.041 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5070 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.236 | 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 |
| 08:59:57.242 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5364 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.225 | 0.3 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.080 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5087 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.245 | 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 |
| 08:59:57.086 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5048 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:56.879 | 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 |
| 08:59:57.331 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=1006) AND (group_id IS NOT NULL) |
| 08:59:57.220 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5027 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.034 | 0.3 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:56.883 | 0.3 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" WHERE ("role_name"='AccountManager') AND (user_id IS NOT NULL) GROUP BY "user_id" |
| 08:59:57.131 | 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 |
| 08:59:56.882 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5209 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.015 | 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 |
| 08:59:57.013 | 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 |
| 08:59:57.021 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5047) AND (sales_id IS NOT NULL) |
| 08:59:57.234 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5066 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.223 | 0.3 ms | yii\db\Command::query | SELECT "group_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5089) AND (group_id IS NOT NULL) |
| 08:59:57.262 | 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 |
| 08:59:57.260 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5203 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.022 | 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 |
| 08:59:57.029 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=1026 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.091 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5043 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.222 | 0.3 ms | yii\db\Command::query | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" WHERE "id"=5089 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 08:59:57.292 | 0.3 ms | yii\db\Command::query | SELECT "sales_id" FROM "a57be577deb434"."tbl_user_resource_relationships" WHERE ("user_id"=5033) AND (sales_id IS NOT NULL) |
| 08:59:57.019 | 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 |
| 08:59:57.276 | 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 |
| 08:59:57.292 | 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 |