資料庫語法 |
---|
0.000051 - SET SQL_BIG_SELECTS = 1 |
0.002163 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000297 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'dqqk7a5ttip5obshfb4kl2socq' |
0.000221 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001466 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.001272 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.001195 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000557 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000138 - select mid from modules where dirname='tadnews' |
0.000538 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000324 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001546 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003366 - 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.000876 - 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.000556 - 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.000554 - 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.849950 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 01:58:46' and always_top_date!='0000-00-00 00:00:00' |
0.000699 - select not_news from tad_news_cate where ncsn='9' |
0.000448 - select * from tad_news_cate where ncsn='9' |
0.344398 - select count(*) from tad_news where ncsn='9' |
0.008019 - select groupid,name from groups |
0.000467 - select groupid,name from groups |
0.003917 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '9' order by sort |
0.334528 - select * from tad_news where 1 and enable='1' and `ncsn` = '9' and start_day < '2025-10-01 01:58:44' and (end_day > '2025-10-01 01:58:44' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.681176 - select * from tad_news where 1 and enable='1' and `ncsn` = '9' and start_day < '2025-10-01 01:58:44' and (end_day > '2025-10-01 01:58:44' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 120, 20 |
0.006002 - desc `tadnews_data_center` `sort` |
0.003236 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10229' order by `sort` , `data_sort` |
0.012638 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10229' order by sort |
0.002757 - select * from tad_news where nsn='10229' |
0.000460 - SELECT * FROM users WHERE uid = '228' |
0.000881 - select groupid,name from groups |
0.003812 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10229' order by sort |
0.021990 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10229' order by sort |
0.018141 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000375 - SELECT * FROM smiles |
0.001467 - desc `tadnews_data_center` `sort` |
0.003439 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10228' order by `sort` , `data_sort` |
0.019740 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10228' order by sort |
0.001315 - select * from tad_news where nsn='10228' |
0.001027 - select groupid,name from groups |
0.016771 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10228' order by sort |
0.011472 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10228' order by sort |
0.016723 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003238 - desc `tadnews_data_center` `sort` |
0.000864 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10227' order by `sort` , `data_sort` |
0.030979 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10227' order by sort |
0.001127 - select * from tad_news where nsn='10227' |
0.006018 - select groupid,name from groups |
0.021384 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10227' order by sort |
0.008407 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10227' order by sort |
0.026567 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.019100 - desc `tadnews_data_center` `sort` |
0.015133 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10226' order by `sort` , `data_sort` |
0.007790 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10226' order by sort |
0.001428 - select * from tad_news where nsn='10226' |
0.000199 - select groupid,name from groups |
0.015666 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10226' order by sort |
0.041473 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10226' order by sort |
0.000855 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000494 - desc `tadnews_data_center` `sort` |
0.005556 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10225' order by `sort` , `data_sort` |
0.021694 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10225' order by sort |
0.012673 - select * from tad_news where nsn='10225' |
0.003604 - select groupid,name from groups |
0.008779 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10225' order by sort |
0.024327 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10225' order by sort |
0.007296 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001612 - desc `tadnews_data_center` `sort` |
0.000454 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10224' order by `sort` , `data_sort` |
0.008123 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10224' order by sort |
0.007113 - select * from tad_news where nsn='10224' |
0.000085 - select groupid,name from groups |
0.010068 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10224' order by sort |
0.006383 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10224' order by sort |
0.009046 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000571 - desc `tadnews_data_center` `sort` |
0.004410 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10223' order by `sort` , `data_sort` |
0.022003 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10223' order by sort |
0.007127 - select * from tad_news where nsn='10223' |
0.001795 - select groupid,name from groups |
0.048862 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10223' order by sort |
0.014292 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10223' order by sort |
0.010071 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002994 - desc `tadnews_data_center` `sort` |
0.000216 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10222' order by `sort` , `data_sort` |
0.005151 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10222' order by sort |
0.009410 - SELECT * FROM users WHERE uid = '180' |
0.004461 - select * from tad_news where nsn='10222' |
0.000834 - select groupid,name from groups |
0.013204 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10222' order by sort |
0.012400 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10222' order by sort |
0.000779 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000776 - desc `tadnews_data_center` `sort` |
0.003380 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10220' order by `sort` , `data_sort` |
0.020793 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10220' order by sort |
0.111531 - select * from tad_news where nsn='10220' |
0.006145 - select groupid,name from groups |
0.020192 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10220' order by sort |
0.022426 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10220' order by sort |
0.010143 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.005345 - desc `tadnews_data_center` `sort` |
0.003679 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10219' order by `sort` , `data_sort` |
0.029704 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10219' order by sort |
0.019936 - select * from tad_news where nsn='10219' |
0.000427 - select groupid,name from groups |
0.026406 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10219' order by sort |
0.026285 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10219' order by sort |
0.014129 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002931 - desc `tadnews_data_center` `sort` |
0.005882 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10217' order by `sort` , `data_sort` |
0.020646 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10217' order by sort |
0.009600 - select * from tad_news where nsn='10217' |
0.000481 - select groupid,name from groups |
0.026763 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10217' order by sort |
0.024126 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10217' order by sort |
0.014871 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.008393 - desc `tadnews_data_center` `sort` |
0.000213 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10209' order by `sort` , `data_sort` |
0.013752 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10209' order by sort |
0.016403 - SELECT * FROM users WHERE uid = '249' |
0.000170 - select * from tad_news where nsn='10209' |
0.000094 - select groupid,name from groups |
0.031685 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10209' order by sort |
0.060272 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10209' order by sort |
0.000648 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.008174 - desc `tadnews_data_center` `sort` |
0.004065 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10204' order by `sort` , `data_sort` |
0.032452 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10204' order by sort |
0.007686 - select * from tad_news where nsn='10204' |
0.007354 - select groupid,name from groups |
0.006574 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10204' order by sort |
0.059357 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10204' order by sort |
0.009022 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001113 - desc `tadnews_data_center` `sort` |
0.000949 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10203' order by `sort` , `data_sort` |
0.026813 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10203' order by sort |
0.007276 - select * from tad_news where nsn='10203' |
0.000254 - select groupid,name from groups |
0.019998 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10203' order by sort |
0.024159 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10203' order by sort |
0.004930 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001038 - desc `tadnews_data_center` `sort` |
0.003243 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10202' order by `sort` , `data_sort` |
0.014870 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10202' order by sort |
0.007135 - select * from tad_news where nsn='10202' |
0.000221 - select groupid,name from groups |
0.006690 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10202' order by sort |
0.010993 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10202' order by sort |
0.019112 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001448 - desc `tadnews_data_center` `sort` |
0.000531 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10188' order by `sort` , `data_sort` |
0.005496 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10188' order by sort |
0.006263 - select * from tad_news where nsn='10188' |
0.000598 - SELECT * FROM users WHERE uid = '182' |
0.000436 - select groupid,name from groups |
0.005937 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10188' order by sort |
0.017163 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10188' order by sort |
0.007832 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001262 - desc `tadnews_data_center` `sort` |
0.000427 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10187' order by `sort` , `data_sort` |
0.016580 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10187' order by sort |
0.000421 - select * from tad_news where nsn='10187' |
0.000524 - select groupid,name from groups |
0.007200 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10187' order by sort |
0.011901 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10187' order by sort |
0.010492 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000823 - desc `tadnews_data_center` `sort` |
0.000416 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10181' order by `sort` , `data_sort` |
0.013808 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10181' order by sort |
0.000264 - select * from tad_news where nsn='10181' |
0.000318 - select groupid,name from groups |
0.015355 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10181' order by sort |
0.013823 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10181' order by sort |
0.004017 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.010469 - desc `tadnews_data_center` `sort` |
0.001541 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10180' order by `sort` , `data_sort` |
0.007360 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10180' order by sort |
0.007943 - select * from tad_news where nsn='10180' |
0.000313 - select groupid,name from groups |
0.007767 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10180' order by sort |
0.014081 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10180' order by sort |
0.010758 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.007414 - desc `tadnews_data_center` `sort` |
0.000409 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10176' order by `sort` , `data_sort` |
0.013037 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10176' order by sort |
0.000966 - select * from tad_news where nsn='10176' |
0.000379 - select groupid,name from groups |
0.004379 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10176' order by sort |
0.029725 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10176' order by sort |
0.000399 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000222 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.002022 - 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.000377 - select * from tad_news_cate where ncsn='9' |
0.134322 - select count(*) from tad_news where ncsn='9' |
0.000349 - select groupid,name from groups |
0.000091 - select groupid,name from groups |
0.000168 - select ncsn,nc_title from tad_news_cate where of_ncsn='9' |
0.000559 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000735 - 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 |