Back

SQL Details

Executed SQL
SELECT category.status AS category_status, category.created_at AS category_created_at, category.deleted_at AS category_deleted_at, category.id AS category_id, category.title AS category_title, category.slug AS category_slug, anon_1.post_id AS anon_1_post_id FROM (SELECT post.id AS post_id FROM post ORDER BY post.priority DESC LIMIT %(param_1)s) AS anon_1 JOIN categories AS categories_1 ON anon_1.post_id = categories_1.post_id JOIN category ON category.id = categories_1.category_id ORDER BY anon_1.post_id
Original query duration
1.6682 ms
CATEGORY_STATUS CATEGORY_CREATED_AT CATEGORY_DELETED_AT CATEGORY_ID CATEGORY_TITLE CATEGORY_SLUG ANON_1_POST_ID
201 2018-03-20 16:08:20.623875 None 1 Men's wear men-s-wear 4
201 2018-03-20 16:08:20.634760 None 2 Women's wear women-s-wear 4
201 2018-03-20 16:08:20.623875 None 1 Men's wear men-s-wear 5
201 2018-03-20 16:12:33.399563 None 3 My category my-category 5