SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id
FROMofi_usergroupsAS a
LEFTJOINofi_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `ofi_viewlevels`
SELECT folder AS type, element AS name, params
FROMofi_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT `enabled`
FROM `ofi_extensions`
WHERE `element` = 'com_akeeba' AND `type` = 'component'
SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_k2'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROMofi_menuAS m
LEFTJOINofi_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SELECT* FROMofi_languages WHERE published=1
ORDERBY ordering ASC
SELECT id, home, template, s.params
FROMofi_template_styles as s
LEFTJOINofi_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
SELECT a.rules
FROMofi_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMofi_assetsAS a
LEFTJOINofi_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT id FROMofi_k2_categories WHERE published=1 AND trash=0 AND access IN(1,1)
SHOWFULLCOLUMNS FROM `ofi_k2_categories`
SELECT* FROMofi_k2_categories WHERE id = '49'
SELECT* FROMofi_k2_categories WHERE id = '28'
SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_phocagallery'
SELECT* FROMofi_k2_categories WHERE parent=49 AND published=1 AND trash=0 AND access IN(1,1) ORDERBY id ASC
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROMofi_k2_items as i RIGHTJOINofi_k2_categoriesAS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-07 05:12:13' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-07 05:12:13' ) AND c.id=49 ORDERBY i.id DESC LIMIT 0, 12
SELECTCOUNT(*) FROMofi_k2_items as i RIGHTJOINofi_k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-10-07 05:12:13' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-07 05:12:13' ) AND c.id=49
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5246 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5244 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5243 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5237 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5233 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5227 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5152 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5139 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5118 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5108 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5105 AND published=1
SELECTCOUNT(*) FROMofi_k2_comments WHERE itemID=5097 AND published=1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMofi_modulesAS m
LEFTJOINofi_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINofi_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-07 05:12:13') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-07 05:12:13') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 908 OR mm.menuid <= 0)
ORDERBY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT extension_id AS id, element AS "option", params, enabled
FROMofi_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
SELECT
c.id ASCID FROMofi_k2_categoriesAS c
LEFTJOINofi_k2_itemsAS content
ON
c.id = content.catid
WHERE
( c.id = 43 )
AND
c.published = 1
SELECT
content.id AS id
FROMofi_k2_itemsAS content
WHERE
content.published = 1 AND content.trash = 0
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-10-07 05:12:13' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-10-07 05:12:13' )
AND ( content.catid = 43 )
ORDERBY
content.created DESC LIMIT
0,12;
SELECT
content.id AS id,
content.alias AS alias,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.featured AS frontpage,
content.access AS access,
content.catid AS cid,
content.video AS video,
content.plugins AS plugins,
categories.name AS catname,
categories.image AS cat_image,
categories.alias AS cat_alias,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content.created_by AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROMofi_k2_itemsAS content
LEFTJOINofi_k2_categoriesAS categories
ON categories.id = content.catid
LEFTJOINofi_usersAS users
ON users.id = content.created_by
LEFTJOINofi_k2_ratingAS content_rating
ON content_rating.itemID = content.id
WHERE
content.id = 5223 OR content.id = 5220 OR content.id = 5219 OR content.id = 5214 OR content.id = 5212 OR content.id = 5206 OR content.id = 5203 OR content.id = 5201 OR content.id = 5197 OR content.id = 5196 OR content.id = 5195 OR content.id = 5194
ORDERBY
content.created DESC
SELECT
content.id AS id,
COUNT(comments.itemID) AS count
FROMofi_k2_itemsAS content
LEFTJOINofi_k2_commentsAS comments
ON comments.itemID = content.id
WHERE
comments.published
AND ( content.id = 5223 OR content.id = 5220 OR content.id = 5219 OR content.id = 5214 OR content.id = 5212 OR content.id = 5206 OR content.id = 5203 OR content.id = 5201 OR content.id = 5197 OR content.id = 5196 OR content.id = 5195 OR content.id = 5194 )
GROUPBY
comments.itemID
;
SHOWFULLCOLUMNS FROM `ofi_users`
SELECT* FROM `ofi_users`
WHERE `id` = 1907
SELECT `g`.`id`,`g`.`title`
FROM `ofi_usergroups` AS g
INNERJOIN `ofi_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 1907
6 × SELECT extension_id AS id, element AS "option", params, enabled FROMofi_extensions
3 × SELECT* FROMofi_k2_categories
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMofi_modulesAS m LEFTJOINofi_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINofi_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROMofi_k2_items as i RIGHTJOINofi_k2_categoriesAS c ON c.id = i.catid
1 × SELECT c.id ASCID FROMofi_k2_categoriesAS c LEFTJOINofi_k2_itemsAS content ON c.id = content.catid
1 × SELECTCOUNT(*) FROMofi_k2_items as i RIGHTJOINofi_k2_categories c ON c.id = i.catid
1 × SELECT content.id AS id, content.alias AS alias, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.featured AS frontpage, content.access AS access, content.catid AS cid, content.video AS video, content.plugins AS plugins, categories.name AS catname, categories.image AS cat_image, categories.alias AS cat_alias, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content.created_by AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count FROMofi_k2_itemsAS content LEFTJOINofi_k2_categoriesAS categories ON categories.id = content.catid LEFTJOINofi_usersAS users ON users.id = content.created_by LEFTJOINofi_k2_ratingAS content_rating ON content_rating.itemID = content.id
1 × SELECT `g`.`id`,`g`.`title` FROM `ofi_usergroups` AS g INNERJOIN `ofi_user_usergroup_map` AS m ON m.group_id = g.id
1 × SELECT* FROM `ofi_users`
1 × SELECT content.id AS id, COUNT(comments.itemID) AS count FROMofi_k2_itemsAS content LEFTJOINofi_k2_commentsAS comments ON comments.itemID = content.id
1 × SELECT content.id AS id FROMofi_k2_itemsAS content
1 × SELECT id FROMofi_k2_categories
1 × SELECT folder AS type, element AS name, params FROMofi_extensions
1 × SELECT id, rules FROM `ofi_viewlevels
1 × SELECT b.id FROMofi_usergroupsAS a LEFTJOINofi_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `ofi_session`
1 × SELECT `enabled` FROM `ofi_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROMofi_menuAS m LEFTJOINofi_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT b.rules FROMofi_assetsAS a LEFTJOINofi_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.rules FROMofi_assetsAS a
1 × SELECT id, home, template, s.params FROMofi_template_styles as s LEFTJOINofi_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id