Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
7148  AG07000001 07 81  2017-12-04 14:42:18  MG00000001  2017-12-04 14:42:18  MG00000001  View Edit Delete
7828  AG07000004 07 84  2018-06-26 10:19:33  MG00000001  2018-06-26 10:19:33  MG00000001  View Edit Delete
7752  AG07000001 07 83  2018-06-07 19:15:52  MG00000001  2018-06-07 19:15:52  MG00000001  View Edit Delete
7827  AG07000003 07 84  2018-06-26 10:19:04  MG00000001  2018-06-26 10:19:04  MG00000001  View Edit Delete
7826  AG07000001 07 84  2018-06-26 10:18:38  MG00000001  2018-06-26 10:18:38  MG00000001  View Edit Delete
7825  AG07000002 07 84  2018-06-25 20:25:48  MG00000001  2018-06-25 20:25:48  MG00000001  View Edit Delete
7379  AG07000001 07 82  2018-02-28 09:17:17  MG00000001  2018-02-28 09:17:37  MG00000001  View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete

Page 9 of 373, showing 20 records out of 7458 total, starting on record 161, ending on 180

(default) 2 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`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`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 1 ORDER BY `Contractor`.`trader_id` desc LIMIT 160, 2020205
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 11117