Internal Server Error

ErrorException

resources/views/frontend-pannel/hair-saloon.blade.php:170

Undefined variable $homePageData

LARAVEL 12.62.0
PHP 8.5.8
UNHANDLED
CODE 0
500
GET
https://reservim.com/c/day-spa/pakistan/lahore/gulberg-iii

Exception trace

Illuminate\Foundation\Bootstrap\HandleExceptions->{closure:Illuminate\Foundation\Bootstrap\HandleExceptions::forwardsTo():261}()
resources/views/frontend-pannel/hair-saloon.blade.php:170
165        <header-section 166        :general_page="{{json_encode($generalPage,true)}}"167        ></header-section>168         169        <!-- <listing-search-banner-section170    :home_data="{{json_encode($homePageData,true)}}"171    :categories="{{json_encode($categories,true)}}"172    :more_categories="{{json_encode($more_categories,true)}}"173    ></listing-search-banner-section> -->174    <new-search-banner-section>175    </new-search-banner-section>176    {{-- <slider-recommended-section :shops="{{json_encode($shop,true)}}">177    </slider-recommended-section> --}}178    <sticky-header-section179        :shops="{{json_encode($shops,true)}}"180        :general_page="{{json_encode($generalPage,true)}}"181        :home_data="{{json_encode($homePage,true)}}"182
13 vendor frames
require(string)
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:123
Illuminate\Filesystem\Filesystem::{closure:Illuminate\Filesystem\Filesystem::getRequire():120}()
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
Illuminate\Filesystem\Filesystem->getRequire()
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:57
Illuminate\View\Engines\PhpEngine->evaluatePath()
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:76
Illuminate\View\Engines\CompilerEngine->get()
vendor/laravel/framework/src/Illuminate/View/View.php:208
Illuminate\View\View->getContents()
vendor/laravel/framework/src/Illuminate/View/View.php:191
Illuminate\View\View->renderContents()
vendor/laravel/framework/src/Illuminate/View/View.php:160
Illuminate\View\View->render()
vendor/laravel/framework/src/Illuminate/Http/Response.php:78
Illuminate\Http\Response->setContent()
vendor/laravel/framework/src/Illuminate/Http/Response.php:34
Illuminate\Http\Response->__construct()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:939
Illuminate\Routing\Router::toResponse()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:906
Illuminate\Routing\Router->prepareResponse()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
Illuminate\Routing\Router->{closure:Illuminate\Routing\Router::runRouteWithinStack():821}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()
app/Http/Middleware/PreventBackHistory.php:18
13     * @param  \Closure  $next14     * @return mixed15     */16    public function handle($request, Closure $next)17    {18        $response = $next($request);1920        // Do not rewrite headers on PDF downloads — corrupted Cache-Control21        // values can make Chrome's PDF viewer show a blank page.22        if ($request->is('download_recipt_file/*', 'print_recipt_file/*', 'call-center/reports/pdf')) {23            return $response;24        }2526        $contentType = (string) $response->headers->get('Content-Type');27        if (stripos($contentType, 'pdf') !== false) {28            return $response;29        }30
1 vendor frame
App\Http\Middleware\PreventBackHistory->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
app/Http/Middleware/SessionExpired.php:49
44            $this->session->forget('lastActivityTime');45            $this->session->forget(['admin_authenticated', 'admin_user_id']);46            auth()->logout();47        }48        $isLoggedIn ? $this->session->put('lastActivityTime', time()) : $this->session->forget('lastActivityTime');49        return $next($request);50    }51}52
1 vendor frame
App\Http\Middleware\SessionExpired->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
app/Http/Middleware/SetDatabaseConnection.php:95
90        ]);9192        DB::purge('mysql');93        $this->forgetPermissionCache();9495        return $next($request);96    }9798    /**99     * Detect the country URL prefix from index.php or the raw request path.100     */101    protected function detectUrlPrefix(Request $request): string102    {103        $fromServer = $_SERVER['RESERVIM_REGION_PREFIX'] ?? null;104        if (is_string($fromServer) && $fromServer !== '') {105            return trim($fromServer, '/');106        }107
39 vendor frames
App\Http\Middleware\SetDatabaseConnection->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
Illuminate\Routing\Middleware\SubstituteBindings->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:87
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:48
Illuminate\View\Middleware\ShareErrorsFromSession->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:120
Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
Illuminate\Session\Middleware\StartSession->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:74
Illuminate\Cookie\Middleware\EncryptCookies->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:821
Illuminate\Routing\Router->runRouteWithinStack()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:800
Illuminate\Routing\Router->runRoute()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:764
Illuminate\Routing\Router->dispatchToRoute()
vendor/laravel/framework/src/Illuminate/Routing/Router.php:753
Illuminate\Routing\Router->dispatch()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:200
Illuminate\Foundation\Http\Kernel->{closure:Illuminate\Foundation\Http\Kernel::dispatchToRouter():197}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
Illuminate\Pipeline\Pipeline->{closure:Illuminate\Pipeline\Pipeline::prepareDestination():178}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31
Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:51
Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php:27
Illuminate\Http\Middleware\ValidatePostSize->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:109
Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php:61
Illuminate\Http\Middleware\HandleCors->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php:58
Illuminate\Http\Middleware\TrustProxies->handle()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:219
Illuminate\Pipeline\Pipeline->{closure:{closure:Illuminate\Pipeline\Pipeline::carry():194}:195}()
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:137
Illuminate\Pipeline\Pipeline->then()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:175
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:144
Illuminate\Foundation\Http\Kernel->handle()
vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1220
Illuminate\Foundation\Application->handleRequest()
public/index.php:127
122    $_SERVER['RESERVIM_REGION_PREFIX'] = '';123    $_SERVER['RESERVIM_ORIGINAL_PATH'] = $requestPath;124}125126(require_once __DIR__.'/../bootstrap/app.php')127    ->handleRequest(Request::capture());128

