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
63291  AG09000005 09  6253 101  38007  90006  ゴーヤ  ごーや  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63292  AG09000005 09  6253 101  38007  32300  ふき  ふき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63293  AG09000005 09  6253 101  38007  38700  わらび  わらび  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63294  AG09000005 09  6253 101  38007  38900  山菜  さんさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63295  AG09000005 09  6253 101  38007  36700  にんにく  にんにく  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63296  AG09000005 09  6253 101  38007  39310  ゆず  ゆず  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63297  AG09000005 09  6253 101  38007  39330  スダチ  すだち  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63298  AG09000005 09  6253 101  38007  35500  枝豆  えだまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63299  AG09000005 09  6253 101  38007  30500  たけのこ  たけのこ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63300  AG09000005 09  6253 101  38007  32400  うど  うど  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63301  AG09000005 09  6253 101  38007  37412  さんしょの実  さんしょのみ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63302  AG09000005 09  6253 101  38007  37410  木の芽  きのめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63303  AG09000005 09  6253 101  38007  33930  ずいき  ずいき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63304  AG09000005 09  6253 101  38007  39510  銀杏  ぎんなん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63305  AG09000005 09  6253 101  38007  33600  パセリ  ぱせり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63306  AG09000005 09  6253 101  38007  38300  なめこ  なめこ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63307  AG09000005 09  6253 101  38007  38521  ぶなしめじ  ぶなふめじ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63308  AG09000005 09  6253 101  38007  38604  エリンギ  えりんぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63309  AG09000005 09  6253 101  38007  38100  生しいたけ  なましいたけ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63310  AG09000005 09  6253 101  38007  36600  たまねぎ  たまねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238007  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete

Page 372 of 15485, showing 20 records out of 309681 total, starting on record 7421, ending on 7440

(default) 2 queries took 982 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 7420, 20202039
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 = 111943