SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004692s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 740 ) [ RunTime:1.232859s ]
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` = 740 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 220,20 [ RunTime:0.044415s ]
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 ('40702483','40701724','40701723','40701400','40700136','40699635','40699174','40698447','40698446','40698445','40698444','40698443','40696535','40696085','40695092','40695091','40695090','40693560','40693559','40693558') [ RunTime:0.003745s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004394s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (740,1438,1451,1443,1408,1442,1409,1440,1457,1447,1441,1445,1446,1449,1450) [ RunTime:0.003338s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004210s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (103,512,513,190,191,212,545,564,569,268,280,289,577,581,516,517,214,215,411,419,291,310,312,170,172,351,352,353,359,611,334,335,199,200,204) [ RunTime:0.003349s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003918s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (39,37,44,40) [ RunTime:0.003241s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004155s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 740 [ RunTime:0.004169s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003363s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004814s ]