Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5558  AG01001305 01 002          View Edit Delete
5563  AG01001704 01 002          View Edit Delete
5572  AG01001874 01 002          View Edit Delete
5568  AG01001720 01 002          View Edit Delete
5561  AG01001250 01 002          View Edit Delete
5557  AG01001931 01 002          View Edit Delete
5551  AG01001278 01 002          View Edit Delete
5583  AG01002588 01 002          View Edit Delete
5581  AG01001265 01 002          View Edit Delete
5584  AG01001257 01 002          View Edit Delete
5578  AG01001713 01 002          View Edit Delete
5576  AG01001844 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5544  AG01001569 01 002          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5541  AG01001739 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete

Page 14 of 373, showing 20 records out of 7458 total, starting on record 261, ending on 280

(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`.`trader_id` asc LIMIT 260, 2020206
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