Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6329  AG02000037 02 51          View Edit Delete
6328  AG02000036 02 51          View Edit Delete
6331  AG02000039 02 51          View Edit Delete
6330  AG02000038 02 51          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6332  AG02000040 02 51          View Edit Delete
6335  AG01003008 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6342  AG02000042 02 51          View Edit Delete
6341  AG02000041 02 51          View Edit Delete
6344  AG01003012 01 010          View Edit Delete
6343  AG01003011 01 010          View Edit Delete
6348  AG02000044 02 51          View Edit Delete
6347  AG01003014 01 010          View Edit Delete
6350  AG02000046 02 51          View Edit Delete
6349  AG02000045 02 51          View Edit Delete
6352  AG02000047 02 51          View Edit Delete
6351  AG01003015 01 010          View Edit Delete

Page 12 of 373, showing 20 records out of 7458 total, starting on record 221, ending on 240

(default) 2 queries took 22 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`.`created` asc LIMIT 220, 2020206
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