Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9887  AG06000306 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9894  AG06000313 06 661          View Edit Delete
9893  AG06000312 06 661          View Edit Delete
9891  AG06000310 06 661          View Edit Delete
9896  AG06000315 06 661          View Edit Delete
9898  AG06000317 06 661          View Edit Delete
9897  AG06000316 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9900  AG06000319 06 661          View Edit Delete
9902  AG06000321 06 661          View Edit Delete
9901  AG06000320 06 661          View Edit Delete
9899  AG06000318 06 661          View Edit Delete
9903  AG06000322 06 661          View Edit Delete
9904  AG06000323 06 661          View Edit Delete
10002  AG06000421 06 661          View Edit Delete
10169  AG06000588 06 661          View Edit Delete
10420  AG06000839 06 661          View Edit Delete
10397  AG06000816 06 661          View Edit Delete
10409  AG06000828 06 661          View Edit Delete

Page 55 of 373, showing 20 records out of 7458 total, starting on record 1081, ending on 1100

(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 1080, 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