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
60106  AG02100037 02  5370 53  00  33400  レタス  れたす  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533800  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60107  AG02100037 02  5371 53  01  33810  チンゲン菜  ちんげんさい  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533801  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60108  AG02100037 02  5372 53  02  31310  水菜  みずな  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533802  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60109  AG02100037 02  5373 53  03  32600  春菊  しゅんぎく  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533803  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60110  AG02100037 02  5374 53  04  33810  ミニチンゲン菜  みにちんげんさい  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533804  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60111  AG02100037 02  5375 53  05  33300  ブロッコリー  ぶろっこりー  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533805  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60112  AG02100037 02  5376 53  06  34570  パプリカ  ぱぷりか  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533806  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60113  AG02100037 02  5377 53  07  34500  こどもピーマン  こどもぴーまん  徳島県阿南市宝田町東の一 2-3                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533807  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60114  AG02100038 02  5370 53  00  33810  チンゲン菜  ちんげんさい  徳島県阿南市福井町赤崎68                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532300  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60115  AG02100038 02  5371 53  01  31900  ねぎ  ねぎ  徳島県阿南市福井町赤崎68                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532301  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60116  AG02100039 02  5370 53  00  34100  きゅうり  きゅうり  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532800  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60117  AG02100039 02  5371 53  01  33300  ブロッコリー  ぶろっこりー  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532801  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60118  AG02100039 02  5372 53  02  43500  甘柿  あまがき  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532802  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60119  AG02100039 02  5373 53  03  39330  すだち  すだち  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532803  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60120  AG02100039 02  5374 53  04  39310  ゆず  ゆず  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532804  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60121  AG02100039 02  5375 53  05  90008  だいだい  だいだい  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532805  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60122  AG02100039 02  5376 53  06  90007  フェイジョア  ふぇいじょあ  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532806  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60123  AG02100039 02  5377 53  07  90006  ゴーヤ  ごーや  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532807  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60124  AG02100039 02  5378 53  08  34300  ナス  なす  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532808  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60125  AG02100039 02  5379 53  09  34400  トマト  とまと  徳島県那賀郡那賀町仁宇字学原146-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532809  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete

Page 328 of 15485, showing 20 records out of 309681 total, starting on record 6541, ending on 6560

(default) 2 queries took 1014 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`.`id` asc LIMIT 6540, 20202036
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 = 111978