資料庫語法 |
---|
0.000042 - SET SQL_BIG_SELECTS = 1 |
0.001562 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000726 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '54t4s9j8rhsb4je3fejr5r7dal' |
0.000265 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000831 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000773 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000458 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000379 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000291 - select mid from modules where dirname='tadnews' |
0.000523 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000171 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001216 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.004211 - 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.001221 - 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.001153 - 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.000602 - 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.184204 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 03:49:51' and always_top_date!='0000-00-00 00:00:00' |
0.001263 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.265038 - 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 03:49:50' and (end_day > '2025-10-01 03:49:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.097322 - 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 03:49:50' and (end_day > '2025-10-01 03:49:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 180, 20 |
0.000873 - desc `tadnews_data_center` `sort` |
0.001065 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3978' order by `sort` , `data_sort` |
0.008197 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3978' order by sort |
0.000133 - select * from tad_news where nsn='3978' |
0.000501 - SELECT * FROM users WHERE uid = '180' |
0.000130 - select groupid,name from groups |
0.007921 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3978' order by sort |
0.006292 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3978' order by sort |
0.000260 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000095 - SELECT * FROM smiles |
0.000372 - desc `tadnews_data_center` `sort` |
0.000410 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3965' order by `sort` , `data_sort` |
0.006862 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3965' order by sort |
0.000180 - SELECT * FROM users WHERE uid = '1' |
0.000157 - select * from tad_news where nsn='3965' |
0.000299 - select groupid,name from groups |
0.005586 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3965' order by sort |
0.005724 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3965' order by sort |
0.000143 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000578 - desc `tadnews_data_center` `sort` |
0.000384 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3963' order by `sort` , `data_sort` |
0.005708 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3963' order by sort |
0.000447 - SELECT * FROM users WHERE uid = '37' |
0.000208 - select * from tad_news where nsn='3963' |
0.000264 - select groupid,name from groups |
0.005243 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3963' order by sort |
0.005148 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3963' order by sort |
0.000346 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002190 - desc `tadnews_data_center` `sort` |
0.000286 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3942' order by `sort` , `data_sort` |
0.005615 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3942' order by sort |
0.000416 - select * from tad_news where nsn='3942' |
0.000256 - select groupid,name from groups |
0.005089 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3942' order by sort |
0.005243 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3942' order by sort |
0.000366 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001067 - desc `tadnews_data_center` `sort` |
0.000246 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3931' order by `sort` , `data_sort` |
0.005706 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3931' order by sort |
0.000545 - select * from tad_news where nsn='3931' |
0.000237 - SELECT * FROM users WHERE uid = '178' |
0.000393 - select groupid,name from groups |
0.005071 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3931' order by sort |
0.005419 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3931' order by sort |
0.000337 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002046 - desc `tadnews_data_center` `sort` |
0.000336 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3908' order by `sort` , `data_sort` |
0.005839 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3908' order by sort |
0.000492 - select * from tad_news where nsn='3908' |
0.000131 - select groupid,name from groups |
0.005180 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3908' order by sort |
0.004977 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3908' order by sort |
0.000148 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001656 - desc `tadnews_data_center` `sort` |
0.000508 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3907' order by `sort` , `data_sort` |
0.006094 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3907' order by sort |
0.000521 - select * from tad_news where nsn='3907' |
0.000256 - select groupid,name from groups |
0.005541 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3907' order by sort |
0.004851 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3907' order by sort |
0.000127 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001423 - desc `tadnews_data_center` `sort` |
0.000449 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3906' order by `sort` , `data_sort` |
0.005426 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3906' order by sort |
0.000306 - select * from tad_news where nsn='3906' |
0.000286 - select groupid,name from groups |
0.004872 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3906' order by sort |
0.004166 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3906' order by sort |
0.000106 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000587 - desc `tadnews_data_center` `sort` |
0.000166 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3892' order by `sort` , `data_sort` |
0.004195 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3892' order by sort |
0.000291 - select * from tad_news where nsn='3892' |
0.000121 - SELECT * FROM users WHERE uid = '184' |
0.000322 - select groupid,name from groups |
0.004288 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3892' order by sort |
0.004421 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3892' order by sort |
0.000243 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000637 - desc `tadnews_data_center` `sort` |
0.000323 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3865' order by `sort` , `data_sort` |
0.005148 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3865' order by sort |
0.000368 - select * from tad_news where nsn='3865' |
0.000098 - select groupid,name from groups |
0.004626 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3865' order by sort |
0.004311 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3865' order by sort |
0.000220 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001279 - desc `tadnews_data_center` `sort` |
0.000642 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3864' order by `sort` , `data_sort` |
0.005359 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3864' order by sort |
0.000185 - select * from tad_news where nsn='3864' |
0.000210 - select groupid,name from groups |
0.004635 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3864' order by sort |
0.004532 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3864' order by sort |
0.000098 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001381 - desc `tadnews_data_center` `sort` |
0.000746 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3860' order by `sort` , `data_sort` |
0.005434 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3860' order by sort |
0.000331 - select * from tad_news where nsn='3860' |
0.000301 - select groupid,name from groups |
0.005567 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3860' order by sort |
0.004721 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3860' order by sort |
0.000334 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001453 - desc `tadnews_data_center` `sort` |
0.002979 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3857' order by `sort` , `data_sort` |
0.032367 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3857' order by sort |
0.003630 - select * from tad_news where nsn='3857' |
0.001401 - select groupid,name from groups |
0.012321 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3857' order by sort |
0.007973 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3857' order by sort |
0.000117 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001204 - desc `tadnews_data_center` `sort` |
0.000311 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3856' order by `sort` , `data_sort` |
0.007979 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3856' order by sort |
0.000520 - select * from tad_news where nsn='3856' |
0.000094 - select groupid,name from groups |
0.005899 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3856' order by sort |
0.005274 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3856' order by sort |
0.000462 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001609 - desc `tadnews_data_center` `sort` |
0.009257 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3855' order by `sort` , `data_sort` |
0.007285 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3855' order by sort |
0.013446 - select * from tad_news where nsn='3855' |
0.000492 - select groupid,name from groups |
0.011124 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3855' order by sort |
0.007633 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3855' order by sort |
0.000735 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000873 - desc `tadnews_data_center` `sort` |
0.000357 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3844' order by `sort` , `data_sort` |
0.008120 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3844' order by sort |
0.000791 - select * from tad_news where nsn='3844' |
0.000406 - select groupid,name from groups |
0.006287 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3844' order by sort |
0.008768 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3844' order by sort |
0.000903 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001282 - desc `tadnews_data_center` `sort` |
0.000938 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3843' order by `sort` , `data_sort` |
0.007723 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3843' order by sort |
0.001034 - select * from tad_news where nsn='3843' |
0.000356 - select groupid,name from groups |
0.007906 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3843' order by sort |
0.006086 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3843' order by sort |
0.000121 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001096 - desc `tadnews_data_center` `sort` |
0.000354 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3842' order by `sort` , `data_sort` |
0.007777 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3842' order by sort |
0.000463 - select * from tad_news where nsn='3842' |
0.000125 - select groupid,name from groups |
0.006617 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3842' order by sort |
0.006022 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3842' order by sort |
0.000155 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000610 - 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`='3757' order by `sort` , `data_sort` |
0.006861 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3757' order by sort |
0.000656 - SELECT * FROM users WHERE uid = '201' |
0.000618 - select * from tad_news where nsn='3757' |
0.000346 - select groupid,name from groups |
0.014507 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3757' order by sort |
0.008869 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3757' order by sort |
0.000975 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001733 - desc `tadnews_data_center` `sort` |
0.000592 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='3756' order by `sort` , `data_sort` |
0.007546 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='3756' order by sort |
0.000177 - select * from tad_news where nsn='3756' |
0.000322 - select groupid,name from groups |
0.006692 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3756' order by sort |
0.006222 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='3756' order by sort |
0.000116 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000470 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001285 - 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 |