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
63151  AG09000001 09  6249 101  38002  91007  餅  もち  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63152  AG09000001 09  6249 101  38002  91008  菓子  かし  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63153  AG09000001 09  6249 101  38002  91009  たまご  たまご  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238002  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63154  AG09000004 09  6252 101  38006  34400  トマト  とまと  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63155  AG09000004 09  6252 101  38006  34460  ミニトマト  みにとまと  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63156  AG09000004 09  6252 101  38006  34100  きゅうり  きゅうり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63157  AG09000004 09  6252 101  38006  34200  南瓜  かぼちゃ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63158  AG09000004 09  6252 101  38006  34500  ピーマン  ぴーまん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63159  AG09000004 09  6252 101  38006  34600  ししとう  ししとう  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63160  AG09000004 09  6252 101  38006  37300  万願寺唐辛子  まんがんじとうがらし  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63161  AG09000004 09  6252 101  38006  37300  たかのつめ  たかのつめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63162  AG09000004 09  6252 101  38006  34270  ズッキーニ  ずっきーに  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63163  AG09000004 09  6252 101  38006  34910  とうがん  とうがん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63164  AG09000004 09  6252 101  38006  34300  なす  なす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63165  AG09000004 09  6252 101  38006  35100  いんげん  いんげん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63166  AG09000004 09  6252 101  38006  35200  えんどう豆  えんどうまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63167  AG09000004 09  6252 101  38006  90003  一寸豆  いっすんまめ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63168  AG09000004 09  6252 101  38006  31800  ほうれん草  ほうれんそう  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63169  AG09000004 09  6252 101  38006  31500  小松菜  こまつな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63170  AG09000004 09  6252 101  38006  31310  水菜  みずな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete

Page 365 of 15485, showing 20 records out of 309681 total, starting on record 7281, ending on 7300

(default) 2 queries took 1053 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` asc LIMIT 7280, 20202042
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 = 1111011