Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10016  AG06000435 06 661          View Edit Delete
10251  AG06000670 06 661          View Edit Delete
10001  AG06000420 06 661          View Edit Delete
10002  AG06000421 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
10031  AG06000450 06 661          View Edit Delete
10029  AG06000448 06 661          View Edit Delete
10007  AG06000426 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
10012  AG06000431 06 661          View Edit Delete
10015  AG06000434 06 661          View Edit Delete
9988  AG06000407 06 661          View Edit Delete
10018  AG06000437 06 661          View Edit Delete
10019  AG06000438 06 661          View Edit Delete
10023  AG06000442 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9869  AG06000288 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
10252  AG06000671 06 661          View Edit Delete
10030  AG06000449 06 661          View Edit Delete

Page 43 of 373, showing 20 records out of 7458 total, starting on record 841, ending on 860

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