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
8632  AG02000001 02  2676 51  531  32300  ふきのとう  ふきのとう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565531  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8633  AG02000001 02  2677 51  532  32300  ふき  ふき  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565532  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8634  AG02000001 02  2679 51  542  38100  菌床生椎茸  きんしょうなましいたけ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565542  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8635  AG02000001 02  2680 51  544  38900  山菜  さんさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565544  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8636  AG02000001 02  2681 51  549  37560  大葉  おおば  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565549  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8637  AG02000001 02  2682 51  552  34700  スイートコーン  すいーとこーん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565552  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8638  AG02000001 02  2685 51  572  39510  ギンナン  ぎんなん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565572  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8639  AG02000001 02  2687 51  576  36500  やまいも  やまいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565576  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8640  AG02000001 02  2688 51  577  37412  山椒  さんしょう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565577  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8641  AG02000001 02  2698 51  727  37700  クレソン  くれそん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565727  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8642  AG02000001 02  2700 51  744  39200  青梅  あおうめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565744  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8643  AG02000001 02  2702 51  747  38900  イタドリ  いたどり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565747  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8644  AG02000001 02  2710 51  803  40100  小夏  こなつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565803  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8645  AG02000001 02  2712 51  935  90003  三度豆  さんどまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565935  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8646  AG02000002 02  2602 51  101  34400  トマト  とまと  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566101  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8647  AG02000002 02  2604 51  104  36600  タマネギ  たまねぎ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566104  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8648  AG02000002 02  2605 51  105  36200  ジャガイモ  じゃがいも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566105  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8649  AG02000002 02  2606 51  106  30300  ニンジン  にんじん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566106  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8650  AG02000002 02  2607 51  107  34100  キュウリ  きゅうり  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566107  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8651  AG02000002 02  2608 51  108  31900  ネギ  ねぎ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566108  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 62 of 15485, showing 20 records out of 309681 total, starting on record 1221, ending on 1240

(default) 2 queries took 981 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 ORDER BY `FarmerProduct`.`id` asc LIMIT 1220, 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 = 111973