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

790.9ms2MBGET 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 executed95.36ms

select * from "dist" where "dist"."dist_no" = 'FA01' limit 129.52ms6ce
Metadata
Bindings
0. FA01
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" = 'FA' limit 19.5ms6ce
Metadata
Bindings
0. FA
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 ('FA01')36.19ms6ce
Metadata
Bindings
0. A
1. FA01
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 ('FA01') order by "item_no" asc limit 20 offset 46020.15ms6ce
Metadata
Bindings
0. A
1. FA01
Hints
Use SELECT * only if you need all columns from table

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

Metadata
Bindings	0. A 1. FA01
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" => "24" ]
request_request: array:1 [ "page" => "24" ]
request_headers: array:10 [ "host" => array:1 [ 0 => "6x8.com.tw" ] "pragma" => array:1 [ 0 => "no-cach...
request_server: array:38 [ "REDIRECT_UNIQUE_ID" => "aFIryj2sC@VQEgC9ojh0gQAAAAQ" "REDIRECT_STATUS" => "200" "U...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /category/FA01
session_attributes: array:2 [ "_token" => "6uq349J2LaZCnWu581piPiBBFtm50v0Ts590NbFZ" "PHPDEBUGBAR_STACK_DATA" => [] ...