Hilltop,Mudgee, on-property sale

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1635071662,
                "last": 1635071662,
                "now": 1635071662
            },
            "token": "3iXZJkdU9qsywMaS3xbrp8UeE8csR9Yh"
        },
        "registry": {},
        "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
        }
    }
}

Time

Memory

60 Queries Logged 42.18 ms

1. Query Time: 0.38 ms Query memory: 0.007 MB Memory before query: 3.899 MB Rows returned: 0

   SELECT `data`
   
     FROM `josok_session`
   
     WHERE `session_id` = X'6666353864393963643530663430346238363463326332653962633266643361'

   Explain

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

   Profile

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
   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:414
   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.]

   ---

2. Query Time: 0.26 ms After last query: 1.21 ms Query memory: 0.004 MB Memory before query: 4.057 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `josok_session`
   
     WHERE `session_id` = X'6666353864393963643530663430346238363463326332653962633266643361' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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:856
   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:414
   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.]

   ---

3. Query Time: 4.52 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 4.062 MB

   INSERT INTO `josok_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6666353864393963643530663430346238363463326332653962633266643361', 1, 1635071662, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `josok_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6666353864393963643530663430346238363463326332653962633266643361', 1, 1635071662, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.05 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.01 ms
   Update	0.08 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	4.17 ms
   Closing tables	0.02 ms
   Unlocking tables	0.02 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:856
   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:414
   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.]

   ---

4. Query Time: 0.57 ms After last query: 2.98 ms Query memory: 0.006 MB Memory before query: 4.281 MB Rows returned: 48

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.18 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.04 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

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

   ---

