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
73702  AG09000071 09  6375 101  38071  90006  ゴーヤ  ごーや  香川県 
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
73730  AG09000071 09  6375 101  38071  90005  いも  いも  香川県 
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
73677  AG09000071 09  6375 101  38071  90003  一寸豆  いっすんまめ  香川県 
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
73686  AG09000071 09  6375 101  38071  90002  葉物  はもの  香川県 
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
73683  AG09000071 09  6375 101  38071  90002  チシャ菜  ちしゃな  香川県 
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
73748  AG09000071 09  6375 101  38071  90001  野菜  やさい  香川県 
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
73734  AG09000071 09  6375 101  38071  49300  キウイ  きうい  香川県 
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
73739  AG09000071 09  6375 101  38071  48000  すいか  すいか  香川県 
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
73738  AG09000071 09  6375 101  38071  47000  メロン  めろん  香川県 
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
73737  AG09000071 09  6375 101  38071  46000  いちご  いちご  香川県 
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
73743  AG09000071 09  6375 101  38071  45800  いちじく  いちじく  香川県 
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
73747  AG09000071 09  6375 101  38071  45700  栗  くり  香川県 
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
73744  AG09000071 09  6375 101  38071  45000  ぶどう  ぶどう  香川県 
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
73741  AG09000071 09  6375 101  38071  44500  プラム  ぷらむ  香川県 
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
73742  AG09000071 09  6375 101  38071  44000  桃  もも  香川県 
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
73740  AG09000071 09  6375 101  38071  43900  びわ  びわ  香川県 
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
73753  AG09000071 09  6375 101  38071  43500  干し柿  ほしがき  香川県 
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
73746  AG09000071 09  6375 101  38071  43500  柿  かき  香川県 
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
73745  AG09000071 09  6375 101  38071  43000  梨  なし  香川県 
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
73735  AG09000071 09  6375 101  38071  41410  レモン  れもん  香川県 
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 71 of 15485, showing 20 records out of 309681 total, starting on record 1401, ending on 1420

(default) 2 queries took 943 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 1400, 20202019
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 = 111924