SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004934s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 740 ) [ RunTime:1.253717s ]
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 200,20 [ RunTime:0.034659s ]
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 ('40710255','40710035','40707581','40707388','40707200','40707199','40707198','40706995','40706287','40706286','40705733','40705542','40704162','40704161','40703281','40702946','40702800','40702620','40702619','40702618') [ RunTime:0.004547s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004374s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (740,1438,1451,1443,1408,1456,1445,1460,1440,1409,1442,1441,1455,1449,1450,1458) [ RunTime:0.003200s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004023s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (95,582,601,190,191,212,214,215,57,70,71,199,200,204,121,124,137,135,136,268,271,274,351,354,612,548,549,550,58,507,545,577,581) [ RunTime:0.003295s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003967s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (37,44,39,55) [ RunTime:0.003169s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004056s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 740 [ RunTime:0.004059s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003302s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004681s ]