資料庫語法 |
---|
0.000039 - SET SQL_BIG_SELECTS = 1 |
0.001240 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000657 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'bbf2mqmsbo85s0huskij9jjj4j' |
0.000455 - SELECT * FROM modules WHERE dirname = 'tadnews' |
0.001326 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '5') |
0.000633 - SELECT * FROM config WHERE (`conf_modid` = '5') ORDER BY conf_order ASC |
0.000663 - SELECT * FROM modules WHERE dirname = 'tadtools' |
0.000469 - SELECT * FROM config WHERE (`conf_modid` = '2') ORDER BY conf_order ASC |
0.000253 - select mid from modules where dirname='tadnews' |
0.000230 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000252 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001156 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.003039 - 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.000829 - 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.000601 - 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.000356 - 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.162584 - update tad_news set always_top='0' WHERE always_top_date <='2025-09-30 23:08:18' and always_top_date!='0000-00-00 00:00:00' |
0.000921 - select not_news from tad_news_cate where ncsn='8' |
0.000408 - select * from tad_news_cate where ncsn='8' |
0.315084 - select count(*) from tad_news where ncsn='8' |
0.001403 - select groupid,name from groups |
0.001439 - select groupid,name from groups |
0.000704 - select * from tad_news_cate where 1 and not_news!='1' and `ncsn` = '8' order by sort |
0.606940 - select * from tad_news where 1 and enable='1' and `ncsn` = '8' and start_day < '2025-09-30 23:08:16' and (end_day > '2025-09-30 23:08:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc |
0.241699 - select * from tad_news where 1 and enable='1' and `ncsn` = '8' and start_day < '2025-09-30 23:08:16' and (end_day > '2025-09-30 23:08:16' or end_day='0000-00-00 00:00:00') order by always_top desc , start_day desc LIMIT 5800, 20 |
0.002310 - desc `tadnews_data_center` `sort` |
0.001181 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='95' order by `sort` , `data_sort` |
0.009747 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='95' order by sort |
0.001079 - SELECT * FROM users WHERE uid = '15' |
0.001383 - select * from tad_news where nsn='95' |
0.001240 - SELECT * FROM users WHERE uid = '15' |
0.000210 - select groupid,name from groups |
0.008213 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='95' order by sort |
0.007474 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='95' order by sort |
0.000988 - SELECT * FROM smiles |
0.003112 - desc `tadnews_data_center` `sort` |
0.000791 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='92' order by `sort` , `data_sort` |
0.006662 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='92' order by sort |
0.000709 - SELECT * FROM users WHERE uid = '18' |
0.000792 - SELECT * FROM users WHERE uid = '18' |
0.000137 - SELECT * FROM users WHERE uid = '18' |
0.000157 - SELECT * FROM users WHERE uid = '18' |
0.000263 - select * from tad_news where nsn='92' |
0.000184 - SELECT * FROM users WHERE uid = '18' |
0.000184 - select groupid,name from groups |
0.007209 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='92' order by sort |
0.007232 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='92' order by sort |
0.002609 - desc `tadnews_data_center` `sort` |
0.000930 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='89' order by `sort` , `data_sort` |
0.007351 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='89' order by sort |
0.001580 - select * from tad_news where nsn='89' |
0.000500 - SELECT * FROM users WHERE uid = '17' |
0.000309 - select groupid,name from groups |
0.004585 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='89' order by sort |
0.007352 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='89' order by sort |
0.002005 - desc `tadnews_data_center` `sort` |
0.000486 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='87' order by `sort` , `data_sort` |
0.005268 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='87' order by sort |
0.000254 - select * from tad_news where nsn='87' |
0.000443 - SELECT * FROM users WHERE uid = '22' |
0.000401 - select groupid,name from groups |
0.005748 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='87' order by sort |
0.008902 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='87' order by sort |
0.000454 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.000840 - desc `tadnews_data_center` `sort` |
0.000540 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='83' order by `sort` , `data_sort` |
0.005373 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='83' order by sort |
0.000445 - SELECT * FROM users WHERE uid = '20' |
0.000093 - SELECT * FROM users WHERE uid = '20' |
0.000406 - select * from tad_news where nsn='83' |
0.000160 - SELECT * FROM users WHERE uid = '20' |
0.000318 - select groupid,name from groups |
0.005479 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='83' order by sort |
0.005211 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='83' order by sort |
0.001193 - desc `tadnews_data_center` `sort` |
0.000565 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='74' order by `sort` , `data_sort` |
0.004967 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='74' order by sort |
0.000495 - SELECT * FROM users WHERE uid = '18' |
0.000469 - select * from tad_news where nsn='74' |
0.000519 - SELECT * FROM users WHERE uid = '18' |
0.000253 - select groupid,name from groups |
0.009325 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='74' order by sort |
0.005765 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='74' order by sort |
0.002081 - desc `tadnews_data_center` `sort` |
0.000462 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='71' order by `sort` , `data_sort` |
0.005533 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='71' order by sort |
0.000471 - SELECT * FROM users WHERE uid = '18' |
0.000224 - SELECT * FROM users WHERE uid = '18' |
0.000089 - SELECT * FROM users WHERE uid = '18' |
0.000114 - select * from tad_news where nsn='71' |
0.000127 - SELECT * FROM users WHERE uid = '18' |
0.000165 - select groupid,name from groups |
0.004557 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='71' order by sort |
0.004205 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='71' order by sort |
0.000827 - desc `tadnews_data_center` `sort` |
0.000591 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='70' order by `sort` , `data_sort` |
0.004698 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='70' order by sort |
0.001880 - SELECT * FROM users WHERE uid = '16' |
0.000134 - select * from tad_news where nsn='70' |
0.000333 - SELECT * FROM users WHERE uid = '16' |
0.000184 - select groupid,name from groups |
0.006668 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='70' order by sort |
0.006484 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='70' order by sort |
0.001898 - desc `tadnews_data_center` `sort` |
0.000703 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='69' order by `sort` , `data_sort` |
0.005151 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='69' order by sort |
0.000518 - SELECT * FROM users WHERE uid = '16' |
0.000556 - select * from tad_news where nsn='69' |
0.000126 - SELECT * FROM users WHERE uid = '16' |
0.000392 - select groupid,name from groups |
0.005032 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='69' order by sort |
0.004953 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='69' order by sort |
0.000686 - 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`='68' order by `sort` , `data_sort` |
0.004650 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='68' order by sort |
0.001279 - SELECT * FROM users WHERE uid = '9' |
0.000122 - SELECT * FROM users WHERE uid = '9' |
0.000462 - select * from tad_news where nsn='68' |
0.000307 - SELECT * FROM users WHERE uid = '9' |
0.000303 - select groupid,name from groups |
0.006870 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='68' order by sort |
0.005930 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='68' order by sort |
0.000929 - desc `tadnews_data_center` `sort` |
0.000540 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='66' order by `sort` , `data_sort` |
0.004642 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='66' order by sort |
0.000400 - SELECT * FROM users WHERE uid = '17' |
0.000231 - SELECT * FROM users WHERE uid = '17' |
0.000105 - select * from tad_news where nsn='66' |
0.000084 - SELECT * FROM users WHERE uid = '17' |
0.000313 - select groupid,name from groups |
0.004329 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='66' order by sort |
0.004706 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='66' order by sort |
0.000481 - select font_color,color,tag from tad_news_tags where `tag_sn`='6' and enable='1' |
0.002342 - desc `tadnews_data_center` `sort` |
0.000436 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='63' order by `sort` , `data_sort` |
0.005114 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='63' order by sort |
0.000127 - SELECT * FROM users WHERE uid = '16' |
0.000099 - SELECT * FROM users WHERE uid = '16' |
0.000296 - select * from tad_news where nsn='63' |
0.000100 - SELECT * FROM users WHERE uid = '16' |
0.000080 - select groupid,name from groups |
0.005422 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='63' order by sort |
0.005658 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='63' order by sort |
0.000359 - desc `tadnews_data_center` `sort` |
0.000283 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='62' order by `sort` , `data_sort` |
0.005119 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='62' order by sort |
0.000166 - SELECT * FROM users WHERE uid = '16' |
0.000247 - SELECT * FROM users WHERE uid = '16' |
0.000144 - SELECT * FROM users WHERE uid = '16' |
0.000133 - SELECT * FROM users WHERE uid = '16' |
0.000120 - select * from tad_news where nsn='62' |
0.000086 - SELECT * FROM users WHERE uid = '16' |
0.000265 - select groupid,name from groups |
0.004076 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='62' order by sort |
0.005743 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='62' order by sort |
0.001051 - desc `tadnews_data_center` `sort` |
0.000199 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='61' order by `sort` , `data_sort` |
0.005965 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='61' order by sort |
0.000152 - SELECT * FROM users WHERE uid = '16' |
0.000256 - SELECT * FROM users WHERE uid = '16' |
0.000159 - SELECT * FROM users WHERE uid = '16' |
0.000245 - SELECT * FROM users WHERE uid = '16' |
0.000440 - select * from tad_news where nsn='61' |
0.000104 - SELECT * FROM users WHERE uid = '16' |
0.000252 - select groupid,name from groups |
0.005240 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='61' order by sort |
0.006875 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='61' order by sort |
0.001505 - desc `tadnews_data_center` `sort` |
0.000497 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='48' order by `sort` , `data_sort` |
0.005181 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='48' order by sort |
0.000552 - SELECT * FROM users WHERE uid = '20' |
0.000211 - SELECT * FROM users WHERE uid = '20' |
0.000082 - SELECT * FROM users WHERE uid = '20' |
0.000126 - SELECT * FROM users WHERE uid = '20' |
0.000086 - SELECT * FROM users WHERE uid = '20' |
0.000107 - SELECT * FROM users WHERE uid = '20' |
0.000142 - SELECT * FROM users WHERE uid = '20' |
0.000112 - select * from tad_news where nsn='48' |
0.000215 - SELECT * FROM users WHERE uid = '20' |
0.000270 - select groupid,name from groups |
0.005859 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='48' order by sort |
0.017879 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='48' order by sort |
0.000675 - desc `tadnews_data_center` `sort` |
0.001290 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='39' order by `sort` , `data_sort` |
0.005732 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='39' order by sort |
0.000498 - SELECT * FROM users WHERE uid = '24' |
0.167266 - select * from tad_news where nsn='39' |
0.000657 - SELECT * FROM users WHERE uid = '24' |
0.005851 - select groupid,name from groups |
0.006782 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='39' order by sort |
0.019824 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='39' order by sort |
0.002627 - desc `tadnews_data_center` `sort` |
0.000860 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='37' order by `sort` , `data_sort` |
0.016793 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='37' order by sort |
0.002630 - SELECT * FROM users WHERE uid = '16' |
0.005572 - SELECT * FROM users WHERE uid = '16' |
0.000757 - select * from tad_news where nsn='37' |
0.000123 - SELECT * FROM users WHERE uid = '16' |
0.000284 - select groupid,name from groups |
0.006214 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='37' order by sort |
0.015005 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='37' order by sort |
0.001001 - desc `tadnews_data_center` `sort` |
0.000420 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='36' order by `sort` , `data_sort` |
0.005708 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='36' order by sort |
0.006566 - SELECT * FROM users WHERE uid = '16' |
0.006187 - SELECT * FROM users WHERE uid = '16' |
0.000461 - select * from tad_news where nsn='36' |
0.000224 - SELECT * FROM users WHERE uid = '16' |
0.000288 - select groupid,name from groups |
0.006763 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='36' order by sort |
0.015969 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='36' order by sort |
0.006921 - desc `tadnews_data_center` `sort` |
0.007055 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='35' order by `sort` , `data_sort` |
0.018996 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='35' order by sort |
0.006699 - SELECT * FROM users WHERE uid = '9' |
0.000106 - select * from tad_news where nsn='35' |
0.000107 - SELECT * FROM users WHERE uid = '9' |
0.000069 - select groupid,name from groups |
0.005298 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='35' order by sort |
0.005618 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='35' order by sort |
0.008836 - desc `tadnews_data_center` `sort` |
0.006810 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tadnews_data_center`
where `mid`= '5' and `col_name`='nsn' and `col_sn`='34' order by `sort` , `data_sort` |
0.005698 - select * from `tadnews_files_center` where `col_name`='nsn' and `col_sn`='34' order by sort |
0.009794 - SELECT * FROM users WHERE uid = '9' |
0.000282 - select * from tad_news where nsn='34' |
0.000134 - SELECT * FROM users WHERE uid = '9' |
0.000309 - select groupid,name from groups |
0.007845 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='34' order by sort |
0.006457 - select * from tadnews_files_center where `col_name`='news_pic' and `col_sn`='34' order by sort |
0.001452 - select ncsn,nc_title from tad_news_cate where of_ncsn='0' |
0.007845 - 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.000157 - select * from tad_news_cate where ncsn='8' |
0.221899 - select count(*) from tad_news where ncsn='8' |
0.000644 - select groupid,name from groups |
0.008250 - select groupid,name from groups |
0.002554 - select ncsn,nc_title from tad_news_cate where of_ncsn='8' |
0.000336 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='default' |
0.000866 - 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 |