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
1733601  AG01001045 01  32809 031  581612  31320  みぶな  みぶな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581612  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733602  AG01001045 01  32810 031  581613  33810  チンゲンサイ  ちんげんさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581613  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733603  AG01001045 01  32811 031  581614  90002  からし菜  からしな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581614  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733604  AG01001045 01  32812 031  581615  30100  紅大根  べにだいこん  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581615  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733605  AG01001045 01  32813 031  581616  31800  ほうれん草  ほうれんそう  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581616  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733606  AG01001045 01  32814 031  581617  30300  金時人参  きんときにんじん  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581617  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733607  AG01001045 01  32815 031  581618  90002  わさび菜  わさびな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581618  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733608  AG01001045 01  32816 031  581619  31800  赤軸ほうれん草  あかじくほうれんそう  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581619  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733609  AG01001045 01  32817 031  581620  90002  のらぼうな  のらぼうな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581620  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733610  AG01001045 01  32818 031  581621  90001  コールラビ  こーるらび  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581621  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733611  AG01001045 01  32819 031  581622  41260  甘夏  あまなつ  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581622  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733612  AG01001045 01  32820 031  581623  90000  農産物23  のうさんぶつ23  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581623  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733613  AG01001045 01  32821 031  581624  90000  農産物24  のうさんぶつ24  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581624  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733614  AG01001045 01  32822 031  581625  90000  農産物25  のうさんぶつ25  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581625  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733615  AG01001045 01  32823 031  581626  90000  農産物26  のうさんぶつ26  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581626  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733616  AG01001045 01  32824 031  581627  90000  農産物27  のうさんぶつ27  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581627  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733617  AG01001045 01  32825 031  581628  90000  農産物28  のうさんぶつ28  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581628  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733618  AG01001045 01  32826 031  581629  90000  農産物29  のうさんぶつ29  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581629  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733619  AG01001045 01  32827 031  581630  90000  農産物30  のうさんぶつ30  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17581630  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1669071  AG01001045 01  18610 032  85154  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685154  12  2023-07-11 00:00:00    2023-03-29 09:40:28  MG00000001  2023-03-29 09:40:28  MG00000001  View Edit Delete

Page 43 of 15485, showing 20 records out of 309681 total, starting on record 841, ending on 860

(default) 2 queries took 910 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 840, 2020207
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 = 111903