Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9834  AG06000253 06 661          View Edit Delete
10196  AG06000615 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
10197  AG06000616 06 661          View Edit Delete
10066  AG06000485 06 661          View Edit Delete
10067  AG06000486 06 661          View Edit Delete
10068  AG06000487 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete
10070  AG06000489 06 661          View Edit Delete
10071  AG06000490 06 661          View Edit Delete
10072  AG06000491 06 661          View Edit Delete
10073  AG06000492 06 661          View Edit Delete
10074  AG06000493 06 661          View Edit Delete
10075  AG06000494 06 661          View Edit Delete
10076  AG06000495 06 661          View Edit Delete
10159  AG06000578 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete
10200  AG06000619 06 661          View Edit Delete
9840  AG06000259 06 661          View Edit Delete
10201  AG06000620 06 661          View Edit Delete

Page 46 of 373, showing 20 records out of 7458 total, starting on record 901, ending on 920

(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`.`company_cd` desc LIMIT 900, 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