Myanmar Music Yamaha- HeavenMall

Messages Timeline Exceptions Views8 Route Queries13 Mails Auth Gate Session Request

39.05ms6MBGET supplier/{id}/{category}

Booting (9.84ms)
Application (35.6ms)

8 templates were rendered

frontend.supplier-product (resources/views/frontend/supplier-product.blade.php)5blade
Params
0
supplier_name
1
covers
2
products
3
parent_category
4
product_category

Params
0	`supplier_name`
1	`covers`
2	`products`
3	`parent_category`
4	`product_category`

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


obLevel
__env
app
errors
supplier_name
covers
products
parent_category
product_category
s_logo
title
description
image
og_title
og_description
og_image

frontend.supplier-product-filter (resources/views/frontend/supplier-product-filter.blade.php)11blade
Params
0
obLevel
1
__env
2
app
3
errors
4
supplier_name
5
covers
6
products
7
parent_category
8
product_category
9
s_logo
10
sidebar_col2

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`title`
11	`description`
12	`image`
13	`og_title`
14	`og_description`
15	`og_image`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`sidebar_col2`

inc.search-item (resources/views/inc/search-item.blade.php)15blade


obLevel
__env
app
errors
supplier_name
covers
products
parent_category
product_category
s_logo
__currentLoopData
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	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`__currentLoopData`
11	`loop`
12	`sidebar_col2`
13	`product`
14	`current_currency`

Params
0	`paginator`
1	`elements`

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


obLevel
__env
app
errors
supplier_name
covers
products
parent_category
product_category
s_logo
__currentLoopData
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	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`__currentLoopData`
11	`loop`
12	`sidebar_col2`
13	`product`
14	`instrument_id`
15	`bicycle_id`
16	`watche_id`
17	`laptop_id`
18	`entertainment_id`
19	`book_id`
20	`all_category`
21	`about`
22	`cartProducts`
23	`setting`

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


obLevel
__env
app
errors
supplier_name
covers
products
parent_category
product_category
s_logo
__currentLoopData
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	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`__currentLoopData`
11	`loop`
12	`sidebar_col2`
13	`product`
14	`instrument_id`
15	`bicycle_id`
16	`watche_id`
17	`laptop_id`
18	`entertainment_id`
19	`book_id`
20	`all_category`
21	`about`
22	`cartProducts`
23	`setting`

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


obLevel
__env
app
errors
supplier_name
covers
products
parent_category
product_category
s_logo
__currentLoopData
loop
sidebar_col2
product
instrument_id
bicycle_id
watche_id
laptop_id
entertainment_id
book_id
all_category
about
cartProducts
setting
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	`supplier_name`
5	`covers`
6	`products`
7	`parent_category`
8	`product_category`
9	`s_logo`
10	`__currentLoopData`
11	`loop`
12	`sidebar_col2`
13	`product`
14	`instrument_id`
15	`bicycle_id`
16	`watche_id`
17	`laptop_id`
18	`entertainment_id`
19	`book_id`
20	`all_category`
21	`about`
22	`cartProducts`
23	`setting`
24	`s_phone`
25	`s_email`
26	`s_shipping`
27	`s_price`
28	`s_shopping`
29	`s_support`
30	`s_facebook`
31	`s_google`
32	`s_twitter`
33	`s_pinterest`
34	`s_vimeo`
35	`s_rss`
36	`s_currency`

uri: GET supplier/{id}/{category}
middleware: web, web
controller: laravel\Http\Controllers\frontend\ProductController@suppliercategory
namespace: laravel\Http\Controllers
prefix: null
where
file: app/Http/Controllers/frontend/ProductController.php:466-514

13 statements were executed, 2 of which were duplicated, 11 unique9.44ms

select * from `suppliers` where `id` = '130' and `is_active` = '1' limit 11.64ms/app/Http/Controllers/frontend/ProductController.php:471u593223395_shop

Metadata
Bindings	0. 130 1. 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	14. /app/Http/Controllers/frontend/ProductController.php:471 22. /app/Http/Middleware/Localization.php:28 70. /index.php:57

select * from `suppliers_cover` where `suppliers_cover`.`supplier_id` in ('130') order by `sort` asc290μs/app/Http/Controllers/frontend/ProductController.php:471u593223395_shop

Metadata
Bindings	0. 130
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Http/Controllers/frontend/ProductController.php:471 28. /app/Http/Middleware/Localization.php:28 76. /index.php:57

select * from `products_category` where `category_slug` = 'ukulele' limit 1470μs/app/Http/Controllers/frontend/ProductController.php:476u593223395_shop

Metadata
Bindings	0. ukulele
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	14. /app/Http/Controllers/frontend/ProductController.php:476 22. /app/Http/Middleware/Localization.php:28 70. /index.php:57

select count(*) as aggregate from `products` inner join `products_category` on `products`.`product_category` = `products_category`.`product_category_id` inner join `suppliers` on `products`.`product_supplier` = `suppliers`.`id` left join `brands` on `products`.`product_brand` = `brands`.`id` where (`products`.`product_category` = '238' and `products`.`product_supplier` = '130' and `products`.`deleted_at` is null and `products`.`is_active` = '1') and `products`.`deleted_at` is null580μs/app/Http/Controllers/frontend/ProductController.php:490u593223395_shop
Metadata
Bindings
0. 238
1. 130
2. 1
Backtrace
13. /app/Http/Controllers/frontend/ProductController.php:490
21. /app/Http/Middleware/Localization.php:28
69. /index.php:57

