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
16683237  AG04000164 04  50752 710  99506  91001  農産乾物  のうさんかんぶつ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683236  AG04000164 04  50752 710  99506  31900  軟白ねぎ  なんぱくねぎ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683235  AG04000164 04  50752 710  99506  90005  赤芽芋  あかめいも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683234  AG04000164 04  50752 710  99506  36600  赤玉葱  あかたまねぎ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683233  AG04000164 04  50752 710  99506  31310  赤水菜  あかみずな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683232  AG04000164 04  50752 710  99506  30100  赤大根  あかだいこん  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683231  AG04000164 04  50752 710  99506  31900  赤ねぎ  あかねぎ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683230  AG04000164 04  50752 710  99506  37300  赤とうがらし  あかとうがらし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683229  AG04000164 04  50752 710  99506  37500  赤じそ  あかじそ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683228  AG04000164 04  50752 710  99506  30200  赤かぶ  あかかぶ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683227  AG04000164 04  50752 710  99506  43000  豊水梨  ほうすいなし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683226  AG04000164 04  50752 710  99506  34400  調理用トマト  ちょうりようとまと  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683225  AG04000164 04  50752 710  99506  91001  蜂蜜百花(小)  はちみつひゃっか しょう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683224  AG04000164 04  50752 710  99506  91001  蜂蜜百花(大)  はちみつひゃっか だい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683223  AG04000164 04  50752 710  99506  91001  蜂蜜ヘアリ(小)  はちみつへあり しょう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683222  AG04000164 04  50752 710  99506  91001  蜂蜜ヘアリ(大)  はちみつへあり だい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683221  AG04000164 04  50752 710  99506  91001  蜂蜜アカシア  はちみつあかしあ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683220  AG04000164 04  50752 710  99506  43500  蜂屋柿(渋柿)  はちやがき しぶがき  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683219  AG04000164 04  50752 710  99506  45000  藤稔  ふじみのり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete
16683218  AG04000164 04  50752 710  99506  90002  蕾菜  つぼみな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399506  12  2023-11-16 00:00:00    2023-11-16 14:15:58  MG00000001  2023-11-16 14:15:58  MG00000001  View Edit Delete

Page 211 of 15485, showing 20 records out of 309681 total, starting on record 4201, ending on 4220

(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 4200, 20202027
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 = 111979