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
16680877  AG01005927 01  49691 036  105599  34460  ミニトマト  みにとまと  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105599  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680876  AG01005927 01  49690 036  105598  34300  ナス  なす  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105598  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680875  AG01005927 01  49688 036  105596  90002  つぼみ菜  つぼみな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105596  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680874  AG01005927 01  49687 036  105595  33920  菜の花  なのはな  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105595  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680873  AG01005927 01  49686 036  105594  33300  ブロッコリー  ぶろっこりー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105594  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680872  AG01005927 01  49685 036  105593  33200  カリフラワー  かりふらわー  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105593  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680871  AG01005927 01  49684 036  105592  32100  わけぎ  わけぎ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105592  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680870  AG01005927 01  49683 036  105591  31100  白菜  はくさい  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105591  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680869  AG01005927 01  49682 036  105590  31700  キャベツ  きゃべつ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105590  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680868  AG01005927 01  49681 036  105589  30300  人参  にんじん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105589  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680867  AG01005927 01  49680 036  105588  30200  かぶ  かぶ  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105588  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680866  AG01005927 01  49679 036  105587  30100  大根  だいこん  福岡県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105587  12  2023-10-26 00:00:00    2023-10-26 00:00:00  MG00000001  2023-10-26 00:00:00  MG00000001  View Edit Delete
16680864  AG02000102 02  6247 54  82937  49300  キウイ  きうい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0282937  12  2023-10-26 00:00:00    2023-10-26 10:47:25  MG00000001  2023-10-26 10:47:25  MG00000001  View Edit Delete
16680863  AG02000009 02  7904 54  45004  49300  キウイ  きうい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0245004  12  2023-10-26 00:00:00    2023-10-26 10:47:17  MG00000001  2023-10-26 10:47:17  MG00000001  View Edit Delete
16680862  AG02000102 02  6392 52  1963  49300  キウイ  きうい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791963  12  2023-10-26 00:00:00    2023-10-26 10:46:54  MG00000001  2023-10-26 10:46:54  MG00000001  View Edit Delete
16680861  AG02000009 02  5258 52  1656  49300  キウイ  きうい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791656  12  2023-10-26 00:00:00    2023-10-26 10:46:45  MG00000001  2023-10-26 10:46:45  MG00000001  View Edit Delete
16680860  AG02000102 02  2669 51  272  49300  キウイ  きうい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26386272  12  2023-10-26 00:00:00    2023-10-26 10:45:59  MG00000001  2023-10-26 10:45:59  MG00000001  View Edit Delete
16680859  AG02000009 02  2669 51  272  49300  キウイ  きうい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26574272  12  2023-10-26 00:00:00    2023-10-26 10:45:26  MG00000001  2023-10-26 10:45:26  MG00000001  View Edit Delete
16680858  AG01005744 01  47531 033  57748  33810  ちんげんさい  ちんげんさい  岡山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0257748  12  2023-10-26 00:00:00    2023-10-26 08:05:47  AG01005744  2023-11-28 12:34:07  MG00000001  View Edit Delete
16680857  AG01005926 01  49840 031  820630  90000  農産物30  のうさんぶつ  和歌山県橋本市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17820630  12  2023-10-25 00:00:00    2023-10-25 16:07:00  MG00000007  2023-10-25 16:07:00  MG00000007  View Edit Delete

Page 327 of 15485, showing 20 records out of 309681 total, starting on record 6521, ending on 6540

(default) 2 queries took 1018 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 6520, 20202037
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 = 111981