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
AG02000051  02000051  Tよつばマルシェ 51  よつばまるしぇごじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-09-30 03:00:25  2017-09-13 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000052  02000052  Tよつばマルシェ 52  よつばまるしぇごじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-12 16:54:48  2017-09-20 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000053  02000053  Tよつばマルシェ 53  よつばまるしぇごじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 12:36:25  2017-09-20 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000054  02000054  Tよつばマルシェ 54  よつばまるしぇごじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-09-14 06:36:38  2017-09-20 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000055  02000055  Tよつばマルシェ 55  よつばまるしぇごじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-05-09 10:12:50  2017-09-28 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000056  02000056  Tよつばマルシェ 56  よつばまるしぇごじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-17 15:35:11  2017-10-17 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000057  02000057  Tよつばマルシェ 57  よつばまるしぇごじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-09-20 12:48:26  2017-10-17 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000058  02000058  Tよつばマルシェ 58  よつばまるしぇごじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-09-14 06:37:09  2017-10-17 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000059  02000059  Tよつばマルシェ 59  よつばまるしぇごじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-24 13:34:39  2017-10-17 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000060  02000060  Tよつばマルシェ 60  よつばまるしぇろくじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-24 14:53:41  2017-10-30 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000061  02000061  Tよつばマルシェ 61  よつばまるしぇろくじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-22 11:48:52  2017-11-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-10-04 14:49:19  MG00000001  View Edit Delete
AG02000062  02000062  Tよつばマルシェ 62  よつばまるしぇろくじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-05-15 06:06:55  2017-12-04 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000063  02000063  Tよつばマルシェ 63  よつばまるしぇろくじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-23 17:51:45  2017-12-12 00:00:00    2017-02-01 00:00:00  MG00000001  2021-03-04 08:54:42  MG00000005  View Edit Delete
AG02000064  02000064  Tよつばマルシェ 64  よつばまるしぇろくじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-12-28 13:36:02  2017-12-12 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000065  02000065  Tよつばマルシェ 65  よつばまるしぇろくじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-05-30 11:28:13  2017-12-18 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000066  02000066  Tよつばマルシェ 66  よつばまるしぇろくじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-04-01 20:57:02  2017-12-19 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:16:32  MG00000001  View Edit Delete
AG02000067  02000067  Tよつばマルシェ 67  よつばまるしぇろくじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-01-06 14:25:06  2018-01-16 00:00:00    2018-01-16 00:00:00  MG00000001  2018-01-16 10:16:32  MG00000001  View Edit Delete
AG02000068  02000068  Tよつばマルシェ 68  よつばまるしぇろくじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2024-01-15 11:44:56  2018-01-16 00:00:00    2018-01-16 00:00:00  MG00000001  2018-01-16 10:16:32  MG00000001  View Edit Delete
AG02000069  02000069  Tよつばマルシェ 69  よつばまるしぇろくじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-09-28 10:54:01  2018-01-29 00:00:00    2018-01-29 00:00:00  MG00000001  2021-03-08 15:32:24  MG00000005  View Edit Delete
AG02000070  02000070  Tよつばマルシェ 70  よつばまるしぇななじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-06-02 12:42:30  2018-01-29 00:00:00    2018-01-29 00:00:00  MG00000001  2018-01-29 10:16:32  MG00000001  View Edit Delete

Page 157 of 256, showing 20 records out of 5104 total, starting on record 3121, ending on 3140

(default) 2 queries took 217 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 3120, 202020144
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 = 11173