SHOW FULL COLUMNS FROM `p8_school` [ RunTime:0.002634s ]
SELECT * FROM `p8_school` WHERE `sch_code_view` = '255520' LIMIT 1 [ RunTime:0.002605s ]
SHOW FULL COLUMNS FROM `p8_school_extend` [ RunTime:0.002622s ]
SELECT * FROM `p8_school_extend` WHERE `sch_code` = '10216' LIMIT 1 [ RunTime:0.004231s ]
SHOW FULL COLUMNS FROM `p8_school_yuanxi_major` [ RunTime:0.002438s ]
SELECT * FROM `p8_school_yuanxi_major` WHERE `sch_code` = '10216' [ RunTime:0.029224s ]
SHOW FULL COLUMNS FROM `p8_major` [ RunTime:0.002531s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('080705','080702','080704','070202','080303','082107','080301','082103','080204','080202','080206','080801','080714','080703','080601','080701','080910','080901','080902','080904','080903','080803','080907','080403','080406','080402','080414','080412','070302','082502','081301','070101','070102','071202','083001','082601','071002','020401','120102','120203','020302','1202','120201','050209','050207','050261','050202','050201','050101','050303','130504','050306','130502','050103','130503','030302','030101') [ RunTime:0.002669s ]
SHOW FULL COLUMNS FROM `p8_school_tsmajor` [ RunTime:0.002433s ]
SELECT * FROM `p8_school_tsmajor` WHERE `sch_code` = '10216' [ RunTime:0.004632s ]
SELECT `code`,`level` FROM `p8_major` WHERE `code` IN ('080202','080301','080406','080705','080901','082107','030101','070102','080703') [ RunTime:0.002276s ]