Запросы к БД |
System |
SELECT `component`, `route` FROM `elx_components`
WHERE `route` IS NOT NULL |
SELECT * FROM `elx_session` WHERE `session_id` = :pkey LIMIT 0,1 |
INSERT INTO `elx_session`
(`session_id`, `uid`, `gid`, `login_method`, `first_activity`, `last_activity`, `clicks`, `current_page`, `ip_address`, `user_agent`, `session_data`)
VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10) |
SELECT * FROM `elx_session` WHERE `session_id` = :pkey LIMIT 0,1 |
UPDATE `elx_session`
SET `uid` = :col1, `gid` = :col2, `login_method` = :col3, `first_activity` = :col4, `last_activity` = :col5, `clicks` = :col6, `current_page` = :col7, `ip_address` = :col8, `user_agent` = :col9, `session_data` = :col10
WHERE `session_id` = :col0 |
SELECT * FROM `elx_acl` ORDER BY `category` ASC, `element` ASC |
SELECT * FROM `elx_engines` WHERE `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `ordering` ASC |
SELECT `id`, `title`, `module`, `showtitle`,
`position`, `content`, `params` FROM `elx_modules`
WHERE `published` = 1 AND `section` = :sec ORDER BY `ordering` ASC |
SELECT `menu_id` FROM `elx_menu` WHERE `section` = :sec
AND `menu_type` = 'link' AND `published`=1
AND `link` = :elxisuri
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `ordering` ASC LIMIT 0,1 |
SELECT `menu_id` FROM `elx_menu` WHERE `section` = :sec
AND `menu_type` = 'link' AND `published`=1
AND `link` = :elxisuri
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `ordering` ASC LIMIT 0,1 |
SELECT `menu_id` FROM `elx_menu` WHERE `section` = :sec
AND `menu_type` = 'link' AND `published`=1
AND ((`link` IS NULL) OR (`link` = '') OR (`link` = :defroute))
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `ordering` ASC LIMIT 0,1 |
SELECT `moduleid` FROM `elx_modules_menu`
WHERE ((`menuid` = 0) OR (`menuid` = :itemid)) |
SELECT `params` FROM `elx_templates`
WHERE `template` = 'five' AND `section` = 'frontend' LIMIT 0,1 |
SELECT * FROM `elx_statistics` WHERE `statdate` = :statd LIMIT 0,1 |
DELETE FROM `elx_statistics_temp` |
INSERT IGNORE INTO `elx_statistics_temp` VALUES (NULL, :xhash) |
INSERT INTO `elx_statistics`
(`id`, `statdate`, `clicks`, `visits`, `langs`)
VALUES (NULL, :xdat, :xcli, :xvis, :xlan) |
SELECT `id`, `plugin`, `alevel`, `published`, `params`
FROM `elx_plugins` ORDER BY `ordering` ASC |
User |
SELECT * FROM `elx_authentication` WHERE `published`=1 ORDER BY `ordering` ASC |
SELECT `params` FROM `elx_components` WHERE `component` = 'com_user' LIMIT 0,1 |
Mod_menu |
SELECT * FROM `elx_menu`
WHERE `section` = :section AND `collection` = :collection AND `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `parent_id` ASC, `ordering` ASC |
SELECT `catid` FROM `elx_categories`
WHERE `seotitle` = :seocat AND `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel)) LIMIT 0,1 |
SELECT * FROM `elx_menu`
WHERE `section` = :section AND `collection` = :collection AND `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `parent_id` ASC, `ordering` ASC |
SELECT `catid` FROM `elx_categories`
WHERE `seotitle` = :seocat AND `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel)) LIMIT 0,1 |
SELECT * FROM `elx_menu`
WHERE `section` = :section AND `collection` = :collection AND `published`=1
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel))
ORDER BY `parent_id` ASC, `ordering` ASC |
Mod_dir_category |
SELECT `params` FROM `elx_plugins`
WHERE `plugin` = :xplg LIMIT 0,1 |
Mod_categories |
SELECT `catid`, `title`, `seolink`
FROM `elx_categories` WHERE `published`=1 AND `parent_id` = 0
AND ((`alevel` <= :lowlevel) OR (`alevel` = :exactlevel)) ORDER BY `title` ASC |
Mod_comments |
SELECT c.id, c.message, c.created, c.uid, c.author, c.email, a.id AS aid, a.catid, a.title, a.seotitle, g.seolink
FROM `elx_comments` c
JOIN `elx_content` a ON a.id = c.elid
LEFT JOIN `elx_categories` g ON g.catid=a.catid
WHERE c.published = 1 AND c.element = :celem AND a.published = 1 AND ((g.published = 1) OR (a.catid = 0))
AND ((g.alevel <= :lowlevel) OR (g.alevel = :exactlevel) OR (a.catid = 0))
AND ((a.alevel <= :lowlevel) OR (a.alevel = :exactlevel))
ORDER BY c.created DESC LIMIT 0,5 |
Mod_whosonline |
SELECT COUNT(`uid`) FROM `elx_session`
WHERE `last_activity` > :ts AND `uid` > 0 LIMIT 0,1 |
SELECT COUNT(`uid`) FROM `elx_session`
WHERE `last_activity` > :ts AND `uid` = 0 LIMIT 0,1 |