Skip to content

Instantly share code, notes, and snippets.

@pushcx

pushcx/explain.sql

Created March 3, 2022 15:16
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 pushcx/a28ca09238fb9491f7ccf84ce1d4620e to your computer and use it in GitHub Desktop.
Save pushcx/a28ca09238fb9491f7ccf84ce1d4620e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain.sql
> explain SELECT `replying_comments`.* FROM `replying_comments` WHERE `replying_comments`.`user_id` = 0 ORDER BY `replying_comments`.`comment_created_at` DESC LIMIT 25 OFFSET 0;
+---+---+---+---+---+---+---+---+---+---+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+---+---+---+---+---+---+---+---+---+---+
| 1 | SIMPLE | com | index | pageid | pageid | 767 | NULL | 130624 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | a | eq_ref | PRIMARY,idx_section,idx_state,idx_catid | PRIMARY | 4 | faktyp_dd.com.pageid | 1 | Using index condition; Using where |
| 1 | SIMPLE | f | eq_ref | PRIMARY | PRIMARY | 4 | faktyp_dd.a.id | 1 | Using where; Using index |
| 1 | SIMPLE | cc | eq_ref | PRIMARY | PRIMARY | 4 | faktyp_dd.a.catid | 1 | Using index condition; Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | faktyp_dd.f.content_id | 1 | Using index condition; Using where |
| 1 | SIMPLE | s | eq_ref | PRIMARY | PRIMARY | 4 | faktyp_dd.a.sectionid | 1 | Using index condition; Using where |
+---+---+---+---+---+---+---+---+---+---+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment