SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000475s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000418s ]
SELECT * FROM `zx_course` WHERE `status` <> -1 AND `id` = 1 LIMIT 1 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000438s ]
SELECT * FROM `zx_school` WHERE `status` <> -1 AND `id` = 1 LIMIT 1 [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000435s ]
SELECT * FROM `zx_article` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.001051s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000670s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `zx_tag` [ RunTime:0.000369s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 25 LIMIT 1 [ RunTime:0.000260s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 23 LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 22 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `zx_tag` WHERE `status` = 1 AND `id` = 16 LIMIT 1 [ RunTime:0.000204s ]
UPDATE `zx_course` SET `click` = `click` + 1 WHERE `id` = 1 [ RunTime:0.002145s ]
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.000602s ]
