Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9871  AG06000290 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9869  AG06000288 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
9929  AG06000348 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
10059  AG06000478 06 661          View Edit Delete
10061  AG06000480 06 661          View Edit Delete
10062  AG06000481 06 661          View Edit Delete

Page 40 of 373, showing 20 records out of 7458 total, starting on record 781, ending on 800

(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`.`company_cd` desc LIMIT 780, 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