[ DB ] CONNECT:[ UseTime:0.012531s ] mysql:host=47.97.231.216;dbname=yibohui_dev;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `expo` [ RunTime:0.010304s ]
[ SQL ] SELECT * FROM `expo` WHERE `status` = 1 ORDER BY `id` DESC [ RunTime:0.008443s ]
[ SQL ] SHOW COLUMNS FROM `menu` [ RunTime:0.010059s ]
[ SQL ] SELECT `m`.*,`i`.`name`,`i`.`outlink`,`i`.`target` FROM `menu` `m` LEFT JOIN `menu_info` `i` ON `m`.`id`=`i`.`menu_id` WHERE `m`.`status` = 1 AND `i`.`lang` = 'cn' ORDER BY `m`.`pid`,`m`.`sort` DESC,`m`.`id` [ RunTime:0.016420s ]
[ SQL ] SHOW COLUMNS FROM `siteinfo` [ RunTime:0.009954s ]
[ SQL ] SELECT `config_name`,`config_value` FROM `siteinfo` WHERE `status` = 1 [ RunTime:0.008414s ]
[ SQL ] SHOW COLUMNS FROM `exhibitor` [ RunTime:0.010187s ]
[ 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.008381s ]
[ 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 483,21 [ RunTime:0.008579s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.009628s ]
[ SQL ] SELECT * FROM `product` WHERE `status` = 1 AND `exhibitor_id` IN (1308,2466,1466,1373,1465,1409,1463,1260,1276,1362,1461,1462,1311,1439,1251,1352,1458,1332,1454,1329,1457) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.016428s ]
[ SQL ] SHOW COLUMNS FROM `country` [ RunTime:0.009245s ]
[ SQL ] SELECT * FROM `country` WHERE `status` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.012193s ]
[ SQL ] SHOW COLUMNS FROM `product_category` [ RunTime:0.009661s ]
[ SQL ] SELECT * FROM `product_category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.008295s ]
[ SQL ] SHOW COLUMNS FROM `industry` [ RunTime:0.009320s ]
[ SQL ] SELECT * FROM `industry` WHERE `status` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.008156s ]