Главная категория

  Forum
Topics
Messages
 Last message
 

Тестовый форум №1

подпись к тестовому форуму
 1 40 from lorien in 09:27 Nov, 23
 

Тестовый форум № 2

ещё одна подпись
 3 9 from ero_sennin in 12:50 Nov, 06
debug sql count: 8, sql time: 0.007

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">forum_category</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_category</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">title</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">forum_category</span><span class="o">`</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">title</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">description</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">category_id</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_message_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">message_count</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">thread_count</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">forum_forum</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">category_id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">1</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">title</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">content</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">content_rendered</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">render_method</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">category_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">forum_id</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">time_created</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">children_count</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">view_count</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">root_id</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">parent_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_message_id</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">forum_message</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">49</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">username</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">first_name</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_name</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">email</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">password</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_staff</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_active</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_superuser</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_login</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">date_joined</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">auth_user</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">1</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">name</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">icq</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">phone</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">email</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">site</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">avatar</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">1</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">title</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">content</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">content_rendered</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">render_method</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">category_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">forum_id</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">time_created</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">children_count</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">view_count</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">root_id</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">parent_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_message_id</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">forum_message</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">forum_message</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">43</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">username</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">first_name</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_name</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">email</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">password</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_staff</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_active</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">is_superuser</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">last_login</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">date_joined</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">auth_user</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">auth_user</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">30</span><span class="p">)</span>
</pre></div>

<div class="highlight"><pre><span class="k">SELECT</span> <span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">name</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">icq</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">phone</span><span class="o">`</span><span class="p">,</span>
<span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">email</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">site</span><span class="o">`</span><span class="p">,</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">avatar</span><span class="o">`</span>
<span class="k">FROM</span> <span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span>
<span class="k">WHERE</span> <span class="p">(</span><span class="o">`</span><span class="n">userprofile_userprofile</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">user_id</span><span class="o">`</span> <span class="o">=</span> <span class="mi">30</span><span class="p">)</span>
</pre></div>