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
16680917  AG01005930 01  49732 036  105586  91010  精米  せいまい  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105586  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680916  AG01005930 01  49731 036  105585  90000  農産物  のうさんぶつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105585  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680915  AG01005929 01  49730 036  105626  36300  里いも  さといも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105626  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680914  AG01005929 01  49729 036  105625  36200  ジャガイモ  じゃがいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105625  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680913  AG01005929 01  49728 036  105624  35400  そら豆  そらまめ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105624  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680912  AG01005929 01  49727 036  105623  35200  スナップえんどう  すなっぷえんどう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105623  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680911  AG01005929 01  49726 036  105622  34800  オクラ  おくら  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105622  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680910  AG01005929 01  49725 036  105621  34700  トウモロコシ  とうもろこし  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105621  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680909  AG01005929 01  49724 036  105620  34500  ピーマン  ぴーまん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105620  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680908  AG01005929 01  49723 036  105619  34300  ナス  なす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105619  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680907  AG01005929 01  49722 036  105618  33300  ブロッコリー  ぶろっこりー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105618  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680906  AG01005929 01  49721 036  105617  32600  春菊  しゅんぎく  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105617  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680905  AG01005929 01  49720 036  105616  31800  ほうれん草  ほうれんそう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105616  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680904  AG01005929 01  49719 036  105615  31700  キャベツ  きゃべつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105615  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680903  AG01005929 01  49718 036  105614  30400  ごぼう  ごぼう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105614  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680902  AG01005929 01  49717 036  105613  30300  ニンジン  にんじん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105613  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680901  AG01005929 01  49716 036  105612  30200  小かぶ  しょうかぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105612  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680900  AG01005929 01  49715 036  105611  30100  大根  だいこん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105611  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680899  AG01005929 01  49714 036  105610  90000  農産物  のうさんぶつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105610  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680898  AG01005928 01  49713 036  105584  36600  玉ねぎ  たまねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105584  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete

Page 325 of 15485, showing 20 records out of 309681 total, starting on record 6481, ending on 6500

(default) 2 queries took 1010 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 6480, 20202038
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 = 111972