Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5504  AG02000005 02 51          View Edit Delete
5531  AG02000032 02 51          View Edit Delete
5602  AG01001559 01 002          View Edit Delete
5558  AG01001305 01 002          View Edit Delete
5561  AG01001250 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5568  AG01001720 01 002          View Edit Delete
5563  AG01001704 01 002          View Edit Delete
5516  AG02000017 02 51          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5521  AG02000022 02 51          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5529  AG02000030 02 51          View Edit Delete
5528  AG02000029 02 51          View Edit Delete
5520  AG02000021 02 51          View Edit Delete
5519  AG02000020 02 51          View Edit Delete

Page 4 of 373, showing 20 records out of 7458 total, starting on record 61, ending on 80

(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`.`created` asc LIMIT 60, 2020205
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 = 11118