Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10092  AG06000511 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
10095  AG06000514 06 661          View Edit Delete
10096  AG06000515 06 661          View Edit Delete
10097  AG06000516 06 661          View Edit Delete
10098  AG06000517 06 661          View Edit Delete
10101  AG06000520 06 661          View Edit Delete
10102  AG06000521 06 661          View Edit Delete
10104  AG06000523 06 661          View Edit Delete
10105  AG06000524 06 661          View Edit Delete
9903  AG06000322 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
10108  AG06000527 06 661          View Edit Delete
10109  AG06000528 06 661          View Edit Delete
10113  AG06000532 06 661          View Edit Delete
10114  AG06000533 06 661          View Edit Delete
10116  AG06000535 06 661          View Edit Delete
10117  AG06000536 06 661          View Edit Delete
10120  AG06000539 06 661          View Edit Delete
10121  AG06000540 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 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 880, 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