SHOW FULL COLUMNS FROM `hkhe_pecentre` [ RunTime:0.001042s ]
SELECT COUNT(*) AS think_count FROM `hkhe_pecentre` `a` INNER JOIN `hkhe_area` `b` ON `b`.`area_id`=`a`.`province` INNER JOIN `hkhe_area` `c` ON `c`.`area_id`=`a`.`city` INNER JOIN `hkhe_area` `d` ON `d`.`area_id`=`a`.`area` WHERE `a`.`state` = '1' AND `a`.`is_hide` = '0' AND `a`.`parent_id` > '0' LIMIT 1 [ RunTime:0.000302s ]
SELECT `a`.`peid`,`a`.`normal_name`,`a`.`logo_path`,`a`.`label`,b.area_name as province,c.area_name as city,d.area_name as area,`a`.`address`,concat(b.area_name,c.area_name,d.area_name,a.address) as all_address FROM `hkhe_pecentre` `a` INNER JOIN `hkhe_area` `b` ON `b`.`area_id`=`a`.`province` INNER JOIN `hkhe_area` `c` ON `c`.`area_id`=`a`.`city` INNER JOIN `hkhe_area` `d` ON `d`.`area_id`=`a`.`area` WHERE `a`.`state` = '1' AND `a`.`is_hide` = '0' AND `a`.`parent_id` > '0' ORDER BY `sort` ASC,`peid` DESC LIMIT 0,4 [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `hkhe_gp_dic` [ RunTime:0.000390s ]
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' GROUP BY `b`.`gid` ) `_group_count_` LIMIT 1 [ RunTime:0.000260s ]
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' GROUP BY `b`.`gid` ORDER BY `b`.`display_sort` DESC,`b`.`sale_num` DESC LIMIT 0,4 [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `hkhe_article` [ RunTime:0.000412s ]
SELECT COUNT(*) AS think_count FROM `hkhe_article` `a` INNER JOIN `hkhe_art_classify` `b` ON `a`.`classify_id`=`b`.`id` WHERE `a`.`is_hidden` = '0' AND `a`.`classify_id` IN ('20','21') LIMIT 1 [ RunTime:0.000189s ]
SELECT `a`.`id`,`a`.`title`,`a`.`image_path`,`a`.`describe`,FROM_UNIXTIME(a.create_time,"%Y-%m-%d") as create_time,b.name as cate_name FROM `hkhe_article` `a` INNER JOIN `hkhe_art_classify` `b` ON `a`.`classify_id`=`b`.`id` WHERE `a`.`is_hidden` = '0' AND `a`.`classify_id` IN ('20','21') ORDER BY `a`.`id` DESC LIMIT 0,2 [ RunTime:0.000155s ]