SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.006052s ]
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 100,20 [ RunTime:0.040230s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.005105s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (740,1359,1361,1380,1364,1377,1378,1369,1374,1381,1368,1360,1376,1373,1363,1365,1367,1408,1455,1438,1443) [ RunTime:0.003975s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004377s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (199,233,234,103,532,556,190,191,212,95,582,601,545,546,547,214,215,170,172,200,204,121,124,137,64,78,79,362,363,366) [ RunTime:0.003315s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003945s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,37,39,54) [ RunTime:0.003186s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004323s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 740 [ RunTime:0.004504s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003432s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004965s ]