SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.036749s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 551 ) [ RunTime:2.668513s ]
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 ( `province_id` = 551 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 160,20 [ RunTime:0.059534s ]
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 ('7896032','7895970','7895969','7895909','7895823','7895241','7895158','7895157','7894989','7894988','7894682','7894323','7894186','7894033','7893898','7893295','7893294','7892871','7892562','7892411') [ RunTime:0.003677s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004350s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (551,726,727,731,729) [ RunTime:0.003303s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.003960s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (294,295,296,291,292,293,362,363,366,268,280,289,299,300,356,367,368,310,312,351,359,611) [ RunTime:0.003326s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004075s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,60,105) [ RunTime:0.004273s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004378s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 551 [ RunTime:0.004170s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003471s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004903s ]