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
8592  AG02000001 02  2622 51  138  36300  里芋  さといも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565138  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8593  AG02000001 02  2623 51  139  32100  ワケギ  わけぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565139  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8594  AG02000001 02  2624 51  145  32900  セロリー  せろりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565145  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8595  AG02000001 02  2626 51  149  31700  キャベツ  きゃべつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565149  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8596  AG02000001 02  2629 51  152  32800  ニラ  にら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565152  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8597  AG02000001 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565154  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8598  AG02000001 02  2631 51  158  33810  チンゲン菜  ちんげんさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565158  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8599  AG02000001 02  2633 51  161  31100  白菜  はくさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565161  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8600  AG02000001 02  2634 51  162  35400  空豆  そらまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565162  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8601  AG02000001 02  2636 51  168  90002  大根菜  だいこんな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565168  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8602  AG02000001 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565169  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8603  AG02000001 02  2638 51  170  33200  カリフラワー  かりふらわー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565170  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8604  AG02000001 02  2641 51  178  41410  レモン  れもん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565178  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8605  AG02000001 02  2642 51  179  39330  すだち  すだち  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565179  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8606  AG02000001 02  2644 51  183  90003  キヌサヤ  きぬさや  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565183  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8607  AG02000001 02  2646 51  187  34600  シシトウ  ししとう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565187  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8608  AG02000001 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565193  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8609  AG02000001 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565199  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8610  AG02000001 02  2653 51  204  47000  メロン  めろん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565204  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8611  AG02000001 02  2654 51  216  45000  ぶどう  ぶどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565216  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 60 of 15485, showing 20 records out of 309681 total, starting on record 1181, ending on 1200

(default) 2 queries took 938 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 1180, 2020208
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 = 111930