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
63111  AG09000001 09  6249 101  38002  38100  生しいたけ  なましいたけ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63112  AG09000001 09  6249 101  38002  36600  たまねぎ  たまねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63113  AG09000001 09  6249 101  38002  36200  じゃがいも  じゃがいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63114  AG09000001 09  6249 101  38002  37850  むかご  むかご  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63115  AG09000001 09  6249 101  38002  36500  山芋  やまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63116  AG09000001 09  6249 101  38002  36100  さつま芋  さつまいも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63117  AG09000001 09  6249 101  38002  36300  さといも  さといも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63118  AG09000001 09  6249 101  38002  39200  梅  うめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63119  AG09000001 09  6249 101  38002  37500  しそ  しそ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63120  AG09000001 09  6249 101  38002  34950  うり  うり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63121  AG09000001 09  6249 101  38002  90005  いも  いも  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63122  AG09000001 09  6249 101  38002  37600  みょうが  みょうが  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63123  AG09000001 09  6249 101  38002  40100  みかん  みかん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63124  AG09000001 09  6249 101  38002  41200  オレンジ  おれんじ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63125  AG09000001 09  6249 101  38002  49300  キウイ  きうい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63126  AG09000001 09  6249 101  38002  41410  レモン  れもん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63127  AG09000001 09  6249 101  38002  90008  柑橘類  かんきつるい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63128  AG09000001 09  6249 101  38002  46000  いちご  いちご  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63129  AG09000001 09  6249 101  38002  47000  メロン  めろん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63130  AG09000001 09  6249 101  38002  48000  すいか  すいか  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete

Page 363 of 15485, showing 20 records out of 309681 total, starting on record 7241, ending on 7260

(default) 2 queries took 994 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 7240, 20202040
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 = 111954