Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9631  AG06000050 06 661          View Edit Delete
9636  AG06000055 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9630  AG06000049 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9644  AG06000063 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9651  AG06000070 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
10162  AG06000581 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
10367  AG06000786 06 661          View Edit Delete
10346  AG06000765 06 661          View Edit Delete

Page 48 of 373, showing 20 records out of 7458 total, starting on record 941, ending on 960

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