5. Query Time: 0.33 ms After last query: 2.54 ms Query memory: 0.005 MB Memory before query: 4.490 MB Rows returned: 5

   SELECT id, rules
   
     FROM `josok_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

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

   ---

6. Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 4.502 MB Rows returned: 2

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

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

   ---

7. Query Time: 1.00 ms After last query: 0.63 ms Query memory: 0.005 MB Memory before query: 4.571 MB Rows returned: 141

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.59 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.04 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

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

   ---

8. Query Time: 0.50 ms After last query: 32.61 ms Query memory: 0.006 MB Memory before query: 8.913 MB Rows returned: 140

   SELECT `config_key`,`config_value`
   
     FROM josok_osmembership_configs

   Explain

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

   Profile

   Status	Duration
   Starting	0.11 ms
   Checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.08 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:41
   10	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:61
   9	OSMembershipHelper::getConfig()	JROOT/administrator/components/com_osmembership/loader.php:80
   8	require_once JROOT/administrator/components/com_osmembership/loader.php	JROOT/plugins/system/membershippro/membershippro.php:55
   7	plgSystemMembershipPro->__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:695
   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.]

   ---

9. Query Time: 0.37 ms After last query: 16.44 ms Query memory: 0.006 MB Memory before query: 10.451 MB Rows returned: 43

   SELECT *
   
     FROM josok_rsform_config

   Explain

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

   Profile

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.03 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
   11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
   10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
   9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
   8	plgSystemRsformdeletesubmissions->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:696
   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.]

   ---

10. Query Time: 0.97 ms After last query: 2.91 ms Query memory: 0.009 MB Memory before query: 10.750 MB Rows returned: 60

    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 josok_menu AS m
    
      LEFT JOIN josok_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	69	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	merinonsw_joo117.m.component_id	1	Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.49 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    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:445
    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:561
    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:1169
    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.]

    ---

11. Query Time: 0.59 ms After last query: 11.18 ms Query memory: 0.006 MB Memory before query: 12.330 MB Rows returned: 328

    SELECT fas.*
    	                  
      FROM josok_jbusinessdirectory_application_settings fas

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.27 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:65
    10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:48
    9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:39
    8	plgSystemUrlTranslator->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:1218
    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.]

    ---

12. Query Time: 0.31 ms After last query: 0.31 ms Query memory: 0.006 MB Memory before query: 12.625 MB Rows returned: 1

    SELECT fas.*
    	                  
      FROM josok_jbusinessdirectory_date_formats fas
    	                
      WHERE fas.id ='2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:76
    10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:48
    9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:39
    8	plgSystemUrlTranslator->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:1218
    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.]

    ---

13. Query Time: 0.29 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 12.631 MB Rows returned: 1

    SELECT fas.*
    	                  
      FROM josok_jbusinessdirectory_currencies fas
    	                
      WHERE fas.currency_id ='9'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:85
    10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:48
    9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:39
    8	plgSystemUrlTranslator->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:1218
    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.]

    ---

14. Query Time: 0.38 ms After last query: 0.18 ms Query memory: 0.005 MB Memory before query: 12.394 MB Rows returned: 1

    SELECT * 
      FROM josok_jbusinessdirectory_company_events e 
      where e.id = 245 
      LIMIT 0, 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:332
    9	plgSystemUrlTranslator->getEventParms()	JROOT/plugins/system/urltranslator/urltranslator.php:99
    8	plgSystemUrlTranslator->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:1218
    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.]

    ---

15. Query Time: 0.40 ms After last query: 1.56 ms Query memory: 0.007 MB Memory before query: 12.536 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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.]

    ---

16. Query Time: 4.23 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 12.527 MB

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init for update	0.06 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	3.85 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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.]

    ---

17. Query Time: 0.40 ms After last query: 1.56 ms Query memory: 0.004 MB Memory before query: 12.702 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

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

    ---

18. Query Time: 0.60 ms After last query: 0.22 ms Query memory: 0.003 MB Memory before query: 12.715 MB Rows returned: 5

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	5
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	merinonsw_joo117.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.18 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

    ---

19. Query Time: 0.76 ms After last query: 17.91 ms Query memory: 0.009 MB Memory before query: 14.783 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_default_attributes`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_default_attributes`

    Profile

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.23 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    Checking permissions	0.04 ms
    Closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:19
    13	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:320
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:4587
    11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:27
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

20. Query Time: 0.34 ms After last query: 0.62 ms Query memory: 0.007 MB Memory before query: 14.814 MB Rows returned: 64

    SELECT id, name, event_config as config 
      FROM josok_jbusinessdirectory_default_attributes

    Explain

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

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
    12	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:4588
    11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:27
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

21. Query Time: 0.78 ms After last query: 1.60 ms Query memory: 0.009 MB Memory before query: 14.971 MB Rows returned: 55

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_company_events`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_company_events`

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    Checking permissions	0.12 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.08 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:19
    15	JTableEvent->__construct()	JROOT/libraries/src/Table/Table.php:320
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:87
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

22. Query Time: 1.21 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 15.063 MB Rows returned: 1

    select co.*, et.name as eventType, et.id as eventTypeId, cu.currency_name as currencyName, bcm.markerLocation as categoryMarker,
    					GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias 
      ORDER BY cg.name separator '#|') as categories
    					
      from josok_jbusinessdirectory_company_events co
    					
      left join  josok_jbusinessdirectory_company_event_types et 
      on co.type=et.id
    					
      left join  josok_jbusinessdirectory_company_event_category ec 
      on ec.eventId=co.id
    					
      left join  josok_jbusinessdirectory_categories cg 
      on cg.id=ec.categoryId 
      and cg.published=1  
    					
      left join  josok_jbusinessdirectory_currencies cu 
      on co.currency_id = cu.currency_id
    					
      left join josok_jbusinessdirectory_companies cp 
      on co.company_id = cp.id
    					
      left join josok_jbusinessdirectory_orders inv 
      on inv.company_id=cp.id 
    					
      left join josok_jbusinessdirectory_packages p 
      on (inv.package_id=p.id 
      and p.status=1) or (p.price=0 
      and p.status=1)
    					
      left join josok_jbusinessdirectory_package_fields pf 
      on p.id=pf.package_id
    					
      left join josok_jbusinessdirectory_categories bcm 
      on bcm.id=co.main_subcategory 
      and bcm.published=1
    					
      where co.id='245'  
      and (
    										(
    											(inv.state= 1 
      and (
    												(
    													(( now() between inv.start_date 
      and inv.end_date) or p.expiration_type=1)
    													or
    													(now() between inv.start_trial_date 
      and inv.end_trial_date)
    												)
    											))
    										)
    										or (
    											((p.expiration_type=1 
      and p.price=0) or (p.id = cp.package_id 
      and p.price=0)))
    								) 
      and pf.feature='company_events'  
      and cp.state=1 
      and (cp.approved = 2 or cp.approved= -1) 
      and (co.approved = 1)
    					
      group by co.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	co	const	PRIMARY,idx_company	PRIMARY	4	const	1
    1	SIMPLE	et	const	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	cp	const	PRIMARY,idx_state,idx_approved,idx_package	PRIMARY	4	const	1
    1	SIMPLE	inv	system	idx_company	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	bcm	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	ec	ref	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	merinonsw_joo117.ec.categoryId	1	Using where
    1	SIMPLE	cu	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	p	ref	PRIMARY,idx_status,idx_price	idx_status	1	const	2	Using where
    1	SIMPLE	pf	ref	idx_package_id	idx_package_id	5	merinonsw_joo117.p.id	8	Using where

    Profile

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.10 ms
    Optimizing	0.05 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.11 ms
    Executing	0.01 ms
    Sending data	0.15 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 ms
    End of update loop	0.10 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:580
    14	JTableEvent->getActiveEvent()	JROOT/components/com_jbusinessdirectory/models/event.php:88
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

23. Query Time: 0.38 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 15.075 MB Rows returned: 0

    select * 
      from josok_jbusinessdirectory_company_event_pictures 
      where eventId=245 
      and picture_enable=1 
      order by id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_jbusinessdirectory_company_event_pictures	ref	idx_event,idx_status	idx_event	4	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:735
    14	JTableEvent->getEventPictures()	JROOT/components/com_jbusinessdirectory/models/event.php:96
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

24. Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 15.091 MB

    update  josok_jbusinessdirectory_company_events 
      set view_count = view_count + 1 
      where id=245

    Explain

    EXPLAIN not possible on query: update josok_jbusinessdirectory_company_events set view_count = view_count + 1 where id=245

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init for update	0.03 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:506
    15	JTableEvent->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/event.php:404
    14	JBusinessDirectoryModelEvent->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/event.php:97
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

25. Query Time: 0.61 ms After last query: 0.49 ms Query memory: 0.010 MB Memory before query: 15.120 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_statistics`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_statistics`

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.16 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Checking permissions	0.04 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.06 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/statistics.php:20
    17	JTableStatistics->__construct()	JROOT/libraries/src/Table/Table.php:320
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:36
    15	JBusinessDirectoryModelEvent->getTable()	JROOT/components/com_jbusinessdirectory/models/event.php:413
    14	JBusinessDirectoryModelEvent->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/event.php:97
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

26. Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 15.142 MB

    INSERT INTO `josok_jbusinessdirectory_statistics`
    (`id`,`item_id`,`item_type`,`date`,`type`) 
      VALUES 
    ('0','245','3','2021-10-24','0')

    Explain

    EXPLAIN not possible on query: INSERT INTO `josok_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) VALUES ('0','245','3','2021-10-24','0')

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init for update	0.01 ms
    Update	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.02 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1421
    17	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:813
    16	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Table/Table.php:925
    15	Joomla\CMS\Table\Table->save()	JROOT/components/com_jbusinessdirectory/models/event.php:414
    14	JBusinessDirectoryModelEvent->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/event.php:97
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

