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
16684617  AG01005873 01  51072 036  109189  39310  ゆず  ゆず  佐賀県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109189  12  2023-12-04 00:00:00    2023-12-04 16:58:08  MG00000007  2023-12-04 16:58:08  MG00000007  View Edit Delete
16684616  AG01005844 01  51071 036  105882  90002  つぼみ菜  つぼみな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105882  12  2023-12-04 00:00:00    2023-12-04 16:56:39  MG00000007  2023-12-04 16:56:39  MG00000007  View Edit Delete
16684615  AG01005843 01  51070 036  105881  33200  カリフラワー  かりふらわー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105881  12  2023-12-04 00:00:00    2023-12-04 16:52:32  MG00000007  2023-12-04 16:52:32  MG00000007  View Edit Delete
16684614  AG01003888 01  7910 011  69566  30100  大根  だいこん  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769566  12  2023-12-04 00:00:00    2023-12-04 16:47:04  AG01003888  2023-12-04 16:47:04  AG01003888  View Edit Delete
16684613  AG01005838 01  51069 036  105880  30100  大根葉  だいこんば  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105880  12  2023-12-04 00:00:00    2023-12-04 16:45:19  MG00000007  2023-12-04 16:45:19  MG00000007  View Edit Delete
16684612  AG01005838 01  51068 036  105879  39310  ゆず  ゆず  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105879  12  2023-12-04 00:00:00    2023-12-04 16:26:50  MG00000007  2023-12-04 16:26:50  MG00000007  View Edit Delete
16684611  AG01005827 01  51067 036  105883  31100  白菜  はくさい  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105883  12  2023-12-04 00:00:00    2023-12-04 16:25:35  MG00000007  2023-12-04 16:25:35  MG00000007  View Edit Delete
16684610  AG01004505 01  15350 065  500145  30210  赤かぶ  あかかぶ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20500145  12  2023-12-04 00:00:00    2023-12-04 15:43:30  AG01004505  2023-12-04 15:43:30  AG01004505  View Edit Delete
16684609  AG01005022 01  17096 066  005  30300  人参  にんじん  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
24042005  12  2023-12-04 00:00:00    2023-12-04 14:31:00  AG01005022  2023-12-04 14:31:00  AG01005022  View Edit Delete
16684608  AG01004006 01  18770 032  85533  32600  春菊     やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685533  12  2023-12-04 00:00:00    2023-12-04 14:05:09  AG01004006  2023-12-04 14:07:50  AG01004006  View Edit Delete
16684607  AG01003768 01  41069 033  56130  39510  銀杏  ぎんなん  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0256130  12  2023-12-04 00:00:00    2023-12-04 09:40:36  AG01003768  2023-12-04 09:40:36  AG01003768  View Edit Delete
16684606  AG01001918 01  18647 032  85279  33300  85279_野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2685279  12  2023-12-04 00:00:00    2023-12-04 07:38:14  AG01001918  2023-12-04 07:38:14  AG01001918  View Edit Delete
16684605  AG01005606 01  44878 033  50724  31900  九条ねぎ  くじょうねぎ  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0250724  12  2023-12-04 00:00:00    2023-12-04 07:03:16  AG01005606  2023-12-21 07:18:04  AG01005606  View Edit Delete
16684604  AG01004505 01  15350 065  500145  33200  カリフローレ  かりふろーれ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20500145  12  2023-12-03 00:00:00    2023-12-03 17:36:54  AG01004505  2023-12-03 17:36:54  AG01004505  View Edit Delete
16684603  AG01004505 01  14553 063  646161  90001  サラダ南瓜  さらだかぼちゃ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646161  12  2023-12-03 00:00:00    2023-12-03 14:01:50  AG01004505  2023-12-03 14:01:50  AG01004505  View Edit Delete
16684602  AG01004505 01  14958 062  646161  34200  サラダ南瓜  さらだかぼちゃ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
23646161  12  2023-12-03 00:00:00    2023-12-03 14:01:27  AG01004505  2023-12-03 14:01:27  AG01004505  View Edit Delete
16684601  AG01004505 01  15350 065  500145  31700  サボイキャベツ  さぼいきゃべつ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20500145  12  2023-12-02 00:00:00    2023-12-02 17:58:42  AG01004505  2023-12-02 17:58:42  AG01004505  View Edit Delete
16684600  AG01004505 01  15350 065  500145  34200  くり南瓜  くりかぼちゃ  長崎県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
20500145  12  2023-12-02 00:00:00    2023-12-02 15:09:40  AG01004505  2023-12-02 15:09:40  AG01004505  View Edit Delete
16684599  AG01005471 01  42735 031  605814  90002  大根葉  だいこんば  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17605814  12  2023-12-02 00:00:00    2023-12-02 12:50:00  AG01005471  2023-12-02 12:52:34  AG01005471  View Edit Delete
16684598  AG01005471 01  42734 031  605813  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17605813  12  2023-12-02 00:00:00    2023-12-02 12:48:19  AG01005471  2023-12-02 12:48:19  AG01005471  View Edit Delete

Page 150 of 15485, showing 20 records out of 309681 total, starting on record 2981, ending on 3000

(default) 2 queries took 977 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 2980, 20202018
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 = 111959