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
112202  AG01001087 01  7664 102  2400033507893   34400  トマト \258 \279  とまと  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350789  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112201  AG01001087 01  7663 102  2400033507978   34400  トマト \198 \214  とまと  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350797  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112203  AG01001087 01  7665 102  2400033507992   34460  ミニトマト \100 \108  みにとまと  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350799  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112204  AG01001087 01  7666 102  2400033508005   34460  ミニトマト \158 \171  みにとまと  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350800  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112206  AG01001087 01  7668 102  2400033508043   34300  なす \198 \214  なす  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350804  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112205  AG01001087 01  7667 102  2400033508074   34300  なす \158 \171  なす  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350807  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112207  AG01001087 01  7669 102  2400033508081   34100  きゅうり \100 \108  きゅうり  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350808  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112208  AG01001087 01  7670 102  2400033508098   34100  きゅうり \158 \171  きゅうり  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350809  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112209  AG01001087 01  7671 102  2400033508135   36600  たまねぎ \100 \108  たまねぎ  兵庫県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350813  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-24 12:03:21  AG01001087  View Edit Delete
112210  AG01001087 01  7672 102  2400033508159   36600  たまねぎ \198 \214  たまねぎ  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350815  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112212  AG01001087 01  7674 102  2400033508166   36200  じゃがいも \198 \214  じゃがいも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350816  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-24 12:04:01  AG01001087  View Edit Delete
112211  AG01001087 01  7673 102  2400033508180   36200  じゃがいも \100 \108  じゃがいも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350818  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-24 12:03:44  AG01001087  View Edit Delete
112213  AG01001087 01  7675 102  2400033508197   36100  さつまいも \138 \149  さつまいも  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350819  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112214  AG01001087 01  7676 102  2400033508234   36100  さつまいも \198 \214  さつまいも  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350823  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112215  AG01001087 01  7677 102  2400033508258   38110  菌床椎茸 \198 \214  きんしょうしいたけ  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350825  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112216  AG01001087 01  7678 102  2400033508319   38110  菌床椎茸 \100 \108  きんしょうしいたけ  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350831  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112217  AG01001087 01  7679 102  2400033508401   34500  ピーマン \100 \108  ぴーまん  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350840  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112218  AG01001087 01  7680 102  2400033508425   34500  ピーマン \158 \171  ぴーまん  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350842  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112219  AG01001087 01  7681 102  2400033508432   36300  さといも \158 \171  さといも  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350843  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete
112220  AG01001087 01  7682 102  2400033508449   36300  さといも \198 \214  さといも  奈良県              
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
14  240003350844  12  2019-05-23 00:00:00    2019-05-21 10:37:12  MG00000001  2019-05-21 10:37:12  MG00000001  View Edit Delete

Page 147 of 15485, showing 20 records out of 309681 total, starting on record 2921, ending on 2940

(default) 2 queries took 984 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 2920, 20202021
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 = 111963