SELECT cms_nodes.id, cms_nodes.author_id, cms_nodes.parent_id, cms_nodes.kind, cms_nodes.status, cms_nodes.date, cms_nodes.creation_date, cms_nodes.modification_date, cms_nodes.data, cms_nodes.index, cms_nodes.quick_access, cms_nodes.protected, cms_nodes.excluded_from_nav
FROM cms_nodes
WHERE cms_nodes.parent_id = %(parent_id_1)s AND cms_nodes.status = %(status_1)s ORDER BY cms_nodes.creation_date DESC
LIMIT %(param_1)s
| QUERY PLAN |
|---|
| Limit (cost=5.89..5.90 rows=4 width=545) |
| -> Sort (cost=5.89..5.91 rows=7 width=545) |
| Sort Key: creation_date DESC |
| -> Seq Scan on cms_nodes (cost=0.00..5.79 rows=7 width=545) |
| Filter: ((parent_id = 9) AND (status = 'published'::text)) |