Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9580  AG06000002 06 661  2022-03-11 10:31:06  MG00000001  2022-03-11 10:31:06  MG00000001  View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete
10064  AG06000483 06 661          View Edit Delete
10068  AG06000487 06 661          View Edit Delete
10067  AG06000486 06 661          View Edit Delete
10062  AG06000481 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
9844  AG06000263 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
10037  AG06000456 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete

Page 39 of 373, showing 20 records out of 7458 total, starting on record 761, ending on 780

(default) 2 queries took 24 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` desc LIMIT 760, 2020208
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