HeavenMall

Messages Timeline Exceptions Views9 Route Queries11 Mails Auth Gate Session Request

42.5ms6MBGET category/{pcategory}/{category}/{id}

Booting (14.14ms)
Application (36.72ms)

9 templates were rendered

frontend.product-listing (resources/views/frontend/product-listing.blade.php)11blade


category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners

Params
0	`category_level`
1	`current_category_id`
2	`current_category_name`
3	`products`
4	`grand_parent_category`
5	`parent_category`
6	`product_category`
7	`property_categories`
8	`property_parent_categories`
9	`parent_id`
10	`banners`

frontend._partials.meta (resources/views/frontend/_partials/meta.blade.php)21blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
title
description
image
og_title
og_description
og_image

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`title`
16	`description`
17	`image`
18	`og_title`
19	`og_description`
20	`og_image`

inc.product-filter (resources/views/inc/product-filter.blade.php)20blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`

inc.list-item (resources/views/inc/list-item.blade.php)22blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2
product
current_currency

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`
20	`product`
21	`current_currency`

inc.list-item (resources/views/inc/list-item.blade.php)22blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2
product
current_currency

pagination::default (resources/views/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`
20	`product`
21	`current_currency`

Params
0	`paginator`
1	`elements`

layouts.app (resources/views/layouts/app.blade.php)31blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2
product
instrument_id
bicycle_id
watche_id
laptop_id
entertainment_id
book_id
all_category
about
cartProducts
setting

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`
20	`product`
21	`instrument_id`
22	`bicycle_id`
23	`watche_id`
24	`laptop_id`
25	`entertainment_id`
26	`book_id`
27	`all_category`
28	`about`
29	`cartProducts`
30	`setting`

layouts.head (resources/views/layouts/head.blade.php)31blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2
product
instrument_id
bicycle_id
watche_id
laptop_id
entertainment_id
book_id
all_category
about
cartProducts
setting

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`
20	`product`
21	`instrument_id`
22	`bicycle_id`
23	`watche_id`
24	`laptop_id`
25	`entertainment_id`
26	`book_id`
27	`all_category`
28	`about`
29	`cartProducts`
30	`setting`

layouts.header (resources/views/layouts/header.blade.php)45blade


obLevel
__env
app
errors
category_level
current_category_id
current_category_name
products
grand_parent_category
parent_category
product_category
property_categories
property_parent_categories
parent_id
banners
isRealEstate
__currentLoopData
banner
loop
sidebar_col2
product
instrument_id
bicycle_id
watche_id
laptop_id
entertainment_id
book_id
all_category
about
cartProducts
setting
s_logo
s_phone
s_email
s_shipping
s_price
s_shopping
s_support
s_facebook
s_google
s_twitter
s_pinterest
s_vimeo
s_rss
s_currency

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`category_level`
5	`current_category_id`
6	`current_category_name`
7	`products`
8	`grand_parent_category`
9	`parent_category`
10	`product_category`
11	`property_categories`
12	`property_parent_categories`
13	`parent_id`
14	`banners`
15	`isRealEstate`
16	`__currentLoopData`
17	`banner`
18	`loop`
19	`sidebar_col2`
20	`product`
21	`instrument_id`
22	`bicycle_id`
23	`watche_id`
24	`laptop_id`
25	`entertainment_id`
26	`book_id`
27	`all_category`
28	`about`
29	`cartProducts`
30	`setting`
31	`s_logo`
32	`s_phone`
33	`s_email`
34	`s_shipping`
35	`s_price`
36	`s_shopping`
37	`s_support`
38	`s_facebook`
39	`s_google`
40	`s_twitter`
41	`s_pinterest`
42	`s_vimeo`
43	`s_rss`
44	`s_currency`

uri: GET category/{pcategory}/{category}/{id}
middleware: web, web
controller: laravel\Http\Controllers\HomeController@categoryProduct
namespace: laravel\Http\Controllers
prefix: null
where
file: app/Http/Controllers/HomeController.php:298-418

11 statements were executed10.07ms

select `product_category_id`, `product_category_name`, `category_slug`, `product_category_phone` from `products_category` where `category_slug` = 'agribusiness' limit 1

4.53ms/app/Http/Controllers/HomeController.php:306u593223395_shop

Metadata
Bindings	0. agribusiness
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /app/Http/Controllers/HomeController.php:306 22. /app/Http/Middleware/Localization.php:28 70. /index.php:57

select `product_category_id`, `product_category_name`, `parent_id`, `category_slug`, `product_category_phone` from `products_category` where `category_slug` = 'herbicide' limit 1

240μs/app/Http/Controllers/HomeController.php:310u593223395_shop

Metadata
Bindings	0. herbicide
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /app/Http/Controllers/HomeController.php:310 22. /app/Http/Middleware/Localization.php:28 70. /index.php:57

select `product_category_id`, `product_category_name`, `product_category_phone`, `product_category_name_my` as `product_category_name`, `parent_id`, `category_slug` from `products_category` where `product_category_id` = '1080' and `category_slug` = 'organic-manures-pesticides' limit 1

200μs/app/Http/Controllers/HomeController.php:328u593223395_shop

Metadata
Bindings	0. 1080 1. organic-manures-pesticides
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /app/Http/Controllers/HomeController.php:328 22. /app/Http/Middleware/Localization.php:28 70. /index.php:57

select count(*) as aggregate from `products` where `products`.`deleted_at` is null and `products`.`is_active` = '1' and ( (products.admin_id = 1 AND products.product_supplier = 0) OR products.product_supplier IN (SELECT id FROM suppliers WHERE id = products.product_supplier AND is_active = 1) ) and `parent_category` = '1080' and `product_category` = '1081' and `products`.`deleted_at` is null580μs/app/Http/Controllers/HomeController.php:347u593223395_shop
Metadata
Bindings
0. 1
1. 1080
2. 1081
Backtrace
13. /app/Http/Controllers/HomeController.php:347
21. /app/Http/Middleware/Localization.php:28
69. /index.php:57

select `products`.* from `products` where `products`.`deleted_at` is null and `products`.`is_active` = '1' and (
(products.admin_id = 1 AND products.product_supplier = 0)
OR products.product_supplier IN (SELECT id FROM suppliers WHERE id = products.product_supplier AND is_active = 1)
) and `parent_category` = '1080' and `product_category` = '1081' and `products`.`deleted_at` is null order by `stocks` desc, `product_id` desc limit 12 offset 24

740μs/app/Http/Controllers/HomeController.php:347u593223395_shop

Metadata
Bindings	0. 1 1. 1080 2. 1081
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	13. /app/Http/Controllers/HomeController.php:347 21. /app/Http/Middleware/Localization.php:28 69. /index.php:57

select * from `products_category` where `products_category`.`product_category_id` in ('967')210μs/app/Http/Controllers/HomeController.php:347u593223395_shop

Metadata
Bindings	0. 967
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/HomeController.php:347 27. /app/Http/Middleware/Localization.php:28 75. /index.php:57

select `products_category`.`product_category_id`, `products_category`.`product_category_image`, `products_category`.`product_category_name_my` as `product_category_name`, `products`.`parent_category`, `category_slug`, count(products.product_id) as count from `products` inner join `products_category` on `products_category`.`product_category_id` = `products`.`parent_category` where ( (products.admin_id = 1 AND products.product_supplier = 0) OR products.product_supplier IN (SELECT id FROM suppliers WHERE id = products.product_supplier AND is_active = 1) ) and `products`.`product_category` = '1081' and `products`.`deleted_at` is null and `products`.`is_active` = '1' group by `products_category`.`product_category_id`, `products_category`.`product_category_image`, `products_category`.`product_category_name`, `products`.`parent_category` order by `products_category`.`created_at` desc1.25ms/app/Http/Controllers/HomeController.php:373u593223395_shop
Metadata
Bindings
0. 1081
1. 1
Backtrace
10. /app/Http/Controllers/HomeController.php:373
18. /app/Http/Middleware/Localization.php:28
66. /index.php:57
select `products_category`.`product_category_name_my` as `product_category_name`, `products_category`.`product_category_image`, `products`.`parent_category`, `products`.`product_category`, `category_slug`, COUNT(products.product_id) as count from `products` inner join `products_category` on `products_category`.`product_category_id` = `products`.`product_category` where ( (products.admin_id = 1 AND products.product_supplier = 0) OR products.product_supplier IN (SELECT id FROM suppliers WHERE id = products.product_supplier AND is_active = 1) ) and `products`.`parent_category` = '1080' and `products`.`deleted_at` is null and `products`.`is_active` = '1' group by `products_category`.`product_category_name`, `products_category`.`product_category_image`, `products`.`parent_category`, `products`.`product_category`1.54ms/app/Http/Controllers/HomeController.php:398u593223395_shop
Metadata
Bindings
0. 1080
1. 1
Backtrace
10. /app/Http/Controllers/HomeController.php:398
18. /app/Http/Middleware/Localization.php:28
66. /index.php:57

Metadata
Bindings	0. 1081 1. 1
Backtrace	10. /app/Http/Controllers/HomeController.php:373 18. /app/Http/Middleware/Localization.php:28 66. /index.php:57

Metadata
Bindings	0. 1080 1. 1
Backtrace	10. /app/Http/Controllers/HomeController.php:398 18. /app/Http/Middleware/Localization.php:28 66. /index.php:57

select * from `banners` where `published` = '1' and `category` = '967' order by `sort` asc240μs/app/Http/Controllers/HomeController.php:403u593223395_shop

Metadata
Bindings	0. 1 1. 967
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/HomeController.php:403 20. /app/Http/Middleware/Localization.php:28 68. /index.php:57

select `product_category_id`, `product_category_name_my` as `product_category_name`, `category_slug`, `product_category_image`, `product_category_moto` from `products_category` where `parent_id` = '0'

320μs/app/Providers/AppServiceProvider.php:52u593223395_shop

Metadata
Bindings	0. 0
Backtrace	10. /app/Providers/AppServiceProvider.php:52 17. view::frontend.product-listing:279 24. /vendor/symfony/http-foundation/Response.php:206 28. /app/Http/Middleware/Localization.php:28 76. /index.php:57

select * from `exchange_rates` where `type` = 'gold' order by `created_at` desc limit 1220μsview::layouts.header:2u593223395_shop

Metadata
Bindings	0. gold
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	13. view::layouts.header:2 19. view::layouts.app:40 25. view::frontend.product-listing:279 32. /vendor/symfony/http-foundation/Response.php:206 36. /app/Http/Middleware/Localization.php:28 84. /index.php:57

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 ] ]
admin-api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
supplier: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
supplier-api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
employee: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
employee-api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: B3bDuIwQbpnYhfEqrmThM0a0zxTkR3DGj0AqPN5Q
_previous: array:1 [ "url" => "https://heavenmall.net/category/agribusiness/organic-manures-pesticides/herbic...
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:1 [ "page" => "3" ]
request_request: array:1 [ "page" => "3" ]
request_headers: array:22 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,i...
request_server: array:61 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT"...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /category/agribusiness/organic-manures-pesticides/herbicide
session_attributes: array:3 [ "_token" => "B3bDuIwQbpnYhfEqrmThM0a0zxTkR3DGj0AqPN5Q" "_previous" => array:1 [ "u...

Herbicide

Organic Ma

Organic Manures & Pesticides (26)

Organic Manures & Pesticides (26)

SELECTIVE HERBICIDES FOR ALL OF PADDY FIELD WEEDS

CYHALO 10 EC

Herbicide

Organic Ma Organic Manures & Pesticides (26)

Organic Manures & Pesticides (26)

SELECTIVE HERBICIDES FOR ALL OF PADDY FIELD WEEDS

CYHALO 10 EC

Organic Ma

Organic Manures & Pesticides (26)