SHOW FULL COLUMNS FROM `zx_system` [ RunTime:0.000581s ]
SELECT * FROM `zx_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `zx_article` [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `zx_course` [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `zx_cate` [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `zx_school` [ RunTime:0.000459s ]
select id,1 as type,title,create_time from zx_article where title like '%舞蹈%'
UNION
select id,2 as type,title,create_time from zx_school where title like '%舞蹈%'
UNION
select id,3 as type,title,create_time from zx_course where title like '%舞蹈%'
order by create_time desc [ RunTime:0.000499s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000792s ]
SELECT * FROM `zx_school` WHERE `status` = 1 ORDER BY rand() LIMIT 12 [ RunTime:0.000750s ]
SELECT `a`.* FROM `zx_course` `a` LEFT JOIN `zx_school` `b` ON `a`.`school_id`=`b`.`id` WHERE `a`.`status` = '1' AND `b`.`status` = '1' ORDER BY rand() LIMIT 12 [ RunTime:0.001126s ]
