Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9702  AG06000121 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9705  AG06000124 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9709  AG06000128 06 661          View Edit Delete
9714  AG06000133 06 661          View Edit Delete
9716  AG06000135 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9713  AG06000132 06 661          View Edit Delete
9719  AG06000138 06 661          View Edit Delete
9721  AG06000140 06 661          View Edit Delete
9720  AG06000139 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete

Page 29 of 373, showing 20 records out of 7458 total, starting on record 561, ending on 580

(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`.`modified` asc LIMIT 560, 2020207
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