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
60353  AG02100045 02  5382 53  12  43000  梨  なし  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535612  12  2018-05-21 00:00:00    2018-05-21 15:16:58  MG00000001  2018-05-21 15:27:16  MG00000001  View Edit Delete
60354  AG02100045 02  5383 53  13  45800  いちじく  いちじく  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535613  12  2018-05-21 00:00:00    2018-05-21 15:17:47  MG00000001  2018-05-21 15:27:36  MG00000001  View Edit Delete
60355  AG02100045 02  5384 53  14  36300  里芋(皮付き)  さといもかわつき  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535614  12  2018-05-21 00:00:00    2018-05-21 15:19:32  MG00000001  2018-05-21 15:25:16  MG00000001  View Edit Delete
60356  AG02100045 02  5385 53  15  36600  玉ねぎ  たまねぎ  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535615  12  2018-05-21 00:00:00    2018-05-21 15:22:16  MG00000001  2018-05-21 15:24:58  MG00000001  View Edit Delete
60357  AG02100045 02  5386 53  16  30100  大根  だいこん  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535616  12  2018-05-21 00:00:00    2018-05-21 15:24:33  MG00000001  2018-05-21 15:24:33  MG00000001  View Edit Delete
60358  AG02100045 02  5387 53  17  33400  レタス  れたす  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535617  12  2018-05-21 00:00:00    2018-05-21 15:30:42  MG00000001  2018-05-21 15:30:42  MG00000001  View Edit Delete
60359  AG02100045 02  5388 53  18  33300  ブロッコリー  ぶろっこりー  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535618  12  2018-05-21 00:00:00    2018-05-21 15:32:04  MG00000001  2018-05-21 15:32:04  MG00000001  View Edit Delete
60360  AG02100045 02  5389 53  19  31700  キャベツ  きゃべつ  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535619  12  2018-05-21 00:00:00    2018-05-21 15:33:01  MG00000001  2018-05-21 15:33:01  MG00000001  View Edit Delete
60361  AG02100045 02  5390 53  20  30300  人参  にんじん  徳島県板野郡北島町中村字岸ノ上1-69                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535620  12  2018-05-21 00:00:00    2018-05-21 15:34:36  MG00000001  2018-05-21 15:35:48  MG00000001  View Edit Delete
60362  AG02100046 02  5370 53  00  30300  人参  にんじん  徳島県板野郡板野町西中富字一才11                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534900  12  2018-05-21 00:00:00    2018-05-21 15:38:36  MG00000001  2018-05-21 15:38:36  MG00000001  View Edit Delete
60363  AG02100047 02  5370 53  00  34300  なす  なす  徳島県阿波市阿波町伊沢田228-1                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535500  12  2018-05-21 00:00:00    2018-05-21 15:40:59  MG00000001  2018-05-21 15:40:59  MG00000001  View Edit Delete
60364  AG02100047 02  5371 53  01  33300  ブロッコリー  ぶろっこりー  徳島県阿波市阿波町伊沢田228-1                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535501  12  2018-05-21 00:00:00    2018-05-21 15:44:18  MG00000001  2018-05-21 15:44:18  MG00000001  View Edit Delete
60365  AG02100047 02  5372 53  02  31900  ねぎ  ねぎ  徳島県阿波市阿波町伊沢田228-1                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535502  12  2018-05-21 00:00:00    2018-05-21 15:45:04  MG00000001  2018-05-21 15:45:04  MG00000001  View Edit Delete
60366  AG02100047 02  5373 53  03  33410  サニーレタス  さにーれたす  徳島県阿波市阿波町伊沢田228-1                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2535503  12  2018-05-21 00:00:00    2018-05-21 15:46:05  MG00000001  2018-05-21 15:46:05  MG00000001  View Edit Delete
60367  AG02100048 02  5370 53  00  33300  ブロッコリー  ぶろっこりー  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534700  12  2018-05-21 00:00:00    2018-05-21 15:58:13  MG00000001  2018-05-21 15:58:13  MG00000001  View Edit Delete
60368  AG02100048 02  5371 53  01  31700  キャベツ  きゃべつ  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534701  12  2018-05-22 00:00:00    2018-05-22 09:46:15  MG00000001  2018-05-22 09:46:15  MG00000001  View Edit Delete
60369  AG02100048 02  5372 53  02  33200  カリフラワー  かりふらわー  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534702  12  2018-05-22 00:00:00    2018-05-22 09:47:16  MG00000001  2018-05-22 09:47:16  MG00000001  View Edit Delete
60370  AG02100048 02  5373 53  03  36600  玉ねぎ  たまねぎ  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534703  12  2018-05-22 00:00:00    2018-05-22 09:48:03  MG00000001  2018-05-22 09:48:03  MG00000001  View Edit Delete
60371  AG02100048 02  5374 53  04  36700  にんにく芋  にんにくいも  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534704  12  2018-05-22 00:00:00    2018-05-22 09:49:09  MG00000001  2018-05-22 09:49:09  MG00000001  View Edit Delete
60372  AG02100048 02  5375 53  05  33400  レタス  れたす  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534705  12  2018-05-22 00:00:00    2018-05-22 09:50:00  MG00000001  2018-05-22 09:50:00  MG00000001  View Edit Delete

Page 336 of 15485, showing 20 records out of 309681 total, starting on record 6701, ending on 6720

(default) 2 queries took 996 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 6700, 20202035
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 = 111961