404 CATEGORY NOT FOUND OH MY GOSH! YOU FOUND IT!!! Looks like the page you're trying to visit doesn't exist. Please check the URL and try your luck again. Take Me Home Designed by RocketTheme Back to Top jquery-migrate.js:21 JQMIGRATE: Logging is active https://www.joctest.org.uk/administrator/index.php Failed to load resource: the server responded with a status of 404 (Category not found) Joomla! Debug Console Errors Category not found Call stack # Function Location 1 JApplicationCms->execute() JROOT/index.php:40 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:251 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:237 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:332 6 require_once() JROOT/libraries/cms/component/helper.php:352 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:16 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:730 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:79 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:693 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 12 JError::raiseError() JROOT/libraries/legacy/view/category.php:129 13 JError::raise() JROOT/libraries/legacy/error/error.php:253 Session Profile Information Time Memory Time: 0.0 ms / 0.0 ms Memory: 0.625 MB / 0.62 MB Application: afterLoad Time: 412.9 ms / 412.9 ms Memory: 12.009 MB / 12.63 MB Application: afterInitialise Time: 61.2 ms / 474.2 ms Memory: 2.779 MB / 15.41 MB Application: afterRoute Database queries total: 133.5 ms Memory Usage Database Queries 73 Queries Logged 133.5 ms 9 duplicate found! 2 duplicates: #6 #16 2 duplicates: #9 #10 2 duplicates: #22 #24 3 duplicates: #35 #68 #69 Query Time: 0.39 ms Query memory: 0.013 MB Memory before query: 2.299 MB Rows returned: 1 SELECT `data` FROM `j3t_session` WHERE `session_id` = '361be02c51e4234a80b550195772c1cb' Explain Profile Call Stack Query Time: 0.28 ms After last query: 2.29 ms Query memory: 0.008 MB Memory before query: 2.406 MB DELETE FROM `j3t_session` WHERE `time` < '1436007117' Explain Profile Call Stack Query Time: 0.14 ms After last query: 8.17 ms Query memory: 0.012 MB Memory before query: 2.766 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_users' Explain Profile Call Stack Query Time: 1.47 ms After last query: 2.27 ms Query memory: 0.009 MB Memory before query: 2.823 MB Rows returned: 76 SELECT folder AS type, element AS name, params FROM j3t_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,5) ORDER BY ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_extensions ref extension extension 62 const 95 Using where; Using filesort Profile Call Stack Query Time: 0.44 ms After last query: 1.26 ms Query memory: 0.012 MB Memory before query: 2.917 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_languages' Explain Profile Call Stack Query Time: 0.12 ms After last query: 22.02 ms Query memory: 0.015 MB Memory before query: 3.906 MB Rows returned: 0 Duplicate queries: #16 SELECT `value` FROM `j3t_admintools_storage` WHERE `key` = 'cparams' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 0.10 ms After last query: 13.54 ms Query memory: 0.014 MB Memory before query: 4.607 MB Rows returned: 0 SELECT `query` FROM `j3t_admintools_wafexceptions` WHERE (`option` IS NULL OR `option` = '') AND (`view` IS NULL OR `view` = '') GROUP BY `query` ORDER BY `query` ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using temporary; Using filesort Profile Call Stack Query Time: 0.38 ms After last query: 4.03 ms Query memory: 0.011 MB Memory before query: 4.764 MB Rows returned: 1 SELECT `enabled` FROM `j3t_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component' Explain Profile Call Stack Query Time: 0.17 ms After last query: 26.66 ms Query memory: 0.017 MB Memory before query: 5.573 MB Rows returned: 1 Duplicate queries: #10 SELECT template FROM j3t_template_styles as s WHERE s.client_id = 0 AND s.home = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 11 Using where Profile Call Stack Query Time: 0.09 ms After last query: 0.24 ms Query memory: 0.018 MB Memory before query: 5.591 MB Rows returned: 1 Duplicate queries: #9 SELECT template FROM j3t_template_styles as s WHERE s.client_id = 0 AND s.home = 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 11 Using where Profile Call Stack Query Time: 0.11 ms After last query: 13.78 ms Query memory: 0.012 MB Memory before query: 5.906 MB Rows returned: 4 SELECT extension, file, type FROM j3t_rokcommon_configs ORDER BY priority Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Using filesort Profile Call Stack Query Time: 0.44 ms After last query: 46.00 ms Query memory: 0.029 MB Memory before query: 7.615 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'library' AND `element` = 'joomla' Explain Profile Call Stack Query Time: 59.23 ms After last query: 0.64 ms Query memory: 0.024 MB Memory before query: 7.630 MB UPDATE `j3t_extensions` SET `params` = '{\"mediaversion\":\"398d8d621bbd00b204c778f007940131\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explain Profile Call Stack Query Time: 0.15 ms After last query: 27.36 ms Query memory: 0.032 MB Memory before query: 8.864 MB Rows returned: 1 SELECT `params` FROM `j3t_comprofiler_plugin` WHERE `id` = 1 Explain Profile Call Stack Query Time: 0.14 ms After last query: 44.53 ms Query memory: 0.014 MB Memory before query: 10.619 MB Rows returned: 0 SELECT * FROM `j3t_admintools_ipautoban` WHERE `ip` = '86.178.207.176' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 0.13 ms After last query: 0.30 ms Query memory: 0.015 MB Memory before query: 10.634 MB Rows returned: 0 Duplicate queries: #6 SELECT `value` FROM `j3t_admintools_storage` WHERE `key` = 'cparams' Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 0.14 ms After last query: 0.85 ms Query memory: 0.014 MB Memory before query: 10.655 MB Rows returned: 0 SELECT `source`,`keepurlparams` FROM `j3t_admintools_redirects` WHERE (`dest` = 'administrator/index.php') OR (`dest` = 'administrator/index.php') AND `published` = '1' ORDER BY `ordering` DESC LIMIT 0, 1 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Profile Call Stack Query Time: 0.55 ms After last query: 0.49 ms Query memory: 0.017 MB Memory before query: 10.689 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_widgetkit' Explain Profile Call Stack Query Time: 0.80 ms After last query: 0.72 ms Query memory: 0.017 MB Memory before query: 10.708 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_zoo' Explain Profile Call Stack Query Time: 2.03 ms After last query: 29.71 ms Query memory: 0.019 MB Memory before query: 11.542 MB Rows returned: 17 SHOW FULL COLUMNS FROM `j3t_extensions` Explain Profile Call Stack Query Time: 0.46 ms After last query: 2.18 ms Query memory: 0.014 MB Memory before query: 11.623 MB Rows returned: 1 SELECT `extension_id` FROM `j3t_extensions` WHERE type = 'component' AND element = 'com_roksprocket' Explain Profile Call Stack Query Time: 0.42 ms After last query: 0.53 ms Query memory: 0.014 MB Memory before query: 11.640 MB Rows returned: 1 Duplicate queries: #24 SELECT * FROM j3t_extensions WHERE `extension_id` = '10047' Explain Profile Call Stack Query Time: 0.46 ms After last query: 0.44 ms Query memory: 0.014 MB Memory before query: 11.654 MB Rows returned: 1 SELECT `extension_id` FROM `j3t_extensions` WHERE type = 'module' AND element = 'mod_roksprocket' Explain Profile Call Stack Query Time: 0.14 ms After last query: 0.44 ms Query memory: 0.014 MB Memory before query: 11.670 MB Rows returned: 1 Duplicate queries: #22 SELECT * FROM j3t_extensions WHERE `extension_id` = '10047' Explain Profile Call Stack Query Time: 1.24 ms After last query: 62.01 ms Query memory: 0.018 MB Memory before query: 12.856 MB Rows returned: 26 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 j3t_menu AS m LEFT JOIN j3t_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 33 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.m.component_id 1 Profile Call Stack Query Time: 0.48 ms After last query: 6.80 ms Query memory: 0.019 MB Memory before query: 13.205 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_content' Explain Profile Call Stack Query Time: 0.45 ms After last query: 1.08 ms Query memory: 0.018 MB Memory before query: 13.239 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_aclmanager' Explain Profile Call Stack Query Time: 0.18 ms After last query: 17.49 ms Query memory: 0.020 MB Memory before query: 14.087 MB Rows returned: 1 SELECT * FROM `j3t_cbsubs_config` WHERE `id` = 1 Explain Profile Call Stack Query Time: 0.14 ms After last query: 8.14 ms Query memory: 0.026 MB Memory before query: 14.378 MB Rows returned: 2 SELECT b.id FROM j3t_usergroups AS a LEFT JOIN j3t_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9 Explain Profile Call Stack Query Time: 0.13 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 14.404 MB Rows returned: 7 SELECT id, rules FROM `j3t_viewlevels` Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 7 Profile Call Stack Query Time: 0.30 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 14.429 MB Rows returned: 2 SELECT a.* FROM `j3t_cbsubs_plans` AS a LEFT JOIN `j3t_cbsubs_plans` AS b ON b.`id` = a.`parent` WHERE a.published = 1 AND a.viewaccesslevel IN (1, 5) GROUP BY a.id ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref published_allownew_allowreg_parent_ordering published_allownew_allowreg_parent_ordering 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.parent 1 Profile Call Stack Query Time: 0.13 ms After last query: 12.95 ms Query memory: 0.020 MB Memory before query: 15.213 MB Rows returned: 0 SELECT `parent_id` FROM j3t_categories WHERE id = 0 Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 0.20 ms After last query: 4.54 ms Query memory: 0.022 MB Memory before query: 15.364 MB Rows returned: 4 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 j3t_categories as c LEFT JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_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,5) AND c.published = 1 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 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY c ALL cat_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using filesort 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Profile Call Stack Query Time: 0.16 ms After last query: 2.43 ms Query memory: 0.009 MB Memory before query: 15.457 MB Rows returned: 1 SELECT * FROM j3t_languages WHERE published=1 ORDER BY ordering ASC Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE j3t_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort Profile Call Stack Query Time: 0.72 ms After last query: 1.13 ms Query memory: 0.008 MB Memory before query: 15.478 MB Rows returned: 9 Duplicate queries: #68 #69 SELECT id, home, template, s.params FROM j3t_template_styles as s LEFT JOIN j3t_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 11 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 joctesto_joomla3.s.template,const 1 Using where Profile Call Stack Query Time: 0.14 ms After last query: 20.72 ms Query memory: 0.023 MB Memory before query: 16.236 MB Rows returned: 2 SELECT b.rules FROM j3t_assets AS a LEFT JOIN j3t_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 11 Using where Profile Call Stack Query Time: 0.19 ms After last query: 3.47 ms Query memory: 0.022 MB Memory before query: 16.309 MB Rows returned: 4 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,COUNT(i.`id`) AS numitems FROM j3t_categories as c LEFT JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_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 LEFT JOIN `j3t_content` AS i ON i.`catid` = c.id AND i.state = 1 WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 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 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY c ALL cat_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 13 Using where; Using temporary; Using filesort 1 PRIMARY i ref idx_state,idx_catid idx_catid 4 joctesto_joomla3.c.id 4 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Profile Call Stack Query Time: 0.13 ms After last query: 0.92 ms Query memory: 0.023 MB Memory before query: 16.358 MB Rows returned: 0 SELECT b.rules FROM j3t_assets AS a LEFT JOIN j3t_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.root') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Profile Call Stack Query Time: 1.43 ms After last query: 5.74 ms Query memory: 0.029 MB Memory before query: 16.687 MB Rows returned: 8 SHOW FULL COLUMNS FROM `j3t_assets` Explain Profile Call Stack Query Time: 0.13 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 16.734 MB Rows returned: 1 SELECT id FROM j3t_assets WHERE parent_id = 0 Explain Profile Call Stack Query Time: 0.12 ms After last query: 0.30 ms Query memory: 0.023 MB Memory before query: 16.756 MB Rows returned: 1 SELECT rules FROM j3t_assets WHERE id = '1' Explain Profile Call Stack Query Time: 10.43 ms After last query: 3.99 ms Query memory: 0.022 MB Memory before query: 16.944 MB Rows returned: 23 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 j3t_content AS a LEFT JOIN j3t_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j3t_categories AS c ON c.id = a.catid LEFT JOIN j3t_users AS ua ON ua.id = a.created_by LEFT JOIN j3t_users AS uam ON uam.id = a.modified_by LEFT JOIN j3t_categories as parent ON parent.id = c.parent_id LEFT JOIN j3t_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_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 a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-04 11:06:58') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-04 11:06:58') ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY a ALL idx_access,idx_catid NO INDEX KEY COULD BE USED NULL NULL 27 Using where; Using temporary; Using filesort 1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.id 1 Using index 1 PRIMARY c eq_ref PRIMARY,idx_access PRIMARY 4 joctesto_joomla3.a.catid 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.created_by 1 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.modified_by 1 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.c.parent_id 1 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.id 1 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Profile Call Stack Query Time: 0.48 ms After last query: 6.21 ms Query memory: 0.026 MB Memory before query: 17.461 MB Rows returned: 1 SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions WHERE `type` = 'component' AND `element` = 'com_tags' Explain Profile Call Stack Query Time: 0.31 ms After last query: 0.85 ms Query memory: 0.021 MB Memory before query: 17.477 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 24 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 1.09 ms Query memory: 0.021 MB Memory before query: 17.515 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 23 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.99 ms Query memory: 0.021 MB Memory before query: 17.555 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 22 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.99 ms Query memory: 0.021 MB Memory before query: 17.595 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 21 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.97 ms Query memory: 0.021 MB Memory before query: 17.635 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 20 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.98 ms Query memory: 0.021 MB Memory before query: 17.675 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 19 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.92 ms Query memory: 0.021 MB Memory before query: 17.714 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 18 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 17.754 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 14 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.97 ms Query memory: 0.021 MB Memory before query: 17.794 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 13 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.98 ms Query memory: 0.021 MB Memory before query: 17.833 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 12 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.95 ms Query memory: 0.021 MB Memory before query: 17.873 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 4 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 17.913 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 3 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 17.952 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_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,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.95 ms Query memory: 0.021 MB Memory before query: 17.992 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_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,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.95 ms Query memory: 0.021 MB Memory before query: 18.031 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 8 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.99 ms Query memory: 0.021 MB Memory before query: 18.071 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 16 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.92 ms Query memory: 0.021 MB Memory before query: 18.111 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 7 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.15 ms After last query: 0.97 ms Query memory: 0.021 MB Memory before query: 18.150 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 6 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.15 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 18.190 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 5 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 18.230 MB Rows returned: 2 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 9 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 1.05 ms Query memory: 0.021 MB Memory before query: 18.281 MB Rows returned: 1 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 10 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 1.03 ms Query memory: 0.021 MB Memory before query: 18.328 MB Rows returned: 1 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 11 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 0.17 ms After last query: 0.99 ms Query memory: 0.021 MB Memory before query: 18.374 MB Rows returned: 1 SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 15 AND `t`.`published` = 1 AND t.access IN (1,1,5) Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type,idx_tag NO INDEX KEY COULD BE USED NULL NULL 5 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 joctesto_joomla3.m.tag_id 1 Using where Profile Call Stack Query Time: 1.63 ms After last query: 3.37 ms Query memory: 0.022 MB Memory before query: 18.539 MB Rows returned: 1 SELECT COUNT(*) FROM j3t_content AS a LEFT JOIN j3t_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j3t_categories AS c ON c.id = a.catid LEFT JOIN j3t_users AS ua ON ua.id = a.created_by LEFT JOIN j3t_users AS uam ON uam.id = a.modified_by LEFT JOIN j3t_categories as parent ON parent.id = c.parent_id LEFT JOIN j3t_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_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 a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-04 11:06:58') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-04 11:06:58') Explain id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY system NULL NO INDEX KEY COULD BE USED NULL NULL 0 const row not found 1 PRIMARY a ALL idx_access,idx_catid NO INDEX KEY COULD BE USED NULL NULL 27 Using where 1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.id 1 Using index 1 PRIMARY c eq_ref PRIMARY,idx_access PRIMARY 4 joctesto_joomla3.a.catid 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.created_by 1 Using index 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.modified_by 1 Using index 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.c.parent_id 1 Using index 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 joctesto_joomla3.a.id 1 Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 Using where; Using temporary; Using filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 13 Using where; Using index; Using join buffer Profile Call Stack Query Time: 0.18 ms After last query: 49.74 ms Query memory: 0.037 MB Memory before query: 21.437 MB Rows returned: 9 Duplicate queries: #35 #69 SELECT id, home, template, s.params FROM j3t_template_styles as s LEFT JOIN j3t_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 11 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 joctesto_joomla3.s.template,const 1 Using where Profile Call Stack Query Time: 0.16 ms After last query: 2.63 ms Query memory: 0.037 MB Memory before query: 21.482 MB Rows returned: 9 Duplicate queries: #35 #68 SELECT id, home, template, s.params FROM j3t_template_styles as s LEFT JOIN j3t_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 11 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 joctesto_joomla3.s.template,const 1 Using where Profile Call Stack Query Time: 1.59 ms After last query: 59.80 ms Query memory: 0.032 MB Memory before query: 22.645 MB Rows returned: 6 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j3t_modules AS m LEFT JOIN j3t_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j3t_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 <= '2015-07-04 11:06:58') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-07-04 11:06:58') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 111 OR mm.menuid <= 0) ORDER BY m.position, m.ordering Explain id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 23 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 joctesto_joomla3.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 joctesto_joomla3.m.module,const 1 Using where Profile Call Stack Query Time: 1.33 ms After last query: 9.70 ms Query memory: 0.042 MB Memory before query: 22.885 MB Rows returned: 6 SHOW FULL COLUMNS FROM `j3t_template_styles` Explain Profile Call Stack Query Time: 0.15 ms After last query: 0.51 ms Query memory: 0.036 MB Memory before query: 22.944 MB Rows returned: 1 SELECT * FROM j3t_template_styles WHERE `id` = '16' Explain Profile Call Stack Query Time: 38.63 ms After last query: 1.07 ms Query memory: 0.003 MB Memory before query: 22.893 MB UPDATE `j3t_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1436007338;s:18:\"session.timer.last\";i:1436007338;s:17:\"session.timer.now\";i:1436008017;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1436008018' WHERE `session_id` = '361be02c51e4234a80b550195772c1cb' Explain Profile Call Stack 37 Query Types Logged, Sorted by Occurrences. SELECT Tables: 23 × SELECT `m`.`tag_id`,`t`.* FROM `j3t_contentitem_tag_map` AS m INNER JOIN `j3t_tags` AS t ON `m`.`tag_id` = `t`.`id` 8 × SELECT extension_id AS id, element AS "option", params, enabled FROM j3t_extensions 3 × SELECT id, home, template, s.params FROM j3t_template_styles as s LEFT JOIN j3t_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id 2 × SELECT b.rules FROM j3t_assets AS a LEFT JOIN j3t_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 2 × SELECT * FROM j3t_extensions 2 × SELECT `value` FROM `j3t_admintools_storage` 2 × SELECT template FROM j3t_template_styles as s 2 × SELECT `extension_id` FROM `j3t_extensions` 1 × SELECT * FROM j3t_languages 1 × 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,COUNT(i.`id`) AS numitems FROM j3t_categories as c LEFT JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × 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 j3t_categories as c LEFT JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 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 j3t_content AS a LEFT JOIN j3t_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j3t_categories AS c ON c.id = a.catid LEFT JOIN j3t_users AS ua ON ua.id = a.created_by LEFT JOIN j3t_users AS uam ON uam.id = a.modified_by LEFT JOIN j3t_categories as parent ON parent.id = c.parent_id LEFT JOIN j3t_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j3t_modules AS m LEFT JOIN j3t_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j3t_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1 × SELECT * FROM j3t_template_styles 1 × SELECT COUNT(*) FROM j3t_content AS a LEFT JOIN j3t_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j3t_categories AS c ON c.id = a.catid LEFT JOIN j3t_users AS ua ON ua.id = a.created_by LEFT JOIN j3t_users AS uam ON uam.id = a.modified_by LEFT JOIN j3t_categories as parent ON parent.id = c.parent_id LEFT JOIN j3t_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j3t_categories AS cat JOIN j3t_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × SELECT `parent_id` FROM j3t_categories 1 × SELECT rules FROM j3t_assets 1 × SELECT id FROM j3t_assets 1 × SELECT b.id FROM j3t_usergroups AS a LEFT JOIN j3t_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT extension, file, type FROM j3t_rokcommon_configs 1 × SELECT `params` FROM `j3t_comprofiler_plugin` 1 × SELECT `enabled` FROM `j3t_extensions` 1 × SELECT `query` FROM `j3t_admintools_wafexceptions` 1 × SELECT folder AS type, element AS name, params FROM j3t_extensions 1 × SELECT * FROM `j3t_admintools_ipautoban` 1 × SELECT `source`,`keepurlparams` FROM `j3t_admintools_redirects` 1 × SELECT id, rules FROM `j3t_viewlevels 1 × SELECT `data` FROM `j3t_session` 1 × SELECT * FROM `j3t_cbsubs_config` 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM j3t_menu AS m LEFT JOIN j3t_extensions AS e ON m.component_id = e.extension_id 1 × SELECT a.* FROM `j3t_cbsubs_plans` AS a LEFT JOIN `j3t_cbsubs_plans` AS b ON b.`id` = a.`parent` OTHER Tables: 1 × SHOW FULL COLUMNS FROM `j3t_template_styles 1 × UPDATE `j3t_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1436007338;s:18:\"session.timer.last\";i:1436007338;s:17:\"session.timer.now\";i:1436008017;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1436008018' 1 × SHOW FULL COLUMNS FROM `j3t_assets 1 × SHOW FULL COLUMNS FROM `j3t_extensions 1 × UPDATE `j3t_extensions` SET `params` = '{\"mediaversion\":\"398d8d621bbd00b204c778f007940131\"}' 1 × DELETE FROM `j3t_session`