Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6316  AG03000025 03 61          View Edit Delete
6315  AG03000024 03 61          View Edit Delete
6314  AG03000023 03 61          View Edit Delete
6313  AG03000022 03 61          View Edit Delete
6312  AG03000021 03 61          View Edit Delete
6311  AG03000020 03 61          View Edit Delete
6310  AG03000019 03 61          View Edit Delete
6309  AG03000018 03 61          View Edit Delete
6308  AG03000017 03 61          View Edit Delete
6307  AG03000016 03 61          View Edit Delete
6306  AG03000015 03 61          View Edit Delete
6305  AG03000014 03 61          View Edit Delete
6304  AG03000013 03 61          View Edit Delete
6303  AG03000012 03 61          View Edit Delete
6302  AG03000011 03 61          View Edit Delete
6301  AG03000010 03 61          View Edit Delete
6300  AG03000009 03 61          View Edit Delete
6299  AG03000008 03 61          View Edit Delete
6298  AG03000007 03 61          View Edit Delete
6297  AG03000006 03 61          View Edit Delete

Page 356 of 373, showing 20 records out of 7458 total, starting on record 7101, ending on 7120

(default) 2 queries took 41 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 7100, 20202024
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