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
57781  AG02100032 02  5370 53  00  30300  人参  にんじん  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534400  12  2018-04-24 00:00:00    2018-04-24 09:57:15  MG00000001  2018-04-24 09:57:15  MG00000001  View Edit Delete
57782  AG02100032 02  5371 53  01  30200  小カブ  こかぶ  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534401  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57783  AG02100032 02  5372 53  02  30100  赤大根  あかだいこん  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534402  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57784  AG02100032 02  5373 53  03  33920  菜の花  なのはな  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534403  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57785  AG02100032 02  5374 53  04  34270  ズッキーニ  ずっきーに  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534404  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57786  AG02100032 02  5375 53  05  39630  モロヘイヤ  もろへいや  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534405  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57787  AG02100032 02  5376 53  06  34200  カボチャ  かぼちゃ  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534406  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57788  AG02100032 02  5377 53  07  34200  ひょうたんカボチャ  ひょうたんかぼちゃ  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534407  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57789  AG02100032 02  5378 53  08  36100  さつま芋  さつまいも  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534408  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57790  AG02100032 02  5379 53  09  36200  じゃがいも  じゃがいも  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534409  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57791  AG02100032 02  5380 53  10  31310  水菜  みずな  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534410  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57792  AG02100032 02  5381 53  11  37300  青とうがらし  あおとうがらし  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534411  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57793  AG02100032 02  5382 53  12  34400  トマト  とまと  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534412  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57794  AG02100032 02  5383 53  13  34300  ナス  なす  徳島県板野郡上板町引野字泉野東3番地                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534413  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57795  AG02100030 02  5370 53  00  31900  ねぎ  ねぎ  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534100  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57796  AG02100030 02  5371 53  01  31500  小松菜  こまつな  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534101  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57797  AG02100030 02  5372 53  02  31800  ほうれん草  ほうれんそう  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534102  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57798  AG02100030 02  5373 53  03  31100  白菜  はくさい  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534103  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57799  AG02100030 02  5374 53  04  31700  キャベツ  きゃべつ  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534104  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete
57800  AG02100030 02  5375 53  05  30200  かぶ  かぶ  徳島県徳島市一宮町東丁475-2                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534105  12  2018-04-24 00:00:00    2018-04-24 09:57:00  MG00000001  2018-04-24 09:57:00  MG00000001  View Edit Delete

Page 321 of 15485, showing 20 records out of 309681 total, starting on record 6401, ending on 6420

(default) 2 queries took 1017 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 6400, 20202035
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 = 111982