Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10281  AG06000700 06 661          View Edit Delete
10279  AG06000698 06 661          View Edit Delete
10276  AG06000695 06 661          View Edit Delete
10269  AG06000688 06 661          View Edit Delete
10288  AG06000707 06 661          View Edit Delete
10286  AG06000705 06 661          View Edit Delete
10283  AG06000702 06 661          View Edit Delete
10290  AG06000709 06 661          View Edit Delete
10294  AG06000713 06 661          View Edit Delete
10292  AG06000711 06 661          View Edit Delete
10289  AG06000708 06 661          View Edit Delete
10282  AG06000701 06 661          View Edit Delete
10268  AG06000687 06 661          View Edit Delete
10240  AG06000659 06 661          View Edit Delete
10184  AG06000603 06 661          View Edit Delete
10296  AG06000715 06 661          View Edit Delete
10295  AG06000714 06 661          View Edit Delete
10183  AG06000602 06 661          View Edit Delete
9977  AG06000396 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 48 of 373, showing 20 records out of 7458 total, starting on record 941, ending on 960

(default) 2 queries took 24 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`.`update_user` asc LIMIT 940, 2020208
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 = 11116