資料庫語法 |
---|
0.001797 - SET SQL_BIG_SELECTS = 1 |
0.000727 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000345 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '4pt6l3ar4p52fqdd4assodok9l' |
0.000445 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001292 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000556 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.002718 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000298 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000565 - select mid from modules where dirname='tadnews' |
0.000196 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000309 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001487 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001888 - 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.001067 - 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.000488 - 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.000471 - 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.147046 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 01:03:43' and always_top_date!='0000-00-00 00:00:00' |
0.000399 - select not_news from tad_news_cate where ncsn='10' |
0.000099 - select * from tad_news_cate where ncsn='10' |
0.431383 - select count(*) from tad_news where ncsn='10' |
0.000639 - select groupid,name from groups |
0.000079 - select groupid,name from groups |
0.000416 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '10' order by sort |
0.091841 - select * from tad_news where 1 and enable='1' and `ncsn` = '10' 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.074081 - select * from tad_news where 1 and enable='1' and `ncsn` = '10' 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 140, 20 |
0.001289 - desc `tadnews_data_center` `sort` |
0.000301 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='7010' order by `sort` , `data_sort` |
0.014384 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='7010' order by sort |
0.000234 - SELECT * FROM users WHERE uid = '180' |
0.000149 - select * from tad_news where nsn='7010' |
0.000315 - select groupid,name from groups |
0.012419 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7010' order by sort |
0.006336 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='7010' order by sort |
0.000274 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000092 - SELECT * FROM smiles |
0.001576 - desc `tadnews_data_center` `sort` |
0.000368 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6964' order by `sort` , `data_sort` |
0.012774 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6964' order by sort |
0.001218 - SELECT * FROM users WHERE uid = '229' |
0.000245 - select * from tad_news where nsn='6964' |
0.000221 - select groupid,name from groups |
0.006538 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6964' order by sort |
0.011951 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6964' order by sort |
0.000337 - select font_color,color,tag from tad_news_tags where `tag_sn`='8' and enable='1' |
0.001178 - desc `tadnews_data_center` `sort` |
0.000342 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6959' order by `sort` , `data_sort` |
0.009174 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6959' order by sort |
0.003258 - select * from tad_news where nsn='6959' |
0.000428 - select groupid,name from groups |
0.007168 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6959' order by sort |
0.006771 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6959' order by sort |
0.000208 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001315 - desc `tadnews_data_center` `sort` |
0.000788 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6956' order by `sort` , `data_sort` |
0.015837 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6956' order by sort |
0.318669 - select * from tad_news where nsn='6956' |
0.000401 - select groupid,name from groups |
0.008860 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6956' order by sort |
0.009845 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6956' order by sort |
0.000982 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001809 - desc `tadnews_data_center` `sort` |
0.000344 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6942' order by `sort` , `data_sort` |
0.020612 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6942' order by sort |
0.008651 - select * from tad_news where nsn='6942' |
0.000744 - select groupid,name from groups |
0.022898 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6942' order by sort |
0.007376 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6942' order by sort |
0.010924 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000507 - desc `tadnews_data_center` `sort` |
0.000292 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6889' order by `sort` , `data_sort` |
0.015969 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6889' order by sort |
0.000418 - select * from tad_news where nsn='6889' |
0.000163 - select groupid,name from groups |
0.007246 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6889' order by sort |
0.026806 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6889' order by sort |
0.000732 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000965 - desc `tadnews_data_center` `sort` |
0.000211 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6642' order by `sort` , `data_sort` |
0.015712 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6642' order by sort |
0.366542 - select * from tad_news where nsn='6642' |
0.000248 - select groupid,name from groups |
0.004325 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6642' order by sort |
0.006573 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6642' order by sort |
0.005645 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.007627 - desc `tadnews_data_center` `sort` |
0.001087 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6640' order by `sort` , `data_sort` |
0.018553 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6640' order by sort |
0.000297 - select * from tad_news where nsn='6640' |
0.000267 - select groupid,name from groups |
0.005768 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6640' order by sort |
0.021710 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6640' order by sort |
0.000474 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000489 - desc `tadnews_data_center` `sort` |
0.005576 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6639' order by `sort` , `data_sort` |
0.004943 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6639' order by sort |
0.006385 - select * from tad_news where nsn='6639' |
0.000110 - select groupid,name from groups |
0.005403 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6639' order by sort |
0.013272 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6639' order by sort |
0.004368 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001044 - desc `tadnews_data_center` `sort` |
0.006885 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6574' order by `sort` , `data_sort` |
0.006579 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6574' order by sort |
0.004300 - select * from tad_news where nsn='6574' |
0.000527 - SELECT * FROM users WHERE uid = '184' |
0.000078 - select groupid,name from groups |
0.006405 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6574' order by sort |
0.013491 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6574' order by sort |
0.000843 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.010271 - desc `tadnews_data_center` `sort` |
0.000664 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6568' order by `sort` , `data_sort` |
0.006011 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6568' order by sort |
0.003293 - select * from tad_news where nsn='6568' |
0.000110 - select groupid,name from groups |
0.005652 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6568' order by sort |
0.017452 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6568' order by sort |
0.003916 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000767 - 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`='6524' order by `sort` , `data_sort` |
0.013401 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6524' order by sort |
0.000162 - select * from tad_news where nsn='6524' |
0.000085 - select groupid,name from groups |
0.005352 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6524' order by sort |
0.011663 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6524' order by sort |
0.006873 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.000956 - desc `tadnews_data_center` `sort` |
0.001101 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6473' order by `sort` , `data_sort` |
0.011135 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6473' order by sort |
0.003396 - select * from tad_news where nsn='6473' |
0.002143 - select groupid,name from groups |
0.012951 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6473' order by sort |
0.007727 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6473' order by sort |
0.003664 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.006480 - desc `tadnews_data_center` `sort` |
0.000517 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6452' order by `sort` , `data_sort` |
0.023788 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6452' order by sort |
0.008004 - select * from tad_news where nsn='6452' |
0.000377 - select groupid,name from groups |
0.012394 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6452' order by sort |
0.008816 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6452' order by sort |
0.012703 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001472 - desc `tadnews_data_center` `sort` |
0.001572 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6351' order by `sort` , `data_sort` |
0.014173 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6351' order by sort |
0.006383 - select * from tad_news where nsn='6351' |
0.000151 - select groupid,name from groups |
0.010704 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6351' order by sort |
0.014540 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6351' order by sort |
0.019902 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.005286 - desc `tadnews_data_center` `sort` |
0.000445 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6314' order by `sort` , `data_sort` |
0.019764 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6314' order by sort |
0.001761 - select * from tad_news where nsn='6314' |
0.000434 - select groupid,name from groups |
0.024281 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6314' order by sort |
0.007801 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6314' order by sort |
0.012064 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004171 - desc `tadnews_data_center` `sort` |
0.002309 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6252' order by `sort` , `data_sort` |
0.012663 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6252' order by sort |
0.007133 - select * from tad_news where nsn='6252' |
0.004667 - select groupid,name from groups |
0.020097 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6252' order by sort |
0.027896 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6252' order by sort |
0.001872 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001518 - desc `tadnews_data_center` `sort` |
0.000633 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6179' order by `sort` , `data_sort` |
0.011550 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6179' order by sort |
0.006237 - select * from tad_news where nsn='6179' |
0.003906 - select groupid,name from groups |
0.013376 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6179' order by sort |
0.018826 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6179' order by sort |
0.008974 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001035 - desc `tadnews_data_center` `sort` |
0.003464 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6095' order by `sort` , `data_sort` |
0.012072 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6095' order by sort |
0.005369 - select * from tad_news where nsn='6095' |
0.000346 - select groupid,name from groups |
0.014559 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6095' order by sort |
0.020437 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6095' order by sort |
0.000634 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.004584 - desc `tadnews_data_center` `sort` |
0.000165 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='6071' order by `sort` , `data_sort` |
0.006627 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='6071' order by sort |
0.010660 - select * from tad_news where nsn='6071' |
0.000541 - select groupid,name from groups |
0.014246 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6071' order by sort |
0.006801 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='6071' order by sort |
0.009322 - select font_color,color,tag from tad_news_tags where `tag_sn`='7' and enable='1' |
0.001227 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.004593 - SELECT t1.ncsn AS lev1, t2.ncsn as lev2, t3.ncsn as lev3, t4.ncsn as lev4, t5.ncsn as lev5, t6.ncsn as lev6, t7.ncsn as lev7
FROM `tad_news_cate` t1
LEFT JOIN `tad_news_cate` t2 ON t2.of_ncsn = t1.ncsn
LEFT JOIN `tad_news_cate` t3 ON t3.of_ncsn = t2.ncsn
LEFT JOIN `tad_news_cate` t4 ON t4.of_ncsn = t3.ncsn
LEFT JOIN `tad_news_cate` t5 ON t5.of_ncsn = t4.ncsn
LEFT JOIN `tad_news_cate` t6 ON t6.of_ncsn = t5.ncsn
LEFT JOIN `tad_news_cate` t7 ON t7.of_ncsn = t6.ncsn
WHERE t1.of_ncsn = '0' |
0.007043 - select * from tad_news_cate where ncsn='10' |
0.149249 - select count(*) from tad_news where ncsn='10' |
0.000444 - select groupid,name from groups |
0.001131 - select groupid,name from groups |
0.000925 - select ncsn,nc_title from tad_news_cate where of_ncsn='10' |
0.000214 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.003552 - 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 |