SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000598s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000478s ]
SELECT * FROM `zx_course` WHERE `status` <> -1 AND `id` = 70 LIMIT 1 [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000480s ]
SELECT * FROM `zx_school` WHERE `status` <> -1 AND `id` = 1 LIMIT 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000453s ]
SELECT * FROM `zx_article` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000955s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `zx_tag` [ RunTime:0.000387s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 19 LIMIT 1 [ RunTime:0.000264s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 16 LIMIT 1 [ RunTime:0.000244s ]
UPDATE `zx_course` SET `click` = `click` + 1 WHERE `id` = 70 [ RunTime:0.002196s ]
SELECT * FROM `zx_course` WHERE `status` = 1 AND `school_id` = 1 ORDER BY CASE WHEN sort = 0 THEN 1 ELSE 0 END,`sort` ASC,`create_time` DESC [ RunTime:0.000636s ]