SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004936s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `industry_category_id` = 64 ) [ RunTime:0.049010s ]
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 220,20 [ RunTime:0.065478s ]
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 ('42916031','42828214','42821533','42800944','42591629','42488645','42399187','42377989','42207892','42131395','37336093','37233709','37216541','36791986','36785416','36546971','36546819','36537849','36441088','36347365') [ RunTime:0.003735s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004358s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (2693,2695,2699,2825,2829,2812,2831,2814,2779,2792,2754,2765,2728,2750,2747,2694,2720,2708,2709,1589,1765,1769,1727,1739,1740,1666,1682,1675,1678,1611,1627,1618,1620,1616,1590,1610) [ RunTime:0.003373s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004180s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (64,65,66,75,81,68,69,78,79) [ RunTime:0.003259s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004141s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,37,84,39) [ RunTime:0.003252s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004449s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003481s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 64 [ RunTime:0.003460s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004824s ]