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
16684938  AG01005703 01  46789 034  81252  31700  キャベツ  きゃべつ  大阪府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2681252  12  2023-12-12 00:00:00    2023-12-12 07:53:40  AG01005703  2023-12-12 07:53:40  AG01005703  View Edit Delete
16684937  AG01003666 01  7416 011  69793  90002  からし菜  からしな  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769793  12  2023-12-11 00:00:00    2023-12-11 17:00:09  AG01003666  2023-12-11 17:00:09  AG01003666  View Edit Delete
16684936  AG01004447 01  40877 033  55132  36200  ジャガイモ  じゃがいも  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255132  12  2023-12-11 00:00:00    2023-12-11 09:37:43  AG01004447  2023-12-11 09:37:43  AG01004447  View Edit Delete
16684935  AG01004505 01  17150 066  059  36300  たけのこ芋  たけのこいも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24168059  12  2023-12-10 00:00:00    2023-12-10 14:34:44  AG01004505  2023-12-10 14:34:44  AG01004505  View Edit Delete
16684934  AG01004505 01  14553 063  646161  90001  たけのこ芋  たけのこいも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646161  12  2023-12-10 00:00:00    2023-12-10 14:34:20  AG01004505  2023-12-10 14:34:20  AG01004505  View Edit Delete
16684933  AG01003555 01  42633 032  86120  90008  完熟ライム  かんじゅくらいむ  香川県三豊市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2686120  12  2023-12-10 00:00:00    2023-12-10 10:38:58  AG01003555  2023-12-10 10:38:58  AG01003555  View Edit Delete
16684932  AG01005103 01  15468 065  500263  36200  新じゃがいも  しんじゃがいも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20500263  12  2023-12-09 00:00:00    2023-12-09 18:12:42  AG01005103  2023-12-09 18:12:42  AG01005103  View Edit Delete
16684931  AG01004502 01  14648 063  646256  30400  ゴボウ  ごぼう  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646256  12  2023-12-09 00:00:00    2023-12-09 14:35:51  AG01004502  2023-12-09 14:35:51  AG01004502  View Edit Delete
16684930  AG01004502 01  15053 062  646256  30400  ゴボウ  ごぼう  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646256  12  2023-12-09 00:00:00    2023-12-09 14:35:28  AG01004502  2023-12-09 14:35:28  AG01004502  View Edit Delete
16684929  AG01004447 01  40875 033  55130  30300  人参  にんじん  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:33:16  AG01004447  2023-12-09 14:33:16  AG01004447  View Edit Delete
16684928  AG01004447 01  40875 033  55130  36600  玉ねぎ  たまねぎ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:32:44  AG01004447  2023-12-09 14:32:44  AG01004447  View Edit Delete
16684927  AG01004447 01  40875 033  55130  32600  春菊  しゅんぎく  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:31:52  AG01004447  2023-12-09 14:31:52  AG01004447  View Edit Delete
16684926  AG01004447 01  40875 033  55130  30200  かぶ  かぶ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:31:07  AG01004447  2023-12-09 14:31:07  AG01004447  View Edit Delete
16684925  AG01004447 01  40875 033  55130  30100  大根  だいこん  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:30:26  AG01004447  2023-12-09 14:30:26  AG01004447  View Edit Delete
16684924  AG01004447 01  40875 033  55130  36200  ジャガイモ  じゃがいも  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0255130  12  2023-12-09 00:00:00    2023-12-09 14:24:16  AG01004447  2023-12-11 09:37:08  AG01004447  View Edit Delete
16684923  AG01005342 01  28502 031  625125  31900  ネギ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17625125  12  2023-12-09 00:00:00    2023-12-09 12:42:53  AG01005342  2023-12-09 12:42:53  AG01005342  View Edit Delete
16684922  AG01005841 01  47732 036  105016  33200  農産物(カリフラワー)  のうさんぶつかりふらわ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105016  12  2023-12-09 00:00:00    2023-12-09 08:48:10  AG01005841  2023-12-09 08:48:10  AG01005841  View Edit Delete
16684921  AG01005102 01  17103 066  012  31310  水菜  みずな  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24121012  12  2023-12-08 00:00:00    2023-12-08 17:35:44  AG01005102  2023-12-08 17:35:44  AG01005102  View Edit Delete
16684920  AG01005693 01  46714 034  81099  31900  九条ネギ  くじょうねぎ  大阪府枚方市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2681099  12  2023-12-08 00:00:00    2023-12-08 15:22:49  AG01005693  2023-12-08 15:22:49  AG01005693  View Edit Delete
16684919  AG01005690 01  46684 034  81069  31800  ほうれん草  ほうれんそう  大阪府枚方市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2681069  12  2023-12-08 00:00:00    2023-12-08 15:19:43  AG01005690  2023-12-08 15:19:43  AG01005690  View Edit Delete

Page 134 of 15485, showing 20 records out of 309681 total, starting on record 2661, ending on 2680

(default) 2 queries took 929 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 2660, 20202017
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 = 111912