SHOW FULL COLUMNS FROM `xb_content` [ RunTime:0.001159s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000723s ]
SELECT `home_menu_id` FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000663s ]
SELECT * FROM `xb_content` WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000814s ]
SHOW FULL COLUMNS FROM `xb_template_custom` [ RunTime:0.000944s ]
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.000682s ]
SHOW FULL COLUMNS FROM `xb_content_details` [ RunTime:0.000938s ]
SELECT `content`,`content_mobile` FROM `xb_content_details` WHERE `content_id` = 156 LIMIT 1 [ RunTime:0.000577s ]
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.000854s ]
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.000922s ]
UPDATE `xb_content` SET `hits` = `hits` + 1 WHERE ( `id` = 156 ) AND `xb_content`.`delete_time` IS NULL [ RunTime:0.004581s ]
SHOW FULL COLUMNS FROM `xb_comment` [ RunTime:0.001213s ]
SELECT COUNT(*) AS think_count FROM `xb_comment` WHERE `state` = 1 AND `source_id` = 156 AND `source_type` = 'template' LIMIT 1 [ RunTime:0.000704s ]
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.000785s ]
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.001041s ]
评论