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
60086  AG02100033 02  5382 53  12  34100  きゅうり  きゅうり  徳島県板野郡板野町西中富字喜多居地87-2                                        
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533212  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60087  AG02100033 02  5383 53  13  35400  そらまめ  そらまめ  徳島県板野郡板野町西中富字喜多居地87-2                                        
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533213  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60088  AG02100033 02  5384 53  14  35500  枝豆  えだまめ  徳島県板野郡板野町西中富字喜多居地87-2                                        
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533214  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60089  AG02100033 02  5385 53  15  30200  かぶ  かぶ  徳島県板野郡板野町西中富字喜多居地87-2                                        
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533215  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60090  AG02100034 02  5370 53  00  34270  ズッキーニ  ずっきーに  徳島県徳島市佐古3番町3-2                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533900  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60091  AG02100034 02  5371 53  01  36100  鳴門金時  なるときんとき  徳島県徳島市佐古3番町3-2                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533901  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60092  AG02100034 02  5372 53  02  33200  カリフラワー  かりふらわー  徳島県徳島市佐古3番町3-2                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533902  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60093  AG02100035 02  5370 53  00  36100  鳴門金時  なるときんとき  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534000  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60094  AG02100035 02  5371 53  01  30100  大根  だいこん  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534001  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60095  AG02100035 02  5372 53  02  33300  ブロッコリー  ぶろっこりー  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534002  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60096  AG02100035 02  5373 53  03  33400  レタス  れたす  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534003  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60097  AG02100035 02  5374 53  04  33400  サニーレタス  さにーれたす  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534004  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60098  AG02100035 02  5375 53  05  31800  ほうれん草  ほうれんそう  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534005  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60099  AG02100035 02  5376 53  06  31900  ねぎ  ねぎ  徳島県鳴門市里浦町里浦字坂田302-5                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534006  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60100  AG02100036 02  5370 53  00  31800  ほうれん草  ほうれんそう  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533700  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60101  AG02100036 02  5371 53  01  31310  水菜  みずな  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533701  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60102  AG02100036 02  5372 53  02  33420  グリーンリーフ  ぐりーんりーふ  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533702  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60103  AG02100036 02  5373 53  03  33400  サニーレタス  さにーれたす  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533703  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60104  AG02100036 02  5374 53  04  33400  半結球レタス  はんけっきゅうれたす  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533704  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  View Edit Delete
60105  AG02100036 02  5375 53  05  31500  小松菜  こまつな  徳島県徳島市川内町榎瀬835-9 2-203                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2533705  12  2018-05-11 00:00:00    2018-05-11 09:27:00  MG00000001  2018-05-11 09:27:00  MG00000001  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 965 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 6520, 20202033
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 = 111932