SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004689s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `province_id` = 551 ) [ RunTime:7.109070s ]
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 180,20 [ RunTime:0.075306s ]
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 ('7892107','7891310','7891155','7890300','7890110','7889544','7889338','7889337','7888000','7887771','7887074','7886359','7885849','7884840','7883578','7883577','7883307','7882198','7882197','7881309') [ RunTime:0.004002s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004535s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (551,726,727,731,729) [ RunTime:0.003370s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004363s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (356,367,368,268,271,274,351,359,611,280,289,269,270,291,310,312,357,358,362,363,366,354,612) [ RunTime:0.003440s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004032s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (44,105,285,76,94) [ RunTime:0.003426s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004429s ]
SELECT * FROM `ent_region` WHERE `parent_id` = 551 [ RunTime:0.004947s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003548s ]
SELECT * FROM `ent_company_type` [ RunTime:0.005134s ]