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
16685390  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
16685389  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
16685388  AG04000166 04  51366 710  99533  90001  カーボロネロ  かーぼろねろ  埼玉県 
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
16685387  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
16685386  AG04000166 04  51366 710  99533  33200  カリフローレ  かりふろーれ  埼玉県 
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
16685385  AG04000166 04  51366 710  99533  33200  カリフラワー  かりふらわー  埼玉県 
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
16685384  AG04000166 04  51366 710  99533  34500  カラーピーマン  からーぴーまん  埼玉県 
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
16685383  AG04000166 04  51366 710  99533  30300  カラフル人参  からふるにんじん  埼玉県 
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
16685382  AG04000166 04  51366 710  99533  31100  オレンジ白菜  おれんじはくさい  埼玉県 
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
16685381  AG04000166 04  51366 710  99533  34800  オクラ  おくら  埼玉県 
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
16685380  AG04000166 04  51366 710  99533  91012  エンツァイ  えんつぁい  埼玉県 
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
16685379  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
16685378  AG04000166 04  51366 710  99533  36800  エシャレット  えしゃれっと  埼玉県 
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
16685377  AG04000166 04  51366 710  99533  37500  エゴマ  えごま  埼玉県 
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
16685376  AG04000166 04  51366 710  99533  33600  イタリアンパセリ  いたりあんぱせり  埼玉県 
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
16685375  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
16685374  AG04000166 04  51366 710  99533  36200  アンデスレッド  あんですれっど  埼玉県 
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
16685373  AG04000166 04  51366 710  99533  90000  アロエベラ  あろえべら  埼玉県 
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
16685372  AG04000166 04  51366 710  99533  33920  アスパラ菜  あすぱらな  埼玉県 
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
16685371  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

Page 112 of 15485, showing 20 records out of 309681 total, starting on record 2221, ending on 2240

(default) 2 queries took 926 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 2220, 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 = 111912