[ SQL ] SHOW COLUMNS FROM `zqy_exhibition_company` [ RunTime:0.017124s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zqy_exhibition_company` `ex` LEFT JOIN `zqy_company` `c` ON `ex`.`company_id`=`c`.`id` LEFT JOIN `zqy_exhibition` `hui` ON `ex`.`exhibition_id`=`hui`.`id` WHERE `c`.`status` = 1 AND `ex`.`exhibition_id` = 0 [ RunTime:0.002114s ]
[ SQL ] SELECT `c`.`id`,`c`.`company_name`,`c`.`logo`,`c`.`company_en` FROM `zqy_exhibition_company` `ex` LEFT JOIN `zqy_company` `c` ON `ex`.`company_id`=`c`.`id` LEFT JOIN `zqy_exhibition` `hui` ON `ex`.`exhibition_id`=`hui`.`id` WHERE `c`.`status` = 1 AND `ex`.`exhibition_id` = 0 ORDER BY `ex`.`create_time`,`ex`.`is_top` DESC LIMIT 0,10 [ RunTime:0.000335s ]