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
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
96	06001	01	19	06	山形市	やまがたし	2018-11-27 22:54:34	2000	1000	2000						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
91	OK01	05	15	15	奥村商事	おくむらしょうじ	2017-11-01 13:11:02	2000	1000	2000						View Edit Delete
145	OK02	04	15	15	奥村商事	おくむらしょうじ	2017-11-01 13:11:02	2000	1000	2000						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
89	24001	01	2	24	三重県	みえけん	2017-09-19 15:31:55	2000	1000	2000	2017-09-19 15:32:07					View Edit Delete
109	24002	01	2	24	四日市市	よっかいちし	2020-02-19 09:26:05	2000	1000	2000						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
87	26003	01	5	26	日吉町	ひよしまち	2017-09-11 13:56:34	2000	1000	2000	2017-09-11 13:56:54					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
95	26005	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
140	00000	01	5	26	阪急オアシス買取	はんきゅうおあしすかいとりよう	2022-05-09 08:36:55	2000	1000	2000						View Edit Delete
157	26006	01	5	26	IZ六地蔵店	いずみやむじぞう	2022-07-20 10:09:11	2000	1000	2000						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
99	27002	01	6	27	大阪和泉	おおさかいずみ	2019-04-18 00:00:00	2000	1000	2000						View Edit Delete
132	27005	01	6	27	IZ八尾店	いずやおてん	2021-07-08 00:00:00	2000	1000	2000						View Edit Delete
135	IZ001	06	6	27	いずみファーマーズ	いずみふぁーまーず	2017-12-22 13:11:02	2000	1000	2000						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`.`locality_cd` asc 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)
- controllerpickup_points
- actionindex
- named(array)
  sortlocality_cd
  directionasc
- pass(empty)
- paging(array)
  PickupPoint(array)
  page1
  current20
  count158
  prevPage(false)
  nextPage(true)
  pageCount8
  order(array)
  PickupPoint.locality_cdasc
  limit20
  options(array)
  sortlocality_cd
  directionasc
  order(array)
  PickupPoint.locality_cdasc
  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.32 MB

Message	Memory use
Component initialization	3.56 MB
Controller action start	3.80 MB
Controller render start	6.12 MB
View render complete	7.75 MB

Timers

Total Request Time: 62 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.51
Event: Controller.initialize	0.03
Event: Controller.startup	0.21
Controller action	14.89
Event: Controller.beforeRender	4.47
» Processing toolbar data	4.40
Rendering View	11.49
» Event: View.beforeRender	0.03
» Rendering APP/View/PickupPoints/index.ctp	10.00
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.82
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.22
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)
  id96
  pickup_point_cd06001
  trader_id01
  locality_id19
  locality_cd06
  pickup_point_nm山形市
  pickup_point_fkやまがたし
  use_start_day2018-11-27 22:54:34
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  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)
  id19
  trader_id01
  locality_cd06
  locality_nm山形県
  use_start_day2018-11-27 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  2(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)
  3(array)
  PickupPoint(array)
  id91
  pickup_point_cdOK01
  trader_id05
  locality_id15
  locality_cd15
  pickup_point_nm奥村商事
  pickup_point_fkおくむらしょうじ
  use_start_day2017-11-01 13:11:02
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password00000000
  Trader(array)
  id05
  formal_trader_nm奥村商事
  formal_trader_fkおくむらしょうじ
  designation_file
  use_start_day2017-11-06 15:00:43
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id15
  trader_id05
  locality_cd15
  locality_nm埼玉県
  use_start_day2017-11-01 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  4(array)
  PickupPoint(array)
  id145
  pickup_point_cdOK02
  trader_id04
  locality_id15
  locality_cd15
  pickup_point_nm奥村商事
  pickup_point_fkおくむらしょうじ
  use_start_day2017-11-01 13:11:02
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password40000000
  Trader(array)
  id04
  formal_trader_nm農業総合研究所
  formal_trader_fkのうぎょうそうごうけんきゅうじょ
  designation_file
  use_start_day2017-11-06 15:00:43
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  Locality(array)
  id15
  trader_id05
  locality_cd15
  locality_nm埼玉県
  use_start_day2017-11-01 00:00:00
  use_end_day(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  5(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)
  6(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
  7(array)
  PickupPoint(array)
  id109
  pickup_point_cd24002
  trader_id01
  locality_id2
  locality_cd24
  pickup_point_nm四日市市
  pickup_point_fkよっかいちし
  use_start_day2020-02-19 09:26:05
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  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
  8(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
  9(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
  10(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
  11(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
  12(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
  13(array)
  PickupPoint(array)
  id95
  pickup_point_cd26005
  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
  14(array)
  PickupPoint(array)
  id140
  pickup_point_cd00000
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nm阪急オアシス買取
  pickup_point_fkはんきゅうおあしすかいとりよう
  use_start_day2022-05-09 08:36:55
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password12400000
  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)
  id157
  pickup_point_cd26006
  trader_id01
  locality_id5
  locality_cd26
  pickup_point_nmIZ六地蔵店
  pickup_point_fkいずみやむじぞう
  use_start_day2022-07-20 10:09:11
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  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)
  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
  17(array)
  PickupPoint(array)
  id99
  pickup_point_cd27002
  trader_id01
  locality_id6
  locality_cd27
  pickup_point_nm大阪和泉
  pickup_point_fkおおさかいずみ
  use_start_day2019-04-18 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password25000000
  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
  18(array)
  PickupPoint(array)
  id132
  pickup_point_cd27005
  trader_id01
  locality_id6
  locality_cd27
  pickup_point_nmIZ八尾店
  pickup_point_fkいずやおてん
  use_start_day2021-07-08 00:00:00
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password11600000
  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
  19(array)
  PickupPoint(array)
  id135
  pickup_point_cdIZ001
  trader_id06
  locality_id6
  locality_cd27
  pickup_point_nmいずみファーマーズ
  pickup_point_fkいずみふぁーまーず
  use_start_day2017-12-22 13:11:02
  use_end_day(null)
  margin_price_yen0
  remain_label_roll2000
  threshold_label_roll1000
  inventory_label_roll2000
  inventory_date(null)
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  password00000000
  Trader(array)
  id06
  formal_trader_nmいずみファーマーズ
  formal_trader_fkいずみふぁーまーず
  designation_file
  use_start_day2021-11-11 09:30:11
  use_end_day(null)
  margin_price_yen0
  created(null)
  insert_user(null)
  modified(null)
  update_user(null)
  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
- $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	aA1t7J6hE@HsJDkIK84-XgAAAdU
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aA1t7J6hE@HsJDkIK84-XgAAAdU
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aA1t7J6hE@HsJDkIK84-XgAAAdU
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.15.189.95
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	42604
Redirect Url	/app/webroot/pickup_points/index/sort:locality_cd/direction:asc
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/pickup_points/index/sort:locality_cd/direction:asc
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1745710572.1496
Request Time	1745710572

====

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