Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9716  AG06000135 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete
9775  AG06000194 06 661          View Edit Delete
9782  AG06000201 06 661          View Edit Delete
9781  AG06000200 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9785  AG06000204 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
9774  AG06000193 06 661          View Edit Delete
9768  AG06000187 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
10100  AG06000519 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9790  AG06000209 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete

Page 53 of 373, showing 20 records out of 7458 total, starting on record 1041, ending on 1060

(default) 2 queries took 25 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 1040, 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 = 11117