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
52305  AG02100014 02  5370 53  00  30300  人参  にんじん  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532100  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52306  AG02100014 02  5371 53  01  35500  枝豆  えだまめ  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532101  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52307  AG02100014 02  5372 53  02  31100  てごろ菜  てごろな  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532102  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52308  AG02100014 02  5373 53  03  33810  チンゲン菜  ちんげんさい  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532103  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52309  AG02100014 02  5374 53  04  31500  小松菜  こまつな  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532104  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52310  AG02100014 02  5375 53  05  31800  ほうれん草  ほうれんそう  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532105  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52311  AG02100015 02  5371 53  01  34950  白瓜  しろうり  徳島県阿南市新野町谷口122                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531201  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52312  AG02100015 02  5372 53  02  39330  すだち  すだち  徳島県阿南市新野町谷口122                                               
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531202  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52313  AG02100016 02  5370 53  00  30300  人参  にんじん  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531300  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52314  AG02100016 02  5371 53  01  30200  かぶら  かぶら  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531301  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52315  AG02100016 02  5372 53  02  31700  キャベツ  きゃべつ  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531302  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52316  AG02100016 02  5373 53  03  30100  大根  だいこん  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531303  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52317  AG02100016 02  5374 53  04  33300  ブロッコリー  ぶろっこりー  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531304  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52318  AG02100016 02  5375 53  05  33200  カリフラワー  かりふらわー  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531305  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52319  AG02100016 02  5376 53  06  34300  ナス  なす  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531306  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52320  AG02100016 02  5377 53  07  33420  グリーンリーフ  ぐりーんりーふ  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531307  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52321  AG02100016 02  5378 53  08  33410  サニーレタス  さにーれたす  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531308  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52322  AG02100016 02  5379 53  09  35500  枝豆  えだまめ  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531309  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52323  AG02100016 02  5380 53  10  36600  玉ネギ  たまねぎ  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531310  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52324  AG02100016 02  5381 53  11  31800  ほうれん草  ほうれんそう  徳島県板野郡板野町古城字南屋敷4                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2531311  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 219 of 15485, showing 20 records out of 309681 total, starting on record 4361, ending on 4380

(default) 2 queries took 952 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 4360, 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 = 111928