Delivery of orders from the most popular sites in Turkey, America and England

Messages Timeline Exceptions Views11 Route Queries7 Mails Auth Gate Session Request

49.6ms2MBGET en/stores

Booting (21.32ms)
Application (30.61ms)

11 templates were rendered

front.pages.stores (resources/views/front/pages/stores.blade.php)6blade
Params
0
singleView
1
items
2
title
3
breadTitle
4
cover
5
categories
front.sections.page-header (resources/views/front/sections/page-header.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
setting
4
cover
5
errors
6
_lang
7
singleView
8
items
9
title
10
breadTitle
11
categories
front.widgets.modal (resources/views/front/widgets/modal.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
setting
4
cover
5
errors
6
_lang
7
singleView
8
items
9
title
10
breadTitle
11
categories
12
modalId
front.pages.stores.store-item (resources/views/front/pages/stores/store-item.blade.php)2blade
Params
0
key
1
item
pagination::default (resources/views/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`singleView`
1	`items`
2	`title`
3	`breadTitle`
4	`cover`
5	`categories`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`modalId`

Params
0	`key`
1	`item`

Params
0	`paginator`
1	`elements`

front.layout (resources/views/front/layout.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

front.widgets.metaTags (resources/views/front/widgets/metaTags.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

front.widgets.favicon (resources/views/front/widgets/favicon.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

front.widgets.loading (resources/views/front/widgets/loading.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

front.sections.nav-bar (resources/views/front/sections/nav-bar.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

front.sections.footer (resources/views/front/sections/footer.blade.php)16blade


obLevel
__env
app
setting
cover
errors
_lang
singleView
items
title
breadTitle
categories
__currentLoopData
category
loop
datas

Params
0	`obLevel`
1	`__env`
2	`app`
3	`setting`
4	`cover`
5	`errors`
6	`_lang`
7	`singleView`
8	`items`
9	`title`
10	`breadTitle`
11	`categories`
12	`__currentLoopData`
13	`category`
14	`loop`
15	`datas`

uri: GET en/stores
middleware: web, language, compress, web
as: shop
controller: App\Http\Controllers\Front\ShopController@stores
namespace: App\Http\Controllers\Front
prefix: /en
where
file: app/Http/Controllers/Front/ShopController.php:34-69

7 statements were executed4.64ms

select * from `settings` where `settings`.`id` = '1' limit 11.6ms/app/Http/Controllers/Front/MainController.php:39ase

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Http/Controllers/Front/MainController.php:39 50. /public/index.php:53

select * from `categories` where exists (select * from `stores` inner join `store_categories` on `stores`.`id` = `store_categories`.`store_id` where `categories`.`id` = `store_categories`.`category_id` and `stores`.`deleted_at` is null) and `categories`.`deleted_at` is null

470μs/vendor/watson/rememberable/src/Query/Builder.php:56ase

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	10. /vendor/watson/rememberable/src/Query/Builder.php:56 13. /app/Http/Controllers/Front/ShopController.php:48 21. middleware::compress:19 24. middleware::language:37 27. /app/Http/Middleware/DebugbarMiddleware.php:22 73. /public/index.php:53

select * from `category_translations` where `category_translations`.`category_id` in ('1', '2', '3', '4', '9', '11', '13', '14', '15', '16', '17', '18', '19')

400μs/app/Http/Controllers/Front/ShopController.php:48ase

Metadata
Bindings	0. 1 1. 2 2. 3 3. 4 4. 9 5. 11 6. 13 7. 14 8. 15 9. 16 10. 17 11. 18 12. 19
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Http/Controllers/Front/ShopController.php:48 25. middleware::compress:19 28. middleware::language:37 31. /app/Http/Middleware/DebugbarMiddleware.php:22 77. /public/index.php:53

select count(*) as aggregate from `stores` where exists (select * from `categories` inner join `store_categories` on `categories`.`id` = `store_categories`.`category_id` where `stores`.`id` = `store_categories`.`store_id` and `store_categories`.`category_id` = '18' and `categories`.`deleted_at` is null) and `stores`.`deleted_at` is null

830μs/vendor/watson/rememberable/src/Query/Builder.php:56ase

Metadata
Bindings	0. 18
Backtrace	10. /vendor/watson/rememberable/src/Query/Builder.php:56 14. /app/Http/Controllers/Front/ShopController.php:60 22. middleware::compress:19 25. middleware::language:37 28. /app/Http/Middleware/DebugbarMiddleware.php:22 74. /public/index.php:53

select * from `stores` where exists (select * from `categories` inner join `store_categories` on `categories`.`id` = `store_categories`.`category_id` where `stores`.`id` = `store_categories`.`store_id` and `store_categories`.`category_id` = '18' and `categories`.`deleted_at` is null) and `stores`.`deleted_at` is null order by `created_at` desc limit 18 offset 18

750μs/vendor/watson/rememberable/src/Query/Builder.php:56ase

Metadata
Bindings	0. 18
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	10. /vendor/watson/rememberable/src/Query/Builder.php:56 14. /app/Http/Controllers/Front/ShopController.php:60 22. middleware::compress:19 25. middleware::language:37 28. /app/Http/Middleware/DebugbarMiddleware.php:22 74. /public/index.php:53

select * from `countries` where `countries`.`id` in ('')290μs/vendor/watson/rememberable/src/Query/Builder.php:56ase

Metadata
Bindings	0.
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	10. /vendor/watson/rememberable/src/Query/Builder.php:56 19. /app/Http/Controllers/Front/ShopController.php:60 27. middleware::compress:19 30. middleware::language:37 33. /app/Http/Middleware/DebugbarMiddleware.php:22 79. /public/index.php:53

select * from `store_translations` where `store_translations`.`store_id` in ('11')300μs/app/Http/Controllers/Front/ShopController.php:60ase

Metadata
Bindings	0. 11
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /app/Http/Controllers/Front/ShopController.php:60 26. middleware::compress:19 29. middleware::language:37 32. /app/Http/Middleware/DebugbarMiddleware.php:22 78. /public/index.php:53

web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
admin: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
warehouse: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
worker: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
courier: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
user: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: 2voOMFB2RXRw6Vb7Xgzq92Th9AIrd8OOQavLFRgb
_previous: array:1 [ "url" => "https://api.dev.aseshop.az/en/stores?cat=18&page=2" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:2 [ "cat" => "18" "page" => "2" ]
request_request: array:2 [ "cat" => "18" "page" => "2" ]
request_headers: array:15 [ "host" => array:1 [ 0 => "api.dev.aseshop.az" ] "connection" => array:1 [ 0...
request_server: array:45 [ "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "api.dev.aseshop.az" "REDIRECT_S...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /en/stores
session_attributes: array:3 [ "_token" => "2voOMFB2RXRw6Vb7Xgzq92Th9AIrd8OOQavLFRgb" "_previous" => array:1 [ "u...

Best Online Shops

Best Online Shops