Bio Trade

Organic Exchange Directory

We offer an efficient, certified, non-toxic, environmentally friendly and cost effective range of cleaning products, manufactured from all natural ingredients.

Bio Glanz is Bulgarian manufacturer of organic detergents and biodegradable cleaning products from plants for industrial and domestic use. The company offers environmentally friendly and 100% harmless to humans and animals detergents.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1749102998,
                "last": 1749102998,
                "now": 1749102998
            },
            "client": {
                "forwarded": "10.1.151.213"
            },
            "token": "x2wStdNAEiAmT9THiq69EcqVM1gCBYzf"
        },
        "registry": {
            "com_sobipro": {
                "back_url": "\/en\/producers\/45-bio-cleaning-detergents",
                "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"
        }
    }
}

Profile Information

Time

Memory

Time: 15.48 ms / 15.48 ms Memory: 0.561 MB / 0.93 MB Application: afterLoad

Time: 55.98 ms / 71.45 ms Memory: 2.226 MB / 3.16 MB Application: afterInitialise

Time: 4.79 ms / 76.25 ms Memory: 0.159 MB / 3.32 MB Application: afterRoute

Time: 2.22 ms / 78.46 ms Memory: 0.025 MB / 3.34 MB Application: beforeRenderComponent com_sobipro

Time: 54.07 ms / 132.53 ms Memory: 3.070 MB / 6.42 MB Application: Before Access::preloadComponents (all components)

Time: 0.45 ms / 132.99 ms Memory: 0.061 MB / 6.48 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 133.02 ms Memory: 0.000 MB / 6.47 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.37 ms / 133.39 ms Memory: 0.009 MB / 6.48 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 165.87 ms / 299.26 ms Memory: 2.589 MB / 9.07 MB Application: afterRenderComponent com_sobipro

Time: 1.26 ms / 300.52 ms Memory: 0.010 MB / 9.08 MB Application: afterDispatch

Time: 7.84 ms / 308.36 ms Memory: 0.093 MB / 9.18 MB Application: beforeRenderModule mod_login (Login form)

Time: 2.62 ms / 310.98 ms Memory: 0.037 MB / 9.21 MB Application: afterRenderModule mod_login (Login form)

Time: 0.06 ms / 311.04 ms Memory: 0.000 MB / 9.21 MB Application: beforeRenderModule mod_custom (Interreg (EN))

Time: 0.40 ms / 311.43 ms Memory: 0.005 MB / 9.22 MB Application: afterRenderModule mod_custom (Interreg (EN))

Time: 0.06 ms / 311.49 ms Memory: 0.000 MB / 9.22 MB Application: beforeRenderModule mod_custom (Google Analytics)

Time: 0.19 ms / 311.68 ms Memory: 0.003 MB / 9.22 MB Application: afterRenderModule mod_custom (Google Analytics)

Time: 0.03 ms / 311.71 ms Memory: 0.000 MB / 9.22 MB Application: beforeRenderModule mod_menu (Footer Logo)

Time: 1.16 ms / 312.87 ms Memory: 0.015 MB / 9.24 MB Application: afterRenderModule mod_menu (Footer Logo)

Time: 0.04 ms / 312.91 ms Memory: 0.000 MB / 9.23 MB Application: beforeRenderModule mod_articles_single (Contact Us (EN))

Time: 0.99 ms / 313.90 ms Memory: 0.102 MB / 9.33 MB Application: Before Access::preloadPermissions (com_content)

Time: 0.67 ms / 314.57 ms Memory: 0.178 MB / 9.51 MB Application: After Access::preloadPermissions (com_content)

Time: 0.03 ms / 314.60 ms Memory: 0.000 MB / 9.50 MB Application: Before Access::getAssetRules (id:193 name:com_content.article.83)

Time: 0.06 ms / 314.66 ms Memory: 0.007 MB / 9.51 MB Application: After Access::getAssetRules (id:193 name:com_content.article.83)

Time: 10.58 ms / 325.24 ms Memory: 0.225 MB / 9.73 MB Application: afterRenderModule mod_articles_single (Contact Us (EN))

Time: 0.04 ms / 325.28 ms Memory: 0.000 MB / 9.72 MB Application: beforeRenderModule mod_menu (Social media)

Time: 0.66 ms / 325.94 ms Memory: 0.010 MB / 9.73 MB Application: afterRenderModule mod_menu (Social media)

Time: 0.06 ms / 326.00 ms Memory: 0.000 MB / 9.72 MB Application: beforeRenderModule mod_spfilter (Quick Jump)

Time: 1.16 ms / 327.16 ms Memory: 0.038 MB / 9.76 MB Application: afterRenderModule mod_spfilter (Quick Jump)

Time: 0.06 ms / 327.23 ms Memory: 0.000 MB / 9.74 MB Application: beforeRenderModule mod_custom (Create your page(Producers) - (EN))

