Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9743  AG06000162 06 661          View Edit Delete
9739  AG06000158 06 661          View Edit Delete
9750  AG06000169 06 661          View Edit Delete
9749  AG06000168 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9752  AG06000171 06 661          View Edit Delete
9754  AG06000173 06 661          View Edit Delete
9753  AG06000172 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9747  AG06000166 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
9757  AG06000176 06 661          View Edit Delete
9756  AG06000175 06 661          View Edit Delete
9760  AG06000179 06 661          View Edit Delete
9762  AG06000181 06 661          View Edit Delete
9761  AG06000180 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9755  AG06000174 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9763  AG06000182 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 25 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`.`created` asc 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 = 11118