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
104932  AG01000335 01  6527 004  343621  37410  木の芽  きのめ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104931  AG01000335 01  6527 004  343621  37412  さんしょの実  さんしょのみ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104947  AG01000335 01  6527 004  343621  37500  しそ  しそ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104950  AG01000335 01  6527 004  343621  37600  みょうが  みょうが  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104942  AG01000335 01  6527 004  343621  37850  むかご  むかご  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104939  AG01000335 01  6527 004  343621  38100  生しいたけ  なましいたけ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104936  AG01000335 01  6527 004  343621  38300  なめこ  なめこ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104937  AG01000335 01  6527 004  343621  38521  ぶなしめじ  ぶなふめじ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104938  AG01000335 01  6527 004  343621  38604  エリンギ  えりんぎ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104923  AG01000335 01  6527 004  343621  38700  わらび  わらび  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104924  AG01000335 01  6527 004  343621  38900  山菜  さんさい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104946  AG01000335 01  6527 004  343621  39200  梅  うめ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104926  AG01000335 01  6527 004  343621  39310  ゆず  ゆず  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104927  AG01000335 01  6527 004  343621  39330  スダチ  すだち  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104934  AG01000335 01  6527 004  343621  39510  銀杏  ぎんなん  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104970  AG01000335 01  6527 004  343621  43500  干し柿  ほしがき  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104966  AG01000335 01  6527 004  343621  45700  栗  くり  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
67457  AG01000335 01  6527 004  343621  90001  野菜  やさい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2018-06-28 00:00:00    2018-06-28 15:12:16  MG00000001  2018-06-28 15:12:16  MG00000001  View Edit Delete
104902  AG01000335 01  6527 004  343621  90002  チシャ菜  ちしゃな  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104905  AG01000335 01  6527 004  343621  90002  葉物  はもの  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete

Page 4 of 15485, showing 20 records out of 309681 total, starting on record 61, ending on 80

(default) 2 queries took 1022 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`.`farmer_id` asc LIMIT 60, 2020202
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 = 1111020