Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9914  AG06000333 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9918  AG06000337 06 661          View Edit Delete
9921  AG06000340 06 661          View Edit Delete
9922  AG06000341 06 661          View Edit Delete
9924  AG06000343 06 661          View Edit Delete
9925  AG06000344 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9928  AG06000347 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9936  AG06000355 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9938  AG06000357 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete

Page 41 of 373, showing 20 records out of 7458 total, starting on record 801, ending on 820

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