27. Query Time: 0.82 ms After last query: 2.03 ms Query memory: 0.009 MB Memory before query: 15.358 MB Rows returned: 75

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_companies`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_companies`

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.16 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    Checking permissions	0.17 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:25
    15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:320
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:100
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

28. Query Time: 0.16 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 15.478 MB

    
      SET SESSION group_concat_max_len = 10000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len = 10000

    Profile

    Status	Duration
    Starting	0.06 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5523
    15	JBusinessUtil::setGroupConcatLenght()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:110
    14	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/event.php:101
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

29. Query Time: 0.88 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 15.488 MB Rows returned: 1

    select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName, GROUP_CONCAT(DISTINCT ct.company_view separator ',') as companyView,
    				GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
      ORDER BY cg.lft separator '#|') as categories,  
    				cr.country_name,GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures,
    				ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
    				
      from josok_jbusinessdirectory_companies bc 
    				
      left join josok_jbusinessdirectory_company_types ct 
      on find_in_set(ct.id,bc.typeId)
    				
      left join josok_jbusinessdirectory_company_category cc 
      on bc.id=cc.companyId 
    				
      left join josok_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
    				
      left join josok_jbusinessdirectory_categories ccm 
      on ccm.id=bc.mainSubcategory 
      and ccm.published=1
    				
      left join josok_jbusinessdirectory_countries as cr 
      on cr.id = bc.countryId 
    				
      left join josok_jbusinessdirectory_company_pictures cpt 
      on cpt.companyId=bc.id 
      and cpt.picture_enable = 1
    				
      where bc.id=278 
      group by bc.id 
      order by name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	bc	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ct	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where
    1	SIMPLE	cc	ref	PRIMARY,idx_category	PRIMARY	4	const	1	Using index
    1	SIMPLE	cg	eq_ref	PRIMARY	PRIMARY	4	merinonsw_joo117.cc.categoryId	1	Using where
    1	SIMPLE	ccm	eq_ref	PRIMARY,idx_state	PRIMARY	4	const	1	Using where
    1	SIMPLE	cr	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	cpt	ref	idx_companyId	idx_companyId	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.12 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 ms
    End of update loop	0.04 ms
    Removing tmp table	0.01 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:128
    14	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/event.php:101
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

