SHOW FULL COLUMNS FROM `hkhe_category` [ RunTime:0.000626s ]
SELECT * FROM `hkhe_category` WHERE `ctype` = 1 AND `miniapp_display` = 1 ORDER BY `sortby` ASC [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `hkhe_gp_dic` [ RunTime:0.000509s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `hkhe_gp_dic` `a` INNER JOIN `hkhe_goods` `b` ON `b`.`gid`=`a`.`goods_id` INNER JOIN `hkhe_pecentre` `c` ON `c`.`peid`=`a`.`son_org_id` WHERE `b`.`state` = '1' AND `b`.`is_normal` = '1' AND `b`.`category_id` = '14' GROUP BY `b`.`gid` ) `_group_count_` LIMIT 1 [ RunTime:0.002325s ]
SELECT `b`.`gid`,`b`.`normal_name`,`b`.`now_price`,`b`.`market_price`,`b`.`image`,`b`.`describe`,`a`.`son_org_id` FROM `hkhe_gp_dic` `a` INNER JOIN `hkhe_goods` `b` ON `b`.`gid`=`a`.`goods_id` INNER JOIN `hkhe_pecentre` `c` ON `c`.`peid`=`a`.`son_org_id` WHERE `b`.`state` = '1' AND `b`.`is_normal` = '1' AND `b`.`category_id` = '14' GROUP BY `b`.`gid` ORDER BY `b`.`display_sort` DESC,`b`.`sale_num` DESC LIMIT 0,8 [ RunTime:0.001241s ]