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
AG01003441  01003441  T小田正直  おだまさなお  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2019-11-07 10:38:53  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003442  01003442  T上村博敏  うえむらひろとし  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003443  01003443  T古川百美  ふるかわももみ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2022-03-27 12:47:39  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003444  01003444  T富田寛  とみたひろし  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2022-12-20 17:39:43  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003445  01003445  T中山博子  なかやまひろこ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2020-03-10 08:21:47  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003446  01003446  T佐川涼人  さがわりょうと  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003447  01003447  T小松正治  こまつまさじ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2020-01-12 17:12:42  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003448  01003448  T佐藤文男  さとうふみお  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2022-12-23 14:00:48  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003449  01003449  T仲村良一  なかむらりょういち  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2019-11-26 10:13:22  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003450  01003450  T佐竹治芳  さたけひろよし  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003451  01003451  T仲村初恵  なかむらはつえ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003452  01003452  T佐藤花奈穂  さとうはなほ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2019-04-22 08:37:41  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003453  01003453  T城義則  じょうよしのり  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2019-09-15 16:50:24  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003454  01003454  T星野真理子  ほしのまりこ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2020-07-07 08:00:42  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003455  01003455  T阿瀬裕大  あせひろまさ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003456  01003456  T手島幸子  てじまさちこ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2022-03-24 04:53:12  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003457  01003457  T大東英治  だいとうえいじ  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11      2018-06-12 09:19:35  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 10:20:45  AG01003457  View Edit Delete
AG01003458  01003458  T松村博文  まつむらひろふみ  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11      2018-06-12 09:19:45  2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 10:16:51  MG00000001  View Edit Delete
AG01003459  01003459  T上原幸枝  うえはらさちえ  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete
AG01003460  01003460  T松本イソエ  まつもといそえ  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11        2018-05-25 00:00:00    2018-05-25 09:40:00  MG00000001  2018-05-25 09:40:00  MG00000001  View Edit Delete

Page 25 of 256, showing 20 records out of 5104 total, starting on record 481, ending on 500

(default) 2 queries took 106 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 480, 20202030
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 = 11176