Users

Id Login User Nm User Fk User Type Password Mail Address 1 Mail Address 2 Login Rock Flg Last Login Day Use Start Day Use End Day Del Flg Init Pass Flg Created Insert User Modified Update User Actions
AG01004651  01004651  T(直)ノービスファーム  のーびすふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-28 07:58:11  2022-03-31 00:00:00    2022-03-31 00:45:40  MG00000001  2022-03-31 00:45:40  MG00000001  View Edit Delete
AG01004652  01004652  T株式会社アグリアート  かぶしきがいしゃあぐりあーと  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-05-09 17:01:51  2022-04-08 00:00:00    2022-04-08 11:04:06  MG00000001  2022-05-12 10:27:44  MG00000001  View Edit Delete
AG01004653  01004653  Tげんきファーム  げんきふぁーむ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-05-29 18:33:31  2022-04-14 00:00:00    2022-04-14 16:38:26  MG00000001  2022-04-14 16:38:26  MG00000001  View Edit Delete
AG01004654  01004654  T佐野光春  さのみつはる  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2024-01-10 16:34:19  2022-04-19 00:00:00    2022-04-19 13:00:04  MG00000001  2022-04-19 13:00:04  MG00000001  View Edit Delete
AG01004655  01004655  T渡部裕之  わたべひろゆき  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-09-20 08:35:34  2022-05-02 00:00:00    2022-05-02 10:00:45  MG00000001  2022-05-02 10:00:45  MG00000001  View Edit Delete
AG01004656  01004656  Tトマト  とまと  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2023-03-30 02:18:23  2022-05-09 00:00:00    2022-05-09 08:42:37  MG00000001  2022-05-09 08:42:37  MG00000001  View Edit Delete
AG01004657  01004657  Tミニトマト  みにとまと  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-07-16 14:32:21  2022-05-09 00:00:00    2022-05-09 10:46:04  MG00000001  2022-05-09 11:28:07  MG00000001  View Edit Delete
AG01004658  01004658  T新たまねぎ  しんたまねぎ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 14:23:54  2022-05-09 00:00:00    2022-05-09 10:58:07  MG00000001  2022-05-09 10:58:07  MG00000001  View Edit Delete
AG01004659  01004659  T赤たまねぎ  あかたまねぎ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-12 10:53:41  2022-05-09 00:00:00    2022-05-09 11:07:53  MG00000001  2022-05-09 11:07:53  MG00000001  View Edit Delete
AG01004660  01004660  Tほうれん草  ほうれんそう  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-10 15:09:19  2022-05-09 00:00:00    2022-05-09 11:11:35  MG00000001  2022-05-09 11:11:35  MG00000001  View Edit Delete
AG01004661  01004661  Tサラダほうれん草  さらだほうれんそう  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40        2022-05-09 00:00:00    2022-05-09 11:17:55  MG00000001  2022-05-09 11:17:55  MG00000001  View Edit Delete
AG01004662  01004662  Tフリルレタス  ふりるれたす  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 14:51:59  2022-05-09 00:00:00    2022-05-09 11:23:50  MG00000001  2022-05-09 11:23:50  MG00000001  View Edit Delete
AG01004663  01004663  Tサニーレタス  さにーれたす  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 15:26:52  2022-05-09 00:00:00    2022-05-09 11:28:55  MG00000001  2022-05-09 11:28:55  MG00000001  View Edit Delete
AG01004664  01004664  T小松菜  こまつな  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 15:08:05  2022-05-09 00:00:00    2022-05-09 11:30:40  MG00000001  2022-05-09 11:30:40  MG00000001  View Edit Delete
AG01004665  01004665  Tそらまめ  そらまめ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40        2022-05-09 00:00:00    2022-05-09 11:44:25  MG00000001  2022-05-09 11:44:25  MG00000001  View Edit Delete
AG01004666  01004666  Tそらまめ(赤)  そらまめあか  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40        2022-05-09 00:00:00    2022-05-09 11:47:07  MG00000001  2022-05-09 11:47:07  MG00000001  View Edit Delete
AG01004667  01004667  Tブロッコリー  ぶろっこりー  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-12 10:46:35  2022-05-09 00:00:00    2022-05-09 11:48:59  MG00000001  2022-05-09 11:48:59  MG00000001  View Edit Delete
AG01004668  01004668  T九条葱(京都府産)  くじょうねぎ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-07-14 11:16:11  2022-05-09 00:00:00    2022-05-09 11:50:55  MG00000001  2022-05-09 11:50:55  MG00000001  View Edit Delete
AG01004669  01004669  Tチンゲン菜  ちんげんさい  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-12 13:00:49  2022-05-09 00:00:00    2022-05-09 11:53:10  MG00000001  2022-05-09 11:53:10  MG00000001  View Edit Delete
AG01004670  01004670  Tスナップえんどう  すなっぷえんどう  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-16 14:22:16  2022-05-09 00:00:00    2022-05-09 12:01:18  MG00000001  2022-05-09 12:01:18  MG00000001  View Edit Delete

Page 89 of 256, showing 20 records out of 5104 total, starting on record 1761, ending on 1780

(default) 2 queries took 350 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user`, `Admin`.`user_id`, `Admin`.`mail_flg`, `Admin`.`created`, `Admin`.`insert_user`, `Admin`.`modified`, `Admin`.`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`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user`, `TradersPickupPoint`.`pickup_point_id`, `TradersPickupPoint`.`trader_user_id`, `TradersPickupPoint`.`use_start_day`, `TradersPickupPoint`.`use_end_day`, `TradersPickupPoint`.`created`, `TradersPickupPoint`.`insert_user`, `TradersPickupPoint`.`modified`, `TradersPickupPoint`.`update_user` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `User`.`del_flg` desc LIMIT 1760, 202020275
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 11175