SHOW FULL COLUMNS FROM `xb_content` [ RunTime:0.001136s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000698s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000736s ]
SELECT * FROM `xb_content` WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001018s ]
SHOW FULL COLUMNS FROM `xb_template_custom` [ RunTime:0.000955s ]
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.000706s ]
SHOW FULL COLUMNS FROM `xb_content_details` [ RunTime:0.000834s ]
SELECT `content`,`content_mobile` FROM `xb_content_details` WHERE `content_id` = 155 LIMIT 1 [ RunTime:0.000595s ]
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.000911s ]
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.001026s ]
UPDATE `xb_content` SET `hits` = `hits` + 1 WHERE ( `id` = 155 ) AND `xb_content`.`delete_time` IS NULL [ RunTime:0.004952s ]
SHOW FULL COLUMNS FROM `xb_comment` [ RunTime:0.001225s ]
SELECT COUNT(*) AS think_count FROM `xb_comment` WHERE `state` = 1 AND `source_id` = 155 AND `source_type` = 'template' LIMIT 1 [ RunTime:0.000786s ]
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.000810s ]
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.000954s ]
评论