資料庫語法 |
---|
0.000045 - SET SQL_BIG_SELECTS = 1 |
0.000938 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.005562 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'c0fdcr7jot8jqrd9d2u8kfgc5c' |
0.002774 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000499 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000267 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.001023 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.003702 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.016337 - select mid from modules where dirname='tadnews' |
0.003303 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.002528 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.003373 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.004397 - 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.002579 - 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.000999 - 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.000346 - 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.446721 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 12:05:05' and always_top_date!='0000-00-00 00:00:00' |
0.001822 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.554451 - 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:03' and (end_day > '2025-09-30 12:05:03' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
1.200372 - 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:03' and (end_day > '2025-09-30 12:05:03' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 240, 20 |
0.017459 - desc `tadnews_data_center` `sort` |
0.000620 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6061' order by `sort` , `data_sort` |
0.030912 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6061' order by sort |
0.002854 - select * from tad_news where nsn='6061' |
0.001332 - SELECT * FROM users WHERE uid = '200' |
0.000437 - select groupid,name from groups |
0.034710 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6061' order by sort |
0.022361 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6061' order by sort |
0.014784 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001587 - SELECT * FROM smiles |
0.007185 - desc `tadnews_data_center` `sort` |
0.006151 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6060' order by `sort` , `data_sort` |
0.016420 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6060' order by sort |
0.006229 - select * from tad_news where nsn='6060' |
0.000659 - select groupid,name from groups |
0.022559 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6060' order by sort |
0.033355 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6060' order by sort |
0.007031 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003898 - desc `tadnews_data_center` `sort` |
0.000465 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6059' order by `sort` , `data_sort` |
0.022950 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6059' order by sort |
0.001997 - select * from tad_news where nsn='6059' |
0.003608 - select groupid,name from groups |
0.021746 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6059' order by sort |
0.031510 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6059' order by sort |
0.008928 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001324 - desc `tadnews_data_center` `sort` |
0.003650 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6032' order by `sort` , `data_sort` |
0.028432 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6032' order by sort |
0.007057 - select * from tad_news where nsn='6032' |
0.001219 - select groupid,name from groups |
0.023505 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6032' order by sort |
0.028673 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6032' order by sort |
0.002320 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001588 - desc `tadnews_data_center` `sort` |
0.009038 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6031' order by `sort` , `data_sort` |
0.024933 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6031' order by sort |
0.007561 - select * from tad_news where nsn='6031' |
0.000696 - select groupid,name from groups |
0.005457 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6031' order by sort |
0.029907 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6031' order by sort |
0.003979 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.004463 - desc `tadnews_data_center` `sort` |
0.005918 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6030' order by `sort` , `data_sort` |
0.017548 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6030' order by sort |
0.018762 - select * from tad_news where nsn='6030' |
0.000101 - select groupid,name from groups |
0.004859 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6030' order by sort |
0.013810 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6030' order by sort |
0.024285 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003514 - desc `tadnews_data_center` `sort` |
0.000573 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6029' order by `sort` , `data_sort` |
0.005919 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6029' order by sort |
0.011066 - select * from tad_news where nsn='6029' |
0.000449 - select groupid,name from groups |
0.034582 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6029' order by sort |
0.022112 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6029' order by sort |
0.003422 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002510 - desc `tadnews_data_center` `sort` |
0.004006 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6028' order by `sort` , `data_sort` |
0.022630 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6028' order by sort |
0.001457 - select * from tad_news where nsn='6028' |
0.001680 - select groupid,name from groups |
0.017547 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6028' order by sort |
0.013555 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6028' order by sort |
0.024620 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002265 - desc `tadnews_data_center` `sort` |
0.001325 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6027' order by `sort` , `data_sort` |
0.021507 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6027' order by sort |
0.006762 - select * from tad_news where nsn='6027' |
0.000546 - select groupid,name from groups |
0.005393 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6027' order by sort |
0.031445 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6027' order by sort |
0.005773 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003247 - desc `tadnews_data_center` `sort` |
0.003367 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6026' order by `sort` , `data_sort` |
0.014887 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6026' order by sort |
0.000443 - select * from tad_news where nsn='6026' |
0.003935 - select groupid,name from groups |
0.015927 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6026' order by sort |
0.030394 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6026' order by sort |
0.007347 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000851 - desc `tadnews_data_center` `sort` |
0.001042 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6010' order by `sort` , `data_sort` |
0.005992 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6010' order by sort |
0.016221 - select * from tad_news where nsn='6010' |
0.000925 - select groupid,name from groups |
0.023428 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6010' order by sort |
0.025333 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6010' order by sort |
0.001702 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003806 - desc `tadnews_data_center` `sort` |
0.000334 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6009' order by `sort` , `data_sort` |
0.011208 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6009' order by sort |
0.008478 - select * from tad_news where nsn='6009' |
0.010268 - select groupid,name from groups |
0.009750 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6009' order by sort |
0.005829 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6009' order by sort |
0.017339 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000607 - desc `tadnews_data_center` `sort` |
0.000218 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6000' order by `sort` , `data_sort` |
0.012669 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6000' order by sort |
0.125579 - select * from tad_news where nsn='6000' |
0.001671 - select groupid,name from groups |
0.037210 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6000' order by sort |
0.037278 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6000' order by sort |
0.022978 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.002634 - desc `tadnews_data_center` `sort` |
0.003304 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5999' order by `sort` , `data_sort` |
0.033030 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5999' order by sort |
0.001316 - select * from tad_news where nsn='5999' |
0.005411 - select groupid,name from groups |
0.021998 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5999' order by sort |
0.034859 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5999' order by sort |
0.004116 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001669 - desc `tadnews_data_center` `sort` |
0.008019 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5998' order by `sort` , `data_sort` |
0.023147 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5998' order by sort |
0.004140 - select * from tad_news where nsn='5998' |
0.003477 - select groupid,name from groups |
0.021229 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5998' order by sort |
0.031185 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5998' order by sort |
0.005260 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.006040 - desc `tadnews_data_center` `sort` |
0.003694 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5997' order by `sort` , `data_sort` |
0.007151 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5997' order by sort |
0.006443 - select * from tad_news where nsn='5997' |
0.005056 - select groupid,name from groups |
0.020900 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5997' order by sort |
0.011461 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5997' order by sort |
0.013596 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003730 - desc `tadnews_data_center` `sort` |
0.003183 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5996' order by `sort` , `data_sort` |
0.007087 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5996' order by sort |
0.016564 - select * from tad_news where nsn='5996' |
0.000457 - select groupid,name from groups |
0.014247 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5996' order by sort |
0.025253 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5996' order by sort |
0.002962 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001052 - desc `tadnews_data_center` `sort` |
0.006453 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5994' order by `sort` , `data_sort` |
0.022512 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5994' order by sort |
0.004433 - select * from tad_news where nsn='5994' |
0.002654 - select groupid,name from groups |
0.019314 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5994' order by sort |
0.021215 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5994' order by sort |
0.003802 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.007568 - desc `tadnews_data_center` `sort` |
0.001752 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5993' order by `sort` , `data_sort` |
0.022562 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5993' order by sort |
0.003177 - select * from tad_news where nsn='5993' |
0.007000 - select groupid,name from groups |
0.006429 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5993' order by sort |
0.040382 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5993' order by sort |
0.017980 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.003935 - desc `tadnews_data_center` `sort` |
0.003703 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='5989' order by `sort` , `data_sort` |
0.020859 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='5989' order by sort |
0.009042 - select * from tad_news where nsn='5989' |
0.000567 - select groupid,name from groups |
0.024452 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5989' order by sort |
0.036970 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='5989' order by sort |
0.007182 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000429 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.001545 - 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 |