Помогите оптимизировать сниппет

<?php
$q=$modx->newQuery('modResource');
$q->select(array('id','pagetitle','uri','publishedon','parent'));
$q->where(array('parent'=>2));
$tickets=$modx->getIterator('modResource',$q);
/*$tickets=$modx->getIterator('modResource', array ('parent'=>2));*/
$ouput='';
if (!$tickets) { 
    return '<div class="alert alert-success">Нет заданий для расчета.</div>';
} else {
    $ouput.='<table class="table table-hover"><thead><tr><th style="text-align: center;">№</th><th style="text-align: center;">Домен</th><th style="text-align: center;">Дата публикации</th><th style="text-align: center;">Количество слов / Статус</th><th style="text-align: center;">Расчитать</th></tr></thead><tbody>';
        $q = '';
        foreach ($tickets as $key => $ticket) {
            $q=$modx->newQuery('modResource');
            $q->select(array('id'));
            $q->where(array('parent'=>$ticket));
            $slova=$modx->getIterator('modResource',$q);
            
            /*$slova = $ticket->getMany('Children');*/
            $kol_slov = count($slova);
            $k=0;
                    
            foreach ($slova as $slovo) { 
                $val = $slovo->getTVValue(1);
                    if ($val=='DONE') {$k++;}
            }   
                
            if ($k < $kol_slov) {
                $out = '('.$k.' / '.$kol_slov.')';
                $men_but='<a class="btn btn btn-info" href="/tickets/'.$ticket->get('id').'/"><i class="icon-pencil icon-white"></i>  Перейти к расчету</a>';
            } elseif(!$kol_slov) { 
                $out = '<span style="color: red;">NOT</span>';
                $men_but='<div class="alert alert-error" style="margin-bottom: 0;"><strong>Нет ключевых слов!</strong></div>';
            } else { 
                $out = '<span style="color: green;">DONE</span>';
                $men_but='<div class="alert alert-success" style="margin-bottom: 0;"><strong>Просчет готов!</strong></div>';
            }
                
            $ouput.='<tr><td style="text-align: center;">'.$ticket->get('id').'</td><td><a href='.$ticket->get('uri').'>'.$ticket->get('pagetitle').'</a></td><td style="text-align: center;">'.$ticket->get('publishedon').'</td><td style="text-align: center;">'.$kol_slov.' / '.$out.'</td><td style="text-align: center;">'.$men_but.'</td></tr>';
        }
    $ouput.='</tbody></table>';
}
return $ouput;