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
9301  AG02000030 02  2667 51  252  43000  梨  なし  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26596252  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
9302  AG01001258 01  2463 006  7019  33600  パセリ  ぱせり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217019      2017-03-23 00:00:00    2017-03-23 15:03:09  MG00000001  2017-03-23 15:03:09  MG00000001  View Edit Delete
9306  AG01001278 01  2461 006  7017  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217017      2017-03-23 00:00:00    2017-03-23 16:19:30  MG00000001  2017-03-23 16:19:30  MG00000001  View Edit Delete
9337  AG01001305 01  2468 006  7024  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217024      2017-03-31 00:00:00    2017-03-31 15:56:06  MG00000001  2017-03-31 15:56:06  MG00000001  View Edit Delete
9346  AG01001250 01  2471 006  7027  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217027      2017-04-03 00:00:00    2017-04-03 16:12:42  MG00000001  2017-04-03 16:12:42  MG00000001  View Edit Delete
9347  AG02000029 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26595118  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9349  AG01000001 01  1925 009  12919  31800  ほうれん草  ほうれんそう  北海道 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212919      2017-04-05 00:00:00    2017-04-05 09:21:32  MG00000001  2017-04-05 09:21:32  MG00000001  View Edit Delete
9350  AG01001265 01  2787 006  7158  31900  白ねぎ  しろねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
217158  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-04-05 16:47:30  AG01001265  View Edit Delete
9353  AG01001579 01  2790 006  7161  30600  れんこん  れんこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
217161  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-04-14 15:14:14  MG00000001  View Edit Delete
9354  AG01001828 01  2791 006  7162  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
217162  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000000  View Edit Delete
9368  AG01001264 01  2450 006  7006  34400  フルーツトマト  ふるーつとまと  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217006      2017-04-12 00:00:00    2017-04-12 13:20:11  MG00000001  2017-04-12 13:20:11  MG00000001  View Edit Delete
9375  AG02000034 02  2695 51  703  30600  レンコン  れんこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26687703  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9434  AG02000012 02  2690 51  589  33600  パセリ  ぱせり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26577589  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9435  AG02000012 02  2711 51  897  90002  葉物  はもの  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26577897  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
9439  AG01001269 01  2448 006  7004  33600  パセリ  ぱせり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217004      2017-04-14 00:00:00    2017-04-14 16:47:48  MG00000001  2017-04-14 16:47:48  MG00000001  View Edit Delete
9441  AG01001269 01  2448 006  7004  32300  ふき  ふき  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217004      2017-04-17 00:00:00    2017-04-17 11:51:16  MG00000001  2017-04-17 11:51:16  MG00000001  View Edit Delete
9482  AG01001888 01  2470 006  7026  32600  春菊  しゅんぎく  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217026      2017-04-20 00:00:00    2017-04-20 16:57:43  MG00000001  2017-04-20 16:57:43  MG00000001  View Edit Delete
9511  AG02000013 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26578519  12  2017-04-24 00:00:00      MG00000001    MG00000000  View Edit Delete
9515  AG01001265 01  2787 006  7158  36100  さつま芋  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
217158      2017-04-25 00:00:00    2017-04-25 15:53:15  MG00000001  2017-04-25 15:53:15  MG00000001  View Edit Delete
9517  AG02000035 02  2626 51  149  31700  キャベツ  きゃべつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26688149  12  2017-04-25 00:00:00      MG00000001    MG00000000  View Edit Delete

Page 86 of 15485, showing 20 records out of 309681 total, starting on record 1701, ending on 1720

(default) 2 queries took 935 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 ORDER BY `FarmerProduct`.`id` asc LIMIT 1700, 2020209
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 = 111926