Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10050  AG06000469 06 661          View Edit Delete
10051  AG06000470 06 661          View Edit Delete
10052  AG06000471 06 661          View Edit Delete
10053  AG06000472 06 661          View Edit Delete
10054  AG06000473 06 661          View Edit Delete
10055  AG06000474 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
10062  AG06000481 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
10067  AG06000486 06 661          View Edit Delete
10068  AG06000487 06 661          View Edit Delete
10069  AG06000488 06 661          View Edit Delete

Page 116 of 373, showing 20 records out of 7458 total, starting on record 2301, ending on 2320

(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 2300, 2020208
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 = 11117