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
16685490  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
16685489  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
16685488  AG04000166 04  51366 710  99533  37300  万願寺とうがらし  まんがんじとうがらし  埼玉県 
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
16685487  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
16685486  AG04000166 04  51366 710  99533  37700  ローズマリー  ろーずまりー  埼玉県 
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
16685485  AG04000166 04  51366 710  99533  33400  ロメインレタス  ろめいんれたす  埼玉県 
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
16685484  AG04000166 04  51366 710  99533  33200  ロマネスコ  ろまねすこ  埼玉県 
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
16685483  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
16685482  AG04000166 04  51366 710  99533  41410  レモン  れもん  埼玉県 
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
16685481  AG04000166 04  51366 710  99533  33400  レタス  れたす  埼玉県 
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
16685480  AG04000166 04  51366 710  99533  49300  レインボーレッド  れいんぼーれっど  埼玉県 
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
16685479  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
16685478  AG04000166 04  51366 710  99533  90001  ルバーブ  るばーぶ  埼玉県 
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
16685477  AG04000166 04  51366 710  99533  37700  ルッコラ  るっこら  埼玉県 
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
16685476  AG04000166 04  51366 710  99533  33400  リーフレタス  りーふれたす  埼玉県 
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
16685475  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
16685474  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
16685473  AG04000166 04  51366 710  99533  34700  ヤングコーン  やんぐこーん  埼玉県 
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
16685472  AG04000166 04  51366 710  99533  39630  モロヘイヤ  もろへいや  埼玉県 
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
16685471  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 107 of 15485, showing 20 records out of 309681 total, starting on record 2121, ending on 2140

(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 2120, 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