Bio Trade

Organic Exchange Directory

Trade with organic cosmetics and organic products and distributor of the brand MaterNatura - bio certified Italian cosmetics series.

Dani 91 Ltd is a producer of cow's milk and cheese.

Daniel Dimitrov is a producer of organic hazelnuts and saplings for hazelnuts of the varieties - Roman, Tonda Gentile, Ran Trapezundski and Almond.

Alexander Valkov is producer of organic hazelnuts and vegetables.

KOMOSS is a manufacturer of organic certified fruits - apples, cherries, strawberries, sour cherries, plums, walnuts.

KOMOSS is a manufacturer of organic certified vegetables - tomatoes, cucumbers, onions, peppers, zucchini.

Orbelus Organic Winery JSC is producer of Bulgarian wine from organic grapes.

Dikotex is a company specializing in the production of healthy, organic and natural foods, herbs and spices, dietetic and diabetic foods and food products

Green Smile Bulgaria offers the largest range of organic products on the Bulgarian market.About 20 organic certified products, satisfying all the nutritional needs of the plants.

“Veselata Ferma” is a producer of organic fruit and vegetables grown in our farm near the village of Skrat, Petrich municipality.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1791598102,
                "last": 1791598102,
                "now": 1791598102
            },
            "token": "5RGZoCqVX19TdhAXpU4HdrRLiWmWpX1C"
        },
        "registry": {
            "com_sobipro": {
                "back_url": "\/en\/producers?site=2",
                "currently-displayed-entries": [
                    "366",
                    "423",
                    "421",
                    "420",
                    "419",
                    "329",
                    "364",
                    "363",
                    "362",
                    "361",
                    "360",
                    "359",
                    "358",
                    "357",
                    "355",
                    "356",
                    "354",
                    "330",
                    "342",
                    "341",
                    "340",
                    "339",
                    "338",
                    "337",
                    "333",
                    "332",
                    "328",
                    "326",
                    "325",
                    "324",
                    "323",
                    "322",
                    "321",
                    "320",
                    "319",
                    "316",
                    "303",
                    "314",
                    "315",
                    "313",
                    "306",
                    "304",
                    "305",
                    "302",
                    "298",
                    "169",
                    "167"
                ],
                "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: 31.17 ms / 31.17 ms Memory: 1.939 MB / 2.18 MB Application: afterLoad

Time: 120.58 ms / 151.76 ms Memory: 8.673 MB / 10.85 MB Application: afterInitialise

Time: 15.53 ms / 167.29 ms Memory: 0.912 MB / 11.76 MB Application: afterRoute

Time: 3.25 ms / 170.54 ms Memory: 0.051 MB / 11.81 MB Application: beforeRenderComponent com_sobipro

Time: 69.02 ms / 239.56 ms Memory: 4.510 MB / 16.32 MB Application: Before Access::preloadComponents (all components)

Time: 1.69 ms / 241.25 ms Memory: 0.104 MB / 16.43 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 241.30 ms Memory: 0.000 MB / 16.42 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.98 ms / 242.28 ms Memory: 0.046 MB / 16.47 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 270.47 ms / 512.75 ms Memory: 4.515 MB / 20.98 MB Application: afterRenderComponent com_sobipro

Time: 3.99 ms / 516.74 ms Memory: 0.159 MB / 21.14 MB Application: afterDispatch

Time: 8.77 ms / 525.51 ms Memory: 0.316 MB / 21.46 MB Application: beforeRenderModule mod_login (Login form)

Time: 8.89 ms / 534.40 ms Memory: 0.402 MB / 21.86 MB Application: afterRenderModule mod_login (Login form)

Time: 0.21 ms / 534.61 ms Memory: 0.000 MB / 21.85 MB Application: beforeRenderModule mod_custom (Interreg (EN))

Time: 1.47 ms / 536.08 ms Memory: 0.011 MB / 21.86 MB Application: afterRenderModule mod_custom (Interreg (EN))

Time: 0.15 ms / 536.24 ms Memory: 0.000 MB / 21.86 MB Application: beforeRenderModule mod_custom (Google Analytics)

Time: 0.35 ms / 536.59 ms Memory: 0.007 MB / 21.87 MB Application: afterRenderModule mod_custom (Google Analytics)

Time: 0.08 ms / 536.67 ms Memory: 0.000 MB / 21.87 MB Application: beforeRenderModule mod_menu (Footer Logo)

Time: 3.18 ms / 539.84 ms Memory: 0.118 MB / 21.98 MB Application: afterRenderModule mod_menu (Footer Logo)

Time: 0.10 ms / 539.94 ms Memory: 0.000 MB / 21.98 MB Application: beforeRenderModule mod_articles_single (Contact Us (EN))

Time: 3.10 ms / 543.04 ms Memory: 0.248 MB / 22.22 MB Application: Before Access::preloadPermissions (com_content)

Time: 2.66 ms / 545.70 ms Memory: 0.314 MB / 22.54 MB Application: After Access::preloadPermissions (com_content)

Time: 0.20 ms / 545.90 ms Memory: 0.000 MB / 22.52 MB Application: Before Access::getAssetRules (id:193 name:com_content.article.83)

Time: 0.23 ms / 546.13 ms Memory: 0.011 MB / 22.53 MB Application: After Access::getAssetRules (id:193 name:com_content.article.83)

Time: 30.90 ms / 577.03 ms Memory: 2.697 MB / 25.23 MB Application: afterRenderModule mod_articles_single (Contact Us (EN))

Time: 0.17 ms / 577.19 ms Memory: 0.000 MB / 25.21 MB Application: beforeRenderModule mod_menu (Social media)

Time: 1.99 ms / 579.18 ms Memory: 0.027 MB / 25.23 MB Application: afterRenderModule mod_menu (Social media)

Time: 0.21 ms / 579.38 ms Memory: 0.000 MB / 25.23 MB Application: beforeRenderModule mod_spfilter (Quick Jump)

Time: 2.51 ms / 581.89 ms Memory: 0.071 MB / 25.30 MB Application: afterRenderModule mod_spfilter (Quick Jump)

Time: 0.12 ms / 582.01 ms Memory: 0.000 MB / 25.25 MB Application: beforeRenderModule mod_custom (Create your page(Producers) - (EN))

Time: 0.36 ms / 582.37 ms Memory: 0.007 MB / 25.26 MB Application: afterRenderModule mod_custom (Create your page(Producers) - (EN))

Time: 0.19 ms / 582.55 ms Memory: 0.000 MB / 25.26 MB Application: beforeRenderModule mod_superfish_menu (Superfish menu)

Time: 16.00 ms / 598.55 ms Memory: 0.687 MB / 25.95 MB Application: afterRenderModule mod_superfish_menu (Superfish menu)

Time: 0.29 ms / 598.84 ms Memory: 0.000 MB / 25.94 MB Application: beforeRenderModule mod_sclogin (Login)

Time: 6.50 ms / 605.34 ms Memory: 0.327 MB / 26.27 MB Application: afterRenderModule mod_sclogin (Login)

Time: 0.12 ms / 605.45 ms Memory: 0.000 MB / 26.25 MB Application: beforeRenderModule mod_languages (Language switcher)

Time: 6.05 ms / 611.50 ms Memory: 0.187 MB / 26.44 MB Application: afterRenderModule mod_languages (Language switcher)

Time: 17.60 ms / 629.10 ms Memory: 0.314 MB / 26.75 MB Application: afterRender

Database queries total: 110.65 ms

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

#	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

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

#	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

#	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

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

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

#	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

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

#	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

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

#	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

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

#	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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cz27f_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

#	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

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

#	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

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

#	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

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

#	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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	biotrade_bio.e.element	1	100.00	Using index condition; Using where

#	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

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

#	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

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

#	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

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

#	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

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

#	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

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

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

#	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

EXPLAIN not possible on query: INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('2','15122','2026-10-10 02:08:23') ON DUPLICATE KEY UPDATE sid = '2',counter = '15122',lastUpdate = '2026-10-10 02:08:23'

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.44 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 0.79 ms After last query: 10.71 ms Query memory: 0.022 MB Memory before query: 18.515 MB Rows returned: 21

SELECT counter,sid 
  FROM cz27f_sobipro_counter 
  WHERE  ( sid  IN ( '215','253','45','42','46','41','290','250','44','257','254','144','48','142','237','249','47','49','43','40','311' ) )

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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:415
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: 2.69 ms After last query: 10.08 ms Query memory: 0.022 MB Memory before query: 18.734 MB Rows returned: 10

SELECT counter,sid 
  FROM cz27f_sobipro_counter 
  WHERE  ( sid  IN ( '360','359','358','357','355','356','354','330','342','341' ) )

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.04 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	1.96 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.14 ms
Reset for next command	0.01 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.55 ms After last query: 18.41 ms Query memory: 0.025 MB Memory before query: 20.628 MB Rows returned: 20

Duplicate queries: #21 #37

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

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.63 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 20.657 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	filtered	Extra
1	SIMPLE	cz27f_sobipro_plugin_task	ALL	pid	NO INDEX KEY COULD BE USED	NULL	NULL	12	100.00	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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.47 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 20.681 MB Rows returned: 1

Duplicate queries: #23 #39

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	filtered	Extra
1	SIMPLE	cz27f_sobipro_plugin_section	ref	PRIMARY	PRIMARY	156	const,const	1	100.00	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.85 ms After last query: 14.16 ms Query memory: 0.026 MB Memory before query: 21.126 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	filtered	Extra
1	SIMPLE	cz27f_sobipro_registry	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.19 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.52 ms After last query: 0.72 ms Query memory: 0.026 MB Memory before query: 21.272 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	filtered	Extra
1	SIMPLE	cz27f_sobipro_registry	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 3.61 ms After last query: 100.56 ms Query memory: 0.039 MB Memory before query: 21.466 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	filtered	Extra
1	SIMPLE	cz27f_sobipro_language	ALL	PRIMARY,sKey	NO INDEX KEY COULD BE USED	NULL	NULL	2639	65.67	Using where; Using filesort

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.18 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.73 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 0.55 ms After last query: 13.81 ms Query memory: 0.015 MB Memory before query: 21.284 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	filtered	Extra
1	SIMPLE	cz27f_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 1.28 ms After last query: 2.07 ms Query memory: 0.023 MB Memory before query: 21.462 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 <= '2026-10-10 02:08:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-10 02:08:23') 
  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	filtered	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	95	42.42	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	biotrade_bio.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	biotrade_bio.m.id	2	100.00	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.49 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 1.14 ms After last query: 20.97 ms Query memory: 0.033 MB Memory before query: 22.223 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	filtered	Extra
1	SIMPLE	cz27f_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	341	100.00	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 0.92 ms After last query: 1.94 ms Query memory: 0.028 MB Memory before query: 22.531 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 <= '2026-10-10 02:08:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-10 02:08:23')

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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.46 ms After last query: 1.29 ms Query memory: 0.029 MB Memory before query: 22.566 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	filtered	Extra
1	SIMPLE	cz27f_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.86 ms After last query: 1.39 ms Query memory: 0.038 MB Memory before query: 22.674 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	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	3	30.77	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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.46 ms After last query: 1.16 ms Query memory: 0.027 MB Memory before query: 22.836 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	filtered	Extra
1	SIMPLE	cz27f_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.95 ms After last query: 8.99 ms Query memory: 0.037 MB Memory before query: 23.666 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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	96.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	biotrade_bio.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.checked_out	1	100.00
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.group_id	1	100.00	Using where

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
19	PlgSystemFields->onContentPrepare()	Same as call in the line below.
18	call_user_func_array()	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: 1.29 ms After last query: 7.93 ms Query memory: 0.036 MB Memory before query: 24.695 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	filtered	Extra
1	SIMPLE	a	ALL	idx_state,idx_access,idx_context,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	25	96.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	biotrade_bio.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.checked_out	1	100.00
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	biotrade_bio.a.id	1	100.00	Using where

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	0.11 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.33 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:387
17	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:341
16	PlgSystemFields->onContentAfterDisplay()	Same as call in the line below.
15	call_user_func_array()	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.60 ms After last query: 8.69 ms Query memory: 0.026 MB Memory before query: 25.270 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	filtered	Extra
1	SIMPLE	cz27f_sobipro_object	ref	parent	parent	5	const	6	100.00

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.76 ms After last query: 8.13 ms Query memory: 0.030 MB Memory before query: 25.555 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	filtered	Extra
1	SIMPLE	cz27f_kunena_configuration	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.80 ms After last query: 12.96 ms Query memory: 0.023 MB Memory before query: 26.265 MB Rows returned: 1

