Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9563  AG01000701 01 002  2022-02-18 11:40:08  MG00000001  2022-02-18 11:40:08  MG00000001  View Edit Delete
9564  AG01004606 01 002  2022-02-18 11:52:52  MG00000001  2022-02-18 11:52:52  MG00000001  View Edit Delete
9565  AG01001299 01 002  2022-02-18 11:54:36  MG00000001  2022-02-18 11:54:36  MG00000001  View Edit Delete
9566  AG01004613 01 002  2022-02-18 13:07:22  MG00000001  2022-02-18 13:07:22  MG00000001  View Edit Delete
9567  AG01004355 01 002  2022-02-18 13:08:19  MG00000001  2022-02-18 13:08:19  MG00000001  View Edit Delete
9568  AG01004639 01 002  2022-02-18 13:24:10  MG00000001  2022-02-18 13:24:10  MG00000001  View Edit Delete
9569  AG01004640 01 002  2022-02-18 13:31:53  MG00000001  2022-02-18 13:31:53  MG00000001  View Edit Delete
9570  AG01004641 01 002  2022-02-18 13:35:54  MG00000001  2022-02-18 13:35:54  MG00000001  View Edit Delete
9574  AG01004074 01 002  2022-02-28 15:15:23  MG00000001  2022-02-28 15:15:23  MG00000001  View Edit Delete
9575  AG01004074 01 006  2022-02-28 15:16:16  MG00000001  2022-02-28 15:16:16  MG00000001  View Edit Delete
9578  AG06000001 06 661  2022-03-09 15:28:43  MG00000001  2022-03-09 15:28:43  MG00000001  View Edit Delete
9580  AG06000002 06 661  2022-03-11 10:31:06  MG00000001  2022-03-11 10:31:06  MG00000001  View Edit Delete
9582  AG08000053 08 96  2022-03-14 09:05:46  MG00000001  2022-03-14 09:05:46  MG00000001  View Edit Delete
9583  AG02100104 02 53  2022-03-15 08:39:54  MG00000001  2022-03-15 08:39:54  MG00000001  View Edit Delete
9584  AG06000003 06 661  2022-03-15 13:58:12  MG00000001  2022-03-15 13:58:12  MG00000001  View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete

Page 92 of 373, showing 20 records out of 7458 total, starting on record 1821, ending on 1840

(default) 2 queries took 25 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`.`id` asc LIMIT 1820, 2020207
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 = 11118