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	Actions
127	02001	01	23	02	青森県	あおもりけん	2021-04-22 00:00:00	2000	1000	2000	2021-04-22 00:00:00	2021-04-22 00:00:00	MG00000005	View Edit Delete
115	33018	01	20	33	落合出荷組合（集荷）	おちあいしゅっかくみあいしゅうか	2021-01-18 00:00:00	2000	1000	2000	2021-01-18 12:23:16	2021-01-18 14:03:51	MG00000001	View Edit Delete
116	33019	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
117	33011	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
118	33012	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
119	33016	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
120	33017	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
121	33015	01	20	33	農愛会（直納）	のうあいかいちょくのう	2021-03-08 00:00:00	2000	1000	2000	2021-01-18 12:23:16	2021-01-18 14:03:51	MG00000001	View Edit Delete
122	33022	01	20	33	HFR2（直納）	えいちえふあーるちょくのう	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
123	33023	01	20	33	HFR2（集荷）	えいちえふあーるしゅうか	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
124	42101	01	10	42	瑞穂（きばる）	みずほきばる	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
125	42107	01	10	42	金子（きばる）	かねこきばる	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
126	42103	01	10	42	深江（きばる）	ふかえきばる	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
128	33021	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
129	33024	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
130	42104	01	10	42	飯盛（きばる）	いいもりきばる	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
152	42100	01	10	42	九州きばる	きゅうしゅうきばる	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
153	42102	01	10	42	大栄（きばる）	だいえいきばる	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
154	42106	01	10	42	日野江（きばる）	ひのえきばる	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
155	42108	01	10	42	有家（きばる）	ありいえきばる	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

Page 1 of 8, showing 20 records out of 158 total, starting on record 1, ending on 20

< 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	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
- pass(empty)
- paging(array)
  PickupPoint(array)
  page1
  current20
  count158
  prevPage(false)
  nextPage(true)
  pageCount8
  order(array)
  PickupPoint.inventory_datedesc
  limit20
  options(array)
  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 9.22 MB

Message	Memory use
Component initialization	3.57 MB
Controller action start	3.80 MB
Controller render start	6.04 MB
View render complete	7.67 MB

Timers

Total Request Time: 63 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.46
Event: Controller.initialize	0.03
Event: Controller.startup	0.21
Controller action	16.41
Event: Controller.beforeRender	4.70
» Processing toolbar data	4.64
Rendering View	11.52
» Event: View.beforeRender	0.04
» Rendering APP/View/PickupPoints/index.ctp	10.06
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.80
» » 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)
  id127
  pickup_point_cd02001
  trader_id01
  locality_id23
  locality_cd02
  pickup_point_nm青森県
  pickup_point_fkあおもりけん
  use_start_day2021-04-22 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date2021-04-22 00:00:00
  created2021-04-22 00:00:00
  insert_userMG00000005
  modified(null)
  update_user(null)
  password11100000
  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)
  id23
  trader_id01
  locality_cd02
  locality_nm青森県
  use_start_day2021-04-22 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  1(array)
  PickupPoint(array)
  id115
  pickup_point_cd33018
  trader_id01
  locality_id20
  locality_cd33
  pickup_point_nm落合出荷組合（集荷）
  pickup_point_fkおちあいしゅっかくみあいしゅうか
  use_start_day2021-01-18 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)
  2(array)
  PickupPoint(array)
  id116
  pickup_point_cd33019
  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)
  3(array)
  PickupPoint(array)
  id117
  pickup_point_cd33011
  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)
  4(array)
  PickupPoint(array)
  id118
  pickup_point_cd33012
  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)
  5(array)
  PickupPoint(array)
  id119
  pickup_point_cd33016
  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)
  6(array)
  PickupPoint(array)
  id120
  pickup_point_cd33017
  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)
  7(array)
  PickupPoint(array)
  id121
  pickup_point_cd33015
  trader_id01
  locality_id20
  locality_cd33
  pickup_point_nm農愛会（直納）
  pickup_point_fkのうあいかいちょくのう
  use_start_day2021-03-08 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)
  8(array)
  PickupPoint(array)
  id122
  pickup_point_cd33022
  trader_id01
  locality_id20
  locality_cd33
  pickup_point_nmHFR2（直納）
  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)
  9(array)
  PickupPoint(array)
  id123
  pickup_point_cd33023
  trader_id01
  locality_id20
  locality_cd33
  pickup_point_nmHFR2（集荷）
  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)
  10(array)
  PickupPoint(array)
  id124
  pickup_point_cd42101
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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)
  id125
  pickup_point_cd42107
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  12(array)
  PickupPoint(array)
  id126
  pickup_point_cd42103
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 00:00:00
  use_end_day(null)
  created2016-08-30 12:23:16
  insert_userMG00000001
  modified2016-08-30 12:23:16
  update_userMG00000001
  13(array)
  PickupPoint(array)
  id128
  pickup_point_cd33021
  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)
  14(array)
  PickupPoint(array)
  id129
  pickup_point_cd33024
  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)
  15(array)
  PickupPoint(array)
  id130
  pickup_point_cd42104
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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)
  id152
  pickup_point_cd42100
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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)
  id153
  pickup_point_cd42102
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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)
  id154
  pickup_point_cd42106
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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)
  id155
  pickup_point_cd42108
  trader_id01
  locality_id10
  locality_cd42
  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
  password29000000
  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)
  id10
  trader_id01
  locality_cd42
  locality_nm長崎県
  use_start_day2016-07-01 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	aA1c8ORnnMMWGlgCbOUYSQAAAks
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aA1c8ORnnMMWGlgCbOUYSQAAAks
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aA1c8ORnnMMWGlgCbOUYSQAAAks
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	18.191.31.198
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	11832
Redirect Url	/app/webroot/PickupPoints/index/sort:inventory_date/direction:desc
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/PickupPoints/index/sort:inventory_date/direction:desc
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1745706224.2607
Request Time	1745706224

====

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