Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9762  AG06000181 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9770  AG06000189 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9777  AG06000196 06 661          View Edit Delete
9774  AG06000193 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9773  AG06000192 06 661          View Edit Delete
9785  AG06000204 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9772  AG06000191 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9717  AG06000136 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`.`update_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