Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9753  AG06000172 06 661          View Edit Delete
9746  AG06000165 06 661          View Edit Delete
9775  AG06000194 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9774  AG06000193 06 661          View Edit Delete
9776  AG06000195 06 661          View Edit Delete
9781  AG06000200 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9773  AG06000192 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9766  AG06000185 06 661          View Edit Delete
9777  AG06000196 06 661          View Edit Delete
9765  AG06000184 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9908  AG06000327 06 661          View Edit Delete
9909  AG06000328 06 661          View Edit Delete
10270  AG06000689 06 661          View Edit Delete

Page 49 of 373, showing 20 records out of 7458 total, starting on record 961, ending on 980

(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`.`company_cd` desc LIMIT 960, 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