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

925.75ms4MBGET category/{id}/{type?}

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	`breadcrumbs`

Params
0	`paginator`
1	`elements`

4 statements were executed140.1ms

select * from "dist" where "dist"."dist_no" = 'DB99' limit 1113.74ms6ce
Metadata
Bindings
0. DB99
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" = 'DB' limit 12.92ms6ce
Metadata
Bindings
0. DB
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 ('DB99')10.06ms6ce
Metadata
Bindings
0. A
1. DB99
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 ('DB99') order by "item_no" asc limit 20 offset 4013.38ms6ce
Metadata
Bindings
0. A
1. DB99
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. DB99
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. DB
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. A 1. DB99

Metadata
Bindings	0. A 1. DB99
Hints	Use `SELECT *` only if you need all columns from table

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:9 [ "host" => array:1 [ 0 => "6x8.com.tw" ] "connection" => array:1 [ 0 => "keep...
request_server: array:37 [ "REDIRECT_UNIQUE_ID" => "Z-KbAlcv2oHq1Sp@O2jo4QAAAAY" "REDIRECT_STATUS" => "200" "U...
request_cookies: array:2 [ "XSRF-TOKEN" => "8tJhk0vZUniI1U1NxEQnXoEEwbaiV7nI1FqGsSEB" "laravel_session" => "1yWM6...
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /category/DB99
session_attributes: array:4 [ "_token" => "8tJhk0vZUniI1U1NxEQnXoEEwbaiV7nI1FqGsSEB" "PHPDEBUGBAR_STACK_DATA" => [] ...