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
16686709  AG04000167 04  51461 710  99545  30200  赤かぶ  あかかぶ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686708  AG04000167 04  51461 710  99545  43000  豊水梨  ほうすいなし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686707  AG04000167 04  51461 710  99545  34400  調理用トマト  ちょうりようとまと  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686706  AG04000167 04  51461 710  99545  91001  蜂蜜百花(小)  はちみつひゃっか しょう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686705  AG04000167 04  51461 710  99545  91001  蜂蜜百花(大)  はちみつひゃっか だい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686704  AG04000167 04  51461 710  99545  91001  蜂蜜ヘアリ(小)  はちみつへあり しょう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686703  AG04000167 04  51461 710  99545  91001  蜂蜜ヘアリ(大)  はちみつへあり だい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686702  AG04000167 04  51461 710  99545  91001  蜂蜜アカシア  はちみつあかしあ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686701  AG04000167 04  51461 710  99545  43500  蜂屋柿(渋柿)  はちやがき しぶがき  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686700  AG04000167 04  51461 710  99545  45000  藤稔  ふじみのり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686699  AG04000167 04  51461 710  99545  90002  蕾菜  つぼみな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686698  AG04000167 04  51461 710  99545  37200  葉生姜  はしょうが  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686697  AG04000167 04  51461 710  99545  37100  葉わさび  はわさび  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686696  AG04000167 04  51461 710  99545  36600  葉たまねぎ  はたまねぎ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686695  AG04000167 04  51461 710  99545  90003  落花生(生)  らっかせい なま  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686694  AG04000167 04  51461 710  99545  33920  菜の花  なのはな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686693  AG04000167 04  51461 710  99545  38110  菌床生椎茸  きんしょうなましいたけ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686692  AG04000167 04  51461 710  99545  90002  茎レタス(山クラゲ)  くきれたすやまくらげ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686691  AG04000167 04  51461 710  99545  33300  茎ブロッコリー  くきぶろっこりー  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686690  AG04000167 04  51461 710  99545  31700  芽キャベツ  めきゃべつ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete

Page 50 of 15485, showing 20 records out of 309681 total, starting on record 981, ending on 1000

(default) 2 queries took 910 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 980, 2020207
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 = 111903