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
60434  AG02000095 02  6220 51  254  40100  せとか  せとか  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378254  12  2018-05-22 00:00:00    2018-05-22 13:36:27  MG00000001  2018-05-22 13:36:27  MG00000001  View Edit Delete
60435  AG02000095 02  2666 51  230  40100  不知火  しらぬい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378230  12  2018-05-22 00:00:00    2018-05-22 13:37:09  MG00000001  2018-05-22 13:37:09  MG00000001  View Edit Delete
60436  AG02000095 02  6221 51  215  90008  黄金柑  おうごんかん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378215  12  2018-05-22 00:00:00    2018-05-22 13:40:14  MG00000001  2018-05-22 13:40:14  MG00000001  View Edit Delete
60437  AG02000095 02  6222 51  281  90008  柑橘  かんきつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378281  12  2018-05-22 00:00:00    2018-05-22 13:48:25  MG00000001  2018-05-22 13:48:25  MG00000001  View Edit Delete
60438  AG02000095 02  6223 51  282  41200  ブラッドオレンジ  ぶらっどおれんじ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378282  12  2018-05-22 00:00:00    2018-05-22 13:49:09  MG00000001  2018-05-22 13:49:09  MG00000001  View Edit Delete
60439  AG02000095 02  6224 51  268  41200  清見  きよみ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378268  12  2018-05-22 00:00:00    2018-05-22 13:50:00  MG00000001  2018-05-22 13:50:00  MG00000001  View Edit Delete
60440  AG02000095 02  6225 51  261  40100  はるか  はるか  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378261  12  2018-05-22 00:00:00    2018-05-22 13:51:09  MG00000001  2018-05-22 13:51:09  MG00000001  View Edit Delete
60441  AG02000095 02  6226 51  947  90008  カラマンダリン  からまんだりん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378947  12  2018-05-22 00:00:00    2018-05-22 13:51:40  MG00000001  2018-05-22 13:51:40  MG00000001  View Edit Delete
60442  AG02000095 02  6227 51  273  40100  南津海  なつみ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378273  12  2018-05-22 00:00:00    2018-05-22 13:52:20  MG00000001  2018-05-22 13:52:20  MG00000001  View Edit Delete
60443  AG02000095 02  2662 51  225  41260  甘夏  あまなつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378225  12  2018-05-22 00:00:00    2018-05-22 13:53:29  MG00000001  2018-05-22 13:53:29  MG00000001  View Edit Delete
60444  AG02000095 02  6228 51  256  90008  ジューシーフルーツ  じゅーしーふるーつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378256  12  2018-05-22 00:00:00    2018-05-22 13:54:04  MG00000001  2018-05-22 13:54:04  MG00000001  View Edit Delete
60445  AG02000095 02  2641 51  178  41410  レモン  れもん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378178  12  2018-05-22 00:00:00    2018-05-22 13:54:35  MG00000001  2018-05-22 13:54:35  MG00000001  View Edit Delete
60446  AG02000095 02  2670 51  299  90007  果物その他  くだものそのた  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26378299  12  2018-05-22 00:00:00    2018-05-22 13:55:01  MG00000001  2018-05-22 13:55:01  MG00000001  View Edit Delete
60447  AG02000096 02  2652 51  199  90001  野菜その他  やさいそのた  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379199  12  2018-05-22 00:00:00    2018-05-22 13:57:11  MG00000001  2018-05-22 13:57:11  MG00000001  View Edit Delete
60448  AG02000096 02  2604 51  104  36600  玉ねぎ  たまねぎ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379104  12  2018-05-22 00:00:00    2018-05-22 13:57:52  MG00000001  2018-05-22 13:57:52  MG00000001  View Edit Delete
60449  AG02000096 02  6229 51  709  34300  長ナス  ながなす  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379709  12  2018-05-22 00:00:00    2018-05-22 14:00:02  MG00000001  2018-05-22 14:00:02  MG00000001  View Edit Delete
60450  AG02000096 02  2607 51  107  34100  きゅうり  きゅうり  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379107  12  2018-05-22 00:00:00    2018-05-22 14:01:10  MG00000001  2018-05-22 14:01:10  MG00000001  View Edit Delete
60451  AG02000096 02  2622 51  138  36300  里芋  さといも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379138  12  2018-05-22 00:00:00    2018-05-22 14:02:14  MG00000001  2018-05-22 14:02:14  MG00000001  View Edit Delete
60452  AG02000096 02  2695 51  703  30600  レンコン  れんこん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379703  12  2018-05-22 00:00:00    2018-05-22 14:07:22  MG00000001  2018-05-22 14:07:22  MG00000001  View Edit Delete
60453  AG02000096 02  6219 51  298  40100  甘平  かんぺい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26379298  12  2018-05-22 00:00:00    2018-05-22 14:08:43  MG00000001  2018-05-22 14:08:43  MG00000001  View Edit Delete

Page 340 of 15485, showing 20 records out of 309681 total, starting on record 6781, ending on 6800

(default) 2 queries took 992 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` asc LIMIT 6780, 20202035
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 = 111957