Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9641  AG06000060 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
9640  AG06000059 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete

Page 17 of 373, showing 20 records out of 7458 total, starting on record 321, ending on 340

(default) 2 queries took 22 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 320, 2020206
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 = 11116