You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Laravel搜索查询本地正常，生产环境部分筛选功能失效

avatar
开发者阿泽
2026-7-4
Laravel多条件搜索生产环境异常：仅匹配关联数据，主表数据无结果

环境配置

生产服务器

  • 数据库版本：10.5.20-MariaDB-cll-lve - MariaDB Server
  • 协议版本：10
  • 域名使用PHP版本：8.0（PHPMyAdmin显示全局PHP版本为7.4.27，与域名版本不一致）

本地环境

  • 数据库版本：8.0.32 - MySQL Community Server - GPL
  • 协议版本：10

问题详情

实现了一个Laravel多条件搜索筛选脚本，本地环境运行完全正常，但生产环境中，输入关键词时仅能正确匹配模型关联数据，无法匹配listings主表的直接数据。已将查询语句输出到日志，语句本身无问题，直接在生产环境数据库执行可得到预期结果，但接口返回结果不稳定，例如搜索space_type为'private'时有结果，改为存在的'shared'时返回空数组。

搜索功能代码 

public static function listings(Request $request)
{
    try{
    $initialData = Listing::query()
    ->select(
        'listings.*',
        'states.name as state_name',
        'sub_categories.sub_category_name',
        'sub_categories.is_land'
    )
    ->leftJoin('states', 'listings.state_id', 'states.id')
    ->leftJoin('sub_categories', 'listings.sub_category_id', 'sub_categories.id')
    ->when($request->has('brand_id'))->where('brand_id', $request->brand)
    ->when($request->has('brand'), function ($query) use ($request) {
        $query->join('brands', 'listings.brand_id', '=', 'brands.id')
            ->where('brands.brand_name', 'LIKE', "%{$request->brand}%");
    })
    ->when($request->has('listing_type'))->listingType(\strtolower($request->listing_type))
    ->withCasts(['is_land' => 'boolean']);

    $result = $initialData
        ->when($request->has('subcategory'), function ($query) use ($request) {
            $subcategories = Str::of($request->subcategory)->explode(',');
            $query->where(function ($subquery) use ($subcategories) {
                /** @var string[] $subcategories */
                foreach ($subcategories as $subcategory) {
                    $subquery->orWhere('sub_categories.sub_category_name', 'LIKE', "%{$subcategory}%");
                }
            });
        })
        ->when($request->has('payment_plan'), function ($query) use ($request) {
            $requestedPaymentPlans = Str::of($request->payment_plan)->explode(',')->toArray();
            $query->where(function ($subquery) use ($requestedPaymentPlans) {
                foreach ($requestedPaymentPlans as $paymentPlan) {
                    $subquery->orWhereJsonContains('payment_plan', $paymentPlan);
                }
            });
        })
        ->when($request->has('space_type'), function ($query) use ($request) {
            $space_type = Str::of($request->space_type)->explode(',');
            $query->where(function ($subquery) use ($space_type) {
                /** @var string[] $space_type */
                foreach ($space_type as $space) {
                    $subquery->orWhere('listings.space_type', 'LIKE', "%{$space}%");
                }
            });
        })
        ->when($request->has(['min_price', 'max_price']))->where(function ($query) use ($request) {
            $query->whereBetween('listings.price', [$request->query('min_price'), $request->query('max_price')]);
        })
        ->when($request->has('location'), function ($query) use ($request) {
            /** @var string[] $location */
            $location = Str::of($request->location)->explode(' ');
            $query->where(function ($subquery) use ($location) {
                foreach ($location as $loc) {
                    $subquery->orWhereHas('state', function ($q) use ($loc) {
                        $q->where('states.name', 'LIKE', "%{$loc}%");
                    })
                        ->orWhereHas('country', function ($q) use ($loc) {
                            $q->where('countries.name', 'LIKE', "%{$loc}%");
                        })
                        ->orWhere('listings.full_address', 'LIKE', "%{$loc}%")
                        ->orWhere('listings.city', 'LIKE', "%{$loc}%");
                }
            });
        })
        ->when($request->has('keyword'), function ($query) use ($request) {
            /** @var string[] $keywords */
            $keywords = Str::of($request->keyword)->explode(' ');
            $query->where(function ($subquery) use ($keywords) {
                foreach ($keywords as $keyword) {
                    $subquery->orWhere('listings.listing_caption', 'LIKE', "%{$keyword}%")
                        ->orWhere('listings.listing_description', 'LIKE', "%{$keyword}%")
                        ->orWhereHas('state', function ($q) use ($keyword) {
                            $q->where('states.name', 'LIKE', "%{$keyword}%");
                        })
                        ->orWhereHas('country', function ($q) use ($keyword) {
                            $q->where('countries.name', 'LIKE', "%{$keyword}%");
                        })
                        ->orWhere('listings.city', 'LIKE', "%{$keyword}%")
                        ->orWhere('listings.full_address', 'LIKE', "%{$keyword}%")
                        ->orWhereHas('sub_category', function ($q) use ($keyword) {
                            $q->where('sub_categories.sub_category_name', 'LIKE', "%{$keyword}%");
                        });
                }
            });
        })
        ->get();

    $landResults = $result->where('is_land', true);
    $nonLandResults = $result->where('is_land', false);

    $finalResult = collect([]);
    $filteredNonLandResults = collect([]);

    if ($nonLandResults->isEmpty()) {
        if ($landResults->isEmpty()) {
            $finalResult = $initialData->get();
        }
    }else {
        $filteredNonLandResults = $nonLandResults->when($request->has('bathrooms'), function ($query) use ($request) {
            $query->where('listings.bathrooms', $request->bathrooms);
        })
        ->when($request->has('bedrooms'), function ($query) use ($request) {
            $query->where('listings.bedrooms', $request->bedrooms);
        })
        ->when($request->has('condition'), function ($query) use ($request) {
            $condition = Str::of($request->condition)->explode(',');

            $query->where(function ($subquery) use ($condition) {
                /** @var string[] $condition */
                foreach ($condition as $cond) {
                    $subquery->orWhere('listings.condition', 'LIKE', "%{$cond}%");
                }
            });
        })
        ->when($request->has('furnishing'), function ($query) use ($request) {
            $furnishings = Str::of($request->furnishing)->explode(',');

            $query->where(function ($subquery) use ($furnishings) {
                /** @var string[] $furnishings */
                foreach ($furnishings as $furnishing) {
                    $subquery->orWhere('listings.furnishing', 'LIKE', "%{$furnishing}%");
                }
            });
        });
        $finalResult = $landResults->concat($filteredNonLandResults)->values()->all();
    }

    $queryLog = DB::getQueryLog();
    Log::info($queryLog);

    return $finalResult;
    }catch(\Exception $e) {
        return $e->getMessage();
    }
}

