Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9950  AG06000369 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9954  AG06000373 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9957  AG06000376 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9962  AG06000381 06 661          View Edit Delete
9965  AG06000384 06 661          View Edit Delete
9966  AG06000385 06 661          View Edit Delete
10227  AG06000646 06 661          View Edit Delete
9968  AG06000387 06 661          View Edit Delete
9975  AG06000394 06 661          View Edit Delete
10226  AG06000645 06 661          View Edit Delete
10224  AG06000643 06 661          View Edit Delete
9979  AG06000398 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
9986  AG06000405 06 661          View Edit Delete
10143  AG06000562 06 661          View Edit Delete

Page 42 of 373, showing 20 records out of 7458 total, starting on record 821, ending on 840

(default) 2 queries took 26 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`.`trader_id` desc LIMIT 820, 2020208
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 = 11118