資料庫語法 |
---|
0.000066 - SET SQL_BIG_SELECTS = 1 |
0.002769 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001084 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '7dfbq46g9dicpci697ft90icup' |
0.001321 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001586 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000933 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000583 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000915 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000391 - select mid from modules where dirname='tadnews' |
0.000620 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000474 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001773 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.004894 - 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.001587 - 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.000665 - 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.000552 - 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.114241 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-29 19:58:09' and always_top_date!='0000-00-00 00:00:00' |
0.000820 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.296087 - 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-29 19:58:08' and (end_day > '2025-09-29 19:58:08' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.559819 - 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-29 19:58:08' and (end_day > '2025-09-29 19:58:08' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 100, 20 |
0.005471 - 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`='10922' order by `sort` , `data_sort` |
0.018641 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10922' order by sort |
0.003193 - select * from tad_news where nsn='10922' |
0.001755 - SELECT * FROM users WHERE uid = '219' |
0.004634 - select groupid,name from groups |
0.013452 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10922' order by sort |
0.026718 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10922' order by sort |
0.000874 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001024 - SELECT * FROM smiles |
0.015970 - desc `tadnews_data_center` `sort` |
0.004075 - 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.007881 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10921' order by sort |
0.009738 - select * from tad_news where nsn='10921' |
0.000452 - select groupid,name from groups |
0.015914 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10921' order by sort |
0.011687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10921' order by sort |
0.009431 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000572 - desc `tadnews_data_center` `sort` |
0.001325 - 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.006456 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10920' order by sort |
0.011374 - SELECT * FROM users WHERE uid = '167' |
0.002396 - select * from tad_news where nsn='10920' |
0.000139 - select groupid,name from groups |
0.008138 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10920' order by sort |
0.018134 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10920' order by sort |
0.012059 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000450 - desc `tadnews_data_center` `sort` |
0.000603 - 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.017137 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10919' order by sort |
0.000666 - select * from tad_news where nsn='10919' |
0.001186 - select groupid,name from groups |
0.009248 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10919' order by sort |
0.013886 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10919' order by sort |
0.009563 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002985 - desc `tadnews_data_center` `sort` |
0.001153 - 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.010341 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10917' order by sort |
0.005882 - select * from tad_news where nsn='10917' |
0.000344 - select groupid,name from groups |
0.005960 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10917' order by sort |
0.014074 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10917' order by sort |
0.010556 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000786 - desc `tadnews_data_center` `sort` |
0.000919 - 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.006831 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10918' order by sort |
0.010958 - select * from tad_news where nsn='10918' |
0.000627 - SELECT * FROM users WHERE uid = '180' |
0.000326 - select groupid,name from groups |
0.005864 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10918' order by sort |
0.016281 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10918' order by sort |
0.006259 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001127 - desc `tadnews_data_center` `sort` |
0.001038 - 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.006418 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10916' order by sort |
0.010556 - select * from tad_news where nsn='10916' |
0.000175 - select groupid,name from groups |
0.007243 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10916' order by sort |
0.014035 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10916' order by sort |
0.007609 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002823 - desc `tadnews_data_center` `sort` |
0.001481 - 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.007796 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10915' order by sort |
0.009571 - SELECT * FROM users WHERE uid = '37' |
0.000140 - select * from tad_news where nsn='10915' |
0.000628 - select groupid,name from groups |
0.006340 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10915' order by sort |
0.016704 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10915' order by sort |
0.008982 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001974 - desc `tadnews_data_center` `sort` |
0.000995 - 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.019465 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10914' order by sort |
0.002676 - SELECT * FROM users WHERE uid = '224' |
0.000701 - select * from tad_news where nsn='10914' |
0.000141 - select groupid,name from groups |
0.013442 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10914' order by sort |
0.006754 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10914' order by sort |
0.006736 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001157 - desc `tadnews_data_center` `sort` |
0.000672 - 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.017054 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10913' order by sort |
0.005308 - select * from tad_news where nsn='10913' |
0.012680 - select groupid,name from groups |
0.014303 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10913' order by sort |
0.006678 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10913' order by sort |
0.007526 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001187 - desc `tadnews_data_center` `sort` |
0.001058 - 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.007783 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10912' order by sort |
0.008959 - select * from tad_news where nsn='10912' |
0.000161 - select groupid,name from groups |
0.015617 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10912' order by sort |
0.006590 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10912' order by sort |
0.008281 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000635 - desc `tadnews_data_center` `sort` |
0.000453 - 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.014822 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10911' order by sort |
0.000667 - select * from tad_news where nsn='10911' |
0.000477 - select groupid,name from groups |
0.005481 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10911' order by sort |
0.011531 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10911' order by sort |
0.004964 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.007466 - 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`='10910' order by `sort` , `data_sort` |
0.005184 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10910' order by sort |
0.001020 - select * from tad_news where nsn='10910' |
0.000498 - select groupid,name from groups |
0.010633 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10910' order by sort |
0.015556 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10910' order by sort |
0.000113 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001374 - desc `tadnews_data_center` `sort` |
0.000219 - 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.007653 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10909' order by sort |
0.006000 - select * from tad_news where nsn='10909' |
0.000419 - select groupid,name from groups |
0.013190 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10909' order by sort |
0.005206 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10909' order by sort |
0.002296 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002995 - desc `tadnews_data_center` `sort` |
0.001866 - 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.011744 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10908' order by sort |
0.001064 - select * from tad_news where nsn='10908' |
0.000593 - select groupid,name from groups |
0.005023 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10908' order by sort |
0.008806 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10908' order by sort |
0.004577 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001518 - desc `tadnews_data_center` `sort` |
0.001004 - 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.006329 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10907' order by sort |
0.005855 - SELECT * FROM users WHERE uid = '195' |
0.000544 - select * from tad_news where nsn='10907' |
0.000413 - select groupid,name from groups |
0.010209 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10907' order by sort |
0.004656 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10907' order by sort |
0.004621 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000972 - desc `tadnews_data_center` `sort` |
0.001378 - 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.006668 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10906' order by sort |
0.005527 - select * from tad_news where nsn='10906' |
0.000530 - select groupid,name from groups |
0.004461 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10906' order by sort |
0.017874 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10906' order by sort |
0.000169 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000853 - desc `tadnews_data_center` `sort` |
0.001577 - 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.006183 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10905' order by sort |
0.004509 - select * from tad_news where nsn='10905' |
0.000293 - select groupid,name from groups |
0.005181 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10905' order by sort |
0.013172 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10905' order by sort |
0.005753 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004164 - desc `tadnews_data_center` `sort` |
0.004041 - 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.007531 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10904' order by sort |
0.001712 - select * from tad_news where nsn='10904' |
0.000448 - select groupid,name from groups |
0.009282 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10904' order by sort |
0.011443 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10904' order by sort |
0.001485 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000603 - desc `tadnews_data_center` `sort` |
0.000627 - 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.011675 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10903' order by sort |
0.002151 - select * from tad_news where nsn='10903' |
0.000073 - select groupid,name from groups |
0.006487 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10903' order by sort |
0.013087 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10903' order by sort |
0.005452 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000128 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000986 - 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 |