SHOW FULL COLUMNS FROM `xk_cate` [ RunTime:0.005404s ]
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.004659s ]
SHOW FULL COLUMNS FROM `xk_column` [ RunTime:0.005786s ]
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.004546s ]
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.004536s ]
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.004534s ]
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.004628s ]
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.004492s ]
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.004540s ]
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.004626s ]
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.020791s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.029066s ]
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.004843s ]
SHOW FULL COLUMNS FROM `xk_adv` [ RunTime:0.005117s ]
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.004469s ]
SELECT * FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004493s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004438s ]
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.004505s ]
SHOW FULL COLUMNS FROM `xk_artice` [ RunTime:0.005289s ]
SELECT `cate_id` FROM `xk_cate` WHERE ( `sign` = 'exhibition_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004645s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004464s ]
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.005468s ]
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.005376s ]
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.004590s ]
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.004554s ]
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.004522s ]
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.004534s ]
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.004518s ]
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.004525s ]
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.004482s ]
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.004490s ]
山东省青岛市平度市田庄镇
cilongshimo@163.com
