Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10130  AG06000549 06 661          View Edit Delete
10131  AG06000550 06 661          View Edit Delete
10134  AG06000553 06 661          View Edit Delete
10135  AG06000554 06 661          View Edit Delete
10136  AG06000555 06 661          View Edit Delete
10137  AG06000556 06 661          View Edit Delete
10140  AG06000559 06 661          View Edit Delete
10141  AG06000560 06 661          View Edit Delete
10143  AG06000562 06 661          View Edit Delete
10144  AG06000563 06 661          View Edit Delete
10147  AG06000566 06 661          View Edit Delete
10148  AG06000567 06 661          View Edit Delete
10149  AG06000568 06 661          View Edit Delete
9921  AG06000340 06 661          View Edit Delete
9650  AG06000069 06 661          View Edit Delete
10331  AG06000750 06 661          View Edit Delete
10152  AG06000571 06 661          View Edit Delete
10153  AG06000572 06 661          View Edit Delete
10155  AG06000574 06 661          View Edit Delete
10156  AG06000575 06 661          View Edit Delete

Page 46 of 373, showing 20 records out of 7458 total, starting on record 901, ending on 920

(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`.`trader_id` desc LIMIT 900, 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