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
1669077  AG01001108 01  18620 032  85186  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685186  12  2023-07-11 00:00:00    2023-03-29 09:54:05  MG00000001  2023-03-29 09:54:05  MG00000001  View Edit Delete
5158  AG01001155 01  1035 005  11011  34100  きゅうり 1P  きゅうり1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211011  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5159  AG01001155 01  1036 005  11012  34100  きゅうり 2P  きゅうり2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211012  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5160  AG01001155 01  1037 005  11013  34100  きゅうり 3P  きゅうり3  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211013  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5161  AG01001155 01  1038 005  11014  34100  きゅうり パック  きゅうりぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211014  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5162  AG01001155 01  1039 005  11021  34400  トマト 1P  とまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211021  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5163  AG01001155 01  1040 005  11022  34400  トマト 2P  とまと2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211022  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5164  AG01001155 01  1041 005  11023  34400  トマト 3P  とまと3  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211023  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5165  AG01001155 01  1042 005  11024  34400  トマト パック  とまとぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211024  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5166  AG01001155 01  1043 005  11031  34460  ミニトマト 1P  みにとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211031  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5167  AG01001155 01  1044 005  11041  34460  高糖度ミニトマト 1P  こうとうどみにとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211041  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5168  AG01001155 01  1045 005  11051  34400  ミディトマト 1P  みでぃとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211051  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5169  AG01001155 01  1046 005  11061  34400  フルーツトマト 1P  ふるーつとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211061  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5170  AG01001155 01  1047 005  11071  34300  ナス 1P  なす1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211071  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5171  AG01001155 01  1048 005  11072  34300  ナス 2P  なす2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211072  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5172  AG01001155 01  1049 005  11073  34300  ナス 3P  なす3  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211073  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5173  AG01001155 01  1050 005  11074  34300  ナス パック  なすぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211074  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5174  AG01001155 01  1051 005  11081  34500  ピーマン 1P  ぴーまん1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211081  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5175  AG01001155 01  1052 005  11091  34570  パプリカ 1P  ぱぷりか1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211091  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5176  AG01001155 01  1053 005  11101  37300  万願寺とうがらし 1P  まんがんじとうがらし1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211101  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete

Page 164 of 15485, showing 20 records out of 309681 total, starting on record 3261, ending on 3280

(default) 2 queries took 926 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` asc LIMIT 3260, 20202023
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 = 111903