資料庫語法 |
---|
0.000265 - SET SQL_BIG_SELECTS = 1 |
0.002020 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000789 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'lo5p9ej021ooh7gepfu57i83em' |
0.000797 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.002492 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000656 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000748 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000690 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000398 - select mid from modules where dirname='tadnews' |
0.000377 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000460 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001311 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002578 - 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.000447 - 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.000412 - 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.000387 - 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.592500 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 12:05:05' and always_top_date!='0000-00-00 00:00:00' |
0.000297 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.785159 - 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 12:05:03' and (end_day > '2025-09-30 12:05:03' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.873939 - 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 12:05:03' and (end_day > '2025-09-30 12:05:03' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 100, 20 |
0.006174 - desc `tadnews_data_center` `sort` |
0.002481 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10922' order by `sort` , `data_sort` |
0.019387 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10922' order by sort |
0.023331 - select * from tad_news where nsn='10922' |
0.000580 - SELECT * FROM users WHERE uid = '219' |
0.004712 - select groupid,name from groups |
0.006538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10922' order by sort |
0.037635 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10922' order by sort |
0.019494 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000877 - SELECT * FROM smiles |
0.001414 - desc `tadnews_data_center` `sort` |
0.002154 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10921' order by `sort` , `data_sort` |
0.030863 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10921' order by sort |
0.002082 - select * from tad_news where nsn='10921' |
0.000102 - select groupid,name from groups |
0.014548 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10921' order by sort |
0.036596 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10921' order by sort |
0.005196 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000561 - desc `tadnews_data_center` `sort` |
0.000730 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10920' order by `sort` , `data_sort` |
0.020138 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10920' order by sort |
0.009939 - SELECT * FROM users WHERE uid = '167' |
0.000688 - select * from tad_news where nsn='10920' |
0.000591 - select groupid,name from groups |
0.021161 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10920' order by sort |
0.030687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10920' order by sort |
0.003129 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001857 - desc `tadnews_data_center` `sort` |
0.007064 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10919' order by `sort` , `data_sort` |
0.020874 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10919' order by sort |
0.009099 - select * from tad_news where nsn='10919' |
0.007062 - select groupid,name from groups |
0.007112 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10919' order by sort |
0.039260 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10919' order by sort |
0.001754 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.006247 - desc `tadnews_data_center` `sort` |
0.001447 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10917' order by `sort` , `data_sort` |
0.030924 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10917' order by sort |
0.001094 - select * from tad_news where nsn='10917' |
0.000418 - select groupid,name from groups |
0.004630 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10917' order by sort |
0.029512 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10917' order by sort |
0.006336 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002625 - desc `tadnews_data_center` `sort` |
0.006578 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10918' order by `sort` , `data_sort` |
0.012341 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10918' order by sort |
0.004928 - select * from tad_news where nsn='10918' |
0.006705 - SELECT * FROM users WHERE uid = '180' |
0.006659 - select groupid,name from groups |
0.011066 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10918' order by sort |
0.026357 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10918' order by sort |
0.006439 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002061 - desc `tadnews_data_center` `sort` |
0.001807 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10916' order by `sort` , `data_sort` |
0.021487 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10916' order by sort |
0.010780 - select * from tad_news where nsn='10916' |
0.001402 - select groupid,name from groups |
0.022653 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10916' order by sort |
0.019989 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10916' order by sort |
0.014788 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002071 - desc `tadnews_data_center` `sort` |
0.000693 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10915' order by `sort` , `data_sort` |
0.022859 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10915' order by sort |
0.007213 - SELECT * FROM users WHERE uid = '37' |
0.001092 - select * from tad_news where nsn='10915' |
0.003104 - select groupid,name from groups |
0.015015 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10915' order by sort |
0.032958 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10915' order by sort |
0.003581 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001413 - desc `tadnews_data_center` `sort` |
0.000797 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10914' order by `sort` , `data_sort` |
0.018244 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10914' order by sort |
0.010294 - SELECT * FROM users WHERE uid = '224' |
0.000218 - select * from tad_news where nsn='10914' |
0.000085 - select groupid,name from groups |
0.008808 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10914' order by sort |
0.033445 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10914' order by sort |
0.011352 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001058 - desc `tadnews_data_center` `sort` |
0.000950 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10913' order by `sort` , `data_sort` |
0.041033 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10913' order by sort |
0.004375 - select * from tad_news where nsn='10913' |
0.000220 - select groupid,name from groups |
0.024958 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10913' order by sort |
0.024450 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10913' order by sort |
0.008931 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001355 - desc `tadnews_data_center` `sort` |
0.003773 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10912' order by `sort` , `data_sort` |
0.011155 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10912' order by sort |
0.019120 - select * from tad_news where nsn='10912' |
0.016444 - select groupid,name from groups |
0.010128 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10912' order by sort |
0.032555 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10912' order by sort |
0.000659 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.006273 - desc `tadnews_data_center` `sort` |
0.000678 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10911' order by `sort` , `data_sort` |
0.006785 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10911' order by sort |
0.140360 - select * from tad_news where nsn='10911' |
0.003073 - select groupid,name from groups |
0.033919 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10911' order by sort |
0.046120 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10911' order by sort |
0.004405 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001578 - desc `tadnews_data_center` `sort` |
0.000836 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10910' order by `sort` , `data_sort` |
0.044306 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10910' order by sort |
0.006477 - select * from tad_news where nsn='10910' |
0.001314 - select groupid,name from groups |
0.048627 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10910' order by sort |
0.006265 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10910' order by sort |
0.007795 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004684 - desc `tadnews_data_center` `sort` |
0.005382 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10909' order by `sort` , `data_sort` |
0.014045 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10909' order by sort |
0.010570 - select * from tad_news where nsn='10909' |
0.000621 - select groupid,name from groups |
0.019332 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10909' order by sort |
0.028769 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10909' order by sort |
0.000195 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000525 - desc `tadnews_data_center` `sort` |
0.001640 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10908' order by `sort` , `data_sort` |
0.020827 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10908' order by sort |
0.002825 - select * from tad_news where nsn='10908' |
0.000288 - select groupid,name from groups |
0.023964 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10908' order by sort |
0.017577 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10908' order by sort |
0.022339 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.002911 - desc `tadnews_data_center` `sort` |
0.003092 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10907' order by `sort` , `data_sort` |
0.047073 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10907' order by sort |
0.003716 - SELECT * FROM users WHERE uid = '195' |
0.000291 - select * from tad_news where nsn='10907' |
0.006123 - select groupid,name from groups |
0.006872 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10907' order by sort |
0.032085 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10907' order by sort |
0.005417 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.002542 - desc `tadnews_data_center` `sort` |
0.002719 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10906' order by `sort` , `data_sort` |
0.030357 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10906' order by sort |
0.005690 - select * from tad_news where nsn='10906' |
0.000740 - select groupid,name from groups |
0.024364 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10906' order by sort |
0.009274 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10906' order by sort |
0.013304 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000658 - desc `tadnews_data_center` `sort` |
0.000636 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10905' order by `sort` , `data_sort` |
0.021233 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10905' order by sort |
0.007832 - select * from tad_news where nsn='10905' |
0.000088 - select groupid,name from groups |
0.020786 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10905' order by sort |
0.012949 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10905' order by sort |
0.010690 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000561 - desc `tadnews_data_center` `sort` |
0.001326 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10904' order by `sort` , `data_sort` |
0.014981 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10904' order by sort |
0.004709 - select * from tad_news where nsn='10904' |
0.000903 - select groupid,name from groups |
0.005706 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10904' order by sort |
0.025430 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10904' order by sort |
0.007831 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000431 - desc `tadnews_data_center` `sort` |
0.000880 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10903' order by `sort` , `data_sort` |
0.017934 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10903' order by sort |
0.007282 - select * from tad_news where nsn='10903' |
0.000106 - select groupid,name from groups |
0.005646 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10903' order by sort |
0.028674 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10903' order by sort |
0.011895 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000638 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000645 - 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 |