Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9784  AG06000203 06 661          View Edit Delete
9780  AG06000199 06 661          View Edit Delete
9788  AG06000207 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
9787  AG06000206 06 661          View Edit Delete
9779  AG06000198 06 661          View Edit Delete
9778  AG06000197 06 661          View Edit Delete
9746  AG06000165 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete

Page 18 of 373, showing 20 records out of 7458 total, starting on record 341, ending on 360

(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 340, 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 = 11118