Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
9788  AG06000207 06 661          View Edit Delete

Page 271 of 373, showing 20 records out of 7458 total, starting on record 5401, ending on 5420

(default) 2 queries took 36 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` desc LIMIT 5400, 20202019
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