Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9867  AG06000286 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9880  AG06000299 06 661          View Edit Delete
9878  AG06000297 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9866  AG06000285 06 661          View Edit Delete
9888  AG06000307 06 661          View Edit Delete
9886  AG06000305 06 661          View Edit Delete
9882  AG06000301 06 661          View Edit Delete
9890  AG06000309 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9893  AG06000312 06 661          View Edit Delete
9889  AG06000308 06 661          View Edit Delete
9881  AG06000300 06 661          View Edit Delete
9865  AG06000284 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9897  AG06000316 06 661          View Edit Delete
9896  AG06000315 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete

Page 24 of 373, showing 20 records out of 7458 total, starting on record 461, ending on 480

(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 460, 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