Ris

        <div class="karma block">
 
			<?php if ($profile['is_can_vote_karma']){ ?>
                <a href="#vote-down" onclick="return icms.users.karmaDown()" class="thumb thumb_down" title="<?php echo LANG_KARMA_DOWN; ?>"></a>
            <?php } ?>
            <span class="value <?php echo html_signed_class($profile['karma']); ?>" title="<?php echo LANG_KARMA; ?>">
                <?php echo html_signed_num($profile['karma']); ?>
            </span>
			<?php if ($profile['is_can_vote_karma']){ ?>
                <a href="#vote-up" onclick="return icms.users.karmaUp()" class="thumb thumb_up" title="<?php echo LANG_KARMA_UP; ?>"></a>
            <?php } ?>
 
        </div>

/components/content/frontend.php => getArticlesList()
SELECT con.*,
con.pubdate AS fpubdate,
cat.title AS cat_title, cat.seolink AS catseolink,
cat.showdesc,
u.nickname AS author,
u.login AS user_login
FROM cms_content con
INNER JOIN cms_category cat ON cat.id = con.category_id
LEFT JOIN cms_users u ON u.id = con.user_id
WHERE con.is_arhive = 0
AND (con.category_id = '6')
AND (con.published = 1 AND con.pubdate <= '2017-01-04 20:26:06'
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2017-01-04 20:26:06')))
 
 
 
 
ORDER BY pubdate ASC
LIMIT 0, 100
Запрос занял 0.00035 с.

/components/anec/frontend.php => anec()
SELECT q.*, c.title cat_title, c.id cid, u.login, u.nickname, r.item_id rid
FROM cms_anec_quests q
LEFT JOIN cms_ratings r ON r.target = 'quest' AND r.item_id = q.id AND r.user_id = 86
LEFT JOIN cms_anec_cats c ON c.id = q.category_id
LEFT JOIN cms_users u ON u.id = q.user_id
WHERE q.published = 1
ORDER BY q.id DESC
LIMIT 0, 40
Запрос занял 0.03168 с.