Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9885  AG06000304 06 661          View Edit Delete
9886  AG06000305 06 661          View Edit Delete
9888  AG06000307 06 661          View Edit Delete
9889  AG06000308 06 661          View Edit Delete
9890  AG06000309 06 661          View Edit Delete
9891  AG06000310 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9894  AG06000313 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9896  AG06000315 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
10103  AG06000522 06 661          View Edit Delete
10156  AG06000575 06 661          View Edit Delete
10115  AG06000534 06 661          View Edit Delete
10116  AG06000535 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
10118  AG06000537 06 661          View Edit Delete
10119  AG06000538 06 661          View Edit Delete

Page 42 of 373, showing 20 records out of 7458 total, starting on record 821, ending on 840

(default) 2 queries took 26 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 820, 2020209
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