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
71759  AG09000056 09  6360 101  38049  34400  トマト  とまと  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71769  AG09000056 09  6360 101  38049  34300  なす  なす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71767  AG09000056 09  6360 101  38049  34270  ズッキーニ  ずっきーに  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71762  AG09000056 09  6360 101  38049  34200  南瓜  かぼちゃ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71761  AG09000056 09  6360 101  38049  34100  きゅうり  きゅうり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71809  AG09000056 09  6360 101  38049  33930  ずいき  ずいき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71776  AG09000056 09  6360 101  38049  33810  チンゲン菜  ちんげんさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71811  AG09000056 09  6360 101  38049  33600  パセリ  ぱせり  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71789  AG09000056 09  6360 101  38049  33420  グリーンリーフ  ぐりーんりーふ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71788  AG09000056 09  6360 101  38049  33410  サニーレタス  さにーれたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71787  AG09000056 09  6360 101  38049  33400  レタス  れたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71784  AG09000056 09  6360 101  38049  33300  ブロッコリー  ぶろっこりー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71785  AG09000056 09  6360 101  38049  33200  カリフラワー  かりふらわー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71786  AG09000056 09  6360 101  38049  33100  アスパラ  あすぱら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71790  AG09000056 09  6360 101  38049  32800  ニラ  にら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71777  AG09000056 09  6360 101  38049  32600  菊菜  きくな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71806  AG09000056 09  6360 101  38049  32400  うど  うど  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71798  AG09000056 09  6360 101  38049  32300  ふき  ふき  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71780  AG09000056 09  6360 101  38049  31910  青ねぎ  あおねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete
71779  AG09000056 09  6360 101  38049  31900  白ねぎ  しろねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238049  12  2018-07-06 00:00:00    2018-07-06 15:06:10  MG00000001  2018-07-06 15:06:10  MG00000001  View Edit Delete

Page 148 of 15485, showing 20 records out of 309681 total, starting on record 2941, ending on 2960

(default) 2 queries took 941 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`.`farmer_id` desc LIMIT 2940, 20202020
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 = 111921