30. Query Time: 0.77 ms After last query: 0.55 ms Query memory: 0.010 MB Memory before query: 15.544 MB Rows returned: 38

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_packages`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_packages`

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.20 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Checking permissions	0.10 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.09 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:21
    17	JTablePackage->__construct()	JROOT/libraries/src/Table/Table.php:320
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:36
    15	JBusinessDirectoryModelEvent->getTable()	JROOT/components/com_jbusinessdirectory/models/event.php:465
    14	JBusinessDirectoryModelEvent->getPackage()	JROOT/components/com_jbusinessdirectory/models/event.php:103
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

31. Query Time: 0.30 ms After last query: 0.10 ms Query memory: 0.008 MB Memory before query: 15.607 MB Rows returned: 1

    select id, package_id 
      from josok_jbusinessdirectory_companies 
      where id= 278

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:220
    15	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/event.php:466
    14	JBusinessDirectoryModelEvent->getPackage()	JROOT/components/com_jbusinessdirectory/models/event.php:103
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

32. Query Time: 1.13 ms After last query: 0.03 ms Query memory: 0.008 MB Memory before query: 15.618 MB Rows returned: 1

    select * , inv.id as invoice_id,  max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS 
    				
      from josok_jbusinessdirectory_packages p
    				
      left join josok_jbusinessdirectory_orders inv 
      on p.id=inv.package_id 
      and inv.company_id=278 
    				
      left join josok_jbusinessdirectory_package_fields pf 
      on p.id=pf.package_id
    				
      where p.status=1  
      and (
    							(
    								(inv.state= 1 
      and (
    									(
    										(( now() between inv.start_date 
      and inv.end_date) or p.expiration_type=1)
    										or
    										(now() between inv.start_trial_date 
      and inv.end_trial_date)
    									)
    								))
    							)
    							or (
    								((p.expiration_type=1 
      and p.price=0) or (p.id = 2 
      and p.price=0)))
    						) 
    				
      group by p.id
    				
      order by p.price desc, ordering desc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	p	ref	PRIMARY,idx_status,idx_price	idx_status	1	const	2	Using where; Using temporary; Using filesort
    1	SIMPLE	inv	ref	idx_company,idx_package	idx_company	4	const	1	Using where
    1	SIMPLE	pf	ref	idx_package_id	idx_package_id	5	merinonsw_joo117.p.id	8

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting for group	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.43 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.08 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:250
    15	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/event.php:466
    14	JBusinessDirectoryModelEvent->getPackage()	JROOT/components/com_jbusinessdirectory/models/event.php:103
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

33. Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 15.642 MB Rows returned: 0

    select * 
      from  josok_jbusinessdirectory_company_attachments 
      where type=3  
      and status=1  
      and object_id=245 
      ORDER BY ordering asc, name,path

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_jbusinessdirectory_company_attachments	ref	idx_type,idx_object,idx_status	idx_object	5	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/attachments.php:38
    14	JBusinessDirectoryAttachments::getAttachments()	JROOT/components/com_jbusinessdirectory/models/event.php:127
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

34. Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.008 MB Memory before query: 15.658 MB Rows returned: 64

    SELECT id, name, listing_config as config 
      FROM josok_jbusinessdirectory_default_attributes

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
    15	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:4588
    14	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/event.php:135
    13	JBusinessDirectoryModelEvent->getEventData()	JROOT/components/com_jbusinessdirectory/models/event.php:67
    12	JBusinessDirectoryModelEvent->getEvent()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:40
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

35. Query Time: 0.60 ms After last query: 0.46 ms Query memory: 0.009 MB Memory before query: 15.726 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_event_attributes`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_event_attributes`

    Profile

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Checking permissions	0.04 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.02 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventattributes.php:19
    15	JTableEventAttributes->__construct()	JROOT/libraries/src/Table/Table.php:320
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:36
    13	JBusinessDirectoryModelEvent->getTable()	JROOT/components/com_jbusinessdirectory/models/event.php:163
    12	JBusinessDirectoryModelEvent->getEventAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:47
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

36. Query Time: 1.02 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 15.745 MB Rows returned: 2

    select a.*,
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR '|#')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from josok_jbusinessdirectory_attributes a
    		          
      left join josok_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join josok_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join josok_jbusinessdirectory_event_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.event_id=245
    		          
    		          
      where a.status = 1 
      and a.attribute_type = 3
    				  
      group by a.id
    		          
      order by a.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_status,idx_attribute_type	idx_attribute_type	1	const	2	Using where; Using temporary; Using filesort
    1	SIMPLE	at	eq_ref	PRIMARY	PRIMARY	4	merinonsw_joo117.a.type	1	Using where
    1	SIMPLE	ao	ALL	idx_attribute_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	ca	ref	event_UNIQUE	event_UNIQUE	8	const,merinonsw_joo117.a.id	11	Using index

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Creating tmp table	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    Creating sort index	0.22 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.09 ms
    Creating sort index	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventattributes.php:48
    13	JTableEventAttributes->getEventAttributes()	JROOT/components/com_jbusinessdirectory/models/event.php:171
    12	JBusinessDirectoryModelEvent->getEventAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:47
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

37. Query Time: 0.59 ms After last query: 0.49 ms Query memory: 0.009 MB Memory before query: 15.778 MB Rows returned: 2

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_company_event_associated_items`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_company_event_associated_items`

    Profile

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Checking permissions	0.03 ms
    Closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:19
    15	JTableEventAssociatedCompanies->__construct()	JROOT/libraries/src/Table/Table.php:320
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:36
    13	JBusinessDirectoryModelEvent->getTable()	JROOT/components/com_jbusinessdirectory/models/event.php:276
    12	JBusinessDirectoryModelEvent->getAssociatedCompanies()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:50
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

