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
8772  AG02000004 02  2602 51  101  34400  トマト  とまと  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568101  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8773  AG02000004 02  2604 51  104  36600  タマネギ  たまねぎ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568104  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8774  AG02000004 02  2605 51  105  36200  ジャガイモ  じゃがいも  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568105  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8775  AG02000004 02  2606 51  106  30300  ニンジン  にんじん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568106  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8776  AG02000004 02  2607 51  107  34100  キュウリ  きゅうり  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568107  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8777  AG02000004 02  2608 51  108  31900  ネギ  ねぎ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568108  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8778  AG02000004 02  2609 51  111  36100  サツマイモ  さつまいも  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568111  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8779  AG02000004 02  2610 51  112  34300  ナス  なす  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8780  AG02000004 02  2611 51  114  34200  カボチャ  かぼちゃ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568114  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8781  AG02000004 02  2613 51  117  35500  枝豆  えだまめ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568117  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8782  AG02000004 02  2614 51  118  33400  レタス  れたす  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568118  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8783  AG02000004 02  2615 51  119  34500  ピーマン  ぴーまん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568119  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8784  AG02000004 02  2616 51  120  34800  オクラ  おくら  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568120  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8785  AG02000004 02  2619 51  129  31500  小松菜  こまつな  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568129  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8786  AG02000004 02  2620 51  133  30400  ゴボウ  ごぼう  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568133  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8787  AG02000004 02  2622 51  138  36300  里芋  さといも  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568138  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8788  AG02000004 02  2623 51  139  32100  ワケギ  わけぎ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568139  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8789  AG02000004 02  2624 51  145  32900  セロリー  せろりー  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568145  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8790  AG02000004 02  2626 51  149  31700  キャベツ  きゃべつ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568149  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8791  AG02000004 02  2629 51  152  32800  ニラ  にら  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568152  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 69 of 15485, showing 20 records out of 309681 total, starting on record 1361, ending on 1380

(default) 2 queries took 985 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 1360, 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 = 111976