資料庫語法 |
---|
0.000544 - SET SQL_BIG_SELECTS = 1 |
0.002633 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000988 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '1tn6vt1bbs44e763pjfff3rodf' |
0.000893 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001570 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000852 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000835 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000332 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000345 - select mid from modules where dirname='tadnews' |
0.000404 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000328 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001169 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002576 - 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.001232 - 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.000621 - 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.000477 - 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.184399 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 20:04:33' and always_top_date!='0000-00-00 00:00:00' |
0.001865 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.114166 - select * from tad_news where 1 and enable='1' and prefix_tag = '13' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 20:04:32' and (end_day > '2025-09-30 20:04:32' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.085569 - select * from tad_news where 1 and enable='1' and prefix_tag = '13' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 20:04:32' and (end_day > '2025-09-30 20:04:32' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
0.000861 - desc `tadnews_data_center` `sort` |
0.000958 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10610' order by `sort` , `data_sort` |
0.007132 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10610' order by sort |
0.000900 - SELECT * FROM users WHERE uid = '227' |
0.000126 - select * from tad_news where nsn='10610' |
0.000132 - select groupid,name from groups |
0.005773 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10610' order by sort |
0.006029 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10610' order by sort |
0.000279 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000176 - SELECT * FROM smiles |
0.000458 - desc `tadnews_data_center` `sort` |
0.000576 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10609' order by `sort` , `data_sort` |
0.006285 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10609' order by sort |
0.000424 - select * from tad_news where nsn='10609' |
0.000170 - select groupid,name from groups |
0.005976 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10609' order by sort |
0.007979 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10609' order by sort |
0.000367 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001627 - desc `tadnews_data_center` `sort` |
0.000963 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10608' order by `sort` , `data_sort` |
0.007909 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10608' order by sort |
0.000212 - select * from tad_news where nsn='10608' |
0.000228 - select groupid,name from groups |
0.007361 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10608' order by sort |
0.006372 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10608' order by sort |
0.000884 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.002100 - desc `tadnews_data_center` `sort` |
0.000238 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10169' order by `sort` , `data_sort` |
0.005944 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10169' order by sort |
0.001289 - select * from tad_news where nsn='10169' |
0.000352 - select groupid,name from groups |
0.005857 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10169' order by sort |
0.006954 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10169' order by sort |
0.000230 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000933 - desc `tadnews_data_center` `sort` |
0.000207 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9541' order by `sort` , `data_sort` |
0.006766 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9541' order by sort |
0.000259 - select * from tad_news where nsn='9541' |
0.000456 - select groupid,name from groups |
0.007483 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9541' order by sort |
0.007113 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9541' order by sort |
0.000341 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001306 - desc `tadnews_data_center` `sort` |
0.000461 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9540' order by `sort` , `data_sort` |
0.007996 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9540' order by sort |
0.000802 - select * from tad_news where nsn='9540' |
0.000587 - select groupid,name from groups |
0.007147 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9540' order by sort |
0.008611 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9540' order by sort |
0.000617 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000963 - desc `tadnews_data_center` `sort` |
0.001077 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9276' order by `sort` , `data_sort` |
0.007536 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9276' order by sort |
0.000231 - select * from tad_news where nsn='9276' |
0.000120 - select groupid,name from groups |
0.006454 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9276' order by sort |
0.006312 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9276' order by sort |
0.000169 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000665 - desc `tadnews_data_center` `sort` |
0.000189 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9135' order by `sort` , `data_sort` |
0.005478 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9135' order by sort |
0.000196 - select * from tad_news where nsn='9135' |
0.000095 - select groupid,name from groups |
0.005772 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9135' order by sort |
0.007668 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9135' order by sort |
0.000373 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000445 - desc `tadnews_data_center` `sort` |
0.000395 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9020' order by `sort` , `data_sort` |
0.006463 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9020' order by sort |
0.000173 - select * from tad_news where nsn='9020' |
0.000372 - select groupid,name from groups |
0.006212 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9020' order by sort |
0.006462 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9020' order by sort |
0.000206 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000667 - desc `tadnews_data_center` `sort` |
0.000374 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9072' order by `sort` , `data_sort` |
0.005900 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9072' order by sort |
0.000209 - select * from tad_news where nsn='9072' |
0.000096 - select groupid,name from groups |
0.005466 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9072' order by sort |
0.005104 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9072' order by sort |
0.000317 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000371 - desc `tadnews_data_center` `sort` |
0.000189 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8681' order by `sort` , `data_sort` |
0.005194 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8681' order by sort |
0.000222 - select * from tad_news where nsn='8681' |
0.000096 - select groupid,name from groups |
0.005070 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8681' order by sort |
0.006064 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8681' order by sort |
0.000228 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000355 - 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`='8527' order by `sort` , `data_sort` |
0.007231 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8527' order by sort |
0.000158 - select * from tad_news where nsn='8527' |
0.000091 - select groupid,name from groups |
0.007204 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8527' order by sort |
0.007162 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8527' order by sort |
0.000913 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001146 - desc `tadnews_data_center` `sort` |
0.000810 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8526' order by `sort` , `data_sort` |
0.010074 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8526' order by sort |
0.000538 - select * from tad_news where nsn='8526' |
0.000433 - select groupid,name from groups |
0.007096 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8526' order by sort |
0.007039 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8526' order by sort |
0.000619 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001631 - desc `tadnews_data_center` `sort` |
0.000381 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8234' order by `sort` , `data_sort` |
0.007424 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8234' order by sort |
0.000147 - select * from tad_news where nsn='8234' |
0.000297 - select groupid,name from groups |
0.007263 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8234' order by sort |
0.007147 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8234' order by sort |
0.000488 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001803 - desc `tadnews_data_center` `sort` |
0.000584 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8098' order by `sort` , `data_sort` |
0.007870 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8098' order by sort |
0.000266 - select * from tad_news where nsn='8098' |
0.000377 - select groupid,name from groups |
0.007170 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8098' order by sort |
0.006521 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8098' order by sort |
0.000429 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001418 - desc `tadnews_data_center` `sort` |
0.000239 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7814' order by `sort` , `data_sort` |
0.006994 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7814' order by sort |
0.000647 - select * from tad_news where nsn='7814' |
0.000088 - select groupid,name from groups |
0.006736 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7814' order by sort |
0.006682 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7814' order by sort |
0.000184 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000378 - desc `tadnews_data_center` `sort` |
0.000860 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7813' order by `sort` , `data_sort` |
0.007034 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7813' order by sort |
0.001419 - select * from tad_news where nsn='7813' |
0.000273 - select groupid,name from groups |
0.006648 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7813' order by sort |
0.006440 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7813' order by sort |
0.000405 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001239 - desc `tadnews_data_center` `sort` |
0.000487 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7709' order by `sort` , `data_sort` |
0.007042 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7709' order by sort |
0.000350 - select * from tad_news where nsn='7709' |
0.000213 - select groupid,name from groups |
0.007719 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7709' order by sort |
0.007040 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7709' order by sort |
0.000932 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001820 - desc `tadnews_data_center` `sort` |
0.000536 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7615' order by `sort` , `data_sort` |
0.008237 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7615' order by sort |
0.000433 - select * from tad_news where nsn='7615' |
0.000356 - select groupid,name from groups |
0.006510 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7615' order by sort |
0.007696 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7615' order by sort |
0.000193 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.001175 - desc `tadnews_data_center` `sort` |
0.000443 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7614' order by `sort` , `data_sort` |
0.008863 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7614' order by sort |
0.001092 - select * from tad_news where nsn='7614' |
0.000487 - select groupid,name from groups |
0.008822 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7614' order by sort |
0.008258 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7614' order by sort |
0.001078 - select font_color,color,tag from tad_news_tags where `tag_sn`='13' and enable='1' |
0.000682 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.002226 - 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 |