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
16683197  AG04000164 04  50752 710  99506  36100  紅はるか  べにはるか  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683196  AG04000164 04  50752 710  99506  36100  紅さつま  べにさつま  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683195  AG04000164 04  50752 710  99506  32500  糸みつば  いとみつば  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683194  AG04000164 04  50752 710  99506  34300  米なす  べいなす  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683193  AG04000164 04  50752 710  99506  46000  章姫  あきひめ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683192  AG04000164 04  50752 710  99506  37500  穂じそ  ほじそ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683191  AG04000164 04  50752 710  99506  45000  種なし巨峰  たねなしきょほう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683190  AG04000164 04  50752 710  99506  45000  種なしピオーネ  たねなしぴおーね  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683189  AG04000164 04  50752 710  99506  46000  秩父いちご  ちちぶいちご  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683188  AG04000164 04  50752 710  99506  37300  福耳(ふくみみ)とうがらし  ふくみみとうがらし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683187  AG04000164 04  50752 710  99506  36300  石川芋  いしかわいも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683186  AG04000164 04  50752 710  99506  31100  白菜(間引き白菜)  はくさい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683185  AG04000164 04  50752 710  99506  31100  白菜  はくさい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683184  AG04000164 04  50752 710  99506  34200  白皮かぼちゃ  しろかわかぼちゃ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683183  AG04000164 04  50752 710  99506  45000  甲斐路  かいじ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683182  AG04000164 04  50752 710  99506  45000  甲州ぶどう  こうしゅうぶどう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683181  AG04000164 04  50752 710  99506  37200  生姜  きょうが  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683180  AG04000164 04  50752 710  99506  37100  生わさび  なまわさび  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683179  AG04000164 04  50752 710  99506  90003  生らっかせい  なまらっかせい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683178  AG04000164 04  50752 710  99506  30500  生たけのこ  なまたけのこ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete

Page 213 of 15485, showing 20 records out of 309681 total, starting on record 4241, ending on 4260

(default) 2 queries took 1003 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` desc LIMIT 4240, 20202025
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 = 111978