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
104896  AG01000335 01  6527 004  343621  90003  一寸豆  いっすんまめ  京都府 
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
104949  AG01000335 01  6527 004  343621  90005  いも  いも  京都府 
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
104921  AG01000335 01  6527 004  343621  90006  ゴーヤ  ごーや  京都府 
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
104971  AG01000335 01  6527 004  343621  91000  加工品  かこうひん  京都府 
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
104972  AG01000335 01  6527 004  343621  91002  雑貨  ざっか  京都府 
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
104973  AG01000335 01  6527 004  343621  91003  豆腐  とうふ  京都府 
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
104974  AG01000335 01  6527 004  343621  91004  あげ  あげ  京都府 
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
104975  AG01000335 01  6527 004  343621  91005  お茶  おちゃ  京都府 
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
104976  AG01000335 01  6527 004  343621  91006  漬物  つけもの  京都府 
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
104977  AG01000335 01  6527 004  343621  91007  餅  もち  京都府 
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
104978  AG01000335 01  6527 004  343621  91008  菓子  かし  京都府 
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
104979  AG01000335 01  6527 004  343621  91009  たまご  たまご  京都府 
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
104969  AG01000335 01  6527 004  343621  91010  お米  おこめ  京都府 
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
104967  AG01000335 01  6527 004  343621  91011  フラワー  ふらわー  京都府 
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
104968  AG01000335 01  6527 004  343621  99998  虫・魚  むしさかな  京都府 
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
104951  AG01000335 01  6528 004  499621  40100  みかん  みかん  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104952  AG01000335 01  6528 004  499621  41200  オレンジ  おれんじ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104954  AG01000335 01  6528 004  499621  41410  レモン  れもん  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104964  AG01000335 01  6528 004  499621  43000  梨  なし  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104965  AG01000335 01  6528 004  499621  43500  柿  かき  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  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 5 of 15485, showing 20 records out of 309681 total, starting on record 81, ending on 100

(default) 2 queries took 977 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 80, 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 = 111975