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
16683217  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
16683216  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
16683215  AG04000164 04  50752 710  99506  36600  葉たまねぎ  はたまねぎ  埼玉県 
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
16683214  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
16683213  AG04000164 04  50752 710  99506  33920  菜の花  なのはな  埼玉県 
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
16683212  AG04000164 04  50752 710  99506  38110  菌床生椎茸  きんしょうなましいたけ  埼玉県 
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
16683211  AG04000164 04  50752 710  99506  90002  茎レタス(山クラゲ)  くきれたすやまくらげ  埼玉県 
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
16683210  AG04000164 04  50752 710  99506  33300  茎ブロッコリー  くきぶろっこりー  埼玉県 
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
16683209  AG04000164 04  50752 710  99506  31700  芽キャベツ  めきゃべつ  埼玉県 
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
16683208  AG04000164 04  50752 710  99506  36500  自然薯  じねんじょ  埼玉県 
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
16683207  AG04000164 04  50752 710  99506  30100  聖護院だいこん  しょうごいんだいこん  埼玉県 
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
16683206  AG04000164 04  50752 710  99506  35200  絹さやえんどう  きぬさやえんどう  埼玉県 
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
16683205  AG04000164 04  50752 710  99506  30400  細ごぼう  ほそこぼう  埼玉県 
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
16683204  AG04000164 04  50752 710  99506  31700  紫キャベツ  むらさききゃべつ  埼玉県 
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
16683203  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
16683202  AG04000164 04  50752 710  99506  91012  紅菜花  べになばな  埼玉県 
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
16683201  AG04000164 04  50752 710  99506  30100  紅芯大根  こうしんだいこん  埼玉県 
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
16683200  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
16683199  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
16683198  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

Page 212 of 15485, showing 20 records out of 309681 total, starting on record 4221, ending on 4240

(default) 2 queries took 934 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 4220, 20202026
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 = 111908