SHOW FULL COLUMNS FROM `xb_content` [ RunTime:0.001219s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000674s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000592s ]
SELECT * FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000833s ]
SHOW FULL COLUMNS FROM `xb_template_custom` [ RunTime:0.001045s ]
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` = 156 LIMIT 1 [ RunTime:0.000633s ]
SHOW FULL COLUMNS FROM `xb_content_details` [ RunTime:0.000854s ]
SELECT `content`,`content_mobile` FROM `xb_content_details` WHERE `content_id` = 156 LIMIT 1 [ RunTime:0.000595s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` < 156 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` > 156 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.000907s ]
UPDATE `xb_content` SET `hits` = `hits` + 1 WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL [ RunTime:0.004512s ]
SHOW FULL COLUMNS FROM `xb_comment` [ RunTime:0.001115s ]
SELECT COUNT(*) AS think_count FROM `xb_comment` WHERE `state` = 1 AND `source_id` = 156 AND `source_type` = 'template' LIMIT 1 [ RunTime:0.000671s ]
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.000807s ]
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.000982s ]
评论