資料庫語法 |
---|
0.000049 - SET SQL_BIG_SELECTS = 1 |
0.001081 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001043 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'rjgdoh7vpn4k8osnfkqdosd9j5' |
0.000624 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001699 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000807 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000282 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000564 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000105 - select mid from modules where dirname='tadnews' |
0.000546 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000265 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001140 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002421 - 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.000880 - 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.000493 - 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.000398 - 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.285844 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 12:05:06' and always_top_date!='0000-00-00 00:00:00' |
0.000586 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.454217 - select * from tad_news where 1 and enable='1' and uid='200' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 12:05:05' and (end_day > '2025-09-30 12:05:05' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.496758 - select * from tad_news where 1 and enable='1' and uid='200' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 12:05:05' and (end_day > '2025-09-30 12:05:05' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 340, 20 |
0.000763 - desc `tadnews_data_center` `sort` |
0.005310 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5708' order by `sort` , `data_sort` |
0.026667 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5708' order by sort |
0.006068 - SELECT * FROM users WHERE uid = '200' |
0.002168 - select * from tad_news where nsn='5708' |
0.000190 - select groupid,name from groups |
0.032436 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5708' order by sort |
0.014421 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5708' order by sort |
0.006771 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.007047 - SELECT * FROM smiles |
0.000761 - desc `tadnews_data_center` `sort` |
0.001431 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5707' order by `sort` , `data_sort` |
0.027736 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5707' order by sort |
0.000245 - select * from tad_news where nsn='5707' |
0.000329 - select groupid,name from groups |
0.015125 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5707' order by sort |
0.012466 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5707' order by sort |
0.003009 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000525 - desc `tadnews_data_center` `sort` |
0.001820 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5706' order by `sort` , `data_sort` |
0.005807 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5706' order by sort |
0.017257 - select * from tad_news where nsn='5706' |
0.000089 - select groupid,name from groups |
0.021690 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5706' order by sort |
0.020109 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5706' order by sort |
0.004853 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001007 - desc `tadnews_data_center` `sort` |
0.000550 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5695' order by `sort` , `data_sort` |
0.028270 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5695' order by sort |
0.004175 - select * from tad_news where nsn='5695' |
0.000150 - select groupid,name from groups |
0.018506 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5695' order by sort |
0.025273 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5695' order by sort |
0.009636 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002019 - desc `tadnews_data_center` `sort` |
0.000414 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5694' order by `sort` , `data_sort` |
0.029394 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5694' order by sort |
0.001366 - select * from tad_news where nsn='5694' |
0.001491 - select groupid,name from groups |
0.016127 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5694' order by sort |
0.016943 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5694' order by sort |
0.020544 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001574 - desc `tadnews_data_center` `sort` |
0.000204 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5693' order by `sort` , `data_sort` |
0.031177 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5693' order by sort |
0.000218 - select * from tad_news where nsn='5693' |
0.000272 - select groupid,name from groups |
0.005158 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5693' order by sort |
0.041341 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5693' order by sort |
0.017098 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003486 - desc `tadnews_data_center` `sort` |
0.002232 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5692' order by `sort` , `data_sort` |
0.006652 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5692' order by sort |
0.138383 - select * from tad_news where nsn='5692' |
0.002111 - select groupid,name from groups |
0.041200 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5692' order by sort |
0.038263 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5692' order by sort |
0.017033 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001843 - desc `tadnews_data_center` `sort` |
0.001352 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5687' order by `sort` , `data_sort` |
0.038321 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5687' order by sort |
0.006137 - select * from tad_news where nsn='5687' |
0.008868 - select groupid,name from groups |
0.031204 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5687' order by sort |
0.028519 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5687' order by sort |
0.007176 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001038 - desc `tadnews_data_center` `sort` |
0.006490 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5686' order by `sort` , `data_sort` |
0.024455 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5686' order by sort |
0.010177 - select * from tad_news where nsn='5686' |
0.000096 - select groupid,name from groups |
0.007966 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5686' order by sort |
0.030645 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5686' order by sort |
0.001723 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001236 - desc `tadnews_data_center` `sort` |
0.004805 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5685' order by `sort` , `data_sort` |
0.013025 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5685' order by sort |
0.007901 - select * from tad_news where nsn='5685' |
0.000680 - select groupid,name from groups |
0.005146 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5685' order by sort |
0.057641 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5685' order by sort |
0.003991 - desc `tadnews_data_center` `sort` |
0.002531 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5684' order by `sort` , `data_sort` |
0.027705 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5684' order by sort |
0.002801 - select * from tad_news where nsn='5684' |
0.003111 - select groupid,name from groups |
0.039475 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5684' order by sort |
0.013433 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5684' order by sort |
0.003506 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001641 - desc `tadnews_data_center` `sort` |
0.006501 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5683' order by `sort` , `data_sort` |
0.017465 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5683' order by sort |
0.013894 - select * from tad_news where nsn='5683' |
0.001160 - select groupid,name from groups |
0.026278 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5683' order by sort |
0.034804 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5683' order by sort |
0.005104 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.006461 - desc `tadnews_data_center` `sort` |
0.000836 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5676' order by `sort` , `data_sort` |
0.026372 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5676' order by sort |
0.011454 - select * from tad_news where nsn='5676' |
0.001234 - select groupid,name from groups |
0.040005 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5676' order by sort |
0.023147 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5676' order by sort |
0.006327 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001595 - desc `tadnews_data_center` `sort` |
0.004984 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5675' order by `sort` , `data_sort` |
0.044632 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5675' order by sort |
0.005589 - select * from tad_news where nsn='5675' |
0.002866 - select groupid,name from groups |
0.016206 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5675' order by sort |
0.026551 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5675' order by sort |
0.001200 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000603 - desc `tadnews_data_center` `sort` |
0.006855 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5674' order by `sort` , `data_sort` |
0.007661 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5674' order by sort |
0.010819 - select * from tad_news where nsn='5674' |
0.000154 - select groupid,name from groups |
0.023557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5674' order by sort |
0.009394 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5674' order by sort |
0.005404 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000662 - desc `tadnews_data_center` `sort` |
0.004334 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5673' order by `sort` , `data_sort` |
0.019843 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5673' order by sort |
0.000983 - select * from tad_news where nsn='5673' |
0.000246 - select groupid,name from groups |
0.011181 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5673' order by sort |
0.012196 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5673' order by sort |
0.011245 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001709 - desc `tadnews_data_center` `sort` |
0.001310 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5671' order by `sort` , `data_sort` |
0.018180 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5671' order by sort |
0.002001 - select * from tad_news where nsn='5671' |
0.000152 - select groupid,name from groups |
0.018004 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5671' order by sort |
0.007268 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5671' order by sort |
0.007084 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001470 - desc `tadnews_data_center` `sort` |
0.002282 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5666' order by `sort` , `data_sort` |
0.027876 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5666' order by sort |
0.003820 - select * from tad_news where nsn='5666' |
0.000362 - select groupid,name from groups |
0.011682 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5666' order by sort |
0.010250 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5666' order by sort |
0.006234 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000785 - desc `tadnews_data_center` `sort` |
0.001187 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5645' order by `sort` , `data_sort` |
0.006361 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5645' order by sort |
0.008740 - select * from tad_news where nsn='5645' |
0.001127 - select groupid,name from groups |
0.006901 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5645' order by sort |
0.016358 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5645' order by sort |
0.014910 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001815 - desc `tadnews_data_center` `sort` |
0.000549 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5644' order by `sort` , `data_sort` |
0.007854 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5644' order by sort |
0.004796 - select * from tad_news where nsn='5644' |
0.002357 - select groupid,name from groups |
0.007402 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5644' order by sort |
0.006186 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5644' order by sort |
0.000271 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000278 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000816 - 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 |