Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10007  AG06000426 06 661          View Edit Delete
10012  AG06000431 06 661          View Edit Delete
10014  AG06000433 06 661          View Edit Delete
10013  AG06000432 06 661          View Edit Delete
10011  AG06000430 06 661          View Edit Delete
10016  AG06000435 06 661          View Edit Delete
10018  AG06000437 06 661          View Edit Delete
10017  AG06000436 06 661          View Edit Delete
10015  AG06000434 06 661          View Edit Delete
10020  AG06000439 06 661          View Edit Delete
10022  AG06000441 06 661          View Edit Delete
10021  AG06000440 06 661          View Edit Delete
10019  AG06000438 06 661          View Edit Delete
10023  AG06000442 06 661          View Edit Delete
10291  AG06000710 06 661          View Edit Delete
10510  AG06000929 06 661          View Edit Delete
10509  AG06000928 06 661          View Edit Delete
10516  AG06000935 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
10310  AG06000729 06 661          View Edit Delete

Page 61 of 373, showing 20 records out of 7458 total, starting on record 1201, ending on 1220

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