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
16684455  AG01006002 01  50979 036  105859  31800  ほうれん草  ほうれんそう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105859  12  2023-11-28 00:00:00    2023-11-28 10:05:10  MG00000007  2023-11-28 10:05:10  MG00000007  View Edit Delete
16684454  AG01006002 01  50978 036  105858  30100  ダイコン  だいこん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105858  12  2023-11-28 00:00:00    2023-11-28 10:03:42  MG00000007  2023-11-28 10:03:42  MG00000007  View Edit Delete
16684453  AG01006002 01  50977 036  1058570  90000  農産物  のうさんぶつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
251058570  12  2023-11-28 00:00:00    2023-11-28 10:02:15  MG00000007  2023-11-28 10:02:15  MG00000007  View Edit Delete
16684452  AG01005844 01  50976 036  105856  35100  いんげん  いんげん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105856  12  2023-11-28 00:00:00    2023-11-28 09:52:21  MG00000007  2023-11-28 09:52:21  MG00000007  View Edit Delete
16684451  AG01005844 01  50975 036  105855  30300  人参  にんじん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105855  12  2023-11-28 00:00:00    2023-11-28 09:51:14  MG00000007  2023-11-28 09:51:14  MG00000007  View Edit Delete
16684450  AG01005844 01  50974 036  105854  36200  ジャガイモ  じゃがいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105854  12  2023-11-28 00:00:00    2023-11-28 09:50:10  MG00000007  2023-11-28 09:50:10  MG00000007  View Edit Delete
16684449  AG01005844 01  50973 036  105853  30400  ごぼう  ごぼう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105853  12  2023-11-28 00:00:00    2023-11-28 09:48:49  MG00000007  2023-11-28 09:48:49  MG00000007  View Edit Delete
16684448  AG01005844 01  50972 036  105852  33400  レタス  れたす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105852  12  2023-11-28 00:00:00    2023-11-28 09:47:09  MG00000007  2023-11-28 09:47:09  MG00000007  View Edit Delete
16684447  AG01005844 01  50971 036  105851  33410  サニーレタス  さにーれたす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105851  12  2023-11-28 00:00:00    2023-11-28 09:46:13  MG00000007  2023-11-28 09:46:13  MG00000007  View Edit Delete
16684446  AG01005844 01  50970 036  105850  30200  かぶ  かぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105850  12  2023-11-28 00:00:00    2023-11-28 09:45:01  MG00000007  2023-11-28 09:45:01  MG00000007  View Edit Delete
16684445  AG01005844 01  50969 036  105849  36300  里芋  さといも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105849  12  2023-11-28 00:00:00    2023-11-28 09:43:54  MG00000007  2023-11-28 09:43:54  MG00000007  View Edit Delete
16684444  AG01005844 01  50968 036  105848  31800  ほうれん草  ほうれんそう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105848  12  2023-11-28 00:00:00    2023-11-28 09:41:48  MG00000007  2023-11-28 09:41:48  MG00000007  View Edit Delete
16684443  AG01005844 01  50967 036  105847  30100  大根  だいこん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105847  12  2023-11-28 00:00:00    2023-11-28 09:40:48  MG00000007  2023-11-28 09:40:48  MG00000007  View Edit Delete
16684442  AG01005844 01  50966 036  105846  33300  ブロッコリー  ぶろっこりー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105846  12  2023-11-28 00:00:00    2023-11-28 09:39:49  MG00000007  2023-11-28 09:39:49  MG00000007  View Edit Delete
16684441  AG01005844 01  50965 036  105845  31700  キャベツ(早生)  きゃべつわせ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105845  12  2023-11-28 00:00:00    2023-11-28 09:38:22  MG00000007  2023-11-28 09:38:22  MG00000007  View Edit Delete
16684440  AG01005844 01  50964 036  105844  31900  九条葱  くじょうねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105844  12  2023-11-28 00:00:00    2023-11-28 09:36:52  MG00000007  2023-11-28 09:36:52  MG00000007  View Edit Delete
16684439  AG01005844 01  50963 036  105843  30200  聖護院かぶ  しょうごいんかぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105843  12  2023-11-28 00:00:00    2023-11-28 09:35:01  MG00000007  2023-11-28 09:35:01  MG00000007  View Edit Delete
16684438  AG01005844 01  50962 036  105842  36200  メークイン  めーくいん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105842  12  2023-11-28 00:00:00    2023-11-28 09:33:31  MG00000007  2023-11-28 09:33:31  MG00000007  View Edit Delete
16684437  AG01005844 01  50961 036  105841  35200  スナップえんどう  すなっぷえんどう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105841  12  2023-11-28 00:00:00    2023-11-28 09:31:43  MG00000007  2023-11-28 09:31:43  MG00000007  View Edit Delete
16684436  AG01005928 01  50960 036  105840  90008  かぼす  かぼす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105840  12  2023-11-28 00:00:00    2023-11-28 09:30:19  MG00000007  2023-11-28 09:30:19  MG00000007  View Edit Delete

Page 158 of 15485, showing 20 records out of 309681 total, starting on record 3141, ending on 3160

(default) 2 queries took 928 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 3140, 20202019
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 = 111909