Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9727  AG06000146 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9725  AG06000144 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete
9721  AG06000140 06 661          View Edit Delete
9720  AG06000139 06 661          View Edit Delete
9719  AG06000138 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete
9716  AG06000135 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9714  AG06000133 06 661          View Edit Delete
9713  AG06000132 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9709  AG06000128 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete

Page 275 of 373, showing 20 records out of 7458 total, starting on record 5481, ending on 5500

(default) 2 queries took 60 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`.`id` desc LIMIT 5480, 20202032
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 = 11128