Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10448  AG06000867 06 661          View Edit Delete
10447  AG06000866 06 661          View Edit Delete
10446  AG06000865 06 661          View Edit Delete
10445  AG06000864 06 661          View Edit Delete
10444  AG06000863 06 661          View Edit Delete
10443  AG06000862 06 661          View Edit Delete
10442  AG06000861 06 661          View Edit Delete
10441  AG06000860 06 661          View Edit Delete
10440  AG06000859 06 661          View Edit Delete
10439  AG06000858 06 661          View Edit Delete
10438  AG06000857 06 661          View Edit Delete
10437  AG06000856 06 661          View Edit Delete
10436  AG06000855 06 661          View Edit Delete
10435  AG06000854 06 661          View Edit Delete
10434  AG06000853 06 661          View Edit Delete
10433  AG06000852 06 661          View Edit Delete
10432  AG06000851 06 661          View Edit Delete
10431  AG06000850 06 661          View Edit Delete
10430  AG06000849 06 661          View Edit Delete
10429  AG06000848 06 661          View Edit Delete

Page 24 of 373, showing 20 records out of 7458 total, starting on record 461, ending on 480

(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`.`farmer_id` desc LIMIT 460, 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