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
63231  AG09000004 09  6252 101  38006  44500  プラム  ぷらむ  香川県 
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
63232  AG09000004 09  6252 101  38006  44000  桃  もも  香川県 
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
63233  AG09000004 09  6252 101  38006  45800  いちじく  いちじく  香川県 
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
63234  AG09000004 09  6252 101  38006  45000  ぶどう  ぶどう  香川県 
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
63235  AG09000004 09  6252 101  38006  43000  梨  なし  香川県 
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
63236  AG09000004 09  6252 101  38006  43500  柿  かき  香川県 
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
63237  AG09000004 09  6252 101  38006  45700  栗  くり  香川県 
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
63238  AG09000004 09  6252 101  38006  90001  野菜  やさい  香川県 
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
63239  AG09000004 09  6252 101  38006  90007  果物  くだもの  香川県 
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
63240  AG09000004 09  6252 101  38006  91011  フラワー  ふらわー  香川県 
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
63241  AG09000004 09  6252 101  38006  99998  虫・魚  むしさかな  香川県 
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
63242  AG09000004 09  6252 101  38006  91010  お米  おこめ  香川県 
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
63243  AG09000004 09  6252 101  38006  43500  干し柿  ほしがき  香川県 
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
63244  AG09000004 09  6252 101  38006  91000  加工品  かこうひん  香川県 
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
63245  AG09000004 09  6252 101  38006  91002  雑貨  ざっか  香川県 
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
63246  AG09000004 09  6252 101  38006  91003  豆腐  とうふ  香川県 
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
63247  AG09000004 09  6252 101  38006  91004  あげ  あげ  香川県 
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
63248  AG09000004 09  6252 101  38006  91005  お茶  おちゃ  香川県 
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
63249  AG09000004 09  6252 101  38006  91006  漬物  つけもの  香川県 
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
63250  AG09000004 09  6252 101  38006  91007  餅  もち  香川県 
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 369 of 15485, showing 20 records out of 309681 total, starting on record 7361, ending on 7380

(default) 2 queries took 1011 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 7360, 20202041
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 = 111970