SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000605s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000463s ]
SELECT * FROM `zx_course` WHERE `status` <> -1 AND `id` = 12 LIMIT 1 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000481s ]
SELECT * FROM `zx_school` WHERE `status` <> -1 AND `id` = 4 LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000444s ]
SELECT * FROM `zx_article` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.001033s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000671s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `zx_tag` [ RunTime:0.000430s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 18 LIMIT 1 [ RunTime:0.000248s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 16 LIMIT 1 [ RunTime:0.000240s ]
UPDATE `zx_course` SET `click` = `click` + 1 WHERE `id` = 12 [ RunTime:0.002246s ]
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.000377s ]
