DHC Mart

Messages Timeline Exceptions Views6 Route Queries15 Mails Auth Gate Session Request

201.32ms14MBGET category/{category?}/{subcategory?}/{subsubcategory?}

Booting (104.61ms)
Application (138.19ms)

6 templates were rendered

user.product (resources/views/user/product.blade.php)4blade
Params
0
product
1
subcategory
2
catdetail
3
category
pagination::default (resources/views/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`product`
1	`subcategory`
2	`catdetail`
3	`category`

Params
0	`paginator`
1	`elements`

user.layouts.subapp (resources/views/user/layouts/subapp.blade.php)14blade


obLevel
__env
app
errors
product
subcategory
catdetail
category
banner
__currentLoopData
loop
p
bannerimage
sitesetting

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`catdetail`
7	`category`
8	`banner`
9	`__currentLoopData`
10	`loop`
11	`p`
12	`bannerimage`
13	`sitesetting`

user.layouts.subheader (resources/views/user/layouts/subheader.blade.php)14blade


obLevel
__env
app
errors
product
subcategory
catdetail
category
banner
__currentLoopData
loop
p
bannerimage
sitesetting

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`catdetail`
7	`category`
8	`banner`
9	`__currentLoopData`
10	`loop`
11	`p`
12	`bannerimage`
13	`sitesetting`

user.layouts.minicart (resources/views/user/layouts/minicart.blade.php)21blade


obLevel
__env
app
errors
product
subcategory
catdetail
category
banner
__currentLoopData
loop
p
bannerimage
sitesetting
categorytree
subsubcategory
query
bestseller
singltree
singlesub
sub

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`catdetail`
7	`category`
8	`banner`
9	`__currentLoopData`
10	`loop`
11	`p`
12	`bannerimage`
13	`sitesetting`
14	`categorytree`
15	`subsubcategory`
16	`query`
17	`bestseller`
18	`singltree`
19	`singlesub`
20	`sub`

user.layouts.footer (resources/views/user/layouts/footer.blade.php)14blade


obLevel
__env
app
errors
product
subcategory
catdetail
category
banner
__currentLoopData
loop
p
bannerimage
sitesetting

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`product`
5	`subcategory`
6	`catdetail`
7	`category`
8	`banner`
9	`__currentLoopData`
10	`loop`
11	`p`
12	`bannerimage`
13	`sitesetting`

uri: GET category/{category?}/{subcategory?}/{subsubcategory?}
middleware: web
controller: App\Http\Controllers\UserAuth\ProductController@index
namespace: App\Http\Controllers
prefix: null
where
file: app/Http/Controllers/UserAuth/ProductController.php:22-102

15 statements were executed, 3 of which were duplicated, 12 unique28.1ms

select * from `subsubcategories` where `slug` = 'pooja-temple' and `status` = 'Active' and `subsubcategories`.`deleted_at` is null limit 1

7.46ms/app/Http/Controllers/UserAuth/ProductController.php:79myallportfolio_dhcmart

Metadata
Bindings	0. pooja-temple 1. Active
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/ProductController.php:79 63. /public/index.php:53

select * from `products` where `subsubcategory_id` = '244' and `status` = 'Active' and `products`.`deleted_at` is null3.08ms/app/Http/Controllers/UserAuth/ProductController.php:85myallportfolio_dhcmart
Metadata
Bindings
0. 244
1. Active
Hints
Use SELECT * only if you need all columns from table
Backtrace
12. /app/Http/Controllers/UserAuth/ProductController.php:85
62. /public/index.php:53
select count(*) as aggregate from `products` where `subsubcategory_id` = '244' and `status` = 'Active' and `products`.`deleted_at` is null690μs/app/Http/Controllers/UserAuth/ProductController.php:86myallportfolio_dhcmart
Metadata
Bindings
0. 244
1. Active
Backtrace
13. /app/Http/Controllers/UserAuth/ProductController.php:86
63. /public/index.php:53

select * from `products` where `subsubcategory_id` = '244' and `status` = 'Active' and `products`.`deleted_at` is null limit 12 offset 0

990μs/app/Http/Controllers/UserAuth/ProductController.php:86myallportfolio_dhcmart

Metadata
Bindings	0. 244 1. Active
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/ProductController.php:86 63. /public/index.php:53

select * from `subcategories` where `id` = '18' and `subcategories`.`deleted_at` is null limit 11.66ms/app/Http/Controllers/UserAuth/ProductController.php:89myallportfolio_dhcmart

Metadata
Bindings	0. 18
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/ProductController.php:89 63. /public/index.php:53

select * from `categories` where `id` = '7' and `categories`.`deleted_at` is null limit 11.71ms/app/Http/Controllers/UserAuth/ProductController.php:90myallportfolio_dhcmart

Metadata
Bindings	0. 7
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/ProductController.php:90 63. /public/index.php:53

select * from `banners` where `banners`.`deleted_at` is null2.17msview::user.product:47myallportfolio_dhcmart
Metadata
Hints
Use SELECT * only if you need all columns from table
Backtrace
14. view::user.product:47
21. /vendor/symfony/http-foundation/Response.php:206
67. /public/index.php:53

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. view::user.product:47 21. /vendor/symfony/http-foundation/Response.php:206 67. /public/index.php:53

select * from `bannerimages` limit 11.85msview::user.product:187myallportfolio_dhcmart

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. view::user.product:187 22. /vendor/symfony/http-foundation/Response.php:206 68. /public/index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 12.57msview::user.product:199myallportfolio_dhcmart

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	13. view::user.product:199 20. /vendor/symfony/http-foundation/Response.php:206 66. /public/index.php:53

select * from `categories` where `status` = 'Active' and `categories`.`deleted_at` is null710μsview::user.layouts.subheader:2myallportfolio_dhcmart

Metadata
Bindings	0. Active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. view::user.layouts.subheader:2 18. view::user.layouts.subapp:21 24. view::user.product:323 31. /vendor/symfony/http-foundation/Response.php:206 77. /public/index.php:53

select * from `subcategories` where `status` = 'Active' and `subcategories`.`category_id` in ('7', '21', '22', '23', '24', '25', '26') and `subcategories`.`deleted_at` is null

820μsview::user.layouts.subheader:2myallportfolio_dhcmart

Metadata
Bindings	0. Active 1. 7 2. 21 3. 22 4. 23 5. 24 6. 25 7. 26
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. view::user.layouts.subheader:2 24. view::user.layouts.subapp:21 30. view::user.product:323 37. /vendor/symfony/http-foundation/Response.php:206 83. /public/index.php:53

select * from `subsubcategories` where `status` = 'Active' and `subsubcategories`.`deleted_at` is null1.85msview::user.layouts.subheader:3myallportfolio_dhcmart

Metadata
Bindings	0. Active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. view::user.layouts.subheader:3 18. view::user.layouts.subapp:21 24. view::user.product:323 31. /vendor/symfony/http-foundation/Response.php:206 77. /public/index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 1860μsview::user.layouts.subheader:4myallportfolio_dhcmart

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	13. view::user.layouts.subheader:4 19. view::user.layouts.subapp:21 25. view::user.product:323 32. /vendor/symfony/http-foundation/Response.php:206 78. /public/index.php:53

select * from `products` where `best_selling` = '1' and `status` = 'Active' and `parentid` is null and `products`.`deleted_at` is null order by `id` desc limit 4 offset 0

760μsview::user.layouts.subheader:10myallportfolio_dhcmart

Metadata
Bindings	0. 1 1. Active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	13. view::user.layouts.subheader:10 19. view::user.layouts.subapp:21 25. view::user.product:323 32. /vendor/symfony/http-foundation/Response.php:206 78. /public/index.php:53

select * from `sitesettings` where `sitesettings`.`deleted_at` is null limit 1920μsview::user.layouts.footer:1myallportfolio_dhcmart

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	13. view::user.layouts.footer:1 19. view::user.layouts.subapp:23 25. view::user.product:323 32. /vendor/symfony/http-foundation/Response.php:206 78. /public/index.php:53

vendor: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
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: KQBDtqv8lLJdWkaiVjVzfWpUAkZo3kFdTC8aamPK
_previous: array:1 [ "url" => "https://mail.echoexitportfolio.com/dhcmart/index.php/category/home-decor/pooja...
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:16 [ "x-https" => array:1 [ 0 => "1" ] "accept-encoding" => array:1 [ 0 => "gzip...
request_server: array:52 [ "USER" => "myallportfolio" "HOME" => "/home/myallportfolio" "PATH_TRANSLATED" => "/...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /category/home-decor/pooja-room/pooja-temple
session_attributes: array:3 [ "_token" => "KQBDtqv8lLJdWkaiVjVzfWpUAkZo3kFdTC8aamPK" "_previous" => array:1 [ "u...

Pooja Temple

World-Wide Shipping

30 Days Return

Support 24/7

Member Discount