Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10038  AG06000457 06 661          View Edit Delete
10036  AG06000455 06 661          View Edit Delete
10033  AG06000452 06 661          View Edit Delete
10040  AG06000459 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
10042  AG06000461 06 661          View Edit Delete
10039  AG06000458 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
10020  AG06000439 06 661          View Edit Delete
10050  AG06000469 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
10054  AG06000473 06 661          View Edit Delete
10053  AG06000472 06 661          View Edit Delete
10046  AG06000465 06 661          View Edit Delete
10045  AG06000464 06 661          View Edit Delete
10019  AG06000438 06 661          View Edit Delete
9979  AG06000398 06 661          View Edit Delete
9978  AG06000397 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 41 of 373, showing 20 records out of 7458 total, starting on record 801, ending on 820

(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`.`update_user` asc LIMIT 800, 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