网站筛选页面点击对应的筛选字段时加载很慢，有什么方法可以解决？？

开源系统更新 2018-06-07 16:50:35

13377185609

网站筛选页面点击对应的筛选字段时，筛选的内容很久才可以显示出来，加载的速度很慢，，有什么办法可以解决？？？

方案

请勿打扰 #1 · 2018-03-05 14:21:20

数据库配置改成127.0.0.1
冷漠 #2 · 2018-03-05 15:06:18

给搜索的字段加索引
13377185609 #3 · 2018-03-06 16:59:34

您好，，是怎么给搜索字段添加索引这是我的筛选字段的代码 <ul> <li class="classother language"> <dl> <dt> 商标类型: </dt> <dd> <span> <a class="label {if !$catid || $cat.child}label-success{else}label-default{/if}" href="{dr_search_url($params, 'catid', NULL)}">不限</a> </span> {loop $related $t} <span> <a class="label {if $t.id==$catid}label-success{else}label-default{/if}" href="{dr_search_url($params, 'catid', $t.id)}">{$t.name}</a> </span> {/loop} </dd> </dl> <div class="cleare"></div> </li>  <li class="classother language"> <dl> <dt> 类型: </dt> <dd> {php $field = dr_field_options('leixing001');} <span> <a class="label {if !$params.leixing001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'leixing001', NULL)}">不限</a> </span> {loop $field $i $t} <span> <a class="label {if $i==$params.leixing001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'leixing001', $i)}">{$t}</a> </span> {/loop} </dd> </dl> <div class="cleare"></div> </li>  <li class="classother language"> <dl> <dt> 注册年限: </dt> <dd> {php $field = dr_field_options('zcnx001');} <span> <a class="label {if !$params.zcnx001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'zcnx001', NULL)}">不限</a> </span> {loop $field $i $t} <span> <a class="label {if $i==$params.zcnx001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'zcnx001', $i)}">{$t}</a> </span> {/loop} </dd> </dl> <div class="cleare"></div> </li>  <li class="classother language"> <dl> <dt> 字数: </dt> <dd> {php $field = dr_field_options('zishu001');} <span> <a class="label {if !$params.zishu001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'zishu001', NULL)}">不限</a> </span> {loop $field $i $t} <span> <a class="label {if $i==$params.zishu001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'zishu001', $i)}">{$t}</a> </span> {/loop} </dd> </dl> <div class="cleare"></div> </li>  <li class="classother language"> <dl> <dt> 价格区间: </dt> <dd> {php $field = dr_field_options('jiagequjian001');} <span> <a class="label {if !$params.jiagequjian001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'jiagequjian001', NULL)}">不限</a> </span> {loop $field $i $t} <span> <a class="label {if $i==$params.jiagequjian001}label-success{else}label-default{/if}" href="{dr_search_url($params, 'jiagequjian001', $i)}">{$t}</a> </span> {/loop} </dd> </dl> <div class="cleare"></div> </li> </ul>
华仔 #4 · 2018-04-29 10:51:11

我的也是搜索刷选结果特慢,请问楼主解决了没有
13377185609 #5 · 2018-06-07 14:51:34

没有解决
姜凯 #6 · 2018-06-07 16:50:35

用数据优化插件分析一下看看