SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000584s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000464s ]
SELECT * FROM `zx_course` WHERE `status` <> -1 AND `id` = 12 LIMIT 1 [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000450s ]
SELECT * FROM `zx_school` WHERE `status` <> -1 AND `id` = 4 LIMIT 1 [ RunTime:0.000272s ]
SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000421s ]
SELECT * FROM `zx_article` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000941s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000708s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `zx_tag` [ RunTime:0.000364s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 18 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 16 LIMIT 1 [ RunTime:0.000224s ]
UPDATE `zx_course` SET `click` = `click` + 1 WHERE `id` = 12 [ RunTime:0.002178s ]
SELECT * FROM `zx_course` WHERE `status` = 1 AND `school_id` = 4 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000369s ]
