Gå til innhold

Norsk nettsted for vevsutvikling - tanker og ideer


Anbefalte innlegg

Videoannonse
Annonse
Gjest Slettet-df17e

Kan ikke folket komme seg på IRC ? Ihvertfall ha et lite "møte" der, for å snakke litt om hvordan vi skal få blitt ferdig nå.

 

EDIT: Jeg har tid til å både skrive artikkler og jobbe med back- og front-end.

Endret av Slettet-df17e
Lenke til kommentar
  • 4 uker senere...
Bør være en middleware som sender med en rekke kolleksjoner av data vi somregel bruker.

Som flatpages, nyeste artikler, nyeste kommentarer osv..

 

Da har vi alltid tilgang til de data uten å måtte spessifisere det selv om vi bruker generic view

Dette er da mye lettere å gjøre med templatetags.

 

Regner med at det var dette du hadde tenkt til å gjøre:

Klikk for å se/fjerne innholdet nedenfor
from django import template
from wds.articles.models import Category, Article, Comment
from wds.flatpages.models import Flatpage

register = template.Library()

class DoGetList:
"""
{% get_category_list as category_list %}
"""
def __init__(self, tag_name, class_name):
	self.tag_name = tag_name
	self.class_name = class_name

def __call__(self, parser, token):
	bits = token.contents.split()
	if len(bits) != 3:
		raise template.TemplateSyntaxError, "'%s' tag takes two arguments" % bits[0]
	if bits[1] != "as":
		raise template.TemplateSyntaxError, "First argument to '%s' tag must be 'as'" % bits[0]
	return self.class_name(bits[2])

class CategoryListNode(template.Node):
def __init__(self,varname):
	self.varname = varname

def __repr__(self):
	return "<CategoryList Node>"

def render(self, context):
	context[self.varname] = Category.objects.all()
	return ''

class ArticleListNode(template.Node):
def __init__(self,varname):
	self.varname = varname

def __repr__(self):
	return "<ArticleList Node>"

def render(self, context):
	context[self.varname] = Article.objects.filter(is_published=True)[:10]
	return ''

class CommentListNode(template.Node):
def __init__(self,varname):
	self.varname = varname

def __repr__(self):
	return "<CommentList Node>"

def render(self, context):
	context[self.varname] = Comment.objects.all()[:10]
	return ''

class FlatpageListNode(template.Node):
def __init__(self,varname):
	self.varname = varname

def __repr__(self):
	return "<FlatpageList Node>"

def render(self, context):
	context[self.varname] = Flatpage.objects.filter(is_published=True)
	return ''

register.tag('get_category_list', DoGetList('get_category_list', CategoryListNode))
register.tag('get_article_list', DoGetList('get_article_list', ArticleListNode))
register.tag('get_comment_list', DoGetList('get_comment_list', CommentListNode))
register.tag('get_flatpage_list', DoGetList('get_flatpage_list', FlatpageListNode))

Endret av JonT
Lenke til kommentar

Bare erstatt /wds/utils/templatetags/listnings.py med den filen.

(Så lenge det ikke ligger mer enn List-Category saken der fortsatt.)

 

Har ikke testet ut saken på WDS-prosjektet. Men bruker det på mine egne Django saker, og der funker det helt strålende.

 

I template fila:

{% load listings %}
{% get_category_list as category_list  %}
<ul>
{% for cat in category_list %}
<li>
<a href="/{{ cat.slug }}" title="Besøk arkivet for {{ cat.name }}">{{ cat.name }}</a>
</li>
{% endfor %}
</ul>

{% load listings %}
{% get_article_list as article_list  %}
<ul>
{% for article in article_list %}
<li><a href="/{{ article.slug }}">{{ article.name }}</a></li>
{% endfor %}
</ul>

 

osv.

 

EDIT: Ta å se over queryset til de forskjellige listningsakene. Er ikke helt sikker på om det er riktig i forhold til WDS.

Endret av JonT
Lenke til kommentar
Her må vi få inn caching, altså. Om vi har ti kategorier og ti flatpages blir dette tjue ekstra spørringer pr. sidevisning.

Eg husker ikkje kva vi har tilgang til av caching hos Subsys, men eg veit at VPS og memcached-løysinger er på veg. :)

20? Det blir da bare 1 på hver.

 

Er da bare å kjøre local eller pagecache i mellomtiden. Enkelt å endre på etterpå hvis det blir mulighet for litt mer heavy saker.

Endret av JonT
Lenke til kommentar

Ikkje om du bruker standard-ORM-en til Django. :)

Django-ORM-en er "lazy" - den henter berre ut det den treng akkurat der og då.

 

Her er SQL-en til ei side på eit prosjekt eg driv med:

 

 

<div id="sqlstats">

