Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9750  AG06000169 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9752  AG06000171 06 661          View Edit Delete
9753  AG06000172 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9756  AG06000175 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
9760  AG06000179 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9763  AG06000182 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9765  AG06000184 06 661          View Edit Delete
9766  AG06000185 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete

Page 101 of 373, showing 20 records out of 7458 total, starting on record 2001, ending on 2020

(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`.`id` asc LIMIT 2000, 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