Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9914  AG06000333 06 661          View Edit Delete
10084  AG06000503 06 661          View Edit Delete
9915  AG06000334 06 661          View Edit Delete
10085  AG06000504 06 661          View Edit Delete
10043  AG06000462 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
10042  AG06000461 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
10038  AG06000457 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9918  AG06000337 06 661          View Edit Delete
9919  AG06000338 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9830  AG06000249 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete

Page 38 of 373, showing 20 records out of 7458 total, starting on record 741, ending on 760

(default) 2 queries took 23 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 740, 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 = 11116