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
9012  AG02000014 02  2703 51  759  90002  スイスチャード  すいすちゃーど  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579759  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9013  AG02000014 02  2705 51  775  31420  高菜  たかな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579775  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9014  AG02000014 02  2706 51  777  30400  サラダごぼう  さらだごぼう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579777  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9015  AG02000014 02  2707 51  783  37700  ローズマリー  ろーずまりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579783  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9016  AG02000014 02  2708 51  786  32700  フェンネル  ふぇんねる  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579786  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9017  AG02000014 02  2709 51  795  33200  カリフローレ  かりふろーれ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579795  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9018  AG02000014 02  2711 51  897  90002  葉物  はもの  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579897  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9019  AG02000014 02  2713 51  962  33710  パクチー  ぱくちー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26579962  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9020  AG02000015 02  2607 51  107  34100  キュウリ  きゅうり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26580107  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9021  AG02000016 02  2610 51  112  34300  ナス  なす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9022  AG02000016 02  2622 51  138  36300  里芋  さといも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581138  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9023  AG02000016 02  2645 51  184  33920  菜花  なのはな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581184  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9024  AG02000016 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581193  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9025  AG02000024 02  2610 51  112  34300  ナス  なす  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26590112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9026  AG02000028 02  2608 51  108  31900  ネギ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26594108  12  2017-02-27 00:00:00      MG00000001  2017-07-11 15:31:33  MG00000001  View Edit Delete
9027  AG02000028 02  2645 51  184  33920  菜花  なのはな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26594184  12  2017-02-27 00:00:00    2017-02-28 10:13:07  MG00000000  2017-07-11 14:56:37  AG02000028  View Edit Delete
9028  AG02000028 02  2694 51  702  90002  ケール  けーる  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26594702  12  2017-02-27 00:00:00      MG00000001  2017-07-11 15:14:59  MG00000001  View Edit Delete
9029  AG02000028 02  2711 51  897  90002  葉物  はもの  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26594897  12  2017-02-27 00:00:00      MG00000001  2017-07-11 15:26:45  MG00000001  View Edit Delete
9030  AG02000029 02  2605 51  105  36200  ジャガイモ  じゃがいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26595105  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9031  AG02000029 02  2606 51  106  30300  ニンジン  にんじん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26595106  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 81 of 15485, showing 20 records out of 309681 total, starting on record 1601, ending on 1620

(default) 2 queries took 918 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 1600, 20202010
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 = 111908