Time: 0.20 ms / 327.43 ms Memory: 0.003 MB / 9.74 MB Application: afterRenderModule mod_custom (Create your page(Producers) - (EN))

Time: 0.06 ms / 327.49 ms Memory: 0.001 MB / 9.75 MB Application: beforeRenderModule mod_superfish_menu (Superfish menu)

Time: 4.24 ms / 331.73 ms Memory: 0.142 MB / 9.89 MB Application: afterRenderModule mod_superfish_menu (Superfish menu)

Time: 0.07 ms / 331.79 ms Memory: 0.000 MB / 9.89 MB Application: beforeRenderModule mod_sclogin (Login)

Time: 2.12 ms / 333.91 ms Memory: 0.060 MB / 9.95 MB Application: afterRenderModule mod_sclogin (Login)

Time: 0.04 ms / 333.95 ms Memory: 0.000 MB / 9.94 MB Application: beforeRenderModule mod_languages (Language switcher)

Time: 2.27 ms / 336.23 ms Memory: 0.095 MB / 10.03 MB Application: afterRenderModule mod_languages (Language switcher)

Time: 2.98 ms / 339.21 ms Memory: 0.073 MB / 10.11 MB Application: afterRender

Database queries total: 78.77 ms

Memory Usage

Database Queries

74 Queries Logged 78.77 ms

13 duplicate found!

3 duplicates: #22 #38 #55

3 duplicates: #24 #40 #57

3 duplicates: #41 #45 #49

2 duplicates: #42 #46

2 duplicates: #43 #47

Query Time: 1.38 ms Query memory: 0.025 MB Memory before query: 1.205 MB Rows returned: 0

SELECT `data`

  FROM `cz27f_session`

  WHERE `session_id` = '467ec0d09fe5a7df29803664257a308b'

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.07 ms
Waiting for query cache lock	0.03 ms
starting	0.02 ms
Checking query cache for query	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.56 ms
Preparing	0.05 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.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
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.]

Query Time: 0.70 ms After last query: 0.68 ms Query memory: 0.022 MB Memory before query: 1.283 MB Rows returned: 0

SELECT `session_id`

  FROM `cz27f_session`

  WHERE `session_id` = '467ec0d09fe5a7df29803664257a308b' 
  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.02 ms
starting	0.02 ms
Checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 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.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.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.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.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.]

Query Time: 2.85 ms After last query: 0.10 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 
('467ec0d09fe5a7df29803664257a308b', 1, 1749102998, 0, '', 0)

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init for update	0.03 ms
Update	1.82 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.52 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
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.]

Query Time: 2.93 ms After last query: 1.19 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.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.03 ms
Optimizing	0.04 ms
Statistics	0.25 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	1.69 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.24 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: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.]

Query Time: 0.22 ms After last query: 1.16 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.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
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.]

Query Time: 0.21 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 1.371 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.02 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.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.]

Query Time: 2.51 ms After last query: 0.25 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.02 ms
starting	0.02 ms
Checking query cache for query	0.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	1.15 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.51 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.]

Query Time: 1.13 ms After last query: 5.11 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.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.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.41 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 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.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.13 ms
Reset for next command	0.02 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.]

Query Time: 1.34 ms After last query: 0.21 ms Query memory: 0.006 MB Memory before query: 1.893 MB

UPDATE `cz27f_extensions`

  SET `params` = '{\"mediaversion\":\"f2ba36866e389d3a4492ecbf2e635d3e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

Status	Duration
Starting	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
init for update	0.09 ms
Updating	0.24 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.16 ms
Query end	0.02 ms
Commit	0.39 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.03 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
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.]

Query Time: 0.85 ms After last query: 1.77 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.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.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 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.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.05 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/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.]

Query Time: 0.29 ms After last query: 2.24 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.04 ms
Waiting for query cache lock	0.03 ms
starting	0.03 ms
Checking query cache for query	0.03 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
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.]

Query Time: 1.03 ms After last query: 0.13 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.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.08 ms
Executing	0.03 ms
Sending data	0.09 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.03 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.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.05 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.]

Query Time: 6.01 ms After last query: 9.22 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.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.12 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.03 ms
table lock	0.03 ms
Waiting for query cache lock	0.05 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.30 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	2.87 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.15 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.27 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.45 ms
Waiting for query cache lock	0.03 ms
Creating sort index	0.36 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.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.03 ms
Updating status	0.03 ms
Storing result in query cache	0.03 ms
Reset for next command	0.03 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.]

Query Time: 1.47 ms After last query: 7.75 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.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.11 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.05 ms
init	0.07 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.09 ms
Executing	0.03 ms
Sending data	0.31 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 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.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.27 ms
Reset for next command	0.03 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.]

