Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9726  AG06000145 06 661          View Edit Delete
9729  AG06000148 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9732  AG06000151 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete

Page 15 of 373, showing 20 records out of 7458 total, starting on record 281, ending on 300

(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 280, 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