[ DB ] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000886s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.002404s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.000660s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 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','230888','231888','232888','233888','234888','235888','236888','237888','238888','277777','200008','201666','202666','203666','204666','205666','206666','207666','208666','209666','210666','211666','212666','213666','214666','215666','216666','217666','218666','219666','220666','22222','227777','444444','400000','202222','203333','209999','205555','212222','215555','223333','225555','226666','200088','222228','222288','222666','222999','220000','222000','258258','211111','288888','206662','225666','227666','222220','228666','230666','499999','222227','231666','201999','202999','203999','205999','206999','207999','208999','210999','444999','449999','444499','299999','488888','21177','266666','222277','220008','201206','210000','212999','220088','227999','228999','230999','49999','231999','200828','292929','257999','235999','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','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','290999','290888','10521','222222','10088','288001','288002','288003','288004','288005','288006','288007','288008','288009','288010','288011','288012','288013','288014','288015','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','222225','210001','210002','211011','212001','213001','215001','216001','217001','219001','213333','219999','222255','272727','20010','200010','203344','237999','223344','280010','229888','223355','400008','232323','252525','225599','444448','288555','288080','288222','288111','288777','45678','288999','288061','288123','288062','288333','288063','288066','433333','288067','222258','221258','288068','288069','288070','288071','288072','288073','212258','221188','288075','288076','47777','200009','223088','288808','200555','201555','202555','203555','204555','206555','207555','208555','209555','210555','277885','258888','41717','22799','202288','41111','40008','288077','288078','288079','288081','288082','288089','275888','40088','211001','200701','200788','209209','233088','222388','212121','210009','220009','211009','222009','213009','215009','230009','222223','222221','204444','225225','221009','223009','233009','232009','235009','225009','225001','250009','255079','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','220599','255099','237009','250299','233333','200333','201333','202333','205333','206333','210333','266888','211333','212333','215333','216333','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','253009','252009','256009','272009','220020','273009','200001','275799','222122','222079','200006','222799','221799','223799','225799','22022','233339','288227','233023','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','299120','299121','299123','211999','222279','9210','444447','244447','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','10006','258009','259009','288100','288101','22227','206011','206022','206033','206044','206055','206066','206077','206088','206099','206086','206085','206087','206000','206078','206098','206206','206777','206222','226166','288889','275110','288967','255337','255336','255993','277667','257313','273166','288330','233066','279079','233077','210006','222916','233155','288331','289009','266001','266002','266003','266005','200300','22666','279099','208389','207009','276658','233768','288886','236666','288109','288887','222898','276666','22000','220978','217717','227955','200012','250003','288711','255001','255002','255003','255004','255005','255006','255007','255008','255010','255011','255012','255013','255015','255016','255017','255018','255019','255020','278880','278881','278882','278883','20000','287565','258875','266368','233089','200022','2666666','22888','288110','288112','226626','222689','255501','288801','288802','288803','288805','288806','288807','288809','288804','258096','255021','255022','255023','255025','255026','255027','255028','255029','269888','222020','288113','222001','222002','222003','222005','222006','222010','222011','288812','222777','288966','260111','288115','227956','299969','222012','222013','229629','222015','222016','422222','222017','222018','222019','222021','222023','222025','222026','12222','222200','222027','222199','444405','410088','219000','222028','222029','222030','226633','222031','222696','222032','222209','222033','219008','226987','L263880','209887','298611','222035','222039','202008','222077','222036','228567','229696','288299','288875','266785','288366','222121','222323','222176','202799','288277','10056','288276','17888','263556','233036','250023','222120','222119','223231','220898','222910','21111','288676','288858','277788','201799','250019','250018','206776','226656','277008','289001','289002','289003','289005','289006','289007','289008','289010','289011','18999','255033','299909','440009','219099','10555','208880','296009','288675','200802','288208','288369','288234','228658','288288','279001','20111','279011','277223','22777','288838','288989','213323','216631','229598','288303','444344','22221','219002','279003','279002','222210','279006','287008','268001','268002','268003','268005','268006','221233','261688','288787','211255','288266','90808','228801','223232','220881','229652','10222','440033','421111','288210','288569','4000002','400002','226565','403333','253001','288818','288397','217997','288822','288821','288820','288823','288825','288826','288827','288828','288829','288658','279098','279269','440999','279279','19999','219901','219902','219903','219905','219906','219907','219908','219909','219910','219911','251888','290636','201551','288660','223532','266563','220212','226533','222653','209901','219900','288665','288532','222533','219922','219222','419999','266656','200601','219003','288233','288232','200901','210901','210902','210903','210905','210906','210907','210908','210909','210910','225332','226562','221881','200011','221767','255323','237588','276155','213366','218956','227655','226650','233122','233276','233653','23000','227632','288561','288235','288836','288770','219960','212555','214444','266532','212655','279091','221776','211653','211231','211533','278886','278885','278889','26888','268881','268882','268883','268885','268886','268887','268889','202201','202202','202203','202205','202206','202207','202208','202209','202231','202232','202235','202236','202237','202238','202239','202250','202251','202253','202255','202256','295009','273376','220533','228998','223765','22999','229999','200999','233733','233632','286001','286002','268007','18666','268008','15888','268010','268012','268013','268015','268016','268017','258801','258802','258803','258805','258806','258807','258809','258810','258812','258811','258813','258015','258816','258817','258818','258819','258820','258821','258822','258823','277079','233880','297009','233025','258830','258831','258832','258835','258836','258837','258838','258839','258850','258851','221533','288855','268823','268822','268112','255502','208569','216978','211991','288766','266118','200909','207777','201007','222270','408888','210003','210005','210007','210008','210010','210011','210012','210013','210015','210016','210017','210018','210019','210020','210021','210022','210023','210025','210026','210027','210028','210029','210030','210031','210032','210033','210035','210036','210037','210038','210039','210050','210051','210052','210053','210055','210056','210057','210058','210059','285681','296999','200868','11110','11000','258000','410000','210004','210060','210061','210088','210099','222226','202020','229001','40000','411000','288268','255503','288852','210063','210065','200200','288588','288500','221218','100000','218001','218002','218003','218005','288833','467777','218006','211532','288830','288831','210722','213127','288859','299899','228052','233752','268832','268831','288885','222522','219988','255586','223033','279901','288201','288202','233212','209669','288321','90361','221333','233911','210720','444222','216675','200126','222727','211021','211022','211023','211025','211026','211027','211028','211029','211020','211012','201113','288868','444404','201120','227575','219662','288816','444888','222076','268178','288688','270660','209001','209002','218812','217767','219979','223111','233121','221211','219555','270512','227852','16888','160001','160002','160003','205050','215050','10118','206800','206801','206802','206803','206805','206806','206807','206808','206809','206810','206811','200068','201001','200188','229565','206877','10068','252011','252012','252013','252015','252016','252006','252008','252088','252099','252035','252080','250060','288896','207662','207558','2520880','250898','250278','252077','255769','256555','11520','10033','203001','203002','203301','203302','203303','203305','203306','203307','203308','203309','203310','203311','203312','203313','203315','203316','203317','203318','203319','203320','203321','203322','203323','203325','203326','203327','203328','203329','203330','20666','200111','200099','203015','203016','226677','230231','233233','233332','223366','258880','203005','200057','223377','225577','225566','225533','255185','227711','221155','208886','271711','258585','201111','221182','221132','221183','222752','228888','221127','221101','266622','218772','221181','221102','221187','221156','221100','221199','221998','223233','221153','221197','221177','221198','411999','6755','400005','230353','233767','285233','260008','275233','275166','233756','200927','288678','221551','221176','219111','227522','223224','288258','288190','288259','228868','218989','223255','234567','200508','233882','232553','290009','221157','288257','221172','268508','258808','258815','258855','258852','258856','258857','258853','258858','258860','258889','258861','258862','258828','258863','258865','275515','258878','288898','288879','215668','257515','233833','268801','233761','203366','233769','280009','221228','227272','223155','215220','212280','255955','200005','220733','233821','200821','220333','200033','288895','222269','26969','222828','223122','288893','28808','288580','211578','268802','211522','221665','221322','288265','277157','268803','250550','255870','288892','268805','2228122','223226','20002','200002','221121','288891','200777','288093','200666','277568','252002','252003','252005','252007','252010','202005','202007','202010','202011','202012','202013','202015','202016','202017','202018','202019','202006','200018','200019','257577','228552','288890','266886','226682','400004','400044') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.021051s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 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','230888','231888','232888','233888','234888','235888','236888','237888','238888','277777','200008','201666','202666','203666','204666','205666','206666','207666','208666','209666','210666','211666','212666','213666','214666','215666','216666','217666','218666','219666','220666','22222','227777','444444','400000','202222','203333','209999','205555','212222','215555','223333','225555','226666','200088','222228','222288','222666','222999','220000','222000','258258','211111','288888','206662','225666','227666','222220','228666','230666','499999','222227','231666','201999','202999','203999','205999','206999','207999','208999','210999','444999','449999','444499','299999','488888','21177','266666','222277','220008','201206','210000','212999','220088','227999','228999','230999','49999','231999','200828','292929','257999','235999','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','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','290999','290888','10521','222222','10088','288001','288002','288003','288004','288005','288006','288007','288008','288009','288010','288011','288012','288013','288014','288015','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','222225','210001','210002','211011','212001','213001','215001','216001','217001','219001','213333','219999','222255','272727','20010','200010','203344','237999','223344','280010','229888','223355','400008','232323','252525','225599','444448','288555','288080','288222','288111','288777','45678','288999','288061','288123','288062','288333','288063','288066','433333','288067','222258','221258','288068','288069','288070','288071','288072','288073','212258','221188','288075','288076','47777','200009','223088','288808','200555','201555','202555','203555','204555','206555','207555','208555','209555','210555','277885','258888','41717','22799','202288','41111','40008','288077','288078','288079','288081','288082','288089','275888','40088','211001','200701','200788','209209','233088','222388','212121','210009','220009','211009','222009','213009','215009','230009','222223','222221','204444','225225','221009','223009','233009','232009','235009','225009','225001','250009','255079','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','220599','255099','237009','250299','233333','200333','201333','202333','205333','206333','210333','266888','211333','212333','215333','216333','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','253009','252009','256009','272009','220020','273009','200001','275799','222122','222079','200006','222799','221799','223799','225799','22022','233339','288227','233023','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','299120','299121','299123','211999','222279','9210','444447','244447','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','10006','258009','259009','288100','288101','22227','206011','206022','206033','206044','206055','206066','206077','206088','206099','206086','206085','206087','206000','206078','206098','206206','206777','206222','226166','288889','275110','288967','255337','255336','255993','277667','257313','273166','288330','233066','279079','233077','210006','222916','233155','288331','289009','266001','266002','266003','266005','200300','22666','279099','208389','207009','276658','233768','288886','236666','288109','288887','222898','276666','22000','220978','217717','227955','200012','250003','288711','255001','255002','255003','255004','255005','255006','255007','255008','255010','255011','255012','255013','255015','255016','255017','255018','255019','255020','278880','278881','278882','278883','20000','287565','258875','266368','233089','200022','2666666','22888','288110','288112','226626','222689','255501','288801','288802','288803','288805','288806','288807','288809','288804','258096','255021','255022','255023','255025','255026','255027','255028','255029','269888','222020','288113','222001','222002','222003','222005','222006','222010','222011','288812','222777','288966','260111','288115','227956','299969','222012','222013','229629','222015','222016','422222','222017','222018','222019','222021','222023','222025','222026','12222','222200','222027','222199','444405','410088','219000','222028','222029','222030','226633','222031','222696','222032','222209','222033','219008','226987','L263880','209887','298611','222035','222039','202008','222077','222036','228567','229696','288299','288875','266785','288366','222121','222323','222176','202799','288277','10056','288276','17888','263556','233036','250023','222120','222119','223231','220898','222910','21111','288676','288858','277788','201799','250019','250018','206776','226656','277008','289001','289002','289003','289005','289006','289007','289008','289010','289011','18999','255033','299909','440009','219099','10555','208880','296009','288675','200802','288208','288369','288234','228658','288288','279001','20111','279011','277223','22777','288838','288989','213323','216631','229598','288303','444344','22221','219002','279003','279002','222210','279006','287008','268001','268002','268003','268005','268006','221233','261688','288787','211255','288266','90808','228801','223232','220881','229652','10222','440033','421111','288210','288569','4000002','400002','226565','403333','253001','288818','288397','217997','288822','288821','288820','288823','288825','288826','288827','288828','288829','288658','279098','279269','440999','279279','19999','219901','219902','219903','219905','219906','219907','219908','219909','219910','219911','251888','290636','201551','288660','223532','266563','220212','226533','222653','209901','219900','288665','288532','222533','219922','219222','419999','266656','200601','219003','288233','288232','200901','210901','210902','210903','210905','210906','210907','210908','210909','210910','225332','226562','221881','200011','221767','255323','237588','276155','213366','218956','227655','226650','233122','233276','233653','23000','227632','288561','288235','288836','288770','219960','212555','214444','266532','212655','279091','221776','211653','211231','211533','278886','278885','278889','26888','268881','268882','268883','268885','268886','268887','268889','202201','202202','202203','202205','202206','202207','202208','202209','202231','202232','202235','202236','202237','202238','202239','202250','202251','202253','202255','202256','295009','273376','220533','228998','223765','22999','229999','200999','233733','233632','286001','286002','268007','18666','268008','15888','268010','268012','268013','268015','268016','268017','258801','258802','258803','258805','258806','258807','258809','258810','258812','258811','258813','258015','258816','258817','258818','258819','258820','258821','258822','258823','277079','233880','297009','233025','258830','258831','258832','258835','258836','258837','258838','258839','258850','258851','221533','288855','268823','268822','268112','255502','208569','216978','211991','288766','266118','200909','207777','201007','222270','408888','210003','210005','210007','210008','210010','210011','210012','210013','210015','210016','210017','210018','210019','210020','210021','210022','210023','210025','210026','210027','210028','210029','210030','210031','210032','210033','210035','210036','210037','210038','210039','210050','210051','210052','210053','210055','210056','210057','210058','210059','285681','296999','200868','11110','11000','258000','410000','210004','210060','210061','210088','210099','222226','202020','229001','40000','411000','288268','255503','288852','210063','210065','200200','288588','288500','221218','100000','218001','218002','218003','218005','288833','467777','218006','211532','288830','288831','210722','213127','288859','299899','228052','233752','268832','268831','288885','222522','219988','255586','223033','279901','288201','288202','233212','209669','288321','90361','221333','233911','210720','444222','216675','200126','222727','211021','211022','211023','211025','211026','211027','211028','211029','211020','211012','201113','288868','444404','201120','227575','219662','288816','444888','222076','268178','288688','270660','209001','209002','218812','217767','219979','223111','233121','221211','219555','270512','227852','16888','160001','160002','160003','205050','215050','10118','206800','206801','206802','206803','206805','206806','206807','206808','206809','206810','206811','200068','201001','200188','229565','206877','10068','252011','252012','252013','252015','252016','252006','252008','252088','252099','252035','252080','250060','288896','207662','207558','2520880','250898','250278','252077','255769','256555','11520','10033','203001','203002','203301','203302','203303','203305','203306','203307','203308','203309','203310','203311','203312','203313','203315','203316','203317','203318','203319','203320','203321','203322','203323','203325','203326','203327','203328','203329','203330','20666','200111','200099','203015','203016','226677','230231','233233','233332','223366','258880','203005','200057','223377','225577','225566','225533','255185','227711','221155','208886','271711','258585','201111','221182','221132','221183','222752','228888','221127','221101','266622','218772','221181','221102','221187','221156','221100','221199','221998','223233','221153','221197','221177','221198','411999','6755','400005','230353','233767','285233','260008','275233','275166','233756','200927','288678','221551','221176','219111','227522','223224','288258','288190','288259','228868','218989','223255','234567','200508','233882','232553','290009','221157','288257','221172','268508','258808','258815','258855','258852','258856','258857','258853','258858','258860','258889','258861','258862','258828','258863','258865','275515','258878','288898','288879','215668','257515','233833','268801','233761','203366','233769','280009','221228','227272','223155','215220','212280','255955','200005','220733','233821','200821','220333','200033','288895','222269','26969','222828','223122','288893','28808','288580','211578','268802','211522','221665','221322','288265','277157','268803','250550','255870','288892','268805','2228122','223226','20002','200002','221121','288891','200777','288093','200666','277568','252002','252003','252005','252007','252010','202005','202007','202010','202011','202012','202013','202015','202016','202017','202018','202019','202006','200018','200019','257577','228552','288890','266886','226682','400004','400044') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.011887s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000727s ]
[ 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.000556s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000585s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.687609s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.590861s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000656s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000529s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000492s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000517s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000510s ]
[ 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-04-16 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-04-16 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-04-13' AND `p`.`create_time` <= '2026-04-19 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000537s ]