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
56600  AG03000026 03  6058 61  11  30100  大根  だいこん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252311  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56601  AG03000026 03  6059 61  12  39630  モロヘイヤ  もろへいや  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252312  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56602  AG03000026 03  6060 61  13  34500  ピーマン  ぴーまん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252313  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56603  AG03000026 03  6061 61  14  34500  甘長ピーマン  あまながぴーまん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252314  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56604  AG03000026 03  6062 61  15  90005  ヤーコン  やーこん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252315  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56605  AG03000026 03  6063 61  16  90006  ゴーヤ  ごーや  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252316  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56606  AG03000026 03  6064 61  17  33920  おり菜  おりな  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252317  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56607  AG03000026 03  6065 61  18  34200  かぼちゃ  かぼちゃ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252318  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56608  AG03000026 03  6066 61  19  34200  坊ちゃんカボチャ  ぼっちゃんかぼちゃ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252319  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56609  AG03000026 03  6067 61  20  34200  雪化粧かぼちゃ  ゆきげしょうかぼちゃ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252320  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56610  AG03000026 03  6068 61  21  34270  ズッキーニ  ずっきーに  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252321  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56611  AG03000026 03  6069 61  22  34800  オクラ  おくら  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252322  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56612  AG03000026 03  6070 61  23  91011  花  はな  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252323  12  2018-03-22 00:00:00  2019-09-30 00:00:00  2018-03-22 13:04:44  MG00000001  2020-05-12 16:30:35  AG03000026  View Edit Delete
56613  AG03000026 03  6071 61  24  31900  白ねぎ  しろねぎ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252324  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56614  AG03000026 03  6072 61  25  36200  じゃが芋  じゃがいも  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252325  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56615  AG03000026 03  6073 61  26  34400  トマト  とまと  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252326  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56617  AG03000026 03  6075 61  28  33300  ブロッコリー  ぶろっこりー  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252328  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56618  AG03000026 03  6076 61  29  90008  かりん  かりん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252329  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56619  AG03000026 03  6077 61  30  43500  しぶ柿  しぶがき  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252330  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56620  AG03000026 03  6078 61  31  31700  キャベツ  きゃべつ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252331  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete

Page 301 of 15485, showing 20 records out of 309681 total, starting on record 6001, ending on 6020

(default) 2 queries took 992 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 6000, 20202032
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 = 111960