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
16681283  AG01005897 01  50025 036  109075  34950  きゅうりビール漬  きゅうりびーるづけ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109075  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681282  AG01005897 01  50024 036  109074  39200  天日干梅干  てんぴぼしうめぼし  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109074  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681281  AG01005897 01  50023 036  109073  36200  ボイルじゃが芋  ぼいるじゃがいも  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109073  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681280  AG01005897 01  50022 036  109072  36300  ボイル里芋  ぼいるさといも  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109072  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681279  AG01005897 01  50021 036  109071  91000  かめ煮セット  かめにせっと  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109071  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681278  AG01005897 01  50020 036  109070  91000  カレーセット  かれーせっと  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109070  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681277  AG01005897 01  50019 036  109069  31900  ムキ玉葱  むきたまねぎ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109069  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681276  AG01005897 01  50018 036  109068  30500  湯がき竹の子  ゆがきたけのこ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109068  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681275  AG01005897 01  50017 036  109067  91000  ゆずこしょう赤  ゆずこしょうあか  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109067  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681274  AG01005897 01  50016 036  109066  91000  ゆずこしょう青  ゆずこしょうあお  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109066  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681273  AG01005897 01  50015 036  109065  91000  よもぎパン  よもぎぱん  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109065  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681272  AG01005897 01  50014 036  109064  91000  よもぎ饅頭  よもぎまんじゅう  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109064  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681271  AG01005897 01  50013 036  109063  91000  加工品  かこうひん  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25109063  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681270  AG01005964 01  50012 036  105732  91000  味の花  あじのはな  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105732  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681269  AG01005964 01  50011 036  105731  91000  子持昆布  こもちこんぶ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105731  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681268  AG01005964 01  50010 036  105730  91000  角切昆布  かくぎりこんぶ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105730  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681267  AG01005964 01  50009 036  105729  91000  からし昆布  からしこんぶ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105729  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681266  AG01005964 01  50008 036  105728  91000  しそ昆布  しそこんぶ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105728  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681265  AG01005964 01  50007 036  105727  90003  煮汁入筑前クロダマル黒豆  にじるいりちくぜんくろだまるくろまめ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105727  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete
16681264  AG01005964 01  50006 036  105726  90003  煮汁入丹波黒豆  にじるいりたんばくろまめ  (なし) 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25105726  12  2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete

Page 308 of 15485, showing 20 records out of 309681 total, starting on record 6141, ending on 6160

(default) 2 queries took 1001 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 6140, 20202038
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 = 111963