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
8569  AG01001569 01  2454 006  7010  33410  サニーレタス  さにーれたす  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:56:08  MG00000001  2017-02-24 18:56:08  MG00000001  View Edit Delete
8570  AG01001569 01  2454 006  7010  33950  芽キャベツ  めきゃべつ  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:56:53  MG00000001  2017-02-24 18:56:53  MG00000001  View Edit Delete
8571  AG01001569 01  2454 006  7010  34100  きゅうり  きゅうり  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:57:25  MG00000001  2017-02-24 18:57:25  MG00000001  View Edit Delete
8572  AG01001569 01  2454 006  7010  35100  インゲン  いんげん  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:58:02  MG00000001  2017-02-24 18:58:02  MG00000001  View Edit Delete
8573  AG01001569 01  2454 006  7010  35200  スナップえんどう  すなっぷえんどう  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:58:41  MG00000001  2017-02-24 18:58:41  MG00000001  View Edit Delete
8577  AG02000001 02  2602 51  101  34400  トマト  とまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565101  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8578  AG02000001 02  2604 51  104  36600  タマネギ  たまねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565104  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8579  AG02000001 02  2605 51  105  36200  ジャガイモ  じゃがいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565105  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8580  AG02000001 02  2606 51  106  30300  ニンジン  にんじん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565106  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8581  AG02000001 02  2607 51  107  34100  キュウリ  きゅうり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565107  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8582  AG02000001 02  2608 51  108  31900  ネギ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565108  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8583  AG02000001 02  2609 51  111  36100  サツマイモ  さつまいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565111  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8584  AG02000001 02  2610 51  112  34300  ナス  なす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8585  AG02000001 02  2611 51  114  34200  カボチャ  かぼちゃ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565114  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8586  AG02000001 02  2613 51  117  35500  枝豆  えだまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565117  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8587  AG02000001 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565118  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8588  AG02000001 02  2615 51  119  34500  ピーマン  ぴーまん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565119  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8589  AG02000001 02  2616 51  120  34800  オクラ  おくら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565120  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8590  AG02000001 02  2619 51  129  31500  小松菜  こまつな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565129  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8591  AG02000001 02  2620 51  133  30400  ゴボウ  ごぼう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565133  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 59 of 15485, showing 20 records out of 309681 total, starting on record 1161, ending on 1180

(default) 2 queries took 927 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 1160, 2020207
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 = 111920