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
16685550  AG04000166 04  51366 710  99533  35500  枝豆(サッポロミドリ)  えだまめ(さっぽろみどり)  埼玉県 
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
16685549  AG04000166 04  51366 710  99533  35500  枝豆(グリーン75)  えだまめぐりーんななじゅうご  埼玉県 
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
16685548  AG04000166 04  51366 710  99533  35500  枝豆(やみつき君)  えだまめ(やみつきくん)  埼玉県 
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
16685547  AG04000166 04  51366 710  99533  35500  枝豆(とよふさ)  えだまめ(とよふさ)  埼玉県 
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
16685546  AG04000166 04  51366 710  99533  35500  枝豆(げんき娘)  えだまめ(げんきむすめ)  埼玉県 
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
16685545  AG04000166 04  51366 710  99533  35500  枝豆(おつな姫)  えだまめ(おつなひめ)  埼玉県 
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
16685544  AG04000166 04  51366 710  99533  35500  枝豆(いきなまる)  えだまめ(いきなまる)  埼玉県 
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
16685543  AG04000166 04  51366 710  99533  32600  春菊  しゅんぎく  埼玉県 
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
16685542  AG04000166 04  51366 710  99533  43000  新高梨  にいたかなし  埼玉県 
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
16685541  AG04000166 04  51366 710  99533  43000  新興梨  しんこうなし  埼玉県 
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
16685540  AG04000166 04  51366 710  99533  37200  新生姜  しんしょうが  埼玉県 
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
16685539  AG04000166 04  51366 710  99533  36700  新にんにく  しんにんにく  埼玉県 
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
16685538  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
16685537  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
16685536  AG04000166 04  51366 710  99533  43000  幸水梨  こうすいなし  埼玉県 
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
16685535  AG04000166 04  51366 710  99533  35100  平さやいんげん  ひらさやいんげん  埼玉県 
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
16685534  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
16685533  AG04000166 04  51366 710  99533  45000  巨峰  きょほう  埼玉県 
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
16685532  AG04000166 04  51366 710  99533  31900  岩槻ネギ  いわつきねぎ  埼玉県 
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
16685531  AG04000166 04  51366 710  99533  31100  山東菜  さんとうさい  埼玉県 
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 104 of 15485, showing 20 records out of 309681 total, starting on record 2061, ending on 2080

(default) 2 queries took 943 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 2060, 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 = 111929