SHOW FULL COLUMNS FROM `tp_pc_config` [ RunTime:0.003908s ]
SELECT * FROM `tp_pc_config` WHERE ( `pc_site` = 'www.zz18z.com' OR `token` = 'www.zz18z.com' ) LIMIT 1 [ RunTime:0.003908s ]
SHOW FULL COLUMNS FROM `tp_home` [ RunTime:0.003907s ]
SELECT * FROM `tp_home` WHERE `token` = 'ozlmxy1435108467' LIMIT 1 [ RunTime:0.002931s ]
SHOW FULL COLUMNS FROM `tp_wxuser` [ RunTime:0.004884s ]
SELECT * FROM `tp_wxuser` WHERE `token` = 'ozlmxy1435108467' LIMIT 1 [ RunTime:0.003908s ]
SHOW FULL COLUMNS FROM `tp_pc_news_category` [ RunTime:0.003907s ]
SELECT *,cat_id as id,pid as fid,cat_name as name,pic as img FROM `tp_pc_news_category` WHERE `token` = 'ozlmxy1435108467' AND `wxhide` = 0 ORDER BY `cat_sort` DESC [ RunTime:0.003908s ]
SELECT `tpl_status` FROM `tp_pc_config` WHERE `token` = 'ozlmxy1435108467' LIMIT 1 [ RunTime:0.002930s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 LIMIT 1 [ RunTime:0.002931s ]
SELECT `pc_site` FROM `tp_pc_config` WHERE `token` = 'ozlmxy1435108467' LIMIT 1 [ RunTime:0.002931s ]
SELECT cat_id as id,pid as pId,`pid`,cat_name as name FROM `tp_pc_news_category` WHERE `token` = 'ozlmxy1435108467' AND `pid` <> -1 [ RunTime:0.003907s ]
SELECT * FROM `tp_pc_news_category` WHERE ( pid=7 ) ORDER BY `cat_sort` DESC,`cat_id` ASC LIMIT 15 [ RunTime:0.002931s ]
SHOW FULL COLUMNS FROM `tp_pc_news` [ RunTime:0.003908s ]
SELECT `id`,`cat_id`,`token`,`title`,`subtitle`,`showsubtitle`,`key`,`pic`,`file`,`info`,`content`,`hits`,`time`,`url`,`groom`,`tcolor`,`bold`,`source`,`stick`,`essence`,`contirbute`,`preview`,`order`,`draft_box`,`recommended_level`,`piccrop`,`createtime`,`is_message_news`,`qr_url`,`count_like`,`jump_state`,`edit_orial`,`cover_pic`,`pic_type` FROM `tp_pc_news` WHERE `token` = 'ozlmxy1435108467' AND `contirbute` = 0 ORDER BY `time` DESC LIMIT 12 [ RunTime:0.008792s ]
SELECT * FROM `tp_pc_news_category` WHERE ( cat_id=7 ) [ RunTime:0.002930s ]
SELECT `cat_name` FROM `tp_pc_news_category` WHERE ( cat_id=0 ) LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.003908s ]
SELECT `cat_id`,`cat_name`,`pid` FROM `tp_pc_news_category` WHERE ( `token`='ozlmxy1435108467' AND `cat_id`='7' ) LIMIT 1 [ RunTime:0.002930s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.003908s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.002930s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_news_category` WHERE `pid` = 0 AND `token` = 'ozlmxy1435108467' AND `hide` = 0 ORDER BY `cat_sort` DESC,`cat_id` ASC [ RunTime:0.003908s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.002931s ]
SELECT `cat_id`,`cat_name`,`pid` FROM `tp_pc_news_category` WHERE ( `token`='ozlmxy1435108467' AND `cat_id`='7' ) LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 LIMIT 1 [ RunTime:0.003907s ]
SELECT * FROM `tp_pc_news_category` WHERE `pid` = 7 AND `token` = 'ozlmxy1435108467' ORDER BY `cat_sort` DESC,`cat_id` ASC [ RunTime:0.003908s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 AND `token` = 'ozlmxy1435108467' LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.003907s ]
SELECT * FROM `tp_pc_news_category` WHERE `cat_id` = 7 LIMIT 1 [ RunTime:0.003908s ]
SELECT * FROM `tp_pc_config` WHERE `pc_site` = 'www.zz18z.com' LIMIT 1 [ RunTime:0.002931s ]
SELECT * FROM `tp_pc_news_category` WHERE `token` = 'ozlmxy1435108467' AND `cat_id` = 7 LIMIT 1 [ RunTime:0.003907s ]
SELECT COUNT(*) AS think_count FROM `tp_pc_news_category` `nc` INNER JOIN `tp_pc_news` `n` ON `n`.`cat_id`=`nc`.`cat_id` WHERE ( n.token='ozlmxy1435108467' AND n.draft_box=0 AND nc.cat_id='7'AND n.contirbute='' ) LIMIT 1 [ RunTime:0.011723s ]
SELECT `n`.*,n.key as keywords,`nc`.`cat_name`,`nc`.`pic_width`,`nc`.`pic_height` FROM `tp_pc_news_category` `nc` INNER JOIN `tp_pc_news` `n` ON `n`.`cat_id`=`nc`.`cat_id` WHERE ( n.token='ozlmxy1435108467' AND n.draft_box=0 AND nc.cat_id='7'AND n.contirbute='' ) ORDER BY `n`.`order` DESC,`n`.`time` DESC LIMIT 120,20 [ RunTime:0.016607s ]
当前位置：新闻中心-新闻列表-校园新闻
