Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
sample joomla queries
EXPLAIN SELECT a.title, a.description AS text, '' AS created, '2' AS browsernav, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_categories AS a WHERE (a.title LIKE '%super%' OR a.description LIKE '%super%') AND a.published IN (1,2) AND a.extension = 'com_content'AND a.access IN (1,1,2,3,6) GROUP BY a.id, a.title, a.description, a.alias ORDER BY a.title DESC LIMIT 0, 50;
EXPLAIN SELECT a.name AS title, '' AS created, a.con_position, a.misc, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav FROM j_contact_details AS a INNER JOIN j_categories AS c ON c.id = a.catid WHERE (a.name LIKE '%super%' OR a.misc LIKE '%super%' OR a.con_position LIKE '%super%' OR a.address LIKE '%super%' OR a.suburb LIKE '%super%' OR a.state LIKE '%super%' OR a.country LIKE '%super%' OR a.postcode LIKE '%super%' OR a.telephone LIKE '%super%' OR a.fax LIKE '%super%') AND a.published IN (1,2) AND c.published=1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) GROUP BY a.id, a.con_position, a.misc, c.alias, c.id ORDER BY a.name DESC LIMIT 0, 50;
EXPLAIN SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid WHERE ((a.title LIKE '%super%' OR a.introtext LIKE '%super%' OR a.fulltext LIKE '%super%' OR a.metakey LIKE '%super%' OR a.metadesc LIKE '%super%')) AND a.state=1 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:10') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 0, 50;
EXPLAIN SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid AND c.access IN (1,1,2,3,6) WHERE ((a.title LIKE '%super%' OR a.introtext LIKE '%super%' OR a.fulltext LIKE '%super%' OR a.metakey LIKE '%super%' OR a.metadesc LIKE '%super%')) AND a.state = 2 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:10') ORDER BY a.created DESC LIMIT 0, 50;
EXPLAIN SELECT a.name AS title, '' AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,'1' AS browsernav FROM j_newsfeeds AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.name LIKE '%super%' OR a.link LIKE '%super%')) AND a.published IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.name ASC LIMIT 0, 50;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.title AS title, '' AS created, a.url, a.description AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section,'1' AS browsernav FROM j_weblinks AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.url LIKE '%super%' OR a.description LIKE '%super%' OR a.title LIKE '%super%')) AND a.state IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.created DESC LIMIT 0, 50;
EXPLAIN SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.created_time AS created, a.note, a.description, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_tags AS a WHERE a.alias <> 'root' AND (a.title LIKE '%super%' OR a.alias LIKE '%super%') ORDER BY a.created_time DESC LIMIT 0, 50;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:10') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:10') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:12') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
EXPLAIN SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
EXPLAIN SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:04') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:04') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:12') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
select @@version_comment limit 1;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:46') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:46') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
EXPLAIN SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:46') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:46') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:47') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:47') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 4;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
EXPLAIN SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:47') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:47') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 1 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM j_content AS a LEFT JOIN j_categories AS c on c.id = a.catid LEFT JOIN j_users AS u on u.id = a.created_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 2;
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 2 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
SELECT COUNT(*) FROM j_content AS a LEFT JOIN j_categories AS c ON c.id = a.catid LEFT JOIN j_users AS ua ON ua.id = a.created_by LEFT JOIN j_users AS uam ON uam.id = a.modified_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2);
SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM j_content AS a LEFT JOIN j_categories AS cc ON cc.id = a.catid WHERE a.catid = 2 AND a.state = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-10-31 15:29:02') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-10-31 15:29:02') ORDER BY CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC;
SELECT * FROM j_content WHERE `id` = '2';
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:02') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 102 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:28:04') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:28:04') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM j_content AS a LEFT JOIN j_categories AS c on c.id = a.catid LEFT JOIN j_users AS u on u.id = a.created_by LEFT JOIN j_categories as parent ON parent.id = c.parent_id LEFT JOIN j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 2;
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_tags';
EXPLAIN SELECT `m`.`tag_id`,`t`.* FROM `j_contentitem_tag_map` AS m INNER JOIN `j_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 2 AND `t`.`published` = 1 AND t.access IN (1,1,2,3,6);
EXPLAIN SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM j_content AS a LEFT JOIN j_categories AS cc ON cc.id = a.catid WHERE a.catid = 2 AND a.state = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2014-10-31 15:29:02') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2014-10-31 15:29:02') ORDER BY CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC;
EXPLAIN SELECT * FROM j_content WHERE `id` = '2';
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:02') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 102 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:05') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:05') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:05') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:05') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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 `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.title, a.description AS text, '' AS created, '2' AS browsernav, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_categories AS a WHERE (a.title LIKE '%test%' OR a.description LIKE '%test%') AND a.published IN (1,2) AND a.extension = 'com_content'AND a.access IN (1,1,2,3,6) GROUP BY a.id, a.title, a.description, a.alias ORDER BY a.title DESC LIMIT 0, 50;
SELECT a.name AS title, '' AS created, a.con_position, a.misc, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav FROM j_contact_details AS a INNER JOIN j_categories AS c ON c.id = a.catid WHERE (a.name LIKE '%test%' OR a.misc LIKE '%test%' OR a.con_position LIKE '%test%' OR a.address LIKE '%test%' OR a.suburb LIKE '%test%' OR a.state LIKE '%test%' OR a.country LIKE '%test%' OR a.postcode LIKE '%test%' OR a.telephone LIKE '%test%' OR a.fax LIKE '%test%') AND a.published IN (1,2) AND c.published=1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) GROUP BY a.id, a.con_position, a.misc, c.alias, c.id ORDER BY a.name DESC LIMIT 0, 50;
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid WHERE ((a.title LIKE '%test%' OR a.introtext LIKE '%test%' OR a.fulltext LIKE '%test%' OR a.metakey LIKE '%test%' OR a.metadesc LIKE '%test%')) AND a.state=1 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:07') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 0, 50;
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid AND c.access IN (1,1,2,3,6) WHERE ((a.title LIKE '%test%' OR a.introtext LIKE '%test%' OR a.fulltext LIKE '%test%' OR a.metakey LIKE '%test%' OR a.metadesc LIKE '%test%')) AND a.state = 2 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:07') ORDER BY a.created DESC LIMIT 0, 48;
SELECT a.name AS title, '' AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,'1' AS browsernav FROM j_newsfeeds AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.name LIKE '%test%' OR a.link LIKE '%test%')) AND a.published IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.name ASC LIMIT 0, 50;
SELECT a.title AS title, '' AS created, a.url, a.description AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section,'1' AS browsernav FROM j_weblinks AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.url LIKE '%test%' OR a.description LIKE '%test%' OR a.title LIKE '%test%')) AND a.state IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.created DESC LIMIT 0, 50;
SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.created_time AS created, a.note, a.description, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_tags AS a WHERE a.alias <> 'root' AND (a.title LIKE '%test%' OR a.alias LIKE '%test%') ORDER BY a.created_time DESC LIMIT 0, 50;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:07') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:07') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT a.title, a.description AS text, '' AS created, '2' AS browsernav, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_categories AS a WHERE (a.title LIKE '%test%' OR a.description LIKE '%test%') AND a.published IN (1,2) AND a.extension = 'com_content'AND a.access IN (1,1,2,3,6) GROUP BY a.id, a.title, a.description, a.alias ORDER BY a.title DESC LIMIT 0, 50;
EXPLAIN SELECT a.name AS title, '' AS created, a.con_position, a.misc, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav FROM j_contact_details AS a INNER JOIN j_categories AS c ON c.id = a.catid WHERE (a.name LIKE '%test%' OR a.misc LIKE '%test%' OR a.con_position LIKE '%test%' OR a.address LIKE '%test%' OR a.suburb LIKE '%test%' OR a.state LIKE '%test%' OR a.country LIKE '%test%' OR a.postcode LIKE '%test%' OR a.telephone LIKE '%test%' OR a.fax LIKE '%test%') AND a.published IN (1,2) AND c.published=1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) GROUP BY a.id, a.con_position, a.misc, c.alias, c.id ORDER BY a.name DESC LIMIT 0, 50;
EXPLAIN SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid WHERE ((a.title LIKE '%test%' OR a.introtext LIKE '%test%' OR a.fulltext LIKE '%test%' OR a.metakey LIKE '%test%' OR a.metadesc LIKE '%test%')) AND a.state=1 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:07') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 0, 50;
EXPLAIN SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j_categories as c LEFT JOIN j_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j_categories AS cat JOIN j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,2,3,6) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid AND c.access IN (1,1,2,3,6) WHERE ((a.title LIKE '%test%' OR a.introtext LIKE '%test%' OR a.fulltext LIKE '%test%' OR a.metakey LIKE '%test%' OR a.metadesc LIKE '%test%')) AND a.state = 2 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:07') ORDER BY a.created DESC LIMIT 0, 48;
EXPLAIN SELECT a.name AS title, '' AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,'1' AS browsernav FROM j_newsfeeds AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.name LIKE '%test%' OR a.link LIKE '%test%')) AND a.published IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.name ASC LIMIT 0, 50;
EXPLAIN SELECT a.title AS title, '' AS created, a.url, a.description AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section,'1' AS browsernav FROM j_weblinks AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.url LIKE '%test%' OR a.description LIKE '%test%' OR a.title LIKE '%test%')) AND a.state IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.created DESC LIMIT 0, 50;
EXPLAIN SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.created_time AS created, a.note, a.description, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_tags AS a WHERE a.alias <> 'root' AND (a.title LIKE '%test%' OR a.alias LIKE '%test%') ORDER BY a.created_time DESC LIMIT 0, 50;
EXPLAIN SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:07') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:07') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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.title, a.description AS text, '' AS created, '2' AS browsernav, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_categories AS a WHERE (a.title LIKE '%super%' OR a.description LIKE '%super%') AND a.published IN (1,2) AND a.extension = 'com_content'AND a.access IN (1,1,2,3,6) GROUP BY a.id, a.title, a.description, a.alias ORDER BY a.title DESC LIMIT 0, 50;
SELECT a.name AS title, '' AS created, a.con_position, a.misc, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Contacts', c.title) AS section,'2' AS browsernav FROM j_contact_details AS a INNER JOIN j_categories AS c ON c.id = a.catid WHERE (a.name LIKE '%super%' OR a.misc LIKE '%super%' OR a.con_position LIKE '%super%' OR a.address LIKE '%super%' OR a.suburb LIKE '%super%' OR a.state LIKE '%super%' OR a.country LIKE '%super%' OR a.postcode LIKE '%super%' OR a.telephone LIKE '%super%' OR a.fax LIKE '%super%') AND a.published IN (1,2) AND c.published=1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) GROUP BY a.id, a.con_position, a.misc, c.alias, c.id ORDER BY a.name DESC LIMIT 0, 50;
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid WHERE ((a.title LIKE '%super%' OR a.introtext LIKE '%super%' OR a.fulltext LIKE '%super%' OR a.metakey LIKE '%super%' OR a.metadesc LIKE '%super%')) AND a.state=1 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:10') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 0, 50;
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav FROM j_content AS a INNER JOIN j_categories AS c ON c.id=a.catid AND c.access IN (1,1,2,3,6) WHERE ((a.title LIKE '%super%' OR a.introtext LIKE '%super%' OR a.fulltext LIKE '%super%' OR a.metakey LIKE '%super%' OR a.metadesc LIKE '%super%')) AND a.state = 2 AND c.published = 1 AND a.access IN (1,1,2,3,6) AND c.access IN (1,1,2,3,6) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-31 15:29:10') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-31 15:29:10') ORDER BY a.created DESC LIMIT 0, 50;
SELECT a.name AS title, '' AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,'1' AS browsernav FROM j_newsfeeds AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.name LIKE '%super%' OR a.link LIKE '%super%')) AND a.published IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.name ASC LIMIT 0, 50;
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
SELECT a.title AS title, '' AS created, a.url, a.description AS text, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Search - Weblinks', c.title) AS section,'1' AS browsernav FROM j_weblinks AS a INNER JOIN j_categories as c ON c.id = a.catid WHERE ((a.url LIKE '%super%' OR a.description LIKE '%super%' OR a.title LIKE '%super%')) AND a.state IN (1,2) AND c.published = 1 AND c.access IN (1,1,2,3,6) ORDER BY a.created DESC LIMIT 0, 50;
SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.created_time AS created, a.note, a.description, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM j_tags AS a WHERE a.alias <> 'root' AND (a.title LIKE '%super%' OR a.alias LIKE '%super%') ORDER BY a.created_time DESC LIMIT 0, 50;
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j_modules AS m LEFT JOIN j_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j_extensions AS 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 <= '2014-10-31 15:29:10') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-31 15:29:10') AND m.access IN (1,1,2,3,6) AND m.client_id = 0 AND (mm.menuid = 103 OR mm.menuid <= 0) ORDER BY m.position, m.ordering;
SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_content';
EXPLAIN SELECT `data` FROM `j_session` WHERE `session_id` = 'rtf35f2oqa0ufei0hulr8giej2';
EXPLAIN SELECT folder AS type, element AS name, params FROM j_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3,6) ORDER BY ordering;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_languages';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN 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 FROM j_menu AS m LEFT JOIN j_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft;
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'library' AND `element` = 'joomla';
EXPLAIN SELECT extension_id AS id, element AS "option", params, enabled FROM j_extensions WHERE `type` = 'component' AND `element` = 'com_search';
EXPLAIN SELECT * FROM j_languages WHERE published=1 ORDER BY ordering ASC;
EXPLAIN SELECT id, home, template, s.params FROM j_template_styles as s LEFT JOIN j_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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment