SHOW FULL COLUMNS FROM `p8_school` [ RunTime:0.002540s ]
SELECT * FROM `p8_school` WHERE `sch_code_view` = '322185' LIMIT 1 [ RunTime:0.003717s ]
SHOW FULL COLUMNS FROM `p8_school_extend` [ RunTime:0.002453s ]
SELECT * FROM `p8_school_extend` WHERE `sch_code` = '12147' LIMIT 1 [ RunTime:0.008072s ]
SHOW FULL COLUMNS FROM `p8_school_yuanxi_major` [ RunTime:0.002428s ]
SELECT * FROM `p8_school_yuanxi_major` WHERE `sch_code` = '12147' [ RunTime:0.027125s ]
SHOW FULL COLUMNS FROM `p8_major` [ RunTime:0.002472s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('500301','500305','081804','460502','500303','500308','440301','440501','460110','460501','460510','500302','500601','500209','500307','500606','530301','530302','530503','530701','530802','500603','500604','500602','500212','500306','080202','500210','500211','460301','460305','460609','500408','500409','510102','510202','510204','510205','440106','500113','500304','550102','550106') [ RunTime:0.002745s ]
SHOW FULL COLUMNS FROM `p8_school_tsmajor` [ RunTime:0.002407s ]
SELECT * FROM `p8_school_tsmajor` WHERE `sch_code` = '12147' [ RunTime:0.004447s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('','460501','500301','500303') [ RunTime:0.002298s ]
