Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10508  AG06000927 06 661          View Edit Delete
10507  AG06000926 06 661          View Edit Delete
10506  AG06000925 06 661          View Edit Delete
10505  AG06000924 06 661          View Edit Delete
10504  AG06000923 06 661          View Edit Delete
10503  AG06000922 06 661          View Edit Delete
10502  AG06000921 06 661          View Edit Delete
10501  AG06000920 06 661          View Edit Delete
10500  AG06000919 06 661          View Edit Delete
10499  AG06000918 06 661          View Edit Delete
10498  AG06000917 06 661          View Edit Delete
10497  AG06000916 06 661          View Edit Delete
10496  AG06000915 06 661          View Edit Delete
10495  AG06000914 06 661          View Edit Delete
10494  AG06000913 06 661          View Edit Delete
10493  AG06000912 06 661          View Edit Delete
10492  AG06000911 06 661          View Edit Delete
10491  AG06000910 06 661          View Edit Delete
10490  AG06000909 06 661          View Edit Delete
10489  AG06000908 06 661          View Edit Delete

Page 21 of 373, showing 20 records out of 7458 total, starting on record 401, ending on 420

(default) 2 queries took 24 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 400, 2020207
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