SHOW FULL COLUMNS FROM `p8_school` [ RunTime:0.002512s ]
SELECT * FROM `p8_school` WHERE `sch_code_view` = '759326' LIMIT 1 [ RunTime:0.003358s ]
SHOW FULL COLUMNS FROM `p8_school_extend` [ RunTime:0.003699s ]
SELECT * FROM `p8_school_extend` WHERE `sch_code` = '11570' LIMIT 1 [ RunTime:0.007128s ]
SHOW FULL COLUMNS FROM `p8_school_yuanxi_major` [ RunTime:0.002339s ]
SELECT * FROM `p8_school_yuanxi_major` WHERE `sch_code` = '11570' [ RunTime:0.024638s ]
SHOW FULL COLUMNS FROM `p8_major` [ RunTime:0.002411s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('460303','440402','460306','510103','510203','510204','510205','080601','130505','480108','480402','550105','550125','550217','480401','480404','480406','480411','470101','480405','420802','430602','530302','530501','530602','530701','530702','530802','530810','540105','540106','570201','570203','570207','540101','550101','550102','550103','550104','550112','460206','460301','460305','460702','460101','440102','440301','440403','440501','550106') [ RunTime:0.002571s ]
SHOW FULL COLUMNS FROM `p8_school_tsmajor` [ RunTime:0.002414s ]
SELECT * FROM `p8_school_tsmajor` WHERE `sch_code` = '11570' [ RunTime:0.004221s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('460306','480405','480411','530302') [ RunTime:0.002344s ]