Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9604  AG06000023 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete
9630  AG06000049 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9636  AG06000055 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9647  AG06000066 06 661          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
9639  AG06000058 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete

Page 11 of 373, showing 20 records out of 7458 total, starting on record 201, ending on 220

(default) 2 queries took 24 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`.`trader_id` desc LIMIT 200, 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 = 11118