CakePHP: the rapid development php framework: PickupPoints

Pickup Points

Id	Pickup Point Cd	Trader	Locality	Locality Cd	Pickup Point Nm	Pickup Point Fk	Use Start Day	Remain Label Roll	Threshold Label Roll	Inventory Label Roll	Inventory Date	Created	Insert User	Modified	Update User	Actions
156	33034	01	20	33	農愛会（市川センター）	のうあいかい	2021-01-20 00:00:00	2000	1000	2000	2021-01-18 12:23:16	2021-01-18 14:03:51	MG00000001			View Edit Delete
114	44101	01	22	44	豊後大野（きばる）	ぶんごおおのきばる	2021-01-15 00:00:00	2000	1000	2000	2021-01-15 12:23:16	2021-01-15 12:23:37	MG00000005			View Edit Delete
94	NR01	09	18	37	日本農産流通株式会社	にほんのうさんりゅうつうかぶしきがいしゃ	2018-06-15 00:00:00	2000	1000	2000	2018-06-15 17:17:12	2018-06-15 17:17:23		2018-06-15 17:17:26		View Edit Delete
93	ARA01	08	17	14	荒井ベジアス	あらいべじあす	2018-03-08 17:02:00	2000	1000	2000	2018-03-08 17:02:14	2018-03-08 17:02:19	MG00000001	2017-04-18 13:36:00	MG00000001	View Edit Delete
89	24001	01	2	24	三重県	みえけん	2017-09-19 15:31:55	2000	1000	2000	2017-09-19 15:32:07					View Edit Delete
88	26004	01	5	26	久御山町	くみやまちょう	2017-09-19 15:24:40	2000	1000	2000	2017-09-19 15:25:00					View Edit Delete
87	26003	01	5	26	日吉町	ひよしまち	2017-09-11 13:56:34	2000	1000	2000	2017-09-11 13:56:54					View Edit Delete
86	SR01	03	13	20	駿河屋魚一	するがやうおいち	2017-05-11 00:00:00	2000	1000	2000	2017-05-11 00:00:00					View Edit Delete
81	27001	01	6	27	茨木市	いばらぎし	2016-08-29 00:00:00	2000	1000	2000	2017-04-18 13:36:00	2017-04-18 13:36:00	MG00000001	2017-04-18 13:36:00	MG00000001	View Edit Delete
82	36012	01	9	36	阿南市北部2	あなんしほくぶに	2016-08-29 00:00:00	2000	1000	2000	2017-04-18 13:36:00	2017-04-18 13:36:00	MG00000001	2017-04-18 13:36:00	MG00000001	View Edit Delete
83	36013	01	9	36	阿南市北部3	あなんしほくぶさん	2016-08-29 00:00:00	2000	1000	2000	2017-04-18 13:36:00	2017-04-18 13:36:00	MG00000001	2017-04-18 13:36:00	MG00000001	View Edit Delete
84	40001	01	11	40	須恵	すえ	2016-07-01 00:00:00	2000	1000	2000	2017-04-18 13:36:00	2017-04-18 13:36:00	MG00000001	2017-04-18 13:36:00	MG00000001	View Edit Delete
80	MZ01	02	14	36	南風ベジタブル	まぜべじたぶる	2017-02-22 00:00:00	2000	1000	2000	2017-02-22 00:00:00					View Edit Delete
31	26001	01	5	26	木津川市	きづがわし	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
32	26002	01	5	26	亀岡市	かめおかし	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
33	26099	01	5	26	MAB京都	えむえいびいきょうと	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
34	29001	01	4	29	大和郡山	やまとこおりやま	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
35	29002	01	4	29	郡山市	こおりやまし	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
36	29003	01	4	29	高田市	たかだし	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete
37	29004	01	4	29	五條市	ごじょうし	2016-08-29 00:00:00	2000	1000	2000	2016-08-30 12:23:16	2016-08-30 12:23:37	MG00000001	2016-08-30 12:23:37	MG00000001	View Edit Delete

Page 2 of 8, showing 20 records out of 158 total, starting on record 21, ending on 40

< previous12345678next >

Actions

