Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10150  AG06000569 06 661          View Edit Delete
10151  AG06000570 06 661          View Edit Delete
10152  AG06000571 06 661          View Edit Delete
10153  AG06000572 06 661          View Edit Delete
10154  AG06000573 06 661          View Edit Delete
10155  AG06000574 06 661          View Edit Delete
10156  AG06000575 06 661          View Edit Delete
10157  AG06000576 06 661          View Edit Delete
10158  AG06000577 06 661          View Edit Delete
10159  AG06000578 06 661          View Edit Delete
10160  AG06000579 06 661          View Edit Delete
10161  AG06000580 06 661          View Edit Delete
10162  AG06000581 06 661          View Edit Delete
10163  AG06000582 06 661          View Edit Delete
10164  AG06000583 06 661          View Edit Delete
10165  AG06000584 06 661          View Edit Delete
10166  AG06000585 06 661          View Edit Delete
10167  AG06000586 06 661          View Edit Delete
10168  AG06000587 06 661          View Edit Delete
10169  AG06000588 06 661          View Edit Delete

Page 121 of 373, showing 20 records out of 7458 total, starting on record 2401, ending on 2420

(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`.`id` asc LIMIT 2400, 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