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
16682575  AG01005868 01  50632 036  109140  90003  小豆  あずき  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109140  12  2023-11-13 00:00:00    2023-11-13 17:33:32  MG00000007  2023-11-13 17:33:32  MG00000007  View Edit Delete
16682574  AG01005868 01  50631 036  109139  34570  パプリカ  ぱぷりか  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109139  12  2023-11-13 00:00:00    2023-11-13 17:32:39  MG00000007  2023-11-13 17:32:39  MG00000007  View Edit Delete
16682573  AG01005868 01  50630 036  109138  32600  春菊  しゅんぎく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109138  12  2023-11-13 00:00:00    2023-11-13 17:31:44  MG00000007  2023-11-13 17:31:44  MG00000007  View Edit Delete
16682572  AG01005868 01  50629 036  109137  30200  サラダかぶ  さらだかぶ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109137  12  2023-11-13 00:00:00    2023-11-13 17:30:38  MG00000007  2023-11-13 17:30:38  MG00000007  View Edit Delete
16682571  AG01005864 01  50628 037  114887  91011  水仙  すいせん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25114887  12  2023-11-13 00:00:00    2023-11-13 17:27:56  MG00000007  2023-11-13 17:27:56  MG00000007  View Edit Delete
16682570  AG01005864 01  50627 036  109136  41320  はっさく  はっさく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109136  12  2023-11-13 00:00:00    2023-11-13 17:26:26  MG00000007  2023-11-13 17:26:26  MG00000007  View Edit Delete
16682569  AG01005864 01  50626 036  109135  41410  レモン  れもん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109135  12  2023-11-13 00:00:00    2023-11-13 17:25:27  MG00000007  2023-11-13 17:25:27  MG00000007  View Edit Delete
16682568  AG01005864 01  50624 036  109133  90003  グリンピース  ぐりんぴーす  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109133  12  2023-11-13 00:00:00    2023-11-13 17:23:14  MG00000007  2023-11-13 17:23:14  MG00000007  View Edit Delete
16682567  AG01005864 01  50621 036  109130  33810  チンゲンサイ  ちんげんさい  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109130  12  2023-11-13 00:00:00    2023-11-13 17:17:33  MG00000007  2023-11-13 17:17:33  MG00000007  View Edit Delete
16682566  AG01005864 01  50620 036  109129  31800  ほうれん草  ほうれんそう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109129  12  2023-11-13 00:00:00    2023-11-13 17:14:15  MG00000007  2023-11-13 17:14:15  MG00000007  View Edit Delete
16682565  AG01005864 01  50619 036  109128  30100  葉大根  はだいこん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109128  12  2023-11-13 00:00:00    2023-11-13 17:12:09  MG00000007  2023-11-13 17:12:09  MG00000007  View Edit Delete
16682564  AG01005994 01  50618 036  105768  43500  柿  かき  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105768  12  2023-11-13 00:00:00    2023-11-13 17:10:38  MG00000007  2023-11-13 17:10:38  MG00000007  View Edit Delete
16682563  AG01005994 01  50617 036  105767  90008  パール柑  ぱーるかん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105767  12  2023-11-13 00:00:00    2023-11-13 17:09:18  MG00000007  2023-11-13 17:09:18  MG00000007  View Edit Delete
16682562  AG01003272 01  5094 011  60601  90005  きくいも  きくいも  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760601  12  2023-11-13 00:00:00    2023-11-13 17:09:09  AG01003272  2023-11-13 17:09:09  AG01003272  View Edit Delete
16682561  AG01003279 01  5098 011  60605  33400  レタス  れたす  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760605  12  2023-11-13 00:00:00    2023-11-13 17:05:57  AG01003279  2023-11-13 17:05:57  AG01003279  View Edit Delete
16682560  AG01005994 01  50615 036  105765  39310  ゆず  ゆず  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105765  12  2023-11-13 00:00:00    2023-11-13 17:04:48  MG00000007  2023-11-13 17:04:48  MG00000007  View Edit Delete
16682559  AG01005994 01  50614 036  105764  36600  新玉ねぎ  しんたまねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105764  12  2023-11-13 00:00:00    2023-11-13 17:03:54  MG00000007  2023-11-13 17:03:54  MG00000007  View Edit Delete
16682558  AG01005994 01  50613 036  105763  36300  サトイモ  さといも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105763  12  2023-11-13 00:00:00    2023-11-13 17:00:43  MG00000007  2023-11-13 17:00:43  MG00000007  View Edit Delete
16682557  AG01005994 01  50612 036  105762  90005  赤芽芋  あかめいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105762  12  2023-11-13 00:00:00    2023-11-13 16:59:52  MG00000007  2023-11-13 16:59:52  MG00000007  View Edit Delete
16682556  AG01005994 01  50611 036  105761  36200  ジャガイモ  じゃがいも  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105761  12  2023-11-13 00:00:00    2023-11-13 16:53:53  MG00000007  2023-11-13 16:53:53  MG00000007  View Edit Delete

Page 244 of 15485, showing 20 records out of 309681 total, starting on record 4861, ending on 4880

(default) 2 queries took 969 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 4860, 20202029
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 = 111940