Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10240  AG06000659 06 661          View Edit Delete
10239  AG06000658 06 661          View Edit Delete
10242  AG06000661 06 661          View Edit Delete
10241  AG06000660 06 661          View Edit Delete
10710  AG06001129 06 661          View Edit Delete
10245  AG06000664 06 661          View Edit Delete
10243  AG06000662 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
10247  AG06000666 06 661          View Edit Delete
10248  AG06000667 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
10035  AG06000454 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
10249  AG06000668 06 661          View Edit Delete
10252  AG06000671 06 661          View Edit Delete
10250  AG06000669 06 661          View Edit Delete
10255  AG06000674 06 661          View Edit Delete
10253  AG06000672 06 661          View Edit Delete
10258  AG06000677 06 661          View Edit Delete
10256  AG06000675 06 661          View Edit Delete

Page 65 of 373, showing 20 records out of 7458 total, starting on record 1281, ending on 1300

(default) 2 queries took 27 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 1280, 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 = 11118