{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1749221182,
                "last": 1749221182,
                "now": 1749221182
            },
            "client": {
                "forwarded": "10.1.65.76"
            }
        },
        "registry": {
            "com_sobipro": {
                "back_url": "\/en\/producers\/45\/view,rss",
                "currently-displayed-entries": [
                    "423",
                    "320"
                ],
                "messages-queue": []
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

58 Queries Logged 72.97 ms

1. Query Time: 1.36 ms Query memory: 0.025 MB Memory before query: 1.204 MB Rows returned: 0

   SELECT `data`
   
     FROM `cz27f_session`
   
     WHERE `session_id` = 'a2a4338a435d77e28688266c0863b0af'

   Explain

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

   Profile

   Status	Duration
   Starting	0.10 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   Checking query cache for query	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.04 ms
   System lock	0.02 ms
   table lock	0.04 ms
   Waiting for query cache lock	0.06 ms
   init	0.06 ms
   Optimizing	0.05 ms
   Statistics	0.09 ms
   Preparing	0.03 ms
   Executing	0.04 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.03 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.11 ms
   Waiting for query cache lock	0.03 ms
   Updating status	0.02 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

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

   ---

2. Query Time: 1.00 ms After last query: 0.87 ms Query memory: 0.022 MB Memory before query: 1.283 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `cz27f_session`
   
     WHERE `session_id` = 'a2a4338a435d77e28688266c0863b0af' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.04 ms
   starting	0.02 ms
   Checking query cache for query	0.06 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   Waiting for query cache lock	0.04 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.03 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.04 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.04 ms
   Updating status	0.03 ms
   Storing result in query cache	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

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

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

   ---

3. Query Time: 3.41 ms After last query: 0.15 ms Query memory: 0.004 MB Memory before query: 1.288 MB

   INSERT INTO `cz27f_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('a2a4338a435d77e28688266c0863b0af', 1, 1749221182, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `cz27f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a2a4338a435d77e28688266c0863b0af', 1, 1749221182, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.04 ms
   Opening tables	0.04 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.04 ms
   Update	1.76 ms
   Waiting for query cache lock	0.03 ms
   Update	0.41 ms
   End of update loop	0.04 ms
   Query end	0.02 ms
   Commit	0.57 ms
   Query end	0.03 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

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

   ---

4. Query Time: 2.21 ms After last query: 1.76 ms Query memory: 0.030 MB Memory before query: 1.324 MB Rows returned: 40

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   Checking query cache for query	0.08 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   Waiting for query cache lock	0.07 ms
   init	0.07 ms
   Optimizing	0.08 ms
   Statistics	0.14 ms
   Preparing	0.07 ms
   Executing	0.03 ms
   Sending data	0.28 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.59 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.02 ms
   Storing result in query cache	0.09 ms
   Reset for next command	0.03 ms

   Call Stack

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

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

   ---

5. Query Time: 0.33 ms After last query: 1.72 ms Query memory: 0.023 MB Memory before query: 1.359 MB Rows returned: 4

   SELECT id, rules
   
     FROM `cz27f_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.04 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   Checking query cache for query	0.02 ms
   checking privileges on cached	0.02 ms
   checking permissions	0.02 ms
   Sending cached result to clien	0.04 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

   ---

6. Query Time: 0.33 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 1.370 MB Rows returned: 2

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.04 ms
   starting	0.03 ms
   Checking query cache for query	0.02 ms
   checking privileges on cached	0.02 ms
   checking permissions	0.03 ms
   Sending cached result to clien	0.03 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

   ---

7. Query Time: 2.35 ms After last query: 0.38 ms Query memory: 0.039 MB Memory before query: 1.393 MB Rows returned: 109

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.03 ms
   starting	0.02 ms
   Checking query cache for query	0.11 ms
   checking permissions	0.04 ms
   Opening tables	0.04 ms
   After opening tables	0.03 ms
   System lock	0.03 ms
   table lock	0.04 ms
   Waiting for query cache lock	0.04 ms
   init	0.06 ms
   Optimizing	0.06 ms
   Statistics	0.09 ms
   Preparing	0.05 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	0.75 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.31 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.02 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.02 ms

   Call Stack

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

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

   ---

8. Query Time: 1.66 ms After last query: 7.47 ms Query memory: 0.026 MB Memory before query: 1.899 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   Checking query cache for query	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   Waiting for query cache lock	0.03 ms
   init	0.06 ms
   Optimizing	0.04 ms
   Statistics	0.13 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.60 ms
   Waiting for query cache lock	0.02 ms
   Updating status	0.10 ms
   Storing result in query cache	0.07 ms
   Reset for next command	0.03 ms

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   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/kunena/kunena.php:70
   7	plgSystemKunena->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

   ---

9. Query Time: 3.27 ms After last query: 0.53 ms Query memory: 0.006 MB Memory before query: 1.892 MB

   UPDATE `cz27f_extensions`
   
     SET `params` = '{\"mediaversion\":\"fff553fbf4cac5b61d5e27ac98a9b867\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.04 ms
   System lock	0.03 ms
   table lock	0.03 ms
   init for update	0.11 ms
   Updating	0.16 ms
   End of update loop	0.03 ms
   Waiting for query cache lock	0.02 ms
   End of update loop	1.64 ms
   Query end	0.03 ms
   Commit	0.56 ms
   Query end	0.03 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.03 ms
   Query end	0.03 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.07 ms
   Reset for next command	0.03 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/kunena/kunena.php:70
   7	plgSystemKunena->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

   ---

10. Query Time: 1.25 ms After last query: 3.07 ms Query memory: 0.022 MB Memory before query: 2.005 MB Rows returned: 1

    SELECT `enabled`
    
      FROM `cz27f_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.06 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.14 ms
    Preparing	0.06 ms
    Executing	0.03 ms
    Sending data	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.27 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

11. Query Time: 0.37 ms After last query: 3.59 ms Query memory: 0.027 MB Memory before query: 2.189 MB Rows returned: 3

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.04 ms
    checking privileges on cached	0.03 ms
    checking permissions	0.03 ms
    Sending cached result to clien	0.05 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

12. Query Time: 1.25 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 2.263 MB Rows returned: 6

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.06 ms
    Optimizing	0.08 ms
    Statistics	0.13 ms
    Preparing	0.07 ms
    Executing	0.03 ms
    Sending data	0.11 ms
    End of update loop	0.04 ms
    Query end	0.03 ms
    Commit	0.04 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.17 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
    8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

13. Query Time: 3.80 ms After last query: 18.44 ms Query memory: 0.196 MB Memory before query: 2.342 MB Rows returned: 244

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.12 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.14 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.06 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.18 ms
    Preparing	0.07 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.53 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.18 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.24 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.27 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.51 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.31 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

14. Query Time: 1.84 ms After last query: 13.54 ms Query memory: 0.021 MB Memory before query: 3.325 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.12 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.17 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.06 ms
    init	0.10 ms
    Optimizing	0.08 ms
    Statistics	0.18 ms
    Preparing	0.11 ms
    Executing	0.03 ms
    Sending data	0.16 ms
    End of update loop	0.05 ms
    Query end	0.03 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.04 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.06 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

15. Query Time: 2.43 ms After last query: 44.07 ms Query memory: 0.035 MB Memory before query: 4.900 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_object 
      WHERE  ( id ='45' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_object	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.13 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.05 ms
    init	0.11 ms
    Optimizing	0.06 ms
    Statistics	1.00 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    11	JDatabaseDriver->loadObject()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:859
    10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:200
    9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:175
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

16. Query Time: 1.89 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 4.910 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_relations 
      WHERE  ( id ='45' )

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    starting	0.03 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.86 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.12 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.04 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

17. Query Time: 0.94 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 4.918 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_relations 
      WHERE  ( id ='2' )

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.04 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

18. Query Time: 0.26 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 4.924 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_relations 
      WHERE  ( id ='1' )

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

19. Query Time: 0.30 ms After last query: 0.13 ms Query memory: 0.035 MB Memory before query: 4.929 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_object 
      WHERE  ( id ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_object	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.03 ms
    checking permissions	0.03 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    11	JDatabaseDriver->loadObject()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:859
    10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:200
    9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:197
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

20. Query Time: 0.40 ms After last query: 9.42 ms Query memory: 0.035 MB Memory before query: 5.205 MB Rows returned: 101

    SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue 
      FROM cz27f_sobipro_config 
      WHERE  ( section  IN ( '0','1' ) )   
      ORDER BY section,  configsection

    Explain

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

    Profile

    Status	Duration
    Starting	0.10 ms
    Waiting for query cache lock	0.02 ms
    starting	0.03 ms
    Checking query cache for query	0.03 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    11	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    10	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/base/config.php:192
    9	SPConfig->addTable()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:158
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

21. Query Time: 0.32 ms After last query: 2.78 ms Query memory: 0.037 MB Memory before query: 5.405 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_field 
      WHERE  ( fid ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_field	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.05 ms
    Waiting for query cache lock	0.03 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.03 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:859
    11	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/models/field.php:387
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

22. Query Time: 0.29 ms After last query: 1.64 ms Query memory: 0.025 MB Memory before query: 5.456 MB Rows returned: 20
    Duplicate queries: #38  #49

    SELECT pid 
      FROM cz27f_sobipro_plugins 
      WHERE  ( enabled ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	20	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.05 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    15	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:388
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

23. Query Time: 0.29 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 5.467 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','bg-BG','button','category','chbxgroup','contact_field','email','image','inbox','info','mod_sobipro_categoryselect','mod_sobipro_entries','multiselect','notifications','paypal','profile_field','radio','select','textarea','url' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_task	index	pid	pid	756	NULL	12	Using where; Using index

    Profile

    Status	Duration
    Starting	0.05 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    15	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:388
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

24. Query Time: 0.25 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 5.474 MB Rows returned: 1
    Duplicate queries: #40  #51

    SELECT pid 
      FROM cz27f_sobipro_plugin_section 
      WHERE  ( section ='1' )  
      AND  ( enabled ='1' )  
      AND  ( pid  IN ( 'notifications' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_section	ref	PRIMARY	PRIMARY	156	const,const	1	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    15	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:71
    13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:388
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

25. Query Time: 0.40 ms After last query: 9.17 ms Query memory: 0.025 MB Memory before query: 5.735 MB Rows returned: 3

    SELECT sValue,sKey 
      FROM cz27f_sobipro_language 
      WHERE  ( fid ='1' )  
      AND  ( sKey  IN ( 'name','description','suffix' ) )  
      AND  ( oType ='field' )   
      ORDER BY FIELD( language,  'en-GB',  '%' ) ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_language	range	PRIMARY,sKey	sKey	452	NULL	393	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.09 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.04 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    14	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    13	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/models/field.php:512
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:408
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:392
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

26. Query Time: 4.13 ms After last query: 3.90 ms Query memory: 0.024 MB Memory before query: 5.755 MB Rows returned: 3

    SELECT id AS id, sKey AS label, sValue AS value, language 
      FROM cz27f_sobipro_language 
      WHERE  ( id ='1' )  
      AND  ( oType ='section' )  
      AND  ( sKey  IN ( 'name' ) )   
      ORDER BY FIELD( language,  'en-GB',  'en-GB' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_language	ref	PRIMARY,sKey	sKey	452	const	115	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.18 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.06 ms
    System lock	0.03 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.05 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.27 ms
    Preparing	0.07 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	2.54 ms
    End of update loop	0.04 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.06 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.56 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    10	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    9	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:707
    8	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:124
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

27. Query Time: 1.65 ms After last query: 12.02 ms Query memory: 0.026 MB Memory before query: 6.312 MB Rows returned: 0

    SELECT rel.gid 
      FROM  cz27f_sobipro_user_group AS grp 
      LEFT JOIN cz27f_sobipro_users_relation AS rel 
      ON grp.gid =  rel.gid 
      WHERE ( ( rel.validUntil > '2025-06-06 14:46:22' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
      AND ( rel.validSince < '2025-06-06 14:46:22' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
      AND grp.enabled = 1  )   
      AND  ( uid ='0' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rel	ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	grp	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.rel.gid	1	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.15 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.05 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.51 ms
    Preparing	0.08 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	1.10 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    18	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101
    16	SPJoomlaUser->spGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:43
    15	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    14	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    13	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    12	Sobi::My()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
    11	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/ctrl/controller.php:56
    10	SPController->setModel()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:446
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

28. Query Time: 0.51 ms After last query: 0.84 ms Query memory: 0.027 MB Memory before query: 6.345 MB Rows returned: 1

    SELECT count(id)
    
      FROM cz27f_usergroups

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_usergroups	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	9	Using index

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.03 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    21	JDatabaseDriver->loadResult()	JROOT/libraries/src/Helper/UserGroupsHelper.php:203
    20	Joomla\CMS\Helper\UserGroupsHelper->total()	JROOT/libraries/src/Helper/UserGroupsHelper.php:150
    19	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
    18	Joomla\CMS\Access\Access::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221
    17	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78
    16	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45
    15	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    14	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    13	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    12	Sobi::My()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
    11	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/ctrl/controller.php:56
    10	SPController->setModel()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:446
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

29. Query Time: 0.22 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 6.355 MB Rows returned: 9

    SELECT *
    
      FROM cz27f_usergroups
    
      ORDER BY lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_usergroups	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/UserGroupsHelper.php:259
    20	Joomla\CMS\Helper\UserGroupsHelper->loadAll()	JROOT/libraries/src/Helper/UserGroupsHelper.php:152
    19	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
    18	Joomla\CMS\Access\Access::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221
    17	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78
    16	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45
    15	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    14	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    13	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    12	Sobi::My()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
    11	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/ctrl/controller.php:56
    10	SPController->setModel()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:446
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

30. Query Time: 1.33 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 6.374 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_category 
      WHERE  ( id ='45' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_category	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.49 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    15	JDatabaseDriver->loadObject()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:859
    14	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/models/dbobject.php:835
    13	SPDBObject->loadTable()	JROOT/components/com_sobipro/lib/models/category.php:158
    12	SPCategory->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:779
    11	SPDBObject->extend()	JROOT/components/com_sobipro/lib/ctrl/controller.php:72
    10	SPController->extend()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:447
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

31. Query Time: 1.37 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 6.383 MB Rows returned: 1

    SELECT counter 
      FROM cz27f_sobipro_counter 
      WHERE  ( sid ='45' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_counter	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.58 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.09 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:807
    14	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/models/dbobject.php:837
    13	SPDBObject->loadTable()	JROOT/components/com_sobipro/lib/models/category.php:158
    12	SPCategory->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:779
    11	SPDBObject->extend()	JROOT/components/com_sobipro/lib/ctrl/controller.php:72
    10	SPController->extend()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:447
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

32. Query Time: 2.12 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 6.392 MB Rows returned: 6

    SELECT id AS id, sKey AS label, sValue AS value, language 
      FROM cz27f_sobipro_language 
      WHERE  ( id ='45' )  
      AND  ( sKey  IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )   
      ORDER BY FIELD( language,  'en-GB',  'en-GB' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_language	ALL	PRIMARY,sKey	NO INDEX KEY COULD BE USED	NULL	NULL	2639	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.61 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    Creating sort index	0.75 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    17	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    16	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:707
    15	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/models/dbobject.php:863
    14	SPDBObject->translate()	JROOT/components/com_sobipro/lib/models/dbobject.php:854
    13	SPDBObject->loadTable()	JROOT/components/com_sobipro/lib/models/category.php:158
    12	SPCategory->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:779
    11	SPDBObject->extend()	JROOT/components/com_sobipro/lib/ctrl/controller.php:72
    10	SPController->extend()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:447
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

33. Query Time: 0.77 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 6.406 MB Rows returned: 1

    SELECT position,pid 
      FROM cz27f_sobipro_relations 
      WHERE  ( id ='45' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_relations	ref	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.54 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:859
    13	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/models/category.php:164
    12	SPCategory->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:779
    11	SPDBObject->extend()	JROOT/components/com_sobipro/lib/ctrl/controller.php:72
    10	SPController->extend()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:447
    9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:267
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

34. Query Time: 0.36 ms After last query: 0.41 ms Query memory: 0.031 MB Memory before query: 6.422 MB Rows returned: 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cz27f_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_kunena','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_sobipro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:151
    14	SPUser->isAdmin()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:197
    13	SPJoomlaUser->authorisePermission()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

35. Query Time: 1.88 ms After last query: 0.66 ms Query memory: 0.026 MB Memory before query: 6.481 MB Rows returned: 1

    SELECT  DISTINCT sprl.rid 
      FROM  cz27f_sobipro_permissions_groups AS spgr 
      LEFT JOIN cz27f_sobipro_permissions_rules AS sprl 
      ON spgr.rid =  sprl.rid 
      WHERE ( ( sprl.validUntil > '2025-06-06 14:46:22' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
      AND ( sprl.validSince < '2025-06-06 14:46:22' OR sprl.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
      AND state = 1  )  
      AND spgr.gid in( 0 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	spgr	index	PRIMARY	PRIMARY	8	NULL	2	Using where; Using index; Using temporary
    1	SIMPLE	sprl	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.05 ms
    Creating tmp table	0.06 ms
    Executing	0.02 ms
    Sending data	0.88 ms
    Removing tmp table	0.03 ms
    Sending data	0.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.03 ms
    Storing result in query cache	0.04 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    16	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:182
    14	SPUser->getPermissions()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240
    13	SPJoomlaUser->authorisePermission()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

36. Query Time: 0.22 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 6.490 MB Rows returned: 3

    SELECT pid 
      FROM cz27f_sobipro_permissions_map 
      WHERE  ( sid ='1' )  
      AND  ( rid  IN ( '1' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_permissions_map	ref	PRIMARY	PRIMARY	8	const,const	3	Using index

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    16	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:190
    14	SPUser->getPermissions()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240
    13	SPJoomlaUser->authorisePermission()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

37. Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 6.498 MB Rows returned: 21

    SELECT * 
      FROM cz27f_sobipro_permissions 
      WHERE  ( site ='front' )  
      AND  ( published ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_permissions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    16	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    15	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:198
    14	SPUser->getPermissions()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240
    13	SPJoomlaUser->authorisePermission()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

38. Query Time: 0.23 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 6.528 MB Rows returned: 20
    Duplicate queries: #22  #49

    SELECT pid 
      FROM cz27f_sobipro_plugins 
      WHERE  ( enabled ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	20	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

39. Query Time: 0.22 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 6.540 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','category.view','category.*' ) )  
      AND  ( pid  IN ( 'bank_transfer','bg-BG','button','category','chbxgroup','contact_field','email','image','inbox','info','mod_sobipro_categoryselect','mod_sobipro_entries','multiselect','notifications','paypal','profile_field','radio','select','textarea','url' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_task	index	pid	pid	756	NULL	12	Using where; Using index

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

40. Query Time: 0.24 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 6.549 MB Rows returned: 1
    Duplicate queries: #24  #51

    SELECT pid 
      FROM cz27f_sobipro_plugin_section 
      WHERE  ( section ='1' )  
      AND  ( enabled ='1' )  
      AND  ( pid  IN ( 'notifications' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_section	ref	PRIMARY	PRIMARY	156	const,const	1	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:71
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182
    12	SPJoomlaUser->can()	JROOT/components/com_sobipro/lib/sobi.php:252
    11	Sobi::Can()	JROOT/components/com_sobipro/lib/ctrl/controller.php:345
    10	SPController->visible()	JROOT/components/com_sobipro/lib/ctrl/controller.php:186
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

41. Query Time: 5.36 ms After last query: 3.41 ms Query memory: 0.024 MB Memory before query: 6.595 MB Rows returned: 2

    SELECT  DISTINCT spo.id 
      FROM  cz27f_sobipro_relations AS sprl 
      LEFT JOIN cz27f_sobipro_object AS spo 
      ON sprl.id =  spo.id 
      WHERE  ( sprl.pid ='45' )  
      AND  ( spo.oType ='entry' )  
      AND  ( spo.state ='1' )  
      AND ( ( spo.validUntil > '2025-06-06 14:46:22' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
      AND ( spo.validSince < '2025-06-06 14:46:22' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   )   
      AND  ( sprl.copy ='0' )   
      ORDER BY updatedTime desc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	spo	ALL	PRIMARY,oType,state,validSince,validUntil	NO INDEX KEY COULD BE USED	NULL	NULL	314	Using where; Using temporary; Using filesort
    1	SIMPLE	sprl	eq_ref	PRIMARY	PRIMARY	8	biotrade_bio.spo.id,const	1	Using where; Distinct

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	1.68 ms
    Preparing	0.05 ms
    Creating tmp table	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	2.64 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    13	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    12	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/ctrl/section.php:410
    11	SPSectionCtrl->getEntries()	JROOT/components/com_sobipro/lib/ctrl/section.php:67
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

42. Query Time: 2.51 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 6.603 MB Rows returned: 2

    SELECT  DISTINCT spo.id 
      FROM  cz27f_sobipro_relations AS sprl 
      LEFT JOIN cz27f_sobipro_object AS spo 
      ON sprl.id =  spo.id 
      WHERE  ( sprl.pid ='45' )  
      AND  ( spo.oType ='entry' )  
      AND  ( spo.state ='1' )  
      AND ( ( spo.validUntil > '2025-06-06 14:46:22' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
      AND ( spo.validSince < '2025-06-06 14:46:22' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   )   
      AND  ( sprl.copy ='0' )   
      ORDER BY updatedTime desc 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	spo	index_merge	PRIMARY,oType,state,validSince,validUntil	state,oType	1,152	NULL	167	Using intersect(state,oType); Using where; Using temporary; Using filesort
    1	SIMPLE	sprl	eq_ref	PRIMARY	PRIMARY	8	biotrade_bio.spo.id,const	1	Using where; Distinct

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.09 ms
    Creating tmp table	0.05 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.80 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.53 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    13	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    12	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/ctrl/section.php:410
    11	SPSectionCtrl->getEntries()	JROOT/components/com_sobipro/lib/ctrl/section.php:68
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

43. Query Time: 2.37 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 6.612 MB Rows returned: 2

    SELECT sr.id, sr.oType,so.id,l.title AS language_title
    
      FROM cz27f_sobipro_relations AS sr
    
      LEFT JOIN `cz27f_sobipro_object` AS so 
      ON so.id = sr.id
    
      LEFT JOIN `cz27f_languages` AS l 
      ON l.lang_code = so.language
    
      WHERE sr.pid = 45 
      AND so.access IN (1,1,5) 
      AND so.language IN ('en-GB','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	so	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	314	Using where
    1	SIMPLE	sr	eq_ref	PRIMARY	PRIMARY	8	biotrade_bio.so.id,const	1
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.03 ms
    Checking query cache for query	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	1.02 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.54 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    14	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    13	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/models/dbobject.php:425
    12	SPDBObject->getChilds()	JROOT/components/com_sobipro/lib/ctrl/section.php:138
    11	SPSectionCtrl->getCats()	JROOT/components/com_sobipro/lib/ctrl/section.php:71
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

44. Query Time: 0.35 ms After last query: 12.06 ms Query memory: 0.036 MB Memory before query: 6.636 MB Rows returned: 0

    SELECT * 
      FROM cz27f_sobipro_field 
      WHERE  ( section ='1' )  
      AND  ( enabled ='1' )  
      AND  ( adminField ='-1' )   
      ORDER BY position

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_field	ALL	enabled,section	NO INDEX KEY COULD BE USED	NULL	NULL	65	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    12	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/models/category.php:260
    11	SPCategory->loadFields()	JROOT/components/com_sobipro/lib/ctrl/section.php:93
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

45. Query Time: 2.36 ms After last query: 28.85 ms Query memory: 0.008 MB Memory before query: 6.896 MB

    INSERT INTO cz27f_sobipro_errors 
      VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy91V9v2jAQAPDvkg+wYPIPzNOGOnWTqiGxRyRkEgPuEjuzzUpV9bvv7FAG4dKFreoLSoJz/vni8zFKUvok6GDCaEyfDPwEa1HyYAKXEQ3CXFW1klxa4y6XRq1ErVVYilW4YobDQ7kWmw/1tvav0KAU0r8NL8ckc1cjCLmTuRVKutsxDVYs/2E1y/3AhAZ5yYw5DJ3Ppj5kMHkWlGCstAeL73NeuxlxGUkwGRnSYMPtp766IaJL49d1eWXCe6Wqki3hr0rJxlsxIdeaVRz3ZiTCvB5087LUWyaLkuu2GiJJ5SKBOHo3cZKM8W8PCf5ieSWKtpNkbjVf/Ux3EPyzC+7V8bup8R0Lf+x02d+bYLv2b16ry9DwvGPPws4cYwklIGJF8W11/13NmN0+sMf+zhRzZj2cUPRWqxI2W0d5jbA0wphfgj9c+CLnmzdLn1qXaLBlmC3pY2OWb5R+xJOYYjBYMt/zfGcvKt6dCL7kD8v1tNE/f97mQUfBDAfX0WJPO6z2mLcxgoteyVu3CZYeJ9eRCJAg3kyro4egncVlC9KimRbchEbn4fSF9+fqlpd11w6LB8OOA1zznzuh+VLJywP89CgkaG/5b1iUoZ0lPSbtGKWNi2BMU6WL6d18cRy3aM3b6LHe4zvjuf5jXZcCSgIc4VxYfnLfUbrjuOOY0VwWXL8RH2tEb8EfRlijhNtCmJrZfHvBHp2xTyZYtCZs4Fgv8udSNxzi9kh7irfLQt3gxXYtHGtKZABwAZ91j9d/gu2F7vqPsk7SeQ5A9PwbPfFyZA==' );

    Explain

    EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_errors VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy91V9v2jAQAPDvkg+wYPIPzNOGOnWTqiGxRyRkEgPuEjuzzUpV9bvv7FAG4dKFreoLSoJz/vni8zFKUvok6GDCaEyfDPwEa1HyYAKXEQ3CXFW1klxa4y6XRq1ErVVYilW4YobDQ7kWmw/1tvav0KAU0r8NL8ckc1cjCLmTuRVKutsxDVYs/2E1y/3AhAZ5yYw5DJ3Ppj5kMHkWlGCstAeL73NeuxlxGUkwGRnSYMPtp766IaJL49d1eWXCe6Wqki3hr0rJxlsxIdeaVRz3ZiTCvB5087LUWyaLkuu2GiJJ5SKBOHo3cZKM8W8PCf5ieSWKtpNkbjVf/Ux3EPyzC+7V8bup8R0Lf+x02d+bYLv2b16ry9DwvGPPws4cYwklIGJF8W11/13NmN0+sMf+zhRzZj2cUPRWqxI2W0d5jbA0wphfgj9c+CLnmzdLn1qXaLBlmC3pY2OWb5R+xJOYYjBYMt/zfGcvKt6dCL7kD8v1tNE/f97mQUfBDAfX0WJPO6z2mLcxgoteyVu3CZYeJ9eRCJAg3kyro4egncVlC9KimRbchEbn4fSF9+fqlpd11w6LB8OOA1zznzuh+VLJywP89CgkaG/5b1iUoZ0lPSbtGKWNi2BMU6WL6d18cRy3aM3b6LHe4zvjuf5jXZcCSgIc4VxYfnLfUbrjuOOY0VwWXL8RH2tEb8EfRlijhNtCmJrZfHvBHp2xTyZYtCZs4Fgv8udSNxzi9kh7irfLQt3gxXYtHGtKZABwAZ91j9d/gu2F7vqPsk7SeQ5A9PwbPfFyZA==' );

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.04 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.04 ms
    Update	1.17 ms
    Waiting for query cache lock	0.04 ms
    Update	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.43 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:792
    17	SPJoomlaDb->query()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:956
    16	SPJoomlaDb->exec()	JROOT/components/com_sobipro/lib/base/exception.php:96
    15	SPException::storeError()	JROOT/components/com_sobipro/lib/base/exception.php:205
    14	SPExceptionHandler()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:713
    13	SPJoomlaMainFrame->getItemid()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:559
    12	SPJoomlaMainFrame::url()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:417
    11	SPJoomlaMainFrame->addObjToPathway()	JROOT/components/com_sobipro/lib/ctrl/section.php:99
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

46. Query Time: 1.07 ms After last query: 1.62 ms Query memory: 0.007 MB Memory before query: 6.893 MB

    INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) 
      VALUES ('45','1435','2025-06-06 14:46:22') 
      ON DUPLICATE KEY UPDATE sid = '45',counter = '1435',lastUpdate = '2025-06-06 14:46:22'

    Explain

    EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('45','1435','2025-06-06 14:46:22') ON DUPLICATE KEY UPDATE sid = '45',counter = '1435',lastUpdate = '2025-06-06 14:46:22'

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.04 ms
    Update	0.10 ms
    Waiting for query cache lock	0.03 ms
    Update	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.39 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:795
    14	Sobi\Database\MySQLi->query()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:959
    13	Sobi\Database\MySQLi->exec()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:760
    12	Sobi\Database\MySQLi->insertUpdate()	JROOT/components/com_sobipro/lib/models/dbobject.php:630
    11	SPDBObject->countVisit()	JROOT/components/com_sobipro/lib/ctrl/section.php:101
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

47. Query Time: 1.93 ms After last query: 29.94 ms Query memory: 0.009 MB Memory before query: 7.288 MB

    INSERT INTO cz27f_sobipro_errors 
      VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy9lltv2jAUx79LPsCCc8c8bahTN6lSJbQ9ISETDHXr2JljNqqq333HDqVcTmjYur0gJ9jn/Pw/tzBKCvok6GDEaEKfGvgJlkLyYATLmAZhqataK65s45azRs9FbXQoxTycs4bDS7UUqw/1Xe2P0EAK5U/D4YTkblWAybUqrdDKPQ5pMGflgzWs9BtTGpSSNc126+R27E0Go2dBCYaV9cDim5LXziNORlKMjEQ0WHH7qS9dhNBlyXm6smrCe60ryWbwV6VVy1sxoZaGVRznzUmM8Xqgq5erXjO1kNwcU4MlpZ0lII7/G3GaDvHYg8BfLK/E4piT5O42X72nGzD+2Rn31AlCHb+RBW6NkEGEkwwBA+K1kf2RUiwx0/NIPwX/1YQNL7vzMk4jHO7bKRycnIB1j5P9G5w0wtIO9rizJ2LFTqxJa++73wBkOUb2VsZZI8+DkQjTCaK1EE0t2WM/tgJjy3uwQdOzRksotg68AmsvfXQbWxdoYBv+QURbNmb5SptHPPkzDAyuzDe8XNuTjuc6om952+u2TRkdFr1i2r7oSrbBZWyJZ9tedyccwWZGfEa5bijXLNLLmEhblLdGvwJhY8LLBboYZgSHKjRlOH7Be11dc1l35VgywErABczwH2th+Eyr0xG2PwwINg3+HizO0dma7UTbWTmGcz29bbbT8c1kuts3PfLb0mNTwX8bHNJ/rGspoCiAI5wIy/eeO4p3mGD8qRNWLbh5J3x0grwDfhRjPbtoWyOz5d0JdnGAvedgeuSwBe+cNd3gYLeH7Nhchg+Ghb7Ci+1ScGwUkQGACwjrBq//FMuF7vqP806kQw2A6Pk3m5XDTA==' );

    Explain

    EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_errors VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy9lltv2jAUx79LPsCCc8c8bahTN6lSJbQ9ISETDHXr2JljNqqq333HDqVcTmjYur0gJ9jn/Pw/tzBKCvok6GDEaEKfGvgJlkLyYATLmAZhqataK65s45azRs9FbXQoxTycs4bDS7UUqw/1Xe2P0EAK5U/D4YTkblWAybUqrdDKPQ5pMGflgzWs9BtTGpSSNc126+R27E0Go2dBCYaV9cDim5LXziNORlKMjEQ0WHH7qS9dhNBlyXm6smrCe60ryWbwV6VVy1sxoZaGVRznzUmM8Xqgq5erXjO1kNwcU4MlpZ0lII7/G3GaDvHYg8BfLK/E4piT5O42X72nGzD+2Rn31AlCHb+RBW6NkEGEkwwBA+K1kf2RUiwx0/NIPwX/1YQNL7vzMk4jHO7bKRycnIB1j5P9G5w0wtIO9rizJ2LFTqxJa++73wBkOUb2VsZZI8+DkQjTCaK1EE0t2WM/tgJjy3uwQdOzRksotg68AmsvfXQbWxdoYBv+QURbNmb5SptHPPkzDAyuzDe8XNuTjuc6om952+u2TRkdFr1i2r7oSrbBZWyJZ9tedyccwWZGfEa5bijXLNLLmEhblLdGvwJhY8LLBboYZgSHKjRlOH7Be11dc1l35VgywErABczwH2th+Eyr0xG2PwwINg3+HizO0dma7UTbWTmGcz29bbbT8c1kuts3PfLb0mNTwX8bHNJ/rGspoCiAI5wIy/eeO4p3mGD8qRNWLbh5J3x0grwDfhRjPbtoWyOz5d0JdnGAvedgeuSwBe+cNd3gYLeH7Nhchg+Ghb7Ci+1ScGwUkQGACwjrBq//FMuF7vqP806kQw2A6Pk3m5XDTA==' );

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.04 ms
    Update	0.12 ms
    Waiting for query cache lock	0.03 ms
    Update	0.02 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.50 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:792
    19	SPJoomlaDb->query()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:956
    18	SPJoomlaDb->exec()	JROOT/components/com_sobipro/lib/base/exception.php:96
    17	SPException::storeError()	JROOT/components/com_sobipro/lib/base/exception.php:205
    16	SPExceptionHandler()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:713
    15	SPJoomlaMainFrame->getItemid()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:559
    14	SPJoomlaMainFrame::url()	JROOT/components/com_sobipro/lib/sobi.php:46
    13	Sobi::Url()	JROOT/components/com_sobipro/lib/views/section.php:352
    12	SPSectionView->view()	JROOT/components/com_sobipro/lib/views/section.php:523
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

48. Query Time: 1.17 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 7.289 MB Rows returned: 2

    SELECT counter,sid 
      FROM cz27f_sobipro_counter 
      WHERE  ( sid  IN ( '423','320' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_counter	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.03 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.35 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    15	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
    14	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/views/view.php:779
    13	SPFrontView->loadNonStaticData()	JROOT/components/com_sobipro/lib/views/section.php:433
    12	SPSectionView->view()	JROOT/components/com_sobipro/lib/views/section.php:523
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

49. Query Time: 0.34 ms After last query: 22.36 ms Query memory: 0.027 MB Memory before query: 8.543 MB Rows returned: 20
    Duplicate queries: #22  #38

    SELECT pid 
      FROM cz27f_sobipro_plugins 
      WHERE  ( enabled ='1' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	20	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    18	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/views/section.php:324
    13	SPSectionView->entry()	JROOT/components/com_sobipro/lib/views/section.php:436
    12	SPSectionView->view()	JROOT/components/com_sobipro/lib/views/section.php:523
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

50. Query Time: 0.25 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 8.555 MB Rows returned: 1

    SELECT pid 
      FROM cz27f_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','list.custom','list.*' ) )  
      AND  ( pid  IN ( 'bank_transfer','bg-BG','button','category','chbxgroup','contact_field','email','image','inbox','info','mod_sobipro_categoryselect','mod_sobipro_entries','multiselect','notifications','paypal','profile_field','radio','select','textarea','url' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_task	index	pid	pid	756	NULL	12	Using where; Using index

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    18	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/views/section.php:324
    13	SPSectionView->entry()	JROOT/components/com_sobipro/lib/views/section.php:436
    12	SPSectionView->view()	JROOT/components/com_sobipro/lib/views/section.php:523
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

51. Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 8.564 MB Rows returned: 1
    Duplicate queries: #24  #40

    SELECT pid 
      FROM cz27f_sobipro_plugin_section 
      WHERE  ( section ='1' )  
      AND  ( enabled ='1' )  
      AND  ( pid  IN ( 'notifications' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_sobipro_plugin_section	ref	PRIMARY	PRIMARY	156	const,const	1	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    18	JDatabaseDriver->loadColumn()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:71
    16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/views/section.php:324
    13	SPSectionView->entry()	JROOT/components/com_sobipro/lib/views/section.php:436
    12	SPSectionView->view()	JROOT/components/com_sobipro/lib/views/section.php:523
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

52. Query Time: 0.30 ms After last query: 7.87 ms Query memory: 0.028 MB Memory before query: 8.740 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_registry 
      WHERE  ( section ='messages' )   
      ORDER BY value

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.03 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    17	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/base/registry.php:140
    16	SPRegistry->loadDBSection()	JROOT/components/com_sobipro/lib/base/message.php:40
    15	SPMessage->__construct()	JROOT/components/com_sobipro/lib/base/message.php:185
    14	SPMessage::getInstance()	JROOT/components/com_sobipro/lib/base/factory.php:165
    13	SPFactory::message()	JROOT/components/com_sobipro/lib/views/view.php:287
    12	SPFrontView->display()	JROOT/components/com_sobipro/lib/views/section.php:526
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

53. Query Time: 0.21 ms After last query: 0.39 ms Query memory: 0.028 MB Memory before query: 8.847 MB Rows returned: 1

    SELECT * 
      FROM cz27f_sobipro_registry 
      WHERE  ( section ='reports' )   
      ORDER BY value

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    17	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/base/registry.php:140
    16	SPRegistry->loadDBSection()	JROOT/components/com_sobipro/lib/base/message.php:50
    15	SPMessage->__construct()	JROOT/components/com_sobipro/lib/base/message.php:185
    14	SPMessage::getInstance()	JROOT/components/com_sobipro/lib/base/factory.php:165
    13	SPFactory::message()	JROOT/components/com_sobipro/lib/views/view.php:287
    12	SPFrontView->display()	JROOT/components/com_sobipro/lib/views/section.php:526
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

54. Query Time: 1.46 ms After last query: 31.98 ms Query memory: 0.010 MB Memory before query: 9.077 MB

    INSERT INTO cz27f_sobipro_errors 
      VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy9lt1umzAUgN+FBxgBAiT0astaddMqVUo39SJS5DhO683YzHa6VFXffccmfw0HSrVqN8iAfc53/k2KOCqeeDE4I8WweDLwCFZcsOAMlkkRhFSVlZJMWuOWc6MWvNIqFHwRLohh8FGu+N2H6r7yR4pAcOlPw+FhlLvVCESuJbVcSfc6LoIFob+sJtRvTIuACmLMduv0euJFBmfPvIgwrKwHFttQVjmNOFmUYmRRXAR3zH7qSxcjdNmwm46WJvypVCnIHH6VSta8JeFypUnJcN48SjBeD3S+M/WSyKVg+pQaJEnlJAFx8t+I03SMxx4c/MWyki9POaPcWfPVa7oC4RdOuKceItTJK1ng1ggZRHiYIWBAvNaiP1KKJeaoG+meiYppE4L1lSC2xXFxNMD5vjf54OQUFHiiDCPahf6FkqOvvbTktZZrrbyiHFM07ja9FGpv9nxjhG0pyyTF0hw2QT1Ks1K6vFGfFW3ECc7eTr/dACJlxijtQUcYaNwN+sDZH+OfOGGCtjTw0JIbsO6xQeZCdH2zNd0xerQxhpb2QTOMtre1NMZyu4MucnQXWkn7A6TXLRcdBa/1CKtFN1oUx29DSxzatBZ5gEMHQt4DDuaU1UpAf2zhG2GBhT0PXncH3MS6knFw2Dx4Lao1HOTGndKPeMPKWlKObRhd28aUclPMj6mtvTUb1vn7RbX+0JZwWLPqYPPlMNmae/Ac2uE7PNcO5Ro81kQ6mKJ9fzsAof3duQv8oonmDCpR03CywzusLn2Xb7kQDbAicAHT7PeaazZXsnntOB7gEdrm/xksydH7ULZ32l7KKZybw/WAnE2uprP9vtmJ3poenR1Zg/5jVQkORQEc4ZRbdvTeUr3jIcafOsfKJdPvhI9OlHfAjxPsejeqmyOx9L6BPXqBfaRgdqKwBm+dN+3gILeH27F5A3eBpTrHi+2N4DE2jKIBgHMI6wav/xTLhfb6T/JWpJc+AKLnvy61T50=' );

    Explain

    EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_errors VALUES ( NULL, '2025-06-06 14:46:22', '2', '0', 'count(): Parameter must be an array or an object that implements Countable', '/home/biotrade/public_html/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php', '713', 'PHP', '0', '216.73.216.18', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45/view,rss', 'Stack to large - skipping', 'eJy9lt1umzAUgN+FBxgBAiT0astaddMqVUo39SJS5DhO683YzHa6VFXffccmfw0HSrVqN8iAfc53/k2KOCqeeDE4I8WweDLwCFZcsOAMlkkRhFSVlZJMWuOWc6MWvNIqFHwRLohh8FGu+N2H6r7yR4pAcOlPw+FhlLvVCESuJbVcSfc6LoIFob+sJtRvTIuACmLMduv0euJFBmfPvIgwrKwHFttQVjmNOFmUYmRRXAR3zH7qSxcjdNmwm46WJvypVCnIHH6VSta8JeFypUnJcN48SjBeD3S+M/WSyKVg+pQaJEnlJAFx8t+I03SMxx4c/MWyki9POaPcWfPVa7oC4RdOuKceItTJK1ng1ggZRHiYIWBAvNaiP1KKJeaoG+meiYppE4L1lSC2xXFxNMD5vjf54OQUFHiiDCPahf6FkqOvvbTktZZrrbyiHFM07ja9FGpv9nxjhG0pyyTF0hw2QT1Ks1K6vFGfFW3ECc7eTr/dACJlxijtQUcYaNwN+sDZH+OfOGGCtjTw0JIbsO6xQeZCdH2zNd0xerQxhpb2QTOMtre1NMZyu4MucnQXWkn7A6TXLRcdBa/1CKtFN1oUx29DSxzatBZ5gEMHQt4DDuaU1UpAf2zhG2GBhT0PXncH3MS6knFw2Dx4Lao1HOTGndKPeMPKWlKObRhd28aUclPMj6mtvTUb1vn7RbX+0JZwWLPqYPPlMNmae/Ac2uE7PNcO5Ro81kQ6mKJ9fzsAof3duQv8oonmDCpR03CywzusLn2Xb7kQDbAicAHT7PeaazZXsnntOB7gEdrm/xksydH7ULZ32l7KKZybw/WAnE2uprP9vtmJ3poenR1Zg/5jVQkORQEc4ZRbdvTeUr3jIcafOsfKJdPvhI9OlHfAjxPsejeqmyOx9L6BPXqBfaRgdqKwBm+dN+3gILeH27F5A3eBpTrHi+2N4DE2jKIBgHMI6wav/xTLhfb6T/JWpJc+AKLnvy61T50=' );

    Profile

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.04 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.05 ms
    Update	0.17 ms
    Waiting for query cache lock	0.04 ms
    Update	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.48 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:792
    22	SPJoomlaDb->query()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:956
    21	SPJoomlaDb->exec()	JROOT/components/com_sobipro/lib/base/exception.php:96
    20	SPException::storeError()	JROOT/components/com_sobipro/lib/base/exception.php:205
    19	SPExceptionHandler()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:713
    18	SPJoomlaMainFrame->getItemid()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:559
    17	SPJoomlaMainFrame::url()	JROOT/components/com_sobipro/lib/sobi.php:46
    16	Sobi::Url()	JROOT/components/com_sobipro/lib/helpers/template.php:210
    15	SobiPro::Url()	Same as call in the line below.
    14	XSLTProcessor->transformToDoc()	JROOT/components/com_sobipro/lib/mlo/template_xslt.php:135
    13	SPTemplateXSLT->display()	JROOT/components/com_sobipro/lib/views/view.php:317
    12	SPFrontView->display()	JROOT/components/com_sobipro/lib/views/section.php:526
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

55. Query Time: 1.86 ms After last query: 0.89 ms Query memory: 0.030 MB Memory before query: 9.071 MB Rows returned: 1

    SELECT * 
      FROM cz27f_users 
      WHERE  ( id  IN ( '1408' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_users	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.04 ms
    System lock	0.03 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.04 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.45 ms
    Preparing	0.03 ms
    Unlocking tables	0.03 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.04 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.37 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    17	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:368
    16	SPJoomlaUser::getBaseData()	JROOT/components/com_sobipro/lib/helpers/template.php:317
    15	SobiPro::User()	Same as call in the line below.
    14	XSLTProcessor->transformToDoc()	JROOT/components/com_sobipro/lib/mlo/template_xslt.php:135
    13	SPTemplateXSLT->display()	JROOT/components/com_sobipro/lib/views/view.php:317
    12	SPFrontView->display()	JROOT/components/com_sobipro/lib/views/section.php:526
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

56. Query Time: 1.02 ms After last query: 0.41 ms Query memory: 0.030 MB Memory before query: 9.084 MB Rows returned: 1

    SELECT * 
      FROM cz27f_users 
      WHERE  ( id  IN ( '1017' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_users	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.04 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.03 ms
    Storing result in query cache	0.47 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:885
    17	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:368
    16	SPJoomlaUser::getBaseData()	JROOT/components/com_sobipro/lib/helpers/template.php:317
    15	SobiPro::User()	Same as call in the line below.
    14	XSLTProcessor->transformToDoc()	JROOT/components/com_sobipro/lib/mlo/template_xslt.php:135
    13	SPTemplateXSLT->display()	JROOT/components/com_sobipro/lib/views/view.php:317
    12	SPFrontView->display()	JROOT/components/com_sobipro/lib/views/section.php:526
    11	SPSectionView->display()	JROOT/components/com_sobipro/lib/ctrl/section.php:122
    10	SPSectionCtrl->view()	JROOT/components/com_sobipro/lib/ctrl/controller.php:187
    9	SPController->execute()	JROOT/components/com_sobipro/lib/ctrl/category.php:67
    8	SPCategoryCtrl->execute()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:520
    7	SobiProCtrl->execute()	JROOT/components/com_sobipro/sobipro.php:45
    6	require_once JROOT/components/com_sobipro/sobipro.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

57. Query Time: 0.26 ms After last query: 2.46 ms Query memory: 0.023 MB Memory before query: 9.011 MB Rows returned: 1

    SELECT template 
      FROM cz27f_template_styles 
      WHERE client_id = 1 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cz27f_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.03 ms
    Sending cached result to clien	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    9	JDatabaseDriver->loadResult()	JROOT/templates/theme1946/includes/includes.php:21
    8	include_once JROOT/templates/theme1946/includes/includes.php	JROOT/templates/theme1946/component.php:11
    7	require JROOT/templates/theme1946/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---

58. Query Time: 2.32 ms After last query: 0.58 ms Query memory: 0.029 MB Memory before query: 9.054 MB Rows returned: 13

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cz27f_modules AS m
    
      LEFT JOIN cz27f_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cz27f_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 <= '2025-06-06 14:46:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-06 14:46:22') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 325 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	58	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	biotrade_bio.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	biotrade_bio.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    Checking query cache for query	0.13 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    Waiting for query cache lock	0.05 ms
    init	0.11 ms
    Optimizing	0.09 ms
    Statistics	0.21 ms
    Preparing	0.13 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.79 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.07 ms
    Starting cleanup	0.03 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.03 ms
    Updating status	0.02 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme1946/includes/includes.php:80
    8	include_once JROOT/templates/theme1946/includes/includes.php	JROOT/templates/theme1946/component.php:11
    7	require JROOT/templates/theme1946/component.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

    ---