Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10254  AG06000673 06 661          View Edit Delete
10222  AG06000641 06 661          View Edit Delete
10288  AG06000707 06 661          View Edit Delete
10296  AG06000715 06 661          View Edit Delete
10301  AG06000720 06 661          View Edit Delete
10299  AG06000718 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
10287  AG06000706 06 661          View Edit Delete
10309  AG06000728 06 661          View Edit Delete
10307  AG06000726 06 661          View Edit Delete
10303  AG06000722 06 661          View Edit Delete
10311  AG06000730 06 661          View Edit Delete
10310  AG06000729 06 661          View Edit Delete
10302  AG06000721 06 661          View Edit Delete
10286  AG06000705 06 661          View Edit Delete
10285  AG06000704 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 47 of 373, showing 20 records out of 7458 total, starting on record 921, ending on 940

(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`.`insert_user` asc LIMIT 920, 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