SHOW FULL COLUMNS FROM `p8_school` [ RunTime:0.015440s ]
SELECT * FROM `p8_school` WHERE `sch_code_view` = '724733' LIMIT 1 [ RunTime:0.021307s ]
SHOW FULL COLUMNS FROM `p8_school_extend` [ RunTime:0.012318s ]
SELECT * FROM `p8_school_extend` WHERE `sch_code` = '11931' LIMIT 1 [ RunTime:0.015577s ]
SHOW FULL COLUMNS FROM `p8_school_yuanxi_major` [ RunTime:0.004664s ]
SELECT * FROM `p8_school_yuanxi_major` WHERE `sch_code` = '11931' [ RunTime:0.024889s ]
SHOW FULL COLUMNS FROM `p8_major` [ RunTime:0.002394s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('090203','090501','410108','410201','410211','420301','450401','420801','420802','420804','420805','420806','490104','410105','410202','440104','440105','440301','440501','530102','530302','530605','530701','530802','440106','550105','550113','550114','510101','510102','510106','510202','510203','510204','510209','510215','510301','540106','570102','570201','570301','120901','500113','540109','460103','460104','460113','460202','460301','460305','460701','460702','460703','500210','500211','510103','480103','510108','550104','550115') [ RunTime:0.002654s ]
SHOW FULL COLUMNS FROM `p8_school_tsmajor` [ RunTime:0.002369s ]
SELECT * FROM `p8_school_tsmajor` WHERE `sch_code` = '11931' [ RunTime:0.004287s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('410201','410202','420801','420802','440106','530102','550115') [ RunTime:0.002347s ]