Queries

mysql
select * from `default_categories` where `slug` = 'day-spa' limit 1
16.91ms
mysql
select `average_price_range` from `shop_services` where `category_id` = 8 and `price` > 0 limit 1
22.64ms
mysql
select `id`, `name`, `slug` from `cities` where `name` = 'lahore' limit 1
20.74ms
mysql
select `id`, `name`, `slug` from `areas` where `slug` = 'gulberg-iii' limit 1
18.86ms
mysql
select * from `default_categories` where `id` = 8 limit 1
10.61ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
11.14ms
mysql
select count(*) as aggregate from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and (`status` = 1 or `g_import` = 1) and (`flag_status` = 0 and `main_category_id` = 8 and `city` = 1 and `area` = 20) and `users`.`deleted_at` is null
67.94ms
mysql
select `id`, `owner_id`, `salon_name`, `shop_logo`, `slug`, `main_category_id`, `opening_closing_hours`, `complete_address`, `city`, `status`, `feature_status`, (select count(*) from `reviews` where `users`.`id` = `reviews`.`shop_id`) as `review_count`, (select avg(`reviews`.`rating`) from `reviews` where `users`.`id` = `reviews`.`shop_id`) as `review_avg_rating` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and (`status` = 1 or `g_import` = 1) and (`flag_status` = 0 and `main_category_id` = 8 and `city` = 1 and `area` = 20) and `users`.`deleted_at` is null order by status DESC, feature_status DESC,review_avg_rating DESC limit 10 offset 0
80.76ms
mysql
select `id`, `name`, `slug` from `default_categories` where `default_categories`.`id` in (8)
17.43ms
mysql
select * from `cities` where `cities`.`id` in ('1')
10.18ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2959)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
134.8ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
31.63ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2927)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
178.98ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
5.21ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2928)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
172.17ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
8.25ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2938)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
143.81ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
1.99ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2950)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
135.58ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
3.07ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2957)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
179.59ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
2.74ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2958)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
142.45ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
2.83ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2974)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
124.39ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
1.01ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2971)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
117.19ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
1.08ms
mysql
select * from (select *, row_number() over (partition by `shop_services`.`shop_id`) as `laravel_row` from `shop_services` where `price` != 0 and `shop_services`.`shop_id` in (2968)) as `laravel_table` where `laravel_row` <= 3 order by `laravel_row`
114.06ms
mysql
select * from `default_services` where `default_services`.`id` in (75, 76, 77)
2.79ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
3.39ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2959 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
3.48ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
3.24ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2959)
1.02ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2959)
3.23ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2959
38.78ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
0.96ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
3.53ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2959 and `id` != 2959 and `users`.`deleted_at` is null
38.26ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
6.58ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2927 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
6.87ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
7.05ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2927)
5.09ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2927)
5.95ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2927
79.29ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
8.43ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
19.8ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2927 and `id` != 2927 and `users`.`deleted_at` is null
54.6ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
1.79ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2928 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
11.34ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
8ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2928)
0.95ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2928)
9.24ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2928
64.64ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4)
7.23ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
5.13ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2928 and `id` != 2928 and `users`.`deleted_at` is null
67.06ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
3.46ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2938 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
11.77ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
14.3ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2938)
13.35ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2938)
3.51ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2938
128.59ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
10.89ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
27.03ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2938 and `id` != 2938 and `users`.`deleted_at` is null
121.41ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
5.48ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2950 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
18.03ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
12.41ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2950)
12.78ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2950)
23.26ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2950
92.37ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
3.58ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
7.17ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2950 and `id` != 2950 and `users`.`deleted_at` is null
73.68ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
9.3ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2957 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
14.71ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
1.17ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2957)
9.81ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2957)
6.5ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2957
73.66ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
0.9ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
9.58ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2957 and `id` != 2957 and `users`.`deleted_at` is null
38.97ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
3.46ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2958 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
3.55ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
0.97ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2958)
4.28ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2958)
3.86ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2958
77.24ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
0.86ms
mysql
select * from `roles` where `name` = 'staff' and `guard_name` = 'web' limit 1
0.66ms
mysql
select `name` from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2)) and `owner_id` = 2958 and `id` != 2958 and `users`.`deleted_at` is null
28.26ms
mysql
select * from `roles` where `name` = 'shop' and `guard_name` = 'web' limit 1
1.97ms
mysql
select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (4)) and `id` = 2974 and (`status` = 1 or `g_import` = 1) and `users`.`deleted_at` is null limit 1
3.95ms
mysql
select * from `default_categories` where `default_categories`.`id` in (8)
1.58ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2974)
2.21ms
mysql
select * from `reviews` where `reviews`.`shop_id` in (2974)
2.46ms
mysql
select `service_id` from `shop_services` where `shop_id` = 2974
39.23ms
mysql
select `name` from `default_services` where `id` in (75, 76, 77, 4, 14, 182)
0.96ms

