Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9848  AG06000267 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9846  AG06000265 06 661          View Edit Delete
9845  AG06000264 06 661          View Edit Delete
9844  AG06000263 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9842  AG06000261 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9840  AG06000259 06 661          View Edit Delete
9839  AG06000258 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete
9837  AG06000256 06 661          View Edit Delete
9836  AG06000255 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9830  AG06000249 06 661          View Edit Delete
9829  AG06000248 06 661          View Edit Delete

Page 54 of 373, showing 20 records out of 7458 total, starting on record 1061, ending on 1080

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