Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6319  AG03000028 03 61          View Edit Delete
6320  AG03000029 03 61          View Edit Delete
6321  AG03000030 03 61          View Edit Delete
6322  AG01003001 01 010          View Edit Delete
6323  AG01003002 01 010          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6327  AG01003005 01 010          View Edit Delete
6328  AG02000036 02 51          View Edit Delete
6329  AG02000037 02 51          View Edit Delete
6330  AG02000038 02 51          View Edit Delete
6331  AG02000039 02 51          View Edit Delete
6332  AG02000040 02 51          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6335  AG01003008 01 010          View Edit Delete
6336  AG01002649 01 004  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6341  AG02000041 02 51          View Edit Delete

Page 19 of 373, showing 20 records out of 7458 total, starting on record 361, ending on 380

(default) 2 queries took 20 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 LIMIT 360, 2020202
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