資料庫語法 |
---|
0.000045 - SET SQL_BIG_SELECTS = 1 |
0.000733 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000215 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '0ftoetfspt2dqhqesv463iloje' |
0.000195 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000439 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000285 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000176 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000183 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000117 - select mid from modules where dirname='tadnews' |
0.000266 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000261 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.000796 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001049 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,5) AND b.bid IN (152,150,148,147,146,145,135,134,133,132,122,121,120,125,118,117,116,115,114,113,112,111,96,92,91,105,104,103,102,101,88,87,86,85,84,83,82,110,80,79,69,68,67,66,65,62,61,60,127,109,108,107,106,100,59,57,55,54,53,52,51,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,124,19,18,17,16,15,14,13,11,10,9,8,7,6,5,4,3,2,1,119,74,72,22,136,95,94,93,89,77,76,75,73,71,70,21) ORDER BY b.weight, m.block_id |
0.000406 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_login.tpl') ORDER BY tpl_refid |
0.000327 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadtools_app_block.tpl') ORDER BY tpl_refid |
0.000243 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_dummy.tpl') ORDER BY tpl_refid |
0.271100 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 15:58:56' and always_top_date!='0000-00-00 00:00:00' |
0.000383 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.603570 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 15:58:54' and (end_day > '2025-09-30 15:58:54' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.433182 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 15:58:54' and (end_day > '2025-09-30 15:58:54' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 9220, 20 |
0.000485 - desc `tadnews_data_center` `sort` |
0.001537 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='196' order by `sort` , `data_sort` |
0.006475 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='196' order by sort |
0.008815 - select * from tad_news where nsn='196' |
0.000343 - SELECT * FROM users WHERE uid = '16' |
0.000285 - select groupid,name from groups |
0.005756 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='196' order by sort |
0.016837 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='196' order by sort |
0.003795 - SELECT * FROM smiles |
0.001561 - desc `tadnews_data_center` `sort` |
0.001721 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='195' order by `sort` , `data_sort` |
0.005135 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='195' order by sort |
0.007509 - select * from tad_news where nsn='195' |
0.000438 - SELECT * FROM users WHERE uid = '16' |
0.000822 - select groupid,name from groups |
0.016730 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='195' order by sort |
0.005025 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='195' order by sort |
0.000624 - desc `tadnews_data_center` `sort` |
0.000189 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='194' order by `sort` , `data_sort` |
0.004949 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='194' order by sort |
0.000139 - select * from tad_news where nsn='194' |
0.000112 - SELECT * FROM users WHERE uid = '24' |
0.000096 - select groupid,name from groups |
0.004143 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='194' order by sort |
0.005562 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='194' order by sort |
0.000657 - desc `tadnews_data_center` `sort` |
0.000320 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='192' order by `sort` , `data_sort` |
0.004593 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='192' order by sort |
0.000441 - SELECT * FROM users WHERE uid = '15' |
0.000123 - select * from tad_news where nsn='192' |
0.000095 - SELECT * FROM users WHERE uid = '15' |
0.000078 - select groupid,name from groups |
0.005041 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='192' order by sort |
0.005195 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='192' order by sort |
0.000576 - desc `tadnews_data_center` `sort` |
0.000185 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='188' order by `sort` , `data_sort` |
0.004869 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='188' order by sort |
0.000143 - select * from tad_news where nsn='188' |
0.000114 - SELECT * FROM users WHERE uid = '11' |
0.000093 - select groupid,name from groups |
0.004678 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='188' order by sort |
0.005246 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='188' order by sort |
0.000357 - desc `tadnews_data_center` `sort` |
0.000173 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='186' order by `sort` , `data_sort` |
0.004535 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='186' order by sort |
0.000186 - select * from tad_news where nsn='186' |
0.000111 - SELECT * FROM users WHERE uid = '20' |
0.000307 - select groupid,name from groups |
0.005427 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='186' order by sort |
0.005064 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='186' order by sort |
0.001032 - desc `tadnews_data_center` `sort` |
0.000481 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='184' order by `sort` , `data_sort` |
0.004440 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='184' order by sort |
0.000162 - select * from tad_news where nsn='184' |
0.000110 - SELECT * FROM users WHERE uid = '15' |
0.000119 - select groupid,name from groups |
0.003687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='184' order by sort |
0.004371 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='184' order by sort |
0.000373 - desc `tadnews_data_center` `sort` |
0.000182 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='183' order by `sort` , `data_sort` |
0.004071 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='183' order by sort |
0.000144 - select * from tad_news where nsn='183' |
0.000106 - SELECT * FROM users WHERE uid = '15' |
0.000128 - select groupid,name from groups |
0.004453 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='183' order by sort |
0.004229 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='183' order by sort |
0.000156 - select font_color,color,tag from tad_news_tags where `tag_sn`='1' and enable='1' |
0.000558 - desc `tadnews_data_center` `sort` |
0.000176 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='182' order by `sort` , `data_sort` |
0.005982 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='182' order by sort |
0.000400 - SELECT * FROM users WHERE uid = '18' |
0.000352 - select * from tad_news where nsn='182' |
0.000198 - SELECT * FROM users WHERE uid = '18' |
0.000120 - select groupid,name from groups |
0.005912 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='182' order by sort |
0.005468 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='182' order by sort |
0.001244 - desc `tadnews_data_center` `sort` |
0.000587 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='180' order by `sort` , `data_sort` |
0.005441 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='180' order by sort |
0.000125 - SELECT * FROM users WHERE uid = '15' |
0.000114 - SELECT * FROM users WHERE uid = '15' |
0.000099 - select * from tad_news where nsn='180' |
0.000085 - SELECT * FROM users WHERE uid = '15' |
0.000197 - select groupid,name from groups |
0.003647 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='180' order by sort |
0.013296 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='180' order by sort |
0.000470 - desc `tadnews_data_center` `sort` |
0.004146 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='179' order by `sort` , `data_sort` |
0.004781 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='179' order by sort |
0.008584 - SELECT * FROM users WHERE uid = '21' |
0.000162 - select * from tad_news where nsn='179' |
0.000285 - SELECT * FROM users WHERE uid = '21' |
0.000083 - select groupid,name from groups |
0.005690 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='179' order by sort |
0.005060 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='179' order by sort |
0.000888 - desc `tadnews_data_center` `sort` |
0.000204 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='178' order by `sort` , `data_sort` |
0.006547 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='178' order by sort |
0.000187 - select * from tad_news where nsn='178' |
0.000480 - SELECT * FROM users WHERE uid = '24' |
0.000292 - select groupid,name from groups |
0.004691 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='178' order by sort |
0.014829 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='178' order by sort |
0.000605 - desc `tadnews_data_center` `sort` |
0.000272 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='177' order by `sort` , `data_sort` |
0.004187 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='177' order by sort |
0.008808 - SELECT * FROM users WHERE uid = '26' |
0.000103 - SELECT * FROM users WHERE uid = '26' |
0.000078 - SELECT * FROM users WHERE uid = '26' |
0.000102 - select * from tad_news where nsn='177' |
0.000229 - SELECT * FROM users WHERE uid = '26' |
0.000070 - select groupid,name from groups |
0.004105 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='177' order by sort |
0.006858 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='177' order by sort |
0.007285 - desc `tadnews_data_center` `sort` |
0.000153 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='176' order by `sort` , `data_sort` |
0.004680 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='176' order by sort |
0.005765 - select * from tad_news where nsn='176' |
0.000101 - SELECT * FROM users WHERE uid = '15' |
0.000079 - select groupid,name from groups |
0.004225 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='176' order by sort |
0.009117 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='176' order by sort |
0.006536 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000248 - desc `tadnews_data_center` `sort` |
0.000157 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='175' order by `sort` , `data_sort` |
0.004809 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='175' order by sort |
0.005785 - SELECT * FROM users WHERE uid = '24' |
0.000130 - select * from tad_news where nsn='175' |
0.000089 - SELECT * FROM users WHERE uid = '24' |
0.000076 - select groupid,name from groups |
0.004170 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='175' order by sort |
0.010441 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='175' order by sort |
0.002710 - desc `tadnews_data_center` `sort` |
0.005029 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='174' order by `sort` , `data_sort` |
0.004502 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='174' order by sort |
0.000569 - SELECT * FROM users WHERE uid = '20' |
0.000199 - select * from tad_news where nsn='174' |
0.000189 - SELECT * FROM users WHERE uid = '20' |
0.003643 - select groupid,name from groups |
0.004360 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='174' order by sort |
0.009358 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='174' order by sort |
0.003675 - desc `tadnews_data_center` `sort` |
0.000543 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='173' order by `sort` , `data_sort` |
0.004689 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='173' order by sort |
0.004428 - select * from tad_news where nsn='173' |
0.000114 - SELECT * FROM users WHERE uid = '26' |
0.000286 - select groupid,name from groups |
0.012330 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='173' order by sort |
0.005178 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='173' order by sort |
0.000597 - desc `tadnews_data_center` `sort` |
0.000237 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='171' order by `sort` , `data_sort` |
0.005270 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='171' order by sort |
0.000895 - select * from tad_news where nsn='171' |
0.000104 - SELECT * FROM users WHERE uid = '26' |
0.000117 - select groupid,name from groups |
0.006170 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='171' order by sort |
0.006340 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='171' order by sort |
0.000423 - desc `tadnews_data_center` `sort` |
0.000204 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='172' order by `sort` , `data_sort` |
0.006542 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='172' order by sort |
0.000383 - SELECT * FROM users WHERE uid = '16' |
0.000218 - select * from tad_news where nsn='172' |
0.000123 - SELECT * FROM users WHERE uid = '16' |
0.000256 - select groupid,name from groups |
0.006415 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='172' order by sort |
0.007195 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='172' order by sort |
0.000148 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000716 - desc `tadnews_data_center` `sort` |
0.000321 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='170' order by `sort` , `data_sort` |
0.006196 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='170' order by sort |
0.000819 - SELECT * FROM users WHERE uid = '6' |
0.000175 - select * from tad_news where nsn='170' |
0.000239 - SELECT * FROM users WHERE uid = '6' |
0.000473 - select groupid,name from groups |
0.005350 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='170' order by sort |
0.006538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='170' order by sort |
0.000165 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000464 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadnews_index.tpl') ORDER BY tpl_refid |