資料庫語法 |
---|
0.000172 - SET SQL_BIG_SELECTS = 1 |
0.001117 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.001210 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'gkicl2vq98mdoi0o67bfb9fmda' |
0.000185 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000957 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000554 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000381 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000542 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000109 - select mid from modules where dirname='tadnews' |
0.000351 - 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.001179 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003496 - 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.000570 - 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.000679 - 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.000405 - 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.178996 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 01:03:48' and always_top_date!='0000-00-00 00:00:00' |
0.000802 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.116034 - select * from tad_news where 1 and enable='1' and uid='249' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:03:47' and (end_day > '2025-09-30 01:03:47' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.094799 - select * from tad_news where 1 and enable='1' and uid='249' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:03:47' and (end_day > '2025-09-30 01:03:47' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 0, 20 |
0.000486 - desc `tadnews_data_center` `sort` |
0.000228 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10630' order by `sort` , `data_sort` |
0.005665 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10630' order by sort |
0.000562 - SELECT * FROM users WHERE uid = '249' |
0.000168 - select * from tad_news where nsn='10630' |
0.000476 - select groupid,name from groups |
0.006321 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10630' order by sort |
0.006171 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10630' order by sort |
0.000134 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000089 - SELECT * FROM smiles |
0.000839 - desc `tadnews_data_center` `sort` |
0.000193 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10570' order by `sort` , `data_sort` |
0.005552 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10570' order by sort |
0.000832 - select * from tad_news where nsn='10570' |
0.000092 - select groupid,name from groups |
0.005362 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10570' order by sort |
0.006612 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10570' order by sort |
0.000139 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000557 - desc `tadnews_data_center` `sort` |
0.000663 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10569' order by `sort` , `data_sort` |
0.006004 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10569' order by sort |
0.000353 - select * from tad_news where nsn='10569' |
0.000381 - select groupid,name from groups |
0.005719 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10569' order by sort |
0.004791 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10569' order by sort |
0.000196 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001225 - 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`='10539' order by `sort` , `data_sort` |
0.005855 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10539' order by sort |
0.000316 - select * from tad_news where nsn='10539' |
0.000099 - select groupid,name from groups |
0.004978 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10539' order by sort |
0.005113 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10539' order by sort |
0.000254 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000383 - desc `tadnews_data_center` `sort` |
0.000180 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10509' order by `sort` , `data_sort` |
0.005840 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10509' order by sort |
0.000324 - select * from tad_news where nsn='10509' |
0.000396 - select groupid,name from groups |
0.005787 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10509' order by sort |
0.006990 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10509' order by sort |
0.000355 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001705 - desc `tadnews_data_center` `sort` |
0.000381 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10508' order by `sort` , `data_sort` |
0.006588 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10508' order by sort |
0.000708 - select * from tad_news where nsn='10508' |
0.000350 - select groupid,name from groups |
0.006683 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10508' order by sort |
0.005476 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10508' order by sort |
0.000130 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000367 - desc `tadnews_data_center` `sort` |
0.000179 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10495' order by `sort` , `data_sort` |
0.006203 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10495' order by sort |
0.000167 - select * from tad_news where nsn='10495' |
0.000126 - select groupid,name from groups |
0.006113 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10495' order by sort |
0.005842 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10495' order by sort |
0.000301 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000994 - desc `tadnews_data_center` `sort` |
0.000475 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10492' order by `sort` , `data_sort` |
0.006253 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10492' order by sort |
0.000904 - select * from tad_news where nsn='10492' |
0.000323 - select groupid,name from groups |
0.006288 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10492' order by sort |
0.005137 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10492' order by sort |
0.000408 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002006 - desc `tadnews_data_center` `sort` |
0.000480 - 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.006721 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10456' order by sort |
0.000815 - select * from tad_news where nsn='10456' |
0.000323 - select groupid,name from groups |
0.005884 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10456' order by sort |
0.005343 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10456' order by sort |
0.000299 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001224 - desc `tadnews_data_center` `sort` |
0.000639 - 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.006646 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10455' order by sort |
0.000815 - select * from tad_news where nsn='10455' |
0.000177 - select groupid,name from groups |
0.005550 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10455' order by sort |
0.005291 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10455' order by sort |
0.000517 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001216 - desc `tadnews_data_center` `sort` |
0.000538 - 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.006997 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10453' order by sort |
0.000515 - select * from tad_news where nsn='10453' |
0.000319 - select groupid,name from groups |
0.005816 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10453' order by sort |
0.006796 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10453' order by sort |
0.000610 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000886 - desc `tadnews_data_center` `sort` |
0.000214 - 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.007534 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10451' order by sort |
0.000208 - select * from tad_news where nsn='10451' |
0.000110 - select groupid,name from groups |
0.005875 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10451' order by sort |
0.005822 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10451' order by sort |
0.000354 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002008 - desc `tadnews_data_center` `sort` |
0.000865 - 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.006782 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10447' order by sort |
0.001179 - select * from tad_news where nsn='10447' |
0.000165 - select groupid,name from groups |
0.007106 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10447' order by sort |
0.005893 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10447' order by sort |
0.000363 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000975 - desc `tadnews_data_center` `sort` |
0.000511 - 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.006884 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10446' order by sort |
0.000327 - select * from tad_news where nsn='10446' |
0.000412 - select groupid,name from groups |
0.006019 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10446' order by sort |
0.006242 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10446' order by sort |
0.000202 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001033 - desc `tadnews_data_center` `sort` |
0.000667 - 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.006907 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10445' order by sort |
0.000576 - select * from tad_news where nsn='10445' |
0.000392 - select groupid,name from groups |
0.006632 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10445' order by sort |
0.006483 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10445' order by sort |
0.000792 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001085 - desc `tadnews_data_center` `sort` |
0.000501 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10373' order by `sort` , `data_sort` |
0.007068 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10373' order by sort |
0.000308 - select * from tad_news where nsn='10373' |
0.000419 - select groupid,name from groups |
0.006353 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10373' order by sort |
0.005670 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10373' order by sort |
0.000360 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000392 - desc `tadnews_data_center` `sort` |
0.000371 - 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.007544 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10401' order by sort |
0.000431 - select * from tad_news where nsn='10401' |
0.000578 - select groupid,name from groups |
0.007297 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10401' order by sort |
0.006511 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10401' order by sort |
0.000357 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001536 - desc `tadnews_data_center` `sort` |
0.000591 - 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.005932 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10380' order by sort |
0.000637 - select * from tad_news where nsn='10380' |
0.000133 - select groupid,name from groups |
0.005603 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.005204 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10380' order by sort |
0.000461 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001029 - desc `tadnews_data_center` `sort` |
0.000801 - 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.006691 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10370' order by sort |
0.000875 - select * from tad_news where nsn='10370' |
0.000335 - select groupid,name from groups |
0.006557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10370' order by sort |
0.006875 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10370' order by sort |
0.000204 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002076 - 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`='10369' order by `sort` , `data_sort` |
0.007739 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10369' order by sort |
0.000957 - select * from tad_news where nsn='10369' |
0.000396 - select groupid,name from groups |
0.006400 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10369' order by sort |
0.006895 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10369' order by sort |
0.000225 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000114 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001038 - 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 |