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
73714  AG09000071 09  6375 101  38071  33930  ずいき  ずいき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73681  AG09000071 09  6375 101  38071  33810  チンゲン菜  ちんげんさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73716  AG09000071 09  6375 101  38071  33600  パセリ  ぱせり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73694  AG09000071 09  6375 101  38071  33420  グリーンリーフ  ぐりーんりーふ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73693  AG09000071 09  6375 101  38071  33410  サニーレタス  さにーれたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73692  AG09000071 09  6375 101  38071  33400  レタス  れたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73689  AG09000071 09  6375 101  38071  33300  ブロッコリー  ぶろっこりー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73690  AG09000071 09  6375 101  38071  33200  カリフラワー  かりふらわー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73691  AG09000071 09  6375 101  38071  33100  アスパラ  あすぱら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73695  AG09000071 09  6375 101  38071  32800  ニラ  にら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73682  AG09000071 09  6375 101  38071  32600  菊菜  きくな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73711  AG09000071 09  6375 101  38071  32400  うど  うど  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73703  AG09000071 09  6375 101  38071  32300  ふき  ふき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73685  AG09000071 09  6375 101  38071  31910  青ねぎ  あおねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73684  AG09000071 09  6375 101  38071  31900  白ねぎ  しろねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73678  AG09000071 09  6375 101  38071  31800  ほうれん草  ほうれんそう  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73687  AG09000071 09  6375 101  38071  31700  キャベツ  きゃべつ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73679  AG09000071 09  6375 101  38071  31500  小松菜  こまつな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73680  AG09000071 09  6375 101  38071  31310  水菜  みずな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete
73688  AG09000071 09  6375 101  38071  31100  はくさい  はくさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238071  12  2018-07-06 00:00:00    2018-07-06 15:08:51  MG00000001  2018-07-06 15:08:51  MG00000001  View Edit Delete

Page 74 of 15485, showing 20 records out of 309681 total, starting on record 1461, ending on 1480

(default) 2 queries took 989 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`.`farmer_id` desc LIMIT 1460, 20202011
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