Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9822  AG06000241 06 661          View Edit Delete
9828  AG06000247 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9830  AG06000249 06 661          View Edit Delete
9827  AG06000246 06 661          View Edit Delete
9821  AG06000240 06 661          View Edit Delete
9837  AG06000256 06 661          View Edit Delete
9836  AG06000255 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9839  AG06000258 06 661          View Edit Delete
9842  AG06000261 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9820  AG06000239 06 661          View Edit Delete
9796  AG06000215 06 661          View Edit Delete
9844  AG06000263 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete

Page 24 of 373, showing 20 records out of 7458 total, starting on record 461, ending on 480

(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 460, 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