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
16684495  AG01005957 01  51019 036  109179  90005  自然薯  じねんじょ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109179  12  2023-11-28 00:00:00    2023-11-28 15:39:48  MG00000007  2023-11-28 15:39:48  MG00000007  View Edit Delete
16684494  AG01005941 01  51018 036  109178  30100  ビーツ  びーつ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109178  12  2023-11-28 00:00:00    2023-11-28 15:36:39  MG00000007  2023-11-28 15:36:39  MG00000007  View Edit Delete
16684493  AG01005941 01  51017 036  109177  41260  甘夏  あまなつ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109177  12  2023-11-28 00:00:00    2023-11-28 15:34:53  MG00000007  2023-11-28 15:34:53  MG00000007  View Edit Delete
16684492  AG01005941 01  51016 036  109176  36700  にんにく  にんにく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109176  12  2023-11-28 00:00:00    2023-11-28 15:33:43  MG00000007  2023-11-28 15:33:43  MG00000007  View Edit Delete
16684491  AG01005941 01  51015 036  109175  31800  ほうれん草  ほうれんそう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109175  12  2023-11-28 00:00:00    2023-11-28 15:26:43  MG00000007  2023-11-28 15:26:43  MG00000007  View Edit Delete
16684490  AG01005941 01  51014 036  109174  36600  玉ねぎ  たまねぎ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109174  12  2023-11-28 00:00:00    2023-11-28 15:25:51  MG00000007  2023-11-28 15:25:51  MG00000007  View Edit Delete
16684489  AG01005941 01  51013 036  109173  43900  びわ  びわ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109173  12  2023-11-28 00:00:00    2023-11-28 15:24:42  MG00000007  2023-11-28 15:24:42  MG00000007  View Edit Delete
16684488  AG01005941 01  51012 036  109172  90002  サラダケール  さらだけーる  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109172  12  2023-11-28 00:00:00    2023-11-28 15:23:40  MG00000007  2023-11-28 15:23:40  MG00000007  View Edit Delete
16684487  AG01005941 01  51011 036  109171  33400  ミックスレタス  みっくすれたす  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109171  12  2023-11-28 00:00:00    2023-11-28 15:22:34  MG00000007  2023-11-28 15:22:34  MG00000007  View Edit Delete
16684486  AG01005941 01  51010 036  109170  31500  こまつ菜  こまつな  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109170  12  2023-11-28 00:00:00    2023-11-28 15:08:51  MG00000007  2023-11-28 15:08:51  MG00000007  View Edit Delete
16684485  AG01005941 01  51009 036  109169  90002  サラダ菜  さらだな  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109169  12  2023-11-28 00:00:00    2023-11-28 15:06:27  MG00000007  2023-11-28 15:06:27  MG00000007  View Edit Delete
16684484  AG01005941 01  51008 036  109168  33810  チンゲンサイ  ちんげんさい  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109168  12  2023-11-28 00:00:00    2023-11-28 14:28:21  MG00000007  2023-11-28 14:28:21  MG00000007  View Edit Delete
16684483  AG01005941 01  51007 036  109167  33300  セニョリックスティック  せにょりっくすてぃっく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109167  12  2023-11-28 00:00:00    2023-11-28 14:27:14  MG00000007  2023-11-28 14:27:14  MG00000007  View Edit Delete
16684482  AG01002726 01  18782 032  85545  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685545  12  2023-11-28 00:00:00    2023-11-28 13:48:28  AG01002726  2023-11-28 13:48:28  AG01002726  View Edit Delete
16684481  AG01006003 01  51006 036  109166  90008  シークワーサー  しーくわーさー  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109166  12  2023-11-28 00:00:00    2023-11-28 13:23:58  MG00000007  2023-11-28 13:23:58  MG00000007  View Edit Delete
16684480  AG01006003 01  51005 036  109165  31800  ほうれん草  ほうれんそう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109165  12  2023-11-28 00:00:00    2023-11-28 13:19:47  MG00000007  2023-11-28 13:19:47  MG00000007  View Edit Delete
16684479  AG01006003 01  51004 036  109164  90008  かぼす  かぼす  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109164  12  2023-11-28 00:00:00    2023-11-28 11:58:05  MG00000007  2023-11-28 13:47:13  MG00000001  View Edit Delete
16684478  AG01006003 01  51003 036  109163  30100  大根  だいこん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109163  12  2023-11-28 00:00:00    2023-11-28 11:55:58  MG00000007  2023-11-28 11:55:58  MG00000007  View Edit Delete
16684477  AG01006003 01  51002 036  109162  39310  ゆず  ゆず  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109162  12  2023-11-28 00:00:00    2023-11-28 11:54:38  MG00000007  2023-11-28 11:54:38  MG00000007  View Edit Delete
16684476  AG01006003 01  51001 036  109161  36700  にんにく  にんにく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109161  12  2023-11-28 00:00:00    2023-11-28 11:41:32  MG00000007  2023-11-28 11:41:32  MG00000007  View Edit Delete

Page 156 of 15485, showing 20 records out of 309681 total, starting on record 3101, ending on 3120

(default) 2 queries took 1094 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`.`id` desc LIMIT 3100, 20202022
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 = 1111072