CakePHP: the rapid development php framework: Farmers

Farmer

User Id: AG01000695
Agreement Start Day: 2017-07-27
Agreement End Day
Plan Code: 1
Agreement Amount: 0
Rental Printer Sn
Rental Tablet Sn
Rental Tablet Tel
Rental Tablet Gmail
Label Flg
Seal Flg
Blog Flg
Log Save Number: 5
User Post Number
User Address
User Tel
Qr Url
Notification File
Plain Password
Created: 2016-08-30 12:23:21
Insert User: MG00000001
Modified: 2017-07-31 11:01:20
Update User: AG01000695

Actions

Related Contractors

Id	Farmer Id	Trader Id	Company Cd	Created	Insert User	Modified	Update User	Actions
1307	AG01000695	01	003	2016-08-30 12:24:15	MG00000001	2016-08-30 12:24:15	MG00000001	View Edit Delete
1308	AG01000695	01	004	2016-08-30 12:24:15	MG00000001	2016-08-30 12:24:15	MG00000001	View Edit Delete

New Contractor

Related Farmer Products

Id Farmer Id Trader Id Cmp Product Id Company Cd Co Product Cd Sys Product Cd Display Product Nm Display Product Fk Display Locality Farmer Edit Flg Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Shipment Start Month Shipment End Month Use Start Day Use End Day Del Flg Created Insert User Modified Update User Actions

11100

AG01000695

6435

004

398704

90001

野菜

やさい

奈良

Notice (8): Undefined index: farmer_edit_flg [APP/View/Farmers/view.ctp, line 357]Code Context            <td><?php echo $farmerProduct['display_product_fk']; ?></td>
            <td><?php echo $farmerProduct['display_locality']; ?></td>
            <td><?php echo $farmerProduct['farmer_edit_flg']; ?></td>
