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
104959  AG01000335 01  6528 004  499621  43900  びわ  びわ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104961  AG01000335 01  6528 004  499621  44000  桃  もも  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104960  AG01000335 01  6528 004  499621  44500  プラム  ぷらむ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104963  AG01000335 01  6528 004  499621  45000  ぶどう  ぶどう  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104962  AG01000335 01  6528 004  499621  45800  いちじく  いちじく  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104956  AG01000335 01  6528 004  499621  46000  いちご  いちご  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104957  AG01000335 01  6528 004  499621  47000  メロン  めろん  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104958  AG01000335 01  6528 004  499621  48000  すいか  すいか  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104953  AG01000335 01  6528 004  499621  49300  キウイ  きうい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
67458  AG01000335 01  6528 004  499621  90007  果実  かじつ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2018-06-28 00:00:00    2018-06-28 15:12:38  MG00000001  2018-06-28 15:12:38  MG00000001  View Edit Delete
104955  AG01000335 01  6528 004  499621  90008  柑橘類  かんきつるい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
1739830  AG01000335 01  39038 031  800301  90000  農産物01  のうさんぶつ01  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800301  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739831  AG01000335 01  39039 031  800302  90000  農産物02  のうさんぶつ02  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800302  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739832  AG01000335 01  39040 031  800303  90000  農産物03  のうさんぶつ03  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800303  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739833  AG01000335 01  39041 031  800304  90000  農産物04  のうさんぶつ04  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800304  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739834  AG01000335 01  39042 031  800305  90000  農産物05  のうさんぶつ05  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800305  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739835  AG01000335 01  39043 031  800306  90000  農産物06  のうさんぶつ06  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800306  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739836  AG01000335 01  39044 031  800307  90000  農産物07  のうさんぶつ07  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800307  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739837  AG01000335 01  39045 031  800308  90000  農産物08  のうさんぶつ08  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800308  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1739838  AG01000335 01  39046 031  800309  90000  農産物09  のうさんぶつ09  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17800309  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete

Page 6 of 15485, showing 20 records out of 309681 total, starting on record 101, ending on 120

(default) 2 queries took 966 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`.`farmer_id` asc LIMIT 100, 2020202
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 = 111964