Query Time: 2.00 ms After last query: 16.24 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.09 ms
Waiting for query cache lock	0.03 ms
starting	0.03 ms
Checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.81 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 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.02 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Waiting for query cache lock	0.03 ms
Updating status	0.06 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.03 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.]

Query Time: 4.78 ms After last query: 0.09 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.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.06 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.04 ms
Optimizing	0.03 ms
Statistics	1.56 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	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.20 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.04 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.]

Query Time: 0.19 ms After last query: 0.09 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.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.03 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.]

Query Time: 0.21 ms After last query: 0.07 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.03 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.]

Query Time: 0.24 ms After last query: 0.07 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.03 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
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.]

Query Time: 0.30 ms After last query: 2.79 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.03 ms
Waiting for query cache lock	0.03 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
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.]

Query Time: 1.72 ms After last query: 1.80 ms Query memory: 0.037 MB Memory before query: 5.404 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.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.05 ms
Updating status	0.03 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.]

Query Time: 0.92 ms After last query: 0.66 ms Query memory: 0.025 MB Memory before query: 5.456 MB Rows returned: 20

Duplicate queries: #38 #55

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.05 ms
checking privileges on cached	0.03 ms
checking permissions	0.05 ms
Sending cached result to clien	0.04 ms
Updating status	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: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.]

Query Time: 0.23 ms After last query: 0.14 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.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.03 ms
Updating status	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: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.]

Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 5.474 MB Rows returned: 1

Duplicate queries: #40 #57

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

Query Time: 0.25 ms After last query: 3.72 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.04 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.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
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.]

Query Time: 0.27 ms After last query: 2.24 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.03 ms
Waiting for query cache lock	0.02 ms
starting	0.04 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.03 ms
Reset for next command	0.02 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.]

Query Time: 2.68 ms After last query: 4.72 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-05 05:56:38' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( rel.validSince < '2025-06-05 05:56:38' 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.04 ms
Waiting for query cache lock	0.02 ms
starting	0.03 ms
Checking query cache for query	0.17 ms
checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.04 ms
Waiting for query cache lock	0.05 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	0.96 ms
Preparing	0.08 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.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.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
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.]

Query Time: 0.25 ms After last query: 0.53 ms Query memory: 0.027 MB Memory before query: 6.344 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.04 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: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.]

Query Time: 0.22 ms After last query: 0.08 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.]

Query Time: 1.48 ms After last query: 0.29 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.03 ms
Waiting for query cache lock	0.08 ms
starting	0.02 ms
Checking query cache for query	0.05 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.05 ms
Optimizing	0.04 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.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.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.02 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.]

Query Time: 1.11 ms After last query: 0.08 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.03 ms
starting	0.02 ms
Checking query cache for query	0.04 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.42 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.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.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Storing result in query cache	0.32 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.]

Query Time: 2.56 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 6.391 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.02 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.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.63 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.94 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.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
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.]

Query Time: 0.73 ms After last query: 0.13 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.02 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.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.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.02 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.]

Query Time: 0.21 ms After last query: 0.35 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.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
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.]

Query Time: 1.68 ms After last query: 0.61 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-05 05:56:38' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( sprl.validSince < '2025-06-05 05:56:38' 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.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.04 ms
Creating tmp table	0.08 ms
Executing	0.02 ms
Sending data	0.72 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.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.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
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.]

Query Time: 0.19 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 6.489 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.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
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.]

Query Time: 0.19 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.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
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.]

Query Time: 0.19 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 6.527 MB Rows returned: 20

Duplicate queries: #22 #55

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

Query Time: 0.19 ms After last query: 0.11 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.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.03 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.]

Query Time: 0.18 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 6.548 MB Rows returned: 1

Duplicate queries: #24 #57

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

Query Time: 3.79 ms After last query: 1.18 ms Query memory: 0.025 MB Memory before query: 6.597 MB Rows returned: 2

Duplicate queries: #45 #49

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.02 ms
Checking query cache for query	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.05 ms
System lock	0.03 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	2.92 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.03 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
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:312
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.]

Query Time: 1.29 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 6.610 MB Rows returned: 0

Duplicate queries: #46

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 = 320 
  AND sr.oType = 'category' 
  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	sr	ref	PRIMARY,oType	oType	152	const	132	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	Using where
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.02 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.05 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.41 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.07 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.03 ms
Updating status	0.02 ms
Storing result in query cache	0.32 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/models/dbobject.php:529
13	SPDBObject->rGetChilds()	JROOT/components/com_sobipro/lib/models/dbobject.php:433
12	SPDBObject->getChilds()	JROOT/components/com_sobipro/lib/ctrl/section.php:312
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.]

Query Time: 1.10 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 6.617 MB Rows returned: 0

Duplicate queries: #47

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 = 423 
  AND sr.oType = 'category' 
  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	sr	ref	PRIMARY,oType	oType	152	const	132	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	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.06 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.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.07 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.03 ms
