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
1733648  AG01000711 01  32856 031  543629  90000  農産物29  のうさんぶつ29  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17543629  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733649  AG01000711 01  32857 031  543630  90000  農産物30  のうさんぶつ30  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17543630  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
6387  AG01000711 01  1487 007  6078  34200  かぼちゃ  かぼちゃ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246078  12  2016-08-29 00:00:00    2016-08-30 12:27:01  MG00000001  2016-08-30 12:27:01  MG00000001  View Edit Delete
4436  AG01000712 01  6447 004  398728  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398728  12  2016-08-29 00:00:00    2016-08-30 12:26:47  MG00000001  2017-08-01 15:38:48  MG00000001  View Edit Delete
11134  AG01000712 01  6447 004  398728  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398728  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
4444  AG01000716 01  6450 004  398737  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398737  12  2016-08-29 00:00:00    2016-08-30 12:26:47  MG00000001  2017-08-01 15:34:40  MG00000001  View Edit Delete
11140  AG01000716 01  6450 004  398737  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398737  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-08-01 15:34:50  MG00000001  View Edit Delete
4445  AG01000716 01  6480 004  472737  90007  果物  くだもの  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2472737  12  2016-08-29 00:00:00    2016-08-30 12:26:47  MG00000001  2017-08-01 15:34:05  MG00000001  View Edit Delete
6389  AG01000716 01  1500 007  6091  36200  じゃがいも  じゃがいも  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246091  12  2016-08-29 00:00:00    2016-08-30 12:27:01  MG00000001  2016-08-30 12:27:01  MG00000001  View Edit Delete
4454  AG01000721 01  6438 004  398715  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398715  12  2016-08-29 00:00:00    2016-08-30 12:26:47  MG00000001  2016-08-30 12:26:47  MG00000001  View Edit Delete
11141  AG01000721 01  6438 004  398715  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398715  12  2017-07-31 00:00:00    2017-07-31 00:00:00  MG00000001  2017-07-31 00:00:00  MG00000001  View Edit Delete
4455  AG01000721 01  6468 004  472715  90007  木下浩明  くだもの  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2472715  12  2016-08-29 00:00:00    2016-08-30 12:26:47  MG00000001  2016-08-30 12:26:47  MG00000001  View Edit Delete
1733650  AG01000721 01  32858 031  544601  31910  青ねぎ  あおねぎ  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544601  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733651  AG01000721 01  32859 031  544602  90000  農産物02  のうさんぶつ02  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544602  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733652  AG01000721 01  32860 031  544603  90000  農産物03  のうさんぶつ03  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544603  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733653  AG01000721 01  32861 031  544604  90000  農産物04  のうさんぶつ04  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544604  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733654  AG01000721 01  32862 031  544605  90000  農産物05  のうさんぶつ05  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544605  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733655  AG01000721 01  32863 031  544606  90000  農産物06  のうさんぶつ06  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544606  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733656  AG01000721 01  32864 031  544607  90000  農産物07  のうさんぶつ07  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544607  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733657  AG01000721 01  32865 031  544608  90000  農産物08  のうさんぶつ08  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544608  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 28 of 15485, showing 20 records out of 309681 total, starting on record 541, ending on 560

(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`.`farmer_id` asc LIMIT 540, 2020205
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