Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9743  AG06000162 06 661          View Edit Delete
9727  AG06000146 06 661          View Edit Delete
9764  AG06000183 06 661          View Edit Delete
9760  AG06000179 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete
9767  AG06000186 06 661          View Edit Delete
9759  AG06000178 06 661          View Edit Delete
9758  AG06000177 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete

Page 17 of 373, showing 20 records out of 7458 total, starting on record 321, ending on 340

(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`.`insert_user` asc LIMIT 320, 2020207
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