RUSHBRUSHDEVELOP

Illuminate\Database\QueryException QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order' in 'order clause' (Connection: mysql, SQL: select `id`, `name`, `slug`, `image_featured_path`, `price`, `discount_price`, `is_best_seller` from `ecommerce_catalog_site_products` where (`categories` like %1%) and `is_visible` = 1 order by `order` asc)

GET api.rushbrush.dev

PHP 8.4.2 — Laravel 11.35.1

9 vendor frames collapsed

6 vendor frames collapsed

1 vendor frame collapsed

33 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 :3133

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

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

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

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

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

app/Http/Controllers/Api/ProductsController.php :34

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

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

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

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

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

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

app/Http/Middleware/API/WebsiteMiddleware.php :32

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

app/Http/Middleware/API/AccessTokenMiddleware.php :30

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

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

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

vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php :162

vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php :128

vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php :90

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 :49

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/Pipeline/Pipeline.php :119

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

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

public/index.php :51

Request

GET /catalog/products

Headers

do-connecting-ip

64.226.120.133

cdn-loop

cloudflare; loops=1

x-rushbrush-website

eg-en

x-access-token

1AHgftfFiWS3LhRSj7Q4b7ULhzZEDi7V8R6GqSfyjpFvL4B6orwz0YDG6MiRdTgd

*/*

accept-language

x-forwarded-proto

https

accept-encoding

gzip, br

sec-fetch-mode

cors

user-agent

node

x-forwarded-for

64.226.120.133,172.69.151.128

host

api.rushbrush.dev

Body

{
    "category_slug": "air-stylers",
    "website": {
        "id": 1,
        "store_id": 1,
        "name": "Egypt English",
        "slug": "eg-en",
        "is_default": null,
        "created_at": "2024-08-10T13:15:00.000000Z",
        "updated_at": "2024-08-10T13:15:00.000000Z"
    }
}

Application

Routing

controller

App\Http\Controllers\Api\ProductsController@index

middleware

api, App\Http\Middleware\API\AccessTokenMiddleware, App\Http\Middleware\API\WebsiteMiddleware

Database Queries

mysql (7.6 ms)

select * from `ecommerce_cache` where `key` in ('rushbrushdevelop_cache_telescope:dump-watcher')

mysql (1.08 ms)

select * from `ecommerce_cache` where `key` in ('rushbrushdevelop_cache_telescope:pause-recording')

mysql (1.2 ms)

select * from `ecommerce_cache` where `key` in ('rushbrushdevelop_cache_7a80d199ddb633ad6449d2264fce3739')

mysql (1.02 ms)

select * from `ecommerce_cache` where `key` in ('rushbrushdevelop_cache_7a80d199ddb633ad6449d2264fce3739:timer')

mysql (0.95 ms)

select * from `ecommerce_cache` where `key` in ('rushbrushdevelop_cache_7a80d199ddb633ad6449d2264fce3739')

mysql (0.96 ms)

select * from `ecommerce_cache` where `key` = 'rushbrushdevelop_cache_7a80d199ddb633ad6449d2264fce3739' limit 1 for update

mysql (1.01 ms)

update `ecommerce_cache` set `value` = 'i:2;' where `key` = 'rushbrushdevelop_cache_7a80d199ddb633ad6449d2264fce3739'

mysql (1.1 ms)

select * from `ecommerce_websites` where `slug` = 'eg-en' limit 1

mysql (1.06 ms)

select * from `ecommerce_catalog_site_categories` where `slug` = 'air-stylers' limit 1