SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005218s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 209 ) [ RunTime:3.578959s ]
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` = 209 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 180,20 [ RunTime:0.108149s ]
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 ('17244783','17242149','17241135','17240117','17239773','17238737','17237675','17236233','17229091','17227029','17223400','17215834','17215833','17215832','17212096','17210149','17203976','17191719','17108635','17105577') [ RunTime:0.003595s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004183s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (209,2244,2247,2248,2235,2250,2246,2245,2251,2243) [ RunTime:0.003253s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.003905s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (157,160,161,95,582,601,548,549,550,103,473,474,351,359,611,268,271,274,196,197,198,199,200,204,475,511,121,122,123,190,214,215,545,546,547,564,569,269,270) [ RunTime:0.003351s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004347s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,37,93) [ RunTime:0.003241s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004126s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 209 [ RunTime:0.004543s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003431s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004829s ]