Headers

cookie
reservimcom_session=eyJpdiI6IkFHa2hSdXRuUHpWckxncERDS3hKakE9PSIsInZhbHVlIjoiS1AxT20yelB2RmRjRWptNm80YWdLeE5iM2h1NXdkZVR5cXp5a29LNHppak5pbzFSeHR5UXRYNVpCaUJrSXNkMTVrY01UYlE1NmlaU1ZRU2EwdysrMHlFSHh0VFNVeUthMHR4SmVJV0xaSGU0Vm1CRTE4K2IvbmZmWDRFS0p1R0QiLCJtYWMiOiJhMjA5N2ViNGEzN2I0MDVlZDZlZjA5YWFhYWI3ODQ0NjJhNWVkMWM1MWNkNTg1YTk1NTkxNTg5ZDllZWYxNmJhIiwidGFnIjoiIn0%3D; XSRF-TOKEN=eyJpdiI6Ijk5UW1BZitIY2txWjQydWRiVGowSmc9PSIsInZhbHVlIjoiNzhkYzVOdU5GNzh6V1RSUzR6cS94enBoNWx5VHF6SXprRXFzQjhsLzBqUkVETGwyTGhxSjlBdFYxbEtrb0RPVThEWC9vYWk2cWFxTk5MNWZPcmp3UzdXdE5zRHRiK3IzRzdDSHpHVjNwU25HVjM2bG0yOXBMclU3bVp3UDdCVXEiLCJtYWMiOiI3MTYwOTdhZTRiMWJiNjYzMzEyYjViZDlmZTcyM2FjMDgyZDhlZmY4MjlkNDY2Zjk0NDhkMDZjZDRjZjc2MzNkIiwidGFnIjoiIn0%3D
accept-encoding
gzip, br, zstd, deflate
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
host
reservim.com

Body

// No request body

Routing

controller
App\Http\Controllers\Search\SearchController@categorySearchCityArea
route name
category-area
middleware
web, prevent-back-history

Routing parameters

{
    "cat_name": "day-spa",
    "region": "pakistan",
    "city": "lahore",
    "area": "gulberg-iii"
}