Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10230  AG06000649 06 661          View Edit Delete
10231  AG06000650 06 661          View Edit Delete
10232  AG06000651 06 661          View Edit Delete
10233  AG06000652 06 661          View Edit Delete
10234  AG06000653 06 661          View Edit Delete
10235  AG06000654 06 661          View Edit Delete
10236  AG06000655 06 661          View Edit Delete
10237  AG06000656 06 661          View Edit Delete
10238  AG06000657 06 661          View Edit Delete
10239  AG06000658 06 661          View Edit Delete
10240  AG06000659 06 661          View Edit Delete
10241  AG06000660 06 661          View Edit Delete
10242  AG06000661 06 661          View Edit Delete
10243  AG06000662 06 661          View Edit Delete
10244  AG06000663 06 661          View Edit Delete
10245  AG06000664 06 661          View Edit Delete
10246  AG06000665 06 661          View Edit Delete
10247  AG06000666 06 661          View Edit Delete
10248  AG06000667 06 661          View Edit Delete
10249  AG06000668 06 661          View Edit Delete

Page 125 of 373, showing 20 records out of 7458 total, starting on record 2481, ending on 2500

(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`.`id` asc LIMIT 2480, 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 = 11116