SHOW FULL COLUMNS FROM `p8_school` [ RunTime:0.002429s ]
SELECT * FROM `p8_school` WHERE `sch_code_view` = '284732' LIMIT 1 [ RunTime:0.003247s ]
SHOW FULL COLUMNS FROM `p8_school_extend` [ RunTime:0.002323s ]
SELECT * FROM `p8_school_extend` WHERE `sch_code` = '11616' LIMIT 1 [ RunTime:0.005350s ]
SHOW FULL COLUMNS FROM `p8_school_yuanxi_major` [ RunTime:0.006863s ]
SELECT * FROM `p8_school_yuanxi_major` WHERE `sch_code` = '11616' [ RunTime:0.025501s ]
SHOW FULL COLUMNS FROM `p8_major` [ RunTime:0.002429s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('450401','450403','440501','440602','450101','450201','450204','450205','420301','430108','430101','430105','430106','430107','450303','460103','460104','460113','460202','460301','460305','080906','510101','510102','510201','510202','510205','510301','530701','460307','500603','500604','440402','440404','460306','500602','500201','440601','440102','440106','440301','440401','440502','440504','530301','530302','530601','530605','530802','530810','540106','590401','460703','500210','460702','460704','500211') [ RunTime:0.002725s ]
SHOW FULL COLUMNS FROM `p8_school_tsmajor` [ RunTime:0.008704s ]
SELECT * FROM `p8_school_tsmajor` WHERE `sch_code` = '11616' [ RunTime:0.004092s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('430105','430108','440102','460703','510102','510201') [ RunTime:0.002286s ]