Freeing items	0.03 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.05 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/models/dbobject.php:529
13	SPDBObject->rGetChilds()	JROOT/components/com_sobipro/lib/models/dbobject.php:433
12	SPDBObject->getChilds()	JROOT/components/com_sobipro/lib/ctrl/section.php:312
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.]

Query Time: 3.15 ms After last query: 5.98 ms Query memory: 0.024 MB Memory before query: 6.618 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  IN ( '45' ) )  
  AND  ( spo.oType ='entry' )  
  AND  ( spo.state ='1' )  
  AND ( ( spo.validUntil > '2025-06-05 05:56:38' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( spo.validSince < '2025-06-05 05:56:38' 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.04 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.10 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.06 ms
Optimizing	0.05 ms
Statistics	1.36 ms
Preparing	0.07 ms
Creating tmp table	0.05 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.43 ms
Creating sort index	0.05 ms
Removing tmp table	0.03 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.40 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.]

Query Time: 0.21 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 6.628 MB Rows returned: 2

Duplicate queries: #41 #49

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

Query Time: 0.22 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 6.640 MB Rows returned: 0

Duplicate queries: #42

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 = 320 
  AND sr.oType = 'category' 
  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	sr	ref	PRIMARY,oType	oType	152	const	132	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1	Using where

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.02 ms
starting	0.03 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.03 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/models/dbobject.php:529
13	SPDBObject->rGetChilds()	JROOT/components/com_sobipro/lib/models/dbobject.php:433
12	SPDBObject->getChilds()	JROOT/components/com_sobipro/lib/ctrl/section.php:312
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.]

Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 6.648 MB Rows returned: 0

Duplicate queries: #43

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 = 423 
  AND sr.oType = 'category' 
  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	sr	ref	PRIMARY,oType	oType	152	const	132	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	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.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: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/models/dbobject.php:529
13	SPDBObject->rGetChilds()	JROOT/components/com_sobipro/lib/models/dbobject.php:433
12	SPDBObject->getChilds()	JROOT/components/com_sobipro/lib/ctrl/section.php:312
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.]

Query Time: 2.11 ms After last query: 2.16 ms Query memory: 0.024 MB Memory before query: 6.648 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  IN ( '45' ) )  
  AND  ( spo.oType ='entry' )  
  AND  ( spo.state ='1' )  
  AND ( ( spo.validUntil > '2025-06-05 05:56:38' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( spo.validSince < '2025-06-05 05:56:38' 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, 10

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.09 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.06 ms
Statistics	0.13 ms
Preparing	0.09 ms
Creating tmp table	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.83 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.22 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.]

Query Time: 0.22 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 6.657 MB Rows returned: 2

Duplicate queries: #41 #45

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

Query Time: 0.24 ms After last query: 2.76 ms Query memory: 0.036 MB Memory before query: 6.679 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.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.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.]

Query Time: 2.38 ms After last query: 26.53 ms Query memory: 0.008 MB Memory before query: 6.939 MB

INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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.14 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init for update	0.04 ms
Update	1.24 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.42 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
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.]

Query Time: 1.14 ms After last query: 2.09 ms Query memory: 0.007 MB Memory before query: 6.936 MB

INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) 
  VALUES ('45','1433','2025-06-05 05:56:38') 
  ON DUPLICATE KEY UPDATE sid = '45',counter = '1433',lastUpdate = '2025-06-05 05:56:38'

Explain

EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('45','1433','2025-06-05 05:56:38') ON DUPLICATE KEY UPDATE sid = '45',counter = '1433',lastUpdate = '2025-06-05 05:56:38'

Profile

Status	Duration
Starting	0.07 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.23 ms
Waiting for query cache lock	0.02 ms
Update	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.35 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
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.]

Query Time: 1.63 ms After last query: 35.81 ms Query memory: 0.009 MB Memory before query: 7.332 MB

INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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.10 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.86 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
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.]

Query Time: 0.96 ms After last query: 0.68 ms Query memory: 0.025 MB Memory before query: 7.332 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.02 ms
Checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 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.03 ms
Statistics	0.07 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.08 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.03 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.32 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.]

Query Time: 0.30 ms After last query: 13.48 ms Query memory: 0.027 MB Memory before query: 8.586 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.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.04 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.]

Query Time: 0.21 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 8.599 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.]

Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 8.608 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.]

Query Time: 0.24 ms After last query: 4.27 ms Query memory: 0.028 MB Memory before query: 8.781 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.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: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.]

Query Time: 0.23 ms After last query: 0.42 ms Query memory: 0.028 MB Memory before query: 8.887 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.03 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.]

Query Time: 0.31 ms After last query: 13.46 ms Query memory: 0.034 MB Memory before query: 9.152 MB Rows returned: 39

