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
60373  AG02100048 02  5376 53  06  31500  小松菜  こまつな  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534706  12  2018-05-22 00:00:00    2018-05-22 09:50:38  MG00000001  2018-05-22 09:50:38  MG00000001  View Edit Delete
60374  AG02100048 02  5377 53  07  33810  チンゲン菜  ちんげんさい  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534707  12  2018-05-22 00:00:00    2018-05-22 09:51:50  MG00000001  2018-05-22 09:51:50  MG00000001  View Edit Delete
60375  AG02100048 02  5378 53  08  31100  白菜  はくさい  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534708  12  2018-05-22 00:00:00    2018-05-22 09:52:58  MG00000001  2018-05-22 09:52:58  MG00000001  View Edit Delete
60376  AG02100048 02  5379 53  09  31900  ねぎ  ねぎ  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534709  12  2018-05-22 00:00:00    2018-05-22 09:53:54  MG00000001  2018-05-22 09:53:54  MG00000001  View Edit Delete
60377  AG02100048 02  5380 53  10  31800  ほうれん草  ほうれんそう  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534710  12  2018-05-22 00:00:00    2018-05-22 09:54:48  MG00000001  2018-05-22 09:54:48  MG00000001  View Edit Delete
60378  AG02100048 02  5381 53  11  30100  大根  だいこん  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534711  12  2018-05-22 00:00:00    2018-05-22 09:55:38  MG00000001  2018-05-22 09:55:38  MG00000001  View Edit Delete
60379  AG02100048 02  5382 53  12  30200  かぶ  かぶ  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534712  12  2018-05-22 00:00:00    2018-05-22 09:58:28  MG00000001  2018-05-22 09:58:28  MG00000001  View Edit Delete
60380  AG02100048 02  5383 53  13  36200  じゃがいも  じゃがいも  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534713  12  2018-05-22 00:00:00    2018-05-22 09:59:24  MG00000001  2018-05-22 09:59:24  MG00000001  View Edit Delete
60381  AG02100048 02  5384 53  14  34500  ピーマン  ぴーまん  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534714  12  2018-05-22 00:00:00    2018-05-22 10:00:11  MG00000001  2018-05-22 10:00:11  MG00000001  View Edit Delete
60382  AG02100048 02  5385 53  15  34300  なす  なす  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534715  12  2018-05-22 00:00:00    2018-05-22 10:00:57  MG00000001  2018-05-22 10:00:57  MG00000001  View Edit Delete
60383  AG02100048 02  5386 53  16  34100  きゅうり  きゅうり  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534716  12  2018-05-22 00:00:00    2018-05-22 10:02:22  MG00000001  2018-05-22 10:02:22  MG00000001  View Edit Delete
60384  AG02100048 02  5387 53  17  35200  絹さやエンドウ  きぬさやえんどう  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534717  12  2018-05-22 00:00:00    2018-05-22 10:03:34  MG00000001  2018-05-22 10:03:34  MG00000001  View Edit Delete
60385  AG02100048 02  5388 53  18  30100  大根葉  だいこんは  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534718  12  2018-05-22 00:00:00    2018-05-22 10:04:47  MG00000001  2018-05-22 10:04:47  MG00000001  View Edit Delete
60386  AG02100048 02  5389 53  19  34200  かぼちゃ  かぼちゃ  徳島県阿波市市場町日開谷字奥日開谷32                                          
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534719  12  2018-05-22 00:00:00    2018-05-22 10:05:28  MG00000001  2018-05-22 10:05:28  MG00000001  View Edit Delete
60387  AG02100049 02  5370 53  00  34270  ズッキーニ  ずっきーに  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534600  12  2018-05-22 00:00:00    2018-05-22 10:07:59  MG00000001  2018-05-22 10:07:59  MG00000001  View Edit Delete
60388  AG02100049 02  5371 53  01  34500  ピーマン  ぴーまん  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534601  12  2018-05-22 00:00:00    2018-05-22 10:09:05  MG00000001  2018-05-22 10:09:05  MG00000001  View Edit Delete
60389  AG02100049 02  5372 53  02  34800  丸おくら  まるおくら  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534602  12  2018-05-22 00:00:00    2018-05-22 10:09:28  MG00000001  2018-05-22 10:09:28  MG00000001  View Edit Delete
60390  AG02100049 02  5373 53  03  34100  きゅうり  きゅうり  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534603  12  2018-05-22 00:00:00    2018-05-22 10:09:58  MG00000001  2018-05-22 10:09:58  MG00000001  View Edit Delete
60391  AG02100049 02  5374 53  04  90003  さんど豆  さんどまめ  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534604  12  2018-05-22 00:00:00    2018-05-22 10:10:35  MG00000001  2018-05-22 10:10:35  MG00000001  View Edit Delete
60392  AG02100049 02  5375 53  05  35100  モロッコインゲン  もろっこいんげん  徳島県阿波市市場町日開谷字為後156                                           
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2534605  12  2018-05-22 00:00:00    2018-05-22 10:11:07  MG00000001  2018-05-22 10:11:07  MG00000001  View Edit Delete

Page 337 of 15485, showing 20 records out of 309681 total, starting on record 6721, ending on 6740

(default) 2 queries took 1041 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 6720, 20202042
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 = 111999