Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9590  AG06000009 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete

Page 93 of 373, showing 20 records out of 7458 total, starting on record 1841, ending on 1860

(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`.`id` asc LIMIT 1840, 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