SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004880s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `industry_category_id` = 294 ) [ RunTime:0.313638s ]
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` = 294 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 180,20 [ RunTime:0.042050s ]
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 ('7519284','7479410','7462220','7438732','7420212','7410734','7409666','7360091','7345219','7315098','7309113','7298420','7279018','3301829','3284231','3284228','52160558','52122845','52052334','52004531') [ RunTime:0.003679s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004269s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (551,725,726,734,735,686,708,691,714,685,687,684,690,699,700,696,705,657,683,711,601,605,604,1346,3308,3309,3328,3329,3280,3283,3234,3300,3307) [ RunTime:0.003411s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004321s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (294,295,296,297,298,308,309,302,303) [ RunTime:0.003287s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004231s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,105,37,39,54) [ RunTime:0.003254s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004506s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003577s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 294 [ RunTime:0.003575s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004820s ]