Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9768  AG06000187 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9770  AG06000189 06 661          View Edit Delete
9773  AG06000192 06 661          View Edit Delete
9772  AG06000191 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
9777  AG06000196 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9785  AG06000204 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9789  AG06000208 06 661          View Edit Delete
9788  AG06000207 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
9790  AG06000209 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9793  AG06000212 06 661          View Edit Delete

Page 35 of 373, showing 20 records out of 7458 total, starting on record 681, ending on 700

(default) 2 queries took 25 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 680, 2020208
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