Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10317  AG06000736 06 661          View Edit Delete
10315  AG06000734 06 661          View Edit Delete
10312  AG06000731 06 661          View Edit Delete
10319  AG06000738 06 661          View Edit Delete
10323  AG06000742 06 661          View Edit Delete
10321  AG06000740 06 661          View Edit Delete
10318  AG06000737 06 661          View Edit Delete
10311  AG06000730 06 661          View Edit Delete
10297  AG06000716 06 661          View Edit Delete
10329  AG06000748 06 661          View Edit Delete
10326  AG06000745 06 661          View Edit Delete
10332  AG06000751 06 661          View Edit Delete
10331  AG06000750 06 661          View Edit Delete
10325  AG06000744 06 661          View Edit Delete
10324  AG06000743 06 661          View Edit Delete
10296  AG06000715 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 49 of 373, showing 20 records out of 7458 total, starting on record 961, ending on 980

(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`.`update_user` asc LIMIT 960, 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