SELECT id AS id, sKey AS label, sValue AS value, language 
  FROM cz27f_sobipro_language 
  WHERE  ( id ='1' )  
  AND  ( sKey  IN ( 'description','name','metaKeys','metaDesc','sfMetaKeys','sfMetaDesc','efMetaKeys','efMetaDesc','efDesc','sfDesc','efTitle','sfTitle','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.06 ms
Waiting for query cache lock	0.03 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
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
28	JDatabaseDriver->loadAssocList()	phar:JROOT/libraries/sobi/Sobi-1.0.2.phar.tar.gz/Database/MySQLi.php:842
27	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:707
26	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/models/dbobject.php:863
25	SPDBObject->translate()	JROOT/components/com_sobipro/lib/models/dbobject.php:854
24	SPDBObject->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:779
23	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:798
22	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:343
21	SPFactory::Section()	JROOT/components/com_sobipro/lib/sobi.php:367
20	Sobi::Section()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:721
19	SPJoomlaMainFrame->getItemid()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:559
18	SPJoomlaMainFrame::url()	JROOT/components/com_sobipro/lib/sobi.php:46
17	Sobi::Url()	JROOT/components/com_sobipro/lib/helpers/template.php:210
16	SobiPro::Url()	JROOT/components/com_sobipro/lib/helpers/template.php:222
15	SobiPro::AlternateLink()	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.]

Query Time: 1.37 ms After last query: 29.34 ms Query memory: 0.011 MB Memory before query: 9.188 MB

INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', 'Stack to large - skipping', 'eJy9lttu2zAMht/FDzDH58S96rIW3dACBdINuwgQKI7SapUlT1K6FEXffZScU2Pa8bBuN4ZsS+Qnivwpkodh/sLywRnJ4/xFw8NbMk69MxhGuecXsqykoMJoO5xpOWeVkj5nc39ONIWPYsnuP1QPlVuSe5wJtxoWx0FmR0MwuRKFYVLY11HuzUnxaBQp3MQk9wpOtN5MndyOnUnv7JXlAYaV9sCi64JW1iNOFiQYWRDm3j01H/vShQhdGnfTFaX2f0hZcjKDX6UUNW9JmFgqUlKcNwsijNcBXWy3ekXEglN1TA2WhLSWgDj6b8RJMsLPHgL82dCSLY45g8zu5ovzdAPGL61xRx0j1NGJLLBjhAxOOE4RMCBeKd4fKcESc9iN9EB5RZX2YfcVJ6YlcGEwwPm+Nvlg5QQcOKL03xGFYW+irCa6VdJBZRjUNh/f+Dn4epzl4OmcG6oEEF4z8XjC5xDzOeoORMnlLgizteamRTaiBAOESaAXQi+lKu/kJ1k08gjWfp9c3wFiQbWWyoGOMNCwG/SJ0V/aPXHCCJVciNCCadjdc4PMptDt3WbrlrHWXbQfJH3YNC3adTcJseLrwAss3qWSwnwD6zUb2hROiZhRvBstQLO8Ay2yaJPa5B4O6wlx1gMOGqlRkoOAt/ANsZOFOU/Odwfc2Ng6tXCY/J861RoOkuNeqmdcUdOWnKNrWqxMo43aNuv66Ga/NRsm8v1Otf7QlnCYmnawuXoYb7a7jxym91FH5NqhbAfCVKSDKdgJ3B4IlXsbLoiLIopRqERV+OMt3n505US/5cY2wIrAHpiiP1dM0ZkUzXvR4Q0jQCX/r8GiDL2wpbug7awcw9mLQt3Bp+ObyXQ3b3rkt6ZHm0faoD+vKs6gKIDDnzBDD95bqncUY/yJDaxYUPVO+GhLeQf8MMLun8NaHIkpHhrYwzfYBw6mRw7rm3Rrv2kHB7s9wo71G7gMLOQFXmx/Co41o2AA4AyOdY3Xf4LlQnv9R1kr0tsYANHrbyxNhC4=' );

Explain

EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_errors VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', 'Stack to large - skipping', 'eJy9lttu2zAMht/FDzDH58S96rIW3dACBdINuwgQKI7SapUlT1K6FEXffZScU2Pa8bBuN4ZsS+Qnivwpkodh/sLywRnJ4/xFw8NbMk69MxhGuecXsqykoMJoO5xpOWeVkj5nc39ONIWPYsnuP1QPlVuSe5wJtxoWx0FmR0MwuRKFYVLY11HuzUnxaBQp3MQk9wpOtN5MndyOnUnv7JXlAYaV9sCi64JW1iNOFiQYWRDm3j01H/vShQhdGnfTFaX2f0hZcjKDX6UUNW9JmFgqUlKcNwsijNcBXWy3ekXEglN1TA2WhLSWgDj6b8RJMsLPHgL82dCSLY45g8zu5ovzdAPGL61xRx0j1NGJLLBjhAxOOE4RMCBeKd4fKcESc9iN9EB5RZX2YfcVJ6YlcGEwwPm+Nvlg5QQcOKL03xGFYW+irCa6VdJBZRjUNh/f+Dn4epzl4OmcG6oEEF4z8XjC5xDzOeoORMnlLgizteamRTaiBAOESaAXQi+lKu/kJ1k08gjWfp9c3wFiQbWWyoGOMNCwG/SJ0V/aPXHCCJVciNCCadjdc4PMptDt3WbrlrHWXbQfJH3YNC3adTcJseLrwAss3qWSwnwD6zUb2hROiZhRvBstQLO8Ay2yaJPa5B4O6wlx1gMOGqlRkoOAt/ANsZOFOU/Odwfc2Ng6tXCY/J861RoOkuNeqmdcUdOWnKNrWqxMo43aNuv66Ga/NRsm8v1Otf7QlnCYmnawuXoYb7a7jxym91FH5NqhbAfCVKSDKdgJ3B4IlXsbLoiLIopRqERV+OMt3n505US/5cY2wIrAHpiiP1dM0ZkUzXvR4Q0jQCX/r8GiDL2wpbug7awcw9mLQt3Bp+ObyXQ3b3rkt6ZHm0faoD+vKs6gKIDDnzBDD95bqncUY/yJDaxYUPVO+GhLeQf8MMLun8NaHIkpHhrYwzfYBw6mRw7rm3Rrv2kHB7s9wo71G7gMLOQFXmx/Co41o2AA4AyOdY3Xf4LlQnv9R1kr0tsYANHrbyxNhC4=' );

Profile

Status	Duration
Starting	0.17 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
init for update	0.05 ms
Update	0.14 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.46 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
24	JDatabaseDriverMysqli->execute()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:792
23	SPJoomlaDb->query()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:956
22	SPJoomlaDb->exec()	JROOT/components/com_sobipro/lib/base/exception.php:96
21	SPException::storeError()	JROOT/components/com_sobipro/lib/base/exception.php:205
20	SPExceptionHandler()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:713
19	SPJoomlaMainFrame->getItemid()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:559
18	SPJoomlaMainFrame::url()	JROOT/components/com_sobipro/lib/sobi.php:46
17	Sobi::Url()	JROOT/components/com_sobipro/lib/helpers/template.php:210
16	SobiPro::Url()	JROOT/components/com_sobipro/lib/helpers/template.php:222
15	SobiPro::AlternateLink()	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.]

Query Time: 0.24 ms After last query: 3.48 ms Query memory: 0.023 MB Memory before query: 9.101 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.03 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.03 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/index.php:4
7	require JROOT/templates/theme1946/index.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.]

Query Time: 5.27 ms After last query: 0.55 ms Query memory: 0.029 MB Memory before query: 9.145 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-05 05:56:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-05 05:56:38') 
  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.04 ms
Waiting for query cache lock	0.36 ms
starting	0.02 ms
Checking query cache for query	0.10 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.06 ms
init	0.09 ms
Optimizing	0.08 ms
Statistics	0.91 ms
Preparing	0.12 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	2.86 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.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.03 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: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/index.php:4
7	require JROOT/templates/theme1946/index.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.]

Query Time: 0.29 ms After last query: 6.98 ms Query memory: 0.049 MB Memory before query: 9.333 MB Rows returned: 199

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `cz27f_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cz27f_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	341	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.05 ms
Updating status	0.03 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()	JROOT/libraries/src/Access/Access.php:359
17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 2.90 ms After last query: 0.47 ms Query memory: 0.042 MB Memory before query: 9.518 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM cz27f_content AS a

  INNER JOIN cz27f_categories AS c 
  on c.id = a.catid

  LEFT JOIN cz27f_users AS u 
  on u.id = a.created_by

  LEFT JOIN cz27f_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN cz27f_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 83 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 05:56:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 05:56:38')

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.02 ms
starting	0.02 ms
Checking query cache for query	0.22 ms
checking permissions	0.03 ms
Opening tables	0.13 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.11 ms
Optimizing	0.08 ms
Statistics	1.54 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.03 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.03 ms
Query end	0.03 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.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.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.30 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 9.545 MB Rows returned: 1

SELECT `alias`

  FROM `cz27f_content`

  WHERE id = '83'

Explain

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

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.05 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
21	ContentRouter->getArticleSegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.28 ms After last query: 0.46 ms Query memory: 0.040 MB Memory before query: 9.562 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `cz27f_categories` AS `s`

  INNER JOIN `cz27f_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right\|cat_idx	4\|207	NULL	3 (31%)	Using index condition; Using where; Using rowid filter

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.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.27 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 9.582 MB Rows returned: 1

