[ DB ] CONNECT:[ UseTime:0.000760s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.001290s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.000538s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.001092s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`user_id` = '10000' GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.001350s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` <> '10000' GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.001084s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000874s ]
[ 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.000619s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000918s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000932s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000899s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000719s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000656s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000738s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000607s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000674s ]
[ 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-05-13 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-05-13 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-05-11' AND `p`.`create_time` <= '2026-05-17 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000626s ]
微信
QQ
