SHOW FULL COLUMNS FROM `xk_cate` [ RunTime:0.005025s ]
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.004434s ]
SHOW FULL COLUMNS FROM `xk_column` [ RunTime:0.004607s ]
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.004280s ]
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.004353s ]
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.004195s ]
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.004201s ]
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.004390s ]
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.004318s ]
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.004114s ]
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.004153s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004099s ]
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.004219s ]
SHOW FULL COLUMNS FROM `xk_adv` [ RunTime:0.004562s ]
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.004212s ]
SELECT * FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004189s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.003887s ]
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.004316s ]
SHOW FULL COLUMNS FROM `xk_artice` [ RunTime:0.005072s ]
SELECT `cate_id` FROM `xk_cate` WHERE ( `sign` = 'corporate_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004100s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.003905s ]
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.005367s ]
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.006952s ]
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.004095s ]
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.003952s ]
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.003932s ]
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.004015s ]
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.004060s ]
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.003989s ]
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.003956s ]
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.003960s ]
山东省青岛市平度市田庄镇
cilongshimo@163.com
