Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9790  AG06000209 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
9792  AG06000211 06 661          View Edit Delete
9793  AG06000212 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9796  AG06000215 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9806  AG06000225 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete

Page 103 of 373, showing 20 records out of 7458 total, starting on record 2041, ending on 2060

(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 LIMIT 2040, 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