[ DB ] CONNECT:[ UseTime:0.000632s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000985s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.000788s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.000957s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`user_id` IN ('686868','90001','10001','19999','12333','18888','10777','10123','10033','10818','10333','10088','10168','10008','12222','10066','10009','12345','16666','11111','16888','10111','15555','17777','616161','160001','696969','90006','90007','90005','935038','613767','20000','151665','787394','327220','205782','878158','573697','891612','473490','380642','230123','824968','802270','592598','627858','843180','978481','634104','575608','800294','923851','628919','229031','354210','496983','776170','282374','102358','166498','596046','526312','132765','489741','756420','200553','119104','174992','235581','310622','961001','631350','836520','127720','688536','227750','452962','376126','474325','535109','448468','416879','439209','311509','609780','659035','801886','802403','301421','254250','506037','901573','615853','113857','270396','131446','901734','124052','791712','246979','214613','508675','672472','584156','930319','543358','970040','128128','658935','563813','349626','800778','773413','870308','919136','268660','782626','397210','384654','921761','623802','447984','961123','264433','860839','698083','569017','499104','872676','527170','496159','921705','532425','699019','685973','827379','957788','543916','262797','266004','881355','490052','385417','368518','625953','420209','188164','740272','859253','597149','555040','586114','941720','903424','205103','230796','460883','444371','894996','935249','494716','521870','558400','766775','731900','315622','695888','671895','394765','578697','355469','852891','302080','552191','216144','943647','909856','232543','921088','885632','537298','337291','452465','930230','603422','609947','660498','720311','571434','13333','513034','135689','905376','486273','827914','902643','682994','471982','901568','521068','993051','616931','518696','331363','800919','516615','108702','316931','669555','271116','941105','331369','162089','785139','911067','172728','976260','567819','790957','155199','691982','481543','191889','208343','383136','818591','742683','697442','618790') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.005210s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` NOT IN ('686868','90001','10001','19999','12333','18888','10777','10123','10033','10818','10333','10088','10168','10008','12222','10066','10009','12345','16666','11111','16888','10111','15555','17777','616161','160001','696969','90006','90007','90005','935038','613767','20000','151665','787394','327220','205782','878158','573697','891612','473490','380642','230123','824968','802270','592598','627858','843180','978481','634104','575608','800294','923851','628919','229031','354210','496983','776170','282374','102358','166498','596046','526312','132765','489741','756420','200553','119104','174992','235581','310622','961001','631350','836520','127720','688536','227750','452962','376126','474325','535109','448468','416879','439209','311509','609780','659035','801886','802403','301421','254250','506037','901573','615853','113857','270396','131446','901734','124052','791712','246979','214613','508675','672472','584156','930319','543358','970040','128128','658935','563813','349626','800778','773413','870308','919136','268660','782626','397210','384654','921761','623802','447984','961123','264433','860839','698083','569017','499104','872676','527170','496159','921705','532425','699019','685973','827379','957788','543916','262797','266004','881355','490052','385417','368518','625953','420209','188164','740272','859253','597149','555040','586114','941720','903424','205103','230796','460883','444371','894996','935249','494716','521870','558400','766775','731900','315622','695888','671895','394765','578697','355469','852891','302080','552191','216144','943647','909856','232543','921088','885632','537298','337291','452465','930230','603422','609947','660498','720311','571434','13333','513034','135689','905376','486273','827914','902643','682994','471982','901568','521068','993051','616931','518696','331363','800919','516615','108702','316931','669555','271116','941105','331369','162089','785139','911067','172728','976260','567819','790957','155199','691982','481543','191889','208343','383136','818591','742683','697442','618790') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.007933s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000957s ]
[ 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.000698s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000965s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.054193s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.040550s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000879s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000692s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000709s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000655s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000650s ]
[ 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-06-11 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-06-11 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-06-08' AND `p`.`create_time` <= '2026-06-14 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000651s ]
微信
QQ
攻城排行榜
是十二呢-10818
礼物榜
本周
|
上周
