When do database queries occur when using a queryset?

Database queries when using QuerySet occur at several key moments, not during the creation of the QuerySet itself. This is due to the 'lazy' nature of QuerySet operations.

Main scenarios for executing queries:

• Iteration over QuerySet: When you iterate over QuerySet elements in a for loop or use functions like list(), tuple(), set().
• Slicing: When using slices (queryset[start:end]) without a step (queryset[start:end:step]). The query is executed to retrieve the requested range of objects. Slices with a negative step or a step other than 1 cause the query to be executed for the entire QuerySet, then processed in Python.
• Serialization/Conversion to string: When calling str(queryset) or repr(queryset).
• Truth value evaluation: When QuerySet is used in a conditional statement (if queryset:). The query is executed to check for the presence of at least one record.
• Using aggregate functions: When calling count(), sum(), avg(), max(), min(), and other aggregation functions.
• Calling methods that return a single object: Such as get(), first(), latest().
• Conversion to boolean: For example, in if not queryset:.

Examples:

# No database query occurs
queryset = MyModel.objects.filter(status='active')

# Query to the database to retrieve all objects
for obj in queryset:
    print(obj.name)

# Query to the database to get the first 10 objects
first_ten = queryset[:10]

# Query to the database to count objects
count = queryset.count()

# Query to the database to get the first object
first_obj = queryset.first()

# Query to the database to check for the presence of objects
if queryset:
    print("Objects found")

It is important to understand that Django caches the results of a QuerySet after the first query execution. Subsequent operations on the same QuerySet (which has already been evaluated) will use the cached data and will not perform additional database queries. However, if you modify the QuerySet (for example, by adding a new filter), it creates a new, unevaluated QuerySet, and the next operation that requires data access will trigger a new query.