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
AG02000031  02000031  Tよつばマルシェ 31  よつばまるしぇさんじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-04-28 13:00:45  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:57:10  MG00000002  View Edit Delete
AG02000032  02000032  Tよつばマルシェ 32  よつばまるしぇさんじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  haruga.cat.hous@docomo.ne.jp    2022-06-30 11:12:39  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:56:27  MG00000002  View Edit Delete
AG02000033  02000033  Tよつばマルシェ 33  よつばまるしぇさんじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-12-01 13:36:38  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:55:47  MG00000002  View Edit Delete
AG02000034  02000034  Tよつばマルシェ 34  よつばまるしぇさんじゅうし  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2021-03-06 14:00:15  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:55:04  MG00000002  View Edit Delete
AG02000035  02000035  Tよつばマルシェ 35  よつばまるしぇさんじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-12-02 12:04:14  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:54:07  MG00000002  View Edit Delete
AG02000036  02000036  Tよつばマルシェ 36  よつばまるしぇさんじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-12 10:20:51  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:54:07  MG00000002  View Edit Delete
AG02000037  02000037  Tよつばマルシェ 37  よつばまるしぇさんじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-19 11:56:44  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:54:07  MG00000002  View Edit Delete
AG02000038  02000038  Tよつばマルシェ 38  よつばまるしぇさんじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2021-12-20 13:15:29  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-03-20 17:14:00  MG00000002  View Edit Delete
AG02000039  02000039  Tよつばマルシェ 39  よつばまるしぇさんじゅうく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-09-28 14:41:17  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:54:07  MG00000002  View Edit Delete
AG02000040  02000040  Tよつばマルシェ 40  よつばまるしぇよんじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-08-13 15:02:46  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 19:54:07  MG00000002  View Edit Delete
AG02000041  02000041  Tよつばマルシェ 41  よつばまるしぇよんじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-11-02 12:44:27  2017-08-02 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:14:34  MG00000001  View Edit Delete
AG02000042  02000042  Tよつばマルシェ 42  よつばまるしぇよんじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 10:07:02  2017-08-02 00:00:00    2017-02-01 00:00:00  MG00000001  2017-12-28 13:04:52  MG00000002  View Edit Delete
AG02000043  02000043  Tよつばマルシェ 43  よつばまるしぇよんじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2018-10-20 16:56:36  2017-08-29 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000044  02000044  Tよつばマルシェ 44  よつばまるしぇよんじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-05-31 15:07:03  2017-09-05 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000045  02000045  Tよつばマルシェ 45  よつばまるしぇよんじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-12-23 13:48:17  2017-09-05 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000046  02000046  Tよつばマルシェ 46  よつばまるしぇよんじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-06-06 11:52:37  2017-09-05 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000047  02000047  Tよつばマルシェ 47  よつばまるしぇよんじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-12-18 14:31:07  2017-09-06 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000048  02000048  Tよつばマルシェ 48  よつばまるしぇよんじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 17:13:19  2017-09-06 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000049  02000049  Tよつばマルシェ 49  よつばまるしぇよんじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-12-18 14:49:30  2017-09-06 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000050  02000050  Tよつばマルシェ 50  よつばまるしぇごじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-08-07 13:10:43  2017-09-11 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete

Page 156 of 256, showing 20 records out of 5104 total, starting on record 3101, ending on 3120

(default) 2 queries took 265 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 3100, 202020149
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 = 111116