SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.006148s ]
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 ( `industry_category_id` = 291 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 40,20 [ RunTime:0.004304s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004346s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (2693,2754,2765,2740,2741,2730,2732,2728,2729,2708,2709,2695,2701,218,219,2471,1346,3280,3282,3234,3300,3303,2042,2057,2066,225,409,499,491,501,488,489,407,494) [ RunTime:0.021332s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004252s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (291,310,312,299,300,292,293) [ RunTime:0.003346s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.006438s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (105,44,37,60) [ RunTime:0.003382s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.006119s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003703s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 291 [ RunTime:0.003657s ]
SELECT * FROM `ent_company_type` [ RunTime:0.006170s ]