Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10190  AG06000609 06 661          View Edit Delete
10191  AG06000610 06 661          View Edit Delete
10192  AG06000611 06 661          View Edit Delete
10193  AG06000612 06 661          View Edit Delete
10194  AG06000613 06 661          View Edit Delete
10195  AG06000614 06 661          View Edit Delete
10196  AG06000615 06 661          View Edit Delete
10197  AG06000616 06 661          View Edit Delete
10198  AG06000617 06 661          View Edit Delete
10199  AG06000618 06 661          View Edit Delete
10200  AG06000619 06 661          View Edit Delete
10201  AG06000620 06 661          View Edit Delete
10202  AG06000621 06 661          View Edit Delete
10203  AG06000622 06 661          View Edit Delete
10204  AG06000623 06 661          View Edit Delete
10205  AG06000624 06 661          View Edit Delete
10206  AG06000625 06 661          View Edit Delete
10207  AG06000626 06 661          View Edit Delete
10208  AG06000627 06 661          View Edit Delete
10209  AG06000628 06 661          View Edit Delete

Page 123 of 373, showing 20 records out of 7458 total, starting on record 2441, ending on 2460

(default) 2 queries took 34 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 2440, 20202013
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 = 11121