{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713480879,
                "last": 1713480879,
                "now": 1713480879
            },
            "token": "R2TrEEsvgI16kwAXwIxhj4DU1b26GOMh"
        },
        "registry": {
            "plg_system_eprivacy_non_eu": false
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Time

Memory

38 Queries Logged 54.54 ms

1. Query Time: 0.38 ms Query memory: 0.023 MB Memory before query: 1.020 MB Rows returned: 0

   SELECT `data`
   
     FROM `cg_session`
   
     WHERE `session_id` = X'3930326537396330653635653233656232343132653037333661643066356464'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cg_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   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.31 ms After last query: 0.34 ms Query memory: 0.020 MB Memory before query: 1.034 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `cg_session`
   
     WHERE `session_id` = X'3930326537396330653635653233656232343132653037333661643066356464' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cg_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   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: 0.80 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 1.039 MB

   INSERT INTO `cg_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3930326537396330653635653233656232343132653037333661643066356464', 1, 1713480879, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `cg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3930326537396330653635653233656232343132653037333661643066356464', 1, 1713480879, 0, '', 0)

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.18 ms
   end	0.01 ms
   query end	0.39 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   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: 0.39 ms After last query: 1.17 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 5

   SELECT id, rules
   
     FROM `cg_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.03 ms

   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.]

   ---

5. Query Time: 0.43 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.127 MB Rows returned: 2

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   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.]

   ---

6. Query Time: 1.00 ms After last query: 5.44 ms Query memory: 0.006 MB Memory before query: 1.641 MB

   UPDATE `cg_extensions`
   
     SET `params` = '{\"mediaversion\":\"2faf0dff5d0768b2847f4751c4419fdb\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	cg_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.09 ms
   updating	0.12 ms
   end	0.02 ms
   query end	0.49 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eprivacy/eprivacy.php:60
   7	plgSystemePrivacy->__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.]

   ---

7. Query Time: 0.32 ms After last query: 9.82 ms Query memory: 0.020 MB Memory before query: 1.715 MB Rows returned: 1

   SELECT count(*)
   
     FROM `cg_cwgears_schedule`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
   8	plgSystemCwgears->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.]

   ---

8. Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 1.720 MB Rows returned: 1

   SELECT count(*)
   
     FROM `cg_cwgears_schedule`
   
     WHERE time + '86400'<'1713480879'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
   8	plgSystemCwgears->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.]

   ---

9. Query Time: 0.39 ms After last query: 5.78 ms Query memory: 0.022 MB Memory before query: 2.054 MB Rows returned: 1
   Duplicate queries: #10

   SELECT id 
     FROM cg_zoo_category 
     WHERE alias = 'sunday-lunch' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cg_zoo_category	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
   12	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
   11	AppAlias->translateAliasToID()	JROOT/components/com_zoo/router.php:197
   10	ZooParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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.]

   ---

10. Query Time: 0.31 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 2.062 MB Rows returned: 1
    Duplicate queries: #9

    SELECT id 
      FROM cg_zoo_category 
      WHERE alias = 'sunday-lunch' 
      LIMIT 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_zoo_category	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
    18	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
    17	AppAlias->translateAliasToID()	JROOT/components/com_zoo/router.php:197
    16	ZooParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    15	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    14	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    13	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    12	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    11	Joomla\CMS\Router\SiteRouter->parse()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:424
    10	PlgSystemEasyFrontendSeo->buildInternalUrl()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:363
    9	PlgSystemEasyFrontendSeo->getCorrectUrlId()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:316
    8	PlgSystemEasyFrontendSeo->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.]

    ---

11. Query Time: 0.42 ms After last query: 2.17 ms Query memory: 0.019 MB Memory before query: 2.160 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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.]

    ---

12. Query Time: 0.36 ms After last query: 2.31 ms Query memory: 0.022 MB Memory before query: 2.311 MB Rows returned: 1

    SELECT * 
      FROM cg_zoo_category 
      WHERE id = 23

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_zoo_category	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
    10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:77
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

13. Query Time: 0.34 ms After last query: 0.53 ms Query memory: 0.022 MB Memory before query: 2.400 MB Rows returned: 1

    SELECT * 
      FROM cg_zoo_application 
      WHERE id = 2

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_zoo_application	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    9	AppTable->get()	JROOT/administrator/components/com_zoo/classes/category.php:173
    8	Category->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:78
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

14. Query Time: 1.19 ms After last query: 1.77 ms Query memory: 0.028 MB Memory before query: 2.462 MB Rows returned: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cg_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ciaogusto','com_coalawebsociallinks','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyfrontendseo','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zoo')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	308	14.61	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.66 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

15. Query Time: 0.19 ms After last query: 0.35 ms Query memory: 0.007 MB Memory before query: 2.520 MB

    
      SET SESSION group_concat_max_len = 1048576

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len = 1048576

    Profile

    Status	Duration
    starting	0.04 ms
    Opening tables	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:183
    13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:293
    12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:317
    11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 14.38 ms After last query: 0.21 ms Query memory: 0.115 MB Memory before query: 2.532 MB Rows returned: 74

    SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
      FROM cg_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
      LEFT JOIN cg_zoo_category_item as ci 
      ON ci.category_id = c.id 
      LEFT JOIN cg_zoo_item AS i USE INDEX (MULTI_INDEX2) 
      ON ci.item_id = i.id 
      AND i.access IN (1,5) 
      AND i.state = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-18 22:54:39') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-18 22:54:39') 
      WHERE c.application_id = 2 
      AND c.published = 1 
      GROUP BY c.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	74	100.00	Using index condition
    1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	ciaogusto.c.id	31	100.00	Using index
    1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	4	ciaogusto.ci.item_id	1	100.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.07 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	13.79 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    17	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    16	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    15	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    14	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:209
    13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:293
    12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:317
    11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 7.06 ms After last query: 2.22 ms Query memory: 0.203 MB Memory before query: 3.136 MB Rows returned: 15

    SELECT a.* 
      FROM cg_zoo_item AS a 
      LEFT JOIN cg_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 2 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 22:54:39') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 22:54:39') 
      AND b.category_id  = 23 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.name 
      LIMIT 30,15

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	85	100.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	ciaogusto.b.item_id	1	30.80	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	5.51 ms
    Creating sort index	0.62 ms
    end	0.02 ms
    query end	0.02 ms
    removing tmp table	0.12 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    12	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:471
    11	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:234
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 7.54 ms After last query: 5.20 ms Query memory: 0.023 MB Memory before query: 3.657 MB Rows returned: 20

    SELECT DISTINCT BINARY CONVERT(LOWER(
      LEFT(name, 1)) USING utf8) letter 
      FROM cg_zoo_item 
      WHERE id IN (SELECT item_id 
      FROM cg_zoo_category_item) 
      AND application_id = 2 
      AND access IN (1,5) 
      AND state = 1 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-18 22:54:39') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-18 22:54:39')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_zoo_item	NULL	range	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,NAME_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	MULTI_INDEX	14	NULL	276	40.00	Using index condition; Using temporary
    1	SIMPLE	cg_zoo_category_item	NULL	ref	ITEMID_INDEX	ITEMID_INDEX	4	ciaogusto.cg_zoo_item.id	10	100.00	Using index; Distinct; FirstMatch(cg_zoo_item)

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.03 ms
    Creating tmp table	0.03 ms
    executing	0.01 ms
    Sending data	6.69 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:134
    13	DatabaseHelper->queryObjectList()	JROOT/administrator/components/com_zoo/helpers/application.php:92
    12	ApplicationHelper->getAlphaIndex()	JROOT/components/com_zoo/controllers/default.php:501
    11	DefaultController->_getAlphaindex()	JROOT/components/com_zoo/controllers/default.php:308
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.08 ms After last query: 273.94 ms Query memory: 0.031 MB Memory before query: 3.969 MB Rows returned: 9

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=79 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=79 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	8	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.02 ms
    Sending data	0.27 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.02 ms
    removing tmp table	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 1.17 ms After last query: 2.55 ms Query memory: 0.033 MB Memory before query: 4.042 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 cg_fields AS a
    
      LEFT JOIN `cg_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN cg_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN cg_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN cg_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN cg_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_zoo.element.textarea' 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	ciaogusto.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	ciaogusto.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ciaogusto.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ciaogusto.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	ciaogusto.a.group_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.24 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.05 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    32	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    31	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    30	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    29	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    28	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    26	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
    25	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:147
    24	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
    23	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:29
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.93 ms After last query: 0.38 ms Query memory: 0.031 MB Memory before query: 4.058 MB Rows returned: 11

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=270 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=270 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	10	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.04 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.32 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.71 ms After last query: 1.12 ms Query memory: 0.030 MB Memory before query: 4.076 MB Rows returned: 4

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=345 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=345 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	4	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.12 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.87 ms After last query: 1.09 ms Query memory: 0.031 MB Memory before query: 4.095 MB Rows returned: 9

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=172 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=172 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	14	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.33 ms
    executing	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.85 ms After last query: 1.09 ms Query memory: 0.031 MB Memory before query: 4.113 MB Rows returned: 9

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=173 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=173 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	14	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.29 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.80 ms After last query: 1.08 ms Query memory: 0.031 MB Memory before query: 4.132 MB Rows returned: 9

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=55 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=55 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	8	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.27 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.12 ms After last query: 450.61 ms Query memory: 0.031 MB Memory before query: 4.150 MB Rows returned: 11

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=171 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=171 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	16	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.35 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.88 ms After last query: 1.44 ms Query memory: 0.031 MB Memory before query: 4.169 MB Rows returned: 12

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=130 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=130 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	13	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.37 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.20 ms After last query: 497.07 ms Query memory: 0.031 MB Memory before query: 4.189 MB Rows returned: 12

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=213 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=213 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	12	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.08 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.38 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.09 ms After last query: 50.95 ms Query memory: 0.031 MB Memory before query: 4.208 MB Rows returned: 10

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=136 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=136 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	11	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.08 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.32 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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: 0.82 ms After last query: 1.31 ms Query memory: 0.031 MB Memory before query: 4.228 MB Rows returned: 9

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=229 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=229 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	15	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.26 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

31. Query Time: 0.86 ms After last query: 1.09 ms Query memory: 0.031 MB Memory before query: 4.246 MB Rows returned: 12

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=90 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=90 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	11	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.31 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

32. Query Time: 1.00 ms After last query: 1.06 ms Query memory: 0.031 MB Memory before query: 4.265 MB Rows returned: 14

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=179 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=179 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	22	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.41 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

33. Query Time: 0.93 ms After last query: 1.09 ms Query memory: 0.032 MB Memory before query: 4.306 MB Rows returned: 12

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=156 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=156 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	13	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.35 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

34. Query Time: 0.89 ms After last query: 1.06 ms Query memory: 0.031 MB Memory before query: 4.326 MB Rows returned: 12

    SELECT b.id 
      FROM cg_zoo_category_item AS a JOIN cg_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=181 
      AND b.published = 1 UNION SELECT 0 
      FROM cg_zoo_category_item AS a 
      WHERE a.item_id=181 
      AND a.category_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	19	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	ciaogusto.a.category_id	1	91.36	Using where
    2	UNION	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.34 ms
    executing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:473
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
    24	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:151
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php:17
    20	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:51
    18	ItemRenderer->render()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php:17
    17	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php:58
    15	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php:88
    13	include JROOT/media/zoo/applications/ricettario/templates/ciaogusto/category.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:155
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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.]

    ---

