Farmer Products

Id Farmer Trader Cmp Product 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
73721  AG09000071 09  6375 101  38071  36600  たまねぎ  たまねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73724  AG09000071 09  6375 101  38071  36500  山芋  やまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73726  AG09000071 09  6375 101  38071  36300  さといも  さといも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73722  AG09000071 09  6375 101  38071  36200  じゃがいも  じゃがいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73725  AG09000071 09  6375 101  38071  36100  さつま芋  さつまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73709  AG09000071 09  6375 101  38071  35500  枝豆  えだまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73676  AG09000071 09  6375 101  38071  35200  えんどう豆  えんどうまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73675  AG09000071 09  6375 101  38071  35100  いんげん  いんげん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73729  AG09000071 09  6375 101  38071  34950  うり  うり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73673  AG09000071 09  6375 101  38071  34910  とうがん  とうがん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73700  AG09000071 09  6375 101  38071  34800  オクラ  おくら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73701  AG09000071 09  6375 101  38071  34700  とうもろこし  とうもろこし  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73669  AG09000071 09  6375 101  38071  34600  ししとう  ししとう  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73668  AG09000071 09  6375 101  38071  34500  ピーマン  ぴーまん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73665  AG09000071 09  6375 101  38071  34460  ミニトマト  みにとまと  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73664  AG09000071 09  6375 101  38071  34400  トマト  とまと  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73674  AG09000071 09  6375 101  38071  34300  なす  なす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73672  AG09000071 09  6375 101  38071  34270  ズッキーニ  ずっきーに  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73667  AG09000071 09  6375 101  38071  34200  南瓜  かぼちゃ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73666  AG09000071 09  6375 101  38071  34100  きゅうり  きゅうり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete

Page 73 of 15485, showing 20 records out of 309681 total, starting on record 1441, ending on 1460

(default) 2 queries took 931 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `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`, `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user`, `SysProduct`.`sys_product_cd`, `SysProduct`.`sys_product_nm`, `SysProduct`.`sys_product_fk`, `SysProduct`.`classify_cd`, `SysProduct`.`use_start_day`, `SysProduct`.`use_end_day`, `SysProduct`.`del_flg`, `SysProduct`.`created`, `SysProduct`.`insert_user`, `SysProduct`.`modified`, `SysProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 1 ORDER BY `FarmerProduct`.`farmer_id` desc LIMIT 1440, 20202011
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 111920