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
8652  AG02000002 02  2609 51  111  36100  サツマイモ  さつまいも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566111  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8653  AG02000002 02  2610 51  112  34300  ナス  なす  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8654  AG02000002 02  2611 51  114  34200  カボチャ  かぼちゃ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566114  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8655  AG02000002 02  2613 51  117  35500  枝豆  えだまめ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566117  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8656  AG02000002 02  2614 51  118  33400  レタス  れたす  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566118  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8657  AG02000002 02  2615 51  119  34500  ピーマン  ぴーまん  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566119  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8658  AG02000002 02  2616 51  120  34800  オクラ  おくら  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566120  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8659  AG02000002 02  2619 51  129  31500  小松菜  こまつな  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566129  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8660  AG02000002 02  2620 51  133  30400  ゴボウ  ごぼう  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566133  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8661  AG02000002 02  2622 51  138  36300  里芋  さといも  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566138  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8662  AG02000002 02  2623 51  139  32100  ワケギ  わけぎ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566139  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8663  AG02000002 02  2624 51  145  32900  セロリー  せろりー  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566145  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8664  AG02000002 02  2626 51  149  31700  キャベツ  きゃべつ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566149  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8665  AG02000002 02  2629 51  152  32800  ニラ  にら  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566152  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8666  AG02000002 02  2630 51  154  31800  ほうれん草  ほうれんそう  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566154  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8667  AG02000002 02  2631 51  158  33810  チンゲン菜  ちんげんさい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566158  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8668  AG02000002 02  2633 51  161  31100  白菜  はくさい  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566161  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8669  AG02000002 02  2634 51  162  35400  空豆  そらまめ  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566162  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8670  AG02000002 02  2636 51  168  90002  大根菜  だいこんな  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566168  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8671  AG02000002 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  005高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26566169  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 63 of 15485, showing 20 records out of 309681 total, starting on record 1241, ending on 1260

(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 LIMIT 1240, 2020207
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