35. Query Time: 2.17 ms After last query: 3.36 ms Query memory: 0.045 MB Memory before query: 4.424 MB Rows returned: 23

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cg_modules AS m
    
      LEFT JOIN cg_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cg_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-18 22:54:39') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 22:54:39') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 605 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	76	1.60	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	ciaogusto.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	ciaogusto.m.id	2	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	1.54 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:633
    12	T3Template->countModules()	JROOT/templates/t3_bs3_blank/tpls/blocks/header.php:22
    11	include JROOT/templates/t3_bs3_blank/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
    10	T3Template->loadBlock()	JROOT/templates/t3_bs3_blank/tpls/default.php:32
    9	include JROOT/templates/t3_bs3_blank/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:221
    8	T3Template->loadLayout()	JROOT/templates/t3_bs3_blank/index.php:34
    7	require JROOT/templates/t3_bs3_blank/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

36. Query Time: 0.41 ms After last query: 14.65 ms Query memory: 0.022 MB Memory before query: 4.715 MB Rows returned: 0

    SELECT uikit
    
      FROM `cg_cwgears`
    
      WHERE url = 'https://ciaogusto.com/occasion/category/sunday-lunch/3'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

37. Query Time: 0.26 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.721 MB Rows returned: 0

    SELECT uikit_plus
    
      FROM `cg_cwgears`
    
      WHERE url = 'https://ciaogusto.com/occasion/category/sunday-lunch/3'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

38. Query Time: 0.40 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.723 MB Rows returned: 0

    SELECT * 
      FROM `cg_plg_easyfrontendseo` 
      WHERE `url` = 'index.php?option=com_zoo&task=category&category_id=23&page=3&Itemid=605'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cg_plg_easyfrontendseo	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:513
    12	PlgSystemEasyFrontendSeo->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---