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
60126  AG02100039 02  5380 53  10  40100  不知火  しらぬい  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532810  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60127  AG02100039 02  5381 53  11  36200  じゃがいも  じゃがいも  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532811  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60128  AG02100039 02  5382 53  12  36600  玉ねぎ  たまねぎ  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532812  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60129  AG02100039 02  5383 53  13  39330  ハウスすだち  はうすすだち  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532813  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60130  AG02100040 02  5370 53  00  33100  アスパラガス  あすぱらがす  徳島県阿南市山口町末広89-1                                              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532900  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60131  AG02100041 02  5370 53  00  33100  アスパラガス  あすぱらがす  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533000  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60132  AG02100041 02  5371 53  01  35200  スナップエンドウ  すなっぷえんどう  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533001  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60133  AG02100041 02  5372 53  02  34100  きゅうり  きゅうり  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533002  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60134  AG02100041 02  5373 53  03  34300  ナス  なす  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533003  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60135  AG02100041 02  5374 53  04  34400  トマト  とまと  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533004  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60136  AG02100041 02  5375 53  05  34460  ミニトマト  みにとまと  徳島県阿南市新野町谷口91                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533005  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60137  AG02100042 02  5370 53  00  31900  太ネギ  ふとねぎ  徳島県徳島市国府町芝原字寺地25-1                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533500  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60138  AG02100042 02  5371 53  01  31700  キャベツ  きゃべつ  徳島県徳島市国府町芝原字寺地25-1                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533501  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60139  AG02100042 02  5372 53  02  33300  ブロッコリー  ぶろっこりー  徳島県徳島市国府町芝原字寺地25-1                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533502  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60140  AG02100042 02  5373 53  03  33200  カリフラワー  かりふらわー  徳島県徳島市国府町芝原字寺地25-1                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533503  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60141  AG02100042 02  5374 53  04  31100  白菜  はくさい  徳島県徳島市国府町芝原字寺地25-1                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533504  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60142  AG02100043 02  5370 53  00  30100  大根  だいこん  徳島県板野郡松茂町豊岡字豊岡開拓181                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533600  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60143  AG02100043 02  5371 53  01  36100  さつまいも  さつまいも  徳島県板野郡松茂町豊岡字豊岡開拓181                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533601  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60144  AG02100043 02  5372 53  02  31900  太ネギ  ふとねぎ  徳島県板野郡松茂町豊岡字豊岡開拓181                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533602  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60178  AG01003299 01  5104 011  60611  90008  河内晩柑  かわちばんかん  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-12 00:00:00    2018-05-12 19:14:01  AG01003299  2018-05-12 19:14:01  AG01003299  View Edit Delete

Page 329 of 15485, showing 20 records out of 309681 total, starting on record 6561, ending on 6580

(default) 2 queries took 1010 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 LIMIT 6560, 20202037
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 = 111973