[ DB ] CONNECT:[ UseTime:0.000220s ] mysql:host=127.0.0.1;port=3306;dbname=sky_db;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000606s ]
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000346s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_income) 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND `p`.`users_id` IN (SELECT `user_id` FROM `tb_room_artist`) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.000573s ]
[ SQL ] SELECT p.prop_id, p.user_id, sum(p.prop_num * p.prop_price) as oo, 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`.`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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` < 62 ) AND `p`.`user_id` NOT IN (SELECT `user_id` FROM `tb_room_artist`) GROUP BY `p`.`user_id` ORDER BY `oo` DESC LIMIT 15 [ RunTime:0.000396s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000358s ]
[ 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.000302s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000348s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000333s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000283s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000270s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000299s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000289s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000304s ]
[ 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-31 00:00:00.001' AND `p`.`create_time` <= '2026-01-31 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-01-26' AND `p`.`create_time` <= '2026-02-01 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000288s ]
微信
QQ
