Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9788  AG06000207 06 661          View Edit Delete
9787  AG06000206 06 661          View Edit Delete
9786  AG06000205 06 661          View Edit Delete
9785  AG06000204 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9781  AG06000200 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
9777  AG06000196 06 661          View Edit Delete
9776  AG06000195 06 661          View Edit Delete
9775  AG06000194 06 661          View Edit Delete
9774  AG06000193 06 661          View Edit Delete
9773  AG06000192 06 661          View Edit Delete
9772  AG06000191 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9770  AG06000189 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete

Page 57 of 373, showing 20 records out of 7458 total, starting on record 1121, ending on 1140

(default) 2 queries took 30 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`.`farmer_id` desc LIMIT 1120, 20202010
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 = 11120