SELECT alias

  FROM cz27f_content

  WHERE id=83

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cz27f_content	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.02 ms
checking permissions	0.04 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
20	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
19	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
18	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.27 ms After last query: 2.03 ms Query memory: 0.039 MB Memory before query: 9.641 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cz27f_fields AS a

  LEFT JOIN `cz27f_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN cz27f_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cz27f_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN cz27f_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cz27f_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_articles_single.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	biotrade_bio.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.group_id	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.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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_single/helper.php:33
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.32 ms After last query: 2.24 ms Query memory: 0.038 MB Memory before query: 9.659 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cz27f_fields AS a

  LEFT JOIN `cz27f_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN cz27f_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cz27f_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN cz27f_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cz27f_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `cz27f_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_state,idx_access,idx_context,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	biotrade_bio.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	biotrade_bio.a.id	1	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.04 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:387
16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:341
15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_single/helper.php:36
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.27 ms After last query: 2.13 ms Query memory: 0.038 MB Memory before query: 9.762 MB Rows returned: 6

SELECT *

  FROM `cz27f_sobipro_object`

  WHERE `parent` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cz27f_sobipro_object	ref	parent	parent	5	const	6

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.03 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()	JROOT/modules/mod_spfilter/mod_spfilter.php:33
10	include JROOT/modules/mod_spfilter/mod_spfilter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.22 ms After last query: 2.43 ms Query memory: 0.028 MB Memory before query: 9.822 MB Rows returned: 1

SELECT *

  FROM `cz27f_kunena_configuration`

  WHERE `id`=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cz27f_kunena_configuration	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.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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1381
21	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1354
20	KunenaConfig::getInstance()	JROOT/components/com_kunena/router.php:42
19	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_superfish_menu/helper.php:110
11	modSfMenuHelper::getList()	JROOT/modules/mod_superfish_menu/mod_superfish_menu.php:27
10	include JROOT/modules/mod_superfish_menu/mod_superfish_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.27 ms After last query: 3.59 ms Query memory: 0.030 MB Memory before query: 9.949 MB Rows returned: 1

SELECT * 
  FROM cz27f_menu 
  WHERE id='325'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cz27f_menu	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.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/modules/mod_sclogin/helper.php:306
11	modSCLoginHelper->getLoginRedirect()	JROOT/modules/mod_sclogin/mod_sclogin.php:25
10	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

Query Time: 0.25 ms After last query: 1.36 ms Query memory: 0.025 MB Memory before query: 10.035 MB Rows returned: 3

SELECT `c2`.`language`,`c2`.`id`

  FROM `cz27f_menu` AS `c`

  INNER JOIN `cz27f_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `cz27f_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `cz27f_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 325

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a2.id	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.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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.]

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × 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

3 × SELECT pid 
  FROM cz27f_sobipro_plugin_task

3 × SELECT id AS id, sKey AS label, sValue AS value, language 
  FROM cz27f_sobipro_language

3 × SELECT pid 
  FROM cz27f_sobipro_relations

3 × SELECT pid 
  FROM cz27f_sobipro_plugin_section

3 × SELECT pid 
  FROM cz27f_sobipro_plugins

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `cz27f_assets`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `cz27f_extensions`

2 × SELECT  DISTINCT spo.id 
  FROM  cz27f_sobipro_relations AS sprl 
  LEFT JOIN cz27f_sobipro_object AS spo 
  ON sprl.id =  spo.id

2 × SELECT * 
  FROM cz27f_sobipro_registry

2 × SELECT * 
  FROM cz27f_sobipro_object

2 × SELECT * 
  FROM cz27f_sobipro_field

1 × SELECT * 
  FROM cz27f_sobipro_permissions

1 × SELECT counter,sid 
  FROM cz27f_sobipro_counter

1 × SELECT template 
  FROM cz27f_template_styles

1 × 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

1 × SELECT `data` 
  FROM `cz27f_session`

1 × SELECT pid 
  FROM cz27f_sobipro_permissions_map

1 × SELECT `alias` 
  FROM `cz27f_content`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `cz27f_categories` AS `s` 
  INNER JOIN `cz27f_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 × SELECT alias 
  FROM cz27f_content

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM cz27f_fields AS a 
  LEFT JOIN `cz27f_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cz27f_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cz27f_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cz27f_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cz27f_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM cz27f_fields AS a 
  LEFT JOIN `cz27f_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cz27f_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cz27f_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cz27f_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cz27f_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `cz27f_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT * 
  FROM `cz27f_sobipro_object`

1 × SELECT * 
  FROM `cz27f_kunena_configuration`

