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
AG02000131  02000131  Tよつばマルシェ 131  よつばまるしぇひゃくさんじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-10-04 13:13:16  2019-02-05 00:00:00    2019-02-05 13:48:59  MG00000001  2019-02-05 13:48:59  MG00000001  View Edit Delete
AG02000132  02000132  Tよつばマルシェ 132  よつばまるしぇひゃくさんじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-05-24 09:02:02  2019-02-20 00:00:00    2019-02-20 09:51:47  MG00000001  2019-02-20 09:51:47  MG00000001  View Edit Delete
AG02000133  02000133  Tよつばマルシェ 133  よつばまるしぇひゃくさんじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-10-04 13:13:09  2019-03-29 00:00:00    2019-03-29 13:20:51  MG00000001  2019-04-08 10:44:31  MG00000001  View Edit Delete
AG02000134  02000134  Tよつばマルシェ 134  よつばまるしぇひゃくさんじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-03-16 13:30:53  2019-03-29 00:00:00    2019-03-29 13:21:41  MG00000001  2019-04-08 10:44:18  MG00000001  View Edit Delete
AG02000135  02000135  Tよつばマルシェ 135  よつばまるしぇひゃくさんじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-03-24 13:20:09  2019-06-25 00:00:00    2019-06-25 08:41:08  MG00000001  2019-06-25 08:41:08  MG00000001  View Edit Delete
AG02000136  02000136  Tよつばマルシェ136  よつばまるしぇひゃくさんじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-01-17 09:35:37  2019-09-02 00:00:00    2019-09-02 08:40:43  MG00000001  2019-09-02 08:40:43  MG00000001  View Edit Delete
AG02000137  02000137  Tよつばマルシェ137  よつばまるしぇひゃくさんじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2019-09-19 16:44:48  2019-09-02 00:00:00    2019-09-02 08:41:12  MG00000001  2019-09-02 08:41:12  MG00000001  View Edit Delete
AG02000138  02000138  Tよつばマルシェ138  よつばまるしぇひゃくさんじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2021-03-23 05:42:32  2019-09-02 00:00:00    2019-09-02 08:41:43  MG00000001  2019-09-02 08:41:43  MG00000001  View Edit Delete
AG02000139  02000139  Tよつばマルシェ 139  よつばまるしぇひゃくさんじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-07-30 09:23:33  2020-05-15 00:00:00    2020-05-15 10:54:24  MG00000001  2020-05-15 10:54:24  MG00000001  View Edit Delete
AG02000140  02000140  T南風様サンプル1  まぜさまさんぷる  01  545d791e435fb1f7966d84362bc6cd3d77f6b07c      2021-03-30 14:32:27  2021-03-05 00:00:00    2021-03-05 17:47:26  MG00000005  2021-03-25 08:45:19  AG02000140  View Edit Delete
AG02000141  02000141  Tよつばマルシェ 141  よつばまるしぇひゃくよんじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 11:55:18  MG00000001  2021-06-09 11:56:35  MG00000001  View Edit Delete
AG02000142  02000142  Tよつばマルシェ 142  よつばまるしぇひゃくよんじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 11:57:18  MG00000001  2021-06-09 11:57:18  MG00000001  View Edit Delete
AG02000143  02000143  Tよつばマルシェ 143  よつばまるしぇひゃくよんじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 11:58:06  MG00000001  2021-06-09 11:58:06  MG00000001  View Edit Delete
AG02000144  02000144  Tよつばマルシェ 144  よつばまるしぇひゃくよんじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-07-12 13:11:55  2021-06-09 00:00:00    2021-06-09 11:58:41  MG00000001  2021-06-09 11:58:41  MG00000001  View Edit Delete
AG02000145  02000145  Tよつばマルシェ 145  よつばまるしぇひゃくよんじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 11:59:37  MG00000001  2021-06-09 11:59:37  MG00000001  View Edit Delete
AG02000146  02000146  Tよつばマルシェ 146  よつばまるしぇひゃくよんじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 12:00:21  MG00000001  2021-06-09 12:00:21  MG00000001  View Edit Delete
AG02000147  02000147  Tよつばマルシェ 147  よつばまるしぇひゃくよんじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 12:01:01  MG00000001  2021-06-09 12:01:01  MG00000001  View Edit Delete
AG02000148  02000148  Tよつばマルシェ 148  よつばまるしぇひゃくよんじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 12:03:38  MG00000001  2021-06-09 12:03:38  MG00000001  View Edit Delete
AG02000149  02000149  Tよつばマルシェ 149  よつばまるしぇひゃくよんじゅうきゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc        2021-06-09 00:00:00    2021-06-09 12:04:19  MG00000001  2021-06-09 12:04:19  MG00000001  View Edit Delete
AG02000150  02000150  Tよつばマルシェ 150  よつばまるしぇひゃくごじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2022-02-18 10:07:27  2021-06-09 00:00:00    2021-06-09 12:05:00  MG00000001  2021-06-09 12:05:00  MG00000001  View Edit Delete

Page 161 of 256, showing 20 records out of 5104 total, starting on record 3201, ending on 3220

(default) 2 queries took 224 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 3200, 202020147
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 = 11177