SHOW FULL COLUMNS FROM `xf_settings` [ RunTime:0.000496s ]
SELECT `value`,`key_name` FROM `xf_settings` [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `xf_infos` [ RunTime:0.000409s ]
SELECT COUNT(*) AS think_count FROM `xf_infos` `i` LEFT JOIN `xf_users` `u` ON `u`.`id`=`i`.`user_id` LEFT JOIN `xf_categories` `c` ON `c`.`id`=`i`.`category_id` WHERE `i`.`status` = '2' AND `i`.`category_id` = '12' AND `i`.`info_type` = '1' [ RunTime:0.000405s ]
SELECT `i`.*,`u`.`nickname`,`u`.`auth_status`,c.name category_name FROM `xf_infos` `i` LEFT JOIN `xf_users` `u` ON `u`.`id`=`i`.`user_id` LEFT JOIN `xf_categories` `c` ON `c`.`id`=`i`.`category_id` WHERE `i`.`status` = '2' AND `i`.`category_id` = '12' AND `i`.`info_type` = '1' ORDER BY `i`.`is_top` DESC,`i`.`published_at` DESC,`i`.`id` DESC LIMIT 0,12 [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `xf_categories` [ RunTime:0.000370s ]
SELECT * FROM `xf_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `xf_product_categories` [ RunTime:0.000340s ]
SELECT * FROM `xf_product_categories` WHERE `status` = 1 ORDER BY `parent_id` ASC,`sort` ASC,`id` ASC [ RunTime:0.000424s ]