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
8712  AG02000003 02  2607 51  107  34100  キュウリ  きゅうり  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567107  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8713  AG02000003 02  2608 51  108  31900  ネギ  ねぎ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567108  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8714  AG02000003 02  2609 51  111  36100  サツマイモ  さつまいも  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567111  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8715  AG02000003 02  2610 51  112  34300  ナス  なす  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567112  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8716  AG02000003 02  2611 51  114  34200  カボチャ  かぼちゃ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567114  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8717  AG02000003 02  2613 51  117  35500  枝豆  えだまめ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567117  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8718  AG02000003 02  2614 51  118  33400  レタス  れたす  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567118  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8719  AG02000003 02  2615 51  119  34500  ピーマン  ぴーまん  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567119  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8720  AG02000003 02  2616 51  120  34800  オクラ  おくら  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567120  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8721  AG02000003 02  2619 51  129  31500  小松菜  こまつな  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567129  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8722  AG02000003 02  2620 51  133  30400  ゴボウ  ごぼう  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567133  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8723  AG02000003 02  2622 51  138  36300  里芋  さといも  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567138  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8724  AG02000003 02  2623 51  139  32100  ワケギ  わけぎ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567139  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8725  AG02000003 02  2624 51  145  32900  セロリー  せろりー  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567145  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8726  AG02000003 02  2626 51  149  31700  キャベツ  きゃべつ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567149  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8727  AG02000003 02  2629 51  152  32800  ニラ  にら  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567152  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8728  AG02000003 02  2630 51  154  31800  ほうれん草  ほうれんそう  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567154  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8729  AG02000003 02  2631 51  158  33810  チンゲン菜  ちんげんさい  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567158  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8730  AG02000003 02  2633 51  161  31100  白菜  はくさい  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567161  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete
8731  AG02000003 02  2634 51  162  35400  空豆  そらまめ  001香川県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26567162  12  2017-02-27 00:00:00      MG00000001    MG00000001  View Edit Delete

Page 66 of 15485, showing 20 records out of 309681 total, starting on record 1301, ending on 1320

(default) 2 queries took 933 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 1300, 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 = 111924