資料庫語法 |
---|
0.000053 - SET SQL_BIG_SELECTS = 1 |
0.002023 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000543 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '8o4veheoe1jvkbj4echsheateu' |
0.000629 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000866 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000795 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000221 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000393 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000112 - select mid from modules where dirname='tadnews' |
0.000471 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000453 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001672 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002030 - 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.000555 - 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.000494 - 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.000311 - 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.906208 - update tad_news set always_top='0' WHERE always_top_date <='2025-10-01 01:58:46' and always_top_date!='0000-00-00 00:00:00' |
0.030541 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
0.506604 - 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-10-01 01:58:45' and (end_day > '2025-10-01 01:58:45' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.679832 - 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-10-01 01:58:45' and (end_day > '2025-10-01 01:58:45' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 20, 20 |
0.000886 - desc `tadnews_data_center` `sort` |
0.002119 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10872' order by `sort` , `data_sort` |
0.017197 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10872' order by sort |
0.007406 - select * from tad_news where nsn='10872' |
0.000144 - SELECT * FROM users WHERE uid = '279' |
0.000100 - select groupid,name from groups |
0.011147 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10872' order by sort |
0.033699 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10872' order by sort |
0.002590 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.008036 - SELECT * FROM smiles |
0.004300 - desc `tadnews_data_center` `sort` |
0.000455 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10844' order by `sort` , `data_sort` |
0.023582 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10844' order by sort |
0.000159 - SELECT * FROM users WHERE uid = '278' |
0.000627 - select * from tad_news where nsn='10844' |
0.003744 - select groupid,name from groups |
0.019053 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10844' order by sort |
0.025939 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10844' order by sort |
0.010769 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001625 - desc `tadnews_data_center` `sort` |
0.004459 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10843' order by `sort` , `data_sort` |
0.006312 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10843' order by sort |
0.021944 - select * from tad_news where nsn='10843' |
0.000519 - SELECT * FROM users WHERE uid = '185' |
0.002133 - select groupid,name from groups |
0.027960 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10843' order by sort |
0.036398 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10843' order by sort |
0.010568 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000453 - desc `tadnews_data_center` `sort` |
0.000835 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10839' order by `sort` , `data_sort` |
0.006843 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10839' order by sort |
0.015773 - select * from tad_news where nsn='10839' |
0.000527 - select groupid,name from groups |
0.012641 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10839' order by sort |
0.019111 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10839' order by sort |
0.017891 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.010434 - 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`='10835' order by `sort` , `data_sort` |
0.031871 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10835' order by sort |
0.002514 - select * from tad_news where nsn='10835' |
0.000237 - select groupid,name from groups |
0.019742 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10835' order by sort |
0.015888 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10835' order by sort |
0.013348 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000438 - desc `tadnews_data_center` `sort` |
0.000892 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10817' order by `sort` , `data_sort` |
0.009686 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10817' order by sort |
0.019583 - select * from tad_news where nsn='10817' |
0.000218 - select groupid,name from groups |
0.014224 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10817' order by sort |
0.032062 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10817' order by sort |
0.009241 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000394 - desc `tadnews_data_center` `sort` |
0.000202 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10807' order by `sort` , `data_sort` |
0.024052 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10807' order by sort |
0.000195 - select * from tad_news where nsn='10807' |
0.000163 - select groupid,name from groups |
0.019986 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10807' order by sort |
0.040128 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10807' order by sort |
0.003373 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001243 - desc `tadnews_data_center` `sort` |
0.000845 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10805' order by `sort` , `data_sort` |
0.011905 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10805' order by sort |
0.104972 - select * from tad_news where nsn='10805' |
0.013526 - select groupid,name from groups |
0.015651 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10805' order by sort |
0.024517 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10805' order by sort |
0.008398 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001787 - desc `tadnews_data_center` `sort` |
0.022924 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10798' order by `sort` , `data_sort` |
0.005534 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10798' order by sort |
0.024971 - select * from tad_news where nsn='10798' |
0.002143 - select groupid,name from groups |
0.027180 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10798' order by sort |
0.035557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10798' order by sort |
0.001904 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000600 - desc `tadnews_data_center` `sort` |
0.002372 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10786' order by `sort` , `data_sort` |
0.019929 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10786' order by sort |
0.011488 - select * from tad_news where nsn='10786' |
0.000220 - select groupid,name from groups |
0.021658 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10786' order by sort |
0.022750 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10786' order by sort |
0.002634 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000667 - desc `tadnews_data_center` `sort` |
0.001870 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10785' order by `sort` , `data_sort` |
0.032268 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10785' order by sort |
0.003079 - select * from tad_news where nsn='10785' |
0.000087 - select groupid,name from groups |
0.013563 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10785' order by sort |
0.038633 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10785' order by sort |
0.012515 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.005706 - desc `tadnews_data_center` `sort` |
0.007148 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10765' order by `sort` , `data_sort` |
0.049740 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10765' order by sort |
0.008879 - select * from tad_news where nsn='10765' |
0.002293 - select groupid,name from groups |
0.030143 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10765' order by sort |
0.027364 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10765' order by sort |
0.010547 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.005624 - desc `tadnews_data_center` `sort` |
0.001616 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10763' order by `sort` , `data_sort` |
0.023314 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10763' order by sort |
0.021147 - select * from tad_news where nsn='10763' |
0.000201 - select groupid,name from groups |
0.028107 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10763' order by sort |
0.027450 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10763' order by sort |
0.006862 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.009235 - desc `tadnews_data_center` `sort` |
0.000520 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10762' order by `sort` , `data_sort` |
0.009819 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10762' order by sort |
0.006309 - select * from tad_news where nsn='10762' |
0.000106 - select groupid,name from groups |
0.006671 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10762' order by sort |
0.007861 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10762' order by sort |
0.000152 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001235 - desc `tadnews_data_center` `sort` |
0.000446 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10759' order by `sort` , `data_sort` |
0.005996 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10759' order by sort |
0.000646 - select * from tad_news where nsn='10759' |
0.000401 - select groupid,name from groups |
0.005148 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10759' order by sort |
0.004860 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10759' order by sort |
0.000412 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001045 - desc `tadnews_data_center` `sort` |
0.000416 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10758' order by `sort` , `data_sort` |
0.005870 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10758' order by sort |
0.000464 - select * from tad_news where nsn='10758' |
0.000131 - select groupid,name from groups |
0.005529 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10758' order by sort |
0.017631 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10758' order by sort |
0.008206 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000723 - desc `tadnews_data_center` `sort` |
0.000433 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10757' order by `sort` , `data_sort` |
0.007923 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10757' order by sort |
0.006746 - select * from tad_news where nsn='10757' |
0.000125 - select groupid,name from groups |
0.019664 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10757' order by sort |
0.018867 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10757' order by sort |
0.000646 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001908 - desc `tadnews_data_center` `sort` |
0.006978 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10740' order by `sort` , `data_sort` |
0.007374 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10740' order by sort |
0.008310 - select * from tad_news where nsn='10740' |
0.000097 - select groupid,name from groups |
0.006019 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10740' order by sort |
0.010861 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10740' order by sort |
0.006644 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001233 - desc `tadnews_data_center` `sort` |
0.001973 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10700' order by `sort` , `data_sort` |
0.012251 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10700' order by sort |
0.004355 - select * from tad_news where nsn='10700' |
0.000317 - select groupid,name from groups |
0.006770 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10700' order by sort |
0.017871 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10700' order by sort |
0.010625 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001642 - desc `tadnews_data_center` `sort` |
0.000411 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10699' order by `sort` , `data_sort` |
0.013078 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10699' order by sort |
0.000326 - select * from tad_news where nsn='10699' |
0.000381 - select groupid,name from groups |
0.012906 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10699' order by sort |
0.014011 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10699' order by sort |
0.007825 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000556 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.006007 - 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 |