資料庫語法 |
---|
0.000343 - SET SQL_BIG_SELECTS = 1 |
0.001389 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000295 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'o4q2q219qq1npgeo5slelcu7v8' |
0.000377 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000513 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.001435 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000439 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000213 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000206 - select mid from modules where dirname='tadnews' |
0.000346 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000277 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001841 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001965 - 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.000621 - 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.000335 - 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.000530 - 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.165130 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 23:00:06' and always_top_date!='0000-00-00 00:00:00' |
0.000929 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.630020 - select * from tad_news where 1 and enable='1' and prefix_tag = '8' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 23:00:04' and (end_day > '2025-09-30 23:00:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.216020 - select * from tad_news where 1 and enable='1' and prefix_tag = '8' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 23:00:04' and (end_day > '2025-09-30 23:00:04' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 1780, 20 |
0.015464 - desc `tadnews_data_center` `sort` |
0.001513 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2262' order by `sort` , `data_sort` |
0.027539 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2262' order by sort |
0.014499 - SELECT * FROM users WHERE uid = '21' |
0.259331 - select * from tad_news where nsn='2262' |
0.000546 - SELECT * FROM users WHERE uid = '21' |
0.000764 - select groupid,name from groups |
0.006604 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2262' order by sort |
0.018037 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2262' order by sort |
0.010289 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000117 - SELECT * FROM smiles |
0.000367 - desc `tadnews_data_center` `sort` |
0.000314 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2220' order by `sort` , `data_sort` |
0.007349 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2220' order by sort |
0.009373 - SELECT * FROM users WHERE uid = '11' |
0.000579 - select * from tad_news where nsn='2220' |
0.000093 - SELECT * FROM users WHERE uid = '11' |
0.000089 - select groupid,name from groups |
0.004757 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2220' order by sort |
0.012636 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2220' order by sort |
0.005788 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001944 - desc `tadnews_data_center` `sort` |
0.000872 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2212' order by `sort` , `data_sort` |
0.013195 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2212' order by sort |
0.006356 - select * from tad_news where nsn='2212' |
0.000228 - SELECT * FROM users WHERE uid = '21' |
0.000391 - select groupid,name from groups |
0.005529 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2212' order by sort |
0.011997 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2212' order by sort |
0.009041 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001166 - desc `tadnews_data_center` `sort` |
0.000368 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2200' order by `sort` , `data_sort` |
0.006797 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2200' order by sort |
0.001533 - SELECT * FROM users WHERE uid = '11' |
0.006961 - select * from tad_news where nsn='2200' |
0.000433 - SELECT * FROM users WHERE uid = '11' |
0.000515 - select groupid,name from groups |
0.008476 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2200' order by sort |
0.009173 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2200' order by sort |
0.009384 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002660 - desc `tadnews_data_center` `sort` |
0.000668 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2180' order by `sort` , `data_sort` |
0.012177 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2180' order by sort |
0.000384 - SELECT * FROM users WHERE uid = '11' |
0.000159 - select * from tad_news where nsn='2180' |
0.000198 - SELECT * FROM users WHERE uid = '11' |
0.000323 - select groupid,name from groups |
0.007921 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2180' order by sort |
0.041751 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2180' order by sort |
0.000415 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000537 - desc `tadnews_data_center` `sort` |
0.000455 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2162' order by `sort` , `data_sort` |
0.018230 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2162' order by sort |
0.000558 - select * from tad_news where nsn='2162' |
0.006302 - SELECT * FROM users WHERE uid = '11' |
0.000249 - select groupid,name from groups |
0.005837 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2162' order by sort |
0.018953 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2162' order by sort |
0.009002 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000371 - desc `tadnews_data_center` `sort` |
0.000221 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2137' order by `sort` , `data_sort` |
0.017755 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2137' order by sort |
0.000143 - SELECT * FROM users WHERE uid = '11' |
0.000127 - select * from tad_news where nsn='2137' |
0.000115 - SELECT * FROM users WHERE uid = '11' |
0.000136 - select groupid,name from groups |
0.004342 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2137' order by sort |
0.009965 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2137' order by sort |
0.008785 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000282 - desc `tadnews_data_center` `sort` |
0.000843 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2135' order by `sort` , `data_sort` |
0.015042 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2135' order by sort |
0.003405 - select * from tad_news where nsn='2135' |
0.000601 - SELECT * FROM users WHERE uid = '11' |
0.000555 - select groupid,name from groups |
0.008584 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2135' order by sort |
0.023799 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2135' order by sort |
0.002251 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001931 - desc `tadnews_data_center` `sort` |
0.001694 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2076' order by `sort` , `data_sort` |
0.015565 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2076' order by sort |
0.002338 - select * from tad_news where nsn='2076' |
0.002113 - SELECT * FROM users WHERE uid = '11' |
0.000550 - select groupid,name from groups |
0.006783 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2076' order by sort |
0.019279 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2076' order by sort |
0.012620 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002466 - desc `tadnews_data_center` `sort` |
0.001867 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='2061' order by `sort` , `data_sort` |
0.007473 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='2061' order by sort |
0.013497 - SELECT * FROM users WHERE uid = '11' |
0.001284 - select * from tad_news where nsn='2061' |
0.000823 - SELECT * FROM users WHERE uid = '11' |
0.000196 - select groupid,name from groups |
0.006974 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2061' order by sort |
0.019967 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='2061' order by sort |
0.025152 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001496 - desc `tadnews_data_center` `sort` |
0.000617 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1956' order by `sort` , `data_sort` |
0.007309 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1956' order by sort |
0.014699 - select * from tad_news where nsn='1956' |
0.000118 - SELECT * FROM users WHERE uid = '11' |
0.000284 - select groupid,name from groups |
0.007272 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1956' order by sort |
0.023918 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1956' order by sort |
0.018427 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002021 - desc `tadnews_data_center` `sort` |
0.000502 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1951' order by `sort` , `data_sort` |
0.006898 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1951' order by sort |
0.011827 - SELECT * FROM users WHERE uid = '21' |
0.000136 - select * from tad_news where nsn='1951' |
0.000360 - SELECT * FROM users WHERE uid = '21' |
0.000295 - select groupid,name from groups |
0.005505 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1951' order by sort |
0.031660 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1951' order by sort |
0.002192 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000560 - desc `tadnews_data_center` `sort` |
0.000305 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1924' order by `sort` , `data_sort` |
0.010757 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1924' order by sort |
0.010241 - select * from tad_news where nsn='1924' |
0.000123 - SELECT * FROM users WHERE uid = '11' |
0.000124 - select groupid,name from groups |
0.005482 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1924' order by sort |
0.037573 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1924' order by sort |
0.000148 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000763 - 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`='1922' order by `sort` , `data_sort` |
0.035454 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1922' order by sort |
0.000341 - SELECT * FROM users WHERE uid = '11' |
0.000845 - select * from tad_news where nsn='1922' |
0.000193 - SELECT * FROM users WHERE uid = '11' |
0.000380 - select groupid,name from groups |
0.011844 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1922' order by sort |
0.014782 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1922' order by sort |
0.000727 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001697 - desc `tadnews_data_center` `sort` |
0.006587 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1915' order by `sort` , `data_sort` |
0.006112 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1915' order by sort |
0.005968 - SELECT * FROM users WHERE uid = '11' |
0.000157 - select * from tad_news where nsn='1915' |
0.000249 - SELECT * FROM users WHERE uid = '11' |
0.000093 - select groupid,name from groups |
0.007388 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1915' order by sort |
0.021287 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1915' order by sort |
0.000801 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002109 - desc `tadnews_data_center` `sort` |
0.004510 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1914' order by `sort` , `data_sort` |
0.008394 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1914' order by sort |
0.011819 - SELECT * FROM users WHERE uid = '11' |
0.006509 - select * from tad_news where nsn='1914' |
0.000128 - SELECT * FROM users WHERE uid = '11' |
0.000121 - select groupid,name from groups |
0.005972 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1914' order by sort |
0.008573 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1914' order by sort |
0.007713 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002247 - desc `tadnews_data_center` `sort` |
0.001945 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1803' order by `sort` , `data_sort` |
0.009095 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1803' order by sort |
0.010047 - SELECT * FROM users WHERE uid = '11' |
0.000110 - SELECT * FROM users WHERE uid = '11' |
0.000180 - SELECT * FROM users WHERE uid = '11' |
0.000131 - select * from tad_news where nsn='1803' |
0.000094 - SELECT * FROM users WHERE uid = '11' |
0.000091 - select groupid,name from groups |
0.013760 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1803' order by sort |
0.009344 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1803' order by sort |
0.001913 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.004919 - desc `tadnews_data_center` `sort` |
0.003796 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1794' order by `sort` , `data_sort` |
0.006876 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1794' order by sort |
0.003328 - SELECT * FROM users WHERE uid = '11' |
0.000326 - SELECT * FROM users WHERE uid = '11' |
0.000511 - SELECT * FROM users WHERE uid = '11' |
0.010210 - select * from tad_news where nsn='1794' |
0.000542 - SELECT * FROM users WHERE uid = '11' |
0.000097 - select groupid,name from groups |
0.015187 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1794' order by sort |
0.008292 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1794' order by sort |
0.000302 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002541 - desc `tadnews_data_center` `sort` |
0.007065 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1639' order by `sort` , `data_sort` |
0.007533 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1639' order by sort |
0.011383 - select * from tad_news where nsn='1639' |
0.000738 - SELECT * FROM users WHERE uid = '11' |
0.000220 - select groupid,name from groups |
0.015607 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1639' order by sort |
0.006608 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1639' order by sort |
0.000422 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002388 - desc `tadnews_data_center` `sort` |
0.007061 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1328' order by `sort` , `data_sort` |
0.007536 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1328' order by sort |
0.004252 - SELECT * FROM users WHERE uid = '17' |
0.000455 - SELECT * FROM users WHERE uid = '17' |
0.000668 - select * from tad_news where nsn='1328' |
0.006945 - SELECT * FROM users WHERE uid = '17' |
0.000592 - select groupid,name from groups |
0.006471 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1328' order by sort |
0.022223 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1328' order by sort |
0.000977 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.007317 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.002082 - 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 |