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
AG01004484  01004484  T(直)本多雄嗣  ほんだゆうじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2022-09-20 13:12:22  2021-04-08 00:00:00    2021-04-08 15:25:11  MG00000005  2021-04-20 10:48:30  MG00000005  View Edit Delete
AG01004485  01004485  T井上壽夫  いのうえとしお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-08 15:13:20  2021-04-08 00:00:00    2021-04-08 15:28:24  MG00000005  2021-04-20 10:54:10  MG00000005  View Edit Delete
AG01004486  01004486  T本多雄嗣  ほんだゆうじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-23 14:40:11  2021-04-08 00:00:00    2021-04-08 15:33:00  MG00000005  2021-04-20 10:54:24  MG00000005  View Edit Delete
AG01004487  01004487  TOH!グラッチェ  ぐらっちぇ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-22 12:28:14  2021-04-09 00:00:00    2021-04-09 15:41:17  MG00000005  2022-01-27 15:57:21  MG00000001  View Edit Delete
AG01004488  01004488  TPIXEL FARMAR  ぴくせるふぁーまー  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-12 14:53:02  2021-04-09 00:00:00    2021-04-09 16:07:07  MG00000005  2022-01-27 15:57:05  MG00000001  View Edit Delete
AG01004489  01004489  TエコファームMITANI  えこふぁーむみたに  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-19 16:00:09  2021-04-09 00:00:00    2021-04-09 16:12:31  MG00000005  2021-04-09 16:12:31  MG00000005  View Edit Delete
AG01004490  01004490  T藤井秀文  ふじいひでのり  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-29 07:04:20  2021-04-09 00:00:00    2021-04-09 16:25:36  MG00000005  2021-04-09 16:25:36  MG00000005  View Edit Delete
AG01004491  01004491  T(直)OH!グラッチェ  ぐらっちぇ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2021-12-24 09:47:04  2021-04-09 00:00:00    2021-04-09 16:30:31  MG00000005  2021-04-09 16:58:44  MG00000005  View Edit Delete
AG01004492  01004492  T(直)PIXEL FARMAR  ぴくせるふぁーまー  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2021-04-09 00:00:00    2021-04-09 16:39:53  MG00000005  2021-04-09 16:58:35  MG00000005  View Edit Delete
AG01004493  01004493  T城臺幸一  じょうだいこういち  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-05-20 16:18:58  2021-04-15 00:00:00    2021-04-15 14:26:54  MG00000005  2021-04-15 14:26:54  MG00000005  View Edit Delete
AG01004494  01004494  T(直)すぎ農園  すぎのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-07-15 14:21:28  2021-04-19 00:00:00    2021-04-19 15:39:31  MG00000005  2021-04-20 10:48:00  MG00000005  View Edit Delete
AG01004495  01004495  T出井集吉  でいしゅうきち  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2021-04-19 00:00:00    2021-04-19 15:53:37  MG00000005  2021-04-19 15:53:37  MG00000005  View Edit Delete
AG01004496  01004496  Tファーム戸田  ふぁーむとだ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-19 12:22:42  2021-04-19 00:00:00    2021-04-19 15:59:13  MG00000005  2022-01-27 15:49:02  MG00000001  View Edit Delete
AG01004497  01004497  Tたんぽぽ農園  たんぽぽのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 13:36:56  2021-04-19 00:00:00    2021-04-19 16:06:35  MG00000005  2022-01-27 15:48:34  MG00000001  View Edit Delete
AG01004498  01004498  T結ファーム㈱  ゆいふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-01 15:12:06  2021-04-19 00:00:00    2021-04-19 16:57:43  MG00000005  2022-01-27 15:48:11  MG00000001  View Edit Delete
AG01004499  01004499  T(直)Y's Table  わいずてーぶる  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2021-08-17 12:34:32  2021-04-19 00:00:00    2021-04-19 17:06:13  MG00000005  2021-04-19 17:06:13  MG00000005  View Edit Delete
AG01004500  01004500  T米田晃  よねだあきら  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-10-24 09:44:17  2021-04-19 00:00:00    2021-04-19 17:27:02  MG00000005  2021-04-19 17:27:02  MG00000005  View Edit Delete
AG01004501  01004501  T九州中央ジェネラルアグリ株式会社  きゅうしゅうちゅうおうじぇねらるあぐりかぶしきがいしゃ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2023-01-05 16:37:07  2021-04-19 00:00:00    2021-04-19 17:48:27  MG00000005  2021-04-19 17:48:27  MG00000005  View Edit Delete
AG01004502  01004502  T柿田愛子  かきたあいこ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 14:18:20  2021-04-19 00:00:00    2021-04-19 17:58:39  MG00000005  2023-02-27 08:53:39  MG00000001  View Edit Delete
AG01004503  01004503  TMKファーム青森  えむけーふぁーむあおもり  01  b0970eed8053eacc0a5dbe545e20448d9ecf75b4      2022-02-10 12:15:02  2021-04-22 00:00:00    2021-04-22 10:05:28  MG00000005  2021-04-22 10:05:28  MG00000005  View Edit Delete

Page 77 of 256, showing 20 records out of 5104 total, starting on record 1521, ending on 1540

(default) 2 queries took 164 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 1520, 20202089
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