YOUNG HOLLYWOOD
YOUNG HOLLYWOOD TV
YOUNGER HOLLYWOOD
BEYOND THE ATHLETE
FOOD FEED
THE CODE WORD
THE FANGIRL LIFE
INSIDE THE LOOK
AMPD UP
THE SOCIAL STREAM
details MORE Spotlight
Articles
Rachel Platten Explains Meaning Behind Broken Glass
YH is on the red carpet at the 45th annual American Music Awards chatting with pop star Rachel Platten all about her empowering single "Broken Glass" and how she seems to constantly have her thumb on the pulse of American consciousness and current societal issues at any given time!
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713895109,
"last": 1713895109,
"now": 1713895109
},
"client": {
"forwarded": "3.133.141.6"
},
"token": "5zFlWcjJBGFyvcqDT6nnbjoIBYQFwoP4"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 2.28 ms / 2.28 ms Memory: 0.398 MB / 0.73 MB Application: afterLoad
Time: 37.56 ms / 39.84 ms Memory: 1.633 MB / 2.36 MB Application: afterInitialise
Time: 8.06 ms / 47.89 ms Memory: 0.962 MB / 3.32 MB Application: afterRoute
Time: 0.95 ms / 48.85 ms Memory: 0.080 MB / 3.40 MB Application: beforeRenderComponent com_content
Time: 0.84 ms / 49.69 ms Memory: 0.049 MB / 3.45 MB Application: Before Access::preloadComponents (all components)
Time: 1.85 ms / 51.54 ms Memory: 0.063 MB / 3.52 MB Application: After Access::preloadComponents (all components)
Time: 0.06 ms / 51.60 ms Memory: 0.000 MB / 3.51 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.21 ms / 51.81 ms Memory: 0.008 MB / 3.52 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 59.39 ms / 111.20 ms Memory: 0.945 MB / 4.47 MB Application: afterRenderComponent com_content
Time: 1.05 ms / 112.25 ms Memory: 0.010 MB / 4.48 MB Application: afterDispatch
Time: 1.28 ms / 113.53 ms Memory: 0.069 MB / 4.55 MB Application: beforeRenderModule mod_noo_contentslider (MORE VIDEOS)
Time: 34.65 ms / 148.18 ms Memory: 0.798 MB / 5.34 MB Application: afterRenderModule mod_noo_contentslider (MORE VIDEOS)
Time: 28.03 ms / 176.21 ms Memory: 0.000 MB / 4.91 MB Application: beforeRenderModule mod_video_player (YH Video Player Module)
Time: 4.48 ms / 180.69 ms Memory: 0.055 MB / 4.96 MB Application: afterRenderModule mod_video_player (YH Video Player Module)
Time: 0.73 ms / 181.42 ms Memory: 0.005 MB / 4.97 MB Application: beforeRenderModule mod_search (Search)
Time: 5.28 ms / 186.71 ms Memory: 0.135 MB / 5.10 MB Application: afterRenderModule mod_search (Search)
Time: 28.53 ms / 215.24 ms Memory: 0.000 MB / 5.10 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 3.73 ms / 218.96 ms Memory: 0.072 MB / 5.17 MB Application: beforeRenderModule mod_menu (shows)
Time: 1.28 ms / 220.24 ms Memory: 0.027 MB / 5.20 MB Application: afterRenderModule mod_menu (shows)
Time: 0.04 ms / 220.28 ms Memory: 0.000 MB / 5.16 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 29.72 ms / 250.00 ms Memory: 0.000 MB / 5.14 MB Application: beforeRenderModule mod_menu (Channels)
Time: 1.24 ms / 251.24 ms Memory: 0.058 MB / 5.20 MB Application: afterRenderModule mod_menu (Channels)
Time: 63.33 ms / 314.57 ms Memory: 0.348 MB / 5.55 MB Application: afterRender
Database queries total: 55.73 ms
5.90 MB (6,183,192 Bytes)
39 Queries Logged 55.73 ms
8 duplicate found!
- Query Time: 0.98 ms Query memory: 0.020 MB Memory before query: 1.067 MB Rows returned: 0
SELECT `session_id`
FROM `yh14_session`
WHERE `session_id` = '6d2e1b93a0d464e1467c418281670bbf'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:214 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:451 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:51 - Query Time: 3.99 ms After last query: 0.19 ms Query memory: 0.003 MB Memory before query: 1.071 MB
INSERT INTO `yh14_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6d2e1b93a0d464e1467c418281670bbf', 1, '1713895109', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `yh14_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6d2e1b93a0d464e1467c418281670bbf', 1, '1713895109', 0, '', 0)Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.13 ms end 0.01 ms query end 3.19 ms closing tables 0.05 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:254 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:451 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:51 - Query Time: 0.96 ms After last query: 2.92 ms Query memory: 0.021 MB Memory before query: 1.147 MB Rows returned: 5
SELECT id, rules
FROM `yh14_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.13 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.90 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 1.159 MB Rows returned: 2
SELECT b.id
FROM yh14_usergroups AS a
LEFT JOIN yh14_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 3.92 ms After last query: 2.95 ms Query memory: 0.007 MB Memory before query: 1.520 MB
UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"5cb7edef4eb7cd281db10046877e1302\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE yh14_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.03 ms System lock 0.09 ms updating 0.08 ms end 0.01 ms query end 2.82 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jbetolo/jbetolo.php:319 9 plgSystemJBetolo::dontJbetolo() JROOT/plugins/system/jbetolo/jbetolo/helper.php:274 8 jbetoloHelper::defineConstants() JROOT/plugins/system/jbetolo/jbetolo.php:846 7 require_once JROOT/plugins/system/jbetolo/jbetolo.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:721 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.03 ms After last query: 2.11 ms Query memory: 0.021 MB Memory before query: 1.642 MB Rows returned: 1
SELECT `custom_data`
FROM `yh14_extensions`
WHERE `type` = 'component'
AND `element` = 'com_sef'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 11 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sef/classes/config.php:754 10 SEFConfig->__construct() JROOT/administrator/components/com_sef/classes/config.php:956 9 SEFConfig::getConfig() JROOT/plugins/system/joomsef/joomsef.php:249 8 plgSystemJoomsef->_isEnabled() JROOT/plugins/system/joomsef/joomsef.php:31 7 plgSystemJoomsef->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:721 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.99 ms After last query: 6.43 ms Query memory: 0.021 MB Memory before query: 2.357 MB Rows returned: 0
SELECT *
FROM yh14_sef_subdomainsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sef_subdomains NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_sef/classes/seftools.php:1082 9 SEFTools::getAllSubdomains() JROOT/plugins/system/joomsef/joomsef.php:90 8 plgSystemJoomsef->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:722 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.89 ms After last query: 2.67 ms Query memory: 0.022 MB Memory before query: 2.440 MB Rows returned: 1Duplicate queries: #37
SELECT COUNT(*)
FROM yh14_sef_subdomains
WHERE subdomain='ampd-up'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sef_subdomains NULL ref PRIMARY PRIMARY 767 const 1 100.00 Using index Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 13 JDatabaseDriver->loadResult() JROOT/components/com_sef/joomsef.php:961 12 JoomSEF::parse() JROOT/components/com_sef/sef.router.php:331 11 JRouterJoomsef->parseSef() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.12 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 2.448 MB Rows returned: 0Duplicate queries: #38
SELECT `a`.`vars`, `u`.`sefurl`
FROM `yh14_sefaliases` AS `a`
INNER JOIN `yh14_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = 'events/rachel-platten-explains-meaning-behind-broken-glass'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref alias alias 767 const 1 100.00 NULL 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.url 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/joomsef.php:1667 13 JoomSEF::_parseAlias() JROOT/components/com_sef/joomsef.php:1101 12 JoomSEF::parse() JROOT/components/com_sef/sef.router.php:331 11 JRouterJoomsef->parseSef() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.81 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 2.457 MB Rows returned: 10
SELECT element,params
FROM yh14_extensions
WHERE type='sef_ext'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_extensions NULL ref extension extension 82 const 10 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_sef/classes/seftools.php:328 15 SEFTools::getExtParams() JROOT/components/com_sef/sef.ext.php:36 14 SefExt->__construct() JROOT/components/com_sef/joomsef.php:1331 13 JoomSEF::_parseSefUrl() JROOT/components/com_sef/joomsef.php:1119 12 JoomSEF::parse() JROOT/components/com_sef/sef.router.php:331 11 JRouterJoomsef->parseSef() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.48 ms After last query: 4.21 ms Query memory: 0.027 MB Memory before query: 3.458 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `yh14_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_announcement','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_favorite','com_fields','com_finder','com_installer','com_jbetolo','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_scriptmerge','com_search','com_sef','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_yhlookup','com_yhvideos')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 327 13.15 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.53 ms After last query: 0.74 ms Query memory: 0.031 MB Memory before query: 3.524 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `yh14_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yh14_content`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.10 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.80 ms After last query: 0.90 ms Query memory: 0.022 MB Memory before query: 3.573 MB Rows returned: 1Duplicate queries: #39
SELECT *
FROM yh14_content
WHERE `id` = '703'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 3.19 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 3.580 MB
UPDATE yh14_content
SET `hits` = (`hits` + 1)
WHERE `id` = '703'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE yh14_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.04 ms updating 0.08 ms end 0.01 ms query end 2.28 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1242 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.54 ms After last query: 1.85 ms Query memory: 0.023 MB Memory before query: 3.688 MB Rows returned: 1Duplicate queries: #30
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 yh14_content AS a
INNER JOIN yh14_categories AS c
on c.id = a.catid
LEFT JOIN yh14_users AS u
on u.id = a.created_by
LEFT JOIN yh14_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yh14_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 703
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 17:58:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 17:58:29')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.32 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.36 ms After last query: 1.06 ms Query memory: 0.028 MB Memory before query: 3.718 MB Rows returned: 3
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 `yh14_categories` AS `s`
INNER JOIN `yh14_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 24
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 33.60 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:670 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.90 ms After last query: 0.70 ms Query memory: 0.027 MB Memory before query: 3.759 MB Rows returned: 1
SELECT id, link, language
FROM yh14_menu
WHERE home=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_menu NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 138 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 22 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_sef/classes/seftools.php:1044 21 SEFTools::getHomeQueries() JROOT/components/com_sef/joomsef.php:483 20 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 19 JRouterJoomsef->buildSef() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 17 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 15 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 12 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.04 ms After last query: 0.70 ms Query memory: 0.022 MB Memory before query: 3.774 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `yh14_contentitem_tag_map` AS m
INNER JOIN `yh14_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 703
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ampd-up18.m.tag_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.45 ms After last query: 1.34 ms Query memory: 0.025 MB Memory before query: 3.912 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM yh14_fields AS a
LEFT JOIN `yh14_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yh14_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yh14_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yh14_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yh14_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yh14_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (24,0,17))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 ampd-up18.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 ampd-up18.a.id 1 100.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.27 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:427 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.01 ms After last query: 1.16 ms Query memory: 0.024 MB Memory before query: 3.942 MB Rows returned: 1
SELECT raw_stats
FROM yh14_mostpopular
WHERE content_id = 703id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_mostpopular NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 269 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.03 ms Opening tables 0.15 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 17 JDatabaseDriver->loadResult() JROOT/plugins/content/mostpopular/mostpopular.php:134 16 plgContentMostpopular->_getRawStats() JROOT/plugins/content/mostpopular/mostpopular.php:42 15 plgContentMostpopular->_updateStats() JROOT/plugins/content/mostpopular/mostpopular.php:31 14 plgContentMostpopular->onContentAfterDisplay() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:202 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 3.91 ms After last query: 0.32 ms Query memory: 0.008 MB Memory before query: 3.955 MB
UPDATE yh14_mostpopular
SET 1_day_stats = 1 , 7_day_stats = 7 , 30_day_stats = 30 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:30:{s:10:\"2024-03-25\";i:1;s:10:\"2024-03-26\";i:1;s:10:\"2024-03-27\";i:1;s:10:\"2024-03-28\";i:1;s:10:\"2024-03-29\";i:1;s:10:\"2024-03-30\";i:1;s:10:\"2024-03-31\";i:1;s:10:\"2024-04-01\";i:1;s:10:\"2024-04-02\";i:1;s:10:\"2024-04-03\";i:1;s:10:\"2024-04-04\";i:1;s:10:\"2024-04-05\";i:1;s:10:\"2024-04-06\";i:1;s:10:\"2024-04-07\";i:1;s:10:\"2024-04-08\";i:1;s:10:\"2024-04-09\";i:1;s:10:\"2024-04-10\";i:1;s:10:\"2024-04-11\";i:1;s:10:\"2024-04-12\";i:1;s:10:\"2024-04-13\";i:1;s:10:\"2024-04-14\";i:1;s:10:\"2024-04-15\";i:1;s:10:\"2024-04-16\";i:1;s:10:\"2024-04-17\";i:1;s:10:\"2024-04-18\";i:1;s:10:\"2024-04-19\";i:1;s:10:\"2024-04-20\";i:1;s:10:\"2024-04-21\";i:1;s:10:\"2024-04-22\";i:1;s:10:\"2024-04-23\";i:1;}'
WHERE content_id = 703id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE yh14_mostpopular NULL index NULL PRIMARY 8 NULL 269 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms updating 0.35 ms end 0.01 ms query end 2.85 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/plugins/content/mostpopular/mostpopular.php:84 15 plgContentMostpopular->_updateStats() JROOT/plugins/content/mostpopular/mostpopular.php:31 14 plgContentMostpopular->onContentAfterDisplay() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:202 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 4.00 ms After last query: 37.96 ms Query memory: 0.222 MB Memory before query: 4.626 MB Rows returned: 147
SELECT a.id,yv.image,yv.bc_image,yv.short_desc as description, a.title, a.alias, a.introtext, a.metadesc, a.catid
FROM yh14_content AS a
INNER JOIN yh14_yhvideos AS yv
ON yv.article_id=a.id
WHERE yv.playlist_id = "1"
AND a.id <> 703
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 17:58:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 17:58:29')
AND a.state = 1
ORDER BY a.id DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yv NULL ALL playlist_id NO INDEX KEY COULD BE USED NULL NULL 148 100.00 Using where; Using temporary; Using filesort 1 SIMPLE a NULL eq_ref PRIMARY,idx_state PRIMARY 4 ampd-up18.yv.article_id 1 16.00 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms Creating tmp table 0.13 ms Sorting result 0.03 ms executing 0.01 ms Sending data 1.30 ms Creating sort index 1.22 ms end 0.02 ms query end 0.02 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/modules/mod_noo_contentslider/helper.php:510 16 modNooContentSliderHelper::getListArticles() JROOT/modules/mod_noo_contentslider/helper.php:367 15 modNooContentSliderHelper::getMoreArticles() JROOT/modules/mod_noo_contentslider/helper.php:36 14 modNooContentSliderHelper::getList() JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:49 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.01 ms After last query: 0.64 ms Query memory: 0.030 MB Memory before query: 4.962 MB Rows returned: 3
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 `yh14_categories` AS `s`
INNER JOIN `yh14_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 22
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 30.40 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Same as call in the line below. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:670 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 17 Joomla\CMS\Router\Route::_() JROOT/modules/mod_noo_contentslider/helper.php:529 16 modNooContentSliderHelper::getListArticles() JROOT/modules/mod_noo_contentslider/helper.php:367 15 modNooContentSliderHelper::getMoreArticles() JROOT/modules/mod_noo_contentslider/helper.php:36 14 modNooContentSliderHelper::getList() JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:49 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.14 ms After last query: 0.64 ms Query memory: 0.030 MB Memory before query: 4.981 MB Rows returned: 3
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 `yh14_categories` AS `s`
INNER JOIN `yh14_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 25
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 35.20 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.23 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 25 ContentRouter->getCategorySegment() Same as call in the line below. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:670 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 17 Joomla\CMS\Router\Route::_() JROOT/modules/mod_noo_contentslider/helper.php:529 16 modNooContentSliderHelper::getListArticles() JROOT/modules/mod_noo_contentslider/helper.php:367 15 modNooContentSliderHelper::getMoreArticles() JROOT/modules/mod_noo_contentslider/helper.php:36 14 modNooContentSliderHelper::getList() JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:49 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.94 ms After last query: 3.23 ms Query memory: 0.028 MB Memory before query: 5.014 MB Rows returned: 1
SELECT *
FROM `yh14_sefurls`
WHERE `origurl` = 'index.php?option=com_content&catid=22&id=702&view=article'
LIMIT 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sefurls NULL ref origurl origurl 767 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/sef.ext.php:100 26 SefExt->getSefUrlFromDatabase() JROOT/components/com_sef/joomsef.php:561 25 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 24 JRouterJoomsef->buildSef() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 22 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 21 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 20 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 17 Joomla\CMS\Router\Route::_() JROOT/modules/mod_noo_contentslider/helper.php:529 16 modNooContentSliderHelper::getListArticles() JROOT/modules/mod_noo_contentslider/helper.php:367 15 modNooContentSliderHelper::getMoreArticles() JROOT/modules/mod_noo_contentslider/helper.php:36 14 modNooContentSliderHelper::getList() JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:49 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 3.18 ms After last query: 14.82 ms Query memory: 0.222 MB Memory before query: 5.123 MB Rows returned: 148
SELECT a.id,yv.image,yv.bc_image,yv.short_desc as description, a.title, a.alias, a.introtext, a.metadesc, a.catid
FROM yh14_content AS a
INNER JOIN yh14_yhvideos AS yv
ON yv.article_id=a.id
WHERE yv.playlist_id = "1"
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 17:58:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 17:58:29')
AND a.state = 1
ORDER BY a.id DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yv NULL ALL playlist_id NO INDEX KEY COULD BE USED NULL NULL 148 100.00 Using where; Using temporary; Using filesort 1 SIMPLE a NULL eq_ref PRIMARY,idx_state PRIMARY 4 ampd-up18.yv.article_id 1 16.00 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.20 ms preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 1.04 ms Creating sort index 0.87 ms end 0.01 ms query end 0.02 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/modules/mod_noo_contentslider/helper.php:510 16 modNooContentSliderHelper::getListArticles() JROOT/modules/mod_noo_contentslider/helper.php:367 15 modNooContentSliderHelper::getMoreArticles() JROOT/modules/mod_noo_contentslider/helper.php:36 14 modNooContentSliderHelper::getList() JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:53 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.77 ms After last query: 1.58 ms Query memory: 0.023 MB Memory before query: 5.164 MB Rows returned: 1
SELECT cat.title
FROM yh14_categories cat
WHERE cat.id=22id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cat NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/templates/yh/html/mod_noo_contentslider/default.php:36 14 require JROOT/templates/yh/html/mod_noo_contentslider/default.php JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:55 13 include JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:595 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.24 ms After last query: 29.61 ms Query memory: 0.022 MB Memory before query: 4.929 MB Rows returned: 1
SELECT c.`title`, c.`catid`, c.`metadesc`, c.`metakey`, c.`video_id`,c.`hits`, v.`article_url`, v.`image`, v.`bc_image`, v.`video_url`, v.`related_terms`, v.`playlist_id`
FROM yh14_content AS c
INNER JOIN yh14_yhvideos AS v
ON c.`video_id` = v.`video_id`
WHERE c.`id` = 703
AND c.`state`= 1
AND c.`publish_up` < NOW()
AND (c.`publish_down` > NOW() OR c.`publish_down` = '0000-00-00 00:00:00')
ORDER BY c.`hits` DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_state PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL ref video_id video_id 8 const 1 100.00 NULL Status Duration starting 0.21 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.10 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 12 JDatabaseDriver->loadObject() JROOT/modules/mod_video_player/helper.php:51 11 modVideoPlayerHelper::getVidParams() JROOT/modules/mod_video_player/mod_video_player.php:29 10 include JROOT/modules/mod_video_player/mod_video_player.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.83 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 4.936 MB Rows returned: 1
SELECT `section_name`,`player_id`,`player_key`
FROM yh14_yhlookup
WHERE `category_id` = 24
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_yhlookup NULL ref catid catid 5 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 12 JDatabaseDriver->loadObject() JROOT/modules/mod_video_player/helper.php:88 11 modVideoPlayerHelper::getVidParams() JROOT/modules/mod_video_player/mod_video_player.php:29 10 include JROOT/modules/mod_video_player/mod_video_player.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.08 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 4.947 MB Rows returned: 1Duplicate queries: #15
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 yh14_content AS a
INNER JOIN yh14_categories AS c
on c.id = a.catid
LEFT JOIN yh14_users AS u
on u.id = a.created_by
LEFT JOIN yh14_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yh14_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 703
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 17:58:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 17:58:29')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/modules/mod_video_player/helper.php:98 11 modVideoPlayerHelper::getArticleData() JROOT/modules/mod_video_player/mod_video_player.php:31 10 include JROOT/modules/mod_video_player/mod_video_player.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.71 ms After last query: 2.10 ms Query memory: 0.027 MB Memory before query: 5.055 MB Rows returned: 0
SELECT *
FROM `yh14_sefurls`
WHERE `origurl` = 'index.php?option=com_search&catid=24&format=opensearch&id=703&view=article'
LIMIT 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sefurls NULL ref origurl origurl 767 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 24 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/sef.ext.php:100 23 SefExt->getSefUrlFromDatabase() JROOT/components/com_sef/joomsef.php:561 22 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 21 JRouterJoomsef->buildSef() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 19 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 18 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 17 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 14 Joomla\CMS\Router\Route::_() JROOT/modules/mod_search/mod_search.php:25 13 include JROOT/modules/mod_search/mod_search.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.68 ms After last query: 0.69 ms Query memory: 0.028 MB Memory before query: 5.069 MB Rows returned: 0
SELECT *
FROM `yh14_sefurls`
WHERE `origurl` = 'index.php?option=com_content'
LIMIT 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sefurls NULL ref origurl origurl 767 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 25 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/sef.ext.php:100 24 SefExt->getSefUrlFromDatabase() JROOT/components/com_sef/joomsef.php:561 23 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 22 JRouterJoomsef->buildSef() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 20 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 18 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/templates/yh/html/mod_search/default.php:15 14 require JROOT/templates/yh/html/mod_search/default.php JROOT/modules/mod_search/mod_search.php:51 13 include JROOT/modules/mod_search/mod_search.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.77 ms After last query: 0.32 ms Query memory: 0.030 MB Memory before query: 5.091 MB Rows returned: 10
SELECT params, element
FROM yh14_extensions
WHERE state>=0
AND enabled=1
AND type='sef_ext'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_extensions NULL ref extension extension 82 const 10 3.33 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/joomsef.php:2108 26 JoomSEF::_getCustomMenuTitle() JROOT/components/com_sef/joomsef.php:1940 25 JoomSEF::_getMenuTitleLang() JROOT/components/com_sef/sef_ext/com_content.php:473 24 SefExt_com_content->create() JROOT/components/com_sef/joomsef.php:578 23 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 22 JRouterJoomsef->buildSef() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 20 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 18 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/templates/yh/html/mod_search/default.php:15 14 require JROOT/templates/yh/html/mod_search/default.php JROOT/modules/mod_search/mod_search.php:51 13 include JROOT/modules/mod_search/mod_search.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.54 ms After last query: 0.47 ms Query memory: 0.028 MB Memory before query: 5.106 MB Rows returned: 0
SELECT `id`, `alias` AS `name`, `language`
FROM `yh14_menu`
WHERE `id` = 252
AND `published` > 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 26 JDatabaseDriver->loadObject() JROOT/components/com_sef/joomsef.php:1977 25 JoomSEF::_getMenuTitleLang() JROOT/components/com_sef/sef_ext/com_content.php:473 24 SefExt_com_content->create() JROOT/components/com_sef/joomsef.php:578 23 JoomSEF::build() JROOT/components/com_sef/sef.router.php:283 22 JRouterJoomsef->buildSef() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/src/Router/Router.php:638 20 Joomla\CMS\Router\Router->processBuildRules() JROOT/libraries/src/Router/SiteRouter.php:655 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:614 18 Joomla\CMS\Router\Router->_processBuildRules() JROOT/libraries/src/Router/Router.php:270 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 15 Joomla\CMS\Router\Route::_() JROOT/templates/yh/html/mod_search/default.php:15 14 require JROOT/templates/yh/html/mod_search/default.php JROOT/modules/mod_search/mod_search.php:51 13 include JROOT/modules/mod_search/mod_search.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.53 ms After last query: 30.86 ms Query memory: 0.027 MB Memory before query: 5.145 MB Rows returned: 5
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 `yh14_categories` AS `s`
INNER JOIN `yh14_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 17
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 25 35.20 Using where Status Duration starting 0.22 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.08 ms statistics 0.22 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 16 Joomla\CMS\Categories\Categories->get() JROOT/libraries/src/Categories/CategoryNode.php:421 15 Joomla\CMS\Categories\CategoryNode->getChildren() JROOT/templates/yh/html/mod_menu/default.php:99 14 require JROOT/templates/yh/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 13 include JROOT/modules/mod_menu/mod_menu.php JROOT/libraries/src/Helper/ModuleHelper.php:201 12 Joomla\CMS\Helper\ModuleHelper::renderModule() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:617 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.19 ms After last query: 59.99 ms Query memory: 0.022 MB Memory before query: 5.123 MB Rows returned: 0
SELECT *
FROM yh14_jmap_metainfo
WHERE `linkurl` = 'https://ampd-up.com/events/rachel-platten-explains-meaning-behind-broken-glass'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_jmap_metainfo NULL ref published published 1 const 1 100.00 Using where Status Duration starting 0.22 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:350 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.89 ms After last query: 31.07 ms Query memory: 0.024 MB Memory before query: 5.519 MB Rows returned: 1Duplicate queries: #8
SELECT COUNT(*)
FROM yh14_sef_subdomains
WHERE subdomain='ampd-up'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_sef_subdomains NULL ref PRIMARY PRIMARY 767 const 1 100.00 Using index Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 16 JDatabaseDriver->loadResult() JROOT/components/com_sef/joomsef.php:961 15 JoomSEF::parse() JROOT/components/com_sef/sef.router.php:331 14 JRouterJoomsef->parseSef() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 12 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 11 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 10 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 9 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 8 Joomla\CMS\Router\SiteRouter->parse() JROOT/plugins/content/fb_tw_plus1/fb_tw_plus1.php:383 7 plgContentfb_tw_plus1->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.69 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 5.528 MB Rows returned: 0Duplicate queries: #9
SELECT `a`.`vars`, `u`.`sefurl`
FROM `yh14_sefaliases` AS `a`
INNER JOIN `yh14_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = 'events/rachel-platten-explains-meaning-behind-broken-glass'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref alias alias 767 const 1 100.00 NULL 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 ampd-up18.a.url 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/components/com_sef/joomsef.php:1667 16 JoomSEF::_parseAlias() JROOT/components/com_sef/joomsef.php:1101 15 JoomSEF::parse() JROOT/components/com_sef/sef.router.php:331 14 JRouterJoomsef->parseSef() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 12 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 11 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 10 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 9 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 8 Joomla\CMS\Router\SiteRouter->parse() JROOT/plugins/content/fb_tw_plus1/fb_tw_plus1.php:383 7 plgContentfb_tw_plus1->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.76 ms After last query: 0.43 ms Query memory: 0.021 MB Memory before query: 5.542 MB Rows returned: 1Duplicate queries: #13
SELECT *
FROM yh14_content
WHERE `id` = '703'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE yh14_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/plugins/content/fb_tw_plus1/fb_tw_plus1.php:387 7 plgContentfb_tw_plus1->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54
29 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
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 `yh14_categories` AS `s`
INNER JOIN `yh14_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)3 × SELECT *
FROM `yh14_sefurls`2 × SELECT `a`.`vars`, `u`.`sefurl`
FROM `yh14_sefaliases` AS `a`
INNER JOIN `yh14_sefurls` AS `u`
ON `u`.`id` = `a`.`url`2 × SELECT COUNT(*)
FROM yh14_sef_subdomains2 × SELECT *
FROM yh14_content2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 yh14_content AS a
INNER JOIN yh14_categories AS c
on c.id = a.catid
LEFT JOIN yh14_users AS u
on u.id = a.created_by
LEFT JOIN yh14_categories as parent
ON parent.id = c.parent_id
LEFT JOIN yh14_content_rating AS v
ON a.id = v.content_id2 × SELECT a.id,yv.image,yv.bc_image,yv.short_desc as description, a.title, a.alias, a.introtext, a.metadesc, a.catid
FROM yh14_content AS a
INNER JOIN yh14_yhvideos AS yv
ON yv.article_id=a.id1 × SELECT `session_id`
FROM `yh14_session`1 × SELECT raw_stats
FROM yh14_mostpopular1 × SELECT `id`, `alias` AS `name`, `language`
FROM `yh14_menu`1 × SELECT params, element
FROM yh14_extensions1 × SELECT `section_name`,`player_id`,`player_key`
FROM yh14_yhlookup1 × SELECT c.`title`, c.`catid`, c.`metadesc`, c.`metakey`, c.`video_id`,c.`hits`, v.`article_url`, v.`image`, v.`bc_image`, v.`video_url`, v.`related_terms`, v.`playlist_id`
FROM yh14_content AS c
INNER JOIN yh14_yhvideos AS v
ON c.`video_id` = v.`video_id`1 × SELECT cat.title
FROM yh14_categories cat1 × SELECT id, link, language
FROM yh14_menu1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM yh14_fields AS a
LEFT JOIN `yh14_languages` AS l
ON l.lang_code = a.language
LEFT JOIN yh14_users AS uc
ON uc.id=a.checked_out
LEFT JOIN yh14_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN yh14_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN yh14_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `yh14_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `m`.`tag_id`,`t`.*
FROM `yh14_contentitem_tag_map` AS m
INNER JOIN `yh14_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT id, rules
FROM `yh14_viewlevels1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `yh14_assets`1 × SELECT element,params
FROM yh14_extensions1 × SELECT *
FROM yh14_sef_subdomain1 × SELECT `custom_data`
FROM `yh14_extensions`1 × SELECT b.id
FROM yh14_usergroups AS a
LEFT JOIN yh14_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM yh14_jmap_metainfo
OTHER Tables:
1 × INSERT INTO `yh14_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6d2e1b93a0d464e1467c418281670bbf', 1, '1713895109', 0, '', 01 × UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"5cb7edef4eb7cd281db10046877e1302\"}'1 × SHOW FULL COLUMNS
FROM `yh14_content1 × UPDATE yh14_content
SET `hits` = (`hits` + 1)1 × UPDATE yh14_mostpopular
SET 1_day_stats = 1 , 7_day_stats = 7 , 30_day_stats = 30 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:30:{s:10:\"2024-03-25\";i:1;s:10:\"2024-03-26\";i:1;s:10:\"2024-03-27\";i:1;s:10:\"2024-03-28\";i:1;s:10:\"2024-03-29\";i:1;s:10:\"2024-03-30\";i:1;s:10:\"2024-03-31\";i:1;s:10:\"2024-04-01\";i:1;s:10:\"2024-04-02\";i:1;s:10:\"2024-04-03\";i:1;s:10:\"2024-04-04\";i:1;s:10:\"2024-04-05\";i:1;s:10:\"2024-04-06\";i:1;s:10:\"2024-04-07\";i:1;s:10:\"2024-04-08\";i:1;s:10:\"2024-04-09\";i:1;s:10:\"2024-04-10\";i:1;s:10:\"2024-04-11\";i:1;s:10:\"2024-04-12\";i:1;s:10:\"2024-04-13\";i:1;s:10:\"2024-04-14\";i:1;s:10:\"2024-04-15\";i:1;s:10:\"2024-04-16\";i:1;s:10:\"2024-04-17\";i:1;s:10:\"2024-04-18\";i:1;s:10:\"2024-04-19\";i:1;s:10:\"2024-04-20\";i:1;s:10:\"2024-04-21\";i:1;s:10:\"2024-04-22\";i:1;s:10:\"2024-04-23\";i:1;}'