SHOW FULL COLUMNS FROM `xk_cate` [ RunTime:0.005474s ]
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.004887s ]
SHOW FULL COLUMNS FROM `xk_column` [ RunTime:0.005175s ]
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.004807s ]
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.005070s ]
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.005317s ]
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.004864s ]
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.004759s ]
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.004840s ]
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.004825s ]
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.004842s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004845s ]
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.004861s ]
SHOW FULL COLUMNS FROM `xk_adv` [ RunTime:0.005263s ]
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.005146s ]
SELECT * FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004921s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004625s ]
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.004924s ]
SHOW FULL COLUMNS FROM `xk_artice` [ RunTime:0.005732s ]
SELECT `cate_id` FROM `xk_cate` WHERE ( `sign` = 'exhibition_news' ) AND `xk_cate`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004994s ]
SELECT `column_id` FROM `xk_column` WHERE ( `sign` = 'news' ) AND `xk_column`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004643s ]
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.005920s ]
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.005394s ]
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.004637s ]
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.004729s ]
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.004577s ]
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.004578s ]
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.004633s ]
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.004581s ]
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.004583s ]
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.004643s ]
山东省青岛市平度市田庄镇
cilongshimo@163.com
