[ DB ] CONNECT:[ UseTime:0.000559s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000691s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.001090s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.000598s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`user_id` IN ('10000','18888','16666','10099','200888','201888','202888','203888','205888','206888','207888','208888','210888','211888','212888','213888','215888','216888','204888','217888','214888','218888','220888','221888','222888','223888','224888','225888','226888','227888','228888','230888','231888','232888','233888','234888','235888','236888','237888','238888','277777','200008','200666','201666','202666','203666','204666','205666','206666','207666','208666','209666','210666','211666','212666','213666','214666','215666','216666','217666','218666','219666','220666','22222','227777','444444','400000','44444','201111','202222','203333','209999','205555','212222','215555','223333','225555','226666','200088','222228','222288','222666','222999','220000','222000','258258','211111','288888','206662','225666','227666','222220','200000','200777','228666','230666','499999','222227','201777','231666','477777','229999','202777','201999','202999','203999','205999','206999','207999','208999','210999','444999','449999','444499','466666','299999','400004','488888','21177','266666','222277','220008','201206','212777','213777','210000','215777','216777','217777','218777','219777','220777','221777','223777','225777','226777','200002','212999','220088','200999','227999','228999','230999','49999','231999','210777','200828','230777','292929','232777','236777','237777','235777','257999','258777','40000','255777','235999','255888','256777','17777','260666','285555','286666','281111','289999','282222','283333','280888','225588','411111','277111','277222','277333','277555','277999','277888','277666','256888','222208','223008','222008','220018','220028','220038','220058','239999','220068','202577','200122','257888','250777','251777','252777','253777','257777','260777','261777','262777','263777','265777','266777','267777','268777','269777','270777','271777','272777','273777','275777','276777','226688','223388','222290','222088','252888','200521','202521','2111111','277444','400521','46666','290999','290888','10521','222222','10088','288001','288002','288003','288004','288005','288006','288007','288008','288009','288010','288011','288012','288013','288014','288015','288016','288017','288018','288019','288020','288021','288022','288023','288024','288025','288026','288027','288028','288029','288030','288031','288032','288033','288034','288035','288036','288037','288038','288039','288040','288050','288051','288052','288053','288055','288056','288057','288058','288059','288060','456789','212521','20022','277668','288666','288088','288188','280777','222225','222777','210001','210002','211011','212001','213001','215001','216001','217001','219001','213333','219999','222255','272727','20010','200010','203344','237999','223344','280010','229888','223355','202020','400008','232323','252525','225599','444448','288555','288080','288222','288111','288777','45678','288999','288061','288123','288062','288333','288063','288066','433333','288067','222258','221258','220999','221999','223999','225999','226999','238999','288068','288069','288070','288071','288072','288073','212258','221188','288075','288076','19999','47777','200009','223088','288808','200555','201555','202555','203555','204555','206555','207555','208555','209555','210555','277885','222209','258888','41717','22799','202288','41111','40008','288077','288078','288079','288081','288082','229918','288089','275888','205777','40088','211001','200701','200788','209209','233088','222388','212121','210009','220009','211009','222009','212009','213009','215009','230009','222223','222221','204444','225225','221009','223009','233009','232009','235009','225009','259777','225001','200099','227009','250009','255079','257009','288083','288085','250799','251001','255009','47999','271717','222211','10020','200020','262626','10009','200007','220077','200727','202001','202002','202003','222022','220222','211112','233399','233001','202009','277000','226009','228009','229009','299099','220599','255099','237009','250299','233333','200333','201333','202333','205333','206333','210333','266888','211333','212333','215333','216333','40999','236009','222007','13333','205099','218333','219333','225333','252001','288090','281888','222588','211115','238009','200017','40004','230333','43333','288300','270009','232333','231333','235333','231009','201314','40001','278008','250999','251009','288092','400001','221212','271009','20088','200258','44443','211119','278800','278801','278802','278803','278805','278806','278807','278808','278809','278810','278811','278812','278888','276888','280000','280001','280002','280003','280005','280006','280007','280008','278009','277009','260009','261009','262009','263009','45555','266009','265009','267009','275111','277280','268009','266999','277061','278280','400009','233002','269009','213213','201987','277001','233033','288091','226699','10927','29999','220799','27777','11999','231079','279999','260001','259999','200056','222509','239009','236008','222339','287777','200117','253009','252009','256009','272009','220020','273009','200001','275799','222122','222079','200006','222799','221799','223799','225799','22022','233339','288227','233023','960','1001','251333','448888','252333','253333','256333','28888','209888','222229','222299','299001','299002','299003','299005','299006','299007','299008','299009','400003','299101','299102','299103','22228','288099','21105','200003','226832','299106','299105','299107','299108','444449','299109','2273','299120','299121','299123','211999','222279','9210','2793','444447','244447','3333333','299125','288882','288883','299126','299128','299129','299130','15555','299131','299132','444446','299133','299135','299136','444445','255766','233755','288098','288880','21310','226223','266099','233991','273355','275518','229988','222661') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.175094s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` NOT IN ('10000','18888','16666','10099','200888','201888','202888','203888','205888','206888','207888','208888','210888','211888','212888','213888','215888','216888','204888','217888','214888','218888','220888','221888','222888','223888','224888','225888','226888','227888','228888','230888','231888','232888','233888','234888','235888','236888','237888','238888','277777','200008','200666','201666','202666','203666','204666','205666','206666','207666','208666','209666','210666','211666','212666','213666','214666','215666','216666','217666','218666','219666','220666','22222','227777','444444','400000','44444','201111','202222','203333','209999','205555','212222','215555','223333','225555','226666','200088','222228','222288','222666','222999','220000','222000','258258','211111','288888','206662','225666','227666','222220','200000','200777','228666','230666','499999','222227','201777','231666','477777','229999','202777','201999','202999','203999','205999','206999','207999','208999','210999','444999','449999','444499','466666','299999','400004','488888','21177','266666','222277','220008','201206','212777','213777','210000','215777','216777','217777','218777','219777','220777','221777','223777','225777','226777','200002','212999','220088','200999','227999','228999','230999','49999','231999','210777','200828','230777','292929','232777','236777','237777','235777','257999','258777','40000','255777','235999','255888','256777','17777','260666','285555','286666','281111','289999','282222','283333','280888','225588','411111','277111','277222','277333','277555','277999','277888','277666','256888','222208','223008','222008','220018','220028','220038','220058','239999','220068','202577','200122','257888','250777','251777','252777','253777','257777','260777','261777','262777','263777','265777','266777','267777','268777','269777','270777','271777','272777','273777','275777','276777','226688','223388','222290','222088','252888','200521','202521','2111111','277444','400521','46666','290999','290888','10521','222222','10088','288001','288002','288003','288004','288005','288006','288007','288008','288009','288010','288011','288012','288013','288014','288015','288016','288017','288018','288019','288020','288021','288022','288023','288024','288025','288026','288027','288028','288029','288030','288031','288032','288033','288034','288035','288036','288037','288038','288039','288040','288050','288051','288052','288053','288055','288056','288057','288058','288059','288060','456789','212521','20022','277668','288666','288088','288188','280777','222225','222777','210001','210002','211011','212001','213001','215001','216001','217001','219001','213333','219999','222255','272727','20010','200010','203344','237999','223344','280010','229888','223355','202020','400008','232323','252525','225599','444448','288555','288080','288222','288111','288777','45678','288999','288061','288123','288062','288333','288063','288066','433333','288067','222258','221258','220999','221999','223999','225999','226999','238999','288068','288069','288070','288071','288072','288073','212258','221188','288075','288076','19999','47777','200009','223088','288808','200555','201555','202555','203555','204555','206555','207555','208555','209555','210555','277885','222209','258888','41717','22799','202288','41111','40008','288077','288078','288079','288081','288082','229918','288089','275888','205777','40088','211001','200701','200788','209209','233088','222388','212121','210009','220009','211009','222009','212009','213009','215009','230009','222223','222221','204444','225225','221009','223009','233009','232009','235009','225009','259777','225001','200099','227009','250009','255079','257009','288083','288085','250799','251001','255009','47999','271717','222211','10020','200020','262626','10009','200007','220077','200727','202001','202002','202003','222022','220222','211112','233399','233001','202009','277000','226009','228009','229009','299099','220599','255099','237009','250299','233333','200333','201333','202333','205333','206333','210333','266888','211333','212333','215333','216333','40999','236009','222007','13333','205099','218333','219333','225333','252001','288090','281888','222588','211115','238009','200017','40004','230333','43333','288300','270009','232333','231333','235333','231009','201314','40001','278008','250999','251009','288092','400001','221212','271009','20088','200258','44443','211119','278800','278801','278802','278803','278805','278806','278807','278808','278809','278810','278811','278812','278888','276888','280000','280001','280002','280003','280005','280006','280007','280008','278009','277009','260009','261009','262009','263009','45555','266009','265009','267009','275111','277280','268009','266999','277061','278280','400009','233002','269009','213213','201987','277001','233033','288091','226699','10927','29999','220799','27777','11999','231079','279999','260001','259999','200056','222509','239009','236008','222339','287777','200117','253009','252009','256009','272009','220020','273009','200001','275799','222122','222079','200006','222799','221799','223799','225799','22022','233339','288227','233023','960','1001','251333','448888','252333','253333','256333','28888','209888','222229','222299','299001','299002','299003','299005','299006','299007','299008','299009','400003','299101','299102','299103','22228','288099','21105','200003','226832','299106','299105','299107','299108','444449','299109','2273','299120','299121','299123','211999','222279','9210','2793','444447','244447','3333333','299125','288882','288883','299126','299128','299129','299130','15555','299131','299132','444446','299133','299135','299136','444445','255766','233755','288098','288880','21310','226223','266099','233991','273355','275518','229988','222661') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.184967s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000688s ]
[ 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.006154s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000568s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:5.963675s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.008329s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000479s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000439s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000456s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000454s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000470s ]
[ 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-02-25 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-02-25 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-02-23' AND `p`.`create_time` <= '2026-03-01 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000470s ]
微信
QQ
