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
8752  AG02000003 02  2664 51  228  41320  ハッサク  はっさく  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567228  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8753  AG02000003 02  2665 51  229  90008  文旦  ぶんたん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567229  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8754  AG02000003 02  2666 51  230  40100  しらぬい  しらぬい  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567230  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8755  AG02000003 02  2667 51  252  43000  梨  なし  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567252  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8756  AG02000003 02  2668 51  264  49540  ブルーベリー  ぶるーべりー  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567264  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8757  AG02000003 02  2669 51  272  49300  キウイ  きうい  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567272  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8758  AG02000003 02  2670 51  299  90007  果物(その他)  くだものそのた  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567299  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8759  AG02000003 02  2671 51  503  32600  春菊  しゅんぎく  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567503  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8760  AG02000003 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567519  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8761  AG02000003 02  2675 51  530  38100  原木生椎茸  げんぼくなましいたけ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567530  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8762  AG02000003 02  2677 51  532  32300  ふき  ふき  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567532  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8763  AG02000003 02  2679 51  542  38100  菌床生椎茸  きんしょうなましいたけ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567542  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8764  AG02000003 02  2681 51  549  37560  大葉  おおば  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567549  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8765  AG02000003 02  2682 51  552  34700  スイートコーン  すいーとこーん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567552  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8766  AG02000003 02  2686 51  573  37300  とうがらし  とうがらし  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567573  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8767  AG02000003 02  2687 51  576  36500  やまいも  やまいも  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567576  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8768  AG02000003 02  2691 51  595  34300  三豊ナス  みとよなす  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567595  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8769  AG02000003 02  2698 51  727  37700  クレソン  くれそん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567727  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8770  AG02000003 02  2710 51  803  40100  小夏  こなつ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567803  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8771  AG02000003 02  2712 51  935  90003  三度豆  さんどまめ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567935  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 68 of 15485, showing 20 records out of 309681 total, starting on record 1341, ending on 1360

(default) 2 queries took 939 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 1340, 2020209
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 = 111930