SHOW FULL COLUMNS FROM `ent_enterprise` [ RunTime:0.004602s ]
SELECT * FROM `ent_enterprise` WHERE `credit_code` = '12420111YA2110805U' LIMIT 1 [ RunTime:0.012616s ]
SHOW FULL COLUMNS FROM `ent_industry` [ RunTime:0.021255s ]
SELECT `name` FROM `ent_industry` WHERE `id` = 291 LIMIT 1 [ RunTime:0.020806s ]
SELECT `name` FROM `ent_industry` WHERE `id` = 299 LIMIT 1 [ RunTime:0.041306s ]
SHOW FULL COLUMNS FROM `ent_region` [ RunTime:0.011908s ]
SELECT `name` FROM `ent_region` WHERE `id` = 221 LIMIT 1 [ RunTime:0.016250s ]
SELECT `name` FROM `ent_region` WHERE `id` = 1586 LIMIT 1 [ RunTime:0.018132s ]
SHOW FULL COLUMNS FROM `ent_enterprise_detail` [ RunTime:0.015513s ]
SELECT * FROM `ent_enterprise_detail` WHERE `enterprise_id` = '31398719' LIMIT 1 [ RunTime:0.013170s ]
SELECT `id`,`name`,`credit_code` FROM `ent_enterprise` FORCE INDEX ( idx_neighbor ) WHERE `city_id` = 1586 AND `industry_category_id` = 291 AND `id` <> '31398719' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.004149s ]