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
16684517  AG01006005 01  51037 033  58605  31100  白菜  はくさい  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258605  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684516  AG01006005 01  51036 033  58604  33200  カリフラワー  かりふらわー  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258604  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684515  AG01006005 01  51035 033  58603  33300  ブロッコリー  ぶろっこりー  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258603  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684514  AG01006005 01  51034 033  58602  31310  水菜  みずな  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258602  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684513  AG01006005 01  51033 033  58601  33810  チンゲンサイ  ちんげんさい  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258601  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684512  AG01006005 01  51032 033  58600  90001  セルリー  せるりー  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258600  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684511  AG01006005 01  51031 033  58599  32600  春菊  しゅんぎく  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258599  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684510  AG01006005 01  51030 033  58598  31800  ほうれん草  ほうれんそう  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258598  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684509  AG01006004 01  51029 033  58211  90000  農産物  のうさんぶつ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258211  12  2023-11-29 00:00:00    2023-11-29 00:00:00  MG00000001  2023-11-29 00:00:00  MG00000001  View Edit Delete
16684506  AG01005748 01  50827 033  58124  31910  58124_農産物  のうさんぶつ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258124  12  2023-11-29 00:00:00    2023-11-29 07:37:20  AG01005748  2023-11-29 07:37:20  AG01005748  View Edit Delete
16684505  AG01005527 01  44950 033  51591  32600  春菊  しゅんぎく  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0251591  12  2023-11-29 00:00:00    2023-11-29 07:13:09  AG01005527  2023-11-29 07:13:09  AG01005527  View Edit Delete
16684504  AG01005099 01  17157 066  066  39310  ゆず  ゆず  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24118066  12  2023-11-28 00:00:00    2023-11-28 17:34:29  AG01005099  2023-11-28 17:34:29  AG01005099  View Edit Delete
16684503  AG01005082 01  17106 066  015  31900  白ねぎ  しろねぎ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24088015  12  2023-11-28 00:00:00    2023-11-28 16:49:03  AG01005082  2023-11-28 16:49:03  AG01005082  View Edit Delete
16684502  AG01006001 01  51027 036  109187  37300  とうがらし  とうがらし  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109187  12  2023-11-28 00:00:00    2023-11-28 15:56:33  MG00000007  2023-11-28 15:56:33  MG00000007  View Edit Delete
16684501  AG01006001 01  51026 036  109186  33300  ブロッコリー  ぶろっこりー  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109186  12  2023-11-28 00:00:00    2023-11-28 15:55:37  MG00000007  2023-11-28 15:55:37  MG00000007  View Edit Delete
16684500  AG01005863 01  51025 036  109185  31100  シロナ  しろな  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109185  12  2023-11-28 00:00:00    2023-11-28 15:54:24  MG00000007  2023-11-28 15:54:24  MG00000007  View Edit Delete
16684499  AG01005863 01  51023 036  109183  37500  赤しそ  あかしそ  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109183  12  2023-11-28 00:00:00    2023-11-28 15:51:29  MG00000007  2023-11-28 15:51:29  MG00000007  View Edit Delete
16684498  AG01005863 01  51022 036  109182  34910  トウガン  とうがん  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109182  12  2023-11-28 00:00:00    2023-11-28 15:50:32  MG00000007  2023-11-28 15:50:32  MG00000007  View Edit Delete
16684497  AG01005863 01  51021 036  109181  33810  チンゲンサイ  ちんげんさい  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109181  12  2023-11-28 00:00:00    2023-11-28 15:49:31  MG00000007  2023-11-28 15:49:31  MG00000007  View Edit Delete
16684496  AG01005957 01  51020 036  109180  36500  山の芋  やまのいも  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109180  12  2023-11-28 00:00:00    2023-11-28 15:41:03  MG00000007  2023-11-28 15:41:03  MG00000007  View Edit Delete

Page 155 of 15485, showing 20 records out of 309681 total, starting on record 3081, ending on 3100

(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` desc LIMIT 3080, 20202026
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 = 111970