Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9607  AG06000026 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9596  AG06000015 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
9591  AG06000010 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete

Page 281 of 373, showing 20 records out of 7458 total, starting on record 5601, ending on 5620

(default) 2 queries took 44 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`.`id` desc LIMIT 5600, 20202023
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 = 11121