<?php
/**
 * @var \App\View\AppView $this
 * @var \App\Model\Entity\SlowQuery $slowQuery
 */
?>
<div class="row">
    <aside class="column">
        <div class="side-nav">
            <h4 class="heading"><?= __('Actions') ?></h4>
            <?= $this->Html->link(__('Edit Slow Query'), ['action' => 'edit', $slowQuery->id], ['class' => 'side-nav-item']) ?>
            <?= $this->Form->postLink(__('Delete Slow Query'), ['action' => 'delete', $slowQuery->id], ['confirm' => __('Are you sure you want to delete # {0}?', $slowQuery->id), 'class' => 'side-nav-item']) ?>
            <?= $this->Html->link(__('List Slow Queries'), ['action' => 'index'], ['class' => 'side-nav-item']) ?>
            <?= $this->Html->link(__('New Slow Query'), ['action' => 'add'], ['class' => 'side-nav-item']) ?>
        </div>
    </aside>
    <div class="column-responsive column-80">
        <div class="slowQueries view content">
            <h3><?= h($slowQuery->id) ?></h3>
            <table>
                <tr>
                    <th><?= __('User') ?></th>
                    <td><?= h($slowQuery->user) ?></td>
                </tr>
                <tr>
                    <th><?= __('Schema') ?></th>
                    <td><?= h($slowQuery->schema) ?></td>
                </tr>
                <tr>
                    <th><?= __('Query Time') ?></th>
                    <td><?= h($slowQuery->query_time) ?></td>
                </tr>
                <tr>
                    <th><?= __('Lock Time') ?></th>
                    <td><?= h($slowQuery->lock_time) ?></td>
                </tr>
                <tr>
                    <th><?= __('Date') ?></th>
                    <td><?= h($slowQuery->date) ?></td>
                </tr>
                <tr>
                    <th><?= __('Id') ?></th>
                    <td><?= $this->Number->format($slowQuery->id) ?></td>
                </tr>
                <tr>
                    <th><?= __('Rows Sent') ?></th>
                    <td><?= $this->Number->format($slowQuery->rows_sent) ?></td>
                </tr>
                <tr>
                    <th><?= __('Rows Examined') ?></th>
                    <td><?= $this->Number->format($slowQuery->rows_examined) ?></td>
                </tr>
                <tr>
                    <th><?= __('Created') ?></th>
                    <td><?= h($slowQuery->created) ?></td>
                </tr>
            </table>
            <div class="text">
                <strong><?= __('Query') ?></strong>
                <blockquote>
                    <?= $this->Text->autoParagraph(h($slowQuery->query)); ?>
                </blockquote>
            </div>
        </div>
    </div>
</div>
