SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005184s ]
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` = 64 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 180,20 [ RunTime:0.022497s ]
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 ('3691044','51666369','50158358','50153758','49839816','49838968','49832073','49794249','49751316','49710987','48243846','48227290','48206152','47984739','47503566','47072778','47017340','46897954','46896467','46849521') [ RunTime:0.003887s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.030981s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (551,601,738,2042,2043,2044,225,491,495,436,444,437,449,413,422,420,428,419,748,1127,749,1120,1119,877,878,887,944,946,934,935,912,920,921,915) [ RunTime:0.003581s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004542s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (64,68,69,86,87,65,66,78,79,75,81) [ RunTime:0.003447s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004457s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (37,44,40) [ RunTime:0.003397s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004888s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003701s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 64 [ RunTime:0.016641s ]
SELECT * FROM `ent_company_type` [ RunTime:0.005359s ]