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

458.41ms2MBGET 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 executed48.78ms

select * from "dist" where "dist"."dist_no" = 'CC07' limit 132.87ms6ce
Metadata
Bindings
0. CC07
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" = 'CC' limit 11.05ms6ce
Metadata
Bindings
0. CC
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 ('CC07')7.86ms6ce
Metadata
Bindings
0. A
1. CC07
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 ('CC07') order by "item_no" asc limit 20 offset 2007ms6ce
Metadata
Bindings
0. A
1. CC07
Hints
Use SELECT * only if you need all columns from table

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

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