欢迎各位兄弟 发布技术文章
这里的技术是共享的
查询 |
SELECT users.uid AS uid, users.name AS users_name, userpoints.max_points AS userpoints_max_points, userpoints.points AS userpoints_points, users.access AS users_access FROM users users LEFT JOIN users_roles users_roles ON users.uid = users_roles.uid AND users_roles.rid = 7 LEFT JOIN users_roles users_roles_value_0 ON users.uid = users_roles_value_0.uid AND users_roles_value_0.rid = 15 LEFT JOIN userpoints userpoints ON users.uid = userpoints.uid WHERE (users_roles.rid IS NULL) AND (users_roles_value_0.rid = 15) ORDER BY users_access DESC
|
标题 | |
路径 | 这个显示没有路径 |
查询构建时间 | 8.55 毫秒 |
查询执行时间 | 2.58 毫秒 |
视图呈现时间 | 30.19 毫秒 |