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
16685410  AG04000166 04  51366 710  99533  90007  ザクロ  ざくろ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685409  AG04000166 04  51366 710  99533  33400  サンチュ  さんちゅ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685408  AG04000166 04  51366 710  99533  33400  サラダ菜  さらだな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685407  AG04000166 04  51366 710  99533  31800  サラダほうれん草  さらだほうれんそう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685406  AG04000166 04  51366 710  99533  90002  サラダからし菜  さらだからしな  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685405  AG04000166 04  51366 710  99533  30200  サラダかぶ もものすけ  さらだかぶ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685404  AG04000166 04  51366 710  99533  30200  サラダかぶ  さらだかぶ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685403  AG04000166 04  51366 710  99533  31700  サボイキャベツ  さぼいきゃべつ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685402  AG04000166 04  51366 710  99533  33400  サニーレタス  さにーれたす  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685401  AG04000166 04  51366 710  99533  49300  ゴールドキウイ  ごーるどきうい  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685400  AG04000166 04  51366 710  99533  31700  コールラビ  こーるらび  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685399  AG04000166 04  51366 710  99533  34200  コリンキー  こりんきー  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685398  AG04000166 04  51366 710  99533  90002  ケール  けーる  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685397  AG04000166 04  51366 710  99533  33400  グリーンカール  ぐりーんかーる  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685396  AG04000166 04  51366 710  99533  33100  グリーンアスパラガス  ぐりーんあすぱらがす  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685395  AG04000166 04  51366 710  99533  35200  グリンピース  ぐりーんぴーす  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685394  AG04000166 04  51366 710  99533  37700  クレソン  くれそん  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685393  AG04000166 04  51366 710  99533  90008  キヨミ  きよみ  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685392  AG04000166 04  51366 710  99533  45000  キャンベル  きゃんべる  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete
16685391  AG04000166 04  51366 710  99533  31700  キャベツ 徳用  きゃべつ とくよう  埼玉県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2399533  12  2023-12-14 00:00:00    2023-12-14 09:03:06  MG00000001  2023-12-14 09:03:06  MG00000001  View Edit Delete

Page 111 of 15485, showing 20 records out of 309681 total, starting on record 2201, ending on 2220

(default) 2 queries took 953 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` desc LIMIT 2200, 20202014
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 = 111939