Skip to content

Instantly share code, notes, and snippets.

@prgTW

prgTW/explain_new_query.txt

Last active July 9, 2020 11:59
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/37f86a5e62ff5b770653b98ebd7fa154 to your computer and use it in GitHub Desktop.
Save prgTW/37f86a5e62ff5b770653b98ebd7fa154 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain_new_query.txt
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: agreement
type: ref
possible_keys: customer_id
key: customer_id
key_len: 4
ref: const
rows: 2
Extra: Using where; 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
*************************** 3. row ***************************
id: 1
select_type: SIMPLE
table: product2
type: ref
possible_keys: agreement_id
key: agreement_id
key_len: 4
ref: main.agreement.id
rows: 6
Extra: Using where
3 rows in set (0.03 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment