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
8932  AG02000008 02  2613 51  117  35500  枝豆  えだまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26573117  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8933  AG02000008 02  2622 51  138  36300  里芋  さといも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26573138  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8934  AG02000008 02  2632 51  160  30200  かぶ  かぶ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26573160  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8935  AG02000008 02  2695 51  703  30600  レンコン  れんこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26573703  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8936  AG02000009 02  2602 51  101  34400  トマト  とまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574101  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8937  AG02000009 02  2605 51  105  36200  ジャガイモ  じゃがいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574105  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8938  AG02000009 02  2618 51  128  31310  水菜  みずな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574128  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8939  AG02000009 02  2619 51  129  31500  小松菜  こまつな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574129  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8940  AG02000009 02  2622 51  138  36300  里芋  さといも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574138  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8941  AG02000009 02  2626 51  149  31700  キャベツ  きゃべつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574149  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8942  AG02000009 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574154  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8943  AG02000009 02  2634 51  162  35400  空豆  そらまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574162  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8944  AG02000009 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574169  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8945  AG02000009 02  2638 51  170  33200  カリフラワー  かりふらわー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574170  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8946  AG02000009 02  2640 51  173  90003  豆  まめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574173  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8947  AG02000009 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574519  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8948  AG02000009 02  2690 51  589  33600  パセリ  ぱせり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574589  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8949  AG02000009 02  2703 51  759  90002  スイスチャード  すいすちゃーど  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574759  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8950  AG02000011 02  2695 51  703  30600  レンコン  れんこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26576703  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8951  AG02000012 02  2608 51  108  31900  ネギ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26577108  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete

Page 77 of 15485, showing 20 records out of 309681 total, starting on record 1521, ending on 1540

(default) 2 queries took 982 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 1520, 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 = 111973