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
16682411  AG02000128 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26238193  12  2023-11-10 00:00:00    2023-11-10 11:24:49  MG00000001  2023-11-10 11:24:49  MG00000001  View Edit Delete
16682410  AG01004825 01  28939 031  686912  43500  次郎柿  じろうがき  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17686912  12  2023-11-10 00:00:00    2023-11-10 10:34:25  AG01004825  2023-11-10 10:34:25  AG01004825  View Edit Delete
16682409  AG01005527 01  44216 033  50062  30200  かぶ  かぶ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0250062  12  2023-11-10 00:00:00    2023-11-10 07:41:49  AG01005527  2023-11-10 07:43:33  AG01005527  View Edit Delete
16682408  AG01004982 01  17125 066  034  34270  ズッキーニ  ずっきーに  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24050034  12  2023-11-09 00:00:00    2023-11-09 17:35:42  AG01004982  2023-11-09 17:35:42  AG01004982  View Edit Delete
16682407  AG01004942 01  12685 011  68351  33400  レタス  れたす  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2768351  12  2023-11-09 00:00:00    2023-11-09 16:42:56  AG01004942  2023-11-09 16:42:56  AG01004942  View Edit Delete
16682406  AG01004505 01  17109 066  018  32800  にら  にら  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24168018  12  2023-11-09 00:00:00    2023-11-09 15:08:36  AG01004505  2023-11-09 15:08:36  AG01004505  View Edit Delete
16682405  AG01005606 01  44876 033  50722  30100  50722_農産物  のうさんぶつ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0250722  12  2023-11-09 00:00:00    2023-11-09 12:05:04  AG01005606  2023-11-09 12:05:52  AG01005606  View Edit Delete
16682404  AG01004033 01  18640 032  85272  90002  大根葉  だいこんば  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685272  12  2023-11-09 00:00:00    2023-11-09 11:04:55  AG01004033  2023-11-09 11:04:55  AG01004033  View Edit Delete
16682403  AG01003736 01  41063 033  56124  30200  小かぶ  こかぶ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0256124  12  2023-11-09 00:00:00    2023-11-09 10:52:30  AG01003736  2023-11-09 10:52:30  AG01003736  View Edit Delete
16682402  AG01005236 01  22759 031  613212  90001  ローズマリー  ろーずまりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17613212  12  2023-11-09 00:00:00    2023-11-09 09:06:40  AG01005236  2023-11-09 09:06:40  AG01005236  View Edit Delete
16682401  AG01005742 01  47529 033  57746  31800  ホウレン草  ほうれんそう  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0257746  12  2023-11-09 00:00:00    2023-11-09 07:54:13  AG01005742  2023-11-29 14:31:20  AG01005742  View Edit Delete
16682400  AG01005742 01  47529 033  57746  31800  57746_農産物  ほうれんそう  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0257746  12  2023-11-09 00:00:00    2023-11-09 07:47:58  AG01005742  2023-11-27 15:21:38  MG00000001  View Edit Delete
16682399  AG01004505 01  14553 063  646161  36300  赤芽里芋  あかめさといも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646161  12  2023-11-08 00:00:00    2023-11-08 18:12:09  AG01004505  2023-11-08 18:12:09  AG01004505  View Edit Delete
16682398  AG01004505 01  14958 062  646161  36300  赤芽里芋  あかめさといも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646161  12  2023-11-08 00:00:00    2023-11-08 18:11:36  AG01004505  2023-11-08 18:11:36  AG01004505  View Edit Delete
16682397  AG01005001 01  14517 063  646125  36300  赤里芋  あかさといも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646125  12  2023-11-08 00:00:00    2023-11-08 18:09:32  AG01005001  2023-11-08 18:09:32  AG01005001  View Edit Delete
16682396  AG01005001 01  14922 062  646125  36300  赤里芋  あかさといも  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646125  12  2023-11-08 00:00:00    2023-11-08 18:08:59  AG01005001  2023-11-08 18:08:59  AG01005001  View Edit Delete
16682395  AG01005090 01  17164 066  082  41410  レモン  れもん  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24010082  12  2023-11-08 00:00:00    2023-11-08 17:40:43  AG01005090  2023-11-08 17:40:43  AG01005090  View Edit Delete
16682394  AG08000070 08  10846 96  773  99998  収穫体験  しゅうかくたいけん  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20159773  12  2021-10-20 00:00:00    2021-10-20 15:38:58  MG00000001  2021-10-20 15:39:21  MG00000001  View Edit Delete
16682393  AG08000070 08  10356 96  699  46000  あまおとめ  あまおとめ  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20159699  12  2021-04-15 00:00:00    2021-04-15 15:01:23  MG00000005  2021-04-15 15:01:23  MG00000005  View Edit Delete
16682392  AG08000070 08  10355 96  698  46000  紅ほっぺ  べにほっぺ  神奈川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20159698  12  2021-04-15 00:00:00    2021-04-15 15:01:20  MG00000005  2021-04-15 15:01:20  MG00000005  View Edit Delete

Page 252 of 15485, showing 20 records out of 309681 total, starting on record 5021, ending on 5040

(default) 2 queries took 1019 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 5020, 20202031
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 = 111988