select `products`.*, `products_category`.`product_category_name`, `brands`.`name`, `brands`.`id` as `b_id`, `suppliers`.`name` as `supplier` from `products` inner join `products_category` on `products`.`product_category` = `products_category`.`product_category_id` inner join `suppliers` on `products`.`product_supplier` = `suppliers`.`id` left join `brands` on `products`.`product_brand` = `brands`.`id` where (`products`.`product_category` = '238' and `products`.`product_supplier` = '130' and `products`.`deleted_at` is null and `products`.`is_active` = '1') and `products`.`deleted_at` is null limit 12 offset 0

680μs/app/Http/Controllers/frontend/ProductController.php:490u593223395_shop

Metadata
Bindings	0. 238 1. 130 2. 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	13. /app/Http/Controllers/frontend/ProductController.php:490 21. /app/Http/Middleware/Localization.php:28 69. /index.php:57

select DISTINCT(products.parent_category) AS category from `products` where (`products`.`product_category` = '238' and `products`.`product_supplier` = '130' and `products`.`deleted_at` is null and `products`.`is_active` = '1')420μs/app/Http/Controllers/frontend/ProductController.php:495u593223395_shop
Metadata
Bindings
0. 238
1. 130
2. 1
Backtrace
10. /app/Http/Controllers/frontend/ProductController.php:495
18. /app/Http/Middleware/Localization.php:28
66. /index.php:57
select DISTINCT(products.product_category) AS category from `products` where (`products`.`product_category` = '238' and `products`.`product_supplier` = '130' and `products`.`deleted_at` is null and `products`.`is_active` = '1')400μs/app/Http/Controllers/frontend/ProductController.php:501u593223395_shop
Metadata
Bindings
0. 238
1. 130
2. 1
Backtrace
10. /app/Http/Controllers/frontend/ProductController.php:501
18. /app/Http/Middleware/Localization.php:28
66. /index.php:57

select `products_category`.*, (SELECT COUNT(product_id) FROM products WHERE parent_category = products_category.product_category_id AND is_active = 1 AND deleted_at IS NULL AND product_supplier = 130) AS count from `products_category` where `product_category_id` in ('8')

3.16ms/app/Services/Manager/CategoryManager.php:46u593223395_shop

Metadata
Bindings	0. 8
Backtrace	12. /app/Services/Manager/CategoryManager.php:46 13. /app/Http/Controllers/frontend/ProductController.php:504 21. /app/Http/Middleware/Localization.php:28 69. /index.php:57

select `products_category`.*, (SELECT COUNT(product_id) FROM products WHERE product_category = products_category.product_category_id AND is_active = 1 AND deleted_at IS NULL AND product_supplier = 130) AS count from `products_category` where `product_category_id` in ('238')

510μs/app/Services/Manager/CategoryManager.php:63u593223395_shop

Metadata
Bindings	0. 238
Backtrace	12. /app/Services/Manager/CategoryManager.php:63 13. /app/Http/Controllers/frontend/ProductController.php:505 21. /app/Http/Middleware/Localization.php:28 69. /index.php:57

select `product_category_name` from `products_category` where `product_category_id` = '3' limit 1330μs/app/AppHelper.php:402u593223395_shop

Metadata
Bindings	0. 3
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/AppHelper.php:402 14. view::inc.search-item:61 20. view::frontend.supplier-product:160 27. /vendor/symfony/http-foundation/Response.php:206 31. /app/Http/Middleware/Localization.php:28 79. /index.php:57

select `product_category_name` from `products_category` where `product_category_id` = '3' limit 1280μs/app/AppHelper.php:402u593223395_shop

Metadata
Bindings	0. 3
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/AppHelper.php:402 14. view::inc.search-item:82 20. view::frontend.supplier-product:160 27. /vendor/symfony/http-foundation/Response.php:206 31. /app/Http/Middleware/Localization.php:28 79. /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'

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

Metadata
Bindings	0. 0
Backtrace	10. /app/Providers/AppServiceProvider.php:52 17. view::frontend.supplier-product:192 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 1320μ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.supplier-product:192 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: 2v0mhpszoVrrBdFxSDek4rYrzP57SKvtcYW8aqPW
_previous: array:1 [ "url" => "https://heavenmall.net/supplier/130/ukulele" ]
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:22 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,i...
request_server: array:60 [ "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: /supplier/130/ukulele
session_attributes: array:3 [ "_token" => "2v0mhpszoVrrBdFxSDek4rYrzP57SKvtcYW8aqPW" "_previous" => array:1 [ "u...

Myanmar Music Yamaha
Normal Supplier

Guitars (75)

Guitars (75)

Yamaha GL1 NT

Myanmar Music Yamaha Normal Supplier

Guitars (75)

Guitars (75)

Yamaha GL1 NT

Myanmar Music Yamaha
Normal Supplier