資料庫語法 |
---|
0.000710 - SET SQL_BIG_SELECTS = 1 |
0.001226 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.004193 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'n4cdj4q65t88icofbp6q2072g3' |
0.000817 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000964 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.001058 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.004085 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000272 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000212 - select mid from modules where dirname='tadnews' |
0.000182 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000180 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.007347 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002201 - 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.000385 - 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.000288 - 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.000319 - 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.334795 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 21:38:44' and always_top_date!='0000-00-00 00:00:00' |
0.001523 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
1.303951 - 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-30 21:38:43' and (end_day > '2025-09-30 21:38:43' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.835779 - 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-30 21:38:43' and (end_day > '2025-09-30 21:38:43' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 8660, 20 |
0.001515 - desc `tadnews_data_center` `sort` |
0.001480 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1087' order by `sort` , `data_sort` |
0.015421 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1087' order by sort |
0.001280 - select * from tad_news where nsn='1087' |
0.001270 - SELECT * FROM users WHERE uid = '16' |
0.000108 - select groupid,name from groups |
0.012663 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1087' order by sort |
0.010477 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1087' order by sort |
0.006796 - SELECT * FROM smiles |
0.001223 - desc `tadnews_data_center` `sort` |
0.002233 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1086' order by `sort` , `data_sort` |
0.005382 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1086' order by sort |
0.008969 - SELECT * FROM users WHERE uid = '16' |
0.000919 - select * from tad_news where nsn='1086' |
0.000099 - SELECT * FROM users WHERE uid = '16' |
0.000196 - select groupid,name from groups |
0.013669 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1086' order by sort |
0.008435 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1086' order by sort |
0.011211 - desc `tadnews_data_center` `sort` |
0.002229 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1085' order by `sort` , `data_sort` |
0.010341 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1085' order by sort |
0.005351 - select * from tad_news where nsn='1085' |
0.001665 - SELECT * FROM users WHERE uid = '16' |
0.000466 - select groupid,name from groups |
0.005658 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1085' order by sort |
0.020837 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1085' order by sort |
0.006474 - desc `tadnews_data_center` `sort` |
0.004812 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1084' order by `sort` , `data_sort` |
0.019001 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1084' order by sort |
0.002530 - select * from tad_news where nsn='1084' |
0.001460 - SELECT * FROM users WHERE uid = '24' |
0.000294 - select groupid,name from groups |
0.011398 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1084' order by sort |
0.011045 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1084' order by sort |
0.009207 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004472 - desc `tadnews_data_center` `sort` |
0.001129 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1111' order by `sort` , `data_sort` |
0.017758 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1111' order by sort |
0.005676 - SELECT * FROM users WHERE uid = '9' |
0.000963 - select * from tad_news where nsn='1111' |
0.001023 - SELECT * FROM users WHERE uid = '9' |
0.000559 - select groupid,name from groups |
0.017906 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1111' order by sort |
0.013052 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1111' order by sort |
0.005996 - desc `tadnews_data_center` `sort` |
0.002173 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1083' order by `sort` , `data_sort` |
0.012760 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1083' order by sort |
0.005947 - SELECT * FROM users WHERE uid = '17' |
0.001898 - select * from tad_news where nsn='1083' |
0.012998 - SELECT * FROM users WHERE uid = '17' |
0.000577 - select groupid,name from groups |
0.020840 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1083' order by sort |
0.004701 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1083' order by sort |
0.008079 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001073 - desc `tadnews_data_center` `sort` |
0.000356 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1107' order by `sort` , `data_sort` |
0.006647 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1107' order by sort |
0.007500 - select * from tad_news where nsn='1107' |
0.000162 - SELECT * FROM users WHERE uid = '9' |
0.000129 - select groupid,name from groups |
0.005366 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1107' order by sort |
0.018830 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1107' order by sort |
0.001213 - desc `tadnews_data_center` `sort` |
0.003924 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1104' order by `sort` , `data_sort` |
0.006062 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1104' order by sort |
0.011448 - SELECT * FROM users WHERE uid = '9' |
0.000316 - select * from tad_news where nsn='1104' |
0.000313 - SELECT * FROM users WHERE uid = '9' |
0.000411 - select groupid,name from groups |
0.006343 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1104' order by sort |
0.018575 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1104' order by sort |
0.003739 - desc `tadnews_data_center` `sort` |
0.010301 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1082' order by `sort` , `data_sort` |
0.017239 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1082' order by sort |
0.014313 - select * from tad_news where nsn='1082' |
0.000446 - SELECT * FROM users WHERE uid = '24' |
0.000397 - select groupid,name from groups |
0.012098 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1082' order by sort |
0.024353 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1082' order by sort |
0.012119 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001926 - desc `tadnews_data_center` `sort` |
0.001103 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1081' order by `sort` , `data_sort` |
0.035256 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1081' order by sort |
0.000593 - select * from tad_news where nsn='1081' |
0.000490 - SELECT * FROM users WHERE uid = '24' |
0.000336 - select groupid,name from groups |
0.011853 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1081' order by sort |
0.006085 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1081' order by sort |
0.009202 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001292 - desc `tadnews_data_center` `sort` |
0.000393 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1080' order by `sort` , `data_sort` |
0.006981 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1080' order by sort |
0.008868 - select * from tad_news where nsn='1080' |
0.000403 - SELECT * FROM users WHERE uid = '24' |
0.000304 - select groupid,name from groups |
0.015505 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1080' order by sort |
0.015717 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1080' order by sort |
0.006622 - desc `tadnews_data_center` `sort` |
0.000251 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1079' order by `sort` , `data_sort` |
0.034543 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1079' order by sort |
0.000879 - select * from tad_news where nsn='1079' |
0.010958 - SELECT * FROM users WHERE uid = '15' |
0.000126 - select groupid,name from groups |
0.018645 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1079' order by sort |
0.010291 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1079' order by sort |
0.006800 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001471 - desc `tadnews_data_center` `sort` |
0.000899 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1110' order by `sort` , `data_sort` |
0.025997 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1110' order by sort |
0.009311 - select * from tad_news where nsn='1110' |
0.000581 - SELECT * FROM users WHERE uid = '9' |
0.000259 - select groupid,name from groups |
0.015666 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1110' order by sort |
0.015870 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1110' order by sort |
0.006769 - desc `tadnews_data_center` `sort` |
0.000758 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1078' order by `sort` , `data_sort` |
0.015279 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1078' order by sort |
0.000347 - select * from tad_news where nsn='1078' |
0.000431 - SELECT * FROM users WHERE uid = '9' |
0.000879 - select groupid,name from groups |
0.005252 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1078' order by sort |
0.025641 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1078' order by sort |
0.009453 - desc `tadnews_data_center` `sort` |
0.004086 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1077' order by `sort` , `data_sort` |
0.018090 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1077' order by sort |
0.001813 - SELECT * FROM users WHERE uid = '9' |
0.000860 - select * from tad_news where nsn='1077' |
0.000444 - SELECT * FROM users WHERE uid = '9' |
0.000293 - select groupid,name from groups |
0.016538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1077' order by sort |
0.006547 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1077' order by sort |
0.006837 - desc `tadnews_data_center` `sort` |
0.002460 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1076' order by `sort` , `data_sort` |
0.010071 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1076' order by sort |
0.006670 - SELECT * FROM users WHERE uid = '9' |
0.000944 - select * from tad_news where nsn='1076' |
0.000303 - SELECT * FROM users WHERE uid = '9' |
0.000356 - select groupid,name from groups |
0.007288 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1076' order by sort |
0.019775 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1076' order by sort |
0.002568 - desc `tadnews_data_center` `sort` |
0.001402 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1075' order by `sort` , `data_sort` |
0.005260 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1075' order by sort |
0.005892 - select * from tad_news where nsn='1075' |
0.000091 - SELECT * FROM users WHERE uid = '9' |
0.000079 - select groupid,name from groups |
0.005408 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1075' order by sort |
0.010755 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1075' order by sort |
0.008069 - desc `tadnews_data_center` `sort` |
0.000757 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1074' order by `sort` , `data_sort` |
0.016658 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1074' order by sort |
0.000218 - select * from tad_news where nsn='1074' |
0.000147 - SELECT * FROM users WHERE uid = '9' |
0.000410 - select groupid,name from groups |
0.007438 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1074' order by sort |
0.010069 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1074' order by sort |
0.004438 - desc `tadnews_data_center` `sort` |
0.000180 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1073' order by `sort` , `data_sort` |
0.004657 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1073' order by sort |
0.006666 - select * from tad_news where nsn='1073' |
0.000246 - SELECT * FROM users WHERE uid = '17' |
0.003915 - select groupid,name from groups |
0.012524 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1073' order by sort |
0.008758 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1073' order by sort |
0.000231 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001276 - desc `tadnews_data_center` `sort` |
0.000494 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='1072' order by `sort` , `data_sort` |
0.007403 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='1072' order by sort |
0.000468 - SELECT * FROM users WHERE uid = '16' |
0.000128 - select * from tad_news where nsn='1072' |
0.000191 - SELECT * FROM users WHERE uid = '16' |
0.000252 - select groupid,name from groups |
0.005219 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1072' order by sort |
0.007191 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='1072' order by sort |
0.000484 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000197 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001529 - 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 |