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
Country Star Dylan Scott Takes Our Baby Food Taste Test
After country singer Dylan Scott treats us to a live acoustic performance of his hit single "My Girl", he sits down and talks with us about his impending fatherhood, and in that spirit, we challenge him to a baby food taste test! Find out if his taste buds are as keen as his music skills, and learn more about the specific flavor nuances of peas than you think you ever needed!
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714081209,
"last": 1714081209,
"now": 1714081209
},
"client": {
"forwarded": "13.59.82.167"
},
"token": "q9q5S8N1rZasR3HqMMwkQTHG0maHHkKS"
},
"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.04 ms / 2.04 ms Memory: 0.398 MB / 0.73 MB Application: afterLoad
Time: 33.11 ms / 35.16 ms Memory: 1.633 MB / 2.36 MB Application: afterInitialise
Time: 6.99 ms / 42.15 ms Memory: 0.966 MB / 3.33 MB Application: afterRoute
Time: 1.04 ms / 43.19 ms Memory: 0.083 MB / 3.41 MB Application: beforeRenderComponent com_content
Time: 0.72 ms / 43.91 ms Memory: 0.049 MB / 3.46 MB Application: Before Access::preloadComponents (all components)
Time: 1.70 ms / 45.62 ms Memory: 0.063 MB / 3.52 MB Application: After Access::preloadComponents (all components)
Time: 0.05 ms / 45.66 ms Memory: 0.000 MB / 3.52 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.17 ms / 45.84 ms Memory: 0.008 MB / 3.53 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 75.56 ms / 121.40 ms Memory: 0.956 MB / 4.48 MB Application: afterRenderComponent com_content
Time: 0.98 ms / 122.38 ms Memory: 0.010 MB / 4.50 MB Application: afterDispatch
Time: 1.49 ms / 123.87 ms Memory: 0.243 MB / 4.74 MB Application: beforeRenderModule mod_video_player (YH Video Player Module)
Time: 3.80 ms / 127.66 ms Memory: 0.053 MB / 4.79 MB Application: afterRenderModule mod_video_player (YH Video Player Module)
Time: 41.65 ms / 169.31 ms Memory: 0.476 MB / 5.27 MB Application: afterRender
Database queries total: 36.46 ms
5.50 MB (5,768,368 Bytes)
29 Queries Logged 36.46 ms
8 duplicate found!
- Query Time: 1.06 ms Query memory: 0.020 MB Memory before query: 1.067 MB Rows returned: 0
SELECT `session_id`
FROM `yh14_session`
WHERE `session_id` = 'b1c177528da0e678eedba63cafc6057f'
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.01 ms Opening tables 0.17 ms init 0.03 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.60 ms After last query: 0.15 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 ('b1c177528da0e678eedba63cafc6057f', 1, '1714081209', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `yh14_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b1c177528da0e678eedba63cafc6057f', 1, '1714081209', 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 2.60 ms closing tables 0.04 ms freeing items 0.05 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.85 ms After last query: 2.20 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.17 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.05 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 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.83 ms After last query: 0.10 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.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 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.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.09 ms After last query: 2.77 ms Query memory: 0.007 MB Memory before query: 1.520 MB
UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"64c98fcf6e81617c7522e0bba0739d40\"}'
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.08 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 2.31 ms closing tables 0.03 ms freeing items 0.03 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: 0.66 ms After last query: 1.84 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.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.07 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: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.84 ms After last query: 5.32 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.05 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.01 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.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: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.63 ms After last query: 2.70 ms Query memory: 0.022 MB Memory before query: 2.440 MB Rows returned: 1Duplicate queries: #27
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.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 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.79 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 2.448 MB Rows returned: 0Duplicate queries: #28
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/country-star-dylan-scott-takes-our-baby-food-taste-test'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.16 ms init 0.02 ms System lock 0.06 ms optimizing 0.02 ms statistics 0.04 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 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.79 ms After last query: 0.14 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.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.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.10 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 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.49 ms After last query: 3.80 ms Query memory: 0.027 MB Memory before query: 3.465 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.14 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.41 ms end 0.02 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.34 ms After last query: 0.52 ms Query memory: 0.031 MB Memory before query: 3.531 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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.24 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.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.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 Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.03 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.70 ms After last query: 0.75 ms Query memory: 0.022 MB Memory before query: 3.581 MB Rows returned: 1Duplicate queries: #29
SELECT *
FROM yh14_content
WHERE `id` = '654'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.07 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.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 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.03 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 3.587 MB
UPDATE yh14_content
SET `hits` = (`hits` + 1)
WHERE `id` = '654'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.07 ms end 0.01 ms query end 2.41 ms closing tables 0.05 ms freeing items 0.05 ms cleaning up 0.04 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.37 ms After last query: 1.34 ms Query memory: 0.023 MB Memory before query: 3.696 MB Rows returned: 1Duplicate queries: #25
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 = 654
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 21:40:09')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 21:40:09')
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.18 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.37 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 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.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: 1.08 ms After last query: 0.78 ms Query memory: 0.028 MB Memory before query: 3.727 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.05 ms System lock 0.01 ms optimizing 0.07 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.13 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 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.76 ms After last query: 0.43 ms Query memory: 0.027 MB Memory before query: 3.767 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.04 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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.11 ms end 0.01 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 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.83 ms After last query: 0.61 ms Query memory: 0.022 MB Memory before query: 3.783 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` = 654
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.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.03 ms System lock 0.03 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.03 ms cleaning up 0.00 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.30 ms After last query: 1.26 ms Query memory: 0.025 MB Memory before query: 3.920 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.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.27 ms init 0.05 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.13 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 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.10 ms Query memory: 0.024 MB Memory before query: 3.951 MB Rows returned: 1
SELECT raw_stats
FROM yh14_mostpopular
WHERE content_id = 654id 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.01 ms Opening tables 0.08 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.18 ms After last query: 0.36 ms Query memory: 0.008 MB Memory before query: 3.964 MB
UPDATE yh14_mostpopular
SET 1_day_stats = 2 , 7_day_stats = 6 , 30_day_stats = 19 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:29:{s:10:\"2024-03-01\";i:1;s:10:\"2024-03-04\";i:1;s:10:\"2024-03-06\";i:1;s:10:\"2024-03-08\";i:1;s:10:\"2024-03-14\";i:1;s:10:\"2024-03-15\";i:1;s:10:\"2024-03-16\";i:1;s:10:\"2024-03-18\";i:1;s:10:\"2024-03-19\";i:1;s:10:\"2024-03-21\";i:1;s:10:\"2024-03-22\";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-04-01\";i:1;s:10:\"2024-04-03\";i:1;s:10:\"2024-04-04\";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-11\";i:1;s:10:\"2024-04-12\";i:1;s:10:\"2024-04-13\";i:1;s:10:\"2024-04-17\";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;s:10:\"2024-04-25\";i:1;}'
WHERE content_id = 654id 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.04 ms init 0.02 ms System lock 0.02 ms updating 0.35 ms end 0.01 ms query end 2.25 ms closing tables 0.02 ms freeing items 0.03 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.64 ms After last query: 1.33 ms Query memory: 0.054 MB Memory before query: 4.021 MB Rows returned: 65
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yh14_modules AS m
LEFT JOIN yh14_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yh14_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 21:40:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 21:40:09')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 208 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 44 1.60 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 ampd-up18.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 ampd-up18.m.id 2 40.00 Using where; Using index Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.83 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 17 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 16 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 15 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/templates/yh/html/com_content/article/default.php:20 14 include JROOT/templates/yh/html/com_content/article/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_content/views/article/view.html.php:210 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: 53.62 ms Query memory: 0.022 MB Memory before query: 4.757 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` = 654
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.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.04 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.06 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.69 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.764 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.06 ms checking permissions 0.01 ms Opening tables 0.09 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.04 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 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.95 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 4.775 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 = 654
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 21:40:09')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 21:40:09')
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.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 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.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.69 ms After last query: 1.55 ms Query memory: 0.022 MB Memory before query: 4.778 MB Rows returned: 0
SELECT *
FROM yh14_jmap_metainfo
WHERE `linkurl` = 'https://ampd-up.com/spotlight/country-star-dylan-scott-takes-our-baby-food-taste-test'
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.08 ms checking permissions 0.01 ms Opening tables 0.12 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.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: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.76 ms After last query: 36.57 ms Query memory: 0.024 MB Memory before query: 5.239 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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 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.03 ms cleaning up 0.00 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.64 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 5.248 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/country-star-dylan-scott-takes-our-baby-food-taste-test'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.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.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.63 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 5.262 MB Rows returned: 1Duplicate queries: #13
SELECT *
FROM yh14_content
WHERE `id` = '654'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.01 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.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 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
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × 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`2 × SELECT *
FROM yh14_content1 × SELECT id, link, language
FROM yh14_menu1 × 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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM yh14_modules AS m
LEFT JOIN yh14_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN yh14_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 `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 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 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 ('b1c177528da0e678eedba63cafc6057f', 1, '1714081209', 0, '', 01 × UPDATE `yh14_extensions`
SET `params` = '{\"mediaversion\":\"64c98fcf6e81617c7522e0bba0739d40\"}'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 = 6 , 30_day_stats = 19 , all_time_stats = all_time_stats + 1 , raw_stats = 'a:29:{s:10:\"2024-03-01\";i:1;s:10:\"2024-03-04\";i:1;s:10:\"2024-03-06\";i:1;s:10:\"2024-03-08\";i:1;s:10:\"2024-03-14\";i:1;s:10:\"2024-03-15\";i:1;s:10:\"2024-03-16\";i:1;s:10:\"2024-03-18\";i:1;s:10:\"2024-03-19\";i:1;s:10:\"2024-03-21\";i:1;s:10:\"2024-03-22\";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-04-01\";i:1;s:10:\"2024-04-03\";i:1;s:10:\"2024-04-04\";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-11\";i:1;s:10:\"2024-04-12\";i:1;s:10:\"2024-04-13\";i:1;s:10:\"2024-04-17\";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;s:10:\"2024-04-25\";i:1;}'