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
16685827  AG01005845 01  51383 036  105923  31900  ネギ  ねぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105923  12  2023-12-22 00:00:00    2023-12-22 15:00:20  MG00000007  2023-12-22 15:00:20  MG00000007  View Edit Delete
16685826  AG01005845 01  51382 036  105922  90002  ケール  けーる  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105922  12  2023-12-22 00:00:00    2023-12-22 14:59:21  MG00000007  2023-12-22 14:59:21  MG00000007  View Edit Delete
16685825  AG01005845 01  51381 036  105921  90002  わさび菜  わさびな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105921  12  2023-12-22 00:00:00    2023-12-22 14:58:03  MG00000007  2023-12-22 14:58:03  MG00000007  View Edit Delete
16685824  AG01005845 01  51380 036  105920  31500  小松菜  こまつな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105920  12  2023-12-22 00:00:00    2023-12-22 14:56:52  MG00000007  2023-12-22 14:56:52  MG00000007  View Edit Delete
16685823  AG01005841 01  51379 036  105910  30400  ごぼう  ごぼう  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105910  12  2023-12-22 00:00:00    2023-12-22 14:55:36  MG00000007  2023-12-22 14:55:36  MG00000007  View Edit Delete
16685822  AG01005841 01  51378 036  105909  33200  カリフラワー  かりふらわー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105909  12  2023-12-22 00:00:00    2023-12-22 14:54:39  MG00000007  2023-12-22 14:54:39  MG00000007  View Edit Delete
16685821  AG01005841 01  51377 036  105908  90008  ネーブル  ねーぶる  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105908  12  2023-12-22 00:00:00    2023-12-22 14:53:28  MG00000007  2023-12-22 14:53:28  MG00000007  View Edit Delete
16685820  AG01005834 01  51376 036  105919  90003  ピース  ぴーす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105919  12  2023-12-22 00:00:00    2023-12-22 14:52:09  MG00000007  2023-12-22 14:52:09  MG00000007  View Edit Delete
16685819  AG01005834 01  51375 036  105918  30200  かぶ  かぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105918  12  2023-12-22 00:00:00    2023-12-22 14:49:57  MG00000007  2023-12-22 14:49:57  MG00000007  View Edit Delete
16685818  AG01005834 01  51374 036  105917  40100  みかん  みかん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105917  12  2023-12-22 00:00:00    2023-12-22 14:49:11  MG00000007  2023-12-22 14:49:11  MG00000007  View Edit Delete
16685817  AG01005834 01  51373 036  105916  33400  レタス  れたす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105916  12  2023-12-22 00:00:00    2023-12-22 14:48:06  MG00000007  2023-12-22 14:48:06  MG00000007  View Edit Delete
16685816  AG01005834 01  51372 036  105915  90002  かつお菜  かつおな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105915  12  2023-12-22 00:00:00    2023-12-22 14:46:50  MG00000007  2023-12-22 14:46:50  MG00000007  View Edit Delete
16685815  AG01005834 01  51371 036  105914  30300  人参  にんじん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105914  12  2023-12-22 00:00:00    2023-12-22 14:45:34  MG00000007  2023-12-22 14:45:34  MG00000007  View Edit Delete
16685814  AG01005831 01  51370 036  105913  31420  高菜  たかな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105913  12  2023-12-22 00:00:00    2023-12-22 14:44:17  MG00000007  2023-12-22 14:44:17  MG00000007  View Edit Delete
16685813  AG01005831 01  51369 036  105912  30200  かぶ  かぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105912  12  2023-12-22 00:00:00    2023-12-22 14:43:10  MG00000007  2023-12-22 14:43:10  MG00000007  View Edit Delete
16685812  AG01005831 01  51368 036  105911  90002  かつお菜  かつおな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105911  12  2023-12-22 00:00:00    2023-12-22 14:42:17  MG00000007  2023-12-22 14:42:17  MG00000007  View Edit Delete
16685811  AG01006005 01  51367 038  58735  91011  ユリ  ゆり  広島県福山市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0258735  12  2023-12-22 00:00:00    2023-12-22 14:38:59  MG00000007  2023-12-22 14:38:59  MG00000007  View Edit Delete
16685810  AG01003558 01  34437 031  711520  31700  キャベツ  きゃべつ  香川県丸亀市産 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17711520  12  2023-12-22 00:00:00    2023-12-22 10:25:03  AG01003558  2023-12-22 10:25:03  AG01003558  View Edit Delete
16685809  AG01005528 01  44228 033  50074  41410  レモン  れもん  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0250074  12  2023-12-22 00:00:00    2023-12-22 07:23:02  AG01005528  2023-12-22 07:23:02  AG01005528  View Edit Delete
16685808  AG01004505 01  17111 066  020  33200  カリフラワー  かりふらわー  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24168020  12  2023-12-21 00:00:00    2023-12-21 15:41:32  AG01004505  2023-12-21 15:41:32  AG01004505  View Edit Delete

Page 94 of 15485, showing 20 records out of 309681 total, starting on record 1861, ending on 1880

(default) 2 queries took 1037 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 1860, 20202017
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 = 1111020