Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10522  AG06000941 06 661          View Edit Delete
10662  AG06001081 06 661          View Edit Delete
10193  AG06000612 06 661          View Edit Delete
10169  AG06000588 06 661          View Edit Delete
10661  AG06001080 06 661          View Edit Delete
10171  AG06000590 06 661          View Edit Delete
10173  AG06000592 06 661          View Edit Delete
10085  AG06000504 06 661          View Edit Delete
10194  AG06000613 06 661          View Edit Delete
10195  AG06000614 06 661          View Edit Delete
10197  AG06000616 06 661          View Edit Delete
10199  AG06000618 06 661          View Edit Delete
10198  AG06000617 06 661          View Edit Delete
10200  AG06000619 06 661          View Edit Delete
10201  AG06000620 06 661          View Edit Delete
10202  AG06000621 06 661          View Edit Delete
10204  AG06000623 06 661          View Edit Delete
10205  AG06000624 06 661          View Edit Delete
10208  AG06000627 06 661          View Edit Delete
10209  AG06000628 06 661          View Edit Delete

Page 63 of 373, showing 20 records out of 7458 total, starting on record 1241, ending on 1260

(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`.`trader_id` desc LIMIT 1240, 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