Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10048  AG06000467 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
10046  AG06000465 06 661          View Edit Delete
10045  AG06000464 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
10043  AG06000462 06 661          View Edit Delete
10042  AG06000461 06 661          View Edit Delete
10041  AG06000460 06 661          View Edit Delete
10040  AG06000459 06 661          View Edit Delete
10039  AG06000458 06 661          View Edit Delete
10038  AG06000457 06 661          View Edit Delete
10037  AG06000456 06 661          View Edit Delete
10036  AG06000455 06 661          View Edit Delete
10035  AG06000454 06 661          View Edit Delete
10034  AG06000453 06 661          View Edit Delete
10033  AG06000452 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
10031  AG06000450 06 661          View Edit Delete
10030  AG06000449 06 661          View Edit Delete
10029  AG06000448 06 661          View Edit Delete

Page 44 of 373, showing 20 records out of 7458 total, starting on record 861, ending on 880

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