Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10422  AG06000841 06 661          View Edit Delete
10220  AG06000639 06 661          View Edit Delete
10348  AG06000767 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9982  AG06000401 06 661          View Edit Delete
10407  AG06000826 06 661          View Edit Delete
10435  AG06000854 06 661          View Edit Delete
10429  AG06000848 06 661          View Edit Delete
10432  AG06000851 06 661          View Edit Delete
10434  AG06000853 06 661          View Edit Delete
10430  AG06000849 06 661          View Edit Delete
10423  AG06000842 06 661          View Edit Delete
10448  AG06000867 06 661          View Edit Delete
10446  AG06000865 06 661          View Edit Delete
10455  AG06000874 06 661          View Edit Delete
10453  AG06000872 06 661          View Edit Delete
10450  AG06000869 06 661          View Edit Delete
10457  AG06000876 06 661          View Edit Delete
10456  AG06000875 06 661          View Edit Delete
10449  AG06000868 06 661          View Edit Delete

Page 51 of 373, showing 20 records out of 7458 total, starting on record 1001, ending on 1020

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