| 1 | {**************************************************************************} |
| 2 | {* *} |
| 3 | {* Copyright (C) 2003-2007 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 | {if $query.explain} |
| 26 | {assign var=cols value=$query.explain[0]|@count} |
| 27 | {else} |
| 28 | {assign var=cols value=1} |
| 29 | {/if} |
| 30 | <table class="bicol" style="width: 75%; font-size: smaller; margin-left:2px; margin-top: 3px;"> |
| 31 | <tr class="impair"> |
| 32 | <td colspan="{$cols}"> |
| 33 | <strong>QUERY:</strong> |
| 34 | <pre style="padding: 0; margin: 0;">{$query.query}</pre> |
| 35 | <br/> |
| 36 | </td> |
| 37 | </tr> |
| 38 | {if $query.error} |
| 39 | <tr> |
| 40 | <td colspan="{$cols}"> |
| 41 | <strong style="color: #f00">ERROR:</strong><br /> |
| 42 | {$query.error|nl2br} |
| 43 | </td> |
| 44 | </tr> |
| 45 | {else} |
| 46 | <tr> |
| 47 | <td colspan="{$cols}"> |
| 48 | <strong>INFO:</strong><br /> |
| 49 | {$query.rows} enregistrement{if $query.rows > 1}s{/if} en {$query.exectime}ms |
| 50 | </td> |
| 51 | </tr> |
| 52 | {/if} |
| 53 | {if $query.explain} |
| 54 | <tr> |
| 55 | {foreach key=key item=item from=$query.explain[0]} |
| 56 | <th style="font-size: smaller">{$key}</th> |
| 57 | {/foreach} |
| 58 | </tr> |
| 59 | {foreach item=explain_row from=$query.explain} |
| 60 | <tr class="impair"> |
| 61 | {foreach item=item from=$explain_row} |
| 62 | <td class="center" style="font-size: smaller">{$item}</td> |
| 63 | {/foreach} |
| 64 | </tr> |
| 65 | {/foreach} |
| 66 | {/if} |
| 67 | </table> |
| 68 | {/foreach} |
| 69 | |
| 70 | {* vim:set et sw=2 sts=2 sws=2 enc=utf-8: *} |