SHOW FULL COLUMNS FROM `hkhe_pecentre` [ RunTime:0.001133s ]
SELECT `a`.`peid`,`a`.`normal_name`,`a`.`logo_path`,`a`.`label`,`a`.`details`,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,`a`.`hospital_detail`,`a`.`open_start`,`a`.`open_end`,`a`.`chengcheluxian` 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`.`peid` = '0' LIMIT 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `hkhe_gp_dic` [ RunTime:0.000452s ]
SELECT `b`.`peid`,`b`.`normal_name`,`b`.`logo_path`,c.area_name as province,d.area_name as city,e.area_name as area,`b`.`address` FROM `hkhe_gp_dic` `a` INNER JOIN `hkhe_pecentre` `b` ON `b`.`peid`=`a`.`son_org_id` INNER JOIN `hkhe_area` `c` ON `c`.`area_id`=`b`.`province` INNER JOIN `hkhe_area` `d` ON `d`.`area_id`=`b`.`city` INNER JOIN `hkhe_area` `e` ON `e`.`area_id`=`b`.`area` WHERE `a`.`goods_id` = '2563' AND `b`.`state` = '1' AND `b`.`is_hide` = '0' AND `b`.`parent_id` > '0' ORDER BY `b`.`sort` ASC,`b`.`peid` DESC [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `hkhe_goods` [ RunTime:0.000721s ]
SELECT `gid`,`normal_name`,`now_price`,`market_price`,`image`,`describe`,`target_gender`,`marital_status` FROM `hkhe_goods` WHERE `gid` = 2563 LIMIT 1 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `hkhe_mei_group` [ RunTime:0.000459s ]
SELECT `meigroup`.`id`,`meigroup`.`relation_type`,`meigroup`.`relation_value`,`meigroup`.`category_id`,`meigroup`.`custom_name`,`meigroup`.`price`,`meigroup`.`inspection_meaning`,`cate`.`name` FROM `hkhe_mei_group` `meigroup` LEFT JOIN `hkhe_medical_examination_category` `cate` ON `meigroup`.`category_id`=`cate`.`id` WHERE `meigroup`.`relation_type` = '2' AND `meigroup`.`relation_value` = '2563' LIMIT 0,1000 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `hkhe_mei_group_item` [ RunTime:0.000422s ]
SELECT `item`.`category_id`,category.name as category_name,`groupitem`.`medical_examination_item_id`,`item`.`name` FROM `hkhe_mei_group_item` `groupitem` LEFT JOIN `hkhe_medical_examination_item` `item` ON `groupitem`.`medical_examination_item_id`=`item`.`id` LEFT JOIN `hkhe_medical_examination_category` `category` ON `item`.`category_id`=`category`.`id` WHERE `groupitem`.`package_id` = '50673' [ RunTime:0.000537s ]