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
61434  AG02100055 02  5387 53  17  90008  河内晩柑  かわちばんかん  愛媛県松山市石手5丁目3-2                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535717  12  2018-05-25 00:00:00    2018-05-25 15:22:44  MG00000001  2018-05-25 15:22:44  MG00000001  View Edit Delete
61435  AG02100055 02  5389 53  19  41410  レモン  れもん  愛媛県松山市石手5丁目3-2                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535719  12  2018-05-25 00:00:00    2018-05-25 15:23:05  MG00000001  2018-05-25 15:23:05  MG00000001  View Edit Delete
61436  AG01003325 01  6506 004  343268  34100  きゅうり  きゅうり  和歌山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343268  12  2018-05-26 00:00:00    2018-05-26 06:45:14  AG01003325  2018-05-26 06:52:57  AG01003325  View Edit Delete
61437  AG01003303 01  5110 011  60617  90008  河内晩柑  かわちばんかん  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760617  12  2018-05-27 00:00:00    2018-05-27 17:37:48  AG01003303  2018-05-27 17:37:48  AG01003303  View Edit Delete
61446  AG02000099 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26382199  12  2018-05-28 00:00:00    2018-05-28 15:15:10  MG00000001  2022-02-09 14:22:08  MG00000001  View Edit Delete
61454  AG02000099 02  2635 51  167  34460  ミニトマト  みにとまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26382167  12  2018-05-28 00:00:00    2018-05-28 15:58:33  MG00000001  2022-02-09 14:26:45  MG00000001  View Edit Delete
61457  AG01003299 01  5104 011  60611  90003  いんげん豆  いんげんまめ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-28 00:00:00    2018-05-28 16:56:40  AG01003299  2018-05-28 16:56:40  AG01003299  View Edit Delete
61458  AG01003299 01  5104 011  60611  90003  ジャンボインゲン豆  じゃんぼいんげんまめ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-28 00:00:00    2018-05-28 16:57:59  AG01003299  2018-05-28 16:57:59  AG01003299  View Edit Delete
61459  AG01003299 01  5104 011  60611  39200  南高梅  なんこううめ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-28 00:00:00    2018-05-28 16:59:01  AG01003299  2018-05-28 16:59:01  AG01003299  View Edit Delete
61460  AG01003299 01  5104 011  60611  34500  ワンダーピーマン  わんだーぴまん  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-28 00:00:00    2018-05-28 17:03:05  AG01003299  2018-05-28 17:03:05  AG01003299  View Edit Delete
61461  AG01003271 01  5093 011  60600  31100  白菜  はくさい  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760600  12  2018-05-29 00:00:00    2018-05-29 08:13:19  AG01003271  2018-05-29 08:13:19  AG01003271  View Edit Delete
61478  AG02000100 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26383199  12  2018-05-29 00:00:00    2018-05-29 10:55:04  MG00000001  2018-05-29 10:55:04  MG00000001  View Edit Delete
61479  AG02000100 02  2635 51  167  34460  ミニトマト  みにとまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26383167  12  2018-05-29 00:00:00    2018-05-29 10:55:27  MG00000001  2018-05-29 10:55:27  MG00000001  View Edit Delete
61594  AG02000093 02  6237 52  1893  30200  かぶら  かぶら  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61595  AG02000093 02  6237 52  1893  34100  きゅうり  きゅうり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61596  AG02000093 02  6237 52  1893  36200  じゃがいも  じゃがいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61597  AG02000093 02  6237 52  1893  34300  なす  なす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61598  AG02000093 02  6237 52  1893  36700  にんにく  にんにく  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61599  AG02000093 02  6237 52  1893  31900  ねぎ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete
61600  AG02000093 02  6237 52  1893  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791893  12  2018-05-31 00:00:00    2018-05-31 14:24:14  MG00000001  2018-05-31 14:24:14  MG00000001  View Edit Delete

Page 344 of 15485, showing 20 records out of 309681 total, starting on record 6861, ending on 6880

(default) 2 queries took 996 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 6860, 20202037
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 = 111959