資料庫語法 |
---|
0.000058 - SET SQL_BIG_SELECTS = 1 |
0.000747 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000207 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'bfp7phut410srq080i8s7bss2g' |
0.000548 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000508 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000270 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000316 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000595 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000180 - select mid from modules where dirname='tadnews' |
0.000176 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000198 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001070 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002358 - 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.000680 - 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.000465 - 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.000443 - 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.317236 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 01:58:47' and always_top_date!='0000-00-00 00:00:00' |
0.000492 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.412789 - select * from tad_news where 1 and enable='1' and prefix_tag = '6' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 01:58:45' and (end_day > '2025-10-01 01:58:45' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.440451 - select * from tad_news where 1 and enable='1' and prefix_tag = '6' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 01:58:45' and (end_day > '2025-10-01 01:58:45' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 60, 20 |
0.005843 - desc `tadnews_data_center` `sort` |
0.005538 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9016' order by `sort` , `data_sort` |
0.010661 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9016' order by sort |
0.017207 - select * from tad_news where nsn='9016' |
0.000703 - SELECT * FROM users WHERE uid = '180' |
0.001684 - select groupid,name from groups |
0.026032 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9016' order by sort |
0.007572 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9016' order by sort |
0.017826 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001718 - SELECT * FROM smiles |
0.002811 - desc `tadnews_data_center` `sort` |
0.001520 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='9006' order by `sort` , `data_sort` |
0.021655 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='9006' order by sort |
0.011939 - select * from tad_news where nsn='9006' |
0.000112 - select groupid,name from groups |
0.005399 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9006' order by sort |
0.053523 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='9006' order by sort |
0.000426 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.007614 - desc `tadnews_data_center` `sort` |
0.001192 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8982' order by `sort` , `data_sort` |
0.007053 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8982' order by sort |
0.105754 - select * from tad_news where nsn='8982' |
0.003059 - select groupid,name from groups |
0.037868 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8982' order by sort |
0.040849 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8982' order by sort |
0.000788 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.007393 - desc `tadnews_data_center` `sort` |
0.002088 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8964' order by `sort` , `data_sort` |
0.029610 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8964' order by sort |
0.000567 - select * from tad_news where nsn='8964' |
0.004652 - select groupid,name from groups |
0.016951 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8964' order by sort |
0.034814 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8964' order by sort |
0.020823 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.004378 - desc `tadnews_data_center` `sort` |
0.001845 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8871' order by `sort` , `data_sort` |
0.029341 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8871' order by sort |
0.002200 - SELECT * FROM users WHERE uid = '195' |
0.000294 - select * from tad_news where nsn='8871' |
0.000165 - select groupid,name from groups |
0.033700 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8871' order by sort |
0.019750 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8871' order by sort |
0.000152 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001054 - desc `tadnews_data_center` `sort` |
0.002211 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8863' order by `sort` , `data_sort` |
0.012857 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8863' order by sort |
0.004876 - SELECT * FROM users WHERE uid = '278' |
0.001659 - select * from tad_news where nsn='8863' |
0.000708 - select groupid,name from groups |
0.012417 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8863' order by sort |
0.018037 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8863' order by sort |
0.009137 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.007757 - desc `tadnews_data_center` `sort` |
0.003909 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8781' order by `sort` , `data_sort` |
0.018432 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8781' order by sort |
0.004038 - select * from tad_news where nsn='8781' |
0.000655 - select groupid,name from groups |
0.020156 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8781' order by sort |
0.008562 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8781' order by sort |
0.008196 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002587 - desc `tadnews_data_center` `sort` |
0.001944 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8733' order by `sort` , `data_sort` |
0.007363 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8733' order by sort |
0.009143 - select * from tad_news where nsn='8733' |
0.000569 - SELECT * FROM users WHERE uid = '182' |
0.007494 - select groupid,name from groups |
0.005804 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8733' order by sort |
0.011537 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8733' order by sort |
0.005259 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000887 - desc `tadnews_data_center` `sort` |
0.000177 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8729' order by `sort` , `data_sort` |
0.006360 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8729' order by sort |
0.013620 - SELECT * FROM users WHERE uid = '37' |
0.001279 - select * from tad_news where nsn='8729' |
0.002845 - select groupid,name from groups |
0.014651 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8729' order by sort |
0.009807 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8729' order by sort |
0.000189 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002036 - desc `tadnews_data_center` `sort` |
0.000465 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8620' order by `sort` , `data_sort` |
0.008013 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8620' order by sort |
0.000421 - select * from tad_news where nsn='8620' |
0.000469 - SELECT * FROM users WHERE uid = '230' |
0.000285 - select groupid,name from groups |
0.004979 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8620' order by sort |
0.006497 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8620' order by sort |
0.000624 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000499 - desc `tadnews_data_center` `sort` |
0.000369 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8701' order by `sort` , `data_sort` |
0.006976 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8701' order by sort |
0.000746 - select * from tad_news where nsn='8701' |
0.000279 - select groupid,name from groups |
0.007340 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8701' order by sort |
0.004719 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8701' order by sort |
0.000544 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001384 - desc `tadnews_data_center` `sort` |
0.000566 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8641' order by `sort` , `data_sort` |
0.005720 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8641' order by sort |
0.000523 - select * from tad_news where nsn='8641' |
0.000125 - select groupid,name from groups |
0.005873 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8641' order by sort |
0.005363 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8641' order by sort |
0.006067 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001694 - desc `tadnews_data_center` `sort` |
0.000551 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8629' order by `sort` , `data_sort` |
0.014259 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8629' order by sort |
0.016168 - select * from tad_news where nsn='8629' |
0.000251 - select groupid,name from groups |
0.004642 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8629' order by sort |
0.014396 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8629' order by sort |
0.009236 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000805 - desc `tadnews_data_center` `sort` |
0.000231 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8609' order by `sort` , `data_sort` |
0.005408 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8609' order by sort |
0.008938 - select * from tad_news where nsn='8609' |
0.000157 - select groupid,name from groups |
0.015741 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8609' order by sort |
0.006513 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8609' order by sort |
0.005448 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001561 - desc `tadnews_data_center` `sort` |
0.008284 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8592' order by `sort` , `data_sort` |
0.029033 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8592' order by sort |
0.010651 - select * from tad_news where nsn='8592' |
0.000302 - select groupid,name from groups |
0.034769 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8592' order by sort |
0.014835 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8592' order by sort |
0.000795 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000836 - desc `tadnews_data_center` `sort` |
0.000394 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8576' order by `sort` , `data_sort` |
0.014778 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8576' order by sort |
0.002256 - select * from tad_news where nsn='8576' |
0.000361 - select groupid,name from groups |
0.012267 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8576' order by sort |
0.015111 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8576' order by sort |
0.000915 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001383 - desc `tadnews_data_center` `sort` |
0.005090 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8537' order by `sort` , `data_sort` |
0.006969 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8537' order by sort |
0.007393 - select * from tad_news where nsn='8537' |
0.000676 - SELECT * FROM users WHERE uid = '249' |
0.000478 - select groupid,name from groups |
0.007514 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8537' order by sort |
0.012856 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8537' order by sort |
0.001624 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.006198 - desc `tadnews_data_center` `sort` |
0.000629 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8536' order by `sort` , `data_sort` |
0.007206 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8536' order by sort |
0.005697 - select * from tad_news where nsn='8536' |
0.000597 - select groupid,name from groups |
0.005612 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8536' order by sort |
0.012191 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8536' order by sort |
0.001027 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.008358 - desc `tadnews_data_center` `sort` |
0.000171 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8499' order by `sort` , `data_sort` |
0.011244 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8499' order by sort |
0.000249 - select * from tad_news where nsn='8499' |
0.000318 - select groupid,name from groups |
0.005308 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8499' order by sort |
0.016214 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8499' order by sort |
0.001765 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002088 - desc `tadnews_data_center` `sort` |
0.006875 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='8498' order by `sort` , `data_sort` |
0.006864 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='8498' order by sort |
0.002185 - select * from tad_news where nsn='8498' |
0.006024 - select groupid,name from groups |
0.006242 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8498' order by sort |
0.011781 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='8498' order by sort |
0.000770 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000238 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.009840 - 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 |