{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1652738187,
                "last": 1652738187,
                "now": 1652738187
            },
            "token": "pqkbxueX5L2Tibtoby6pgKW7mv9wKrc3"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "com_zoo": {
            "zootrack": {
                "items": {
                    "current": null
                },
                "categories": {
                    "current": null
                }
            }
        }
    }
}

Time

Memory

166 Queries Logged 178.42 ms

1. Query Time: 0.75 ms Query memory: 0.023 MB Memory before query: 1.033 MB Rows returned: 0

   SELECT `data`
   
     FROM `a5uv2_session`
   
     WHERE `session_id` = X'6a35763339366c6d713330746b3031636b3476366d6c75743939'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.55 ms After last query: 4.08 ms Query memory: 0.020 MB Memory before query: 1.048 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `a5uv2_session`
   
     WHERE `session_id` = X'6a35763339366c6d713330746b3031636b3476366d6c75743939' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 1.47 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.053 MB

   INSERT INTO `a5uv2_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6a35763339366c6d713330746b3031636b3476366d6c75743939', 1, 1652738187, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `a5uv2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a35763339366c6d713330746b3031636b3476366d6c75743939', 1, 1652738187, 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 1.23 ms After last query: 6.58 ms Query memory: 0.025 MB Memory before query: 1.084 MB Rows returned: 42

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `a5uv2_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_extensions	ref	extension	extension	82	const	42	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.61 ms After last query: 6.96 ms Query memory: 0.021 MB Memory before query: 1.115 MB Rows returned: 5

   SELECT id, rules
   
     FROM `a5uv2_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   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:318
   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:604
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.70 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 1.127 MB Rows returned: 2

   SELECT b.id
   
     FROM a5uv2_usergroups AS a
   
     LEFT JOIN a5uv2_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   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:318
   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:604
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 1.71 ms After last query: 0.82 ms Query memory: 0.030 MB Memory before query: 1.149 MB Rows returned: 110

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM a5uv2_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_extensions	ref	extension	extension	82	const	136	Using index condition; Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   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:604
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.98 ms After last query: 105.78 ms Query memory: 0.021 MB Memory before query: 1.983 MB Rows returned: 2

   SELECT *
   
     FROM a5uv2_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.70 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 1.992 MB Rows returned: 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `a5uv2_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a5uv2_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.93 ms After last query: 78.89 ms Query memory: 0.025 MB Memory before query: 2.212 MB Rows returned: 1

    SELECT id,template 
      FROM a5uv2_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a5uv2_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:28
    16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
    15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
    14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
    13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
    12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
    11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:113
    10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:8
    9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:16
    8	plgSystemWidgetkit->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:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 2.73 ms After last query: 80.58 ms Query memory: 0.161 MB Memory before query: 2.509 MB Rows returned: 122

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM a5uv2_menu AS m
    
      LEFT JOIN a5uv2_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	296	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	cine_com.m.component_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/zoolingual/zoolingual.php:48
    9	plgSystemZoolingual->init()	JROOT/plugins/system/zoolingual/zoolingual.php:39
    8	plgSystemZoolingual->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:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 1.23 ms After last query: 85.27 ms Query memory: 0.038 MB Memory before query: 3.755 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM a5uv2_template_styles as s
    
      LEFT JOIN a5uv2_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	cine_com.s.template,const	1	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:97
    13	YOOtheme\Theme\Joomla\ThemeLoader::getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:38
    12	YOOtheme\Theme\Joomla\ThemeLoader::initTheme()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    11	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    10	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    7	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.95 ms After last query: 31.86 ms Query memory: 0.025 MB Memory before query: 3.958 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `a5uv2_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a5uv2_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    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/zooseo/zooseo.php:545
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 1.63 ms After last query: 0.31 ms Query memory: 0.006 MB Memory before query: 3.950 MB

    UPDATE `a5uv2_extensions`
    
      SET `params` = '{\"mediaversion\":\"02ef9c699cd5588aff4d176fff535e21\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `a5uv2_extensions` SET `params` = '{\"mediaversion\":\"02ef9c699cd5588aff4d176fff535e21\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	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/zooseo/zooseo.php:545
    9	plgSystemZooSeo->addOpenGraphTags()	JROOT/plugins/system/zooseo/zooseo.php:96
    8	plgSystemZooSeo->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 2.22 ms After last query: 67.82 ms Query memory: 0.028 MB Memory before query: 4.224 MB Rows returned: 41

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `a5uv2_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_sendinblue','com_tags','com_templates','com_users','com_vdata','com_vikevents','com_widgetkit','com_wrapper','com_zoo')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a5uv2_assets	range	idx_asset_name	idx_asset_name	402	NULL	43	Using index condition

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 4.81 ms After last query: 0.33 ms Query memory: 0.087 MB Memory before query: 4.276 MB Rows returned: 551

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `a5uv2_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a5uv2_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	2067	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    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:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 1.75 ms After last query: 9.75 ms Query memory: 0.032 MB Memory before query: 4.757 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `a5uv2_content`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `a5uv2_content`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    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:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 1.90 ms After last query: 16.18 ms Query memory: 0.005 MB Memory before query: 4.807 MB

    UPDATE a5uv2_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '377'

    Explain

    EXPLAIN not possible on query: UPDATE a5uv2_content SET `hits` = (`hits` + 1) WHERE `id` = '377'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 1.28 ms After last query: 6.20 ms Query memory: 0.101 MB Memory before query: 4.834 MB Rows returned: 1

    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 a5uv2_content AS a
    
      INNER JOIN a5uv2_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN a5uv2_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN a5uv2_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 377 
      AND c.published > 0 
      AND a.language in ('en-GB','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 2.97 ms After last query: 10.63 ms Query memory: 0.022 MB Memory before query: 5.010 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `a5uv2_contentitem_tag_map` AS m 
    
      INNER JOIN `a5uv2_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 377 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	20	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	cine_com.t.id	3	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 2.94 ms After last query: 294.23 ms Query memory: 0.037 MB Memory before query: 6.549 MB Rows returned: 2

    SELECT DISTINCT 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, g.note as group_note
    
      FROM a5uv2_fields AS a
    
      LEFT JOIN `a5uv2_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN a5uv2_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN a5uv2_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN a5uv2_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.user' 
      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 ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	2	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cine_com.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.group_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    46	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    45	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    44	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    43	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    42	FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/FieldsHelper.php:17
    41	YOOtheme\Builder\Joomla\Fields\FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/SourceListener.php:27
    40	YOOtheme\Builder\Joomla\Fields\SourceListener::initSource()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    39	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    38	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    37	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    36	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    35	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-source/bootstrap.php:46
    34	YOOtheme\Application::YOOtheme\Builder\{closure}()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    33	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:155
    32	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:323
    31	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    30	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:50
    29	YOOtheme\Container->__invoke()	JROOT/templates/yootheme/vendor/yootheme/application/functions.php:24
    28	YOOtheme\app()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:103
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 7.29 ms After last query: 1.58 ms Query memory: 0.080 MB Memory before query: 6.585 MB Rows returned: 53

    SELECT DISTINCT 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, g.note as group_note
    
      FROM a5uv2_fields AS a
    
      LEFT JOIN `a5uv2_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN a5uv2_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN a5uv2_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN a5uv2_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.article' 
      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 ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	idx_state,idx_access,idx_context	NO INDEX KEY COULD BE USED	NULL	NULL	71	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cine_com.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.group_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    46	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    45	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    44	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    43	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    42	FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/FieldsHelper.php:17
    41	YOOtheme\Builder\Joomla\Fields\FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/SourceListener.php:27
    40	YOOtheme\Builder\Joomla\Fields\SourceListener::initSource()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    39	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    38	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    37	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    36	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    35	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-source/bootstrap.php:46
    34	YOOtheme\Application::YOOtheme\Builder\{closure}()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    33	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:155
    32	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:323
    31	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    30	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:50
    29	YOOtheme\Container->__invoke()	JROOT/templates/yootheme/vendor/yootheme/application/functions.php:24
    28	YOOtheme\app()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:103
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 6.62 ms After last query: 2.39 ms Query memory: 0.044 MB Memory before query: 6.902 MB Rows returned: 14

    SELECT DISTINCT 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, g.note as group_note
    
      FROM a5uv2_fields AS a
    
      LEFT JOIN `a5uv2_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN a5uv2_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN a5uv2_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN a5uv2_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.categories' 
      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 ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	14	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cine_com.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.group_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    46	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    45	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    44	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    43	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    42	FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/FieldsHelper.php:17
    41	YOOtheme\Builder\Joomla\Fields\FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/SourceListener.php:27
    40	YOOtheme\Builder\Joomla\Fields\SourceListener::initSource()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    39	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    38	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    37	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    36	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    35	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-source/bootstrap.php:46
    34	YOOtheme\Application::YOOtheme\Builder\{closure}()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    33	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:155
    32	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:323
    31	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    30	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:50
    29	YOOtheme\Container->__invoke()	JROOT/templates/yootheme/vendor/yootheme/application/functions.php:24
    28	YOOtheme\app()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:103
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 2.19 ms After last query: 1.12 ms Query memory: 0.036 MB Memory before query: 7.002 MB Rows returned: 0

    SELECT DISTINCT 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, g.note as group_note
    
      FROM a5uv2_fields AS a
    
      LEFT JOIN `a5uv2_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN a5uv2_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN a5uv2_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN a5uv2_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_contact.contact' 
      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 ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	cine_com.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	cine_com.a.group_id	1	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    46	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    45	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    44	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    43	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    42	FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/FieldsHelper.php:17
    41	YOOtheme\Builder\Joomla\Fields\FieldsHelper::getFields()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-fields/src/SourceListener.php:27
    40	YOOtheme\Builder\Joomla\Fields\SourceListener::initSource()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    39	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    38	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    37	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    36	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/utils/src/Event.php:47
    35	YOOtheme\Event::emit()	JROOT/templates/yootheme/vendor/yootheme/builder-source/bootstrap.php:46
    34	YOOtheme\Application::YOOtheme\Builder\{closure}()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    33	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:155
    32	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:323
    31	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:91
    30	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:50
    29	YOOtheme\Container->__invoke()	JROOT/templates/yootheme/vendor/yootheme/application/functions.php:24
    28	YOOtheme\app()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:103
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 1.56 ms After last query: 609.97 ms Query memory: 0.053 MB Memory before query: 10.500 MB Rows returned: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (499) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 1.17 ms After last query: 4.61 ms Query memory: 0.053 MB Memory before query: 10.544 MB Rows returned: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (461) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 1.11 ms After last query: 1.14 ms Query memory: 0.053 MB Memory before query: 10.567 MB Rows returned: 1
    Duplicate queries: #31

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (436) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 1.15 ms After last query: 1.04 ms Query memory: 0.053 MB Memory before query: 10.589 MB Rows returned: 1
    Duplicate queries: #37

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (441) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 1.05 ms After last query: 1.04 ms Query memory: 0.053 MB Memory before query: 10.612 MB Rows returned: 1
    Duplicate queries: #35

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (439) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 1.14 ms After last query: 1.04 ms Query memory: 0.053 MB Memory before query: 10.634 MB Rows returned: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM a5uv2_content AS a
    
      LEFT JOIN a5uv2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN a5uv2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN a5uv2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN a5uv2_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.id IN (366) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-16 21:56:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-16 21:56:27') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    47	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    46	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    45	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    44	ContentModelArticles->getItems()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:97
    43	YOOtheme\Builder\Joomla\Source\ArticleHelper::query()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/ArticleHelper.php:24
    42	YOOtheme\Builder\Joomla\Source\ArticleHelper::get()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla-source/src/Type/CustomArticleQueryType.php:213
    41	YOOtheme\Builder\Joomla\Source\Type\CustomArticleQueryType::resolve()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/Utils/Middleware.php:42
    40	YOOtheme\GraphQL\Utils\Middleware->__invoke()	JROOT/templates/yootheme/vendor/yootheme/graphql/src/SchemaBuilder.php:306
    39	YOOtheme\GraphQL\SchemaBuilder->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:781
    38	YOOtheme\GraphQL\Executor\Executor->resolveOrError()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:739
    37	YOOtheme\GraphQL\Executor\Executor->resolveField()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:473
    36	YOOtheme\GraphQL\Executor\Executor->executeFields()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:349
    35	YOOtheme\GraphQL\Executor\Executor->executeOperation()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:309
    34	YOOtheme\GraphQL\Executor\Executor->YOOtheme\GraphQL\Executor\{closure}()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Promise/Adapter/SyncPromiseAdapter.php:59
    33	YOOtheme\GraphQL\Executor\Promise\Adapter\SyncPromiseAdapter->create()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:310
    32	YOOtheme\GraphQL\Executor\Executor->doExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/Executor/Executor.php:166
    31	YOOtheme\GraphQL\Executor\Executor::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:148
    30	YOOtheme\GraphQL\GraphQL::promiseToExecute()	JROOT/templates/yootheme/vendor/yootheme/graphql/lib/GraphQL.php:85
    29	YOOtheme\GraphQL\GraphQL::executeQuery()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source.php:69
    28	YOOtheme\Builder\Source->query()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:113
    27	YOOtheme\Builder\Source\SourceTransform->querySource()	JROOT/templates/yootheme/vendor/yootheme/builder-source/src/Source/SourceTransform.php:60
    26	YOOtheme\Builder\Source\SourceTransform->__invoke()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:248
    25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    22	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    21	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:269
    20	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:94
    19	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:111
    18	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/src/ContentListener.php:97
    17	YOOtheme\Builder\Joomla\ContentListener->prepareContent()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
    16	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
    15	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
    14	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
    13	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
    12	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Cont