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
52345  AG02100020 02  5375 53  05  34300  ナス  なす  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530805  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52346  AG02100020 02  5376 53  06  39200  青梅  あおうめ  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530806  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52347  AG02100020 02  5377 53  07  39330  すだち  すだち  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530807  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52348  AG02100020 02  5378 53  08  31900  細ねぎ  ほそねぎ  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530808  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52349  AG02100020 02  5379 53  09  36200  じゃが芋  じゃがいも  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530809  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52350  AG02100020 02  5380 53  10  91011  シキビ  しきび  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530810  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52351  AG02100021 02  5370 53  00  33810  チンゲン菜  ちんげんさい  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530900  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52352  AG02100021 02  5371 53  01  31500  小松菜  こまつな  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530901  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52353  AG02100021 02  5372 53  02  31800  ほうれん草  ほうれんそう  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530902  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52354  AG02100021 02  5373 53  03  31310  水菜  みずな  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530903  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52355  AG02100021 02  5374 53  04  34300  なすび  なすび  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530904  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52356  AG02100021 02  5375 53  05  34100  きゅうり  きゅうり  徳島県板野郡松茂町広島字北川向一ノ越85-2                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530905  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52357  AG02100022 02  5370 53  00  90002  ツルムラサキ  つるむらさき  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531000  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52358  AG02100022 02  5371 53  01  37100  わさび菜  わさびな  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531001  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52359  AG02100022 02  5372 53  02  30300  人参  にんじん  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531002  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52360  AG02100022 02  5373 53  03  33300  ブロッコリー  ぶろっこりー  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531003  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52361  AG02100022 02  5374 53  04  90001  アイスプラント  あいすぷらんと  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531004  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52362  AG02100022 02  5375 53  05  33600  イタリアンパセリ  いたりあんぱせり  徳島県徳島市応神町東貞方字中筋66-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531005  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52363  AG02100023 02  5370 53  00  30600  レンコン  れんこん  徳島県鳴門市大麻町三俣字走出65                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531100  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52364  AG02100015 02  5370 53  00  37200  生姜  しょうが  徳島県阿南市新野町谷口122                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531200  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete

Page 221 of 15485, showing 20 records out of 309681 total, starting on record 4401, ending on 4420

(default) 2 queries took 983 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 4400, 20202024
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