2026年3月8号 收入排行
| 名次 |
姓名 |
收入(元) |
|
🥇
|
王* |
48179.00 元 |
|
🥈
|
刘* |
34584.00 元 |
|
🥉
|
王* |
31650.00 元 |
|
4 |
支*英 |
27363.00 元 |
|
5 |
谢*平 |
16446.00 元 |
|
6 |
黄*宝 |
12650.00 元 |
|
7 |
王*龙 |
12330.00 元 |
|
8 |
张*帆 |
8263.00 元 |
|
9 |
李*菱 |
1344.00 元 |
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-03-10 02:13:20 HTTP/2.0 GET : https://baobiao.lzhx99.com/
- 运行时间 : 0.090230s [ 吞吐率:11.08req/s ] 内存消耗:4,280.55kb 文件加载:148
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=df18d6d3aee7aa60f702e3667c48f963
- CONNECT:[ UseTime:0.002918s ] mysql:host=49.232.215.22;port=3306;dbname=baobiao;charset=utf8
- SHOW FULL COLUMNS FROM `setting` [ RunTime:0.003804s ]
- SELECT * FROM `setting` WHERE `key` = 'default_display_date' LIMIT 1 [ RunTime:0.001923s ]
- SELECT * FROM `setting` WHERE `key` = 'default_display_month' LIMIT 1 [ RunTime:0.001893s ]
- SELECT * FROM `setting` WHERE `key` = 'default_display_day' LIMIT 1 [ RunTime:0.001898s ]
- SHOW FULL COLUMNS FROM `amount_record` [ RunTime:0.003455s ]
- SHOW FULL COLUMNS FROM `user` [ RunTime:0.003374s ]
- SELECT user_id, SUM(amount) as total FROM `amount_record` WHERE `month` = '2026-03' AND ( COALESCE(record_date, DATE(create_time)) <= '2026-03-08' ) AND `user_id` IN (SELECT `id` FROM `user` WHERE `disabled` = 0) GROUP BY `user_id` ORDER BY `total` DESC [ RunTime:0.001937s ]
- SELECT `name`,`id` FROM `user` WHERE `id` IN (30,24,25,26,29,27,28,32,31) [ RunTime:0.001907s ]
0.096104s