<p><em>Total query count:</em> 102<br/>
<em>Total execution time:</em> 0.096</p>
<ul class="sqllog">

       <li>0.005: SELECT "django_session"."session_key","django_session"."session_data","django_session"."expire_date" FROM "django_session" WHERE ("django_session"."session_key" = 05c5d0dbb1e283f6e673b370eb446b36 AND "django_session"."expire_date" > 2007-10-15 18:19:38.873084)</li>

       <li>0.003: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>


       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."username" = dittasss)</li>


       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.002: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 1)</li>

       <li>0.001: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 1)</li>


       <li>0.002: SELECT "auth_message"."id","auth_message"."user_id","auth_message"."message" FROM "auth_message" WHERE ("auth_message"."user_id" = 1)</li>

       <li>0.002: SELECT "django_content_type"."id","django_content_type"."name","django_content_type"."app_label","django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."app_label" = blog AND "django_content_type"."model" = entry)</li>

       <li>0.001: SELECT COUNT(*) FROM "profile_unreadmessage" WHERE ("profile_unreadmessage"."read" = False AND "profile_unreadmessage"."user_id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "groups_groupinvite" WHERE ("groups_groupinvite"."requested_id" = 1 AND "groups_groupinvite"."accepted" = False)</li>

       <li>0.001: SELECT COUNT(*) FROM "profile_friendrequest" WHERE ("profile_friendrequest"."requested_id" = 1 AND "profile_friendrequest"."verified" = False)</li>

       <li>0.002: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 1)</li>


       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.003: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."is_active" = True) ORDER BY "auth_user"."date_joined" DESC LIMIT 50 </li>

       <li>0.001: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 9)</li>

       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 9)</li>

       <li>0.001: SELECT "profile_privacyinfo"."id","profile_privacyinfo"."display_on_map","profile_privacyinfo"."display_real_name","profile_privacyinfo"."display_full_age","profile_privacyinfo"."display_address","profile_privacyinfo"."display_email","profile_privacyinfo"."display_msn","profile_privacyinfo"."display_skype" FROM "profile_privacyinfo" WHERE ("profile_privacyinfo"."id" = 9)</li>

       <li>0.001: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 8)</li>


       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 8)</li>

       <li>0.001: SELECT "profile_privacyinfo"."id","profile_privacyinfo"."display_on_map","profile_privacyinfo"."display_real_name","profile_privacyinfo"."display_full_age","profile_privacyinfo"."display_address","profile_privacyinfo"."display_email","profile_privacyinfo"."display_msn","profile_privacyinfo"."display_skype" FROM "profile_privacyinfo" WHERE ("profile_privacyinfo"."id" = 8)</li>

       <li>0.001: SELECT "profile_unguser"."id","profile_unguser"."user_id","profile_unguser"."gender","profile_unguser"."long_cord","profile_unguser"."lat_cord","profile_unguser"."personal_info_id","profile_unguser"."contact_info_id","profile_unguser"."privacy_info_id","profile_unguser"."statusmessage","profile_unguser"."code","profile_unguser"."urort_id","profile_unguser"."online","profile_unguser"."last_login","profile_unguser"."avatar","profile_unguser"."image" FROM "profile_unguser" WHERE ("profile_unguser"."user_id" = 1)</li>

       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.000: SELECT "profile_privacyinfo"."id","profile_privacyinfo"."display_on_map","profile_privacyinfo"."display_real_name","profile_privacyinfo"."display_full_age","profile_privacyinfo"."display_address","profile_privacyinfo"."display_email","profile_privacyinfo"."display_msn","profile_privacyinfo"."display_skype" FROM "profile_privacyinfo" WHERE ("profile_privacyinfo"."id" = 1)</li>

       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>


       <li>0.000: SELECT "profile_privacyinfo"."id","profile_privacyinfo"."display_on_map","profile_privacyinfo"."display_real_name","profile_privacyinfo"."display_full_age","profile_privacyinfo"."display_address","profile_privacyinfo"."display_email","profile_privacyinfo"."display_msn","profile_privacyinfo"."display_skype" FROM "profile_privacyinfo" WHERE ("profile_privacyinfo"."id" = 1)</li>

       <li>0.001: SELECT "profile_personalinfo"."id","profile_personalinfo"."birthday","profile_personalinfo"."homepage","profile_personalinfo"."music","profile_personalinfo"."tv","profile_personalinfo"."movies","profile_personalinfo"."interests" FROM "profile_personalinfo" WHERE ("profile_personalinfo"."id" = 1)</li>

       <li>0.001: SELECT "profile_contactinfo"."id","profile_contactinfo"."city_id","profile_contactinfo"."address","profile_contactinfo"."email","profile_contactinfo"."msn","profile_contactinfo"."skype","profile_contactinfo"."phonenumber" FROM "profile_contactinfo" WHERE ("profile_contactinfo"."id" = 1)</li>

       <li>0.001: SELECT "administrasjon_city"."id","administrasjon_city"."name","administrasjon_city"."slug","administrasjon_city"."county","administrasjon_city"."latitude","administrasjon_city"."longitude" FROM "administrasjon_city" WHERE ("administrasjon_city"."id" = 25)</li>

       <li>0.003: SELECT "filer_image"."id","filer_image"."album_id","filer_image"."image","filer_image"."thumb","filer_image"."title","filer_image"."description","filer_image"."longitude","filer_image"."latitude","filer_image"."tags","filer_image"."pub_date","filer_image"."views","filer_image"."votes","filer_image"."interesting" FROM "filer_image" INNER JOIN "filer_album" AS "filer_image__album" ON "filer_image"."album_id" = "filer_image__album"."id" WHERE ("filer_image__album"."author_id" = 1) LIMIT 4 </li>

       <li>0.001: SELECT "filer_album"."id","filer_album"."author_id","filer_album"."title","filer_album"."slug","filer_album"."short_description","filer_album"."pub_date","filer_album"."long_description","filer_album"."created" FROM "filer_album" WHERE ("filer_album"."id" = 3)</li>


       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.001: SELECT "filer_album"."id","filer_album"."author_id","filer_album"."title","filer_album"."slug","filer_album"."short_description","filer_album"."pub_date","filer_album"."long_description","filer_album"."created" FROM "filer_album" WHERE ("filer_album"."id" = 3)</li>

       <li>0.001: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.001: SELECT "filer_album"."id","filer_album"."author_id","filer_album"."title","filer_album"."slug","filer_album"."short_description","filer_album"."pub_date","filer_album"."long_description","filer_album"."created" FROM "filer_album" WHERE ("filer_album"."id" = 3)</li>

       <li>0.000: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.000: SELECT "filer_album"."id","filer_album"."author_id","filer_album"."title","filer_album"."slug","filer_album"."short_description","filer_album"."pub_date","filer_album"."long_description","filer_album"."created" FROM "filer_album" WHERE ("filer_album"."id" = 3)</li>


       <li>0.000: SELECT "auth_user"."id","auth_user"."username","auth_user"."first_name","auth_user"."last_name","auth_user"."email","auth_user"."password","auth_user"."is_staff","auth_user"."is_active","auth_user"."is_superuser","auth_user"."last_login","auth_user"."date_joined" FROM "auth_user" WHERE ("auth_user"."id" = 1)</li>

       <li>0.005: SELECT "blog_entry"."id","blog_entry"."author_id","blog_entry"."blog_id","blog_entry"."title","blog_entry"."slug","blog_entry"."top_image","blog_entry"."intro","blog_entry"."body","blog_entry"."pub_date","blog_entry"."last_modified","blog_entry"."views","blog_entry"."link","blog_entry"."guid","blog_entry"."deleted","blog_entry"."comments_enabled","blog_entry"."published","blog_entry"."votes","blog_entry"."tags","blog_entry"."image_gallery","blog_entry"."interestingness" FROM "blog_entry" WHERE ("blog_entry"."blog_id" = 1) ORDER BY "blog_entry"."pub_date" DESC</li>

       <li>0.001: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 53)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 30)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 29)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 28)</li>

       <li>0.001: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 27)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 26)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 25)</li>

       <li>0.001: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 24)</li>


       <li>0.001: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 23)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 22)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 21)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 20)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 19)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 18)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 17)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 16)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 15)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.002: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 14)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 13)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 12)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 11)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 10)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 9)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 8)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 7)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 6)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 5)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 4)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 3)</li>


       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 2)</li>

       <li>0.000: SELECT "blog_blog"."id","blog_blog"."author_id","blog_blog"."name","blog_blog"."tagline","blog_blog"."created","blog_blog"."views","blog_blog"."is_public","blog_blog"."slug","blog_blog"."description" FROM "blog_blog" WHERE ("blog_blog"."id" = 1)</li>

       <li>0.001: SELECT COUNT(*) FROM "comments_comment" INNER JOIN "django_content_type" AS "comments_comment__content_type" ON "comments_comment"."content_type_id" = "comments_comment__content_type"."id" WHERE ("comments_comment__content_type"."model" = entry AND "comments_comment"."site_id" = 1 AND "comments_comment__content_type"."app_label" = blog AND "comments_comment"."object_id" = 1)</li>

</ul>

 

 

 

Så det blir nok tjue spørringer, skjønner du. :)

Lenke til kommentar

Opprett en konto eller logg inn for å kommentere

Du må være et medlem for å kunne skrive en kommentar

Opprett konto

Det er enkelt å melde seg inn for å starte en ny konto!

Start en konto

Logg inn

Har du allerede en konto? Logg inn her.

Logg inn nå
×
×
  • Opprett ny...