Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1503283426,
                "last": 1503283426,
                "now": 1503283426
            },
            "client": {
                "forwarded": "54.145.113.2"
            }
        },
        "registry": {
            "com_sobipro": {
                "messages-queue": []
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Time

Memory

140 Queries Logged 108.01 ms

1. Query Time: 0.24 ms Query memory: 0.027 MB Memory before query: 0.735 MB Rows returned: 0

   SELECT `data`
   
     FROM `upgrade_session`
   
     WHERE `session_id` = 'imaibt4b85gtcck5o4s0cj8tf1'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   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:1720
   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:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.18 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 0.754 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `upgrade_session`
   
     WHERE `session_id` = 'imaibt4b85gtcck5o4s0cj8tf1' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_session	const	PRIMARY	PRIMARY	766	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
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 68.64 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 0.760 MB

   INSERT INTO `upgrade_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('imaibt4b85gtcck5o4s0cj8tf1', 1, '1503283426', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `upgrade_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('imaibt4b85gtcck5o4s0cj8tf1', 1, '1503283426', 0, '', 0)

   Profile

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

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.19 ms After last query: 2.50 ms Query memory: 0.025 MB Memory before query: 0.936 MB Rows returned: 2

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	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:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.20 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 0.944 MB Rows returned: 6

   SELECT id, rules
   
     FROM `upgrade_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_viewlevels	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:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 9.96 ms After last query: 28.19 ms Query memory: 0.009 MB Memory before query: 2.375 MB

   UPDATE `upgrade_extensions`
   
     SET `params` = '{\"mediaversion\":\"80ad1b605067122f3737d084fc712c30\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_extensions	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/cms/library/helper.php:116
   13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
   10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   9	JFactory::getDocument()	JROOT/plugins/system/urlnormalizer/urlnormalizer.php:24
   8	PlgSystemUrlnormalizer->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.20 ms After last query: 14.46 ms Query memory: 0.030 MB Memory before query: 10.659 MB Rows returned: 1

   SELECT *
   
     FROM upgrade_languages
   
     ORDER BY ordering ASC

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
   12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
   11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
   10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
   9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
   8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.45 ms After last query: 1.34 ms Query memory: 0.043 MB Memory before query: 10.821 MB Rows returned: 1

   SELECT `params` 
     FROM upgrade_extensions 
     WHERE `element`='com_sh404sef' 
     AND `type`='component';

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714
   14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363
   13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
   12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:143
   11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:638
   10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
   9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
   8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.28 ms After last query: 8.63 ms Query memory: 0.027 MB Memory before query: 11.198 MB Rows returned: 0

   SELECT `id`,`alias`,`newurl`,`hits` 
     FROM `upgrade_sh404sef_aliases` 
     WHERE `alias` = 'component/com_sobipro/Itemid,1283/format,raw/out,raw/sid,109/sptpl,feeds.rss/tmpl,component/' or `alias` = 'component/com_sobipro/Itemid,1283/format,raw/out,raw/sid,109/sptpl,feeds.rss/tmpl,component' or `alias` = 'component/com_sobipro/Itemid,1283/format,raw/out,raw/sid,109/sptpl,feeds.rss/tmpl,component/' 
     order by `alias` desc

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	upgrade_sh404sef_aliases	range	alias	alias	767	NULL	2	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:1642
   12	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
   11	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:624
   10	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:249
   9	Sh404sefClassRouterInternal->preprocessParseRule()	JROOT/libraries/cms/router/router.php:597
   8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
   7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:221
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.08 ms After last query: 0.67 ms Query memory: 0.026 MB Memory before query: 11.224 MB Rows returned: 8
    Duplicate queries: #11

    select id, title, alias 
      from upgrade_jumi 
      where published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_jumi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.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:1791
    11	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
    10	parseJumiRouter()	JROOT/libraries/cms/router/router.php:597
    9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
    8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
    7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.10 ms After last query: 1.65 ms Query memory: 0.028 MB Memory before query: 11.355 MB Rows returned: 8
    Duplicate queries: #10

    select id, title, alias 
      from upgrade_jumi 
      where published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_jumi	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.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:1791
    15	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
    14	parseJumiRouter()	JROOT/libraries/cms/router/router.php:597
    13	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
    12	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
    11	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
    10	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    9	JRouterSite->parse()	JROOT/plugins/system/joomlatools/joomlatools.php:275
    8	PlgSystemJoomlatools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.24 ms After last query: 3.34 ms Query memory: 0.037 MB Memory before query: 11.671 MB Rows returned: 1

    SELECT * 
      FROM upgrade_sobipro_object 
      WHERE  ( id ='109' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_object	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:1642
    11	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:859
    10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:200
    9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:175
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.20 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 11.684 MB Rows returned: 1

    SELECT pid 
      FROM upgrade_sobipro_relations 
      WHERE  ( id ='109' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_relations	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:1720
    10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.09 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 11.692 MB Rows returned: 1

    SELECT pid 
      FROM upgrade_sobipro_relations 
      WHERE  ( id ='58' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_relations	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:1720
    10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.07 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 11.699 MB Rows returned: 1

    SELECT pid 
      FROM upgrade_sobipro_relations 
      WHERE  ( id ='54' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_relations	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:1720
    10	JDatabaseDriver->loadResult()	JROOT/libraries/sobi/Database/MySQLi.php:807
    9	Sobi\Database\MySQLi->loadResult()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:186
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.07 ms After last query: 0.05 ms Query memory: 0.037 MB Memory before query: 11.707 MB Rows returned: 1

    SELECT * 
      FROM upgrade_sobipro_object 
      WHERE  ( id ='54' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_object	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:1642
    11	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:859
    10	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/base/factory.php:200
    9	SPFactory::object()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:197
    8	SobiProCtrl->getSection()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.09 ms After last query: 0.60 ms Query memory: 0.039 MB Memory before query: 11.762 MB Rows returned: 91

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	89	100.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:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/sobi/Database/MySQLi.php:885
    10	Sobi\Database\MySQLi->loadObjectList()	JROOT/components/com_sobipro/lib/base/config.php:192
    9	SPConfig->addTable()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:158
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.08 ms After last query: 0.50 ms Query memory: 0.039 MB Memory before query: 11.788 MB Rows returned: 1

    SELECT * 
      FROM upgrade_sobipro_field 
      WHERE  ( fid ='36' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_field	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:1642
    12	JDatabaseDriver->loadObject()	JROOT/libraries/sobi/Database/MySQLi.php:859
    11	Sobi\Database\MySQLi->loadObject()	JROOT/components/com_sobipro/lib/models/field.php:379
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.07 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 11.811 MB Rows returned: 13
    Duplicate queries: #21  #23  #26  #28  #31  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:380
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.07 ms After last query: 0.07 ms Query memory: 0.028 MB Memory before query: 11.824 MB Rows returned: 0
    Duplicate queries: #22  #24  #27  #29  #32  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    13	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    12	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    11	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:380
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.07 ms After last query: 0.08 ms Query memory: 0.030 MB Memory before query: 11.833 MB Rows returned: 13
    Duplicate queries: #19  #23  #26  #28  #31  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:393
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.029 MB Memory before query: 11.846 MB Rows returned: 0
    Duplicate queries: #20  #24  #27  #29  #32  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    15	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    14	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    13	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    12	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:393
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.07 ms After last query: 0.33 ms Query memory: 0.031 MB Memory before query: 11.926 MB Rows returned: 13
    Duplicate queries: #19  #21  #26  #28  #31  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	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:1530
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/sobi.php:420
    13	Sobi::Lang()	JROOT/components/com_sobipro/lib/models/field.php:501
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:400
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 11.941 MB Rows returned: 0
    Duplicate queries: #20  #22  #27  #29  #32  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    17	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    16	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    15	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    14	Sobi::Trigger()	JROOT/components/com_sobipro/lib/sobi.php:420
    13	Sobi::Lang()	JROOT/components/com_sobipro/lib/models/field.php:501
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:400
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 11.951 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_language	range	PRIMARY,sKey	sKey	452	NULL	225	100.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:1486
    14	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:842
    13	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/models/field.php:504
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:400
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.08 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 11.963 MB Rows returned: 13
    Duplicate queries: #19  #21  #23  #28  #31  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:521
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:400
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.029 MB Memory before query: 11.977 MB Rows returned: 0
    Duplicate queries: #20  #22  #24  #29  #32  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/models/field.php:521
    12	SPField->loadTables()	JROOT/components/com_sobipro/lib/models/field.php:400
    11	SPField->extend()	JROOT/components/com_sobipro/lib/models/field.php:384
    10	SPField->init()	JROOT/components/com_sobipro/lib/base/config.php:76
    9	SPConfig->init()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:162
    8	SobiProCtrl->createConfig()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.07 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 11.976 MB Rows returned: 13
    Duplicate queries: #19  #21  #23  #26  #31  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:100
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 11.986 MB Rows returned: 0
    Duplicate queries: #20  #22  #24  #27  #32  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:100
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.07 ms After last query: 1.14 ms Query memory: 0.026 MB Memory before query: 12.139 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_language	ref	PRIMARY,sKey	sKey	452	const	126	100.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:1486
    10	JDatabaseDriver->loadAssocList()	JROOT/libraries/sobi/Database/MySQLi.php:842
    9	Sobi\Database\MySQLi->loadAssocList()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:707
    8	SPJoomlaLang::translateObject()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:124
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.07 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 12.149 MB Rows returned: 13
    Duplicate queries: #19  #21  #23  #26  #28  #36  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:133
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 12.159 MB Rows returned: 0
    Duplicate queries: #20  #22  #24  #27  #29  #37  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    11	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    10	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    9	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    8	Sobi::Trigger()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:133
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 12.178 MB Rows returned: 0

    SELECT rel.gid 
      FROM  upgrade_sobipro_user_group AS grp 
      LEFT JOIN upgrade_sobipro_users_relation AS rel 
      ON grp.gid =  rel.gid 
      WHERE ( ( rel.validUntil > '2017-08-21 02:43:46' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
      AND ( rel.validSince < '2017-08-21 02:43:46' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
      AND grp.enabled = 1  )   
      AND  ( uid ='0' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	grp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	rel	ref	PRIMARY	PRIMARY	8	const,omnitron_omnitron.grp.gid	1	100.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:1530
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    14	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101
    13	SPJoomlaUser->spGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:43
    12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:249
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.07 ms After last query: 0.14 ms Query memory: 0.030 MB Memory before query: 12.192 MB Rows returned: 1

    SELECT count(id)
    
      FROM upgrade_usergroups

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_usergroups	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	25	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:1720
    18	JDatabaseDriver->loadResult()	JROOT/libraries/cms/helper/usergroups.php:202
    17	JHelperUsergroups->total()	JROOT/libraries/cms/helper/usergroups.php:149
    16	JHelperUsergroups->getAll()	JROOT/libraries/joomla/access/access.php:499
    15	JAccess::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221
    14	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78
    13	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45
    12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:249
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.07 ms After last query: 0.05 ms Query memory: 0.034 MB Memory before query: 12.205 MB Rows returned: 25

    SELECT *
    
      FROM upgrade_usergroups
    
      ORDER BY lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_usergroups	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	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:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/usergroups.php:258
    17	JHelperUsergroups->loadAll()	JROOT/libraries/cms/helper/usergroups.php:151
    16	JHelperUsergroups->getAll()	JROOT/libraries/joomla/access/access.php:499
    15	JAccess::getGroupPath()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221
    14	SAccess::parentGroups()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78
    13	SPUser->parentGids()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45
    12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:249
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.07 ms After last query: 0.12 ms Query memory: 0.030 MB Memory before query: 12.248 MB Rows returned: 13
    Duplicate queries: #19  #21  #23  #26  #28  #31  #39  #41  #43  #45  #47  #51  #54  #57  #60  #62  #65  #71  #73  #75  #77  #79  #81  #83  #85  #87  #89  #91  #93  #95  #101  #103  #105  #107  #109  #111  #113  #115  #117  #120  #124  #128  #130  #132  #135

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugins	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.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:1530
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:51
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:46
    12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:249
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.08 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 12.261 MB Rows returned: 0
    Duplicate queries: #20  #22  #24  #27  #29  #32  #40  #42  #44  #46  #48  #52  #55  #58  #61  #63  #66

    SELECT pid 
      FROM upgrade_sobipro_plugin_task 
      WHERE  ( onAction  IN ( '*','*' ) )  
      AND  ( pid  IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info' ) )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	upgrade_sobipro_plugin_task	index	pid	pid	757	NULL	8	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:1530
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/sobi/Database/MySQLi.php:824
    16	Sobi\Database\MySQLi->loadResultArray()	JROOT/components/com_sobipro/lib/plugins/interface.php:61
    15	SPPlugins->load()	JROOT/components/com_sobipro/lib/plugins/interface.php:154
    14	SPPlugins->trigger()	JROOT/components/com_sobipro/lib/sobi.php:226
    13	Sobi::Trigger()	JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:46
    12	SPUser->__construct()	JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388
    11	SPJoomlaUser::getCurrent()	JROOT/components/com_sobipro/lib/base/factory.php:114
    10	SPFactory::user()	JROOT/components/com_sobipro/lib/sobi.php:446
    9	Sobi::My()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:249
    8	SobiProCtrl->route()	JROOT/components/com_sobipro/lib/ctrl/sobipro.php:136
    7	SobiProCtrl->__construct()	JROOT/components/com_sobipro/sobipro.php:44
    6	require_once JROOT/components/com_sobipro/sobipro.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.28 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 12.275 MB Rows returned: 1