SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004869s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `industry_category_id` = 193 ) [ RunTime:0.288361s ]
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 200,20 [ RunTime:0.106589s ]
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 ('48016218','48015624','48015616','48015605','48015600','48015599','47890742','47885446','47527251','47527245','47527243','47507570','46849765','46232745','45051209','44915801','44884185','44820706','44745745','44616682') [ RunTime:0.003776s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004585s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (748,749,1119,1115,877,912,914,403,404,2959,750,822,823,806,808,751,752,814,800,771,780) [ RunTime:0.003312s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004046s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (193,202,203,216,217,194,205,209,248) [ RunTime:0.003157s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004051s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,39,37,42,40) [ RunTime:0.003122s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.018967s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003538s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 193 [ RunTime:0.003489s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004971s ]