Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9908  AG06000327 06 661          View Edit Delete
9907  AG06000326 06 661          View Edit Delete
9906  AG06000325 06 661          View Edit Delete
9905  AG06000324 06 661          View Edit Delete
9904  AG06000323 06 661          View Edit Delete
9903  AG06000322 06 661          View Edit Delete
9902  AG06000321 06 661          View Edit Delete
9901  AG06000320 06 661          View Edit Delete
9900  AG06000319 06 661          View Edit Delete
9899  AG06000318 06 661          View Edit Delete
9898  AG06000317 06 661          View Edit Delete
9897  AG06000316 06 661          View Edit Delete
9896  AG06000315 06 661          View Edit Delete
9895  AG06000314 06 661          View Edit Delete
9894  AG06000313 06 661          View Edit Delete
9893  AG06000312 06 661          View Edit Delete
9892  AG06000311 06 661          View Edit Delete
9891  AG06000310 06 661          View Edit Delete
9890  AG06000309 06 661          View Edit Delete
9889  AG06000308 06 661          View Edit Delete

Page 51 of 373, showing 20 records out of 7458 total, starting on record 1001, ending on 1020

(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`.`farmer_id` desc LIMIT 1000, 2020209
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 = 11116