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
52718  AG02000069 02  5489 52  1798  36100  さつま芋(鳴門金時)  さつまいもなるときんとき  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52719  AG02000069 02  5489 52  1798  31900  ねぎ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52720  AG02000069 02  5489 52  1798  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52721  AG02000069 02  5489 52  1798  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52722  AG02000069 02  5489 52  1798  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52723  AG02000069 02  5489 52  1798  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52724  AG02000069 02  5489 52  1798  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791798  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52725  AG02000070 02  5490 52  1799  36100  さつま芋(鳴門金時)  さつまいもなるときんとき  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791799  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52726  AG02000070 02  5490 52  1799  33200  カリフラワー  かりふらわー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791799  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52727  AG02000070 02  5490 52  1799  34270  ズッキーニ  ずっきーに  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791799  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52728  AG02000070 02  5490 52  1799  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791799  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52729  AG02000071 02  5491 52  1819  34500  こどもピーマン  こどもぴーまん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52730  AG02000071 02  5491 52  1819  33810  チンゲン菜  ちんげんさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52731  AG02000071 02  5491 52  1819  34570  パプリカ  ぱぷりか  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52732  AG02000071 02  5491 52  1819  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52733  AG02000071 02  5491 52  1819  33420  リーフレタス  りーふれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52734  AG02000071 02  5491 52  1819  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52735  AG02000071 02  5491 52  1819  31310  水菜  みずな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52736  AG02000071 02  5491 52  1819  32600  菊菜  きくな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52737  AG02000071 02  5491 52  1819  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791819  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete

Page 235 of 15485, showing 20 records out of 309681 total, starting on record 4681, ending on 4700

(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 4680, 20202025
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