Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9928  AG06000347 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9926  AG06000345 06 661          View Edit Delete
9925  AG06000344 06 661          View Edit Delete
9924  AG06000343 06 661          View Edit Delete
9923  AG06000342 06 661          View Edit Delete
9922  AG06000341 06 661          View Edit Delete
9921  AG06000340 06 661          View Edit Delete
9920  AG06000339 06 661          View Edit Delete
9919  AG06000338 06 661          View Edit Delete
9918  AG06000337 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9915  AG06000334 06 661          View Edit Delete
9914  AG06000333 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9909  AG06000328 06 661          View Edit Delete

Page 50 of 373, showing 20 records out of 7458 total, starting on record 981, ending on 1000

(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`.`farmer_id` desc LIMIT 980, 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