PlayWay System

Our Products

Messages Timeline Exceptions Views4 Route Queries9 Mails Auth Gate Session Request

124.43ms4MBGET productlist/{name?}

Booting (71.07ms)
Application (77.11ms)

4 templates were rendered

user.productlist (resources/views/user/productlist.blade.php)2blade
Params
0
product
1
subcategory
user.layouts.app (resources/views/user/layouts/app.blade.php)9blade
Params
0
obLevel
1
__env
2
app
3
errors
4
product
5
subcategory
6
sitesetting
7
__currentLoopData
8
loop
user.layouts.header (resources/views/user/layouts/header.blade.php)9blade
Params
0
obLevel
1
__env
2
app
3
errors
4
product
5
subcategory
6
sitesetting
7
__currentLoopData
8
loop
user.layouts.footer (resources/views/user/layouts/footer.blade.php)9blade
Params
0
obLevel
1
__env
2
app
3
errors
4
product
5
subcategory
6
sitesetting
7
__currentLoopData
8
loop

Params
0	`product`
1	`subcategory`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`sitesetting`
7	`__currentLoopData`
8	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`sitesetting`
7	`__currentLoopData`
8	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`sitesetting`
7	`__currentLoopData`
8	`loop`

uri: GET productlist/{name?}
middleware: web
controller: App\Http\Controllers\UserAuth\SubcategoryController@productlist
namespace: App\Http\Controllers
prefix: null
where
file: app/Http/Controllers/UserAuth/SubcategoryController.php:47-75

9 statements were executed, 3 of which were duplicated, 6 unique16.84ms

select * from `subcategories` where `slug` = 'demo' and `subcategories`.`deleted_at` is null limit 16.5ms/app/Http/Controllers/UserAuth/SubcategoryController.php:54myallportfolio_project2_db

Metadata
Bindings	0. demo
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	13. /app/Http/Controllers/UserAuth/SubcategoryController.php:54 63. /index.php:53

select * from `products` where `subcategory_id` = '2' and `products`.`deleted_at` is null2ms/app/Http/Controllers/UserAuth/SubcategoryController.php:60myallportfolio_project2_db
Metadata
Bindings
0. 2
Hints
Use SELECT * only if you need all columns from table
Backtrace
12. /app/Http/Controllers/UserAuth/SubcategoryController.php:60
62. /index.php:53
select count(*) as aggregate from `products` where `subcategory_id` = '2' and `products`.`deleted_at` is null510μs/app/Http/Controllers/UserAuth/SubcategoryController.php:61myallportfolio_project2_db
Metadata
Bindings
0. 2
Backtrace
13. /app/Http/Controllers/UserAuth/SubcategoryController.php:61
63. /index.php:53

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/UserAuth/SubcategoryController.php:60 62. /index.php:53

Metadata
Bindings	0. 2
Backtrace	13. /app/Http/Controllers/UserAuth/SubcategoryController.php:61 63. /index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 12.61msview::user.productlist:2myallportfolio_project2_db

Metadata
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	15. view::user.productlist:2 22. /vendor/symfony/http-foundation/Response.php:206 68. /index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 1680μsview::user.layouts.header:2myallportfolio_project2_db

Metadata
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	15. view::user.layouts.header:2 21. view::user.layouts.app:56 27. view::user.productlist:68 34. /vendor/symfony/http-foundation/Response.php:206 80. /index.php:53

select * from `categories` where `categories`.`deleted_at` is null2.33msview::user.layouts.header:3myallportfolio_project2_db

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. view::user.layouts.header:3 20. view::user.layouts.app:56 26. view::user.productlist:68 33. /vendor/symfony/http-foundation/Response.php:206 79. /index.php:53

select * from `subcategories` where `subcategories`.`deleted_at` is null620μsview::user.layouts.header:4myallportfolio_project2_db

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. view::user.layouts.header:4 20. view::user.layouts.app:56 26. view::user.productlist:68 33. /vendor/symfony/http-foundation/Response.php:206 79. /index.php:53

select * from `products` where `products`.`deleted_at` is null610μsview::user.layouts.header:5myallportfolio_project2_db

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. view::user.layouts.header:5 20. view::user.layouts.app:56 26. view::user.productlist:68 33. /vendor/symfony/http-foundation/Response.php:206 79. /index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 1980μsview::user.layouts.footer:2myallportfolio_project2_db

Metadata
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	15. view::user.layouts.footer:2 21. view::user.layouts.app:58 27. view::user.productlist:68 34. /vendor/symfony/http-foundation/Response.php:206 80. /index.php:53

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

_token: fBoKCmZIQsCvilmj9mzrI3TXyU0fEWsW0PDYso5G
_previous: array:1 [ "url" => "https://mail.echoexitportfolio.com/project2/productlist/demo" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:17 [ "x-https" => array:1 [ 0 => "1" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=ey...
request_server: array:58 [ "USER" => "myallportfolio" "HOME" => "/home/myallportfolio" "SCRIPT_NAME" => "/proj...
request_cookies: array:2 [ "XSRF-TOKEN" => "VLvmh6wRLlMzk9YeeGcNSKMS8bYGCD7W8cZXXZ8b" "laravel_session" => "17WIJ...
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /productlist/demo
session_attributes: array:3 [ "_token" => "fBoKCmZIQsCvilmj9mzrI3TXyU0fEWsW0PDYso5G" "_previous" => array:1 [ "u...