SHOW FULL COLUMNS FROM `xk_cate` [ RunTime:0.032053s ]
SELECT `seo_title`,`seo_des`,`seo_keywords`,`author`,`generator` FROM `xk_cate` WHERE ( `sign` = 'corporate_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.041330s ]
SHOW FULL COLUMNS FROM `xk_column` [ RunTime:0.039107s ]
SELECT `column_id`,`column_name`,`linkurl`,`sign`,`picurl`,`picurl1` FROM `xk_column` WHERE ( `status` = 1 ) AND `xk_column`.`delete_time` IS NULL ORDER BY `order_id` ASC LIMIT 7 [ RunTime:0.040926s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 19 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.040931s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 21 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041509s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 20 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041499s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 26 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.039160s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 27 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041560s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 23 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041593s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 25 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041575s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.040701s ]
SELECT c.`cate_id`,c.`cate_name`,c.`cate_author_name`,c.`column_id`,c.`sign`,c.`linkurl`,c.`type` FROM `xk_cate` `c` WHERE ( `status` = 1 AND `parent_id` = 0 AND `c`.`column_id` = '23' ) AND `c`.`delete_time` IS NULL ORDER BY `order_id` ASC LIMIT 1 [ RunTime:0.039618s ]
SHOW FULL COLUMNS FROM `xk_adv` [ RunTime:0.041436s ]
SELECT `adv_id`,`adv_name`,`linkurl`,`target`,`fileurl` FROM `xk_adv` WHERE ( `adv_postion_id` = 6 AND `status` = 1 ) AND `xk_adv`.`delete_time` IS NULL ORDER BY `order_id` ASC LIMIT 1 [ RunTime:0.041484s ]
SELECT * FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.041234s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.041491s ]
SELECT c.`cate_id`,c.`cate_name`,c.`cate_author_name`,c.`column_id`,c.`sign`,c.`linkurl`,c.`picurl` FROM `xk_cate` `c` WHERE ( `status` = 1 AND `parent_id` = 0 AND `c`.`column_id` = '23' ) AND `c`.`delete_time` IS NULL ORDER BY `order_id` ASC LIMIT 10 [ RunTime:0.039286s ]
SHOW FULL COLUMNS FROM `xk_artice` [ RunTime:0.041839s ]
SELECT `cate_id` FROM `xk_cate` WHERE ( `sign` = 'corporate_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.040915s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.041314s ]
SELECT COUNT(*) AS think_count FROM `xk_artice` `a` LEFT JOIN `xk_cate` `c` ON `c`.`cate_id`=`a`.`cate_id` WHERE ( `a`.`status` = '1' AND `a`.`cate_str` LIKE '%,90,%' AND `a`.`column_id` = '23' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.043293s ]
SELECT `a`.*,c.`cate_name`,c.`linkurl` FROM `xk_artice` `a` LEFT JOIN `xk_cate` `c` ON `c`.`cate_id`=`a`.`cate_id` WHERE ( `a`.`status` = '1' AND `a`.`cate_str` LIKE '%,90,%' AND `a`.`column_id` = '23' ) AND `a`.`delete_time` IS NULL ORDER BY `order_id` DESC LIMIT 0,5 [ RunTime:0.055057s ]
SELECT `column_id`,`column_name`,`linkurl`,`sign`,`picurl`,`picurl1` FROM `xk_column` WHERE ( `status` = 1 ) AND `xk_column`.`delete_time` IS NULL ORDER BY `order_id` ASC LIMIT 7 [ RunTime:0.041271s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 19 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.039048s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 21 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041599s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 20 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.036633s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 26 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.041548s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 27 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.039168s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 23 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.020455s ]
SELECT `cate_id`,`cate_name`,`sign`,`linkurl`,`picurl` FROM `xk_cate` WHERE ( `column_id` = 25 AND `is_nav` = 1 AND `parent_id` = 0 ) AND `xk_cate`.`delete_time` IS NULL ORDER BY `order_id` ASC [ RunTime:0.004862s ]
山东省青岛市平度市田庄镇
cilongshimo@163.com
