資料庫語法 |
---|
0.000088 - SET SQL_BIG_SELECTS = 1 |
0.001273 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000816 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '0fofr6g94vohddi7r7unnhaash' |
0.000186 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001225 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000768 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000298 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000513 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000374 - select mid from modules where dirname='tadnews' |
0.000597 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000386 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.002084 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003633 - 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.001345 - 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.000632 - 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.000678 - 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.107650 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 05:56:17' and always_top_date!='0000-00-00 00:00:00' |
0.000741 - select not_news from tad_news_cate where ncsn='9' |
0.000327 - select * from tad_news_cate where ncsn='9' |
0.074027 - select count(*) from tad_news where ncsn='9' |
0.000216 - select groupid,name from groups |
0.000211 - select groupid,name from groups |
0.000535 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '9' order by sort |
0.137920 - select * from tad_news where 1 and enable='1' and `ncsn` = '9' and start_day < '2025-10-01 05:56:16' and (end_day > '2025-10-01 05:56:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.108750 - select * from tad_news where 1 and enable='1' and `ncsn` = '9' and start_day < '2025-10-01 05:56:16' and (end_day > '2025-10-01 05:56:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 60, 20 |
0.000900 - desc `tadnews_data_center` `sort` |
0.001898 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10582' order by `sort` , `data_sort` |
0.008490 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10582' order by sort |
0.000648 - SELECT * FROM users WHERE uid = '182' |
0.000202 - select * from tad_news where nsn='10582' |
0.000394 - select groupid,name from groups |
0.007930 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10582' order by sort |
0.006907 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10582' order by sort |
0.000153 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000271 - SELECT * FROM smiles |
0.000978 - desc `tadnews_data_center` `sort` |
0.000773 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10573' order by `sort` , `data_sort` |
0.006965 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10573' order by sort |
0.000470 - SELECT * FROM users WHERE uid = '169' |
0.000159 - select * from tad_news where nsn='10573' |
0.000157 - select groupid,name from groups |
0.007298 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10573' order by sort |
0.006696 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10573' order by sort |
0.000172 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000933 - desc `tadnews_data_center` `sort` |
0.000349 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10572' order by `sort` , `data_sort` |
0.006969 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10572' order by sort |
0.000921 - select * from tad_news where nsn='10572' |
0.000251 - select groupid,name from groups |
0.006975 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10572' order by sort |
0.005894 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10572' order by sort |
0.000178 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001016 - desc `tadnews_data_center` `sort` |
0.000183 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10571' order by `sort` , `data_sort` |
0.005886 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10571' order by sort |
0.001170 - select * from tad_news where nsn='10571' |
0.000102 - select groupid,name from groups |
0.007235 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10571' order by sort |
0.005345 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10571' order by sort |
0.000455 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000525 - desc `tadnews_data_center` `sort` |
0.000372 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10539' order by `sort` , `data_sort` |
0.005966 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10539' order by sort |
0.000640 - SELECT * FROM users WHERE uid = '249' |
0.000563 - select * from tad_news where nsn='10539' |
0.000098 - select groupid,name from groups |
0.006192 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10539' order by sort |
0.005484 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10539' order by sort |
0.000563 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001646 - desc `tadnews_data_center` `sort` |
0.000762 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10534' order by `sort` , `data_sort` |
0.007259 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10534' order by sort |
0.000396 - SELECT * FROM users WHERE uid = '180' |
0.000516 - select * from tad_news where nsn='10534' |
0.000132 - select groupid,name from groups |
0.006139 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10534' order by sort |
0.006896 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10534' order by sort |
0.000636 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000910 - desc `tadnews_data_center` `sort` |
0.001040 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10532' order by `sort` , `data_sort` |
0.006517 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10532' order by sort |
0.001205 - SELECT * FROM users WHERE uid = '228' |
0.000242 - select * from tad_news where nsn='10532' |
0.000145 - select groupid,name from groups |
0.006659 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10532' order by sort |
0.008398 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10532' order by sort |
0.000908 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000678 - desc `tadnews_data_center` `sort` |
0.001298 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10531' order by `sort` , `data_sort` |
0.008488 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10531' order by sort |
0.000244 - select * from tad_news where nsn='10531' |
0.000305 - select groupid,name from groups |
0.006427 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10531' order by sort |
0.006934 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10531' order by sort |
0.001733 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000958 - desc `tadnews_data_center` `sort` |
0.000664 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10529' order by `sort` , `data_sort` |
0.006604 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10529' order by sort |
0.000832 - select * from tad_news where nsn='10529' |
0.000426 - select groupid,name from groups |
0.008727 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10529' order by sort |
0.008164 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10529' order by sort |
0.000499 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001147 - desc `tadnews_data_center` `sort` |
0.000724 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10528' order by `sort` , `data_sort` |
0.005910 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10528' order by sort |
0.000896 - select * from tad_news where nsn='10528' |
0.000153 - select groupid,name from groups |
0.006411 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10528' order by sort |
0.007186 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10528' order by sort |
0.000512 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002417 - desc `tadnews_data_center` `sort` |
0.001146 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10527' order by `sort` , `data_sort` |
0.013652 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10527' order by sort |
0.000932 - select * from tad_news where nsn='10527' |
0.000671 - select groupid,name from groups |
0.008966 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10527' order by sort |
0.007131 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10527' order by sort |
0.000485 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001384 - desc `tadnews_data_center` `sort` |
0.000398 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10526' order by `sort` , `data_sort` |
0.007040 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10526' order by sort |
0.000562 - select * from tad_news where nsn='10526' |
0.000552 - select groupid,name from groups |
0.007005 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10526' order by sort |
0.007796 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10526' order by sort |
0.000192 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001610 - desc `tadnews_data_center` `sort` |
0.000955 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10525' order by `sort` , `data_sort` |
0.008943 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10525' order by sort |
0.000341 - select * from tad_news where nsn='10525' |
0.000364 - select groupid,name from groups |
0.008116 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10525' order by sort |
0.008210 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10525' order by sort |
0.000182 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001441 - desc `tadnews_data_center` `sort` |
0.000288 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10524' order by `sort` , `data_sort` |
0.006731 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10524' order by sort |
0.000885 - select * from tad_news where nsn='10524' |
0.000448 - select groupid,name from groups |
0.007836 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10524' order by sort |
0.010464 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10524' order by sort |
0.000244 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001141 - desc `tadnews_data_center` `sort` |
0.000713 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10523' order by `sort` , `data_sort` |
0.008471 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10523' order by sort |
0.000279 - select * from tad_news where nsn='10523' |
0.000114 - select groupid,name from groups |
0.006537 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10523' order by sort |
0.005647 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10523' order by sort |
0.000307 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001216 - 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`='10522' order by `sort` , `data_sort` |
0.007277 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10522' order by sort |
0.000419 - select * from tad_news where nsn='10522' |
0.000162 - select groupid,name from groups |
0.007470 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10522' order by sort |
0.005284 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10522' order by sort |
0.000214 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000415 - desc `tadnews_data_center` `sort` |
0.000203 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10521' order by `sort` , `data_sort` |
0.004445 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10521' order by sort |
0.000368 - select * from tad_news where nsn='10521' |
0.000122 - select groupid,name from groups |
0.005278 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10521' order by sort |
0.004172 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10521' order by sort |
0.000211 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000373 - 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`='10520' order by `sort` , `data_sort` |
0.005640 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10520' order by sort |
0.000348 - select * from tad_news where nsn='10520' |
0.000123 - select groupid,name from groups |
0.005104 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10520' order by sort |
0.005394 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10520' order by sort |
0.000243 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000417 - desc `tadnews_data_center` `sort` |
0.000203 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10519' order by `sort` , `data_sort` |
0.006640 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10519' order by sort |
0.000298 - select * from tad_news where nsn='10519' |
0.000461 - select groupid,name from groups |
0.005836 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10519' order by sort |
0.007539 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10519' order by sort |
0.000275 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000538 - desc `tadnews_data_center` `sort` |
0.000249 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10518' order by `sort` , `data_sort` |
0.005414 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10518' order by sort |
0.000331 - select * from tad_news where nsn='10518' |
0.000125 - select groupid,name from groups |
0.005788 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10518' order by sort |
0.007886 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10518' order by sort |
0.000478 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000196 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.000768 - 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.000154 - select * from tad_news_cate where ncsn='9' |
0.082892 - select count(*) from tad_news where ncsn='9' |
0.000474 - select groupid,name from groups |
0.000076 - select groupid,name from groups |
0.000260 - select ncsn,nc_title from tad_news_cate where of_ncsn='9' |
0.000287 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001399 - 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 |