Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9808  AG06000227 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9806  AG06000225 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9796  AG06000215 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9794  AG06000213 06 661          View Edit Delete
9793  AG06000212 06 661          View Edit Delete
9792  AG06000211 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
9790  AG06000209 06 661          View Edit Delete
9789  AG06000208 06 661          View Edit Delete

Page 56 of 373, showing 20 records out of 7458 total, starting on record 1101, ending on 1120

(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`.`farmer_id` desc LIMIT 1100, 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 = 11116