Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5581  AG01001265 01 002          View Edit Delete
5583  AG01002588 01 002          View Edit Delete
5584  AG01001257 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5597  AG01001852 01 002          View Edit Delete
5600  AG01001579 01 002          View Edit Delete
5602  AG01001559 01 002          View Edit Delete
10962  AG01004811 01 002  2022-06-13 11:32:18  MG00000001  2022-06-13 11:32:18  MG00000001  View Edit Delete
11012  AG01004817 01 002  2022-06-22 10:36:57  MG00000001  2022-06-22 10:36:57  MG00000001  View Edit Delete
11640  AG01005153 01 002  2022-09-16 09:12:15  MG00000001  2022-09-16 09:12:15  MG00000001  View Edit Delete
13341  AG01004752 01 002  2022-11-21 10:36:10  MG00000001  2022-11-21 10:36:10  MG00000001  View Edit Delete
13381  AG01005360 01 002  2022-11-24 10:52:34  MG00000001  2022-11-24 10:52:34  MG00000001  View Edit Delete
9339  AG01003744 01 002  2021-04-01 18:26:11  MG00000005  2021-04-01 18:26:11  MG00000005  View Edit Delete
11831  AG01005159 01 002  2022-09-30 16:04:40  MG00000001  2022-09-30 16:04:40  MG00000001  View Edit Delete
5864  AG01001315 01 002  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
13178  AG01005233 01 002  2022-11-07 13:12:55  MG00000001  2022-11-07 13:12:55  MG00000001  View Edit Delete
13223  AG01005254 01 002  2022-11-11 10:54:49  MG00000001  2022-11-11 10:54:49  MG00000001  View Edit Delete
10983  AG01004823 01 002  2022-06-20 11:40:14  MG00000001  2022-06-20 11:40:14  MG00000001  View Edit Delete
10981  AG01004821 01 002  2022-06-20 11:38:15  MG00000001  2022-06-20 11:38:15  MG00000001  View Edit Delete

Page 16 of 373, showing 20 records out of 7458 total, starting on record 301, ending on 320

(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`.`company_cd` asc LIMIT 300, 2020206
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 = 11116