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
TR01000002  01000002  TJA道央  どうおう  12  6854c1657ab410f1b3602210a45fac88a48da88b  01000002      2016-07-01 00:00:00  2030-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:03:15  MG00000001  View Edit Delete
TR01000003  01000003  T長沼  ながぬま  12  39f562c4834b2d854dba536e7c019ca57e00c077  01000003      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:03:53  MG00000001  View Edit Delete
TR01000004  01000004  T南幌  なんぽろ  12  64aff6315bb39eca37879c2131e6db5572692057  01000004      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:32  MG00000001  View Edit Delete
TR01000005  01000005  TJAいしかり  いしかり  12  1f65e792f507f481c677a4f079f58fa9f1ec5aa5  01000005      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:44  MG00000001  View Edit Delete
TR01000006  01000006  T月形新鮮組  つきがたしんせんぐみ  12  5f31cd69ee346b09cc6fed468dcfe1370d02c8bf  01000006      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:59  MG00000001  View Edit Delete
TR01000022  01000022  TJA北いしかり①  きたいしかり  12  c2c81757eb4dcd50afb2592e2e371d808a9b6d32  01000022      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:05  MG00000001  View Edit Delete
TR01000023  01000023  TJA北いしかり②  きたいしかり  12  59916f16ae49dfd40b5ab983a49f922067a079f7  01000023      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:16  MG00000001  View Edit Delete
TR01000032  01000032  T木津川市  きづがわ  12  b8d449de72ea4676276609e441c08148753b7679  01000032      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:45  MG00000001  View Edit Delete
TR01000033  01000033  T亀岡市  かめおか  12  d0ab0a8ba3990a2fac024ed147a5a44e11b2202e  01000033      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:56  MG00000001  View Edit Delete
TR01000034  01000034  TMAB京都  きょうと  12  e0fc39d68e1a0a326bfefe81892602ca28ad354e  01000034      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:08  MG00000001  View Edit Delete
TR01000035  01000035  T大和郡山  やまとこおりやま  12  36626568870c65c8767c38932842588128eabb41  01000035      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:22  MG00000001  View Edit Delete
TR01000036  01000036  T郡山市  こおりやま  12  7ba904560e55516e994029752d78820a5cd2014b  01000036      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:41  MG00000001  View Edit Delete
TR01000037  01000037  T高田市  たかだ  12  f16b982165486693063bdd0e2b4f34dcc4e71aff  01000037      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:51  MG00000001  View Edit Delete
TR01000038  01000038  T五條市  ごじょうし  12  b2410967112a7f2480b261a9026de2f148905be4  01000038      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:04  MG00000001  View Edit Delete
TR01000039  01000039  T河合町  かわいちょう  12  e4e55df5e52be2f706e99356c4db8c40a478b992  01000039      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:14  MG00000001  View Edit Delete
TR01000040  01000040  T奈良市  なら  12  90b1078b79873a664aa66948b936c8ca6aa5fb76  01000040      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:25  MG00000001  View Edit Delete
TR01000041  01000041  T御所市  ごせ  12  f07b060d770c84ec7d9b9b0c630d5a0d6b75989a  01000041      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:51  MG00000001  View Edit Delete
TR01000042  01000042  T平群町  へぐり  12  ac5e6dc924d1edc808322889cb2b141d3543d399  01000042      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:13:21  MG00000001  View Edit Delete
TR01000043  01000043  T明日香村  あすかむら  12  58c182c8c312b81e0dc8a146552dbf14fbddad55  01000043      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:13:33  MG00000001  View Edit Delete
TR01000044  01000044  T大淀町  おおよどちょう  12  93babe5e2f8a88b96e5117c5b72aab678ae9e618  01000044      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:39:00  MG00000001  View Edit Delete

Page 2 of 256, showing 20 records out of 5104 total, starting on record 21, ending on 40

(default) 2 queries took 319 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 ORDER BY `User`.`modified` asc LIMIT 20, 202020246
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 = 11173