Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10250  AG06000669 06 661          View Edit Delete
10251  AG06000670 06 661          View Edit Delete
10252  AG06000671 06 661          View Edit Delete
10253  AG06000672 06 661          View Edit Delete
10254  AG06000673 06 661          View Edit Delete
10255  AG06000674 06 661          View Edit Delete
10256  AG06000675 06 661          View Edit Delete
10257  AG06000676 06 661          View Edit Delete
10258  AG06000677 06 661          View Edit Delete
10259  AG06000678 06 661          View Edit Delete
10260  AG06000679 06 661          View Edit Delete
10261  AG06000680 06 661          View Edit Delete
10262  AG06000681 06 661          View Edit Delete
10263  AG06000682 06 661          View Edit Delete
10264  AG06000683 06 661          View Edit Delete
10265  AG06000684 06 661          View Edit Delete
10266  AG06000685 06 661          View Edit Delete
10267  AG06000686 06 661          View Edit Delete
10268  AG06000687 06 661          View Edit Delete
10269  AG06000688 06 661          View Edit Delete

Page 126 of 373, showing 20 records out of 7458 total, starting on record 2501, ending on 2520

(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 2500, 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