SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005966s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `scale` = '大型' ) [ RunTime:0.836674s ]
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 ( `scale` = '大型' ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 40,20 [ RunTime:0.016716s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004336s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (218,2501,2502,235,2497,236,219,2480,2478,2473,2466,2470,2472,2463,2990,3084,3085,225,409,499,488,489,423,435,426,748,1121,1139,749,1120,1119) [ RunTime:0.003430s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004045s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (103,475,511,157,158,164,545,564,569,95,582,601,196,197,198,193,202,203,548,549,550,268,280,289,121,135,136,190,191,212,199,200,204,104,110,546,547,57,70,71,393,394) [ RunTime:0.003459s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004262s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (40,37,44,48,39,76,46) [ RunTime:0.003323s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004215s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003538s ]
SELECT * FROM `ent_company_type` [ RunTime:0.007553s ]