public function getShortUrlParams($shortUrlId)
{
$qb = $this->getConnection()->createQueryBuilder();
$qb->select('user', 'imageIdentifier', 'extension', 'query')->from($this->tableNames['shorturl'], 's')->where('shortUrlId = :shortUrlId')->setParameters([':shortUrlId' => $shortUrlId]);
$stmt = $qb->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$row) {
return null;
}
$row['query'] = unserialize($row['query']);
return $row;
}