Skip to content

Instantly share code, notes, and snippets.

@prgTW

prgTW/explain_old_query.txt

Created July 9, 2020 11:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save prgTW/c06446a0fda98a3b596eb33d8ffed183 to your computer and use it in GitHub Desktop.
Save prgTW/c06446a0fda98a3b596eb33d8ffed183 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain_old_query.txt
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: agreement
type: ref
possible_keys: PRIMARY,customer_id
key: customer_id
key_len: 4
ref: const
rows: 2
Extra: Using index
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: product1
type: ref
possible_keys: agreement_id
key: agreement_id
key_len: 4
ref: main.agreement.id
rows: 22
Extra: Using where
2 rows in set (0.13 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment