SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004707s ]
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 120,20 [ RunTime:0.004344s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004290s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (740,1438,1457,1450,1440,1443,1452,1447,1408,1456,1442,1449,1409,1451,1458) [ RunTime:0.003375s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004120s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (548,552,553,103,341,342,356,357,358,190,214,215,268,271,274,545,577,581,170,172,199,200,204,334,335,546,547,95,582,601,191,212,104,110,121,133,138,173,263,411,419,362,363,366) [ RunTime:0.003383s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004301s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (75,44,54,55,37,59,42) [ RunTime:0.003319s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.005041s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 740 [ RunTime:0.004727s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003548s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004897s ]