SHOW FULL COLUMNS FROM `xb_content` [ RunTime:0.001452s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000768s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000840s ]
SELECT * FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001365s ]
SHOW FULL COLUMNS FROM `xb_template_custom` [ RunTime:0.001181s ]
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` = 155 LIMIT 1 [ RunTime:0.001003s ]
SHOW FULL COLUMNS FROM `xb_content_details` [ RunTime:0.001191s ]
SELECT `content`,`content_mobile` FROM `xb_content_details` WHERE `content_id` = 155 LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` < 155 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` DESC LIMIT 1 [ RunTime:0.001206s ]
SELECT * FROM `xb_content` WHERE ( `home_menu_id` = 1 AND `state` = 1 AND `id` > 155 ) AND `xb_content`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.001674s ]
UPDATE `xb_content` SET `hits` = `hits` + 1 WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL [ RunTime:0.005162s ]
SHOW FULL COLUMNS FROM `xb_comment` [ RunTime:0.001568s ]
SELECT COUNT(*) AS think_count FROM `xb_comment` WHERE `state` = 1 AND `source_id` = 155 AND `source_type` = 'template' LIMIT 1 [ RunTime:0.000911s ]
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.002046s ]
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.001833s ]
评论