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
52265  AG02100007 02  5371 53  01  30200  かぶら  かぶら  徳島県鳴門市大麻町三俣字走出16                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530101  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52266  AG02100007 02  5372 53  02  31900  ネギ  ねぎ  徳島県鳴門市大麻町三俣字走出16                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530102  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52267  AG02100007 02  5373 53  03  31100  白菜  はくさい  徳島県鳴門市大麻町三俣字走出16                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530103  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52268  AG02100008 02  5370 53  00  30600  レンコン  れんこん  徳島県板野郡藍住町乙瀬字中田158-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530200  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52269  AG02100008 02  5371 53  01  30200  かぶら  かぶら  徳島県板野郡藍住町乙瀬字中田158-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530201  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52270  AG02100008 02  5372 53  02  35500  枝豆  えだまめ  徳島県板野郡藍住町乙瀬字中田158-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530202  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52271  AG02100008 02  5373 53  03  90002  つるむらさき  つるむらさき  徳島県板野郡藍住町乙瀬字中田158-1                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530203  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52272  AG02100009 02  5370 53  00  31800  ほうれん草  ほうれんそう  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530300  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52273  AG02100009 02  5371 53  01  31310  水菜  みずな  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530301  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52274  AG02100009 02  5372 53  02  31500  小松菜  こまつな  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530302  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52275  AG02100009 02  5373 53  03  34200  かぼちゃ  かぼちゃ  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530303  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52276  AG02100009 02  5374 53  04  34400  トマト  とまと  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530304  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52277  AG02100009 02  5375 53  05  35500  枝豆  えだまめ  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530305  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52278  AG02100009 02  5376 53  06  34950  瓜  うり  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530306  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52279  AG02100009 02  5377 53  07  33300  ブロッコリー  ぶろっこりー  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530307  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52280  AG02100009 02  5378 53  08  33200  カリフラワー  かりふらわー  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530308  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52281  AG02100009 02  5379 53  09  33600  パセリ  ぱせり  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530309  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52282  AG02100009 02  5380 53  10  90002  リーフミックス  りーふみっくす  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530310  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52283  AG02100009 02  5381 53  11  32600  春菊  しゅんぎく  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530311  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52284  AG02100009 02  5382 53  12  31900  ネギ  ねぎ  徳島県徳島市国府町中231                                                
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530312  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 217 of 15485, showing 20 records out of 309681 total, starting on record 4321, ending on 4340

(default) 2 queries took 987 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 4320, 20202027
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 = 111960