SHOW FULL COLUMNS FROM `xb_content` [ RunTime:0.001239s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 151 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000720s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 151 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000590s ]
SELECT * FROM `xb_content` WHERE ( `id` = 151 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000823s ]
SHOW FULL COLUMNS FROM `xb_template_custom` [ RunTime:0.000883s ]
SELECT `content_id`,`type`,`free_type`,`category`,`source_code_file`,`coding`,`file_size`,`screen_work`,`demo_url`,`author1` FROM `xb_template_custom` WHERE `content_id` = 151 LIMIT 1 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `xb_content_details` [ RunTime:0.000842s ]
SELECT `content`,`content_mobile` FROM `xb_content_details` WHERE `content_id` = 151 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` < 151 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.000900s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` > 151 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.000811s ]
UPDATE `xb_content` SET `hits` = `hits` + 1 WHERE ( `id` = 151 ) AND `xb_content`.`delete_time` IS NULL [ RunTime:0.004609s ]
SHOW FULL COLUMNS FROM `xb_comment` [ RunTime:0.001149s ]
SELECT COUNT(*) AS think_count FROM `xb_comment` WHERE `state` = 1 AND `source_id` = 151 AND `source_type` = 'template' LIMIT 1 [ RunTime:0.000769s ]
SELECT COUNT(*) AS think_count FROM `xb_content` `c` LEFT JOIN `xb_template_custom` `c2` ON `c`.`id`=`c2`.`content_id` WHERE ( `c`.`state` = '1' AND `c`.`home_menu_id` IN ('22','1') ) AND `c`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000783s ]
SELECT * FROM `xb_content` `c` LEFT JOIN `xb_template_custom` `c2` ON `c`.`id`=`c2`.`content_id` WHERE ( `c`.`state` = '1' AND `c`.`home_menu_id` IN ('22','1') ) AND `c`.`delete_time` IS NULL ORDER BY `sort` DESC LIMIT 0,8 [ RunTime:0.000908s ]
评论