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
AG01004784  01004784  Tぶどう(シャインマスカット)  ぶどう  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:05:55  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004785  01004785  T桃(日川白鳳)  もも  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:06:43  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004786  01004786  T桃(あかつき)  もも  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:08:29  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004787  01004787  T桃(黄金桃)  もも  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:20:19  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004788  01004788  T桃(川中島)  もも  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:20:46  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004789  01004789  T大玉すいか  おおだますいか  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:29:36  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004790  01004790  T小玉すいか(マダーボール)  こだますいか  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:31:46  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004791  01004791  T小玉すいか(うり坊)  こだますいか  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:34:01  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004792  01004792  T小玉すいか  こだますいか  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:35:35  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004793  01004793  Tキンカン  きんかん  01  f634663ff0e57b848fbb580b385f3a7b631d7245        2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004794  01004794  Tいちじく  いちじく  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:22:19  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004795  01004795  Tキウイ  きうい  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:26:27  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004796  01004796  Tプラム  ぷらむ  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:36:47  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004797  01004797  Tレモン  れもん  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:27:20  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004798  01004798  Tレモン(青レモン)  れもん  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:27:58  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004799  01004799  T梨(幸水)  なし  01  f634663ff0e57b848fbb580b385f3a7b631d7245      2022-06-13 15:28:45  2022-06-06 00:00:00    2022-06-06 13:42:37  MG00000001  2022-06-06 13:42:37  MG00000001  View Edit Delete
AG01004800  01004800  Tコールラビ  こーるらび  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2023-03-30 09:15:07  2022-06-08 00:00:00    2022-06-08 14:50:05  MG00000001  2022-06-08 14:50:05  MG00000001  View Edit Delete
AG01004801  01004801  Tビーツ  びーつ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 15:30:08  2022-06-08 00:00:00    2022-06-08 14:50:05  MG00000001  2022-06-08 14:50:05  MG00000001  View Edit Delete
AG01004802  01004802  Tキャべツ  きゃべつ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-07-14 11:18:09  2022-06-08 00:00:00    2022-06-08 14:50:05  MG00000001  2022-06-08 14:50:05  MG00000001  View Edit Delete
AG01004803  01004803  Tズッキーニ  ずっきーに  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-07-11 22:28:40  2022-06-08 00:00:00    2022-06-08 14:50:05  MG00000001  2022-06-08 14:50:05  MG00000001  View Edit Delete

Page 92 of 256, showing 20 records out of 5104 total, starting on record 1821, ending on 1840

(default) 2 queries took 166 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 1820, 20202091
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