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
AG01004423  01004423  T(直)社ふぁーむ  やしろふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 08:01:43  2021-03-15 00:00:00    2021-03-15 10:51:45  MG00000005  2021-03-15 10:51:45  MG00000005  View Edit Delete
AG01004424  01004424  T(直)まるふく農園  まるふくのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 12:02:07  2021-03-15 00:00:00    2021-03-15 11:01:57  MG00000005  2021-03-15 11:01:57  MG00000005  View Edit Delete
AG01004425  01004425  T(直)佐藤多美子  さとうたみこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-18 15:51:02  2021-03-18 00:00:00    2021-03-18 10:52:37  MG00000005  2021-03-18 10:52:37  MG00000005  View Edit Delete
AG01004426  01004426  T(直)中須加淳一  なすかじゅんいち  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-06 13:20:29  2021-03-18 00:00:00    2021-03-18 11:23:23  MG00000005  2021-03-18 11:23:23  MG00000005  View Edit Delete
AG01004427  01004427  T(直)じゅんこ  じゅんこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-18 12:59:46  2021-03-18 00:00:00    2021-03-18 11:29:33  MG00000005  2021-03-18 11:29:33  MG00000005  View Edit Delete
AG01004428  01004428  T(直)森谷英憲  もりたにひであき  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 09:43:45  2021-03-18 00:00:00    2021-03-18 11:33:43  MG00000005  2021-03-18 11:33:43  MG00000005  View Edit Delete
AG01004429  01004429  T(直)虎倉ファームあっくん  こくらふぁーむあっくん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-11 12:28:37  2021-03-18 00:00:00    2021-03-18 11:52:08  MG00000005  2021-03-18 11:52:08  MG00000005  View Edit Delete
AG01004430  01004430  T(直)旬の蔵  しゅんのくら  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-14 13:31:43  2021-03-18 00:00:00    2021-03-18 13:47:12  MG00000005  2021-03-18 13:47:12  MG00000005  View Edit Delete
AG01004431  01004431  T(直)大園斉幸  おおぞのよしゆき  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2021-03-18 00:00:00    2021-03-18 13:52:50  MG00000005  2021-03-18 13:52:50  MG00000005  View Edit Delete
AG01004432  01004432  T(直)果の実ファーム  かのみふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-26 13:25:55  2021-03-18 00:00:00    2021-03-18 15:56:52  MG00000005  2021-03-18 15:56:52  MG00000005  View Edit Delete
AG01004433  01004433  T(直)坪井尚  つぼいなお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-04 06:30:52  2021-03-18 00:00:00    2021-03-18 16:03:00  MG00000005  2021-03-18 16:03:00  MG00000005  View Edit Delete
AG01004434  01004434  T(直)アイアイファーム  あいあいふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 10:55:47  2021-03-18 00:00:00    2021-03-18 16:11:11  MG00000005  2021-03-18 16:11:11  MG00000005  View Edit Delete
AG01004435  01004435  T(直)光畑久仁子  みつはたくにこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-16 07:58:39  2021-03-19 00:00:00    2021-03-19 08:52:54  MG00000005  2021-03-19 08:52:54  MG00000005  View Edit Delete
AG01004436  01004436  T(直)加藤文隆  かとうふみたか  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-08-28 15:04:05  2021-03-19 00:00:00    2021-03-19 08:59:44  MG00000005  2021-03-19 08:59:44  MG00000005  View Edit Delete
AG01004437  01004437  T(直)うさっくまファーム  うさっくまふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-30 15:07:43  2021-03-19 00:00:00    2021-03-19 17:21:44  MG00000005  2021-03-19 17:21:44  MG00000005  View Edit Delete
AG01004438  01004438  T(直)吉田秀敏  よしだひでとし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2022-07-09 11:26:40  2021-03-19 00:00:00    2021-03-19 17:37:02  MG00000005  2021-03-19 17:38:21  MG00000005  View Edit Delete
AG01004439  01004439  T(直)たけもと自然農園  たけもとしぜんのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2021-07-21 13:23:19  2021-03-19 00:00:00    2021-03-19 17:45:34  MG00000005  2021-03-19 17:45:34  MG00000005  View Edit Delete
AG01004440  01004440  T(直)羽浦政博  はうらまさひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 16:46:08  2021-03-19 00:00:00    2021-03-19 18:16:06  MG00000005  2021-03-19 18:16:06  MG00000005  View Edit Delete
AG01004441  01004441  T(直)おくの農園  おくののうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 13:53:19  2021-03-19 00:00:00    2021-03-19 18:27:50  MG00000005  2021-03-19 18:27:50  MG00000005  View Edit Delete
AG01004442  01004442  T(直)梶田堅一  かじたけんいち  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-14 18:00:21  2021-03-20 00:00:00    2021-03-20 22:41:09  MG00000005  2021-03-20 22:41:09  MG00000005  View Edit Delete

Page 74 of 256, showing 20 records out of 5104 total, starting on record 1461, ending on 1480

(default) 2 queries took 166 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 LIMIT 1460, 20202091
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