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
56641  AG03000028 03  6053 61  06  34460  ミニトマト  みにとまと  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252506  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56642  AG03000028 03  6054 61  07  36700  生にんにく  なまにんにく  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252507  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56643  AG03000028 03  6055 61  08  36700  乾燥にんにく 200g  かんそうにんにくにひゃくぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252508  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56644  AG03000028 03  6056 61  09  36700  乾燥にんにく 500g  かんそうにんにくごひゃくぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252509  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56645  AG03000028 03  6057 61  10  36700  乾燥にんにく 1kg  かんそうにんにくいちきろ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252510  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56646  AG03000028 03  6058 61  11  36700  黒にんにく L  くろにんにくえる  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252511  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56647  AG03000028 03  6059 61  12  36700  黒にんにく M  くろにんにくえむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252512  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2022-06-19 19:19:35  AG03000028  View Edit Delete
56648  AG03000028 03  6060 61  13  36700  黒にんにく バラ 150g  くろにんにくばらひゃくごじゅうぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252513  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56649  AG03000028 03  6061 61  14  36700  黒にんにく S  くろにんにくえす  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252514  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56650  AG03000028 03  6062 61  15  36700  黒にんにく  くろにんにく  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252515  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56651  AG03000028 03  6063 61  16  36700  にんにくの芽  にんにくのめ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252516  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56652  AG03000028 03  6064 61  17  36700  生にんにく 100g  なまにんにくひゃくぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252517  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56653  AG03000028 03  6065 61  18  36700  生にんにく 200g  なまにんにくにひゃくぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252518  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56654  AG03000028 03  6066 61  19  36700  生にんにく 500g  なまにんにくごひゃくぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252519  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56655  AG03000028 03  6067 61  20  36700  生にんにく 150g  なまにんにくひゃくごじゅうぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252520  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56656  AG03000028 03  6068 61  21  36700  生にんにく 1kg  なまにんにくいちきろ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252521  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56657  AG03000028 03  6069 61  22  36700  生にんにく 250g  なまにんにくにひゃくごじゅうぐらむ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252522  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56658  AG03000030 03  6047 61  00  91009  烏骨鶏有精卵  うこっけいゆうせいらん  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252600  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56659  AG03000030 03  6048 61  01  91009  鶏卵  にわとりたまご  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252601  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete
56660  AG03000030 03  6049 61  02  35200  えんどう  えんどう  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0252602  12  2018-03-22 00:00:00    2018-03-22 13:04:44  MG00000001  2018-03-22 13:04:44  MG00000001  View Edit Delete

Page 303 of 15485, showing 20 records out of 309681 total, starting on record 6041, ending on 6060

(default) 2 queries took 1013 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 6040, 20202045
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 = 111968