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
16685909  AG08000071 08  6821 96  165  34400  とまと(王様種)  とまとおうさましゅ  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160165  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685908  AG08000071 08  6820 96  164  34400  とまと(桃太郎)  とまとももたろう  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160164  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685907  AG08000071 08  6819 96  163  34400  トマト  とまと  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160163  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685906  AG08000071 08  6818 96  162  34300  彩りなす  いろどりなす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160162  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685905  AG08000071 08  6817 96  161  34300  水ナス  みずなす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160161  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685904  AG08000071 08  6816 96  160  34300  米なす  べいなす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160160  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685903  AG08000071 08  6815 96  159  34300  長なす  ながなす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160159  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685902  AG08000071 08  6814 96  158  34300  なす  なす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160158  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685901  AG08000071 08  6813 96  157  34200  コリンキー  こりんきー  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160157  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685900  AG08000071 08  6812 96  156  34200  バターナッツカボチャ  ばたーなっつかぼちゃ  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160156  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685899  AG08000071 08  6811 96  155  34200  カボチャ(えびす)  かぼちゃえびす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160155  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685898  AG08000071 08  6810 96  154  34200  カボチャ(栗五郎)  かぼちゃくりごろう  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160154  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685897  AG08000071 08  6809 96  153  34200  カボチャ(九重栗)  かぼちゃここのえくり  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160153  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685896  AG08000071 08  6808 96  152  34200  南瓜  かぼちゃ  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160152  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685895  AG08000071 08  6807 96  151  34100  きゅうり  きゅうり  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160151  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685894  AG08000071 08  6806 96  119  33300  スティックセニョール  すてぃっくせにょーる  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160119  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685893  AG08000071 08  6805 96  118  31700  プチベール  ぷちべーる  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160118  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685892  AG08000071 08  6804 96  117  37700  レモングラス  れもんぐらす  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160117  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685891  AG08000071 08  6803 96  116  37710  バジル(スィート)  ばじるすぃーと  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160116  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete
16685890  AG08000071 08  6802 96  115  37710  バジル(ホーリー)  ばじるほーりー  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20160115  12  2018-09-26 00:00:00    2018-09-26 15:11:00  MG00000001  2018-09-26 15:11:00  MG00000001  View Edit Delete

Page 90 of 15485, showing 20 records out of 309681 total, starting on record 1781, ending on 1800

(default) 2 queries took 925 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` desc LIMIT 1780, 20202012
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 = 111913