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
8672  AG02000002 02  2638 51  170  33200  カリフラワー  かりふらわー  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566170  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8673  AG02000002 02  2641 51  178  41410  レモン  れもん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566178  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8674  AG02000002 02  2642 51  179  39330  すだち  すだち  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566179  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8675  AG02000002 02  2644 51  183  90003  キヌサヤ  きぬさや  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566183  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8676  AG02000002 02  2646 51  187  34600  シシトウ  ししとう  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566187  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8677  AG02000002 02  2650 51  193  30100  大根  だいこん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566193  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8678  AG02000002 02  2652 51  199  90001  野菜(その他)  やさいそのた  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566199  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8679  AG02000002 02  2653 51  204  47000  メロン  めろん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566204  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8680  AG02000002 02  2654 51  216  45000  ぶどう  ぶどう  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566216  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8681  AG02000002 02  2655 51  217  44000  桃  もも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566217  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8682  AG02000002 02  2656 51  218  48000  スイカ  すいか  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566218  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8683  AG02000002 02  2657 51  219  45700  栗  くり  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566219  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8684  AG02000002 02  2658 51  220  40100  ミカン  みかん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566220  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8685  AG02000002 02  2659 51  222  43500  柿  かき  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566222  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8686  AG02000002 02  2660 51  223  46000  いちご  いちご  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566223  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8687  AG02000002 02  2661 51  224  43900  びわ  びわ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566224  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8688  AG02000002 02  2662 51  225  41260  甘夏  あまなつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566225  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8689  AG02000002 02  2663 51  227  41390  ポンカン  ぽんかん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566227  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8690  AG02000002 02  2664 51  228  41320  ハッサク  はっさく  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566228  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8691  AG02000002 02  2665 51  229  90008  文旦  ぶんたん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566229  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 64 of 15485, showing 20 records out of 309681 total, starting on record 1261, ending on 1280

(default) 2 queries took 924 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 1260, 2020208
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 = 111916