SHOW FULL COLUMNS FROM `hkhe_pecentre` [ RunTime:0.001007s ]
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` = '1762' LIMIT 1 [ RunTime:0.000292s ]
SHOW FULL COLUMNS FROM `hkhe_hosp_business_hours_time` [ RunTime:0.000456s ]
SELECT `w`.`son_org_id`,`w`.`start_week`,`w`.`end_week`,`t`.`bhw_id`,`t`.`start_time`,`t`.`end_time`,`t`.`special_type`,`t`.`invalid_goods`,`t`.`remark` FROM `hkhe_hosp_business_hours_time` `t` LEFT JOIN `hkhe_hosp_business_hours_week` `w` ON `t`.`bhw_id`=`w`.`id` WHERE `t`.`is_active` = '1' AND `w`.`is_active` = '1' AND `w`.`son_org_id` = '1762' ORDER BY `w`.`start_week` ASC,`t`.`start_time` ASC [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `hkhe_goods` [ RunTime:0.000668s ]
SELECT `gid`,`normal_name`,`now_price`,`market_price`,`image`,`describe`,`target_gender`,`marital_status` FROM `hkhe_goods` WHERE `gid` = 41 LIMIT 1 [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `hkhe_goods_price` [ RunTime:0.000382s ]
SELECT `sale_price` FROM `hkhe_goods_price` WHERE `son_org_id` = 1762 AND `goods_id` = 41 LIMIT 1 [ RunTime:0.000635s ]
SELECT `spread_priceclassify` FROM `hkhe_goods` WHERE `gid` = 41 LIMIT 1 [ RunTime:0.000163s ]
SHOW FULL COLUMNS FROM `hkhe_srm_goods` [ RunTime:0.000441s ]
SELECT `srm`.*,org.id as org_srm_id,org.title as org_title,`org`.`official_org_id` FROM `hkhe_srm_goods` `srm` LEFT JOIN `hkhe_org_contract` `org` ON `srm`.`supplier_id`=`org`.`id` WHERE `goods_group_id` = 9 AND `org`.`official_org_id` = '1762' LIMIT 1 [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `hkhe_mei_group` [ RunTime:0.000407s ]
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` = '1' AND `meigroup`.`relation_value` = '47' LIMIT 0,1000 [ RunTime:0.000528s ]
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` = '41' LIMIT 0,1000 [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `hkhe_mei_group_item` [ RunTime:0.000367s ]
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` = '40827' [ RunTime:0.000197s ]
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` = '40828' [ RunTime:0.000180s ]
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` = '40829' [ RunTime:0.000179s ]
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` = '40830' [ RunTime:0.000207s ]
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` = '40831' [ RunTime:0.000189s ]
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` = '40832' [ RunTime:0.000181s ]
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` = '40833' [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `hkhe_medical_examination_category` [ RunTime:0.000359s ]
SELECT `id`,`significance` FROM `hkhe_medical_examination_category` WHERE `id` IN (14,33,6,43) [ RunTime:0.000147s ]