資料庫語法 |
---|
0.000049 - SET SQL_BIG_SELECTS = 1 |
0.000480 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000299 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '5pkb0j98kdubia2tvjpfukpr18' |
0.000189 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.000785 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000488 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.001296 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000286 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000366 - select mid from modules where dirname='tadnews' |
0.000744 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000402 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001059 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.002227 - 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.000996 - 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.000646 - 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.000386 - 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.249029 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-29 19:58:09' and always_top_date!='0000-00-00 00:00:00' |
0.000337 - select * from tad_news_cate where 1 and not_news!='1' order by sort |
1.009024 - 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-29 19:58:08' and (end_day > '2025-09-29 19:58:08' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.213018 - 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-29 19:58:08' and (end_day > '2025-09-29 19:58:08' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 200, 20 |
0.001468 - desc `tadnews_data_center` `sort` |
0.001766 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10819' order by `sort` , `data_sort` |
0.012986 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10819' order by sort |
0.001311 - select * from tad_news where nsn='10819' |
0.000706 - SELECT * FROM users WHERE uid = '219' |
0.004899 - select groupid,name from groups |
0.004507 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10819' order by sort |
0.008458 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10819' order by sort |
0.000631 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000248 - SELECT * FROM smiles |
0.001670 - desc `tadnews_data_center` `sort` |
0.000692 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10818' order by `sort` , `data_sort` |
0.011808 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10818' order by sort |
0.000930 - select * from tad_news where nsn='10818' |
0.000674 - select groupid,name from groups |
0.010390 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10818' order by sort |
0.008965 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10818' order by sort |
0.000491 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.002014 - desc `tadnews_data_center` `sort` |
0.000221 - 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.011792 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10817' order by sort |
0.000431 - SELECT * FROM users WHERE uid = '278' |
0.005452 - select * from tad_news where nsn='10817' |
0.000258 - select groupid,name from groups |
0.005184 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10817' order by sort |
0.008773 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10817' order by sort |
0.003018 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001509 - desc `tadnews_data_center` `sort` |
0.001049 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10811' order by `sort` , `data_sort` |
0.016990 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10811' order by sort |
0.000630 - SELECT * FROM users WHERE uid = '180' |
0.000639 - select * from tad_news where nsn='10811' |
0.000201 - select groupid,name from groups |
0.004473 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10811' order by sort |
0.012180 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10811' order by sort |
0.001508 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.001176 - desc `tadnews_data_center` `sort` |
0.000698 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10816' order by `sort` , `data_sort` |
0.012798 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10816' order by sort |
0.000414 - select * from tad_news where nsn='10816' |
0.000407 - SELECT * FROM users WHERE uid = '318' |
0.004925 - select groupid,name from groups |
0.005518 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10816' order by sort |
0.007780 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10816' order by sort |
0.001758 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.002115 - desc `tadnews_data_center` `sort` |
0.000832 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10815' order by `sort` , `data_sort` |
0.011085 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10815' order by sort |
0.000647 - select * from tad_news where nsn='10815' |
0.002399 - select groupid,name from groups |
0.013212 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10815' order by sort |
0.011915 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10815' order by sort |
0.000249 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.000498 - desc `tadnews_data_center` `sort` |
0.000296 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10814' order by `sort` , `data_sort` |
0.010417 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10814' order by sort |
0.000397 - SELECT * FROM users WHERE uid = '37' |
0.001139 - select * from tad_news where nsn='10814' |
0.005472 - select groupid,name from groups |
0.005934 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10814' order by sort |
0.012832 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10814' order by sort |
0.005694 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000497 - desc `tadnews_data_center` `sort` |
0.000435 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10813' order by `sort` , `data_sort` |
0.004316 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10813' order by sort |
0.005776 - select * from tad_news where nsn='10813' |
0.000108 - select groupid,name from groups |
0.005166 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10813' order by sort |
0.004644 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10813' order by sort |
0.000630 - select font_color,color,tag from tad_news_tags where `tag_sn`='9' and enable='1' |
0.001019 - desc `tadnews_data_center` `sort` |
0.000352 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10812' order by `sort` , `data_sort` |
0.007415 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10812' order by sort |
0.000671 - select * from tad_news where nsn='10812' |
0.000113 - select groupid,name from groups |
0.007404 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10812' order by sort |
0.007172 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10812' order by sort |
0.000144 - select font_color,color,tag from tad_news_tags where `tag_sn`='12' and enable='1' |
0.000421 - 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`='10810' order by `sort` , `data_sort` |
0.006758 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10810' order by sort |
0.000425 - SELECT * FROM users WHERE uid = '230' |
0.000343 - select * from tad_news where nsn='10810' |
0.000299 - select groupid,name from groups |
0.007048 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10810' order by sort |
0.007207 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10810' order by sort |
0.000381 - select font_color,color,tag from tad_news_tags where `tag_sn`='10' and enable='1' |
0.001072 - desc `tadnews_data_center` `sort` |
0.000495 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10809' order by `sort` , `data_sort` |
0.007673 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10809' order by sort |
0.001126 - select * from tad_news where nsn='10809' |
0.000446 - select groupid,name from groups |
0.006415 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10809' order by sort |
0.007586 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10809' order by sort |
0.000388 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000958 - desc `tadnews_data_center` `sort` |
0.000227 - 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.007301 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10807' order by sort |
0.000224 - SELECT * FROM users WHERE uid = '185' |
0.000315 - select * from tad_news where nsn='10807' |
0.000103 - select groupid,name from groups |
0.006174 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10807' order by sort |
0.005279 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10807' order by sort |
0.000248 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000901 - desc `tadnews_data_center` `sort` |
0.000897 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10806' order by `sort` , `data_sort` |
0.006666 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10806' order by sort |
0.000206 - select * from tad_news where nsn='10806' |
0.000344 - SELECT * FROM users WHERE uid = '167' |
0.000337 - select groupid,name from groups |
0.006024 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10806' order by sort |
0.006172 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10806' order by sort |
0.000145 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001207 - desc `tadnews_data_center` `sort` |
0.000280 - 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.005835 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10805' order by sort |
0.000328 - select * from tad_news where nsn='10805' |
0.000363 - select groupid,name from groups |
0.005684 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10805' order by sort |
0.005772 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10805' order by sort |
0.000303 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000795 - desc `tadnews_data_center` `sort` |
0.000206 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10804' order by `sort` , `data_sort` |
0.007221 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10804' order by sort |
0.000348 - select * from tad_news where nsn='10804' |
0.000098 - select groupid,name from groups |
0.006982 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10804' order by sort |
0.006306 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10804' order by sort |
0.000515 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000818 - desc `tadnews_data_center` `sort` |
0.000642 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10802' order by `sort` , `data_sort` |
0.008106 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10802' order by sort |
0.000634 - select * from tad_news where nsn='10802' |
0.000614 - select groupid,name from groups |
0.007605 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10802' order by sort |
0.007989 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10802' order by sort |
0.000450 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001638 - desc `tadnews_data_center` `sort` |
0.000484 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10801' order by `sort` , `data_sort` |
0.008413 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10801' order by sort |
0.000425 - select * from tad_news where nsn='10801' |
0.000524 - select groupid,name from groups |
0.007256 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10801' order by sort |
0.007053 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10801' order by sort |
0.000791 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000434 - desc `tadnews_data_center` `sort` |
0.000233 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10800' order by `sort` , `data_sort` |
0.007572 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10800' order by sort |
0.001175 - select * from tad_news where nsn='10800' |
0.000119 - select groupid,name from groups |
0.006895 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10800' order by sort |
0.007601 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10800' order by sort |
0.000338 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002227 - desc `tadnews_data_center` `sort` |
0.000375 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='10799' order by `sort` , `data_sort` |
0.006336 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10799' order by sort |
0.000669 - select * from tad_news where nsn='10799' |
0.000261 - select groupid,name from groups |
0.007211 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10799' order by sort |
0.006219 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10799' order by sort |
0.000519 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001223 - desc `tadnews_data_center` `sort` |
0.000714 - 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.006796 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='10798' order by sort |
0.001294 - select * from tad_news where nsn='10798' |
0.000615 - select groupid,name from groups |
0.007017 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10798' order by sort |
0.006700 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='10798' order by sort |
0.000518 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.000393 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000675 - 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 |