SHOW FULL COLUMNS FROM `hkhe_pecentre` [ RunTime:0.003124s ]
SELECT `b`.`area_id`,`b`.`area_name` FROM `hkhe_pecentre` `a` INNER JOIN `hkhe_area` `b` ON `a`.`area`=`b`.`area_id` WHERE `a`.`state` = '1' AND `a`.`is_hide` = '0' AND `a`.`parent_id` > '0' AND `b`.`area_parent_id` = '0' GROUP BY `a`.`area` [ RunTime:0.000878s ]
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.000296s ]
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 336,8 [ RunTime:0.004129s ]