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
16680897  AG01005928 01  49712 036  105583  35500  枝豆  えだまめ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105583  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680896  AG01005928 01  49711 036  105582  90006  ゴーヤ  ごーや  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105582  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680895  AG01005928 01  49710 036  105581  34800  オクラ  おくら  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105581  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680894  AG01005928 01  49709 036  105580  34500  ピーマン  ぴーまん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105580  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680893  AG01005928 01  49708 036  105579  34300  ナス  なす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105579  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680892  AG01005928 01  49707 036  105578  34200  かぼちゃ  かぼちゃ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105578  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680891  AG01005928 01  49706 036  105577  34100  キューリ  きゅーり  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105577  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680890  AG01005928 01  49705 036  105576  33300  ブロッコリー  ぶろっこりー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105576  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680889  AG01005928 01  49704 036  105575  31100  白菜  はくさい  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105575  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680888  AG01005928 01  49703 036  105574  31700  キャベツ  きゃべつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105574  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680887  AG01005928 01  49702 036  105573  90000  農産物  のうさんぶつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105573  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680886  AG01005927 01  49701 036  105609  37600  みょうが  みょうが  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105609  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680885  AG01005927 01  49700 036  105608  36300  里芋  さといも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105608  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680884  AG01005927 01  49698 036  105606  36200  ジャガイモ  じゃがいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105606  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680883  AG01005927 01  49697 036  105605  35200  スナップえんどう  すなっぷえんどう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105605  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680882  AG01005927 01  49696 036  105604  35100  いんげん  いんげん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105604  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680881  AG01005927 01  49695 036  105603  90006  ゴーヤ  ごーや  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105603  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680880  AG01005927 01  49694 036  105602  37300  甘とうがらし  あまとうがらし  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105602  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680879  AG01005927 01  49693 036  105601  34600  ししとう  ししとう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105601  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680878  AG01005927 01  49692 036  105600  34500  ピーマン  ぴーまん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105600  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 326 of 15485, showing 20 records out of 309681 total, starting on record 6501, ending on 6520

(default) 2 queries took 1006 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 6500, 20202037
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 = 111969