Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10135  AG06000554 06 661          View Edit Delete
10154  AG06000573 06 661          View Edit Delete
10629  AG06001048 06 661          View Edit Delete
10150  AG06000569 06 661          View Edit Delete
10137  AG06000556 06 661          View Edit Delete
10118  AG06000537 06 661          View Edit Delete
10080  AG06000499 06 661          View Edit Delete
10639  AG06001058 06 661          View Edit Delete
10151  AG06000570 06 661          View Edit Delete
10152  AG06000571 06 661          View Edit Delete
10169  AG06000588 06 661          View Edit Delete
10163  AG06000582 06 661          View Edit Delete
10165  AG06000584 06 661          View Edit Delete
10630  AG06001049 06 661          View Edit Delete
10635  AG06001054 06 661          View Edit Delete
10158  AG06000577 06 661          View Edit Delete
10070  AG06000489 06 661          View Edit Delete
9975  AG06000394 06 661          View Edit Delete
9976  AG06000395 06 661          View Edit Delete
9973  AG06000392 06 661          View Edit Delete

Page 62 of 373, showing 20 records out of 7458 total, starting on record 1221, ending on 1240

(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`.`trader_id` desc LIMIT 1220, 2020209
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 = 11117