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
AG01005704  01005704  T紀之定清壱  のりゆきじょうきよしいつ  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-22 15:11:25  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005705  01005705  T大村拓矢  おおむらたくや  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-20 16:35:05  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005706  01005706  Tにんにく王国  にんにくおうこく  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-18 10:55:54  2023-09-15 00:00:00    2023-09-15 00:00:00  MG00000001  2023-09-15 00:00:00  MG00000001  View Edit Delete
AG01005707  01005707  T(直)橋本誠治  ちょくはしもとせいじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:45:32  2023-09-22 00:00:00    2023-09-22 10:49:52  MG00000001  2023-09-22 10:49:52  MG00000001  View Edit Delete
AG01005708  01005708  T(直)佐藤精文  ちょくさとうせいぶん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 07:19:00  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005709  01005709  T(直)藤井隆宏  ちょくふじいたかひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-08 08:38:33  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005710  01005710  T(直)佐藤範雄  ちょくさとうはんおす  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:39:19  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005711  01005711  T(直)三宅智雄  ちょくみやけともお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 07:00:58  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005712  01005712  T(直)橋本禎介  ちょくはしもとよしすけ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-22 06:33:52  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005713  01005713  T(直)槇坂孝子  ちょくまきさかたかこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 06:58:05  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005714  01005714  T(直)滝弘子  ちょくたきひろこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 06:59:58  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005715  01005715  T(直)多賀義明  ちょくたがよしあき  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 06:57:30  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005716  01005716  T(直)藤原範子  ちょくふじわらのりこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 06:30:25  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005717  01005717  T(直)森下義男  ちょくもりしたよしお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 07:01:33  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005718  01005718  T橋本誠治  はしもとせいじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:46:41  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005719  01005719  T佐藤精文  さとうせいぶん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 07:10:34  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005720  01005720  T藤井隆宏  ふじいたかひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-19 06:58:17  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005721  01005721  T佐藤範雄  さとうはんおす  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 06:47:13  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005722  01005722  T三宅智雄  みやけともお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-23 06:49:56  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005723  01005723  T橋本禎介  はしもとよしすけ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-18 06:43:25  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete

Page 138 of 256, showing 20 records out of 5104 total, starting on record 2741, ending on 2760

(default) 2 queries took 222 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 2740, 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 = 11175