SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.005001s ]
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` = 121 ) ORDER BY `establish_date` DESC,`id` DESC LIMIT 120,20 [ RunTime:0.015284s ]
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 ('42479899','42456545','42399188','42279764','42245012','42212110','42174473','24358479','24354409','24339495','24316804','24267665','24244644','24019194','24008770','23958589','23730770','23718642','23698283','23553262') [ RunTime:0.004230s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.006193s ]
SELECT `name`,`id` FROM `ent_region` WHERE `id` IN (2693,2754,2766,2728,2750,2730,2733,2708,2723,2694,2707,2714,218,2616,2623,2621,2619,2653,2652,2605,2606,2603,2610,2579,2588,2571,2598,2567,2591,2532,2533,2545,2547,2516,2520) [ RunTime:0.003536s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.004459s ]
SELECT `name`,`id` FROM `ent_industry` WHERE `id` IN (121,135,136,124,137,133,138,129,130,125) [ RunTime:0.003312s ]
SHOW FULL COLUMNS FROM `ent_company_type` [ RunTime:0.004158s ]
SELECT `name`,`id` FROM `ent_company_type` WHERE `id` IN (105,84,44,37,40,54) [ RunTime:0.003300s ]
SELECT * FROM `ent_region` WHERE `level` = 1 ORDER BY `sort` [ RunTime:0.004668s ]
SELECT * FROM `ent_industry` WHERE `level` = 1 [ RunTime:0.003925s ]
SELECT * FROM `ent_industry` WHERE `parent_id` = 121 [ RunTime:0.003782s ]
SELECT * FROM `ent_company_type` [ RunTime:0.004957s ]