SHOW FULL COLUMNS FROM `xf_settings` [ RunTime:0.001266s ]
SELECT `value`,`key_name` FROM `xf_settings` [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `xf_product_categories` [ RunTime:0.000646s ]
SELECT `id` FROM `xf_product_categories` WHERE `parent_id` = '3' AND `status` = 1 [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `xf_products` [ RunTime:0.000676s ]
SELECT COUNT(*) AS think_count FROM `xf_products` `p` LEFT JOIN `xf_shops` `s` ON `s`.`id`=`p`.`shop_id` LEFT JOIN `xf_product_categories` `c` ON `c`.`id`=`p`.`category_id` WHERE `p`.`status` = '2' AND `s`.`status` = '1' AND `p`.`deleted_at` IS NULL AND ( `p`.`title` LIKE '%新品%' OR `p`.`summary` LIKE '%新品%' OR `p`.`content` LIKE '%新品%' ) AND `p`.`category_id` IN ('3','26','27','28','29','30','31') [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `xf_categories` [ RunTime:0.000705s ]
SELECT * FROM `xf_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000366s ]
SELECT * FROM `xf_product_categories` WHERE `status` = 1 ORDER BY `parent_id` ASC,`sort` ASC,`id` ASC [ RunTime:0.000338s ]