SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004740s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 382 ) [ RunTime:1.346545s ]
SELECT `id`,`name`,`credit_code`,`reg_status`,`legal_person`,`scale`,`company_type_id`,`reg_capital`,`capital_currency`,`establish_date`,`province_id`,`city_id`,`district_id`,`industry_category_id`,`industry_sector_id`,`industry_group_id`,`phone` FROM `ent_enterprise` WHERE ( `province_id` = 382 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 160,20 [ RunTime:0.029163s ]
SELECT `id`,`name`,`credit_code`,`reg_status`,`legal_person`,`scale`,`company_type_id`,`reg_capital`,`capital_currency`,`establish_date`,`province_id`,`city_id`,`district_id`,`industry_category_id`,`industry_sector_id`,`industry_group_id`,`phone` FROM `ent_enterprise` WHERE `id` IN ('28410034','28409432','28408742','28405625','28403856','28399461','28396962','28394496','28393562','28393337','28391992','28391215','28389779','28389406','28388321','28385917','28385916','28384400','28381313','28378697') [ RunTime:0.003831s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004368s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (382,383,399,388,396,384,387,389,397,395,398) [ RunTime:0.003257s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.003990s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (291,299,300,310,312,294,295,296,362,363,366,297,298,292,293) [ RunTime:0.003296s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003927s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,74,37,39,140,87) [ RunTime:0.003220s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004111s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 382 [ RunTime:0.004132s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003388s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004792s ]