Фитофарм

Illuminate\Database\QueryException QueryException

SQLSTATE[53100]: Disk full: 7 ERROR: could not resize shared memory segment "/PostgreSQL.3805678486" to 8388608 bytes: No space left on device CONTEXT: parallel worker (Connection: pgsql, SQL: select MAX( CASE WHEN stock_info.calculated_price IS NOT NULL AND stock_info.calculated_price > 0 THEN stock_info.calculated_price ELSE stock_info.rprice END ) AS max_price from "stock_info" inner join "stocks" as "s" on "s"."iid" = "stock_info"."stock_id" inner join "pharmacies" as "p" on "p"."id" = "s"."pharmacy_id" and "p"."city_id" = 1 inner join "medicines" as "m" on "m"."id" = "s"."medicine_id" and "m"."is_published" = 1 limit 1)

GET lk.etoapteka.ru

PHP 8.3.4 — Laravel 11.32.0

11 vendor frames collapsed

3 vendor frames collapsed

1 vendor frame collapsed

3 vendor frames collapsed

37 vendor frames collapsed

vendor/laravel/framework/src/Illuminate/Database/Connection.php :825

vendor/laravel/framework/src/Illuminate/Database/Connection.php :779

vendor/laravel/framework/src/Illuminate/Database/Connection.php :398

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3132

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3117

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3705

vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3116

vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :759

vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :741

vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php :344

vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php :690

app/Pipes/Medicines/List/FilterMedicineListPipe.php :57

vendor/laravel/framework/src/Illuminate/Cache/Repository.php :426

vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php :453

vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php :358

app/Pipes/Medicines/List/FilterMedicineListPipe.php :36

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

app/Pipes/Medicines/List/SearchMedicineListPipe.php :94

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

app/Pipes/Medicines/List/InitiateMedicineListPipe.php :20

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

app/Pipes/SetUserPipe.php :35

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :119

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :129

app/Http/Controllers/Api/Medicines/MedicineController.php :40

vendor/laravel/framework/src/Illuminate/Routing/Controller.php :54

vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php :43

vendor/laravel/framework/src/Illuminate/Routing/Route.php :264

vendor/laravel/framework/src/Illuminate/Routing/Route.php :210

vendor/laravel/framework/src/Illuminate/Routing/Router.php :808

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :144

vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :119

vendor/laravel/framework/src/Illuminate/Routing/Router.php :807

vendor/laravel/framework/src/Illuminate/Routing/Router.php :786

vendor/laravel/framework/src/Illuminate/Routing/Router.php :750

vendor/laravel/framework/src/Illuminate/Routing/Router.php :739

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :201

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :144

vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php :19

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :110

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php :62

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php :22

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :183

vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :119

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :176

vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :145

vendor/laravel/framework/src/Illuminate/Foundation/Application.php :1190

public/index.php :17

Request

GET /api/v1/cities/1/products

Headers

x-real-ip

89.111.173.75

x-forwarded-server

3c8648265752

x-forwarded-proto

https

x-forwarded-port

x-forwarded-host

lk.etoapteka.ru

x-forwarded-for

89.111.173.75

sec-fetch-mode

cors

content-type

application/json

accept-language

accept-encoding

br, gzip, deflate

*/*

user-agent

node

host

lk.etoapteka.ru

Body

{
    "categoryId": "31000",
    "filters": {
        "availability": "1"
    },
    "per-page": "16",
    "subCategoryId": "786001"
}

Application

Routing

controller

App\Http\Controllers\Api\Medicines\MedicineController@index

route name

api.v1.products.index

middleware

api

Routing Parameters

{
    "city": {
        "id": 1,
        "name": "Анапа",
        "order": 1,
        "created_at": "2024-12-17T06:42:03.000000Z",
        "updated_at": "2025-03-12T08:32:15.000000Z",
        "latitude": "44.894817",
        "longitude": "37.31637",
        "zoom": "12",
        "zoom_mobile": "10"
    }
}

Database Queries

pgsql (29.24 ms)

select * from "cities" where "id" = '1' limit 1

Результаты поиска