Guest User

Untitled

a guest
Mar 14th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.97 KB | None | 0 0
  1. Query Output:
  2. > EXPLAIN EXTENDED
  3. SELECT *
  4. FROM Article a0_
  5. INNER JOIN Content c1_ ON a0_.content_id = c1_.id
  6. INNER JOIN Category c2_ ON c1_.category_id = c2_.id
  7. INNER JOIN Content_Status c3_ ON c1_.content_status_id = c3_.id /* */
  8. INNER JOIN Cms_User c4_ ON c1_.create_user_id = c4_.id /* */
  9. WHERE a0_.content_id = c1_.id
  10. AND c2_.parent_id = 1
  11. ORDER BY c1_.last_update_date DESC /* */
  12. LIMIT 20 OFFSET 59840
  13.  
  14. + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
  15. | id      | select_type      | TABLE      | TYPE      | possible_keys      | KEY      | key_len      | REF      | ROWS      | filtered      | Extra      |
  16. + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
  17. | 1       | SIMPLE           | a0_        | ALL       | fk_Article_content_id |          |              |          | 63909     | 100.00        | USING TEMPORARY; USING filesort |
  18. | 1       | SIMPLE           | c1_        | eq_ref    | PRIMARY,fk_Content_create_user_id,fk_Content_content_status_id,fk_Content_category_id | PRIMARY  | 4            | hw_cms_test.a0_.content_id | 1         | 100.00        |            |
  19. | 1       | SIMPLE           | c4_        | eq_ref    | PRIMARY            | PRIMARY  | 4            | hw_cms_test.c1_.create_user_id | 1         | 100.00        |            |
  20. | 1       | SIMPLE           | c3_        | eq_ref    | PRIMARY            | PRIMARY  | 4            | hw_cms_test.c1_.content_status_id | 1         | 100.00        |            |
  21. | 1       | SIMPLE           | c2_        | eq_ref    | PRIMARY            | PRIMARY  | 4            | hw_cms_test.c1_.category_id | 1         | 100.00        | USING WHERE |
  22. + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
  23. 5 ROWS
Add Comment
Please, Sign In to add comment