Contractors

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

Page 115 of 373, showing 20 records out of 7458 total, starting on record 2281, ending on 2300

(default) 2 queries took 28 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`.`id` asc LIMIT 2280, 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 = 11119