資料庫語法 |
---|
0.006822 - SET SQL_BIG_SELECTS = 1 |
0.002476 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.003210 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '6lqe3568kpsdg865mtm1a56f66' |
0.011639 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001740 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.002040 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.001107 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000679 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000950 - select mid from modules where dirname='tadnews' |
0.004119 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000555 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001831 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002506 - 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.000764 - 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.000472 - 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.001153 - 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.407895 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 06:06:51' and always_top_date!='0000-00-00 00:00:00' |
0.000677 - select not_news from tad_news_cate where ncsn='11' |
0.000340 - select * from tad_news_cate where ncsn='11' |
0.137015 - select count(*) from tad_news where ncsn='11' |
0.006832 - select groupid,name from groups |
0.000287 - select groupid,name from groups |
0.000397 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '11' order by sort |
0.283630 - select * from tad_news where 1 and enable='1' and `ncsn` = '11' and start_day < '2025-10-01 06:06:50' and (end_day > '2025-10-01 06:06:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.246085 - select * from tad_news where 1 and enable='1' and `ncsn` = '11' and start_day < '2025-10-01 06:06:50' and (end_day > '2025-10-01 06:06:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 480, 20 |
0.006592 - desc `tadnews_data_center` `sort` |
0.000992 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5608' order by `sort` , `data_sort` |
0.026710 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5608' order by sort |
0.000209 - select * from tad_news where nsn='5608' |
0.000183 - SELECT * FROM users WHERE uid = '182' |
0.000335 - select groupid,name from groups |
0.016795 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5608' order by sort |
0.017379 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5608' order by sort |
0.003697 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000357 - SELECT * FROM smiles |
0.005051 - desc `tadnews_data_center` `sort` |
0.000784 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5565' order by `sort` , `data_sort` |
0.009588 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5565' order by sort |
0.010819 - SELECT * FROM users WHERE uid = '37' |
0.000131 - select * from tad_news where nsn='5565' |
0.000072 - select groupid,name from groups |
0.005225 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5565' order by sort |
0.013189 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5565' order by sort |
0.013771 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.006223 - desc `tadnews_data_center` `sort` |
0.000568 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5563' order by `sort` , `data_sort` |
0.006833 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5563' order by sort |
0.001220 - select * from tad_news where nsn='5563' |
0.006013 - select groupid,name from groups |
0.017971 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5563' order by sort |
0.013408 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5563' order by sort |
0.012938 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000357 - desc `tadnews_data_center` `sort` |
0.000887 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5546' order by `sort` , `data_sort` |
0.025017 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5546' order by sort |
0.001200 - select * from tad_news where nsn='5546' |
0.000302 - select groupid,name from groups |
0.006193 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5546' order by sort |
0.018821 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5546' order by sort |
0.015084 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000774 - desc `tadnews_data_center` `sort` |
0.002254 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5538' order by `sort` , `data_sort` |
0.016209 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5538' order by sort |
0.001415 - select * from tad_news where nsn='5538' |
0.005645 - select groupid,name from groups |
0.017448 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5538' order by sort |
0.019809 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5538' order by sort |
0.002380 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001768 - desc `tadnews_data_center` `sort` |
0.005511 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5517' order by `sort` , `data_sort` |
0.014276 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5517' order by sort |
0.001497 - select * from tad_news where nsn='5517' |
0.001351 - select groupid,name from groups |
0.025785 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5517' order by sort |
0.043479 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5517' order by sort |
0.001021 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001255 - desc `tadnews_data_center` `sort` |
0.001208 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5502' order by `sort` , `data_sort` |
0.016945 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5502' order by sort |
0.003658 - select * from tad_news where nsn='5502' |
0.000373 - select groupid,name from groups |
0.005618 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5502' order by sort |
0.029061 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5502' order by sort |
0.000893 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.003306 - desc `tadnews_data_center` `sort` |
0.001856 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5490' order by `sort` , `data_sort` |
0.015829 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5490' order by sort |
0.003480 - select * from tad_news where nsn='5490' |
0.006310 - select groupid,name from groups |
0.009468 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5490' order by sort |
0.007659 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5490' order by sort |
0.014459 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.007792 - desc `tadnews_data_center` `sort` |
0.000311 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5470' order by `sort` , `data_sort` |
0.006487 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5470' order by sort |
0.005317 - select * from tad_news where nsn='5470' |
0.001952 - select groupid,name from groups |
0.017869 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5470' order by sort |
0.022317 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5470' order by sort |
0.011587 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.003986 - desc `tadnews_data_center` `sort` |
0.000330 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5449' order by `sort` , `data_sort` |
0.022198 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5449' order by sort |
0.012180 - select * from tad_news where nsn='5449' |
0.000620 - select groupid,name from groups |
0.017181 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5449' order by sort |
0.021222 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5449' order by sort |
0.005033 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001092 - desc `tadnews_data_center` `sort` |
0.000633 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5446' order by `sort` , `data_sort` |
0.010069 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5446' order by sort |
0.013689 - select * from tad_news where nsn='5446' |
0.000522 - select groupid,name from groups |
0.006209 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5446' order by sort |
0.020972 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5446' order by sort |
0.001949 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.005638 - desc `tadnews_data_center` `sort` |
0.000383 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5445' order by `sort` , `data_sort` |
0.015386 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5445' order by sort |
0.001230 - select * from tad_news where nsn='5445' |
0.000070 - select groupid,name from groups |
0.004021 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5445' order by sort |
0.018653 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5445' order by sort |
0.012326 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000730 - desc `tadnews_data_center` `sort` |
0.000709 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5385' order by `sort` , `data_sort` |
0.018442 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5385' order by sort |
0.000169 - select * from tad_news where nsn='5385' |
0.000526 - select groupid,name from groups |
0.014167 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5385' order by sort |
0.019867 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5385' order by sort |
0.003551 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.004406 - desc `tadnews_data_center` `sort` |
0.003264 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5384' order by `sort` , `data_sort` |
0.011762 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5384' order by sort |
0.005959 - select * from tad_news where nsn='5384' |
0.008437 - select groupid,name from groups |
0.011522 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5384' order by sort |
0.006955 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5384' order by sort |
0.009346 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.004869 - desc `tadnews_data_center` `sort` |
0.002607 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5353' order by `sort` , `data_sort` |
0.012219 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5353' order by sort |
0.001531 - select * from tad_news where nsn='5353' |
0.015417 - select groupid,name from groups |
0.011163 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5353' order by sort |
0.052215 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5353' order by sort |
0.008174 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000740 - desc `tadnews_data_center` `sort` |
0.000388 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5341' order by `sort` , `data_sort` |
0.012167 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5341' order by sort |
0.002282 - select * from tad_news where nsn='5341' |
0.003875 - select groupid,name from groups |
0.010664 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5341' order by sort |
0.012111 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5341' order by sort |
0.000138 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000613 - desc `tadnews_data_center` `sort` |
0.000245 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5340' order by `sort` , `data_sort` |
0.015580 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5340' order by sort |
0.000282 - select * from tad_news where nsn='5340' |
0.000106 - select groupid,name from groups |
0.005942 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5340' order by sort |
0.014590 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5340' order by sort |
0.000160 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000384 - desc `tadnews_data_center` `sort` |
0.000468 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5290' order by `sort` , `data_sort` |
0.010951 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5290' order by sort |
0.007387 - select * from tad_news where nsn='5290' |
0.000099 - select groupid,name from groups |
0.004139 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5290' order by sort |
0.019669 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5290' order by sort |
0.001333 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000450 - desc `tadnews_data_center` `sort` |
0.002208 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5289' order by `sort` , `data_sort` |
0.013887 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5289' order by sort |
0.006075 - select * from tad_news where nsn='5289' |
0.000139 - select groupid,name from groups |
0.022570 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5289' order by sort |
0.015643 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5289' order by sort |
0.000616 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000876 - 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`='5217' order by `sort` , `data_sort` |
0.010946 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5217' order by sort |
0.004575 - select * from tad_news where nsn='5217' |
0.001741 - select groupid,name from groups |
0.006038 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5217' order by sort |
0.005998 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5217' order by sort |
0.000429 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000137 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.001540 - SELECT t1.ncsn AS lev1, t2.ncsn as lev2, t3.ncsn as lev3, t4.ncsn as lev4, t5.ncsn as lev5, t6.ncsn as lev6, t7.ncsn as lev7
FROM `tad_news_cate` t1
LEFT JOIN `tad_news_cate` t2 ON t2.of_ncsn = t1.ncsn
LEFT JOIN `tad_news_cate` t3 ON t3.of_ncsn = t2.ncsn
LEFT JOIN `tad_news_cate` t4 ON t4.of_ncsn = t3.ncsn
LEFT JOIN `tad_news_cate` t5 ON t5.of_ncsn = t4.ncsn
LEFT JOIN `tad_news_cate` t6 ON t6.of_ncsn = t5.ncsn
LEFT JOIN `tad_news_cate` t7 ON t7.of_ncsn = t6.ncsn
WHERE t1.of_ncsn = '0' |
0.000125 - select * from tad_news_cate where ncsn='11' |
0.070194 - select count(*) from tad_news where ncsn='11' |
0.001470 - select groupid,name from groups |
0.000087 - select groupid,name from groups |
0.000227 - select ncsn,nc_title from tad_news_cate where of_ncsn='11' |
0.000169 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.002063 - 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 |