38. Query Time: 1.25 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 15.794 MB Rows returned: 0

    select DISTINCT cp.* 
                        
      from josok_jbusinessdirectory_companies cp 
                        
      left join josok_jbusinessdirectory_orders inv 
      on inv.company_id=cp.id
                        
      left join josok_jbusinessdirectory_packages p 
      on (inv.package_id=p.id 
      and p.status=1 
      and 1) or (p.price=0 
      and (p.expiration_type=1 or cp.package_id = p.id) 
      and p.status=1 
      and 1)
                        
      WHERE cp.id IN (
                        select eac.company_id 
                        
      from josok_jbusinessdirectory_companies c
                        
      left join josok_jbusinessdirectory_company_event_associated_items eac  
                        
      on eac.company_id=c.id  
      where eac.event_id=245
                        ) 
      and cp.state = 1  
      and (
    								(
    									(inv.state= 1 
      and (
    										(
    											(( now() between inv.start_date 
      and inv.end_date) or p.expiration_type=1)
    											or
    											(now() between inv.start_trial_date 
      and inv.end_trial_date)
    										)
    									))
    								)
    								or (
    									((p.expiration_type=1 
      and p.price=0) or (p.id = cp.package_id 
      and p.price=0)))
    							) 
      and (cp.approved = 2 or cp.approved= -1)   
      and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
      and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)   
    					
      order by cp.name

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	eac	ref	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
    1	PRIMARY	cp	eq_ref	PRIMARY,idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	PRIMARY	4	merinonsw_joo117.eac.company_id	1	Using where
    1	PRIMARY	inv	ALL	idx_company	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	merinonsw_joo117.eac.company_id	1	Using index; Distinct
    1	PRIMARY	p	ref	PRIMARY,idx_status,idx_price	idx_status	1	const	2	Using where; Distinct

    Profile

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.20 ms
    Preparing	0.06 ms
    Creating tmp table	0.07 ms
    Sorting result	0.04 ms
    Executing	0.01 ms
    Sending data	0.37 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:175
    13	JTableEventAssociatedCompanies->getAssociatedCompaniesDetails()	JROOT/components/com_jbusinessdirectory/models/event.php:281
    12	JBusinessDirectoryModelEvent->getAssociatedCompanies()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:50
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

39. Query Time: 0.61 ms After last query: 0.39 ms Query memory: 0.009 MB Memory before query: 15.805 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `josok_jbusinessdirectory_event_videos`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `josok_jbusinessdirectory_event_videos`

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Checking permissions	0.03 ms
    Closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventvideos.php:24
    15	JTableEventVideos->__construct()	JROOT/libraries/src/Table/Table.php:320
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/event.php:36
    13	JBusinessDirectoryModelEvent->getTable()	JROOT/components/com_jbusinessdirectory/models/event.php:380
    12	JBusinessDirectoryModelEvent->getEventVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:55
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

40. Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 15.819 MB Rows returned: 0

    select * 
      from josok_jbusinessdirectory_event_videos 
      where eventId=245 
      ORDER BY id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_jbusinessdirectory_event_videos	ref	ids_eventId	ids_eventId	5	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventvideos.php:55
    13	JTableEventVideos->getEventVideos()	JROOT/components/com_jbusinessdirectory/models/event.php:381
    12	JBusinessDirectoryModelEvent->getEventVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:55
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

41. Query Time: 0.29 ms After last query: 2.77 ms Query memory: 0.013 MB Memory before query: 16.058 MB Rows returned: 1
    Duplicate queries: #42

    SELECT `alias`
    
      FROM `josok_jbusinessdirectory_company_events`
    
      WHERE id = '245'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    26	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:170
    25	JBusinessDirectoryRouter->getEventSegment()	Same as call in the line below.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/views/event/tmpl/default_style_1.php:31
    15	include JROOT/components/com_jbusinessdirectory/views/event/tmpl/default_style_1.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php:25
    13	include JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:62
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

42. Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.013 MB Memory before query: 16.070 MB Rows returned: 1
    Duplicate queries: #41

    SELECT `alias`
    
      FROM `josok_jbusinessdirectory_company_events`
    
      WHERE id = '245'

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    27	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:170
    26	JBusinessDirectoryRouter->getEventSegment()	Same as call in the line below.
    25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
    23	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    22	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/views/event/tmpl/default_style_1.php:31
    15	include JROOT/components/com_jbusinessdirectory/views/event/tmpl/default_style_1.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php:25
    13	include JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:62
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

43. Query Time: 0.96 ms After last query: 4.18 ms Query memory: 0.010 MB Memory before query: 16.292 MB Rows returned: 20

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM josok_modules AS m
    
      LEFT JOIN josok_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN josok_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-10-24 10:34:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-10-24 10:34:22') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 502 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.51 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php:32
    13	include JROOT/components/com_jbusinessdirectory/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/event/view.html.php:62
    10	JBusinessDirectoryViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:86
    6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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.]

    ---

44. Query Time: 0.76 ms After last query: 30.73 ms Query memory: 0.007 MB Memory before query: 17.809 MB Rows returned: 1

    SELECT *
    
      FROM `josok_sppagebuilder`
    
      WHERE `extension` = 'mod_sppagebuilder' 
      AND `extension_view` = 'module' 
      AND `view_id` = '114'

    Explain

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

    Profile

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:38
    12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:14
    11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

45. Query Time: 0.39 ms After last query: 2.56 ms Query memory: 0.008 MB Memory before query: 18.023 MB Rows returned: 1
    Duplicate queries: #46

    SELECT `template`
    
      FROM `josok_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:643
    14	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
    13	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:739
    12	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/modules/mod_sppagebuilder/tmpl/default.php:11
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

46. Query Time: 0.70 ms After last query: 30.83 ms Query memory: 0.008 MB Memory before query: 21.582 MB Rows returned: 1
    Duplicate queries: #45

    SELECT `template`
    
      FROM `josok_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profile

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

47. Query Time: 0.65 ms After last query: 3.52 ms Query memory: 0.009 MB Memory before query: 21.949 MB Rows returned: 7

    SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
    
      FROM (
    SELECT id,title,level,published,parent_id,lft,rgt
    
      FROM josok_tags
    
      WHERE `published` = '1') AS a
    
      LEFT JOIN `josok_tags` AS b 
      ON a.lft > b.lft 
      AND a.rgt < b.rgt
    
      WHERE `a`.`level` != '0'
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_tags	ALL	tag_idx	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where; Using temporary; Using filesort
    1	SIMPLE	b	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	Range checked for each record (index map: 0x10); Distinct

    Profile

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
    15	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

48. Query Time: 0.51 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 21.956 MB Rows returned: 0
    Duplicate queries: #49  #50

    SELECT a.enabled
    
      FROM `josok_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

49. Query Time: 0.45 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 21.970 MB Rows returned: 0
    Duplicate queries: #48  #50

    SELECT a.enabled
    
      FROM `josok_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
    14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

