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
8812  AG02000004 02  2660 51  223  46000  いちご  いちご  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568223  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8813  AG02000004 02  2661 51  224  43900  びわ  びわ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568224  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8814  AG02000004 02  2662 51  225  41260  甘夏  あまなつ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568225  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8815  AG02000004 02  2663 51  227  41390  ポンカン  ぽんかん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568227  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8816  AG02000004 02  2664 51  228  41320  ハッサク  はっさく  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568228  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8817  AG02000004 02  2665 51  229  90008  文旦  ぶんたん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568229  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8818  AG02000004 02  2666 51  230  40100  しらぬい  しらぬい  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568230  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8819  AG02000004 02  2667 51  252  43000  梨  なし  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568252  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8820  AG02000004 02  2668 51  264  49540  ブルーベリー  ぶるーべりー  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568264  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8821  AG02000004 02  2669 51  272  49300  キウイ  きうい  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568272  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8822  AG02000004 02  2670 51  299  90007  果物(その他)  くだものそのた  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568299  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8823  AG02000004 02  2671 51  503  32600  春菊  しゅんぎく  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568503  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8824  AG02000004 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568519  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8825  AG02000004 02  2675 51  530  38100  原木生椎茸  げんぼくなましいたけ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568530  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8826  AG02000004 02  2677 51  532  32300  ふき  ふき  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568532  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8827  AG02000004 02  2679 51  542  38100  菌床生椎茸  きんしょうなましいたけ  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568542  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8828  AG02000004 02  2681 51  549  37560  大葉  おおば  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568549  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8829  AG02000004 02  2682 51  552  34700  スイートコーン  すいーとこーん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568552  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8830  AG02000004 02  2687 51  576  36500  やまいも  やまいも  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568576  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8831  AG02000004 02  2698 51  727  37700  クレソン  くれそん  002愛媛県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26568727  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 71 of 15485, showing 20 records out of 309681 total, starting on record 1401, ending on 1420

(default) 2 queries took 941 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 1400, 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 = 111932