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
16685310  AG04000166 04  51366 710  99533  91012  ちんげん菜  ちんげんさい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685309  AG04000166 04  51366 710  99533  31800  ちぢみほうれん草  ちぢみほうれんそう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685308  AG04000166 04  51366 710  99533  30100  だいこん  だいこん  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685307  AG04000166 04  51366 710  99533  38900  たらの芽  たらのめ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685306  AG04000166 04  51366 710  99533  36600  たまねぎ  たまねぎ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685305  AG04000166 04  51366 710  99533  36300  たけのこ芋  たけのこいも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685304  AG04000166 04  51366 710  99533  30500  たけのこ  たけのこ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685303  AG04000166 04  51366 710  99533  35400  そら豆  そらまめ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685302  AG04000166 04  51366 710  99533  34200  そうめんかぼちゃ  そうめんかぼちゃ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685301  AG04000166 04  51366 710  99533  38900  ぜんまい  ぜんまい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685300  AG04000166 04  51366 710  99533  32700  せり  せり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685299  AG04000166 04  51366 710  99533  44500  すもも  すもも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685298  AG04000166 04  51366 710  99533  39330  すだち  すだち  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685297  AG04000166 04  51366 710  99533  48000  すいか  すいか  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685296  AG04000166 04  51366 710  99533  36200  じゃが芋  じゃがいも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685295  AG04000166 04  51366 710  99533  36200  じゃがいも(十勝こがね)  じゃがいもとかちこがね  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685294  AG04000166 04  51366 710  99533  36200  じゃがいも(北海こがね)  じゃがいも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685293  AG04000166 04  51366 710  99533  36200  じゃがいも(北あかり)  じゃがいもきたあかり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685292  AG04000166 04  51366 710  99533  36200  じゃがいも(メークイン)  じゃがいもめーくいん  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685291  AG04000166 04  51366 710  99533  36200  じゃがいも(ノーザンルビー)  じゃがいものーざんるびー  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete

Page 116 of 15485, showing 20 records out of 309681 total, starting on record 2301, ending on 2320

(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 2300, 20202014
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 = 111989