Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Query Output:
- > EXPLAIN EXTENDED
- SELECT *
- FROM Article a0_
- INNER JOIN Content c1_ ON a0_.content_id = c1_.id
- INNER JOIN Category c2_ ON c1_.category_id = c2_.id
- INNER JOIN Content_Status c3_ ON c1_.content_status_id = c3_.id /* */
- INNER JOIN Cms_User c4_ ON c1_.create_user_id = c4_.id /* */
- WHERE a0_.content_id = c1_.id
- AND c2_.parent_id = 1
- ORDER BY c1_.last_update_date DESC /* */
- LIMIT 20 OFFSET 59840
- + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
- | id | select_type | TABLE | TYPE | possible_keys | KEY | key_len | REF | ROWS | filtered | Extra |
- + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
- | 1 | SIMPLE | a0_ | ALL | fk_Article_content_id | | | | 63909 | 100.00 | USING TEMPORARY; USING filesort |
- | 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 | |
- | 1 | SIMPLE | c4_ | eq_ref | PRIMARY | PRIMARY | 4 | hw_cms_test.c1_.create_user_id | 1 | 100.00 | |
- | 1 | SIMPLE | c3_ | eq_ref | PRIMARY | PRIMARY | 4 | hw_cms_test.c1_.content_status_id | 1 | 100.00 | |
- | 1 | SIMPLE | c2_ | eq_ref | PRIMARY | PRIMARY | 4 | hw_cms_test.c1_.category_id | 1 | 100.00 | USING WHERE |
- + ------- + ---------------- + ---------- + --------- + ------------------ + -------- + ------------ + -------- + --------- + ------------- + ---------- +
- 5 ROWS
Add Comment
Please, Sign In to add comment