Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9807  AG06000226 06 661          View Edit Delete
10023  AG06000442 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
10026  AG06000445 06 661          View Edit Delete
10025  AG06000444 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete
9897  AG06000316 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9891  AG06000310 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete

Page 37 of 373, showing 20 records out of 7458 total, starting on record 721, ending on 740

(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`.`company_cd` desc LIMIT 720, 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 = 11117