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
5268  AG01001155 01  1145 005  16044  38400  えのき パック  えのきぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216044  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5269  AG01001155 01  1146 005  16051  38600  ひらたけ 1P  ひらたけ1  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216051  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5270  AG01001155 01  1147 005  16061  38604  えりんぎ 1P  えりんぎ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216061  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5271  AG01001155 01  1148 005  16064  38604  えりんぎ パック  えりんぎぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216064  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5272  AG01001155 01  1149 005  16071  38300  なめこ 1P  なめこ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216071  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5273  AG01001155 01  1150 005  16081  38620  まいたけ 1P  まいたけ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216081  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5274  AG01001155 01  1151 005  16082  38620  まいたけ 2P  まいたけ2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216082  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5275  AG01001155 01  1152 005  16084  38620  まいたけ パック  まいたけぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0216084  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5276  AG01001155 01  1153 005  17011  90001  野菜 1P  やさい1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217011  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5277  AG01001155 01  1154 005  17012  90001  野菜 2P  やさい2  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217012  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5278  AG01001155 01  1155 005  17013  90001  野菜 3P  やさい3  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217013  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5279  AG01001155 01  1156 005  17014  90001  野菜 パック  やさいぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217014  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5280  AG01001155 01  1157 005  17021  37440  かいわれ 1P  かいわれ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217021  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5281  AG01001155 01  1158 005  17031  37700  ハーブ 1P  はーぶ1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217031  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5282  AG01001155 01  1159 005  17041  32300  ふき 1P  ふき1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217041  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5283  AG01001155 01  1160 005  17051  37560  大葉 1P  おおば1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217051  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5284  AG01001155 01  1161 005  17061  37200  しょうが 1P  しょうが1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217061  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5285  AG01001155 01  1162 005  17071  39330  すだち 1P  すだち1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217071  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5286  AG01001155 01  1163 005  17074  39330  すだち パック  すだちぱっく  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217074  12  2016-07-01 00:00:00    2016-08-30 12:26:53  MG00000001  2016-08-30 12:26:53  MG00000001  View Edit Delete
5287  AG01001155 01  1164 005  17081  39310  柚子 1P  ゆず1  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217081  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 42 of 15485, showing 20 records out of 309681 total, starting on record 821, ending on 840

(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 ORDER BY `FarmerProduct`.`id` asc LIMIT 820, 2020205
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 = 111917