搜索解析:SELECT `dr_1_news`.`id` FROM `dr_1_news` WHERE `dr_1_news`.`status` = 9 AND `dr_1_news`.`catid`=1 AND `dr_1_news`.`id` IN (SELECT `id` FROM `dr_1_news_category_data` WHERE (`dr_1_news_category_data`.`diqu`=2)) ORDER BY NULL
查询解析: SELECT `dr_1_news`.*,`dr_1_news_category_data`.`diqu`,`dr_1_news_category_data`.`jdlx`,`dr_1_news_category_data`.`hqcd`,`dr_1_news_category_data`.`rnzs`,`dr_1_news_category_data`.`jiagezhuo`,`dr_1_news_category_data`.`dianhua`,`dr_1_news_category_data`.`dizhi_lng`,`dr_1_news_category_data`.`dizhi_lat`,`dr_1_news_category_data`.`dizhi`,`dr_1_news_category_data`.`shipindizhi`,`dr_1_news_category_data`.`hycd`,`dr_1_news_category_data`.`shipindizhi2`,`dr_1_news_category_data`.`sp1slt`,`dr_1_news_category_data`.`sp2slt`,`dr_1_news_category_data`.`fmdt`,`dr_1_news_category_data`.`jdjs` FROM `dr_1_news` LEFT JOIN dr_1_news_category_data ON `dr_1_news_category_data`.`id`=`dr_1_news`.`id` WHERE `dr_1_news`.`status` = 9 AND `dr_1_news`.`catid`=1 AND `dr_1_news`.`id` IN (SELECT `id` FROM `dr_1_news_category_data` WHERE (`dr_1_news_category_data`.`diqu`=2)) ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 0,5
如果还是不出来就使用下诊断变量搜索页面的模板标签生成工具:/doc/code/search.html