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
16686589  AG04000167 04  51461 710  99545  30100  大根菜  だいこんな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686588  AG04000167 04  51461 710  99545  36500  大和芋  やまといも  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686587  AG04000167 04  51461 710  99545  34950  夕顔  ゆうがお  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686586  AG04000167 04  51461 710  99545  90008  夏みかん  なつみかん  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686585  AG04000167 04  51461 710  99545  34200  坊ちゃん南瓜  ぼっちゃんかぼちゃ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686584  AG04000167 04  51461 710  99545  34100  四葉きゅうり  よつばきゅうり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686583  AG04000167 04  51461 710  99545  34100  四川きゅうり  しせんきゅうり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686582  AG04000167 04  51461 710  99545  90002  味美菜  あじみな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686581  AG04000167 04  51461 710  99545  38600  原木栽培生しいたけ  げんぼくなましいたけ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686580  AG04000167 04  51461 710  99545  39200  南高梅  なんこうばい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686579  AG04000167 04  51461 710  99545  43000  南水梨  なんすいなし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686578  AG04000167 04  51461 710  99545  34300  千両なす  せんりょうなす  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686577  AG04000167 04  51461 710  99545  45700  利平栗  りへいぐり  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686576  AG04000167 04  51461 710  99545  30100  切干  きりぼし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686575  AG04000167 04  51461 710  99545  32500  切みつば  きりみつば  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686574  AG04000167 04  51461 710  99545  37300  内藤とうがらし  ないとうとうがらし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686573  AG04000167 04  51461 710  99545  36300  八ツ頭  やつがしら  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686572  AG04000167 04  51461 710  99545  36300  八っ子  やつっこ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686571  AG04000167 04  51461 710  99545  31420  児菜(子持ち高菜)  あーさい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete
16686570  AG04000167 04  51461 710  99545  37300  伏見とうがらし  ふしみとうがらし  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399545  12  2024-01-15 00:00:00    2024-01-15 15:28:12  MG00000001  2024-01-15 15:28:12  MG00000001  View Edit Delete

Page 56 of 15485, showing 20 records out of 309681 total, starting on record 1101, ending on 1120

(default) 2 queries took 950 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 1100, 2020208
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 = 111942