資料庫語法 |
---|
0.000316 - SET SQL_BIG_SELECTS = 1 |
0.001556 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000379 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '602llqk4qlkvov4lavshia9crb' |
0.000441 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000972 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.004395 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000328 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000321 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.001686 - select mid from modules where dirname='tadnews' |
0.000263 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000433 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001897 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002802 - 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.000307 - 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.000345 - 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.000480 - 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.216311 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 01:03:44' and always_top_date!='0000-00-00 00:00:00' |
0.001200 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.763041 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:03:42' and (end_day > '2025-09-30 01:03:42' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.357500 - select * from tad_news where 1 and enable='1' and (ncsn in(8,9,10,12,11,13,4) or ncsn='0') and start_day < '2025-09-30 01:03:42' and (end_day > '2025-09-30 01:03:42' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 4280, 20 |
0.002341 - desc `tadnews_data_center` `sort` |
0.001243 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6428' order by `sort` , `data_sort` |
0.008567 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6428' order by sort |
0.001172 - SELECT * FROM users WHERE uid = '200' |
0.273520 - select * from tad_news where nsn='6428' |
0.004840 - select groupid,name from groups |
0.004288 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6428' order by sort |
0.007539 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6428' order by sort |
0.000188 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000101 - SELECT * FROM smiles |
0.000393 - desc `tadnews_data_center` `sort` |
0.004183 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6427' order by `sort` , `data_sort` |
0.005214 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6427' order by sort |
0.000389 - select * from tad_news where nsn='6427' |
0.000686 - select groupid,name from groups |
0.028021 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6427' order by sort |
0.006400 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6427' order by sort |
0.006516 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000439 - desc `tadnews_data_center` `sort` |
0.000224 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6426' order by `sort` , `data_sort` |
0.005575 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6426' order by sort |
0.000624 - select * from tad_news where nsn='6426' |
0.000345 - select groupid,name from groups |
0.012715 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6426' order by sort |
0.017673 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6426' order by sort |
0.008622 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000786 - desc `tadnews_data_center` `sort` |
0.000559 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6425' order by `sort` , `data_sort` |
0.022897 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6425' order by sort |
0.005851 - select * from tad_news where nsn='6425' |
0.000351 - select groupid,name from groups |
0.005413 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6425' order by sort |
0.037966 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6425' order by sort |
0.000323 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000923 - desc `tadnews_data_center` `sort` |
0.000645 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6424' order by `sort` , `data_sort` |
0.007950 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6424' order by sort |
0.018386 - select * from tad_news where nsn='6424' |
0.002780 - select groupid,name from groups |
0.010712 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6424' order by sort |
0.017739 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6424' order by sort |
0.000099 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000479 - desc `tadnews_data_center` `sort` |
0.000794 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6423' order by `sort` , `data_sort` |
0.017566 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6423' order by sort |
0.008586 - select * from tad_news where nsn='6423' |
0.002411 - select groupid,name from groups |
0.012784 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6423' order by sort |
0.006260 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6423' order by sort |
0.002252 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.006357 - desc `tadnews_data_center` `sort` |
0.000910 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6422' order by `sort` , `data_sort` |
0.015145 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6422' order by sort |
0.009048 - SELECT * FROM users WHERE uid = '180' |
0.000313 - select * from tad_news where nsn='6422' |
0.000278 - select groupid,name from groups |
0.021230 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6422' order by sort |
0.015827 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6422' order by sort |
0.004666 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001309 - desc `tadnews_data_center` `sort` |
0.000200 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6421' order by `sort` , `data_sort` |
0.005459 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6421' order by sort |
0.013038 - SELECT * FROM users WHERE uid = '37' |
0.001014 - select * from tad_news where nsn='6421' |
0.000255 - select groupid,name from groups |
0.018730 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6421' order by sort |
0.008121 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6421' order by sort |
0.010380 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002405 - desc `tadnews_data_center` `sort` |
0.000222 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6420' order by `sort` , `data_sort` |
0.007001 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6420' order by sort |
0.008059 - SELECT * FROM users WHERE uid = '186' |
0.000149 - select * from tad_news where nsn='6420' |
0.000093 - select groupid,name from groups |
0.006178 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6420' order by sort |
0.019336 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6420' order by sort |
0.000200 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000795 - desc `tadnews_data_center` `sort` |
0.000252 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6419' order by `sort` , `data_sort` |
0.006389 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6419' order by sort |
0.009739 - select * from tad_news where nsn='6419' |
0.000136 - select groupid,name from groups |
0.015915 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6419' order by sort |
0.005833 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6419' order by sort |
0.006733 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.002300 - 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`='6418' order by `sort` , `data_sort` |
0.021396 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6418' order by sort |
0.000384 - select * from tad_news where nsn='6418' |
0.000281 - select groupid,name from groups |
0.016332 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6418' order by sort |
0.005372 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6418' order by sort |
0.007397 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.001387 - desc `tadnews_data_center` `sort` |
0.000790 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6417' order by `sort` , `data_sort` |
0.015179 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6417' order by sort |
0.008820 - select * from tad_news where nsn='6417' |
0.000174 - select groupid,name from groups |
0.020049 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6417' order by sort |
0.016006 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6417' order by sort |
0.000133 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.003201 - desc `tadnews_data_center` `sort` |
0.000408 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6416' order by `sort` , `data_sort` |
0.006171 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6416' order by sort |
0.009034 - select * from tad_news where nsn='6416' |
0.000088 - select groupid,name from groups |
0.009486 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6416' order by sort |
0.004220 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6416' order by sort |
0.007616 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000604 - desc `tadnews_data_center` `sort` |
0.000220 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6415' order by `sort` , `data_sort` |
0.004608 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6415' order by sort |
0.007591 - select * from tad_news where nsn='6415' |
0.000267 - select groupid,name from groups |
0.004640 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6415' order by sort |
0.021883 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6415' order by sort |
0.000311 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000592 - desc `tadnews_data_center` `sort` |
0.000492 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6414' order by `sort` , `data_sort` |
0.005866 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6414' order by sort |
0.010174 - select * from tad_news where nsn='6414' |
0.000106 - select groupid,name from groups |
0.013022 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6414' order by sort |
0.005244 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6414' order by sort |
0.005409 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000858 - 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`='6413' order by `sort` , `data_sort` |
0.020368 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6413' order by sort |
0.000222 - select * from tad_news where nsn='6413' |
0.000354 - select groupid,name from groups |
0.005342 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6413' order by sort |
0.006083 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6413' order by sort |
0.014081 - desc `tadnews_data_center` `sort` |
0.000289 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6412' order by `sort` , `data_sort` |
0.005300 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6412' order by sort |
0.011258 - select * from tad_news where nsn='6412' |
0.000098 - select groupid,name from groups |
0.014566 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6412' order by sort |
0.006099 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6412' order by sort |
0.008522 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000357 - desc `tadnews_data_center` `sort` |
0.005871 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6411' order by `sort` , `data_sort` |
0.008137 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6411' order by sort |
0.010065 - select * from tad_news where nsn='6411' |
0.000248 - select groupid,name from groups |
0.007139 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6411' order by sort |
0.013345 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6411' order by sort |
0.000389 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000539 - desc `tadnews_data_center` `sort` |
0.000618 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6410' order by `sort` , `data_sort` |
0.006844 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6410' order by sort |
0.006121 - select * from tad_news where nsn='6410' |
0.002756 - select groupid,name from groups |
0.015908 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6410' order by sort |
0.004754 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6410' order by sort |
0.007296 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000370 - desc `tadnews_data_center` `sort` |
0.000262 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6409' order by `sort` , `data_sort` |
0.013351 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6409' order by sort |
0.000153 - select * from tad_news where nsn='6409' |
0.000420 - select groupid,name from groups |
0.009526 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6409' order by sort |
0.004619 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6409' order by sort |
0.005662 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000138 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000517 - 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 |