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
52365  AG02100014 02  5376 53  06  33600  パセリ  ぱせり  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532106  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52366  AG02100014 02  5377 53  07  31900  ネギ  ねぎ  徳島県板野郡藍住町勝瑞字西勝地49                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532107  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52367  AG02100024 02  5370 53  00  30600  れんこん  れんこん  徳島県鳴門市鳴門町三ツ石字芙蓉山下145                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532200  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52368  AG02100024 02  5371 53  01  43000  豊水梨  ほうすいなし  徳島県鳴門市鳴門町三ツ石字芙蓉山下145                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532201  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52369  AG02100024 02  5372 53  02  43000  幸水梨  こうすいなし  徳島県鳴門市鳴門町三ツ石字芙蓉山下145                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532202  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52370  AG02100025 02  5381 53  11  30200  カブ  かぶ  徳島県阿南市                                                       
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532411  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52371  AG02100026 02  5370 53  00  34800  オクラ  おくら  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532500  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52372  AG02100026 02  5371 53  01  33920  菜花  なばな  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532501  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52373  AG02100026 02  5372 53  02  91012  空芯菜  くうしんさい  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532502  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52374  AG02100026 02  5373 53  03  34300  ナス  なす  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532503  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52375  AG02100026 02  5374 53  04  30100  大根  だいこん  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532504  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52376  AG02100026 02  5375 53  05  30300  人参  にんじん  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532505  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52377  AG02100026 02  5376 53  06  34100  きゅうり  きゅうり  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532506  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52378  AG02100026 02  5377 53  07  37200  ウコン  うこん  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532507  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52379  AG02100026 02  5378 53  08  36100  さつま芋  さつまいも  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532508  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52380  AG02100026 02  5379 53  09  32700  セリ  せり  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532509  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52381  AG02100026 02  5380 53  10  34200  カボチャ  かぼちゃ  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532510  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52382  AG02100026 02  5381 53  11  36700  ニンニク芋  にんにくいも  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532511  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52383  AG02100026 02  5382 53  12  34400  トマト  とまと  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532512  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52384  AG02100026 02  5383 53  13  36300  里芋(皮付き)  さといもかわつき  徳島県阿南市椿町宝野30                                                 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2532513  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 222 of 15485, showing 20 records out of 309681 total, starting on record 4421, ending on 4440

(default) 2 queries took 990 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 4420, 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 = 111966