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
8852  AG02000005 02  2626 51  149  31700  キャベツ  きゃべつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569149  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8853  AG02000005 02  2629 51  152  32800  ニラ  にら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569152  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8854  AG02000005 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569154  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8855  AG02000005 02  2631 51  158  33810  チンゲン菜  ちんげんさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569158  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8856  AG02000005 02  2633 51  161  31100  白菜  はくさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569161  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8857  AG02000005 02  2634 51  162  35400  空豆  そらまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569162  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8858  AG02000005 02  2636 51  168  90002  大根菜  だいこんな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569168  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8859  AG02000005 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569169  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8860  AG02000005 02  2638 51  170  33200  カリフラワー  かりふらわー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569170  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8861  AG02000005 02  2641 51  178  41410  レモン  れもん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569178  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8862  AG02000005 02  2642 51  179  39330  すだち  すだち  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569179  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8863  AG02000005 02  2644 51  183  90003  キヌサヤ  きぬさや  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569183  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8864  AG02000005 02  2646 51  187  34600  シシトウ  ししとう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569187  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8865  AG02000005 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569193  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8866  AG02000005 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569199  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8867  AG02000005 02  2653 51  204  47000  メロン  めろん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569204  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8868  AG02000005 02  2654 51  216  45000  ぶどう  ぶどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569216  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8869  AG02000005 02  2655 51  217  44000  桃  もも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569217  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8870  AG02000005 02  2656 51  218  48000  スイカ  すいか  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569218  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete
8871  AG02000005 02  2657 51  219  45700  栗  くり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26569219  12  2017-02-27 00:00:00      MG00000001    MG00000000  View Edit Delete

Page 73 of 15485, showing 20 records out of 309681 total, starting on record 1441, ending on 1460

(default) 2 queries took 922 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 1440, 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 = 111913