Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10095  AG06000514 06 661          View Edit Delete
10132  AG06000551 06 661          View Edit Delete
10128  AG06000547 06 661          View Edit Delete
10136  AG06000555 06 661          View Edit Delete
10141  AG06000560 06 661          View Edit Delete
10139  AG06000558 06 661          View Edit Delete
10135  AG06000554 06 661          View Edit Delete
10127  AG06000546 06 661          View Edit Delete
10149  AG06000568 06 661          View Edit Delete
10147  AG06000566 06 661          View Edit Delete
10143  AG06000562 06 661          View Edit Delete
10151  AG06000570 06 661          View Edit Delete
10150  AG06000569 06 661          View Edit Delete
10142  AG06000561 06 661          View Edit Delete
10126  AG06000545 06 661          View Edit Delete
10094  AG06000513 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 43 of 373, showing 20 records out of 7458 total, starting on record 841, ending on 860

(default) 2 queries took 26 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`.`insert_user` asc LIMIT 840, 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 = 11118