Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10054  AG06000473 06 661          View Edit Delete
10052  AG06000471 06 661          View Edit Delete
10048  AG06000467 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
10061  AG06000480 06 661          View Edit Delete
10059  AG06000478 06 661          View Edit Delete
10055  AG06000474 06 661          View Edit Delete
10047  AG06000466 06 661          View Edit Delete
10033  AG06000452 06 661          View Edit Delete
10068  AG06000487 06 661          View Edit Delete
10064  AG06000483 06 661          View Edit Delete
10072  AG06000491 06 661          View Edit Delete
10071  AG06000490 06 661          View Edit Delete
10063  AG06000482 06 661          View Edit Delete
10062  AG06000481 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
9984  AG06000403 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 41 of 373, showing 20 records out of 7458 total, starting on record 801, ending on 820

(default) 2 queries took 25 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`.`insert_user` asc LIMIT 800, 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 = 11117