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
8732  AG02000003 02  2636 51  168  90002  大根菜  だいこんな  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567168  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8733  AG02000003 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567169  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8734  AG02000003 02  2638 51  170  33200  カリフラワー  かりふらわー  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567170  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8735  AG02000003 02  2641 51  178  41410  レモン  れもん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567178  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8736  AG02000003 02  2642 51  179  39330  すだち  すだち  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567179  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8737  AG02000003 02  2644 51  183  90003  キヌサヤ  きぬさや  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567183  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8738  AG02000003 02  2646 51  187  34600  シシトウ  ししとう  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567187  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8739  AG02000003 02  2650 51  193  30100  大根  だいこん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567193  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8740  AG02000003 02  2652 51  199  90001  野菜(その他)  やさいそのた  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567199  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8741  AG02000003 02  2653 51  204  47000  メロン  めろん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567204  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8742  AG02000003 02  2654 51  216  45000  ぶどう  ぶどう  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567216  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8743  AG02000003 02  2655 51  217  44000  桃  もも  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567217  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8744  AG02000003 02  2656 51  218  48000  スイカ  すいか  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567218  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8745  AG02000003 02  2657 51  219  45700  栗  くり  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567219  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8746  AG02000003 02  2658 51  220  40100  ミカン  みかん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567220  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8747  AG02000003 02  2659 51  222  43500  柿  かき  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567222  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8748  AG02000003 02  2660 51  223  46000  いちご  いちご  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567223  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8749  AG02000003 02  2661 51  224  43900  びわ  びわ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567224  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8750  AG02000003 02  2662 51  225  41260  甘夏  あまなつ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567225  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8751  AG02000003 02  2663 51  227  41390  ポンカン  ぽんかん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567227  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 67 of 15485, showing 20 records out of 309681 total, starting on record 1321, ending on 1340

(default) 2 queries took 920 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 1320, 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 = 111912