Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9630  AG06000049 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9869  AG06000288 06 661          View Edit Delete
9639  AG06000058 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
9641  AG06000060 06 661          View Edit Delete
9866  AG06000285 06 661          View Edit Delete

Page 23 of 373, showing 20 records out of 7458 total, starting on record 441, ending on 460

(default) 2 queries took 22 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 440, 2020206
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