Contractors

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

Page 111 of 373, showing 20 records out of 7458 total, starting on record 2201, ending on 2220

(default) 2 queries took 27 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 LIMIT 2200, 2020209
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