Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10328  AG06000747 06 661          View Edit Delete
10327  AG06000746 06 661          View Edit Delete
10326  AG06000745 06 661          View Edit Delete
10325  AG06000744 06 661          View Edit Delete
10324  AG06000743 06 661          View Edit Delete
10323  AG06000742 06 661          View Edit Delete
10322  AG06000741 06 661          View Edit Delete
10321  AG06000740 06 661          View Edit Delete
10320  AG06000739 06 661          View Edit Delete
10319  AG06000738 06 661          View Edit Delete
10318  AG06000737 06 661          View Edit Delete
10317  AG06000736 06 661          View Edit Delete
10316  AG06000735 06 661          View Edit Delete
10315  AG06000734 06 661          View Edit Delete
10314  AG06000733 06 661          View Edit Delete
10313  AG06000732 06 661          View Edit Delete
10312  AG06000731 06 661          View Edit Delete
10311  AG06000730 06 661          View Edit Delete
10310  AG06000729 06 661          View Edit Delete
10309  AG06000728 06 661          View Edit Delete

Page 30 of 373, showing 20 records out of 7458 total, starting on record 581, ending on 600

(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`.`farmer_id` desc LIMIT 580, 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 = 11118