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
5308  AG01001155 01  1185 005  18151  91000  メンマ水煮 1P  めんまみずに1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218151  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5309  AG01001155 01  1186 005  18161  91000  れんこん水煮 1P  れんこんみずに1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218161  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5310  AG01001155 01  1187 005  18171  91000  銀杏水煮 1P  ぎんなんみずに1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218171  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5311  AG01001155 01  1188 005  18181  91000  大豆水煮 1P  だいずみずに1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218181  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5312  AG01001155 01  1189 005  18191  91000  カットコーン 1P  かっとこーん1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218191  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5313  AG01001155 01  1190 005  18201  91000  レトルトコーン 1P  れとるとこーん1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218201  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5314  AG01001155 01  1191 005  18211  91000  千切り大根 1P  せんぎりだいこん1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218211  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5315  AG01001155 01  1192 005  18221  91000  タカのつめ 1P  たかのつめ1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218221  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5316  AG01001155 01  1193 005  18231  91000  にんにくスライス 1P  にんにくすらいす1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218231  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5317  AG01001155 01  1194 005  18241  91000  くずきり 1P  くずきり1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218241  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5318  AG01001155 01  1195 005  18251  91000  筑前煮 1P  ちくぜんに1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0218251  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5319  AG01001155 01  1197 005  21011  46000  いちご 1P  いちご1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221011  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5320  AG01001155 01  1198 005  21014  46000  いちご パック  いちごぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221014  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5321  AG01001155 01  1199 005  21021  44000  桃 1P  もも1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221021  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5322  AG01001155 01  1200 005  21022  44000  桃 2P  もも2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221022  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5323  AG01001155 01  1201 005  21023  44000  桃 3P  もも3  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221023  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5324  AG01001155 01  1202 005  21024  44000  桃 パック  ももぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221024  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5325  AG01001155 01  1203 005  21031  44500  すもも 1P  すもも1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221031  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5326  AG01001155 01  1204 005  21034  44500  すもも パック  すももぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221034  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5327  AG01001155 01  1205 005  21041  43000  梨 1P  なし1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0221041  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete

Page 44 of 15485, showing 20 records out of 309681 total, starting on record 861, ending on 880

(default) 2 queries took 912 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 860, 2020206
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 = 111906