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
Madison Beer Talks New Single, Festivals, & Weirdest Meals
The amazing Madison Beer returns to the Young Hollywood Studio to catch us up on her incredible new single "Home With You" and her experience performing at Lollapalooza for the first time! She also reveals what designers she's most looking forward to seeing at New York Fashion Week, plus she tells us her favorite "weird" food combination!
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713896851,
"last": 1713896851,
"now": 1713896851
},
"client": {
"forwarded": "13.58.151.231"
},
"token": "foqY5u3NwkuWfaGiwZfQwNmr1FQx5PhX"
},
"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: 1.88 ms / 1.88 ms Memory: 0.398 MB / 0.73 MB Application: afterLoad
Time: 35.41 ms / 37.29 ms Memory: 1.633 MB / 2.36 MB Application: afterInitialise
Time: 7.19 ms / 44.49 ms Memory: 0.962 MB / 3.32 MB Application: afterRoute
Time: 1.12 ms / 45.61 ms Memory: 0.083 MB / 3.41 MB Application: beforeRenderComponent com_content
Time: 0.99 ms / 46.60 ms Memory: 0.049 MB / 3.46 MB Application: Before Access::preloadComponents (all components)
Time: 1.65 ms / 48.26 ms Memory: 0.063 MB / 3.52 MB Application: After Access::preloadComponents (all components)
Time: 0.06 ms / 48.32 ms Memory: 0.000 MB / 3.52 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.24 ms / 48.56 ms Memory: 0.008 MB / 3.52 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 49.35 ms / 97.91 ms Memory: 0.944 MB / 4.47 MB Application: afterRenderComponent com_content
Time: 1.21 ms / 99.12 ms Memory: 0.010 MB / 4.48 MB Application: afterDispatch
Time: 1.90 ms / 101.02 ms Memory: 0.243 MB / 4.72 MB Application: beforeRenderModule mod_video_player (YH Video Player Module)
Time: 4.30 ms / 105.32 ms Memory: 0.053 MB / 4.77 MB Application: afterRenderModule mod_video_player (YH Video Player Module)
Time: 40.99 ms / 146.31 ms Memory: 0.476 MB / 5.25 MB Application: afterRender
Database queries total: 35.03 ms
5.47 MB (5,736,416 Bytes)
28 Queries Logged 35.03 ms
8 duplicate found!
- Query Time: 0.79 ms Query memory: 0.020 MB Memory before query: 1.067 MB Rows returned: 0
SELECT `session_id`
FROM `yh14_session`
WHERE `session_id` = '77fac57b7c8fe09021242c6a282fc0b7'
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.11 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 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: 2.07 ms After last query: 0.11 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 ('77fac57b7c8fe09021242c6a282fc0b7', 1, '1713896851', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `yh14_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('77fac57b7c8fe09021242c6a282fc0b7', 1, '1713896851', 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms update 0.09 ms end 0.01 ms query end 1.50 ms closing tables 0.03 ms freeing items 0.04 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.76 ms After last query: 3.38 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.08 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.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.87 ms After last query: 0.21 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.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 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 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.27 ms After last query: 3.23 ms Query memory: 0.007 MB Memory before query: 1.520 MB
UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"c34c2a834ae7f1f19f3ac1652fa57de9\"}'
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.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.11 ms updating 0.08 ms end 0.01 ms query end 2.31 ms closing tables 0.05 ms freeing items 0.05 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.27 ms After last query: 2.24 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.21 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.13 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 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 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.96 ms After last query: 6.68 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.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 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.13 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.47 ms Query memory: 0.022 MB Memory before query: 2.440 MB Rows returned: 1Duplicate queries: #26
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.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 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.03 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: 0.74 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 2.448 MB Rows returned: 0Duplicate queries: #27
SELECT `a`.`vars`, `u`.`sefurl`
FROM `yh14_sefaliases` AS `a`
INNER JOIN `yh14_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = 'spotlight/madison-beer-talks-new-single-festivals--weirdest-meals'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.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 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.06 ms freeing items 0.03 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.74 ms After last query: 0.16 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.03 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.04 ms preparing 0.01 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 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.39 ms After last query: 4.32 ms Query memory: 0.027 MB Memory before query: 3.461 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.12 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.35 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 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.31 ms After last query: 0.71 ms Query memory: 0.031 MB Memory before query: 3.527 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.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 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 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.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.06 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: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.73 ms After last query: 0.84 ms Query memory: 0.022 MB Memory before query: 3.577 MB Rows returned: 1Duplicate queries: #28
SELECT *
FROM yh14_content
WHERE `id` = '728'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.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 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.21 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 3.584 MB
UPDATE yh14_content
SET `hits` = (`hits` + 1)
WHERE `id` = '728'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.03 ms updating 0.06 ms end 0.01 ms query end 2.55 ms closing tables 0.03 ms freeing items 0.04 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.22 ms After last query: 1.52 ms Query memory: 0.023 MB Memory before query: 3.692 MB Rows returned: 1Duplicate queries: #24
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 = 728
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 18:27:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 18:27:31')
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.19 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.04 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.02 ms executing 0.00 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 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: 0.92 ms After last query: 1.03 ms Query memory: 0.026 MB Memory before query: 3.731 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.06 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.05 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: 0.92 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 3.756 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` = 728
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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 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.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.14 ms After last query: 1.31 ms Query memory: 0.027 MB Memory before query: 3.899 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.14 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.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() 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.32 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 3.924 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 (22,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.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.12 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 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 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: 0.99 ms After last query: 1.11 ms Query memory: 0.024 MB Memory before query: 3.955 MB Rows returned: 1
SELECT raw_stats
FROM yh14_mostpopular
WHERE content_id = 728id 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.13 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.23 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.63 ms After last query: 0.28 ms Query memory: 0.008 MB Memory before query: 3.968 MB
UPDATE yh14_mostpopular
SET 1_day_stats = 2 , 7_day_stats = 8 , 30_day_stats = 31 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:29:{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 = 728id 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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms updating 0.42 ms end 0.01 ms query end 2.48 ms closing tables 0.03 ms freeing items 0.06 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: 1.22 ms After last query: 29.80 ms Query memory: 0.022 MB Memory before query: 4.740 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` = 728
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.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.07 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.04 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 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.71 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 4.748 MB Rows returned: 1
SELECT `section_name`,`player_id`,`player_key`
FROM yh14_yhlookup
WHERE `category_id` = 22
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.05 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 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 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: 0.99 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 4.759 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 = 728
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 18:27:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 18:27:31')
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.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.00 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.00 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 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.62 ms After last query: 2.20 ms Query memory: 0.022 MB Memory before query: 4.761 MB Rows returned: 0
SELECT *
FROM yh14_jmap_metainfo
WHERE `linkurl` = 'https://ampd-up.com/spotlight/madison-beer-talks-new-single-festivals--weirdest-meals'
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.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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 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.92 ms After last query: 35.34 ms Query memory: 0.024 MB Memory before query: 5.223 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.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.01 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 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.67 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 5.231 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` = 'spotlight/madison-beer-talks-new-single-festivals--weirdest-meals'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.07 ms checking permissions 0.01 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.05 ms preparing 0.01 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.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.77 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 5.245 MB Rows returned: 1Duplicate queries: #13
SELECT *
FROM yh14_content
WHERE `id` = '728'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.04 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
24 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × 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 COUNT(*)
FROM yh14_sef_subdomains2 × SELECT `a`.`vars`, `u`.`sefurl`
FROM `yh14_sefaliases` AS `a`
INNER JOIN `yh14_sefurls` AS `u`
ON `u`.`id` = `a`.`url`1 × 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 raw_stats
FROM yh14_mostpopular1 × 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 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)1 × 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 `session_id`
FROM `yh14_session`1 × SELECT id, link, language
FROM yh14_menu1 × 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 ('77fac57b7c8fe09021242c6a282fc0b7', 1, '1713896851', 0, '', 01 × UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"c34c2a834ae7f1f19f3ac1652fa57de9\"}'1 × SHOW FULL COLUMNS
FROM `yh14_content1 × UPDATE yh14_content
SET `hits` = (`hits` + 1)1 × UPDATE yh14_mostpopular
SET 1_day_stats = 2 , 7_day_stats = 8 , 30_day_stats = 31 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:29:{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;}'