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
5167  AG01001155 01  1044 005  11041  34460  高糖度ミニトマト 1P  こうとうどみにとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211041  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5168  AG01001155 01  1045 005  11051  34400  ミディトマト 1P  みでぃとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211051  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5169  AG01001155 01  1046 005  11061  34400  フルーツトマト 1P  ふるーつとまと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211061  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5170  AG01001155 01  1047 005  11071  34300  ナス 1P  なす1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211071  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5171  AG01001155 01  1048 005  11072  34300  ナス 2P  なす2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211072  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5172  AG01001155 01  1049 005  11073  34300  ナス 3P  なす3  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211073  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5173  AG01001155 01  1050 005  11074  34300  ナス パック  なすぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211074  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5174  AG01001155 01  1051 005  11081  34500  ピーマン 1P  ぴーまん1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211081  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5175  AG01001155 01  1052 005  11091  34570  パプリカ 1P  ぱぷりか1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211091  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5176  AG01001155 01  1053 005  11101  37300  万願寺とうがらし 1P  まんがんじとうがらし1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211101  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5177  AG01001155 01  1054 005  11111  37300  甘長とうがらし 1P  あまながとうがらし1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211111  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5178  AG01001155 01  1055 005  11121  34200  南瓜 1P  かぼちゃ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211121  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5179  AG01001155 01  1056 005  11131  34200  南瓜 1/4カット 1P  かぼちゃかっと1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211131  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5180  AG01001155 01  1057 005  11141  34800  オクラ 1P  おくら1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211141  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5181  AG01001155 01  1058 005  11151  34600  シシトウ 1P  ししとう1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211151  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5182  AG01001155 01  1059 005  11161  34700  とうもろこし 1P  とうもろこし1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211161  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5183  AG01001155 01  1060 005  11162  34700  とうもろこし 2P  とうもろこし2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211162  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5184  AG01001155 01  1061 005  11164  34700  とうもろこし パック  とうもろこしぱっく  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0211164  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5185  AG01001155 01  1062 005  12011  32900  セロリ 1P  せろり1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212011  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete
5186  AG01001155 01  1063 005  12021  33600  パセリ 1P  ぱせり1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212021  12  2016-07-01 00:00:00    2016-08-30 12:26:52  MG00000001  2016-08-30 12:26:52  MG00000001  View Edit Delete

Page 37 of 15485, showing 20 records out of 309681 total, starting on record 721, ending on 740

(default) 2 queries took 914 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 LIMIT 720, 2020205
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 = 111909