SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005547s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `industry_category_id` = 193 ) [ RunTime:0.415120s ]
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` = 193 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 140,20 [ RunTime:0.022203s ]
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 ('2613546','2612149','2611868','2608490','2605458','2605456','2604809','2601748','2600320','2599297','2598957','2595367','2593199','2592539','2589695','2589394','2586897','2586054','2585752','2584343') [ RunTime:0.003893s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004456s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (551,726,729,735,733,727,732,734,731,725) [ RunTime:0.003485s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004079s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (193,202,203,194,205) [ RunTime:0.003310s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.003969s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (285,44,105,104,140,37) [ RunTime:0.003275s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004178s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003452s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 193 [ RunTime:0.003485s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004942s ]