```
1 × SELECT * 
  FROM cz27f_menu
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM cz27f_content AS a 
  INNER JOIN cz27f_categories AS c 
  on c.id = a.catid 
  LEFT JOIN cz27f_users AS u 
  on u.id = a.created_by 
  LEFT JOIN cz27f_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN cz27f_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT * 
  FROM cz27f_sobipro_category

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

1 × 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

1 × SELECT id, rules 
  FROM `cz27f_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM cz27f_extensions

1 × SELECT `enabled` 
  FROM `cz27f_extensions`

```
1 × SELECT * 
  FROM cz27f_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `cz27f_extensions`

1 × 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

1 × SELECT position,pid 
  FROM cz27f_sobipro_relations

1 × SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue 
  FROM cz27f_sobipro_config

1 × SELECT sValue,sKey 
  FROM cz27f_sobipro_language

1 × SELECT rel.gid 
  FROM  cz27f_sobipro_user_group AS grp 
  LEFT JOIN cz27f_sobipro_users_relation AS rel 
  ON grp.gid =  rel.gid

1 × SELECT count(id) 
  FROM cz27f_usergroup

```
1 × SELECT * 
  FROM cz27f_usergroups
```

1 × SELECT `session_id` 
  FROM `cz27f_session`

1 × SELECT counter 
  FROM cz27f_sobipro_counter

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `cz27f_menu` AS `c` 
  INNER JOIN `cz27f_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `cz27f_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `cz27f_menu` AS `c2` 
  ON a2.id = c2.`id`

OTHER Tables:

1 × INSERT INTO `cz27f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('467ec0d09fe5a7df29803664257a308b', 1, 1749102998, 0, '', 0

1 × UPDATE `cz27f_extensions` 
  SET `params` = '{\"mediaversion\":\"f2ba36866e389d3a4492ecbf2e635d3e\"}'

1 × INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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==' )

1 × INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) 
  VALUES ('45','1433','2025-06-05 05:56:38') 
  ON DUPLICATE KEY UPDATE sid = '45',counter = '1433',lastUpdate = '2025-06-05 05:56:38

1 × INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', '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==' )

1 × INSERT INTO cz27f_sobipro_errors 
  VALUES ( NULL, '2025-06-05 05:56:38', '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.34', 'unknown', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '/en/producers/45-bio-cleaning-detergents', 'Stack to large - skipping', 'eJy9lttu2zAMht/FDzDH58S96rIW3dACBdINuwgQKI7SapUlT1K6FEXffZScU2Pa8bBuN4ZsS+Qnivwpkodh/sLywRnJ4/xFw8NbMk69MxhGuecXsqykoMJoO5xpOWeVkj5nc39ONIWPYsnuP1QPlVuSe5wJtxoWx0FmR0MwuRKFYVLY11HuzUnxaBQp3MQk9wpOtN5MndyOnUnv7JXlAYaV9sCi64JW1iNOFiQYWRDm3j01H/vShQhdGnfTFaX2f0hZcjKDX6UUNW9JmFgqUlKcNwsijNcBXWy3ekXEglN1TA2WhLSWgDj6b8RJMsLPHgL82dCSLY45g8zu5ovzdAPGL61xRx0j1NGJLLBjhAxOOE4RMCBeKd4fKcESc9iN9EB5RZX2YfcVJ6YlcGEwwPm+Nvlg5QQcOKL03xGFYW+irCa6VdJBZRjUNh/f+Dn4epzl4OmcG6oEEF4z8XjC5xDzOeoORMnlLgizteamRTaiBAOESaAXQi+lKu/kJ1k08gjWfp9c3wFiQbWWyoGOMNCwG/SJ0V/aPXHCCJVciNCCadjdc4PMptDt3WbrlrHWXbQfJH3YNC3adTcJseLrwAss3qWSwnwD6zUb2hROiZhRvBstQLO8Ay2yaJPa5B4O6wlx1gMOGqlRkoOAt/ANsZOFOU/Odwfc2Ng6tXCY/J861RoOkuNeqmdcUdOWnKNrWqxMo43aNuv66Ga/NRsm8v1Otf7QlnCYmnawuXoYb7a7jxym91FH5NqhbAfCVKSDKdgJ3B4IlXsbLoiLIopRqERV+OMt3n505US/5cY2wIrAHpiiP1dM0ZkUzXvR4Q0jQCX/r8GiDL2wpbug7awcw9mLQt3Bp+ObyXQ3b3rkt6ZHm0faoD+vKs6gKIDDnzBDD95bqncUY/yJDaxYUPVO+GhLeQf8MMLun8NaHIkpHhrYwzfYBw6mRw7rm3Rrv2kHB7s9wo71G7gMLOQFXmx/Co41o2AA4AyOdY3Xf4LlQnv9R1kr0tsYANHrbyxNhC4=' )

Bio Trade

Bio Cleaning detergents

GOE Europe Ltd.

Bio Glanz Ltd.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

74 Queries Logged 78.77 ms

13 duplicate found!

52 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: