Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10011  AG06000430 06 661          View Edit Delete
10012  AG06000431 06 661          View Edit Delete
10000  AG06000419 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
10017  AG06000436 06 661          View Edit Delete
10016  AG06000435 06 661          View Edit Delete
10022  AG06000441 06 661          View Edit Delete
10021  AG06000440 06 661          View Edit Delete
10024  AG06000443 06 661          View Edit Delete
10023  AG06000442 06 661          View Edit Delete
10027  AG06000446 06 661          View Edit Delete
10026  AG06000445 06 661          View Edit Delete
10029  AG06000448 06 661          View Edit Delete
10028  AG06000447 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
10031  AG06000450 06 661          View Edit Delete
10034  AG06000453 06 661          View Edit Delete
10035  AG06000454 06 661          View Edit Delete
10037  AG06000456 06 661          View Edit Delete
10038  AG06000457 06 661          View Edit Delete

Page 59 of 373, showing 20 records out of 7458 total, starting on record 1161, ending on 1180

(default) 2 queries took 26 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 1160, 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 = 11117