SHOW FULL COLUMNS FROM `xk_cate` [ RunTime:0.005324s ]
SELECT `seo_title`,`seo_des`,`seo_keywords`,`author`,`generator` FROM `xk_cate` WHERE ( `sign` = 'exhibition_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004836s ]
SHOW FULL COLUMNS FROM `xk_column` [ RunTime:0.005133s ]
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.004760s ]
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.004953s ]
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.004823s ]
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.004839s ]
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.004804s ]
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.004794s ]
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.004799s ]
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.004795s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004679s ]
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.004708s ]
SHOW FULL COLUMNS FROM `xk_adv` [ RunTime:0.005168s ]
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.004998s ]
SELECT * FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004910s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004452s ]
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.004917s ]
SHOW FULL COLUMNS FROM `xk_artice` [ RunTime:0.005726s ]
SELECT `cate_id` FROM `xk_cate` WHERE ( `sign` = 'exhibition_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004744s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004433s ]
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 '%,91,%' AND `a`.`column_id` = '23' ) AND `a`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.005692s ]
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 '%,91,%' AND `a`.`column_id` = '23' ) AND `a`.`delete_time` IS NULL ORDER BY `order_id` DESC LIMIT 0,5 [ RunTime:0.005546s ]
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.004503s ]
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.004493s ]
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.004427s ]
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.004505s ]
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.004547s ]
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.004439s ]
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.004472s ]
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.004439s ]
山东省青岛市平度市田庄镇
cilongshimo@163.com
