Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9787  AG06000206 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9786  AG06000205 06 661          View Edit Delete
9770  AG06000189 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete

Page 22 of 373, showing 20 records out of 7458 total, starting on record 421, ending on 440

(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`.`insert_user` asc LIMIT 420, 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