[ DB ] CONNECT:[ UseTime:0.012801s ] mysql:host=47.97.231.216;dbname=yibohui_dev;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `exhibitor` [ RunTime:0.010400s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM ( SELECT e.*,p.create_time as product_time,p.image as product_image,p.title_cn as product_title,
(select GROUP_CONCAT(cate_name_cn) from exhibitor_category_map as ecm left join product_category as pc on pc.id = ecm.category_id where ecm.exhibitor_id = e.id) as cate_list
FROM `exhibitor` `e` LEFT JOIN `product` `p` ON `p`.`exhibitor_id`=`e`.`id` WHERE `company_cn` <> '' AND `e`.`status` = 1 ORDER BY is_top desc,sort desc,expo_id desc,product_time desc LIMIT 0,999999 ) as a GROUP BY `a`.`company_id` ) `_group_count_` [ RunTime:0.008648s ]
[ SQL ] SELECT * FROM ( SELECT e.*,p.create_time as product_time,p.image as product_image,p.title_cn as product_title,
(select GROUP_CONCAT(cate_name_cn) from exhibitor_category_map as ecm left join product_category as pc on pc.id = ecm.category_id where ecm.exhibitor_id = e.id) as cate_list
FROM `exhibitor` `e` LEFT JOIN `product` `p` ON `p`.`exhibitor_id`=`e`.`id` WHERE `company_cn` <> '' AND `e`.`status` = 1 ORDER BY is_top desc,sort desc,expo_id desc,product_time desc LIMIT 0,999999 ) as a GROUP BY `a`.`company_id` ORDER BY is_top desc,sort desc,expo_id desc,product_time desc LIMIT 1239,21 [ RunTime:0.104792s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.009715s ]
[ SQL ] SELECT * FROM `product` WHERE `status` = 1 AND `exhibitor_id` IN (1037,1038,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1055,1056,1057,1058,1059) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.008945s ]
首页 
关于医博会
展会概况
展商中心
观众中心
媒体中心
网上展厅
商旅服务
同期活动
联系我们
大健康品牌展
