Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9962  AG06000381 06 661          View Edit Delete
10040  AG06000459 06 661          View Edit Delete
10041  AG06000460 06 661          View Edit Delete
10042  AG06000461 06 661          View Edit Delete
10043  AG06000462 06 661          View Edit Delete
10044  AG06000463 06 661          View Edit Delete
10046  AG06000465 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
10049  AG06000468 06 661          View Edit Delete
10051  AG06000470 06 661          View Edit Delete
10052  AG06000471 06 661          View Edit Delete
10227  AG06000646 06 661          View Edit Delete
10175  AG06000594 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
10176  AG06000595 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
10177  AG06000596 06 661          View Edit Delete
9966  AG06000385 06 661          View Edit Delete
9818  AG06000237 06 661          View Edit Delete
10178  AG06000597 06 661          View Edit Delete

Page 45 of 373, showing 20 records out of 7458 total, starting on record 881, ending on 900

(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`.`company_cd` desc LIMIT 880, 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