Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9685  AG06000104 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9705  AG06000124 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9716  AG06000135 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9714  AG06000133 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9656  AG06000075 06 661          View Edit Delete
9771  AG06000190 06 661          View Edit Delete

Page 24 of 373, showing 20 records out of 7458 total, starting on record 461, ending on 480

(default) 2 queries took 23 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 460, 2020207
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