Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10213  AG06000632 06 661          View Edit Delete
10185  AG06000604 06 661          View Edit Delete
10243  AG06000662 06 661          View Edit Delete
10250  AG06000669 06 661          View Edit Delete
10254  AG06000673 06 661          View Edit Delete
10252  AG06000671 06 661          View Edit Delete
10249  AG06000668 06 661          View Edit Delete
10242  AG06000661 06 661          View Edit Delete
10261  AG06000680 06 661          View Edit Delete
10259  AG06000678 06 661          View Edit Delete
10256  AG06000675 06 661          View Edit Delete
10263  AG06000682 06 661          View Edit Delete
10262  AG06000681 06 661          View Edit Delete
10255  AG06000674 06 661          View Edit Delete
10241  AG06000660 06 661          View Edit Delete
10240  AG06000659 06 661          View Edit Delete
10184  AG06000603 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 47 of 373, showing 20 records out of 7458 total, starting on record 921, ending on 940

(default) 2 queries took 25 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 920, 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 = 11117