Back

SQL Details

Executed SQL
EXPLAIN
SELECT item_type_mapping.created AS item_type_mapping_created, item_type_mapping.updated AS item_type_mapping_updated, item_type_mapping.id AS item_type_mapping_id, item_type_mapping.item_type_id AS item_type_mapping_item_type_id, item_type_mapping.mapping AS item_type_mapping_mapping, item_type_mapping.version_id AS item_type_mapping_version_id 
FROM item_type_mapping 
WHERE item_type_mapping.item_type_id = %(item_type_id_1)s AND item_type_mapping.mapping IS NOT NULL ORDER BY item_type_mapping.created DESC 
 LIMIT %(param_1)s
Original query duration
0.4647 ms
QUERY PLAN
Limit (cost=21.52..21.53 rows=1 width=60)
-> Sort (cost=21.52..21.54 rows=5 width=60)
Sort Key: created DESC
-> Seq Scan on item_type_mapping (cost=0.00..21.50 rows=5 width=60)
Filter: ((mapping IS NOT NULL) AND (item_type_id = 21))