SHOW FULL COLUMNS FROM `xf_settings` [ RunTime:0.000625s ]
SELECT `value`,`key_name` FROM `xf_settings` [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `xf_infos` [ RunTime:0.000537s ]
SELECT `i`.*,`u`.`nickname`,`u`.`auth_status`,`u`.`avatar`,c.name category_name,`e`.`company_name`,`e`.`credit_code`,e.id enterprise_id 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` LEFT JOIN `xf_enterprises` `e` ON `e`.`user_id`=`i`.`user_id` WHERE `i`.`id` = '30' AND `i`.`status` = '2' LIMIT 1 [ RunTime:0.000496s ]
UPDATE `xf_infos` SET `view_count` = `view_count` + 1 WHERE `id` = '30' [ RunTime:0.006762s ]
SHOW FULL COLUMNS FROM `xf_info_images` [ RunTime:0.004702s ]
SELECT * FROM `xf_info_images` WHERE `info_id` = '30' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004817s ]
SHOW FULL COLUMNS FROM `xf_info_attachments` [ RunTime:0.003090s ]
SELECT * FROM `xf_info_attachments` WHERE `info_id` = '30' ORDER BY `id` ASC [ RunTime:0.001936s ]
SHOW FULL COLUMNS FROM `xf_contact_unlocks` [ RunTime:0.000986s ]
SELECT COUNT(*) AS think_count FROM `xf_contact_unlocks` WHERE `user_id` = '0' AND `unlock_token` = 'e5e60db41e287a8945540e7880d2f0fd493e9ec0504a4ae3' AND `info_id` = '30' AND `pay_status` = 1 [ RunTime:0.000445s ]
SELECT COUNT(*) AS think_count FROM `xf_contact_unlocks` WHERE `user_id` = '0' AND `unlock_token` = 'e5e60db41e287a8945540e7880d2f0fd493e9ec0504a4ae3' AND `info_id` = '30' AND `pay_status` = 1 [ RunTime:0.000726s ]
SELECT `i`.`id`,`i`.`title`,`i`.`summary`,`i`.`content`,`i`.`view_count`,`i`.`quote_count`,`i`.`allow_quote`,`i`.`is_recommend`,`i`.`published_at`,`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`.`id` <> '30' ORDER BY `i`.`is_recommend` DESC,`i`.`is_top` DESC,`i`.`view_count` DESC,`i`.`published_at` DESC,`i`.`id` DESC LIMIT 5 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `xf_categories` [ RunTime:0.000431s ]
SELECT * FROM `xf_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `xf_product_categories` [ RunTime:0.000391s ]
SELECT * FROM `xf_product_categories` WHERE `status` = 1 ORDER BY `parent_id` ASC,`sort` ASC,`id` ASC [ RunTime:0.000482s ]