SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004883s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `industry_category_id` = 103 ) [ RunTime:3.360960s ]
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` = 103 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 160,20 [ RunTime:0.048315s ]
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 ('42897768','42888242','42852762','42848236','42843253','42841584','42834431','42834208','42818378','42817587','42815944','42813909','42807350','42798348','42795381','42793524','42782625','42776119','42762873','42732604') [ RunTime:0.005229s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.005315s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (2693,2695,2697,2696,2825,2829,2826,2737,2822,2828,2827,2812,2813,2817,2806,2815,2814,2793,2809) [ RunTime:0.003364s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004372s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (103,170,172,477,489,431,444,393,394,411,419,107,109,341,342,104,110,450,459,522,523,334,335) [ RunTime:0.003390s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.005174s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (105,84,44) [ RunTime:0.003365s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.005435s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.004601s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 103 [ RunTime:0.004134s ]
SELECT * FROM `ent_company_type` [ RunTime:0.005696s ]