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
16679914  AG01005869 01  48792 036  108348  32600  シュンギク  しゅんぎく  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108348  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679913  AG01005869 01  48791 036  108347  36200  ジャガイモ  じゃがいも  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108347  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679912  AG01005869 01  48790 036  108346  34600  ししとう  ししとう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108346  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679911  AG01005869 01  48789 036  108345  90003  四角豆  しかくまめ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108345  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679910  AG01005869 01  48788 036  108344  31800  サラダほうれん草  さらだほうれんそう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108344  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679909  AG01005869 01  48787 036  108343  35200  さやえんどう  さやえんどう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108343  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679908  AG01005869 01  48786 036  108342  33410  サニーレタス  さにーれたす  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108342  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679907  AG01005869 01  48785 036  108341  90003  ささげ  ささげ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108341  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679906  AG01005869 01  48784 036  108340  31500  コマツナ  こまつな  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108340  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679905  AG01005869 01  48783 036  108339  34100  キュウリ  きゅうり  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108339  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679904  AG01005869 01  48782 036  108338  31700  キャベツ  きゃべつ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108338  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679903  AG01005869 01  48781 036  108337  33200  カリフローレ  かりふろーれ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108337  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679902  AG01005869 01  48780 036  108336  33200  カリフラワー  かりふらわー  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108336  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679901  AG01005869 01  48779 036  108335  90002  カリーノケール  かりーのけーる  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108335  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679900  AG01005869 01  48778 036  108334  34200  かぼちゃ  かぼちゃ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108334  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679899  AG01005869 01  48777 036  108333  30200  かぶ  かぶ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108333  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679898  AG01005869 01  48776 036  108332  90002  かつお菜  かつおな  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108332  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679897  AG01005869 01  48775 036  108331  34800  オクラ  おくら  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108331  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679896  AG01005869 01  48774 036  108330  35100  いんげん  いんげん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108330  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
16679895  AG01005869 01  48773 036  108329  34600  甘長ししとう  あまちょうししとう  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108329  12  2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete

Page 372 of 15485, showing 20 records out of 309681 total, starting on record 7421, ending on 7440

(default) 2 queries took 1006 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 7420, 20202043
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 = 111963