SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004755s ]
SELECT COUNT(*) AS think_count FROM `ent_enterprise` WHERE ( `scale` = '大型' ) [ RunTime:3.506258s ]
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 ( `scale` = '大型' ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.013890s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.004364s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (2693,2695,2699,2698,2825,2826,2710,2836,2837,2843,2916,2953,2737,2822,2779,2782,218,219,2465,2619,2624,2605,2606,2571,2592,2532,2547,2534,2538,2508,2509,2501,2502,235,2497,236) [ RunTime:0.003326s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004911s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (268,271,274,103,446,447,196,197,198,64,68,69,199,200,204,269,270,512,513,121,133,138,57,58,507,545,546,547,135,136,193,194,205,475,511,157,158,164,564,569) [ RunTime:0.004040s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004349s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (105,44,48,37,39,40) [ RunTime:0.003315s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004778s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003521s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004856s ]