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
63171  AG09000004 09  6252 101  38006  33810  チンゲン菜  ちんげんさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63172  AG09000004 09  6252 101  38006  32600  菊菜  きくな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63173  AG09000004 09  6252 101  38006  90002  チシャ菜  ちしゃな  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63174  AG09000004 09  6252 101  38006  31900  白ねぎ  しろねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63175  AG09000004 09  6252 101  38006  31910  青ねぎ  あおねぎ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63176  AG09000004 09  6252 101  38006  90002  葉物  はもの  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63177  AG09000004 09  6252 101  38006  31700  キャベツ  きゃべつ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63178  AG09000004 09  6252 101  38006  31100  はくさい  はくさい  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63179  AG09000004 09  6252 101  38006  33300  ブロッコリー  ぶろっこりー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63180  AG09000004 09  6252 101  38006  33200  カリフラワー  かりふらわー  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63181  AG09000004 09  6252 101  38006  33100  アスパラ  あすぱら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63182  AG09000004 09  6252 101  38006  33400  レタス  れたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63183  AG09000004 09  6252 101  38006  33410  サニーレタス  さにーれたす  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63184  AG09000004 09  6252 101  38006  33420  グリーンリーフ  ぐりーんりーふ  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63185  AG09000004 09  6252 101  38006  32800  ニラ  にら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63186  AG09000004 09  6252 101  38006  30400  ごぼう  ごぼう  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63187  AG09000004 09  6252 101  38006  30300  人参  にんじん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63188  AG09000004 09  6252 101  38006  30600  れんこん  れんこん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63189  AG09000004 09  6252 101  38006  30100  大根  だいこん  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete
63190  AG09000004 09  6252 101  38006  34800  オクラ  おくら  香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0238006  12  2018-06-18 00:00:00    2018-06-18 07:57:33  MG00000001  2018-06-18 07:57:33  MG00000001  View Edit Delete

Page 366 of 15485, showing 20 records out of 309681 total, starting on record 7301, ending on 7320

(default) 2 queries took 1001 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 LIMIT 7300, 20202040
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 = 111961