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
AG01005664  01005664  T松尾 紀彦  まつおのりひこ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-09-07 08:28:41  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005665  01005665  Tみやまファーム  みやまふぁーむ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005666  01005666  T田尻 秀広  たじりひでひろ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005667  01005667  T梶山 忠雄  かじやまただお  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005668  01005668  T松藤 恵  まつふじめぐみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-08-31 15:49:42  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005669  01005669  Tイクシマ  いくしま  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005670  01005670  T松尾一美  まつおかずみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005671  01005671  T(直)合同会社コクヨウ  ごうどうかいしゃこくよう  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005672  01005672  T(直)小山 秀司  こやましゅうじ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005673  01005673  T(直)高田  たかだ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005674  01005674  T(直)田中 正春  たなかまさはる  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005675  01005675  T(直)松尾 紀彦  まつおのりひこ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005676  01005676  T(直)みやまファーム  みやまふぁーむ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005677  01005677  T(直)田尻 秀広  たじりひでひろ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005678  01005678  T(直)梶山 忠雄  かじやまただお  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005679  01005679  T(直)松藤 恵  まつふじめぐみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005680  01005680  T(直)イクシマ  いくしま  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005681  01005681  T(直)松尾一美  まつおかずみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005682  01005682  T(直)月足 大作  つきあしたださく  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005683  01005683  T(直)中村正  なかむらただし  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-10-25 08:09:41  2023-08-29 00:00:00    2023-08-29 00:00:00  MG00000001  2023-08-29 00:00:00  MG00000001  View Edit Delete

Page 136 of 256, showing 20 records out of 5104 total, starting on record 2701, ending on 2720

(default) 2 queries took 215 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 2700, 202020143
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 = 11172