补充：仅传入keyword参数时的查询日志

生产环境日志 

[2023-12-07 14:28:19] production.INFO: array (
  0 => 
  array (
    'query' => 'select `listings`.*, `states`.`name` as `state_name`, `sub_categories`.`sub_category_name`, `sub_categories`.`is_land` from `listings` left join `states` on `listings`.`state_id` = `states`.`id` left join `sub_categories` on `listings`.`sub_category_id` = `sub_categories`.`id` where (`listings`.`listing_caption` LIKE ? or `listings`.`listing_description` LIKE ? or exists (select * from `states` where `listings`.`state_id` = `states`.`id` and `states`.`name` LIKE ?) or exists (select * from `countries` where `listings`.`country_id` = `countries`.`id` and `countries`.`name` LIKE ?) or `listings`.`city` LIKE ? or `listings`.`full_address` LIKE ? or exists (select * from `sub_categories` where `listings`.`sub_category_id` = `sub_categories`.`id` and `sub_categories`.`sub_category_name` LIKE ?))',
    'bindings' => 
    array (
      0 => '%near%',
      1 => '%near%',
      2 => '%near%',
      3 => '%near%',
      4 => '%near%',
      5 => '%near%',
      6 => '%near%',
    ),
    'time' => 6.28,
  ),
)

本地环境日志 

[2023-12-07 14:38:50] local.INFO: array (
  0 => 
  array (
    'query' => 'select `listings`.*, `states`.`name` as `state_name`, `sub_categories`.`sub_category_name`, `sub_categories`.`is_land` from `listings` left join `states` on `listings`.`state_id` = `states`.`id` left join `sub_categories` on `listings`.`sub_category_id` = `sub_categories`.`id` where (`listings`.`listing_caption` LIKE ? or `listings`.`listing_description` LIKE ? or exists (select * from `states` where `listings`.`state_id` = `states`.`id` and `states`.`name` LIKE ?) or exists (select * from `countries` where `listings`.`country_id` = `countries`.`id` and `countries`.`name` LIKE ?) or `listings`.`city` LIKE ? or `listings`.`full_address` LIKE ? or exists (select * from `sub_categories` where `listings`.`sub_category_id` = `sub_categories`.`id` and `sub_categories`.`sub_category_name` LIKE ?))',
    'bindings' => 
    array (
      0 => '%near%',
      1 => '%near%',
      2 => '%near%',
      3 => '%near%',
      4 => '%near%',
      5 => '%near%',
      6 => '%near%',
    ),
    'time' => 152.35,
  ),
)

内容的提问来源于stack exchange，提问作者Joseph Okafor

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
火山引擎 最新活动
全面开放
Doubao-Seedance-2.5全新模型升级

模型再升级,30秒超长叙事, 模态参考扩容

HOT
方舟Codingplan

模型自由，工具不限，最新支持 Deepseek-V4 系列、GLM-5.3 系列

HOT
方舟Agent plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列

HOT
新用户特惠专场

大模型19元起，Al应用9.9元畅享，新人首购爆款尽享优惠

最近更新时间：2026.07.04 15:09:55