Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10362  AG06000781 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
10347  AG06000766 06 661          View Edit Delete
10375  AG06000794 06 661          View Edit Delete
10369  AG06000788 06 661          View Edit Delete
10372  AG06000791 06 661          View Edit Delete
10374  AG06000793 06 661          View Edit Delete
10370  AG06000789 06 661          View Edit Delete
10363  AG06000782 06 661          View Edit Delete
10388  AG06000807 06 661          View Edit Delete
10386  AG06000805 06 661          View Edit Delete
10395  AG06000814 06 661          View Edit Delete
10393  AG06000812 06 661          View Edit Delete
10390  AG06000809 06 661          View Edit Delete
10397  AG06000816 06 661          View Edit Delete
10396  AG06000815 06 661          View Edit Delete
10389  AG06000808 06 661          View Edit Delete

Page 51 of 373, showing 20 records out of 7458 total, starting on record 1001, ending on 1020

(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`.`update_user` asc LIMIT 1000, 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 = 11117