Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9903  AG06000322 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9914  AG06000333 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9902  AG06000321 06 661          View Edit Delete
9926  AG06000345 06 661          View Edit Delete
9925  AG06000344 06 661          View Edit Delete
9922  AG06000341 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9901  AG06000320 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9929  AG06000348 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
9928  AG06000347 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9900  AG06000319 06 661          View Edit Delete
9836  AG06000255 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete

Page 25 of 373, showing 20 records out of 7458 total, starting on record 481, ending on 500

(default) 2 queries took 22 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 480, 2020206
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 = 11116