Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9982  AG06000401 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9984  AG06000403 06 661          View Edit Delete
9985  AG06000404 06 661          View Edit Delete
9987  AG06000406 06 661          View Edit Delete
9988  AG06000407 06 661          View Edit Delete
9989  AG06000408 06 661          View Edit Delete
9990  AG06000409 06 661          View Edit Delete
9994  AG06000413 06 661          View Edit Delete
9995  AG06000414 06 661          View Edit Delete
9996  AG06000415 06 661          View Edit Delete
9997  AG06000416 06 661          View Edit Delete
9998  AG06000417 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9862  AG06000281 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
10001  AG06000420 06 661          View Edit Delete

Page 30 of 373, showing 20 records out of 7458 total, starting on record 581, ending on 600

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