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

水豚萬用中卡

$999999
水豚包裝紙

$999999
水豚A4彩色影印紙

$999999
水豚16K方格筆記

$999999

Messages Timeline Exceptions Views7 Route Queries4 Mails Session Request

1.19s2MBGET category/{id}/{type?}

Booting (79.44ms)
Application (1.13s)

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 unique769.54ms

select * from "dist" where "dist"."dist_no" = 'F' limit 121.03ms6ce
Metadata
Bindings
0. F
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" = 'F' limit 11.62ms6ce
Metadata
Bindings
0. F
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. F
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. F
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 ('F', 'FA', 'FA10', 'FA47', 'FA44', 'FA45', 'FA46', 'FA43', 'FA42', 'FA40', 'FA41', 'FA15', 'FA39', 'FA08', 'FA12', 'FA38', 'FA34', 'FA13', 'FA14', 'FA11', 'FA09', 'FA07', 'FA06', 'FA05', 'FA99', 'FA04', 'FA03', 'FA01', 'FA02', 'FB', 'FB43', 'FB19', 'FB18', 'FB17', 'FB16', 'FB14', 'FB15', 'FB13', 'FB12', 'FB11', 'FB10', 'FB09', 'FB08', 'FB02', 'FB03', 'FB04', 'FB05', 'FB06', 'FB99', 'FB01', 'FB07', 'GH06', 'GH04')

310.51ms6ce

Metadata
Bindings	0. A 1. F 2. FA 3. FA10 4. FA47 5. FA44 6. FA45 7. FA46 8. FA43 9. FA42 10. FA40 11. FA41 12. FA15 13. FA39 14. FA08 15. FA12 16. FA38 17. FA34 18. FA13 19. FA14 20. FA11 21. FA09 22. FA07 23. FA06 24. FA05 25. FA99 26. FA04 27. FA03 28. FA01 29. FA02 30. FB 31. FB43 32. FB19 33. FB18 34. FB17 35. FB16 36. FB14 37. FB15 38. FB13 39. FB12 40. FB11 41. FB10 42. FB09 43. FB08 44. FB02 45. FB03 46. FB04 47. FB05 48. FB06 49. FB99 50. FB01 51. FB07 52. GH06 53. GH04

Metadata

Bindings

0. A
1. F
2. FA
3. FA10
4. FA47
5. FA44
6. FA45
7. FA46
8. FA43
9. FA42
10. FA40
11. FA41
12. FA15
13. FA39
14. FA08
15. FA12
16. FA38
17. FA34
18. FA13
19. FA14
20. FA11
21. FA09
22. FA07
23. FA06
24. FA05
25. FA99
26. FA04
27. FA03
28. FA01
29. FA02
30. FB
31. FB43
32. FB19
33. FB18
34. FB17
35. FB16
36. FB14
37. FB15
38. FB13
39. FB12
40. FB11
41. FB10
42. FB09
43. FB08
44. FB02
45. FB03
46. FB04
47. FB05
48. FB06
49. FB99
50. FB01
51. FB07
52. GH06
53. GH04

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 ('F', 'FA', 'FA10', 'FA47', 'FA44', 'FA45', 'FA46', 'FA43', 'FA42', 'FA40', 'FA41', 'FA15', 'FA39', 'FA08', 'FA12', 'FA38', 'FA34', 'FA13', 'FA14', 'FA11', 'FA09', 'FA07', 'FA06', 'FA05', 'FA99', 'FA04', 'FA03', 'FA01', 'FA02', 'FB', 'FB43', 'FB19', 'FB18', 'FB17', 'FB16', 'FB14', 'FB15', 'FB13', 'FB12', 'FB11', 'FB10', 'FB09', 'FB08', 'FB02', 'FB03', 'FB04', 'FB05', 'FB06', 'FB99', 'FB01', 'FB07', 'GH06', 'GH04') order by "item_no" asc limit 20 offset 8080

436.38ms6ce

Metadata

Metadata
Bindings	0. A 1. F 2. FA 3. FA10 4. FA47 5. FA44 6. FA45 7. FA46 8. FA43 9. FA42 10. FA40 11. FA41 12. FA15 13. FA39 14. FA08 15. FA12 16. FA38 17. FA34 18. FA13 19. FA14 20. FA11 21. FA09 22. FA07 23. FA06 24. FA05 25. FA99 26. FA04 27. FA03 28. FA01 29. FA02 30. FB 31. FB43 32. FB19 33. FB18 34. FB17 35. FB16 36. FB14 37. FB15 38. FB13 39. FB12 40. FB11 41. FB10 42. FB09 43. FB08 44. FB02 45. FB03 46. FB04 47. FB05 48. FB06 49. FB99 50. FB01 51. FB07 52. GH06 53. GH04
Hints	Use `SELECT *` only if you need all columns from table

Bindings

0. A
1. F
2. FA
3. FA10
4. FA47
5. FA44
6. FA45
7. FA46
8. FA43
9. FA42
10. FA40
11. FA41
12. FA15
13. FA39
14. FA08
15. FA12
16. FA38
17. FA34
18. FA13
19. FA14
20. FA11
21. FA09
22. FA07
23. FA06
24. FA05
25. FA99
26. FA04
27. FA03
28. FA01
29. FA02
30. FB
31. FB43
32. FB19
33. FB18
34. FB17
35. FB16
36. FB14
37. FB15
38. FB13
39. FB12
40. FB11
41. FB10
42. FB09
43. FB08
44. FB02
45. FB03
46. FB04
47. FB05
48. FB06
49. FB99
50. FB01
51. FB07
52. GH06
53. GH04

Hints

Use SELECT * only if you need all columns from table

_token: c1V1E1BwdokWnw1zXQZWzE9OlMeREnR5uMzV8QLc
PHPDEBUGBAR_STACK_DATA: []

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