[ DB ] CONNECT:[ UseTime:0.000294s ] mysql:host=127.0.0.1;dbname=ray_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.004130s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.000992s ]
[ SQL ] SHOW COLUMNS FROM `tb_user_tops` [ RunTime:0.000413s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`user_id` IN ('10001','10003','10005','10006','10007','10008','10009','11111','12222','13333','15555','16666','17777','18888','19999','15888','10011','10022','10033','10055','10066','10077','10088','10099','10111','10222','10333','10520','10521','10555','10666','10777','10888','10999','11115','11119','288888','200099','200199','200299','200399','200599','200699','200899','201099','201199','201299','201399','20599','201599','201699','201899','201999','202099','202199','202299','202399','202599','202699','202899','202999','215500','215501','215502','215503','215505','215506','215507','215508','215509','215588','222821','222822','222823','220520','221520','222520','201520','223520','202520','225520','203520','226520','204520','227520','205520','228520','206520','207520','229520','208520','209520','212520','211520','233520','244520','255520','266520','277520','288520','299520','210520','218520','230520','231520','232520','266666','200520','200123','210123','220123','230123','250123','260123','270123','280123','290123','211123','12345','222123','200345','233123','220035','255123','266123','220135','220235','220335','220535','277123','288123','212123','213123','215123','222333','222111','222555','222666','222777','222888','222999','222000','222200','222211','222233','222255','222277','222288','222299','299999','221122','200000','200002','200003','200005','200007','200006','200009','200010','200012','200015','200016','200018','200019','200020','200021','200022','200025','200026','200029','200030','200033','200111','200115','200116','200118','200119','200200','200222','200228','200088','200055','200066','200155','200255','277777','200188','200288','200388','200588','200303','200688','200788','200888','200988','201088','201188','201288','201588','201688','201788','201888','201988','202088','202188','202288','202588','200505','289999','203599','203699','206799','203799','203899','203888','206666','216666','226666','236666','256666','276666','286666','296666','261666','262666','263666','265666','267666','268666','269666','201515','211211','210555','220555','230555','260555','270555','280555','290555','200555','250555','201555','202555','212121','203555','206555','207555','208555','203999','17888','200919','211011','217888','227888','237888','257888','239888','277888','256888','267888','255888','287888','266888','215099','216099','218099','219099','213099','228099','220099','221099','222099','223099','225099','226099','227099','229099','230099','231099','232099','233099','218888','219888','220888','221888','235099','236099','237099','239099','251099','230088','270099','208888','228888','210088','220088','250088','260088','270088','290088','221088','222088','223088','225088','226088','227088','229088','222188','222388','222588','218218','292929','275888','227066','226066','225066','223066','228066','271099','261099','269999','220003','210003','230003','250003','260003','222922','210000','233333','200313','269000','266688','269099','255099','268099','209999','200323','236123','237123','239123','251123','288099','257099','203199','205199','206199','225555','203131','202155','203232','202255','201111','280099','211888','201919','219999','211999','253088','261555','221188','205888','212888','208988','225888','203203','200909','499999','208999','233888','236888','288999','418888','211088','223888','229888','230888','231888','232888','235888','259888','201212','201666','202666','203666','205666','203636','411111','208666','209666','202266','203366','205566','220666','221666','221133','222226','205099','220588','202066','220066','200333','201333','202333','222222','203333','205333','212555','206333','207333','258555','208333','209333','223333','213333','211333','212333','215333','216333','255555','218333','219333','229333','228333','227333','226333','225333','221333','230333','232333','282888','235333','202020','236333','237333','266333','277333','276888','10086','210086','220086','230086','250086','260086','270086','280086','290086','200086','222086','269888','225666','222166','222066','228666','444999','220333','252333','262333','211666','272288','270345','261123','251288','251588','229555','212399','259099','268888','239666','278888','258888','298888','239333','226688','272333','292333','260888','253333','231333','221166','217333','282333','201266','220899','298333','221288','221388','221588','221688','221788','221988','258099','282299','223388','225588','229988','223666','202888','979','444333','210333','212666','219666','299666','449999','215666','448888','297333','423333','439999','290333','283333','293333','428888','220299','227666','270333','216888','271333','275333','296888','258333','231666','232666','235666','251666','252666','253666','289666','200008','212166','200816','228866','2288','292666','252888','262888','252555','200817','202278','286333','255333','206206','233666','210888','251888','261888','200818','266088','266188','266288','266388','266588','266788','266988','267088','267188','267388','267288','267588','267688','267788','267988','260666','281666','215888','213888','211111','255666','212345','225568','250066','251066','251166','251266','251366','251566','251766','251866','251966','215566','252066','225566','235566','255566','265566','275566','285566','295566','252166','252266','252366','221299','212251','212777','209345','208345','216899','218666','246666','207777','222210','201010','16888','276333','200059','200069','200079','200089','211099','212099','203099','206099','207099','208099','209199','209299','209399','209599','209699','209799','209899','208199','208299','208399','208599','208699','208799','208899','216088','208601','219123','209099','279099','200999','210199','210999','200039','220009','222009','221009','222019','266661','220599','212299','210899','205299','200110','219299','212999','441888','222686','222966','219219','212199','1985','200129','200139','200159','259999','288885','266665','217777','233331','400001','299299','271299','271399','271199','229999','285333','290188','202988','290288','203988','290388','205988','290588','206988','290688','207988','290788','209988','290888','210988','290988','220988','230988','250988','260988','270988','280988','205899','211399','211599','211699','227299','211799','211899','221599','200696','200001','278099','222882','213188','215088','215188','200544','206699','207799','200077','200078','202345','203399','422888','205599','225999','221399','207888','226999','227999','223999','232999','6152','269199','269299','269399','269599','269699','269799','257999','298999','266999','267999','276999','279333','278333','212288','295333','296333','265333','221855','277099','277199','277299','3613','297888','229299','239299','279299','225299','262288','282288','262588','200828','221199','223399','251299','255799','225599','202123','223288','226788','272266','200068','444449','277988','277899','227799','255699','227899','233799','221699','225799','226199','223799','227266','225788','99000','251788','203388','217099','217199','200799','201799','202799','217299','205799','217399','217599','217699','212799','217899','213799','215799','216799','217999','237999','277999','207999','216999','260099','227777','209119','261333','251333','298099','290099','212599','200777','21066','210066','230066','200166','260066','200266','270066','200366','280066','200566','290066','200666','200766','211066','212066','272688','260333','281099','281299','281199','239555','200011','200900','200028','200100','220000','230000','291099','221886','222199','211199','200808','2199','202688','202788','210688','203688','263099','229229','271888','230688','231688','232688','233688','205123','200098','200198','200298','10998','200398','200598','200698','200798','200898','200998','299998','200786','292999','232988','272066','212988','232123','213988','261088','262088','263088','265088','281088','219088','218088','217088','228088','212088','268088','223299','17999','206299','10988','206899','279988','221266','222266','213088','231088','220688','223199','223599','297099','223699','297199','216688','220098','221098','221198','221298','210001','220001','230001','250001','260001','270001','280001','290001','211001','212001','213001','215001','216001','217001','218001','219001','221001','222001','223001','225001','226001','227001','228001','229001','231001','295555','208080','269088','239001','210098','210198','210298','210398','210598','210698','210798','210898','210998','211098','211198','211298','211398','211598','211698','211798','211898','211998','212098','212198','212298','212398','212598','212698','212798','212898','212998','213098','213198','213298','210011','210111','210211','210311','210511','210611','210711','210811','210911','212011','212111','212211','212311','212511','212611','212711','212811','212911','213011','213111','232001','466688','235066','235086','201011','219119','217799','219799','220799','221799','222799','226799','228799','229799','230799','231799','1221','220011','230011','250011','260011','270011','280011','290011','221011','222011','223011','225011','226011','227011','228011','229011','200101','200201','200301','200501','200601','200701','200801','200901','230111','230211','230311','230511','230611','230711','230811','2066','230911','231011','206611','266611','260188','219011','202211','232011','422333','201233','211233','212233','235011','426888','221233','213233','215233','219966','222101','236233','237233','267011','260233','261233','262233') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.024205s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` NOT IN ('10001','10003','10005','10006','10007','10008','10009','11111','12222','13333','15555','16666','17777','18888','19999','15888','10011','10022','10033','10055','10066','10077','10088','10099','10111','10222','10333','10520','10521','10555','10666','10777','10888','10999','11115','11119','288888','200099','200199','200299','200399','200599','200699','200899','201099','201199','201299','201399','20599','201599','201699','201899','201999','202099','202199','202299','202399','202599','202699','202899','202999','215500','215501','215502','215503','215505','215506','215507','215508','215509','215588','222821','222822','222823','220520','221520','222520','201520','223520','202520','225520','203520','226520','204520','227520','205520','228520','206520','207520','229520','208520','209520','212520','211520','233520','244520','255520','266520','277520','288520','299520','210520','218520','230520','231520','232520','266666','200520','200123','210123','220123','230123','250123','260123','270123','280123','290123','211123','12345','222123','200345','233123','220035','255123','266123','220135','220235','220335','220535','277123','288123','212123','213123','215123','222333','222111','222555','222666','222777','222888','222999','222000','222200','222211','222233','222255','222277','222288','222299','299999','221122','200000','200002','200003','200005','200007','200006','200009','200010','200012','200015','200016','200018','200019','200020','200021','200022','200025','200026','200029','200030','200033','200111','200115','200116','200118','200119','200200','200222','200228','200088','200055','200066','200155','200255','277777','200188','200288','200388','200588','200303','200688','200788','200888','200988','201088','201188','201288','201588','201688','201788','201888','201988','202088','202188','202288','202588','200505','289999','203599','203699','206799','203799','203899','203888','206666','216666','226666','236666','256666','276666','286666','296666','261666','262666','263666','265666','267666','268666','269666','201515','211211','210555','220555','230555','260555','270555','280555','290555','200555','250555','201555','202555','212121','203555','206555','207555','208555','203999','17888','200919','211011','217888','227888','237888','257888','239888','277888','256888','267888','255888','287888','266888','215099','216099','218099','219099','213099','228099','220099','221099','222099','223099','225099','226099','227099','229099','230099','231099','232099','233099','218888','219888','220888','221888','235099','236099','237099','239099','251099','230088','270099','208888','228888','210088','220088','250088','260088','270088','290088','221088','222088','223088','225088','226088','227088','229088','222188','222388','222588','218218','292929','275888','227066','226066','225066','223066','228066','271099','261099','269999','220003','210003','230003','250003','260003','222922','210000','233333','200313','269000','266688','269099','255099','268099','209999','200323','236123','237123','239123','251123','288099','257099','203199','205199','206199','225555','203131','202155','203232','202255','201111','280099','211888','201919','219999','211999','253088','261555','221188','205888','212888','208988','225888','203203','200909','499999','208999','233888','236888','288999','418888','211088','223888','229888','230888','231888','232888','235888','259888','201212','201666','202666','203666','205666','203636','411111','208666','209666','202266','203366','205566','220666','221666','221133','222226','205099','220588','202066','220066','200333','201333','202333','222222','203333','205333','212555','206333','207333','258555','208333','209333','223333','213333','211333','212333','215333','216333','255555','218333','219333','229333','228333','227333','226333','225333','221333','230333','232333','282888','235333','202020','236333','237333','266333','277333','276888','10086','210086','220086','230086','250086','260086','270086','280086','290086','200086','222086','269888','225666','222166','222066','228666','444999','220333','252333','262333','211666','272288','270345','261123','251288','251588','229555','212399','259099','268888','239666','278888','258888','298888','239333','226688','272333','292333','260888','253333','231333','221166','217333','282333','201266','220899','298333','221288','221388','221588','221688','221788','221988','258099','282299','223388','225588','229988','223666','202888','979','444333','210333','212666','219666','299666','449999','215666','448888','297333','423333','439999','290333','283333','293333','428888','220299','227666','270333','216888','271333','275333','296888','258333','231666','232666','235666','251666','252666','253666','289666','200008','212166','200816','228866','2288','292666','252888','262888','252555','200817','202278','286333','255333','206206','233666','210888','251888','261888','200818','266088','266188','266288','266388','266588','266788','266988','267088','267188','267388','267288','267588','267688','267788','267988','260666','281666','215888','213888','211111','255666','212345','225568','250066','251066','251166','251266','251366','251566','251766','251866','251966','215566','252066','225566','235566','255566','265566','275566','285566','295566','252166','252266','252366','221299','212251','212777','209345','208345','216899','218666','246666','207777','222210','201010','16888','276333','200059','200069','200079','200089','211099','212099','203099','206099','207099','208099','209199','209299','209399','209599','209699','209799','209899','208199','208299','208399','208599','208699','208799','208899','216088','208601','219123','209099','279099','200999','210199','210999','200039','220009','222009','221009','222019','266661','220599','212299','210899','205299','200110','219299','212999','441888','222686','222966','219219','212199','1985','200129','200139','200159','259999','288885','266665','217777','233331','400001','299299','271299','271399','271199','229999','285333','290188','202988','290288','203988','290388','205988','290588','206988','290688','207988','290788','209988','290888','210988','290988','220988','230988','250988','260988','270988','280988','205899','211399','211599','211699','227299','211799','211899','221599','200696','200001','278099','222882','213188','215088','215188','200544','206699','207799','200077','200078','202345','203399','422888','205599','225999','221399','207888','226999','227999','223999','232999','6152','269199','269299','269399','269599','269699','269799','257999','298999','266999','267999','276999','279333','278333','212288','295333','296333','265333','221855','277099','277199','277299','3613','297888','229299','239299','279299','225299','262288','282288','262588','200828','221199','223399','251299','255799','225599','202123','223288','226788','272266','200068','444449','277988','277899','227799','255699','227899','233799','221699','225799','226199','223799','227266','225788','99000','251788','203388','217099','217199','200799','201799','202799','217299','205799','217399','217599','217699','212799','217899','213799','215799','216799','217999','237999','277999','207999','216999','260099','227777','209119','261333','251333','298099','290099','212599','200777','21066','210066','230066','200166','260066','200266','270066','200366','280066','200566','290066','200666','200766','211066','212066','272688','260333','281099','281299','281199','239555','200011','200900','200028','200100','220000','230000','291099','221886','222199','211199','200808','2199','202688','202788','210688','203688','263099','229229','271888','230688','231688','232688','233688','205123','200098','200198','200298','10998','200398','200598','200698','200798','200898','200998','299998','200786','292999','232988','272066','212988','232123','213988','261088','262088','263088','265088','281088','219088','218088','217088','228088','212088','268088','223299','17999','206299','10988','206899','279988','221266','222266','213088','231088','220688','223199','223599','297099','223699','297199','216688','220098','221098','221198','221298','210001','220001','230001','250001','260001','270001','280001','290001','211001','212001','213001','215001','216001','217001','218001','219001','221001','222001','223001','225001','226001','227001','228001','229001','231001','295555','208080','269088','239001','210098','210198','210298','210398','210598','210698','210798','210898','210998','211098','211198','211298','211398','211598','211698','211798','211898','211998','212098','212198','212298','212398','212598','212698','212798','212898','212998','213098','213198','213298','210011','210111','210211','210311','210511','210611','210711','210811','210911','212011','212111','212211','212311','212511','212611','212711','212811','212911','213011','213111','232001','466688','235066','235086','201011','219119','217799','219799','220799','221799','222799','226799','228799','229799','230799','231799','1221','220011','230011','250011','260011','270011','280011','290011','221011','222011','223011','225011','226011','227011','228011','229011','200101','200201','200301','200501','200601','200701','200801','200901','230111','230211','230311','230511','230611','230711','230811','2066','230911','231011','206611','266611','260188','219011','202211','232011','422333','201233','211233','212233','235011','426888','221233','213233','215233','219966','222101','236233','237233','267011','260233','261233','262233') GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.005095s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000496s ]
[ 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.000350s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000419s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.001315s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000384s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000341s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000304s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000325s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000320s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000327s ]
[ 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-03-04 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2026-03-04 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2026-03-02' AND `p`.`create_time` <= '2026-03-08 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.000328s ]