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
74468  AG09000077 09  6381 101  38077  36700  にんにく  にんにく  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74610  AG09000077 09  6381 101  38077  36600  たまねぎ  たまねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74483  AG09000077 09  6381 101  38077  36600  たまねぎ  たまねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74613  AG09000077 09  6381 101  38077  36500  山芋  やまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74486  AG09000077 09  6381 101  38077  36500  山芋  やまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74615  AG09000077 09  6381 101  38077  36300  さといも  さといも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74488  AG09000077 09  6381 101  38077  36300  さといも  さといも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74611  AG09000077 09  6381 101  38077  36200  じゃがいも  じゃがいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74484  AG09000077 09  6381 101  38077  36200  じゃがいも  じゃがいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74614  AG09000077 09  6381 101  38077  36100  さつま芋  さつまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74487  AG09000077 09  6381 101  38077  36100  さつま芋  さつまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74598  AG09000077 09  6381 101  38077  35500  枝豆  えだまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74471  AG09000077 09  6381 101  38077  35500  枝豆  えだまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74565  AG09000077 09  6381 101  38077  35200  えんどう豆  えんどうまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74438  AG09000077 09  6381 101  38077  35200  えんどう豆  えんどうまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74564  AG09000077 09  6381 101  38077  35100  いんげん  いんげん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74437  AG09000077 09  6381 101  38077  35100  いんげん  いんげん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74618  AG09000077 09  6381 101  38077  34950  うり  うり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete
74491  AG09000077 09  6381 101  38077  34950  うり  うり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:02  MG00000001  2018-07-06 15:12:02  MG00000001  View Edit Delete
74562  AG09000077 09  6381 101  38077  34910  とうがん  とうがん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238077  12  2018-07-06 00:00:00    2018-07-06 15:12:18  MG00000001  2018-07-06 15:12:18  MG00000001  View Edit Delete

Page 41 of 15485, showing 20 records out of 309681 total, starting on record 801, ending on 820

(default) 2 queries took 915 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 800, 2020206
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 = 111909