SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004549s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 740 ) [ RunTime:0.683208s ]
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 240,20 [ RunTime:0.058843s ]
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 ('40692340','40692339','40692338','40689936','40426852','40426741','40426487','40426272','40425943','40425922','40425845','40425768','40425490','40425456','40425254','40425253','40424859','40424657','40424245','40424097') [ RunTime:0.003953s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004102s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (740,1408,1442,1438,1411,1417,1413,1432,1434,1433,1426,1430,1416,1425) [ RunTime:0.003196s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.003863s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (545,546,547,196,197,198,103,477,489,190,191,212,564,569,268,271,274,157,160,161,473,474,214,215,261,262,95,582,601) [ RunTime:0.003229s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003809s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (37,54,44,42) [ RunTime:0.003112s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004036s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 740 [ RunTime:0.004026s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003402s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004726s ]