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

284.56ms2MBGET 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 executed39.4ms

select * from "dist" where "dist"."dist_no" = 'TH01' limit 118.07ms6ce
Metadata
Bindings
0. TH01
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" = 'TH' limit 11.1ms6ce
Metadata
Bindings
0. TH
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 ('TH01')12.01ms6ce
Metadata
Bindings
0. A
1. TH01
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 ('TH01') order by "item_no" asc limit 20 offset 08.22ms6ce
Metadata
Bindings
0. A
1. TH01
Hints
Use SELECT * only if you need all columns from table

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

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