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
8692  AG02000002 02  2666 51  230  40100  しらぬい  しらぬい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566230  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8693  AG02000002 02  2667 51  252  43000  梨  なし  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566252  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8694  AG02000002 02  2668 51  264  49540  ブルーベリー  ぶるーべりー  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566264  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8695  AG02000002 02  2669 51  272  49300  キウイ  きうい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566272  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8696  AG02000002 02  2670 51  299  90007  果物(その他)  くだものそのた  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566299  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8697  AG02000002 02  2671 51  503  32600  春菊  しゅんぎく  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566503  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8698  AG02000002 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566519  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8699  AG02000002 02  2675 51  530  38100  原木生椎茸  げんぼくなましいたけ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566530  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8700  AG02000002 02  2677 51  532  32300  ふき  ふき  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566532  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8701  AG02000002 02  2679 51  542  38100  菌床生椎茸  きんしょうなましいたけ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566542  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8702  AG02000002 02  2681 51  549  37560  大葉  おおば  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566549  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8703  AG02000002 02  2682 51  552  34700  スイートコーン  すいーとこーん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566552  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8704  AG02000002 02  2687 51  576  36500  やまいも  やまいも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566576  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8705  AG02000002 02  2698 51  727  37700  クレソン  くれそん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566727  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8706  AG02000002 02  2710 51  803  40100  小夏  こなつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566803  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8707  AG02000002 02  2712 51  935  90003  三度豆  さんどまめ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566935  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8708  AG02000003 02  2602 51  101  34400  トマト  とまと  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567101  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8709  AG02000003 02  2604 51  104  36600  タマネギ  たまねぎ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567104  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8710  AG02000003 02  2605 51  105  36200  ジャガイモ  じゃがいも  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567105  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8711  AG02000003 02  2606 51  106  30300  ニンジン  にんじん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567106  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 65 of 15485, showing 20 records out of 309681 total, starting on record 1281, ending on 1300

(default) 2 queries took 915 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 1280, 2020208
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 = 111907