Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9880  AG06000299 06 661          View Edit Delete
9878  AG06000297 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9868  AG06000287 06 661          View Edit Delete
9887  AG06000306 06 661          View Edit Delete
9885  AG06000304 06 661          View Edit Delete
9882  AG06000301 06 661          View Edit Delete
9889  AG06000308 06 661          View Edit Delete
9893  AG06000312 06 661          View Edit Delete
9891  AG06000310 06 661          View Edit Delete
9888  AG06000307 06 661          View Edit Delete
9881  AG06000300 06 661          View Edit Delete
9867  AG06000286 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9894  AG06000313 06 661          View Edit Delete
9866  AG06000285 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete

Page 60 of 373, showing 20 records out of 7458 total, starting on record 1181, ending on 1200

(default) 2 queries took 26 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 1180, 2020209
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