templates/skin/common.database-debug.tpl

   1 {**************************************************************************}
   2 {*                                                                        *}
   3 {*  Copyright (C) 2003-2006 Polytechnique.org                             *}
   4 {*  http://opensource.polytechnique.org/                                  *}
   5 {*                                                                        *}
   6 {*  This program is free software; you can redistribute it and/or modify  *}
   7 {*  it under the terms of the GNU General Public License as published by  *}
   8 {*  the Free Software Foundation; either version 2 of the License, or     *}
   9 {*  (at your option) any later version.                                   *}
  10 {*                                                                        *}
  11 {*  This program is distributed in the hope that it will be useful,       *}
  12 {*  but WITHOUT ANY WARRANTY; without even the implied warranty of        *}
  13 {*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *}
  14 {*  GNU General Public License for more details.                          *}
  15 {*                                                                        *}
  16 {*  You should have received a copy of the GNU General Public License     *}
  17 {*  along with this program; if not, write to the Free Software           *}
  18 {*  Foundation, Inc.,                                                     *}
  19 {*  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA               *}
  20 {*                                                                        *}
  21 {**************************************************************************}
  22
  23
  24 {foreach item=query from=$trace_data}
  25 <table class="bicol" style="width: 75%; font-family: monospace; font-size: smaller; margin-left:2px; margin-top: 3px;">
  26   <tr class="impair">
  27     <td>
  28       <strong>QUERY:</strong>
  29       <pre style="padding: 0; margin: 0;">{$query.query}</pre>
  30       <br/>
  31     </td>
  32   </tr>
  33   {if $query.error}
  34   <tr>
  35     <td>
  36       <strong style="color: #f00">ERROR:</strong><br />
  37       {$query.error|nl2br}
  38     </td>
  39   </tr>
  40   {else}
  41   <tr>
  42     <td>
  43       <strong>INFO:</strong><br />
  44       {$query.rows} enregistrement{if $query.rows > 1}s{/if} en {$query.exectime}ms
  45     </td>
  46   </tr>
  47   {/if}
  48 </table>
  49 {if $query.explain}
  50 <table class="bicol" style="width: 75%; font-family: monospace; font-size: smaller; margin-left: 2px; margin-bottom: 3px;">
  51   <tr>
  52     {foreach key=key item=item from=$query.explain[0]}
  53     <th>{$key}</th>
  54     {/foreach}
  55   </tr>
  56   {foreach item=explain_row from=$query.explain}
  57   <tr class="impair">
  58     {foreach item=item from=$explain_row}
  59     <td class="center">{$item}</td>
  60     {/foreach}
  61   </tr>
  62   {/foreach}
  63 </table>
  64 {/if}
  65 {/foreach}
  66
  67 {* vim:set et sw=2 sts=2 sws=2: *}