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
AG02000091  02000091  Tよつばマルシェ 91  よつばまるしぇきゅうじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-11-22 12:46:25  2018-04-20 00:00:00    2018-04-20 19:03:32  MG00000001  2018-04-27 11:57:21  MG00000001  View Edit Delete
AG02000092  02000092  Tよつばマルシェ 92  よつばまるしぇきゅうじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-09-05 14:06:13  2018-04-27 00:00:00    2018-04-27 11:58:27  MG00000001  2018-04-27 11:58:27  MG00000001  View Edit Delete
AG02000093  02000093  Tよつばマルシェ 93  よつばまるしぇきゅうじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-02-09 13:15:11  2018-05-16 00:00:00    2018-05-16 10:23:28  MG00000001  2018-09-03 11:17:18  MG00000001  View Edit Delete
AG02000094  02000094  Tよつばマルシェ 94  よつばまるしぇきゅうじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-09-05 13:03:14  2018-05-16 00:00:00    2018-05-16 10:24:10  MG00000001  2018-09-03 11:17:41  MG00000001  View Edit Delete
AG02000095  02000095  Tよつばマルシェ 95  よつばまるしぇきゅうじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-09-10 12:47:24  2018-05-21 00:00:00    2018-05-21 13:24:51  MG00000001  2018-05-21 13:24:51  MG00000001  View Edit Delete
AG02000096  02000096  Tよつばマルシェ 96  よつばまるしぇきゅうじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-10-17 15:15:43  2018-05-21 00:00:00    2018-05-21 13:26:52  MG00000001  2018-05-21 13:26:52  MG00000001  View Edit Delete
AG02000097  02000097  Tよつばマルシェ 97  よつばまるしぇきゅうじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 12:02:34  2018-05-25 00:00:00    2018-05-25 14:16:24  MG00000001  2018-05-25 14:16:24  MG00000001  View Edit Delete
AG02000098  02000098  Tよつばマルシェ 98  よつばまるしぇきゅうじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-10 16:51:36  2018-05-25 00:00:00    2018-05-25 14:17:38  MG00000001  2018-05-25 14:17:38  MG00000001  View Edit Delete
AG02000099  02000099  Tよつばマルシェ 99  よつばまるしぇきゅうじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 17:52:25  2018-05-28 00:00:00    2018-05-28 15:12:26  MG00000001  2018-05-28 15:12:26  MG00000001  View Edit Delete
AG02000100  02000100  Tよつばマルシェ 100  よつばまるしぇひゃく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-08-19 14:39:22  2018-05-29 00:00:00    2018-05-29 10:53:49  MG00000001  2018-05-29 10:53:49  MG00000001  View Edit Delete
AG02000101  02000101  Tよつばマルシェ 101  よつばまるしぇひゃくいち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-05-01 09:50:47  2018-06-12 00:00:00    2018-06-12 09:34:22  MG00000001  2018-06-12 09:34:22  MG00000001  View Edit Delete
AG02000102  02000102  Tよつばマルシェ 102  よつばまるしぇひゃくに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-24 16:10:54  2018-06-12 00:00:00    2018-06-12 09:35:16  MG00000001  2018-06-12 09:35:16  MG00000001  View Edit Delete
AG02000103  02000103  Tよつばマルシェ 103  よつばまるしぇひゃくさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-12-20 13:56:52  2018-06-21 00:00:00    2018-06-21 12:55:12  MG00000001  2018-11-01 09:16:44  MG00000001  View Edit Delete
AG02000104  02000104  Tよつばマルシェ 104  よつばまるしぇひゃくよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-07-23 14:10:02  2018-07-03 00:00:00    2018-07-03 12:17:51  MG00000001  2018-07-03 12:17:51  MG00000001  View Edit Delete
AG02000105  02000105  Tよつばマルシェ 105  よつばまるしぇひゃくご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-07-22 15:07:29  2018-07-11 00:00:00    2018-07-11 10:08:24  MG00000001  2018-07-11 10:08:24  MG00000001  View Edit Delete
AG02000106  02000106  Tよつばマルシェ 106  よつばまるしぇひゃくろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-08-18 13:58:28  2018-07-30 00:00:00    2018-07-30 11:38:13  MG00000001  2018-07-30 11:38:13  MG00000001  View Edit Delete
AG02000107  02000107  Tよつばマルシェ 107  よつばまるしぇひゃくなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 09:28:56  2018-08-16 00:00:00    2018-08-16 12:47:06  MG00000001  2018-08-16 12:47:06  MG00000001  View Edit Delete
AG02000108  02000108  Tよつばマルシェ 108  よつばまるしぇひゃくはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-09-29 17:06:14  2018-08-16 00:00:00    2018-08-16 12:47:48  MG00000001  2018-08-16 12:47:48  MG00000001  View Edit Delete
AG02000109  02000109  Tよつばマルシェ 109  よつばまるしぇひゃくきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-07-20 09:04:48  2018-08-16 00:00:00    2018-08-16 12:48:35  MG00000001  2018-08-16 12:48:35  MG00000001  View Edit Delete
AG02000110  02000110  Tよつばマルシェ 110  よつばまるしぇひゃくじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-01-05 10:16:45  2018-08-16 00:00:00    2018-08-16 12:49:26  MG00000001  2018-08-16 12:49:26  MG00000001  View Edit Delete

Page 159 of 256, showing 20 records out of 5104 total, starting on record 3161, ending on 3180

(default) 2 queries took 221 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 3160, 202020146
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