[ DB ] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;dbname=sky_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.040491s ]
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.001050s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 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.010397s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 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.001080s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.001523s ]
[ 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.000573s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000643s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000522s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000488s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000450s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000429s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000605s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000637s ]
[ 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` >= '2025-12-17 00:00:00.001' AND `p`.`create_time` <= '2025-12-17 23:59:59.999' AND `l`.`user_level` >= 62 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-12-15' AND `p`.`create_time` <= '2025-12-21 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000636s ]
微信
QQ
