SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005614s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 241 ) [ RunTime:1.192606s ]
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` = 241 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 180,20 [ RunTime:0.047284s ]
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 ('26165070','26165069','26164946','26164841','26164840','26164456','26164197','26163642','26163487','26163486','26163059','26162586','26162585','26161398','26161064','26161063','26161062','26160862','26160861','26160652') [ RunTime:0.003575s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004362s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (241,242,248,249,250,247) [ RunTime:0.003279s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.006133s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (95,582,601,268,271,274,190,191,212,294,302,303,103,411,419,545,564,569,121,133,138,57,58,507,291,292,293,214,215,546,547,351,354,612,157,160,161,199,233,234) [ RunTime:0.003449s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003847s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,37,39) [ RunTime:0.003174s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004109s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 241 [ RunTime:0.004087s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003364s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004744s ]