(default) 2 queries took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `PickupPoint`.`id`, `PickupPoint`.`pickup_point_cd`, `PickupPoint`.`trader_id`, `PickupPoint`.`locality_id`, `PickupPoint`.`locality_cd`, `PickupPoint`.`pickup_point_nm`, `PickupPoint`.`pickup_point_fk`, `PickupPoint`.`use_start_day`, `PickupPoint`.`use_end_day`, `PickupPoint`.`margin_price_yen`, `PickupPoint`.`remain_label_roll`, `PickupPoint`.`threshold_label_roll`, `PickupPoint`.`inventory_label_roll`, `PickupPoint`.`inventory_date`, `PickupPoint`.`created`, `PickupPoint`.`insert_user`, `PickupPoint`.`modified`, `PickupPoint`.`update_user`, `PickupPoint`.`password`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user`, `Locality`.`id`, `Locality`.`trader_id`, `Locality`.`locality_cd`, `Locality`.`locality_nm`, `Locality`.`use_start_day`, `Locality`.`use_end_day`, `Locality`.`created`, `Locality`.`insert_user`, `Locality`.`modified`, `Locality`.`update_user` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1 ORDER BY `PickupPoint`.`inventory_date` desc LIMIT 20, 20		20	20	1
2	SELECT COUNT(*) AS `count` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1		1	1	1

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerPickupPoints
- actionindex
- named(array)
  sortinventory_date
  directiondesc
  page2
- pass(empty)
- paging(array)
  PickupPoint(array)
  page2
  current20
  count158
  prevPage(true)
  nextPage(true)
  pageCount8
  order(array)
  PickupPoint.inventory_datedesc
  limit20
  options(array)
  page2
  sortinventory_date
  directiondesc
  order(array)
  PickupPoint.inventory_datedesc
  conditions(empty)
  paramTypenamed
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====
Sql Log
+

Sql Logs

default
No query logs.

====

Timer

Memory

Peak Memory Use 69.18 MB

Message	Memory use
Component initialization	3.56 MB
Controller action start	3.80 MB
Controller render start	5.96 MB
View render complete	7.59 MB

Timers

Total Request Time: 424 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.71
Event: Controller.initialize	0.03
Event: Controller.startup	0.22
Controller action	16.91
Event: Controller.beforeRender	184.43
» Processing toolbar data	184.33
Rendering View	13.07
» Event: View.beforeRender	0.04
» Rendering APP/View/PickupPoints/index.ctp	11.32
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.02
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.21
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- pickupPoints(array)
  0(array)
  PickupPoint(array)
  id156
  pickup_point_cd33034
  trader_id01
  locality_id20
  locality_cd33
  pickup_point_nm農愛会（市川センター）
  pickup_point_fkのうあいかい
  use_start_day2021-01-20 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2021-01-18 12:23:16
  created2021-01-18 14:03:51
  insert_userMG00000001
  modified(null)
  update_user
  password24000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id20
  trader_id01
  locality_cd33
  locality_nm岡山県
  use_start_day2019-04-09 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  1(array)
  PickupPoint(array)
  id114
  pickup_point_cd44101
  trader_id01
  locality_id22
  locality_cd44
  pickup_point_nm豊後大野（きばる）
  pickup_point_fkぶんごおおのきばる
  use_start_day2021-01-15 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2021-01-15 12:23:16
  created2021-01-15 12:23:37
  insert_userMG00000005
  modified(null)
  update_user
  password11500000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id22
  trader_id01
  locality_cd44
  locality_nm大分県
  use_start_day2021-01-15 00:00:00
  use_end_day(null)
  created2021-01-15 12:23:16
  insert_userMG00000005
  modified(null)
  update_user
  2(array)
  PickupPoint(array)
  id94
  pickup_point_cdNR01
  trader_id09
  locality_id18
  locality_cd37
  pickup_point_nm日本農産流通株式会社
  pickup_point_fkにほんのうさんりゅうつうかぶしきがいしゃ
  use_start_day2018-06-15 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2018-06-15 17:17:12
  created2018-06-15 17:17:23
  insert_user(null)
  modified2018-06-15 17:17:26
  update_user(null)
  password90000000
  Trader(array)
  id09
  formal_trader_nm日本農産流通株式会社
  formal_trader_fkにほんのうさんりゅうつうかぶしきがいしゃ
  designation_file
  use_start_day2018-06-15 00:00:00
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id18
  trader_id09
  locality_cd37
  locality_nm香川県
  use_start_day2018-06-15 00:00:00
  use_end_day(null)
  created2018-06-15 12:23:16
  insert_userMG00000001
  modified2018-06-15 12:23:16
  update_userMG00000001
  3(array)
  PickupPoint(array)
  id93
  pickup_point_cdARA01
  trader_id08
  locality_id17
  locality_cd14
  pickup_point_nm荒井ベジアス
  pickup_point_fkあらいべじあす
  use_start_day2018-03-08 17:02:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2018-03-08 17:02:14
  created2018-03-08 17:02:19
  insert_userMG00000001
  modified2017-04-18 13:36:00
  update_userMG00000001
  password80000000
  Trader(array)
  id08
  formal_trader_nm荒井ベジアス
  formal_trader_fkあらいべじあす
  designation_file
  use_start_day2018-03-08 17:05:50
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id17
  trader_id08
  locality_cd14
  locality_nm神奈川県平塚市
  use_start_day2018-03-08 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  4(array)
  PickupPoint(array)
  id89
  pickup_point_cd24001
  trader_id01
  locality_id2
  locality_cd24
  pickup_point_nm三重県
  pickup_point_fkみえけん
  use_start_day2017-09-19 15:31:55
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-09-19 15:32:07
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password22000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id2
  trader_id01
  locality_cd24
  locality_nm三重県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  5(array)
  PickupPoint(array)
  id88
  pickup_point_cd26004
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nm久御山町
  pickup_point_fkくみやまちょう
  use_start_day2017-09-19 15:24:40
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-09-19 15:25:00
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password30000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id5
  trader_id01
  locality_cd26
  locality_nm京都府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  6(array)
  PickupPoint(array)
  id87
  pickup_point_cd26003
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nm日吉町
  pickup_point_fkひよしまち
  use_start_day2017-09-11 13:56:34
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-09-11 13:56:54
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password20000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id5
  trader_id01
  locality_cd26
  locality_nm京都府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  7(array)
  PickupPoint(array)
  id86
  pickup_point_cdSR01
  trader_id03
  locality_id13
  locality_cd20
  pickup_point_nm駿河屋魚一
  pickup_point_fkするがやうおいち
  use_start_day2017-05-11 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-05-11 00:00:00
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password30000000
  Trader(array)
  id03
  formal_trader_nm駿河屋魚一
  formal_trader_fkするがやうおいち
  designation_file　
  use_start_day2017-05-11 00:00:00
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id13
  trader_id01
  locality_cd20
  locality_nm飛騨
  use_start_day2017-05-10 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  8(array)
  PickupPoint(array)
  id81
  pickup_point_cd27001
  trader_id01
  locality_id6
  locality_cd27
  pickup_point_nm茨木市
  pickup_point_fkいばらぎし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-04-18 13:36:00
  created2017-04-18 13:36:00
  insert_userMG00000001
  modified2017-04-18 13:36:00
  update_userMG00000001
  password00000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id6
  trader_id01
  locality_cd27
  locality_nm大阪府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  9(array)
  PickupPoint(array)
  id82
  pickup_point_cd36012
  trader_id01
  locality_id9
  locality_cd36
  pickup_point_nm阿南市北部2
  pickup_point_fkあなんしほくぶに
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-04-18 13:36:00
  created2017-04-18 13:36:00
  insert_userMG00000001
  modified2017-04-18 13:36:00
  update_userMG00000001
  password17000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id9
  trader_id01
  locality_cd36
  locality_nm徳島県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  10(array)
  PickupPoint(array)
  id83
  pickup_point_cd36013
  trader_id01
  locality_id9
  locality_cd36
  pickup_point_nm阿南市北部3
  pickup_point_fkあなんしほくぶさん
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-04-18 13:36:00
  created2017-04-18 13:36:00
  insert_userMG00000001
  modified2017-04-18 13:36:00
  update_userMG00000001
  password18000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id9
  trader_id01
  locality_cd36
  locality_nm徳島県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  11(array)
  PickupPoint(array)
  id84
  pickup_point_cd40001
  trader_id01
  locality_id11
  locality_cd40
  pickup_point_nm須恵
  pickup_point_fkすえ
  use_start_day2016-07-01 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-04-18 13:36:00
  created2017-04-18 13:36:00
  insert_userMG00000001
  modified2017-04-18 13:36:00
  update_userMG00000001
  password10000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id11
  trader_id01
  locality_cd40
  locality_nm福岡県
  use_start_day2017-01-01 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  12(array)
  PickupPoint(array)
  id80
  pickup_point_cdMZ01
  trader_id02
  locality_id14
  locality_cd36
  pickup_point_nm南風ベジタブル
  pickup_point_fkまぜべじたぶる
  use_start_day2017-02-22 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2017-02-22 00:00:00
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password08847012
  Trader(array)
  id02
  formal_trader_nm南風ベジタブル
  formal_trader_fkまぜべじたぶる
  designation_file
  use_start_day2017-01-01 00:00:00
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id14
  trader_id02
  locality_cd36
  locality_nm101徳島県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  13(array)
  PickupPoint(array)
  id31
  pickup_point_cd26001
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nm木津川市
  pickup_point_fkきづがわし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password00000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id5
  trader_id01
  locality_cd26
  locality_nm京都府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  14(array)
  PickupPoint(array)
  id32
  pickup_point_cd26002
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nm亀岡市
  pickup_point_fkかめおかし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password13000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id5
  trader_id01
  locality_cd26
  locality_nm京都府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  15(array)
  PickupPoint(array)
  id33
  pickup_point_cd26099
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nmMAB京都
  pickup_point_fkえむえいびいきょうと
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password00000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id5
  trader_id01
  locality_cd26
  locality_nm京都府
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  16(array)
  PickupPoint(array)
  id34
  pickup_point_cd29001
  trader_id01
  locality_id4
  locality_cd29
  pickup_point_nm大和郡山
  pickup_point_fkやまとこおりやま
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password11000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id4
  trader_id01
  locality_cd29
  locality_nm奈良県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  17(array)
  PickupPoint(array)
  id35
  pickup_point_cd29002
  trader_id01
  locality_id4
  locality_cd29
  pickup_point_nm郡山市
  pickup_point_fkこおりやまし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password11000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id4
  trader_id01
  locality_cd29
  locality_nm奈良県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  18(array)
  PickupPoint(array)
  id36
  pickup_point_cd29003
  trader_id01
  locality_id4
  locality_cd29
  pickup_point_nm高田市
  pickup_point_fkたかだし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password11000000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id4
  trader_id01
  locality_cd29
  locality_nm奈良県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  19(array)
  PickupPoint(array)
  id37
  pickup_point_cd29004
  trader_id01
  locality_id4
  locality_cd29
  pickup_point_nm五條市
  pickup_point_fkごじょうし
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2016-08-30 12:23:16
  created2016-08-30 12:23:37
  insert_userMG00000001
  modified2016-08-30 12:23:37
  update_userMG00000001
  password11700000
  Trader(array)
  id01
  formal_trader_nm三井食品
  formal_trader_fk三井食品
  designation_file
  use_start_day2016-08-26 17:04:05
  use_end_day(null)
  margin_price_yen0
  created2016-08-26 17:04:05
  insert_userMG00000001
  modified2016-08-26 17:04:05
  update_userMG00000001
  Locality(array)
  id4
  trader_id01
  locality_cd29
  locality_nm奈良県
  use_start_day2016-08-29 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
- $request->data(empty)
- $this->validationErrors(array)
  PickupPoint(empty)
  Trader(empty)
  Locality(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Js
  3Session
  4Number
  5SimpleGraph
  6Paginator
  7DebugTimer
  8Toolbar
  9Flash
  10HtmlToolbar
====

Environment

App Constants

Constant	Value
BACKUP_DIR	/var/www/release/hounotori/app/tmp/backup
IMPORT_DIR	/var/www/webdav/mab

CakePHP Constants

Constant	Value
APP	/var/www/release/hounotori/app/
APP_DIR	app
APPLIBS	/var/www/release/hounotori/app/Lib/
CACHE	/var/www/release/hounotori/app/tmp/cache/
CAKE	/var/www/release/hounotori/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/release/hounotori/lib
CORE_PATH	/var/www/release/hounotori/lib/
CAKE_VERSION	2.8.5
CSS	/var/www/release/hounotori/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://202.222.80.41
IMAGES	/var/www/release/hounotori/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/release/hounotori/app/webroot/js/
JS_URL	js/
LOGS	/var/www/release/hounotori/app/tmp/logs/
ROOT	/var/www/release/hounotori
TESTS	/var/www/release/hounotori/app/Test/
TMP	/var/www/release/hounotori/app/tmp/
VENDORS	/var/www/release/hounotori/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/release/hounotori/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
User	apache
Home	/usr/share/httpd
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	aA4gjyZo1@eGX45RglpUjAAAAFA
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aA4gjyZo1@eGX45RglpUjAAAAFA
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aA4gjyZo1@eGX45RglpUjAAAAFA
Kounotori Deploy Env	stg
Proxy-nokeepalive	1
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Host	202.222.80.41
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1g
Server Name	202.222.80.41
Server Addr	192.168.1.3
Server Port	80
Remote Addr	3.143.235.3
Document Root	/var/www/html
Request Scheme	http
Context Prefix
Context Document Root	/var/www/html
Server Admin	admin@agri-harvest.sato.co.jp
Script Filename	/var/www/html/app/webroot/index.php
Remote Port	44417
Redirect Url	/app/webroot/PickupPoints/index/sort:inventory_date/direction:desc/page:2
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/PickupPoints/index/sort:inventory_date/direction:desc/page:2
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1745756303.809
Request Time	1745756303

====

Include
+
Included Files

Include Paths
- 0/var/www/release/hounotori/lib
- 2/opt/remi/php56/root/usr/share/pear
- 3/opt/remi/php56/root/usr/share/php
- 4/usr/share/pear
- 5/usr/share/php
- 6-> /var/www/release/hounotori/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/PaginatorComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/ValidationBehavior.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/userDefineConst.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Controller(array)
  0APP/Controller/PickupPointsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/PickupPoint.php
  1APP/Model/AppModel.php
  2APP/Model/Trader.php
  3APP/Model/Locality.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

CakePHP: the rapid development php framework

Pickup Points

Actions

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files