資料庫語法 |
---|
0.000134 - SET SQL_BIG_SELECTS = 1 |
0.002817 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.015379 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '72q01uu1n4vhj8oqif78g3fjbu' |
0.004042 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.002930 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.001610 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000686 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.001421 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.002770 - select mid from modules where dirname='tadnews' |
0.000587 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000400 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001989 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.005097 - 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.001536 - 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.000546 - 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.000411 - 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.420362 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 06:06:51' and always_top_date!='0000-00-00 00:00:00' |
0.000486 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.547397 - select * from tad_news where 1 and enable='1' and prefix_tag = '8' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 06:06:50' and (end_day > '2025-10-01 06:06:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.273531 - select * from tad_news where 1 and enable='1' and prefix_tag = '8' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-10-01 06:06:50' and (end_day > '2025-10-01 06:06:50' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 120, 20 |
0.002410 - desc `tadnews_data_center` `sort` |
0.005018 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10168' order by `sort` , `data_sort` |
0.006799 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10168' order by sort |
0.011787 - SELECT * FROM users WHERE uid = '249' |
0.000587 - select * from tad_news where nsn='10168' |
0.000356 - select groupid,name from groups |
0.020262 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10168' order by sort |
0.009104 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10168' order by sort |
0.017945 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003269 - SELECT * FROM smiles |
0.002710 - desc `tadnews_data_center` `sort` |
0.000355 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10165' order by `sort` , `data_sort` |
0.013934 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10165' order by sort |
0.003140 - select * from tad_news where nsn='10165' |
0.000736 - select groupid,name from groups |
0.012658 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10165' order by sort |
0.007122 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10165' order by sort |
0.012979 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001022 - desc `tadnews_data_center` `sort` |
0.001021 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10164' order by `sort` , `data_sort` |
0.006280 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10164' order by sort |
0.015173 - select * from tad_news where nsn='10164' |
0.000249 - select groupid,name from groups |
0.006728 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10164' order by sort |
0.026716 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10164' order by sort |
0.009301 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001862 - desc `tadnews_data_center` `sort` |
0.001524 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10145' order by `sort` , `data_sort` |
0.015486 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10145' order by sort |
0.007944 - select * from tad_news where nsn='10145' |
0.004944 - SELECT * FROM users WHERE uid = '228' |
0.000743 - select groupid,name from groups |
0.017333 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10145' order by sort |
0.007879 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10145' order by sort |
0.004414 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.004731 - desc `tadnews_data_center` `sort` |
0.001404 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10144' order by `sort` , `data_sort` |
0.030402 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10144' order by sort |
0.000838 - select * from tad_news where nsn='10144' |
0.000368 - select groupid,name from groups |
0.023645 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10144' order by sort |
0.017796 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10144' order by sort |
0.004943 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001426 - desc `tadnews_data_center` `sort` |
0.002669 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10139' order by `sort` , `data_sort` |
0.007273 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10139' order by sort |
0.008726 - select * from tad_news where nsn='10139' |
0.005578 - select groupid,name from groups |
0.009036 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10139' order by sort |
0.015248 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10139' order by sort |
0.012099 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.007386 - desc `tadnews_data_center` `sort` |
0.002913 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10138' order by `sort` , `data_sort` |
0.017777 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10138' order by sort |
0.001637 - select * from tad_news where nsn='10138' |
0.005313 - SELECT * FROM users WHERE uid = '169' |
0.004454 - select groupid,name from groups |
0.004045 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10138' order by sort |
0.010066 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10138' order by sort |
0.011243 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001061 - desc `tadnews_data_center` `sort` |
0.006183 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10135' order by `sort` , `data_sort` |
0.013495 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10135' order by sort |
0.014769 - select * from tad_news where nsn='10135' |
0.000097 - select groupid,name from groups |
0.006311 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10135' order by sort |
0.027028 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10135' order by sort |
0.001438 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.014470 - desc `tadnews_data_center` `sort` |
0.013766 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10134' order by `sort` , `data_sort` |
0.024667 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10134' order by sort |
0.008355 - select * from tad_news where nsn='10134' |
0.000471 - select groupid,name from groups |
0.006587 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10134' order by sort |
0.034047 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10134' order by sort |
0.004737 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002263 - desc `tadnews_data_center` `sort` |
0.010640 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10132' order by `sort` , `data_sort` |
0.027091 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10132' order by sort |
0.007911 - select * from tad_news where nsn='10132' |
0.000318 - select groupid,name from groups |
0.019086 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10132' order by sort |
0.029820 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10132' order by sort |
0.000449 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.005606 - desc `tadnews_data_center` `sort` |
0.001199 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10130' order by `sort` , `data_sort` |
0.009727 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10130' order by sort |
0.005645 - select * from tad_news where nsn='10130' |
0.000540 - select groupid,name from groups |
0.006307 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10130' order by sort |
0.015015 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10130' order by sort |
0.007572 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001813 - desc `tadnews_data_center` `sort` |
0.000542 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10127' order by `sort` , `data_sort` |
0.017298 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10127' order by sort |
0.004539 - select * from tad_news where nsn='10127' |
0.000951 - select groupid,name from groups |
0.005869 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10127' order by sort |
0.044574 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10127' order by sort |
0.000144 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001101 - desc `tadnews_data_center` `sort` |
0.009939 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10119' order by `sort` , `data_sort` |
0.014095 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10119' order by sort |
0.021585 - select * from tad_news where nsn='10119' |
0.000086 - select groupid,name from groups |
0.012432 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10119' order by sort |
0.013401 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10119' order by sort |
0.009890 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.004478 - desc `tadnews_data_center` `sort` |
0.000234 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10089' order by `sort` , `data_sort` |
0.033556 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10089' order by sort |
0.005130 - select * from tad_news where nsn='10089' |
0.000258 - select groupid,name from groups |
0.011195 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10089' order by sort |
0.011241 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10089' order by sort |
0.004652 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000620 - desc `tadnews_data_center` `sort` |
0.000284 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10077' order by `sort` , `data_sort` |
0.005724 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10077' order by sort |
0.000446 - select * from tad_news where nsn='10077' |
0.006151 - select groupid,name from groups |
0.005589 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10077' order by sort |
0.026200 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10077' order by sort |
0.000887 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000623 - desc `tadnews_data_center` `sort` |
0.007299 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10065' order by `sort` , `data_sort` |
0.021032 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10065' order by sort |
0.000875 - select * from tad_news where nsn='10065' |
0.000328 - select groupid,name from groups |
0.022290 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10065' order by sort |
0.005210 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10065' order by sort |
0.003386 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000700 - desc `tadnews_data_center` `sort` |
0.000681 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10064' order by `sort` , `data_sort` |
0.010203 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10064' order by sort |
0.000366 - select * from tad_news where nsn='10064' |
0.004588 - select groupid,name from groups |
0.004558 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10064' order by sort |
0.009510 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10064' order by sort |
0.000284 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.006399 - desc `tadnews_data_center` `sort` |
0.000670 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10063' order by `sort` , `data_sort` |
0.005035 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10063' order by sort |
0.000920 - select * from tad_news where nsn='10063' |
0.000094 - select groupid,name from groups |
0.018635 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10063' order by sort |
0.009305 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10063' order by sort |
0.002182 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003062 - desc `tadnews_data_center` `sort` |
0.000504 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10062' order by `sort` , `data_sort` |
0.019509 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10062' order by sort |
0.010425 - select * from tad_news where nsn='10062' |
0.000121 - select groupid,name from groups |
0.004803 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10062' order by sort |
0.010220 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10062' order by sort |
0.001889 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.005472 - desc `tadnews_data_center` `sort` |
0.000391 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10061' order by `sort` , `data_sort` |
0.006620 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10061' order by sort |
0.003464 - select * from tad_news where nsn='10061' |
0.000480 - select groupid,name from groups |
0.011012 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10061' order by sort |
0.014046 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10061' order by sort |
0.001383 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.009474 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001538 - 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 |