Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10268  AG06000687 06 661          View Edit Delete
10267  AG06000686 06 661          View Edit Delete
10266  AG06000685 06 661          View Edit Delete
10265  AG06000684 06 661          View Edit Delete
10264  AG06000683 06 661          View Edit Delete
10263  AG06000682 06 661          View Edit Delete
10262  AG06000681 06 661          View Edit Delete
10261  AG06000680 06 661          View Edit Delete
10260  AG06000679 06 661          View Edit Delete
10259  AG06000678 06 661          View Edit Delete
10258  AG06000677 06 661          View Edit Delete
10257  AG06000676 06 661          View Edit Delete
10256  AG06000675 06 661          View Edit Delete
10255  AG06000674 06 661          View Edit Delete
10254  AG06000673 06 661          View Edit Delete
10253  AG06000672 06 661          View Edit Delete
10252  AG06000671 06 661          View Edit Delete
10251  AG06000670 06 661          View Edit Delete
10250  AG06000669 06 661          View Edit Delete
10249  AG06000668 06 661          View Edit Delete

Page 33 of 373, showing 20 records out of 7458 total, starting on record 641, ending on 660

(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`.`farmer_id` desc LIMIT 640, 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