Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10052  AG06000471 06 661          View Edit Delete
10053  AG06000472 06 661          View Edit Delete
10078  AG06000497 06 661          View Edit Delete
10074  AG06000493 06 661          View Edit Delete
10066  AG06000485 06 661          View Edit Delete
10071  AG06000490 06 661          View Edit Delete
10082  AG06000501 06 661          View Edit Delete
10081  AG06000500 06 661          View Edit Delete
10087  AG06000506 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
10088  AG06000507 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
10585  AG06001004 06 661          View Edit Delete
10058  AG06000477 06 661          View Edit Delete
10089  AG06000508 06 661          View Edit Delete
10091  AG06000510 06 661          View Edit Delete
10061  AG06000480 06 661          View Edit Delete
10028  AG06000447 06 661          View Edit Delete
10016  AG06000435 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete

Page 60 of 373, showing 20 records out of 7458 total, starting on record 1181, ending on 1200

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