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
60331  AG02000092 02  6214 54  78832  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278832  12  2018-05-21 00:00:00    2018-05-21 13:56:54  MG00000001  2018-05-21 13:56:54  MG00000001  View Edit Delete
60332  AG02000092 02  6214 54  78832  31900  ネギ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278832  12  2018-05-21 00:00:00    2018-05-21 13:56:54  MG00000001  2018-05-21 13:56:54  MG00000001  View Edit Delete
60333  AG02000092 02  6214 54  78832  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278832  12  2018-05-21 00:00:00    2018-05-21 13:56:54  MG00000001  2018-05-21 13:56:54  MG00000001  View Edit Delete
60334  AG02000092 02  6214 54  78832  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278832  12  2018-05-21 00:00:00    2018-05-21 13:56:54  MG00000001  2018-05-21 13:56:54  MG00000001  View Edit Delete
60337  AG02100044 02  5370 53  00  30300  人参  にんじん  徳島県勝浦郡勝浦町坂本                                                  
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534800  12  2018-05-21 00:00:00    2018-05-21 14:31:30  MG00000001  2018-05-21 14:31:30  MG00000001  View Edit Delete
60338  AG02100044 02  5371 53  01  36100  さつま芋  さつまいも  徳島県勝浦郡勝浦町坂本                                                  
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534801  12  2018-05-21 00:00:00    2018-05-21 14:35:59  MG00000001  2019-08-19 09:55:53  MG00000001  View Edit Delete
60339  AG02100044 02  5372 53  02  40100  みかん  みかん  徳島県勝浦郡勝浦町坂本                                                  
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534802  12  2018-05-21 00:00:00    2018-05-21 14:37:33  MG00000001  2018-05-21 14:37:33  MG00000001  View Edit Delete
60340  AG02100044 02  5373 53  03  38600  きくらげ(黒)  きくらげくろ  徳島県勝浦郡勝浦町坂本                                                  
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534803  12  2018-05-21 00:00:00    2018-05-21 14:39:20  MG00000001  2019-08-19 09:56:07  MG00000001  View Edit Delete
60341  AG02100045 02  5370 53  00  31500  小松菜  こまつな  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535600  12  2018-05-21 00:00:00    2018-05-21 14:46:35  MG00000001  2018-05-21 14:46:35  MG00000001  View Edit Delete
60342  AG02100045 02  5371 53  01  33810  チンゲン菜  ちんげんさい  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535601  12  2018-05-21 00:00:00    2018-05-21 14:49:56  MG00000001  2018-05-21 14:49:56  MG00000001  View Edit Delete
60343  AG02100045 02  5372 53  02  31310  水菜  みずな  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535602  12  2018-05-21 00:00:00    2018-05-21 14:53:49  MG00000001  2018-05-21 14:53:49  MG00000001  View Edit Delete
60344  AG02100045 02  5373 53  03  31800  ほうれん草  ほうれんそう  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535603  12  2018-05-21 00:00:00    2018-05-21 14:57:46  MG00000001  2018-05-21 14:57:46  MG00000001  View Edit Delete
60345  AG02100045 02  5374 53  04  36200  じゃがいも  じゃがいも  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535604  12  2018-05-21 00:00:00    2018-05-21 14:59:53  MG00000001  2018-05-21 14:59:53  MG00000001  View Edit Delete
60346  AG02100045 02  5375 53  05  36100  鳴門金時  なるときんとき  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535605  12  2018-05-21 00:00:00    2018-05-21 15:01:38  MG00000001  2018-05-21 15:01:38  MG00000001  View Edit Delete
60347  AG02100045 02  5376 53  06  34200  かぼちゃ  かぼちゃ  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535606  12  2018-05-21 00:00:00    2018-05-21 15:03:42  MG00000001  2018-05-21 15:03:42  MG00000001  View Edit Delete
60348  AG02100045 02  5377 53  07  34800  おくら  おくら  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535607  12  2018-05-21 00:00:00    2018-05-21 15:04:57  MG00000001  2018-05-21 15:04:57  MG00000001  View Edit Delete
60349  AG02100045 02  5378 53  08  34500  ピーマン  ぴーまん  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535608  12  2018-05-21 00:00:00    2018-05-21 15:06:29  MG00000001  2018-05-21 15:06:29  MG00000001  View Edit Delete
60350  AG02100045 02  5379 53  09  31910  青ネギ  あおねぎ  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535609  12  2018-05-21 00:00:00    2018-05-21 15:08:38  MG00000001  2018-05-21 15:08:38  MG00000001  View Edit Delete
60351  AG02100045 02  5380 53  10  34100  きゅうり  きゅうり  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535610  12  2018-05-21 00:00:00    2018-05-21 15:11:26  MG00000001  2018-05-21 15:11:26  MG00000001  View Edit Delete
60352  AG02100045 02  5381 53  11  34300  なす  なす  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535611  12  2018-05-21 00:00:00    2018-05-21 15:13:31  MG00000001  2018-05-21 15:13:31  MG00000001  View Edit Delete

Page 335 of 15485, showing 20 records out of 309681 total, starting on record 6681, ending on 6700

(default) 2 queries took 1073 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 6680, 20202040
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 = 1111033