Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9746  AG06000165 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9739  AG06000158 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9753  AG06000172 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9734  AG06000153 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9752  AG06000171 06 661          View Edit Delete
9760  AG06000179 06 661          View Edit Delete
9732  AG06000151 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9745  AG06000164 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete

Page 48 of 373, showing 20 records out of 7458 total, starting on record 941, ending on 960

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