SELECT * 
  FROM cz27f_menu 
  WHERE id='325'

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.93 ms After last query: 4.36 ms Query memory: 0.021 MB Memory before query: 26.427 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	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.a2.id	1	100.00

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.17 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.07 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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.]

50 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

48 × 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 id AS id, sKey AS label, sValue AS value, language 
  FROM cz27f_sobipro_language

3 × SELECT pid 
  FROM cz27f_sobipro_plugin_section

3 × SELECT pid 
  FROM cz27f_sobipro_plugins

3 × SELECT pid 
  FROM cz27f_sobipro_plugin_task

2 × SELECT * 
  FROM cz27f_sobipro_object

2 × SELECT * 
  FROM cz27f_sobipro_field

2 × SELECT pid 
  FROM cz27f_sobipro_relations

2 × SELECT * 
  FROM cz27f_sobipro_registry

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

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

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 counter,sid 
  FROM cz27f_sobipro_counter

1 × SELECT * 
  FROM cz27f_sobipro_permissions

1 × SELECT  DISTINCT spo.id 
  FROM  cz27f_sobipro_language AS splang 
  LEFT JOIN cz27f_sobipro_object AS spo 
  ON splang.id =  spo.id

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 template 
  FROM cz27f_template_styles

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_object`

1 × SELECT * 
  FROM `cz27f_kunena_configuration`

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

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`

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 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 `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 pid 
  FROM cz27f_sobipro_permissions_map

1 × SELECT * 
  FROM cz27f_sobipro_category

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

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

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 `enabled` 
  FROM `cz27f_extensions`

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

1 × SELECT `session_id` 
  FROM `cz27f_session`

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 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 cSection AS configsection,sKey AS sKey,sValue AS sValue 
  FROM cz27f_sobipro_config

1 × SELECT `data` 
  FROM `cz27f_session`

1 × SELECT counter 
  FROM cz27f_sobipro_counter

1 × SELECT position,pid 
  FROM cz27f_sobipro_relations

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

1 × SELECT count(id) 
  FROM cz27f_usergroup

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  DISTINCT sprl.rid 
  FROM  cz27f_sobipro_permissions_groups AS spgr 
  LEFT JOIN cz27f_sobipro_permissions_rules AS sprl 
  ON spgr.rid =  sprl.rid

OTHER Tables:

1 × INSERT INTO cz27f_sobipro_counter (`sid`,`counter`,`lastUpdate`) 
  VALUES ('2','15122','2026-10-10 02:08:23') 
  ON DUPLICATE KEY UPDATE sid = '2',counter = '15122',lastUpdate = '2026-10-10 02:08:23

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

1 × INSERT INTO `cz27f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a1hg9o0k19csr3mr1rlhqlf2n1', 1, 1791598102, 0, '', 0

Bio Trade

Bio Producers

MIO BIO Ltd.

DANI 91 Ltd.

Daniel Dimitrov

Alexander Valkov AP

KOMOSS Ltd.

KOMOSS Ltd.

Orbelus Organic Winery JSC

Dikotex

Green Smile Bulgaria Ltd

Veselata ferma AD

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

113 Queries Logged 110.65 ms

54 duplicate found!

50 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	spgr	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using temporary
1	SIMPLE	sprl	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.spgr.rid	1	100.00	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sr	index	PRIMARY	oType	152	NULL	318	100.00	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	100.00	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1	100.00	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sr	ref	PRIMARY,oType	oType	152	const	132	100.00	Using where; Using index
1	SIMPLE	so	eq_ref	PRIMARY	PRIMARY	4	biotrade_bio.sr.id	1	100.00	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	func	1	100.00	Using where

Status	Duration
Starting	0.39 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.06 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Status	Duration
Starting	12.46 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.03 ms