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
11145  AG01000723 01  6442 004  398721  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398721  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11162  AG01000900 01  6436 004  398709  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398709  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11163  AG01000901 01  1029 003  91  91000  ニンニクみそ  にんにくみそ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17570791  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11164  AG01000901 01  1029 003  91  91000  ふきみそ  ふきみそ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17578391  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11165  AG01000901 01  1029 003  91  91000  梅みそ  うめみ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17563091  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 15:03:36  AG01000901  View Edit Delete
11169  AG01000955 01  6455 004  398976  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398976  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11193  AG01000986 01  6415 004  343211  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343211  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11210  AG01001028 01  6492 004  499262  90007  果物  くだもの  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499262  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11215  AG01001043 01  6417 004  343257  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343257  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11228  AG01001107 01  6422 004  343332  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343332  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11236  AG01001168 01  6424 004  343394  33420  グリーンリーフ  ぐりーんりーふ  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343394  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2020-07-06 18:07:06  AG01001168  View Edit Delete
11241  AG01001183 01  6425 004  343410  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343410  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11244  AG01001224 01  1028 003  86  90007  果物  くだもの  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17505686  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
11249  AG01002649 01  6501 004  343500  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343500  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-08-01 19:18:18  MG00000001  View Edit Delete
11283  AG02000041 02  2602 51  101  34400  トマト  とまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26696101  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete
11284  AG02000041 02  2612 51  116  35100  インゲン豆  いんげんまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26696116  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete
11285  AG02000041 02  2615 51  119  34500  ピーマン  ぴーまん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26696119  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete
11286  AG02000041 02  2644 51  183  35200  キヌサヤ  きぬさや  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26696183  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete
11287  AG02000041 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26696519  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete
11288  AG02000042 02  2602 51  101  34400  トマト  とまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26695101  12  2017-08-02 00:00:00    2017-08-02 00:00:00  MG00000001  2017-08-02 00:00:00  MG00000001  View Edit Delete

Page 95 of 15485, showing 20 records out of 309681 total, starting on record 1881, ending on 1900

(default) 2 queries took 962 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 1880, 20202011
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 = 111951