50. Query Time: 0.50 ms After last query: 0.85 ms Query memory: 0.009 MB Memory before query: 22.097 MB Rows returned: 0
    Duplicate queries: #48  #49

    SELECT a.enabled
    
      FROM `josok_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
    14	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

51. Query Time: 0.49 ms After last query: 17.24 ms Query memory: 0.009 MB Memory before query: 24.150 MB Rows returned: 1

    SELECT a.enabled
    
      FROM `josok_extensions` AS `a`
    
      WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
    15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

52. Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 24.161 MB Rows returned: 1

    SELECT `e`.`manifest_cache`
    
      FROM `josok_extensions` AS `e`
    
      WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529
    16	SpPgaeBuilderBase::getExtensionVersion()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475
    15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

53. Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 24.170 MB Rows returned: 13

    SELECT `listid`,`name`
    
      FROM `josok_acymailing_list`
    
      WHERE `published` = '1'
    
      ORDER BY name DESC

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492
    15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
    14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    12	AddonParser::viewAddons()	JROOT/modules/mod_sppagebuilder/tmpl/default.php:26
    11	require JROOT/modules/mod_sppagebuilder/tmpl/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16
    10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

54. Query Time: 0.44 ms After last query: 18.94 ms Query memory: 0.006 MB Memory before query: 25.507 MB Rows returned: 0

    SELECT *
     
      FROM josok_jmap_metainfo
     
      WHERE `linkurl` = 'https://merinonsw.com.au/event/245-hilltop-mudgee-
      on-property-sale'
     
      AND `published` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	josok_jmap_metainfo	ref	published	published	1	const	1	Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:429
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

55. Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 25.513 MB Rows returned: 0

    SELECT *
     
      FROM josok_jmap_canonicals
     
      WHERE `linkurl` = 'https://merinonsw.com.au/event/245-hilltop-mudgee-
      on-property-sale'

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:507
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

56. Query Time: 0.19 ms After last query: 2.48 ms Query memory: 0.004 MB Memory before query: 25.709 MB

    LOCK TABLES `josok_extensions` WRITE

    Explain

    EXPLAIN not possible on query: LOCK TABLES `josok_extensions` WRITE

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:551
    8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/osmembershipupdatestatus/osmembershipupdatestatus.php:77
    7	plgSystemOSMembershipUpdateStatus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

57. Query Time: 3.65 ms After last query: 0.03 ms Query memory: 0.004 MB Memory before query: 25.714 MB

    UPDATE josok_extensions
    
      SET params = '{\"cache_time\":\"1\",\"last_run\":1635071662}'
    
      WHERE `element` = "osmembershipupdatestatus" 
      AND `folder` = "system"

    Explain

    EXPLAIN not possible on query: UPDATE josok_extensions SET params = '{\"cache_time\":\"1\",\"last_run\":1635071662}' WHERE `element` = "osmembershipupdatestatus" AND `folder` = "system"

    Profile

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    Init for update	0.05 ms
    Updating	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	3.35 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/osmembershipupdatestatus/osmembershipupdatestatus.php:88
    7	plgSystemOSMembershipUpdateStatus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

58. Query Time: 0.20 ms After last query: 1.23 ms Query memory: 0.004 MB Memory before query: 25.816 MB

    UNLOCK TABLES

    Explain

    EXPLAIN not possible on query: UNLOCK TABLES

    Profile

    Status	Duration
    Starting	0.08 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:926
    8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/osmembershipupdatestatus/osmembershipupdatestatus.php:100
    7	plgSystemOSMembershipUpdateStatus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

59. Query Time: 0.39 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 25.822 MB Rows returned: 0

    SELECT a.id
    
      FROM josok_osmembership_subscribers AS a
    
      INNER JOIN josok_osmembership_plans AS b 
      ON a.plan_id = b.id
    
      WHERE b.lifetime_membership != 1 
      AND a.published = 1 
      AND a.to_date < UTC_TIMESTAMP()
    
      ORDER BY a.id 
      LIMIT 100

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    8	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershipupdatestatus/osmembershipupdatestatus.php:151
    7	plgSystemOSMembershipUpdateStatus->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---

60. Query Time: 0.31 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 25.823 MB Rows returned: 0

    SELECT *
     
      FROM josok_jmap_headings
     
      WHERE `linkurl` = 'https://merinonsw.com.au/event/245-hilltop-mudgee-
      on-property-sale'

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.03 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:816
    7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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.]

    ---