$viewFile = '/var/www/release/hounotori/app/View/Farmers/view.ctp'
$dataForView = array(
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => null,
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'farmer' => array(
		'Farmer' => array(
			'user_id' => 'AG01000695',
			'agreement_start_day' => '2017-07-27',
			'agreement_end_day' => null,
			'plan_code' => '1',
			'agreement_amount' => '0',
			'rental_printer_sn' => '',
			'rental_tablet_sn' => '',
			'rental_tablet_tel' => '',
			'rental_tablet_gmail' => '',
			'label_flg' => null,
			'seal_flg' => null,
			'blog_flg' => null,
			'log_save_number' => '5',
			'user_post_number' => '',
			'user_address' => '',
			'user_tel' => '',
			'qr_url' => null,
			'notification_file' => null,
			'plain_password' => '',
			'admin_memo' => '大和アグリファーム',
			'biz_browser_authorized_devices_count' => '1',
			'biz_browser_authorized_devices_limit' => '30',
			'created' => '2016-08-30 12:23:21',
			'insert_user' => 'MG00000001',
			'modified' => '2017-07-31 11:01:20',
			'update_user' => 'AG01000695'
		),
		'ContractPlan' => array(
			'plan_code' => '1',
			'plan_nm' => 'フルレンタル1年プラン',
			'contract_months' => '12',
			'agreement_amount' => '6800',
			'created' => '2016-08-26 17:04:06',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-26 17:04:06',
			'update_user' => 'MG00000001'
		),
		'User' => array(
			'password' => '*****',
			'id' => 'AG01000695',
			'login_id' => '01000695',
			'user_nm' => 'T上田美加子',
			'user_fk' => 'うえだみかこ',
			'user_type' => '01',
			'mail_address_1' => '',
			'mail_address_2' => null,
			'login_rock_flg' => '0',
			'last_login_day' => '2017-09-08 14:02:26',
			'use_start_day' => '2016-08-29 00:00:00',
			'use_end_day' => null,
			'del_flg' => '0',
			'init_pass_flg' => '0',
			'created' => '2016-08-30 12:23:21',
			'insert_user' => 'MG00000001',
			'modified' => '2017-07-28 10:26:04',
			'update_user' => 'MG00000001'
		),
		'Contractor' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'ExchangeLabelRollLog' => array(),
		'FarmerProduct' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'UsersPickupPoint' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'Trader' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => null,
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'farmers/view/AG01000695',
			'query' => array([maximum depth reached]),
			'data' => array([maximum depth reached]),
			'get' => array([maximum depth reached]),
			'currentRoute' => object(CakeRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'farmer' => array(
				[maximum depth reached]
			),
			'$request->data' => array([maximum depth reached])
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$farmer = array(
	'Farmer' => array(
		'user_id' => 'AG01000695',
		'agreement_start_day' => '2017-07-27',
		'agreement_end_day' => null,
		'plan_code' => '1',
		'agreement_amount' => '0',
		'rental_printer_sn' => '',
		'rental_tablet_sn' => '',
		'rental_tablet_tel' => '',
		'rental_tablet_gmail' => '',
		'label_flg' => null,
		'seal_flg' => null,
		'blog_flg' => null,
		'log_save_number' => '5',
		'user_post_number' => '',
		'user_address' => '',
		'user_tel' => '',
		'qr_url' => null,
		'notification_file' => null,
		'plain_password' => '',
		'admin_memo' => '大和アグリファーム',
		'biz_browser_authorized_devices_count' => '1',
		'biz_browser_authorized_devices_limit' => '30',
		'created' => '2016-08-30 12:23:21',
		'insert_user' => 'MG00000001',
		'modified' => '2017-07-31 11:01:20',
		'update_user' => 'AG01000695'
	),
	'ContractPlan' => array(
		'plan_code' => '1',
		'plan_nm' => 'フルレンタル1年プラン',
		'contract_months' => '12',
		'agreement_amount' => '6800',
		'created' => '2016-08-26 17:04:06',
		'insert_user' => 'MG00000001',
		'modified' => '2016-08-26 17:04:06',
		'update_user' => 'MG00000001'
	),
	'User' => array(
		'password' => '*****',
		'id' => 'AG01000695',
		'login_id' => '01000695',
		'user_nm' => 'T上田美加子',
		'user_fk' => 'うえだみかこ',
		'user_type' => '01',
		'mail_address_1' => '',
		'mail_address_2' => null,
		'login_rock_flg' => '0',
		'last_login_day' => '2017-09-08 14:02:26',
		'use_start_day' => '2016-08-29 00:00:00',
		'use_end_day' => null,
		'del_flg' => '0',
		'init_pass_flg' => '0',
		'created' => '2016-08-30 12:23:21',
		'insert_user' => 'MG00000001',
		'modified' => '2017-07-28 10:26:04',
		'update_user' => 'MG00000001'
	),
	'Contractor' => array(
		(int) 0 => array(
			'id' => '1307',
			'farmer_id' => 'AG01000695',
			'trader_id' => '01',
			'company_cd' => '003',
			'created' => '2016-08-30 12:24:15',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-30 12:24:15',
			'update_user' => 'MG00000001'
		),
		(int) 1 => array(
			'id' => '1308',
			'farmer_id' => 'AG01000695',
			'trader_id' => '01',
			'company_cd' => '004',
			'created' => '2016-08-30 12:24:15',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-30 12:24:15',
			'update_user' => 'MG00000001'
		)
	),
	'ExchangeLabelRollLog' => array(),
	'FarmerProduct' => array(
		(int) 0 => array(
			'id' => '11100',
			'farmer_id' => 'AG01000695',
			'trader_id' => '01',
			'cmp_product_id' => '6435',
			'company_cd' => '004',
			'co_product_cd' => '398704',
			'sys_product_cd' => '90001',
			'display_product_nm' => '野菜',
			'display_product_fk' => 'やさい',
			'display_locality' => '奈良',
			'farmer_edit_status' => '1',
			'brc_shipment_product_characters' => '7',
			'brc_shipment_product_cd' => '2398704',
			'brc_price_cd' => '1',
			'brc_price_characters' => '4',
			'company_shipment_cd' => '398704',
			'brc_type_flag' => null,
			'brc_mid_flag' => null,
			'val_pos_pattern' => null,
			'mid_checkdigit_flag' => null,
			'shipment_start_month' => '1',
			'shipment_end_month' => '12',
			'use_start_day' => '2017-07-31 00:00:00',
			'use_end_day' => null,
			'del_flg' => '0',
			'created' => '2017-07-31 11:02:07',
			'insert_user' => 'AG01000695',
			'modified' => '2017-07-31 11:02:07',
			'update_user' => 'AG01000695'
		)
	),
	'UsersPickupPoint' => array(
		(int) 0 => array(
			'farmer_id' => 'AG01000695',
			'pickup_point_id' => '36',
			'use_start_day' => '2016-08-29 00:00:00',
			'use_end_day' => null,
			'created' => '2016-08-30 12:23:39',
			'insert_user' => 'MG00000001',
			'modified' => '2017-10-20 19:37:21',
			'update_user' => 'MG00000001'
		)
	),
	'Trader' => array(
		(int) 0 => array(
			'id' => '01',
			'formal_trader_nm' => '三井食品',
			'formal_trader_fk' => '三井食品',
			'designation_file' => '',
			'use_start_day' => '2016-08-26 17:04:05',
			'use_end_day' => null,
			'margin_price_yen' => '0',
			'created' => '2016-08-26 17:04:05',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-26 17:04:05',
			'update_user' => 'MG00000001',
			'TradersFarmer' => array(
				[maximum depth reached]
			)
		)
	)
)
$contractor = array(
	'id' => '1308',
	'farmer_id' => 'AG01000695',
	'trader_id' => '01',
	'company_cd' => '004',
	'created' => '2016-08-30 12:24:15',
	'insert_user' => 'MG00000001',
	'modified' => '2016-08-30 12:24:15',
	'update_user' => 'MG00000001'
)
$farmerProduct = array(
	'id' => '11100',
	'farmer_id' => 'AG01000695',
	'trader_id' => '01',
	'cmp_product_id' => '6435',
	'company_cd' => '004',
	'co_product_cd' => '398704',
	'sys_product_cd' => '90001',
	'display_product_nm' => '野菜',
	'display_product_fk' => 'やさい',
	'display_locality' => '奈良',
	'farmer_edit_status' => '1',
	'brc_shipment_product_characters' => '7',
	'brc_shipment_product_cd' => '2398704',
	'brc_price_cd' => '1',
	'brc_price_characters' => '4',
	'company_shipment_cd' => '398704',
	'brc_type_flag' => null,
	'brc_mid_flag' => null,
	'val_pos_pattern' => null,
	'mid_checkdigit_flag' => null,
	'shipment_start_month' => '1',
	'shipment_end_month' => '12',
	'use_start_day' => '2017-07-31 00:00:00',
	'use_end_day' => null,
	'del_flg' => '0',
	'created' => '2017-07-31 11:02:07',
	'insert_user' => 'AG01000695',
	'modified' => '2017-07-31 11:02:07',
	'update_user' => 'AG01000695'
)
include - APP/View/Farmers/view.ctp, line 357
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

2398704

2017-07-31 00:00:00

2017-07-31 11:02:07

AG01000695

2017-07-31 11:02:07

AG01000695

View Edit Delete

New Farmer Product

Related Users Pickup Points

Farmer Id	Pickup Point Id	Use Start Day	Use End Day	Created	Insert User	Modified	Update User	Actions
AG01000695	36	2016-08-29 00:00:00		2016-08-30 12:23:39	MG00000001	2017-10-20 19:37:21	MG00000001	View Edit Delete

New Users Pickup Point

(default) 7 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` WHERE `Farmer`.`user_id` = 'AG01000695'	1	1	0
2	SELECT `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE `Farmer`.`user_id` = 'AG01000695' LIMIT 1	1	1	1
3	SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` WHERE `Contractor`.`farmer_id` = ('AG01000695')	2	2	0
4	SELECT `ExchangeLabelRollLog`.`exchange_number`, `ExchangeLabelRollLog`.`farmer_id`, `ExchangeLabelRollLog`.`pickup_point_id`, `ExchangeLabelRollLog`.`exchange_label_roll`, `ExchangeLabelRollLog`.`acceptance_label_roll`, `ExchangeLabelRollLog`.`exchange_date`, `ExchangeLabelRollLog`.`acceptance_date`, `ExchangeLabelRollLog`.`exchange_user_id`, `ExchangeLabelRollLog`.`created`, `ExchangeLabelRollLog`.`insert_user`, `ExchangeLabelRollLog`.`modified`, `ExchangeLabelRollLog`.`update_user` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` WHERE `ExchangeLabelRollLog`.`farmer_id` = ('AG01000695')	0	0	0
5	SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` WHERE `FarmerProduct`.`farmer_id` = ('AG01000695')	1	1	0
6	SELECT `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` WHERE `UsersPickupPoint`.`farmer_id` = ('AG01000695')	1	1	0
7	SELECT `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`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user` FROM `sato_agri`.`traders` AS `Trader` JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = 'AG01000695' AND `TradersFarmer`.`trader_id` = `Trader`.`id`)	1	1	0

(default) 7 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` WHERE `Farmer`.`user_id` = 'AG01000695'

SELECT `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE `Farmer`.`user_id` = 'AG01000695' LIMIT 1

SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` WHERE `Contractor`.`farmer_id` = ('AG01000695')

SELECT `ExchangeLabelRollLog`.`exchange_number`, `ExchangeLabelRollLog`.`farmer_id`, `ExchangeLabelRollLog`.`pickup_point_id`, `ExchangeLabelRollLog`.`exchange_label_roll`, `ExchangeLabelRollLog`.`acceptance_label_roll`, `ExchangeLabelRollLog`.`exchange_date`, `ExchangeLabelRollLog`.`acceptance_date`, `ExchangeLabelRollLog`.`exchange_user_id`, `ExchangeLabelRollLog`.`created`, `ExchangeLabelRollLog`.`insert_user`, `ExchangeLabelRollLog`.`modified`, `ExchangeLabelRollLog`.`update_user` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` WHERE `ExchangeLabelRollLog`.`farmer_id` = ('AG01000695')

SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` WHERE `FarmerProduct`.`farmer_id` = ('AG01000695')

SELECT `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` WHERE `UsersPickupPoint`.`farmer_id` = ('AG01000695')

SELECT `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`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user` FROM `sato_agri`.`traders` AS `Trader` JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = 'AG01000695' AND `TradersFarmer`.`trader_id` = `Trader`.`id`)

Message	Memory use
Component initialization	3.56 MB
Controller action start	3.79 MB
Controller render start	6.39 MB
View render complete	7.86 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.78
Event: Controller.initialize	0.04
Event: Controller.startup	0.27
Controller action	16.79
Event: Controller.beforeRender	51.07
» Processing toolbar data	50.98
Rendering View	6.95
» Event: View.beforeRender	0.03
» Rendering APP/View/Farmers/view.ctp	5.29
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.86
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.23
Event: View.afterLayout	0.00

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

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/

Environment Variable	Value
Php Version	5.6.40
User	apache
Home	/usr/share/httpd
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	aAzyqaD5vRhC4DANj8CBKgAAABM
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aAzyqaD5vRhC4DANj8CBKgAAABM
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aAzyqaD5vRhC4DANj8CBKgAAABM
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.16.164.14
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	61202
Redirect Url	/app/webroot/farmers/view/AG01000695
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/farmers/view/AG01000695
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1745679017.4713
Request Time	1745679017

CakePHP: the rapid development php framework

Farmer

Actions

Related Users

Related Contractors

Related Exchange Label Roll Logs

Related Farmer Products

Related Users Pickup Points

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