[ DB ] CONNECT:[ UseTime:0.000402s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000546s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.000154s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.000336s ]
[ SQL ] SELECT sum(p.total_value) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_user_tops` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`user_id` IN ('78906','19703','160002','7721','10666','8881','81888','81889','281802','71503') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.018175s ]
[ SQL ] SELECT sum(p.total_volume) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_user_tops` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` NOT IN ('78906','19703','160002','7721','10666','8881','81888','81889','281802','71503') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.012018s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000544s ]
[ SQL ] SELECT `s`.*,l1.user_level as level1,u1.user_name as name1,u1.user_head_url as headurl,`l2`.`user_level`,`u2`.`user_name`,`u2`.`user_head_url`,`s`.`start_time`,`s`.`end_time` FROM `tb_prop_siege` `s` LEFT JOIN `tb_user_info` `u1` ON `s`.`user_id`=`u1`.`user_id` LEFT JOIN `tb_user_level` `l1` ON `s`.`user_id`=`l1`.`user_id` LEFT JOIN `tb_user_info` `u2` ON `s`.`users_id`=`u2`.`user_id` LEFT JOIN `tb_user_level` `l2` ON `s`.`users_id`=`l2`.`user_id` LIMIT 10 [ RunTime:0.017957s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000486s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.034555s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.034528s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010642s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010950s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010828s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010780s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010864s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2026-01-02 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-01-02 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-12-29' AND `p`.`create_time` <= '2026-01-04 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.010862s ]
微信
QQ
