[ SQL ] SHOW COLUMNS FROM `hx_hook_plugin` [ RunTime:0.000468s ]
[ SQL ] SELECT `hook`,`plugin` FROM `hx_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `hx_portal_post` [ RunTime:0.000659s ]
[ SQL ] SELECT `post`.*,`relation`.`category_id` FROM `hx_portal_post` `post` LEFT JOIN `hx_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE ( post.post_type=1 and post.post_status=1 and post.delete_time=0 and post.id=4 ) GROUP BY `relation`.`category_id` LIMIT 1 [ RunTime:0.000972s ]
[ SQL ] SELECT `post`.* FROM `hx_portal_post` `post` WHERE ( post.post_type=1 and post.post_status=1 and post.delete_time=0 and post.id<4 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT `post`.* FROM `hx_portal_post` `post` WHERE ( post.post_type=1 and post.post_status=1 and post.delete_time=0 and post.id>4 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SHOW COLUMNS FROM `hx_goods` [ RunTime:0.000498s ]
[ SQL ] SELECT g.*,min(category_post.category_id) as category_id FROM `hx_goods` `g` LEFT JOIN `hx_user` `user` ON `g`.`user_id`=`user`.`id` LEFT JOIN `hx_goods_category_post` `category_post` ON `g`.`id`=`category_post`.`post_id` WHERE ( g.post_status=1 and g.post_type=1 and g.delete_time=0 and g.lang="zh-cn" ) AND ( g.recommended=1 ) GROUP BY `g`.`id` ORDER BY `g`.`post_hits` DESC LIMIT 5 [ RunTime:0.002179s ]
