PlayWay System

Our Products

Messages Timeline Exceptions Views4 Route Queries9 Mails Auth Gate Session Request

223.15ms4MBGET productlist/{name?}

Booting (123.33ms)
Application (153.8ms)

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 unique44.43ms

select * from `subcategories` where `slug` = 'demo' and `subcategories`.`deleted_at` is null limit 128.2ms/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 null4.18ms/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 null1.11ms/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 13.79msview::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 11.15msview::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 null3.49msview::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 null780μ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 null750μ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: NRjt7hM0Gjr2VChjmOawdj2DUeWPpUTC7OzANJA6
_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" => "9qgIkCPFSXr6hN56NjTJxIuGWwLtVJv2wOaCAkoX" "laravel_session" => "2nVwT...
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /productlist/demo
session_attributes: array:3 [ "_token" => "NRjt7hM0Gjr2VChjmOawdj2DUeWPpUTC7OzANJA6" "_previous" => array:1 [ "u...