Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10253  AG06000672 06 661          View Edit Delete
10251  AG06000670 06 661          View Edit Delete
10247  AG06000666 06 661          View Edit Delete
10239  AG06000658 06 661          View Edit Delete
10223  AG06000642 06 661          View Edit Delete
10260  AG06000679 06 661          View Edit Delete
10256  AG06000675 06 661          View Edit Delete
10264  AG06000683 06 661          View Edit Delete
10269  AG06000688 06 661          View Edit Delete
10267  AG06000686 06 661          View Edit Delete
10263  AG06000682 06 661          View Edit Delete
10255  AG06000674 06 661          View Edit Delete
10271  AG06000690 06 661          View Edit Delete
10270  AG06000689 06 661          View Edit Delete
10254  AG06000673 06 661          View Edit Delete
10222  AG06000641 06 661          View Edit Delete
10221  AG06000640 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 46 of 373, showing 20 records out of 7458 total, starting on record 901, ending on 920

(default) 2 queries took 26 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`.`insert_user` asc LIMIT 900, 2020208
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