資料庫語法 |
---|
0.000212 - SET SQL_BIG_SELECTS = 1 |
0.003060 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001267 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'fm200794mb1mjb0ktmfbd8l6q9' |
0.000455 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001700 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000836 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000386 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000279 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000188 - select mid from modules where dirname='tadnews' |
0.000470 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000375 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.002019 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003583 - 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.001053 - 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.000330 - 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.000368 - 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.195811 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 00:25:26' and always_top_date!='0000-00-00 00:00:00' |
0.001867 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.191685 - 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-09-30 00:25:25' and (end_day > '2025-09-30 00:25:25' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.074461 - 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-09-30 00:25:25' and (end_day > '2025-09-30 00:25:25' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 80, 20 |
0.002188 - desc `tadnews_data_center` `sort` |
0.000376 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10477' order by `sort` , `data_sort` |
0.011534 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10477' order by sort |
0.001405 - select * from tad_news where nsn='10477' |
0.000442 - SELECT * FROM users WHERE uid = '169' |
0.000143 - select groupid,name from groups |
0.008764 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10477' order by sort |
0.008621 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10477' order by sort |
0.000786 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000604 - SELECT * FROM smiles |
0.001426 - desc `tadnews_data_center` `sort` |
0.000721 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10456' order by `sort` , `data_sort` |
0.011666 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10456' order by sort |
0.001342 - SELECT * FROM users WHERE uid = '249' |
0.000885 - select * from tad_news where nsn='10456' |
0.000305 - select groupid,name from groups |
0.013168 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10456' order by sort |
0.006619 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10456' order by sort |
0.000149 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001162 - desc `tadnews_data_center` `sort` |
0.000176 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10455' order by `sort` , `data_sort` |
0.009402 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10455' order by sort |
0.000431 - select * from tad_news where nsn='10455' |
0.000412 - select groupid,name from groups |
0.007383 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10455' order by sort |
0.007520 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10455' order by sort |
0.000175 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001551 - desc `tadnews_data_center` `sort` |
0.000644 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10453' order by `sort` , `data_sort` |
0.007763 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10453' order by sort |
0.000641 - select * from tad_news where nsn='10453' |
0.000368 - select groupid,name from groups |
0.010459 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10453' order by sort |
0.007440 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10453' order by sort |
0.000292 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002083 - desc `tadnews_data_center` `sort` |
0.000659 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10451' order by `sort` , `data_sort` |
0.008445 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10451' order by sort |
0.000575 - select * from tad_news where nsn='10451' |
0.000520 - select groupid,name from groups |
0.007576 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10451' order by sort |
0.005802 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10451' order by sort |
0.000160 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000370 - desc `tadnews_data_center` `sort` |
0.000236 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10447' order by `sort` , `data_sort` |
0.004244 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10447' order by sort |
0.000226 - select * from tad_news where nsn='10447' |
0.000090 - select groupid,name from groups |
0.003740 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10447' order by sort |
0.003687 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10447' order by sort |
0.000158 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000355 - 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`='10446' order by `sort` , `data_sort` |
0.004324 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10446' order by sort |
0.000214 - select * from tad_news where nsn='10446' |
0.000093 - select groupid,name from groups |
0.004874 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10446' order by sort |
0.003996 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10446' order by sort |
0.000135 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001081 - desc `tadnews_data_center` `sort` |
0.000243 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10445' order by `sort` , `data_sort` |
0.005887 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10445' order by sort |
0.000376 - select * from tad_news where nsn='10445' |
0.000223 - select groupid,name from groups |
0.005634 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10445' order by sort |
0.005900 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10445' order by sort |
0.000165 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001695 - desc `tadnews_data_center` `sort` |
0.001022 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10401' order by `sort` , `data_sort` |
0.007953 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10401' order by sort |
0.000827 - select * from tad_news where nsn='10401' |
0.000543 - select groupid,name from groups |
0.007112 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10401' order by sort |
0.006550 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10401' order by sort |
0.000231 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001555 - 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`='10380' order by `sort` , `data_sort` |
0.007793 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10380' order by sort |
0.000589 - select * from tad_news where nsn='10380' |
0.000405 - select groupid,name from groups |
0.007159 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.007686 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.000970 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000834 - 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`='10370' order by `sort` , `data_sort` |
0.008820 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10370' order by sort |
0.001110 - select * from tad_news where nsn='10370' |
0.000464 - select groupid,name from groups |
0.008546 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10370' order by sort |
0.007583 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10370' order by sort |
0.000693 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001506 - desc `tadnews_data_center` `sort` |
0.000848 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10369' order by `sort` , `data_sort` |
0.008296 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10369' order by sort |
0.000473 - select * from tad_news where nsn='10369' |
0.000194 - select groupid,name from groups |
0.007772 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10369' order by sort |
0.007430 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10369' order by sort |
0.000844 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002330 - desc `tadnews_data_center` `sort` |
0.000909 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10368' order by `sort` , `data_sort` |
0.009418 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10368' order by sort |
0.000905 - select * from tad_news where nsn='10368' |
0.000429 - select groupid,name from groups |
0.007813 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10368' order by sort |
0.007315 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10368' order by sort |
0.003573 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001068 - desc `tadnews_data_center` `sort` |
0.001525 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10350' order by `sort` , `data_sort` |
0.011779 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10350' order by sort |
0.000569 - select * from tad_news where nsn='10350' |
0.000443 - select groupid,name from groups |
0.009032 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10350' order by sort |
0.007616 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10350' order by sort |
0.001038 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001512 - desc `tadnews_data_center` `sort` |
0.000981 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10336' order by `sort` , `data_sort` |
0.007459 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10336' order by sort |
0.000520 - select * from tad_news where nsn='10336' |
0.000437 - select groupid,name from groups |
0.006808 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10336' order by sort |
0.007761 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10336' order by sort |
0.000922 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001395 - 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`='10335' order by `sort` , `data_sort` |
0.010263 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10335' order by sort |
0.001258 - select * from tad_news where nsn='10335' |
0.000482 - select groupid,name from groups |
0.006714 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10335' order by sort |
0.008288 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10335' order by sort |
0.000633 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001333 - desc `tadnews_data_center` `sort` |
0.000869 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10334' order by `sort` , `data_sort` |
0.007180 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10334' order by sort |
0.000877 - SELECT * FROM users WHERE uid = '185' |
0.000582 - select * from tad_news where nsn='10334' |
0.000379 - select groupid,name from groups |
0.006355 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10334' order by sort |
0.007876 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10334' order by sort |
0.000520 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002206 - desc `tadnews_data_center` `sort` |
0.000727 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10332' order by `sort` , `data_sort` |
0.008253 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10332' order by sort |
0.000990 - select * from tad_news where nsn='10332' |
0.000170 - select groupid,name from groups |
0.008294 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10332' order by sort |
0.006788 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10332' order by sort |
0.000139 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000342 - desc `tadnews_data_center` `sort` |
0.000174 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10331' order by `sort` , `data_sort` |
0.004137 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10331' order by sort |
0.000479 - select * from tad_news where nsn='10331' |
0.000094 - select groupid,name from groups |
0.005175 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10331' order by sort |
0.005760 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10331' order by sort |
0.000349 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001473 - desc `tadnews_data_center` `sort` |
0.000275 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10328' order by `sort` , `data_sort` |
0.006953 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10328' order by sort |
0.000254 - select * from tad_news where nsn='10328' |
0.000100 - select groupid,name from groups |
0.005321 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10328' order by sort |
0.006037 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10328' order by sort |
0.000675 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000600 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000796 - 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 |