set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000162s ]
SHOW FULL COLUMNS FROM `dr_weixin` [ RunTime:0.000619s ]
SELECT * FROM `dr_weixin` WHERE `name` = 'config' LIMIT 1 [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `dr_2_tag` [ RunTime:0.001477s ]
SELECT * FROM `dr_2_tag` WHERE `code` = 'nongjiaxiaowu' LIMIT 1 [ RunTime:0.001381s ]
show COLUMNS FROM dr_2_news [ RunTime:0.001565s ]
show COLUMNS FROM dr_2_movie [ RunTime:0.000560s ]
SELECT count(*) as c FROM (SELECT id,title,url,thumb,keywords,'news' AS mid FROM `dr_2_news` UNION ALL SELECT id,title,url,thumb,keywords,'movie' AS mid FROM `dr_2_movie`) as my WHERE ((`title` LIKE "%农家小屋%" OR `keywords` LIKE "%农家小屋%")) ORDER BY NULL [ RunTime:0.096958s ]
SELECT id,title,url,thumb,keywords,mid FROM (SELECT id,title,url,thumb,keywords,'news' AS mid FROM `dr_2_news` UNION ALL SELECT id,title,url,thumb,keywords,'movie' AS mid FROM `dr_2_movie`) as my WHERE ((`title` LIKE "%农家小屋%" OR `keywords` LIKE "%农家小屋%")) LIMIT 0,16 [ RunTime:0.093664s ]