Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9967  AG06000386 06 661          View Edit Delete
9966  AG06000385 06 661          View Edit Delete
9965  AG06000384 06 661          View Edit Delete
9964  AG06000383 06 661          View Edit Delete
9963  AG06000382 06 661          View Edit Delete
9962  AG06000381 06 661          View Edit Delete
9961  AG06000380 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9959  AG06000378 06 661          View Edit Delete
9958  AG06000377 06 661          View Edit Delete
9957  AG06000376 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9955  AG06000374 06 661          View Edit Delete
9954  AG06000373 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9952  AG06000371 06 661          View Edit Delete
9951  AG06000370 06 661          View Edit Delete
9950  AG06000369 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete
9948  AG06000367 06 661          View Edit Delete

Page 263 of 373, showing 20 records out of 7458 total, starting on record 5241, ending on 5260

(default) 2 queries took 35 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` desc LIMIT 5240, 20202018
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