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
16684475  AG01005870 01  50999 036  109159  37200  しょうが  しょうが  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109159  12  2023-11-28 00:00:00    2023-11-28 11:22:34  MG00000007  2023-11-28 11:22:34  MG00000007  View Edit Delete
16684474  AG01005828 01  50998 036  105878  32800  にら  にら  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105878  12  2023-11-28 00:00:00    2023-11-28 11:14:11  MG00000007  2023-11-28 11:14:11  MG00000007  View Edit Delete
16684473  AG01005828 01  50997 036  105877  32600  春菊  しゅんぎく  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105877  12  2023-11-28 00:00:00    2023-11-28 11:12:01  MG00000007  2023-11-28 11:12:01  MG00000007  View Edit Delete
16684472  AG01006002 01  50996 036  105876  31100  白菜  はくさい  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105876  12  2023-11-28 00:00:00    2023-11-28 10:48:30  MG00000007  2023-11-28 10:48:30  MG00000007  View Edit Delete
16684471  AG01006002 01  50995 036  105875  36100  さつまいも  さつまいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105875  12  2023-11-28 00:00:00    2023-11-28 10:43:24  MG00000007  2023-11-28 10:43:24  MG00000007  View Edit Delete
16684470  AG01006002 01  50994 036  105874  34200  かぼちゃ  かぼちゃ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105874  12  2023-11-28 00:00:00    2023-11-28 10:41:23  MG00000007  2023-11-28 10:41:23  MG00000007  View Edit Delete
16684469  AG01006002 01  50993 036  105873  31420  高菜  たかな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105873  12  2023-11-28 00:00:00    2023-11-28 10:36:59  MG00000007  2023-11-28 10:36:59  MG00000007  View Edit Delete
16684468  AG01006002 01  50992 036  105872  90002  かつお菜  かつおな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105872  12  2023-11-28 00:00:00    2023-11-28 10:35:23  MG00000007  2023-11-28 10:35:23  MG00000007  View Edit Delete
16684467  AG01006002 01  50991 036  105871  34950  甘ウリ  あまうり  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105871  12  2023-11-28 00:00:00    2023-11-28 10:33:33  MG00000007  2023-11-28 10:33:33  MG00000007  View Edit Delete
16684466  AG01006002 01  50990 036  105870  48000  すいか  すいか  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105870  12  2023-11-28 00:00:00    2023-11-28 10:32:22  MG00000007  2023-11-28 10:32:22  MG00000007  View Edit Delete
16684465  AG01006002 01  50989 036  105869  33300  ブロッコリー  ぶろっこりー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105869  12  2023-11-28 00:00:00    2023-11-28 10:31:14  MG00000007  2023-11-28 10:31:14  MG00000007  View Edit Delete
16684464  AG01006002 01  50988 036  105868  35400  そら豆  そらまめ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105868  12  2023-11-28 00:00:00    2023-11-28 10:25:18  MG00000007  2023-11-28 10:25:18  MG00000007  View Edit Delete
16684463  AG01006002 01  50987 036  105867  30300  人参  にんじん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105867  12  2023-11-28 00:00:00    2023-11-28 10:17:22  MG00000007  2023-11-28 10:17:22  MG00000007  View Edit Delete
16684462  AG01006002 01  50986 036  105866  31700  キャベツ  きゃべつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105866  12  2023-11-28 00:00:00    2023-11-28 10:16:05  MG00000007  2023-11-28 10:16:05  MG00000007  View Edit Delete
16684461  AG01006002 01  50985 036  105865  34500  ピーマン  ぴーまん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105865  12  2023-11-28 00:00:00    2023-11-28 10:14:24  MG00000007  2023-11-28 10:14:24  MG00000007  View Edit Delete
16684460  AG01006002 01  50984 036  105864  34300  ナス  なす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105864  12  2023-11-28 00:00:00    2023-11-28 10:12:55  MG00000007  2023-11-28 10:12:55  MG00000007  View Edit Delete
16684459  AG01006002 01  50983 036  105863  36600  タマネギ  たまねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105863  12  2023-11-28 00:00:00    2023-11-28 10:11:48  MG00000007  2023-11-28 10:11:48  MG00000007  View Edit Delete
16684458  AG01006002 01  50982 036  105862  31900  ネギ  ねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105862  12  2023-11-28 00:00:00    2023-11-28 10:10:41  MG00000007  2023-11-28 10:10:41  MG00000007  View Edit Delete
16684457  AG01006002 01  50981 036  105861  36200  馬鈴薯  ばれいしょ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105861  12  2023-11-28 00:00:00    2023-11-28 10:08:26  MG00000007  2023-11-28 10:08:26  MG00000007  View Edit Delete
16684456  AG01006002 01  50980 036  105860  36300  里芋  さといも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105860  12  2023-11-28 00:00:00    2023-11-28 10:07:15  MG00000007  2023-11-28 10:07:15  MG00000007  View Edit Delete

Page 157 of 15485, showing 20 records out of 309681 total, starting on record 3121, ending on 3140

(default) 2 queries took 947 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 3120, 20202020
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 = 111927