[ DB ] CONNECT:[ UseTime:0.000269s ] mysql:host=127.0.0.1;dbname=sky_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_room_artist` [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `tb_room_artist` [ RunTime:0.000270s ]
[ SQL ] SHOW COLUMNS FROM `tb_z_log_prop` [ RunTime:0.000302s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_income) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND `p`.`users_id` IN (16666,10000,500004,516666,516600,516601,526666,516602,516603,516605,516606,516607,516608,516609,516610,917,9888,18888,516611,516612,518887,518885,518883,518882,518881,518880,518888,516670,511122,516669,516668,516671,516672,516678,516677,516675,516673,518889,500006,500019,500020,688,518890,518800,516680,518801,516676,516683,516685,444448,516686,516687,1356,666,518999,1260,8300,516688,118,516620,516628,516630,500088,500030,518868,518869,518870,518871,500110,518872,518873,516661,400001,500060,500033,500035,500012,580001,580002,580003,580004,580005,580006,580007,580008,580009,580010,500008,40008,400008,580011,580012,580013,580014,580015,500003,580016,580017,500005,580020,516679,500007,500028,500009,500029,580030,580031,580032,580033,500068,500098,500444,500600,20100,52010,500212,500213,516650,580050,500026,500066,500051,500015,222277,500111,500222,500333,500099,501111,500123,500500,500076,400006,518860,518861,505555,525525,580808,518877,518833,517002,517004,517005,517006,517007,517008,517009,500126,517021,500555,517801,517880,5170011,500166,433333,517883,517884,517885,517886,517887,500077,521212,521313,516626,500050,517808,508010,516690,516697,500188,500888,500065,516621,516622,518836,518837,500086,500666,566121,500101,400005,517888,500336,500337,500338,516623,500198,500777,500069,518850,518855,500321,500129,518879,518866,518822,518820,518821,518823,518824,518825,518826,518827,518828,528899,410000,508800,510880,508810,508801,508802,508803,508804,508805,508806,508807,508808,508809,508811,508812,508813,508814,508815,508816,508817,508818,518830,10001,510001,510002,510003,510004,510005,510006,510007,510008,510010,510011,510012,510013,510014,510015,510016,510017,510018,510019,510020,508821,508822,508823,508824,508825,508826,508827,508828,508829,508830,500678,555277,527701,527702,527703,527704,527705,527706,527707,527708,527709,527710,527711,527712,527713,527714,527715,527716,527717,527718,527719,527720,527721,527722,527723,527724,527725,527726,527727,527728,527729,527731,527732,527733,527734,527735,527736,527737,527738,527739,527740,578899,518518,516639,518878,510021,510022,510023,510024,510025,510026,510027,510028,510029,510030,510031,510032,510033,510034,510035,510036,510037,510038,510039,510040,510046,588156,10009,599999,590001,590002,590003,590004,590005,590006,590007,590008,590009,590010,590011,590012,590013,590014,590015,590016,590017,590018,590019,590020,590021,590022,590023,590024,590025,590026,590027,590028,590029,590030,590031,590032,590033,590034,590035,590036,590037,590038,590039,590040,490001,411111,518892,595555,590050,221100,590051,590052,2010,200056,200010,20010,590053,590055,590056,490002,500010,590057,590077,590000,590060,590058,590059,590062,590099,510051,412705,412706,412707,412708,410001,520518,222222,590069,418888,510116,590073,500001,590999,590065,490006,590070,590071,516635,400000,555555,590082,590072,510065,590080,590081,590083,590084,590085,510066,510067,510068,510069,510070,510071,510516,511111,400004,599900,490000,200088,288288,400012,10277,444444,490005,590090,527769,599901,599902,599903,599904,599905,599906,599907,599908,599909,599910,599911,599912,599913,599914,599915,599916,599917,599918,599919,599920,599921,599922,599923,599924,599925,599926,599927,599928,599929,599930,599931,599932,599933,599934,599935,599936,599937,599938,599939,599940,599951,599952,599953,599954,599955,599956,599957,599958,599959,599960,588888,512000,512001,512002,512003,512004,512005,512006,512007,512008,512009,577777,512010,512011,512012,512013,512014,512015,512016,512017,512018,512019,590256,512020,512021,512022,512023,512024,512025,512026,512027,512028,512029,533333,506666,512345,559999,550000,552222,455555,551111,499000,500700,590098,599521,590166,527777,555666,587878,519601,519602,519603,519604,519605,519606,519607,519608,519609,519610,519611,519612,519613,519614,519615,519616,519617,519618,519619,519620,599666,440666,590078,599950,599961,599962,599963,599964,599965,599966,599967,599968,599969,499999,509901,509902,509903,590079,509905,509906,509907,509908,509909,509910,509911,509912,509913,509914,509915,509916,509917,509918,509919,509920,509921,509922,509923,509924,409999,590066,590068,590086,501007,519007,502007,596007,503007,569007,596555,599555,569555,519555,598555,556666,590061,588080,588081,588082,588083,519621,588067,588087,519622,555777,555888,555999,587555,577700,577701,577702,577703,577704,577705,577706,577707,577708,577709,577710,577711,577712,577713,577714,577715,577716,577717,577718,577719,588056,418800,522227,419999,510062,555333,555566,466666,412345,422222,477777,596098,513555,555550,555551,555552,555553,566666,502222,503333,507777,520520,561111,562222,567777,569999,520021,519999,504444,554444,564444,412000,544444,500000,478478,596655,518126,596060,511105,490007,590900,596666,577769,590101,590102,502020,555111,555222,555511,555522,555533,555520,577780,577730,410200,590087,440000,590111,590222,590333,590555,590666,516698,599981,599982,599000,599983,516658,580101,599990,599991,591100,599992,599993,599994,599995,599996,599997,515555,510000,400020,590100,501010,501011,501012,501013,501014,501015,501016,501017,501018,501019,516682,501020,501021,501022,501023,501024,501025,501026,501027,501028,501029,500516,400003,590689,500802,508000,500900,590870,570000,410270,508888,500090,599599,500882,590189,522222,527700,460016,19999,520123,520125,520126,527768,521983,522625,579999,590200,555556,527786,590201,400088,598888,590107,590106,508902,555557,518876,518862,502266,596635,516036,517787,522888,445555,516692,599011,599012,500002,480008,516681,590911,519987,519988,586655,582222,597777,593333,508088,519977,519998,519978,519979,590093,590301,590302,590303,590304,590305,590306,590307,590308,590309,590310,500100,416608,590095,526900,516693,500070,522223,508080,210009,530009,510009,590096,590097,590089,590091,299997,290009,590300,590879,527797,516691,416622,590116,566165,5166601,514514,590128,590129,5166602,519991,500078,500089,427703,500801,519666,519600,408888,590800,516056,519630,519000,555558,517777,527791,527792,527793,527794,527795,596686,596689,590806,599988,490008,519633,519635,519333,520756,516651,559966,559922,558888,553333,590700,520000,516098,516090,555585,510688,516011,512300,188688,510271,566656,566111,459999,550888,596687,596688,596677,596699,596622,599888,566066,500960,516513,590202,599001,590203,200000,416777,596006,596000,596001,596002,596009,596003,596010,480000,17888,596005,501668,590105,590103,590108,590109,596008,501663,590119,510088,578801,578803,578805,578806,578807,578808,578809,578810,578811,578812,578813,518856,516916,516862,596011,596012,501665,590213,519638,516629,578802,560001,560002,560003,560004,560005,560006,560007,560008,560009,560010,560011,560012,560013,560014,560015,560016,560017,560018,560019,560020,560021,560022,560023,560024,560025,560026,560027,560028,560029,560030,560031,560032,560033,560034,560035,560036,560037,560038,560039,560050,560051,560052,560053,560054,560055,560056,560057,560058,560059,555559,509999,20000,25000,22000,20821,516696,517881,510277,510955,520821,210000,500258,227777,404404,500013,429999,439999,510833,501998,501333,501777,519678,520777,510888,560078,598001,598002,598003,598004,598005,598006,598007,598008,598009,598010,598011,598012,598013,598014,598015,598016,598017,598018,598019,598020,519989,519986,599091,222777,599073,599075,599333,500087,560111,599088,560112,599055,598598,500082,290000) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 15 [ RunTime:0.083164s ]
[ SQL ] SELECT p.prop_id, p.user_id, sum(p.prop_num * p.prop_price) as oo, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` < 39 ) AND `p`.`user_id` NOT IN (16666,10000,500004,516666,516600,516601,526666,516602,516603,516605,516606,516607,516608,516609,516610,917,9888,18888,516611,516612,518887,518885,518883,518882,518881,518880,518888,516670,511122,516669,516668,516671,516672,516678,516677,516675,516673,518889,500006,500019,500020,688,518890,518800,516680,518801,516676,516683,516685,444448,516686,516687,1356,666,518999,1260,8300,516688,118,516620,516628,516630,500088,500030,518868,518869,518870,518871,500110,518872,518873,516661,400001,500060,500033,500035,500012,580001,580002,580003,580004,580005,580006,580007,580008,580009,580010,500008,40008,400008,580011,580012,580013,580014,580015,500003,580016,580017,500005,580020,516679,500007,500028,500009,500029,580030,580031,580032,580033,500068,500098,500444,500600,20100,52010,500212,500213,516650,580050,500026,500066,500051,500015,222277,500111,500222,500333,500099,501111,500123,500500,500076,400006,518860,518861,505555,525525,580808,518877,518833,517002,517004,517005,517006,517007,517008,517009,500126,517021,500555,517801,517880,5170011,500166,433333,517883,517884,517885,517886,517887,500077,521212,521313,516626,500050,517808,508010,516690,516697,500188,500888,500065,516621,516622,518836,518837,500086,500666,566121,500101,400005,517888,500336,500337,500338,516623,500198,500777,500069,518850,518855,500321,500129,518879,518866,518822,518820,518821,518823,518824,518825,518826,518827,518828,528899,410000,508800,510880,508810,508801,508802,508803,508804,508805,508806,508807,508808,508809,508811,508812,508813,508814,508815,508816,508817,508818,518830,10001,510001,510002,510003,510004,510005,510006,510007,510008,510010,510011,510012,510013,510014,510015,510016,510017,510018,510019,510020,508821,508822,508823,508824,508825,508826,508827,508828,508829,508830,500678,555277,527701,527702,527703,527704,527705,527706,527707,527708,527709,527710,527711,527712,527713,527714,527715,527716,527717,527718,527719,527720,527721,527722,527723,527724,527725,527726,527727,527728,527729,527731,527732,527733,527734,527735,527736,527737,527738,527739,527740,578899,518518,516639,518878,510021,510022,510023,510024,510025,510026,510027,510028,510029,510030,510031,510032,510033,510034,510035,510036,510037,510038,510039,510040,510046,588156,10009,599999,590001,590002,590003,590004,590005,590006,590007,590008,590009,590010,590011,590012,590013,590014,590015,590016,590017,590018,590019,590020,590021,590022,590023,590024,590025,590026,590027,590028,590029,590030,590031,590032,590033,590034,590035,590036,590037,590038,590039,590040,490001,411111,518892,595555,590050,221100,590051,590052,2010,200056,200010,20010,590053,590055,590056,490002,500010,590057,590077,590000,590060,590058,590059,590062,590099,510051,412705,412706,412707,412708,410001,520518,222222,590069,418888,510116,590073,500001,590999,590065,490006,590070,590071,516635,400000,555555,590082,590072,510065,590080,590081,590083,590084,590085,510066,510067,510068,510069,510070,510071,510516,511111,400004,599900,490000,200088,288288,400012,10277,444444,490005,590090,527769,599901,599902,599903,599904,599905,599906,599907,599908,599909,599910,599911,599912,599913,599914,599915,599916,599917,599918,599919,599920,599921,599922,599923,599924,599925,599926,599927,599928,599929,599930,599931,599932,599933,599934,599935,599936,599937,599938,599939,599940,599951,599952,599953,599954,599955,599956,599957,599958,599959,599960,588888,512000,512001,512002,512003,512004,512005,512006,512007,512008,512009,577777,512010,512011,512012,512013,512014,512015,512016,512017,512018,512019,590256,512020,512021,512022,512023,512024,512025,512026,512027,512028,512029,533333,506666,512345,559999,550000,552222,455555,551111,499000,500700,590098,599521,590166,527777,555666,587878,519601,519602,519603,519604,519605,519606,519607,519608,519609,519610,519611,519612,519613,519614,519615,519616,519617,519618,519619,519620,599666,440666,590078,599950,599961,599962,599963,599964,599965,599966,599967,599968,599969,499999,509901,509902,509903,590079,509905,509906,509907,509908,509909,509910,509911,509912,509913,509914,509915,509916,509917,509918,509919,509920,509921,509922,509923,509924,409999,590066,590068,590086,501007,519007,502007,596007,503007,569007,596555,599555,569555,519555,598555,556666,590061,588080,588081,588082,588083,519621,588067,588087,519622,555777,555888,555999,587555,577700,577701,577702,577703,577704,577705,577706,577707,577708,577709,577710,577711,577712,577713,577714,577715,577716,577717,577718,577719,588056,418800,522227,419999,510062,555333,555566,466666,412345,422222,477777,596098,513555,555550,555551,555552,555553,566666,502222,503333,507777,520520,561111,562222,567777,569999,520021,519999,504444,554444,564444,412000,544444,500000,478478,596655,518126,596060,511105,490007,590900,596666,577769,590101,590102,502020,555111,555222,555511,555522,555533,555520,577780,577730,410200,590087,440000,590111,590222,590333,590555,590666,516698,599981,599982,599000,599983,516658,580101,599990,599991,591100,599992,599993,599994,599995,599996,599997,515555,510000,400020,590100,501010,501011,501012,501013,501014,501015,501016,501017,501018,501019,516682,501020,501021,501022,501023,501024,501025,501026,501027,501028,501029,500516,400003,590689,500802,508000,500900,590870,570000,410270,508888,500090,599599,500882,590189,522222,527700,460016,19999,520123,520125,520126,527768,521983,522625,579999,590200,555556,527786,590201,400088,598888,590107,590106,508902,555557,518876,518862,502266,596635,516036,517787,522888,445555,516692,599011,599012,500002,480008,516681,590911,519987,519988,586655,582222,597777,593333,508088,519977,519998,519978,519979,590093,590301,590302,590303,590304,590305,590306,590307,590308,590309,590310,500100,416608,590095,526900,516693,500070,522223,508080,210009,530009,510009,590096,590097,590089,590091,299997,290009,590300,590879,527797,516691,416622,590116,566165,5166601,514514,590128,590129,5166602,519991,500078,500089,427703,500801,519666,519600,408888,590800,516056,519630,519000,555558,517777,527791,527792,527793,527794,527795,596686,596689,590806,599988,490008,519633,519635,519333,520756,516651,559966,559922,558888,553333,590700,520000,516098,516090,555585,510688,516011,512300,188688,510271,566656,566111,459999,550888,596687,596688,596677,596699,596622,599888,566066,500960,516513,590202,599001,590203,200000,416777,596006,596000,596001,596002,596009,596003,596010,480000,17888,596005,501668,590105,590103,590108,590109,596008,501663,590119,510088,578801,578803,578805,578806,578807,578808,578809,578810,578811,578812,578813,518856,516916,516862,596011,596012,501665,590213,519638,516629,578802,560001,560002,560003,560004,560005,560006,560007,560008,560009,560010,560011,560012,560013,560014,560015,560016,560017,560018,560019,560020,560021,560022,560023,560024,560025,560026,560027,560028,560029,560030,560031,560032,560033,560034,560035,560036,560037,560038,560039,560050,560051,560052,560053,560054,560055,560056,560057,560058,560059,555559,509999,20000,25000,22000,20821,516696,517881,510277,510955,520821,210000,500258,227777,404404,500013,429999,439999,510833,501998,501333,501777,519678,520777,510888,560078,598001,598002,598003,598004,598005,598006,598007,598008,598009,598010,598011,598012,598013,598014,598015,598016,598017,598018,598019,598020,519989,519986,599091,222777,599073,599075,599333,500087,560111,599088,560112,599055,598598,500082,290000) GROUP BY `p`.`user_id` ORDER BY `oo` DESC LIMIT 15 [ RunTime:0.067358s ]
[ SQL ] SHOW COLUMNS FROM `tb_prop_siege` [ RunTime:0.000445s ]
[ 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.000245s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.027814s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.027222s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.033518s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.033520s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.040010s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 507 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.039876s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.users_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`users_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`users_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`users_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.046394s ]
[ SQL ] SELECT p.prop_id, sum(p.prop_num) as income, p.user_id, l.user_level,c.name,i.user_name, i.user_head_url FROM `tb_z_log_prop` `p` INNER JOIN `tb_user_level` `l` ON `p`.`user_id`=`l`.`user_id` INNER JOIN `tb_level_user_conf` `c` ON `l`.`user_level`=`c`.`idx` INNER JOIN `tb_user_info` `i` ON `p`.`user_id`=`i`.`user_id` WHERE ( `p`.`create_time` >= '2025-04-28 00:00:00.001 00:00:00' AND `p`.`create_time` <= '2025-04-28 23:59:59.999 23:59:59' AND `l`.`user_level` >= 39 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 148 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 610 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 507 ) AND ( `p`.`create_time` >= '2025-04-28' AND `p`.`create_time` <= '2025-05-04 23:59:59' AND `p`.`prop_id` = 149 ) GROUP BY `p`.`user_id` ORDER BY `income` DESC LIMIT 3 [ RunTime:0.046318s ]
微信
QQ
