LHBBA&LXBBA 六信玩具批發(台中烏日店)

Messages Timeline Exceptions Views7 Route Queries4 Mails Session Request

648.08ms2MBGET category/{id}/{type?}

Booting (81.53ms)
Application (583.29ms)

7 templates were rendered

project.default.site.productlist (resources/views/project/default/site/productlist.blade.php)1blade
Params
0
Upper
project.default.site.leftmenu (resources/views/project/default/site/leftmenu.blade.php)5blade
Params
0
obLevel
1
__env
2
app
3
errors
4
Upper
breadcrumbs::bootstrap3 (vendor/davejamesmiller/laravel-breadcrumbs/views/bootstrap3.blade.php)1blade
Params
0
breadcrumbs
pagination::default (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/default.blade.php)2blade
Params
0
paginator
1
elements
layouts.site (resources/views/layouts/site.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
Upper
5
i
6
col
7
max
8
height
9
width
10
__currentLoopData
11
item
12
loop
13
file
14
image
layouts.header (resources/views/layouts/header.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
Upper
5
i
6
col
7
max
8
height
9
width
10
__currentLoopData
11
item
12
loop
13
file
14
image
user.menu.CategoryTop (resources/views/user/menu/CategoryTop.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
errors
4
Upper
5
i
6
col
7
max
8
height
9
width
10
__currentLoopData
11
item
12
loop
13
file
14
image
15
CartService

Params
0	`Upper`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`Upper`

Params
0	`breadcrumbs`

Params
0	`paginator`
1	`elements`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`Upper`
5	`i`
6	`col`
7	`max`
8	`height`
9	`width`
10	`__currentLoopData`
11	`item`
12	`loop`
13	`file`
14	`image`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`Upper`
5	`i`
6	`col`
7	`max`
8	`height`
9	`width`
10	`__currentLoopData`
11	`item`
12	`loop`
13	`file`
14	`image`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`Upper`
5	`i`
6	`col`
7	`max`
8	`height`
9	`width`
10	`__currentLoopData`
11	`item`
12	`loop`
13	`file`
14	`image`
15	`CartService`

uri: GET category/{id}/{type?}
middleware: web, web
as: category
controller: App\Http\Controllers\Site\CategoryController@show
namespace: App\Http\Controllers
prefix: null
where
file: app/Http/Controllers/Site/CategoryController.php:35-138

4 statements were executed, 2 of which were duplicated, 2 unique243.88ms

select * from "dist" where "dist"."dist_no" = 'D' limit 119.81ms6ce
Metadata
Bindings
0. D
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
select * from "dist" where "dist"."dist_no" = 'D' limit 11.6ms6ce
Metadata
Bindings
0. D
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

Metadata
Bindings	0. D
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

Metadata
Bindings	0. D
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

select count(*) as aggregate from "item" inner join "itemwr" on "item"."item_no" = "itemwr"."item_no" where "itemwr"."ware_no" = 'A' and "zdate" is null and "dist_no" in ('D', 'DC', 'DC02', 'DC01', 'DC05', 'DC04', 'DC03', 'DD', 'DD04', 'DD01', 'DD02', 'DD03', 'DE', 'DE03', 'DE02', 'DE04', 'DE01', 'DA', 'DA05', 'DA01', 'DA04', 'DA03', 'DA02', 'DB', 'DB99', 'DB05', 'DB01', 'DB02', 'DB03', 'DB04')

110.32ms6ce

Metadata
Bindings	0. A 1. D 2. DC 3. DC02 4. DC01 5. DC05 6. DC04 7. DC03 8. DD 9. DD04 10. DD01 11. DD02 12. DD03 13. DE 14. DE03 15. DE02 16. DE04 17. DE01 18. DA 19. DA05 20. DA01 21. DA04 22. DA03 23. DA02 24. DB 25. DB99 26. DB05 27. DB01 28. DB02 29. DB03 30. DB04

select item.*,CASE WHEN itemwr.qty-itemwr.orde_way_qty-itemwr.safe_qty > 0 THEN itemwr.qty-itemwr.orde_way_qty-itemwr.safe_qty ELSE 0 END as orde_qty from "item" inner join "itemwr" on "item"."item_no" = "itemwr"."item_no" where "itemwr"."ware_no" = 'A' and "zdate" is null and "dist_no" in ('D', 'DC', 'DC02', 'DC01', 'DC05', 'DC04', 'DC03', 'DD', 'DD04', 'DD01', 'DD02', 'DD03', 'DE', 'DE03', 'DE02', 'DE04', 'DE01', 'DA', 'DA05', 'DA01', 'DA04', 'DA03', 'DA02', 'DB', 'DB99', 'DB05', 'DB01', 'DB02', 'DB03', 'DB04') order by "item_no" asc limit 20 offset 1000

112.15ms6ce

Metadata
Bindings	0. A 1. D 2. DC 3. DC02 4. DC01 5. DC05 6. DC04 7. DC03 8. DD 9. DD04 10. DD01 11. DD02 12. DD03 13. DE 14. DE03 15. DE02 16. DE04 17. DE01 18. DA 19. DA05 20. DA01 21. DA04 22. DA03 23. DA02 24. DB 25. DB99 26. DB05 27. DB01 28. DB02 29. DB03 30. DB04
Hints	Use `SELECT *` only if you need all columns from table

_token: etoWAFQx9B6KkuWfFzyCRn4PbUogRySufbAx3EcW
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:1 [ "page" => "51" ]
request_request: array:1 [ "page" => "51" ]
request_headers: array:8 [ "host" => array:1 [ 0 => "6x8.com.tw" ] "connection" => array:1 [ 0 => "keep...
request_server: array:36 [ "REDIRECT_UNIQUE_ID" => "aCXpixkKXdrCF7Wk1yz4ggAAAAU" "REDIRECT_STATUS" => "200" "U...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /category/D
session_attributes: array:2 [ "_token" => "etoWAFQx9B6KkuWfFzyCRn4PbUogRySufbAx3EcW" "PHPDEBUGBAR_STACK_DATA" => [] ...