SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.006157s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 382 ) [ RunTime:0.511090s ]
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 140,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 ('28440089','28440088','28440087','28440086','28430334','28427668','28427667','28427666','28423425','28423424','28420663','28419005','28413070','28412026','28411784','28411458','28411217','28410796','28410036','28410035') [ RunTime:0.003769s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004484s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (382,383,392,399,384,395,385,387,396,386,397,389) [ RunTime:0.003280s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004031s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (351,359,611,352,353,356,367,368,291,299,300,294,295,296) [ RunTime:0.003300s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004091s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (37,39,44,54) [ RunTime:0.003270s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004448s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 382 [ RunTime:0.004253s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003533s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004894s ]