Tektronix 2754p 2755ap 2755p Spectrum Analyzer

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1742647942,
                "last": 1742647942,
                "now": 1742647942
            },
            "token": "zWXzhmP7Sc5816mIjiHryCFSaBY0A9gO"
        },
        "registry": {
            "com_sobipro": {
                "messages-queue": [],
                "back_url": "/test-equipment-repair-and-calibration-service/metrology-maintenance-laboratory/441-tektronix-2754p-2755ap-2755p"
            }
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 28.22 ms / 28.22 ms Memory: 2.012 MB / 2.38 MB Application: afterLoad

Time: 115.65 ms / 143.87 ms Memory: 7.655 MB / 10.03 MB Application: afterInitialise

Time: 33.07 ms / 176.94 ms Memory: 2.440 MB / 12.47 MB Application: afterRoute

Time: 1.81 ms / 178.76 ms Memory: 0.012 MB / 12.49 MB Application: beforeRenderComponent com_sobipro

Time: 123.33 ms / 302.09 ms Memory: 4.179 MB / 16.67 MB Application: Before Access::preloadComponents (all components)

Time: 2.83 ms / 304.92 ms Memory: 0.069 MB / 16.74 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 304.98 ms Memory: -0.002 MB / 16.73 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.75 ms / 305.73 ms Memory: 0.026 MB / 16.76 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 436.72 ms / 742.45 ms Memory: 5.428 MB / 22.19 MB Application: afterRenderComponent com_sobipro

Time: 2.62 ms / 745.07 ms Memory: 0.099 MB / 22.29 MB Application: afterDispatch

Time: 0.16 ms / 808.92 ms Memory: -0.005 MB / 23.16 MB Application: beforeRenderModule mod_custom (Veteran and Women Owned Business)

Time: 0.37 ms / 809.29 ms Memory: 0.004 MB / 23.16 MB Application: afterRenderModule mod_custom (Veteran and Women Owned Business)

Time: 0.07 ms / 809.36 ms Memory: -0.002 MB / 23.16 MB Application: beforeRenderModule mod_ossobiproajaxsearch (OS SobiPro Ajax Search)

Time: 3.29 ms / 812.64 ms Memory: 0.070 MB / 23.23 MB Application: afterRenderModule mod_ossobiproajaxsearch (OS SobiPro Ajax Search)

Time: 0.06 ms / 812.70 ms Memory: -0.013 MB / 23.22 MB Application: beforeRenderModule mod_menu (Must-see Stuff)

Time: 7.80 ms / 820.50 ms Memory: 0.083 MB / 23.30 MB Application: afterRenderModule mod_menu (Must-see Stuff)

Time: 0.06 ms / 820.55 ms Memory: 0.003 MB / 23.30 MB Application: beforeRenderModule mod_creativecontactform (questions)

Time: 10.58 ms / 831.13 ms Memory: 0.223 MB / 23.53 MB Application: afterRenderModule mod_creativecontactform (questions)

Time: 0.07 ms / 831.21 ms Memory: -0.008 MB / 23.52 MB Application: beforeRenderModule mod_custom (Extensive parts inventory)

Time: 0.45 ms / 831.66 ms Memory: 0.004 MB / 23.52 MB Application: afterRenderModule mod_custom (Extensive parts inventory)

Time: 0.11 ms / 831.77 ms Memory: -0.002 MB / 23.52 MB Application: beforeRenderModule mod_custom (Efficiency)

Time: 0.69 ms / 832.46 ms Memory: 0.004 MB / 23.53 MB Application: afterRenderModule mod_custom (Efficiency)

Time: 37.29 ms / 869.75 ms Memory: 0.422 MB / 23.95 MB Application: afterRender

Database queries total: 480.33 ms

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

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

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

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

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

Profile

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

Call Stack

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

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

Query Time: 1.03 ms After last query: 3.77 ms Query memory: 0.040 MB Memory before query: 4.503 MB Rows returned: 48

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `bajzm_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	extension	extension	82	const	51	1.00	Using where

Profile

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

Call Stack

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

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

Query Time: 0.83 ms After last query: 3.56 ms Query memory: 0.021 MB Memory before query: 4.708 MB Rows returned: 5

SELECT id, rules

  FROM `bajzm_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 4.720 MB Rows returned: 2

SELECT b.id

  FROM bajzm_usergroups AS a

  LEFT JOIN bajzm_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.64 ms After last query: 0.96 ms Query memory: 0.035 MB Memory before query: 4.789 MB Rows returned: 130

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM bajzm_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	extension	extension	82	const	166	0.60	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.96 ms After last query: 25.29 ms Query memory: 0.029 MB Memory before query: 7.401 MB Rows returned: 202

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 7.430 MB Rows returned: 17

SELECT name,value

  FROM bajzm_jsn_poweradmin_config

  WHERE 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 1.09 ms Query memory: 0.020 MB Memory before query: 7.468 MB Rows returned: 1

SELECT COUNT(*)

  FROM bajzm_extensions

  WHERE element="jsnadminbar"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:913
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 17.37 ms Query memory: 0.021 MB Memory before query: 8.792 MB Rows returned: 1

SELECT params

  FROM bajzm_extensions

  WHERE type = "plugin" 
  AND folder = "system" 
  AND element = 'jsnextfw'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:169
9	JsnExtFwHelper::getSettings()	JROOT/plugins/system/jsnextfw/jsnextfw.php:144
8	PlgSystemJsnExtFw->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 8.833 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `bajzm_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/responsivizer/responsivizer.php:129
8	plgSystemResponsivizer->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 8.825 MB

UPDATE `bajzm_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/responsivizer/responsivizer.php:129
8	plgSystemResponsivizer->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 6.16 ms Query memory: 0.021 MB Memory before query: 9.488 MB Rows returned: 1

SELECT params

  FROM bajzm_extensions

  WHERE type = "component" 
  AND element = 'com_pagebuilder4'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:179
10	JsnExtFwHelper::getSettings()	JROOT/administrator/components/com_pagebuilder4/helpers/pagebuilder4.php:156
9	JSNPageBuilder4Helper::getConfig()	JROOT/plugins/system/pagebuilder4/pagebuilder4.php:205
8	plgSystemPageBuilder4->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.49 ms After last query: 10.62 ms Query memory: 0.048 MB Memory before query: 10.283 MB Rows returned: 26

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 bajzm_menu AS m

  LEFT JOIN bajzm_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	146	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	arepair_1716.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 8.86 ms Query memory: 0.021 MB Memory before query: 10.825 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM bajzm_template_styles as s

  LEFT JOIN bajzm_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	8	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	arepair_1716.e.element	1	75.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/routerreplacer/routerreplacer.php:95
8	plgSystemRouterReplacer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.75 ms Query memory: 0.022 MB Memory before query: 10.898 MB Rows returned: 1

SELECT manifest_cache

  FROM bajzm_extensions

  WHERE element LIKE 'jsn_epic2_pro'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	12	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
11	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
10	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 3.69 ms Query memory: 0.021 MB Memory before query: 11.183 MB Rows returned: 1

Duplicate queries: #19

SELECT COUNT(*)

  FROM bajzm_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 7.82 ms Query memory: 0.022 MB Memory before query: 11.839 MB Rows returned: 1

Duplicate queries: #18

SELECT COUNT(*)

  FROM bajzm_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/utils.php:81
11	SunFwUtils::checkSH404SEF()	JROOT/plugins/system/sunfw/includes/overwrite/overwrite.php:84
10	SunFwOverwrite::initialize()	JROOT/plugins/system/sunfw/includes/site.php:121
9	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:241
8	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:383
7	PlgSystemSunFw->onAfterRoute()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.87 ms After last query: 1.02 ms Query memory: 0.146 MB Memory before query: 11.927 MB Rows returned: 1

SELECT ss.*

  FROM bajzm_sunfw_styles AS ss

  INNER JOIN bajzm_template_styles AS ts 
  ON ts.id = ss.style_id

  WHERE ts.id = 11

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ss	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	ts	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/sunfw/includes/helper.php:253
10	SunFwHelper::getSunFwStyle()	JROOT/plugins/system/sunfw/includes/site.php:140
9	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:241
8	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:383
7	PlgSystemSunFw->onAfterRoute()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 2.17 ms Query memory: 0.019 MB Memory before query: 12.477 MB Rows returned: 1

SELECT *

  FROM bajzm_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 15.53 ms Query memory: 0.022 MB Memory before query: 13.992 MB Rows returned: 1

SELECT * 
  FROM bajzm_sobipro_object 
  WHERE  ( id ='441' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:978
10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:224
9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:201
8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:92
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 14.000 MB Rows returned: 1

SELECT pid 
  FROM bajzm_sobipro_relations 
  WHERE  ( id ='441' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:919
9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:212
8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:92
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 14.006 MB Rows returned: 1

SELECT pid 
  FROM bajzm_sobipro_relations 
  WHERE  ( id ='437' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:919
9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:212
8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:92
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 14.012 MB Rows returned: 1

SELECT pid 
  FROM bajzm_sobipro_relations 
  WHERE  ( id ='435' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:919
9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:212
8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:92
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 14.017 MB Rows returned: 1

SELECT * 
  FROM bajzm_sobipro_object 
  WHERE  ( id ='435' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:978
10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:224
9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:224
8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:92
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.32 ms After last query: 3.24 ms Query memory: 0.031 MB Memory before query: 14.241 MB Rows returned: 102

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/sobi/Database/MySQLi.php:1007
10	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/base/config.php:228
9	SPConfig->addTable()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:181
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 2.20 ms Query memory: 0.022 MB Memory before query: 15.050 MB Rows returned: 1

Duplicate queries: #79

SELECT * 
  FROM bajzm_sobipro_field 
  WHERE  ( fid ='25' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:978
11	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/models/field.php:425
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.76 ms Query memory: 0.024 MB Memory before query: 15.093 MB Rows returned: 20

Duplicate queries: #32 #35 #39 #42 #46 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:426
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 15.103 MB Rows returned: 1

Duplicate queries: #33 #36 #40 #43 #47 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:426
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 15.111 MB Rows returned: 0

Duplicate queries: #34 #37 #41 #44 #48 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:426
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 15.115 MB Rows returned: 20

Duplicate queries: #29 #35 #39 #42 #46 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:445
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #30 #36 #40 #43 #47 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:445
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 15.142 MB Rows returned: 0

Duplicate queries: #31 #37 #41 #44 #48 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:445
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 2.44 ms Query memory: 0.025 MB Memory before query: 15.296 MB Rows returned: 20

Duplicate queries: #29 #32 #39 #42 #46 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/sobi.php:510
13	Sobi::Lang()	JROOT/components/com_sobipro/lib/models/field.php:575
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 15.308 MB Rows returned: 1

Duplicate queries: #30 #33 #40 #43 #47 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/sobi.php:510
13	Sobi::Lang()	JROOT/components/com_sobipro/lib/models/field.php:575
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 15.317 MB Rows returned: 0

Duplicate queries: #31 #34 #41 #44 #48 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/sobi.php:510
13	Sobi::Lang()	JROOT/components/com_sobipro/lib/models/field.php:575
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.91 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 15.323 MB Rows returned: 3

Duplicate queries: #86 #104

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_language	NULL	range	PRIMARY,sKey	PRIMARY	602	NULL	109	1.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:959
13	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/models/field.php:578
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 15.332 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #42 #46 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:596
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 15.343 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #43 #47 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:596
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 15.352 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #44 #48 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:596
12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:452
11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:431
10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:96
9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185
8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:102
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 15.353 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #46 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:108
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 15.362 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #47 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:108
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 15.369 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #48 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:108
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 4.90 ms Query memory: 0.021 MB Memory before query: 15.637 MB Rows returned: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_language	NULL	ref	PRIMARY,sKey	sKey	602	const	17	1.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:959
9	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:852
8	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:142
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 15.644 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #52 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 15.653 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #53 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #31 #34 #37 #41 #44 #54 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.13 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 15.668 MB Rows returned: 0

SELECT rel.gid 
  FROM  bajzm_sobipro_user_group AS grp 
  LEFT JOIN bajzm_sobipro_users_relation AS rel 
  ON grp.gid =  rel.gid 
  WHERE ( ( rel.validUntil > '2025-03-22 12:52:22' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( rel.validSince < '2025-03-22 12:52:22' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
  AND grp.enabled = 1  )   
  AND  ( uid ='0' )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:100
13	SPJoomlaUser->spGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:38
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.58 ms Query memory: 0.025 MB Memory before query: 15.694 MB Rows returned: 1

SELECT count(id)

  FROM bajzm_usergroups

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	9	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/Helper/UserGroupsHelper.php:207
17	Joomla\CMS\Helper\UserGroupsHelper->total()	JROOT/libraries/src/Helper/UserGroupsHelper.php:154
16	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
15	Joomla\CMS\Access\Access::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:225
14	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:75
13	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:40
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 15.703 MB Rows returned: 9

SELECT *

  FROM bajzm_usergroups

  ORDER BY lft ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/UserGroupsHelper.php:263
17	Joomla\CMS\Helper\UserGroupsHelper->loadAll()	JROOT/libraries/src/Helper/UserGroupsHelper.php:156
16	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
15	Joomla\CMS\Access\Access::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:225
14	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:75
13	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:40
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 15.719 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #46 #56 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:41
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.16 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 15.731 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #47 #57 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:41
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 15.739 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #44 #48 #58 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:41
12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:419
11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:126
10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:545
9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:278
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 11.91 ms After last query: 1.36 ms Query memory: 0.088 MB Memory before query: 15.748 MB Rows returned: 243

SELECT fileName,template,configFile,cid 
  FROM bajzm_sobipro_view_cache 
  WHERE  ( section ='435' )  
  AND  ( sid ='441' )  
  AND  ( task ='' )  
  AND  ( site ='1' )  
  AND  ( request ='[]' )  
  AND  ( language ='en-GB' )  
  AND  ( userGroups ='[1,9]' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_view_cache	NULL	index_merge	sid,section,language,task,request,site,userGroups	sid,section	4,4	NULL	76	76.87	Using intersect(sid,section); Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/libraries/sobi/Database/MySQLi.php:1026
10	Sobi\Database\MySQLi->loadRow()	JROOT/components/com_sobipro/lib/base/cache.php:900
9	SPCache->view()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:285
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 5.01 ms Query memory: 0.025 MB Memory before query: 16.059 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #46 #52 #59 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/controller.php:89
13	SPController->__construct()	Same as call in the line below.
12	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
11	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:425
10	SPFactory::Controller()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:471
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 16.070 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #47 #53 #60 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/controller.php:89
13	SPController->__construct()	Same as call in the line below.
12	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
11	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:425
10	SPFactory::Controller()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:471
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 16.079 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #44 #48 #54 #61 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/controller.php:89
13	SPController->__construct()	Same as call in the line below.
12	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
11	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:425
10	SPFactory::Controller()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:471
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 8.16 ms Query memory: 0.026 MB Memory before query: 16.330 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #46 #52 #56 #62 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
19	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
18	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
17	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
16	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
15	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/models/entry.php:103
14	SPEntry->__construct()	Same as call in the line below.
13	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
12	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:311
11	SPFactory::Model()	JROOT/components/com_sobipro/lib/base/factory.php:333
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 16.343 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #47 #53 #57 #63 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
19	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
18	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
17	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
16	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
15	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/models/entry.php:103
14	SPEntry->__construct()	Same as call in the line below.
13	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
12	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:311
11	SPFactory::Model()	JROOT/components/com_sobipro/lib/base/factory.php:333
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 16.353 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #44 #48 #54 #58 #64 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
19	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
18	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
17	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
16	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:218
15	SPDBObject->__construct()	JROOT/components/com_sobipro/lib/models/entry.php:103
14	SPEntry->__construct()	Same as call in the line below.
13	ReflectionClass->newInstanceArgs()	JROOT/components/com_sobipro/lib/base/factory.php:275
12	SPFactory::Instance()	JROOT/components/com_sobipro/lib/base/factory.php:311
11	SPFactory::Model()	JROOT/components/com_sobipro/lib/base/factory.php:333
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 16.360 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #46 #52 #56 #59 #65 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:851
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 16.371 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #47 #53 #57 #60 #66 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:851
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 16.379 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #44 #48 #54 #58 #61 #67 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:851
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 16.393 MB Rows returned: 20

Duplicate queries: #29 #32 #35 #39 #42 #46 #52 #56 #59 #62 #72 #76 #80 #83 #87 #94 #97 #101 #105 #108 #111 #114 #118 #121 #124 #128 #131 #134 #138 #141 #144 #148 #151 #154 #158 #161 #164 #167 #170 #174 #178 #181 #184 #187 #190 #193 #196 #199 #202 #205 #208 #211 #214 #217 #220 #223 #226 #230 #233 #236 #239 #242 #245 #248 #251 #254 #257 #260 #263 #266 #270 #273 #276 #279 #282 #285 #288 #291 #294 #297 #300 #303 #306 #309 #312 #315 #318 #321 #324 #327 #330 #333 #336 #339 #342 #345 #348 #351 #355 #360 #363 #367 #371 #374 #377 #380 #383 #386 #389 #392 #395 #398 #401 #404 #407 #410 #413 #416 #419 #424 #427 #430 #433 #436 #439 #442 #445 #448 #451 #454 #479 #482 #485

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:70
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:838
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 16.410 MB Rows returned: 1

Duplicate queries: #30 #33 #36 #40 #43 #47 #53 #57 #60 #63 #73 #77 #81 #84 #88 #95 #98 #102 #106 #109 #112 #115 #119 #122 #125 #129 #132 #135 #139 #142 #145 #149 #152 #155 #159 #162 #165 #168 #171 #175 #179 #182 #185 #188 #191 #194

SELECT pid 
  FROM bajzm_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )  
  AND  ( pid  IN ( 'chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','im_ex','download_field','mod_sobipro_entries','button','geomap_field','mod_sobipro_geomap','notifications','contact_field','template_packager' ) )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_task	NULL	index	pid	pid	757	NULL	17	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:86
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:838
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 16.419 MB Rows returned: 0

Duplicate queries: #31 #34 #37 #41 #44 #48 #54 #58 #61 #64 #74 #78 #82 #85 #89 #96 #99 #103 #107 #110 #113 #116 #120 #123 #126 #130 #133 #136 #140 #143 #146 #150 #153 #156 #160 #163 #166 #169 #172 #176 #180 #183 #186 #189 #192 #195

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	16.67	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:100
15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:230
14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:241
13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/dbobject.php:838
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 16.424 MB Rows returned: 1

SELECT pid,position,validSince,validUntil 
  FROM bajzm_sobipro_relations 
  WHERE  ( id ='441' )  
  AND  ( oType ='entry' )   
  ORDER BY position

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_relations	NULL	ref	PRIMARY,oType	PRIMARY	4	const	1	97.34	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:959
15	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/models/entry.php:453
14	SPEntry->getCategories()	JROOT/components/com_sobipro/lib/models/entry.php:120
13	SPEntry->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:839
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 16.434 MB Rows returned: 1

SELECT id 
  FROM bajzm_sobipro_object 
  WHERE  ( id  IN ( '437' ) )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:938
15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/models/entry.php:457
14	SPEntry->getCategories()	JROOT/components/com_sobipro/lib/models/entry.php:120
13	SPEntry->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:839
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.97 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 16.443 MB Rows returned: 2

SELECT id AS id, sKey AS label, sValue AS value, language 
  FROM bajzm_sobipro_language 
  WHERE  ( id  IN ( '437' ) )  
  AND  ( oType ='category' )  
  AND  ( sKey  IN ( 'name','alias','nid' ) )   
  ORDER BY FIELD( language,  'en-GB',  'en-GB' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bajzm_sobipro_language	NULL	ALL	PRIMARY,sKey	NO INDEX KEY COULD BE USED	NULL	NULL	1552	0.26	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:959
16	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:852
15	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/models/entry.php:479
14	SPEntry->getCategories()	JROOT/components/com_sobipro/lib/models/entry.php:120
13	SPEntry->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:839
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 16.453 MB Rows returned: 1

SELECT nid,id 
  FROM bajzm_sobipro_object 
  WHERE  ( id  IN ( '437' ) )

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:959
16	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:858
15	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/models/entry.php:479
14	SPEntry->getCategories()	JROOT/components/com_sobipro/lib/models/entry.php:120
13	SPEntry->loadTable()	JROOT/components/com_sobipro/lib/models/dbobject.php:839
12	SPDBObject->extend()	JROOT/components/com_sobipro/lib/models/dbobject.php:859
11	SPDBObject->init()	JROOT/components/com_sobipro/lib/base/factory.php:334
10	SPFactory::Entry()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:477
9	SobiProCtrl->routeObj()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:296
8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:154
7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:46
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 16.462 MB Rows returned: 20

Hewlett Packard Tektronix

2754P 2755AP 2755P

Efficiency

Must-see Stuff

Extensive parts inventory

We are a Veteran & Women Owned Small Business.

Copyright © www.AnalyzerRepair.com 2021

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

495 Queries Logged 480.33 ms

415 duplicate found!