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
8992  AG02000014 02  2644 51  183  90003  キヌサヤ  きぬさや  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579183  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8993  AG02000014 02  2646 51  187  34600  シシトウ  ししとう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579187  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8994  AG02000014 02  2647 51  188  34270  ズッキーニ  ずっきーに  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579188  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8995  AG02000014 02  2648 51  190  31320  みぶな  みぶな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579190  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8996  AG02000014 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579193  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8997  AG02000014 02  2651 51  198  30300  金時ニンジン  きんときにんじん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579198  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8998  AG02000014 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579199  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8999  AG02000014 02  2671 51  503  32600  春菊  しゅんぎく  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579503  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9000  AG02000014 02  2672 51  508  30910  ラディッシュ  らでぃっしゅ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579508  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9001  AG02000014 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579519  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9002  AG02000014 02  2678 51  539  39200  梅  うめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579539  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9003  AG02000014 02  2681 51  549  37560  大葉  おおば  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579549  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9004  AG02000014 02  2683 51  559  90002  からし菜  からしな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579559  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9005  AG02000014 02  2686 51  573  37300  とうがらし  とうがらし  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579573  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9006  AG02000014 02  2689 51  585  90001  コールラビ  こーるらぴ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579585  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9007  AG02000014 02  2690 51  589  33600  パセリ  ぱせり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579589  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9008  AG02000014 02  2692 51  597  90002  アイスプラント  あいすぷらんと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579597  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9009  AG02000014 02  2693 51  701  37300  伏見甘長唐辛子  ふしみあまながとうがらし  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579701  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9010  AG02000014 02  2696 51  707  37710  バジル  ばじる  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579707  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9011  AG02000014 02  2697 51  708  90001  ビーツ  びーつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579708  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete

Page 80 of 15485, showing 20 records out of 309681 total, starting on record 1581, ending on 1600

(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 ORDER BY `FarmerProduct`.`id` asc LIMIT 1580, 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 = 111906