Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10128  AG06000547 06 661          View Edit Delete
10127  AG06000546 06 661          View Edit Delete
10126  AG06000545 06 661          View Edit Delete
10125  AG06000544 06 661          View Edit Delete
10124  AG06000543 06 661          View Edit Delete
10123  AG06000542 06 661          View Edit Delete
10122  AG06000541 06 661          View Edit Delete
10121  AG06000540 06 661          View Edit Delete
10120  AG06000539 06 661          View Edit Delete
10119  AG06000538 06 661          View Edit Delete
10118  AG06000537 06 661          View Edit Delete
10117  AG06000536 06 661          View Edit Delete
10116  AG06000535 06 661          View Edit Delete
10115  AG06000534 06 661          View Edit Delete
10114  AG06000533 06 661          View Edit Delete
10113  AG06000532 06 661          View Edit Delete
10112  AG06000531 06 661          View Edit Delete
10111  AG06000530 06 661          View Edit Delete
10110  AG06000529 06 661          View Edit Delete
10109  AG06000528 06 661          View Edit Delete

Page 40 of 373, showing 20 records out of 7458 total, starting on record 781, ending on 800

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