Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10049  AG06000468 06 661          View Edit Delete
10050  AG06000469 06 661          View Edit Delete
10053  AG06000472 06 661          View Edit Delete
10054  AG06000473 06 661          View Edit Delete
10056  AG06000475 06 661          View Edit Delete
10057  AG06000476 06 661          View Edit Delete
10058  AG06000477 06 661          View Edit Delete
10059  AG06000478 06 661          View Edit Delete
10060  AG06000479 06 661          View Edit Delete
10061  AG06000480 06 661          View Edit Delete
10063  AG06000482 06 661          View Edit Delete
10064  AG06000483 06 661          View Edit Delete
10065  AG06000484 06 661          View Edit Delete
10066  AG06000485 06 661          View Edit Delete
10068  AG06000487 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
10071  AG06000490 06 661          View Edit Delete
10076  AG06000495 06 661          View Edit Delete
10077  AG06000496 06 661          View Edit Delete

Page 44 of 373, showing 20 records out of 7458 total, starting on record 861, ending on 880

(default) 2 queries took 23 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 860, 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 = 11116