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
8792  AG02000004 02  2630 51  154  31800  ほうれん草  ほうれんそう  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568154  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8793  AG02000004 02  2631 51  158  33810  チンゲン菜  ちんげんさい  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568158  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8794  AG02000004 02  2633 51  161  31100  白菜  はくさい  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568161  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8795  AG02000004 02  2634 51  162  35400  空豆  そらまめ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568162  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8796  AG02000004 02  2636 51  168  90002  大根菜  だいこんな  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568168  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8797  AG02000004 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568169  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8798  AG02000004 02  2638 51  170  33200  カリフラワー  かりふらわー  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568170  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8799  AG02000004 02  2641 51  178  41410  レモン  れもん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568178  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8800  AG02000004 02  2642 51  179  39330  すだち  すだち  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568179  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8801  AG02000004 02  2644 51  183  90003  キヌサヤ  きぬさや  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568183  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8802  AG02000004 02  2646 51  187  34600  シシトウ  ししとう  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568187  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8803  AG02000004 02  2650 51  193  30100  大根  だいこん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568193  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8804  AG02000004 02  2652 51  199  90001  野菜(その他)  やさいそのた  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568199  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8805  AG02000004 02  2653 51  204  47000  メロン  めろん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568204  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8806  AG02000004 02  2654 51  216  45000  ぶどう  ぶどう  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568216  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8807  AG02000004 02  2655 51  217  44000  桃  もも  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568217  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8808  AG02000004 02  2656 51  218  48000  スイカ  すいか  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568218  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8809  AG02000004 02  2657 51  219  45700  栗  くり  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568219  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8810  AG02000004 02  2658 51  220  40100  ミカン  みかん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568220  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8811  AG02000004 02  2659 51  222  43500  柿  かき  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568222  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 70 of 15485, showing 20 records out of 309681 total, starting on record 1381, ending on 1400

(default) 2 queries took 932 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 1380, 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 = 111923