Business Listings - Right Estate Commercial

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1722061417,
                "last": 1722061417,
                "now": 1722061417
            },
            "token": "eu1lj1aE1dC8RgGWwHPDatRGDneh3X0M"
        },
        "registry": {
            "com_jbusinessdirectory": {
                "listing": {
                    "search": {
                        "ordercol": null
                    }
                }
            }
        },
        "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
        },
        "menuId": "3350",
        "categorySearch": null,
        "searchkeyword": "",
        "searchkeywordLocation": "",
        "typeSearch": "",
        "citySearch": "",
        "starRating": "",
        "regionSearch": "",
        "countrySearch": "",
        "zipcode": "",
        "customAtrributes": "",
        "letter": "",
        "radius": "",
        "provinceSearch": "",
        "areaSearch": "",
        "filter-by-fav": "",
        "filterParams": "",
        "location": "",
        "geo-latitude": "",
        "geo-longitude": "",
        "geo-country": "",
        "geolocation": "",
        "categories": "",
        "onlyLocal": 0,
        "categoryId": null,
        "listing-search": true,
        "menuItemId": "3350",
        "showCustomMarkers": 1,
        "moreFilters": null,
        "lSearchType": 1
    }
}

Profile Information

Time

Memory

Time: 4.77 ms / 4.77 ms Memory: 0.402 MB / 0.75 MB Application: afterLoad

Time: 28.83 ms / 33.60 ms Memory: 1.205 MB / 1.95 MB Application: afterInitialise

Time: 18.57 ms / 52.17 ms Memory: 0.442 MB / 2.39 MB Application: afterRoute

Time: 0.72 ms / 52.89 ms Memory: 0.013 MB / 2.41 MB Application: beforeRenderComponent com_jbusinessdirectory

Time: 69.61 ms / 122.50 ms Memory: 2.159 MB / 4.57 MB Application: afterRenderComponent com_jbusinessdirectory

Time: 0.76 ms / 123.26 ms Memory: 0.007 MB / 4.57 MB Application: afterDispatch

Time: 41.71 ms / 164.97 ms Memory: 0.887 MB / 5.46 MB Application: beforeRenderModule mod_custom (Template copyright)

Time: 0.80 ms / 165.78 ms Memory: 0.006 MB / 5.47 MB Application: afterRenderModule mod_custom (Template copyright)

Time: 0.04 ms / 165.81 ms Memory: 0.000 MB / 5.46 MB Application: beforeRenderModule mod_custom (Footer Social Icon)

Time: 0.13 ms / 165.94 ms Memory: 0.004 MB / 5.47 MB Application: afterRenderModule mod_custom (Footer Social Icon)

Time: 0.03 ms / 165.97 ms Memory: 0.000 MB / 5.47 MB Application: beforeRenderModule mod_menu (infomation)

Time: 1.00 ms / 166.97 ms Memory: 0.037 MB / 5.51 MB Application: afterRenderModule mod_menu (infomation)

Time: 0.03 ms / 167.00 ms Memory: 0.000 MB / 5.50 MB Application: beforeRenderModule mod_custom (Footer Logo)

Time: 0.08 ms / 167.07 ms Memory: 0.003 MB / 5.50 MB Application: afterRenderModule mod_custom (Footer Logo)

Time: 0.02 ms / 167.10 ms Memory: 0.000 MB / 5.50 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 0.37 ms / 167.47 ms Memory: 0.010 MB / 5.51 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.03 ms / 167.49 ms Memory: 0.000 MB / 5.51 MB Application: beforeRenderModule mod_custom (Header page info)

Time: 0.06 ms / 167.56 ms Memory: 0.004 MB / 5.52 MB Application: afterRenderModule mod_custom (Header page info)

Time: 6.09 ms / 173.65 ms Memory: 0.782 MB / 6.30 MB Application: afterRender

Database queries total: 49.78 ms

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

Status	Duration
Starting	0.19 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
After opening tables	0.12 ms
System lock	0.02 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
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

#	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:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

EXPLAIN not possible on query: INSERT INTO `zofl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3737633065633835646164613831396534383231343533396562383533373266', 1, 1722061417, 0, '', 0)

Profile

Status	Duration
Starting	0.08 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 for update	0.02 ms
Update	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 0.67 ms After last query: 1.51 ms Query memory: 0.025 MB Memory before query: 1.080 MB Rows returned: 42

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

  FROM `zofl_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	zofl_extensions	ref	extension	extension	82	const	42	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.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 1.110 MB Rows returned: 5

SELECT id, rules

  FROM `zofl_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.122 MB Rows returned: 2

SELECT b.id

  FROM zofl_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.76 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 1.143 MB Rows returned: 110

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

  FROM zofl_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	zofl_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	250	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.49 ms After last query: 5.95 ms Query memory: 0.036 MB Memory before query: 1.501 MB Rows returned: 331

Duplicate queries: #48 #58 #61 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.09 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.94 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	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
Query end	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.547 MB Rows returned: 0

SELECT name,value

  FROM zofl_jsn_poweradmin_config

  WHERE 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jsn_poweradmin_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	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.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

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

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

Query Time: 0.41 ms After last query: 0.63 ms Query memory: 0.020 MB Memory before query: 1.526 MB Rows returned: 1

SELECT COUNT(*)

  FROM zofl_extensions

  WHERE element="jsnadminbar"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using where; Using index

Profile

Status	Duration
Starting	0.07 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.03 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:913
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105
7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 5.89 ms Query memory: 0.048 MB Memory before query: 1.975 MB Rows returned: 26

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM zofl_menu AS m

  LEFT JOIN zofl_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	126	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	u522904507_n17L5.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.10 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.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 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:76
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:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:64
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:491
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:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 3.47 ms Query memory: 0.022 MB Memory before query: 2.178 MB Rows returned: 0

SELECT `id`

  FROM `zofl_jbusinessdirectory_companies`

  WHERE alias = 'rightestatecommercial-2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jbusinessdirectory_companies	ref	idx_alias	idx_alias	303	const	1	Using index condition

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:355
12	JBusinessDirectoryRouter->getCompaniesId()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140
10	Joomla\CMS\Component\Router\Rules\StandardRules->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 2.202 MB Rows returned: 1

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

  FROM `zofl_extensions`

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

Explain

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

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.04 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 2.194 MB

UPDATE `zofl_extensions`

  SET `params` = '{\"mediaversion\":\"96b2e81c2d7d67db573bed2487965f82\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.02 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.04 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.38 ms Query memory: 0.092 MB Memory before query: 2.274 MB Rows returned: 364

SELECT fas.*
	                  
  FROM zofl_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	364

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.22 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 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/components/com_jbusinessdirectory/helpers/utils.php:67
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 2.529 MB Rows returned: 1

SELECT fas.*
	                  
  FROM zofl_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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 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.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:78
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 2.538 MB Rows returned: 1

SELECT fas.*
	                  
  FROM zofl_jbusinessdirectory_currencies fas
	                
  WHERE fas.currency_id ='47'

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.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.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:87
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 2.340 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM zofl_template_styles as s

  LEFT JOIN zofl_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	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	u522904507_n17L5.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 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/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
10	jsn_template_framework_class_loader()	Same as call in the line below.
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 2.369 MB Rows returned: 1

SELECT manifest_cache

  FROM zofl_extensions

  WHERE element LIKE 'jsn_reta_pro'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	10	Using index condition

Profile

Status	Duration
Starting	0.07 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.01 ms
Optimizing	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
10	jsn_template_framework_class_loader()	Same as call in the line below.
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 8.14 ms Query memory: 0.021 MB Memory before query: 2.388 MB Rows returned: 1

SELECT COUNT(*)

  FROM zofl_extensions

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

Explain

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

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.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.33 ms Query memory: 0.019 MB Memory before query: 2.397 MB Rows returned: 1

SELECT *

  FROM zofl_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

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.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 30.08 ms Query memory: 0.028 MB Memory before query: 3.231 MB Rows returned: 62

SELECT *
	                  
  FROM zofl_jbusinessdirectory_mobile_app_config

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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/components/com_jbusinessdirectory/helpers/utils.php:9380
15	JBusinessUtil::getMobileAppConfig()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:9399
14	JBusinessUtil::getMobileAppSettings()	JROOT/components/com_jbusinessdirectory/models/search.php:22
13	JBusinessDirectoryModelSearch->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.39 ms Query memory: 0.025 MB Memory before query: 3.317 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_default_attributes`

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 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.04 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	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
Query end	0.03 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:19
13	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5752
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:80
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 3.332 MB Rows returned: 70

SELECT id, name, listing_config as config 
  FROM zofl_jbusinessdirectory_default_attributes

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
12	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5753
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:80
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.96 ms After last query: 4.16 ms Query memory: 0.038 MB Memory before query: 3.358 MB Rows returned: 81

SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_companies`

Explain

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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 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.02 ms
After opening tables	0.01 ms
checking permissions	0.14 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:25
15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:650
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.18 ms Query memory: 0.008 MB Memory before query: 3.477 MB


  SET SQL_BIG_SELECTS=1

Explain

EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

Profile

Status	Duration
Starting	0.07 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:6864
16	JBusinessUtil::setBigSqlSelects()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1148
15	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:954
14	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:621
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:685
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.488 MB Rows returned: 2

select * 
  from 
					(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
					
					cp.id
					 

					
  from zofl_jbusinessdirectory_companies cp

					
					
					
					
					
					
					
					
					
					
					
					
					 
					
  where 1         
					      
  and cp.state=1 
  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)  
					         
					
  group by cp.id
					
  having 1 
					) s
					
  where 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3
2	DERIVED	cp	range	idx_state,idx_approved,idx_publish_start_date,idx_publish_end_date	idx_approved	1	NULL	3	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	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
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
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1155
15	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:954
14	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:621
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:685
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 3.483 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.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 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:6845
15	JBusinessUtil::setGroupConcatLenght()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1111
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:630
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:685
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 3.494 MB Rows returned: 2

select slec.* , companyName , featured
				 
  from (
					select 
					cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
								,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
					 
					 
					
  from zofl_jbusinessdirectory_companies cp
                    
					
  left join zofl_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
			   	    
  left join zofl_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1

			   	     
  left join zofl_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1 
				    
					
  left join zofl_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2  
					
					
					
					
					
					
					
					
					
					
  left join zofl_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id

                    
  left join zofl_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
                    
                    
					
                    
					
  left join zofl_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1
					
					
					
                    
  where 1 
  and  cp.state=1        
		       
  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)   
		        
		  
					
  group by cp.id 
				) as slec 
				
  where 1  
				
  having 1 
                 
  order by featured desc 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	42	Using filesort
2	DERIVED	bk	system	unq_bkm,idx_item_id,idx_user_id,idx_item_type	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
2	DERIVED	cp	range	idx_state,idx_approved,idx_publish_start_date,idx_publish_end_date	idx_approved	1	NULL	3	Using index condition; Using where
2	DERIVED	cc	ref	PRIMARY,idx_category	PRIMARY	4	u522904507_n17L5.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	u522904507_n17L5.cc.categoryId	1	Using where
2	DERIVED	cr	ref	idx_approved,idx_review_type,idx_item_id	idx_item_id	4	u522904507_n17L5.cp.id	2	Using where
2	DERIVED	ct	index	NULL	PRIMARY	4	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Statistics	0.02 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.18 ms
Executing	0.01 ms
Sending data	0.08 ms
Creating sort index	0.06 ms
Removing tmp table	0.02 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	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.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 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/company.php:1121
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:630
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:685
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.16 ms After last query: 0.06 ms Query memory: 0.042 MB Memory before query: 3.509 MB Rows returned: 2

select slec.* , companyName , featured
				 
  from (
					select 
					 cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,
					cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile, 
				cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,
				cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,
				cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,
				cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,
				cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,
				
				
				
				
				GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.lft separator '#|') as categories,
				GROUP_CONCAT( DISTINCT cg.id) as categoryIds,
					
				
				 bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker,bcm.icon as mainCategoryIcon, bcm.iconImgLocation as categoryIconImage, bcm.id as mainCategoryId, 
				
				 GROUP_CONCAT(DISTINCT ct.name) as typeName, 
				 bk.id as bookmark, 
				count(distinct cr.id) as nr_reviews,
				cn.country_name as countryName
				
				
					 
					 
					
  from zofl_jbusinessdirectory_companies cp
                    
					
  left join zofl_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
			   	    
  left join zofl_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1

			   	     
  left join zofl_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1 
				    
					
  left join zofl_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2  
					
					
					
					
					
					
					
					
					
					
  left join zofl_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id

                    
  left join zofl_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
                    
                    
					
                    
					
  left join zofl_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1
					
					
					
                    
  where 1 
  and  cp.id in (57,58)
					
  group by cp.id 
				) as slec 
				
  where 1  
				
                 
  order by featured desc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using filesort
2	DERIVED	bk	system	unq_bkm,idx_item_id,idx_user_id,idx_item_type	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
2	DERIVED	cp	range	PRIMARY	PRIMARY	4	NULL	2	Using index condition
2	DERIVED	cc	ref	PRIMARY,idx_category	PRIMARY	4	u522904507_n17L5.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	u522904507_n17L5.cc.categoryId	1	Using where
2	DERIVED	bcm	eq_ref	PRIMARY,idx_state	PRIMARY	4	u522904507_n17L5.cp.mainSubcategory	1	Using where
2	DERIVED	cr	ref	idx_approved,idx_review_type,idx_item_id	idx_item_id	4	u522904507_n17L5.cp.id	2	Using where
2	DERIVED	cn	eq_ref	PRIMARY	PRIMARY	4	u522904507_n17L5.cp.countryId	1	Using where
2	DERIVED	ct	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Statistics	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.33 ms
Executing	0.01 ms
Sending data	0.42 ms
Creating sort index	0.11 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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.02 ms
Removing tmp table	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 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/company.php:1134
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:630
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:685
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 9.78 ms Query memory: 0.028 MB Memory before query: 4.105 MB Rows returned: 13

SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_company_providers`

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 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.06 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	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
Query end	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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:17
17	JTableCompanyServiceProviders->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
15	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1349
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1410
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/search.php:715
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 4.129 MB Rows returned: 7

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from zofl_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 57 
  and cph.type = 0 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref	idx_provider_id,idx_item_type,idx_type	idx_provider_id	4	const	10	Using where; Using filesort

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.04 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
Removing tmp table	0.01 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.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1350
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1410
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/search.php:715
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 4.151 MB Rows returned: 0

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from zofl_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 57 
  and cph.type = 1 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref	idx_provider_id,idx_item_type,idx_type	idx_provider_id	4	const	10	Using where; Using filesort

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 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.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.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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/companyserviceproviders.php:62
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1392
14	JBusinessDirectoryModelCompanies->getBreakHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1411
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/search.php:715
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 4.172 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_company_attributes`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.29 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.02 ms
Preparing	0.02 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
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.12 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.13 ms
Reset for next command	0.02 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:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:19
15	JTableCompanyAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:752
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 4.189 MB Rows returned: 0

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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,
				  at.code as attributeTypeCode,
				  GROUP_CONCAT(DISTINCT ca.value 
  ORDER BY ca.value) as attributeValue
				  
  from zofl_jbusinessdirectory_attributes a 
		          
  left join zofl_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join zofl_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join zofl_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=57
		          
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

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.10 ms
checking permissions	0.11 ms
Opening tables	0.14 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.04 ms
Reset for next command	0.02 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/companyattributes.php:52
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:753
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 4.199 MB Rows returned: 7

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from zofl_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 58 
  and cph.type = 0 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref	idx_provider_id,idx_item_type,idx_type	idx_provider_id	4	const	9	Using where; Using filesort

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.03 ms
Statistics	0.07 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.02 ms
Removing tmp table	0.02 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.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.02 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/companyserviceproviders.php:62
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1350
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1410
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/search.php:715
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from zofl_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 58 
  and cph.type = 1 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref	idx_provider_id,idx_item_type,idx_type	idx_provider_id	4	const	9	Using where; Using filesort

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.02 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.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.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 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/companyserviceproviders.php:62
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1392
14	JBusinessDirectoryModelCompanies->getBreakHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1411
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/search.php:715
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 4.221 MB Rows returned: 0

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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,
				  at.code as attributeTypeCode,
				  GROUP_CONCAT(DISTINCT ca.value 
  ORDER BY ca.value) as attributeValue
				  
  from zofl_jbusinessdirectory_attributes a 
		          
  left join zofl_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join zofl_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join zofl_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=58
		          
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

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.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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:753
12	JBusinessDirectoryModelSearch->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 0.39 ms Query memory: 0.028 MB Memory before query: 4.232 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_attributes`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.02 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.02 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.07 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.12 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.02 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:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:19
15	JTableAttribute->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:1796
12	JBusinessDirectoryModelSearch->getCustomAttributeValues()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:120
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.89 ms Query memory: 0.023 MB Memory before query: 4.362 MB Rows returned: 1

SELECT DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM zofl_jbusinessdirectory_companies 
  WHERE approved=2 
  ORDER BY letter

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jbusinessdirectory_companies	ref	idx_approved	idx_approved	1	const	2	Using where; Using temporary; Using filesort

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.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1523
13	JTableCompany->getUsedLettersForActiveBusiness()	JROOT/components/com_jbusinessdirectory/models/search.php:2094
12	JBusinessDirectoryModelSearch->getUsedLetter()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:150
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.75 ms After last query: 0.87 ms Query memory: 0.026 MB Memory before query: 4.482 MB Rows returned: 11

Duplicate queries: #79

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM zofl_modules AS m

  LEFT JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN zofl_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 <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 3350 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	106	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	u522904507_n17L5.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	u522904507_n17L5.m.module,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
16	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
15	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
14	JModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:72
13	include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 1.15 ms Query memory: 0.029 MB Memory before query: 4.550 MB Rows returned: 1

Duplicate queries: #43

SELECT `alias`

  FROM `zofl_jbusinessdirectory_companies`

  WHERE id = '57'

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 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.01 ms
Unlocking tables	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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 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:246
26	JBusinessDirectoryRouter->getCompaniesSegment()	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/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:2175
16	JBusinessUtil::getCompanyLink()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:747
15	JBusinessUtil::prepareCompaniesMapLocations()	JROOT/components/com_jbusinessdirectory/include/search-map.php:87
14	require JROOT/components/com_jbusinessdirectory/include/search-map.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:338
13	include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.06 ms Query memory: 0.029 MB Memory before query: 4.563 MB Rows returned: 1

Duplicate queries: #42

SELECT `alias`

  FROM `zofl_jbusinessdirectory_companies`

  WHERE id = '57'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
28	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:246
27	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
24	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/components/com_jbusinessdirectory/router.php:195
23	JBusinessDirectoryRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:2175
16	JBusinessUtil::getCompanyLink()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:747
15	JBusinessUtil::prepareCompaniesMapLocations()	JROOT/components/com_jbusinessdirectory/include/search-map.php:87
14	require JROOT/components/com_jbusinessdirectory/include/search-map.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:338
13	include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 4.580 MB Rows returned: 1

Duplicate queries: #45

SELECT `alias`

  FROM `zofl_jbusinessdirectory_companies`

  WHERE id = '58'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jbusinessdirectory_companies	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.02 ms
Optimizing	0.01 ms
Statistics	0.03 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 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:246
26	JBusinessDirectoryRouter->getCompaniesSegment()	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/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:2175
16	JBusinessUtil::getCompanyLink()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:747
15	JBusinessUtil::prepareCompaniesMapLocations()	JROOT/components/com_jbusinessdirectory/include/search-map.php:87
14	require JROOT/components/com_jbusinessdirectory/include/search-map.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:338
13	include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.029 MB Memory before query: 4.593 MB Rows returned: 1

Duplicate queries: #44

SELECT `alias`

  FROM `zofl_jbusinessdirectory_companies`

  WHERE id = '58'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jbusinessdirectory_companies	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.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
28	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:246
27	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
24	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/components/com_jbusinessdirectory/router.php:195
23	JBusinessDirectoryRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:2175
16	JBusinessUtil::getCompanyLink()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:747
15	JBusinessUtil::prepareCompaniesMapLocations()	JROOT/components/com_jbusinessdirectory/include/search-map.php:87
14	require JROOT/components/com_jbusinessdirectory/include/search-map.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:338
13	include JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 6.85 ms Query memory: 0.023 MB Memory before query: 4.664 MB Rows returned: 0

SELECT m.id

  FROM zofl_modules AS m

  INNER JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -3350) 
  AND m.position IN ("topbar", "logo", "top", "header-right", "toolbar", "mainmenu", "nav-bar", "promo-
  left", "promo", "promo-right", "content-top-over", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom-over", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer1", "footer2", "footer3", "background", "debug", "brand", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	206	Using where
1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	u522904507_n17L5.m.id,const	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_reta_pro/template_custom.php:23
11	include_once JROOT/templates/jsn_reta_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_reta_pro/index.php:18
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 4.673 MB Rows returned: 0

SELECT m.id

  FROM zofl_modules AS m

  INNER JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid = 3350 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -3350)) 
  AND m.position IN ("topbar", "logo", "top", "header-right", "toolbar", "mainmenu", "nav-bar", "promo-
  left", "promo", "promo-right", "content-top-over", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom-over", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer1", "footer2", "footer3", "background", "debug", "brand", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	index	PRIMARY,published,newsfeeds	PRIMARY	4	NULL	206	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	u522904507_n17L5.m.id	1	Using where; Using index

Profile

Status	Duration
Starting	0.09 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.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_reta_pro/template_custom.php:23
11	include_once JROOT/templates/jsn_reta_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_reta_pro/index.php:18
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 1.56 ms Query memory: 0.038 MB Memory before query: 4.678 MB Rows returned: 331

Duplicate queries: #8 #58 #61 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
Starting	0.08 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.81 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	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
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
12	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784
11	JSNTplHelper::checkMegamenuTable()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25
10	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
9	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.687 MB Rows returned: 1

Duplicate queries: #59 #62

SELECT COUNT(*)

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='en-gb'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47
10	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
9	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.693 MB Rows returned: 1

Duplicate queries: #60 #63

SELECT *

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='*'

  ORDER BY modified DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jsn_tplframework_megamenu	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.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68
10	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
9	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 3.74 ms Query memory: 0.027 MB Memory before query: 4.817 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=537 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.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.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 4.832 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=539 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.09 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.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 4.844 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=538 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.857 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=540 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 4.869 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=543 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.882 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=541 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.08 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.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.894 MB Rows returned: 0

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access

  FROM zofl_modules AS m

  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.id=550 
  AND m.client_id= 0 
  AND m.published = 1 
  AND m.access IN (1,1,5)

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.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:169
25	JSNTplMMShortcodeModule->loadModule()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/elements/module/module.php:124
24	JSNTplMMShortcodeModule->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
23	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
22	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
21	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
20	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/column/column.php:81
19	JSNTplMMShortcodeColumn->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
18	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
17	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
16	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
15	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/shortcodes/layout/row/row.php:120
14	JSNTplMMShortcodeRow->elementShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:931
13	JSNTplMMHelperShortcode::shortcodeToMegamenuFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:890
12	JSNTplMMHelperShortcode::doShortcodeTagFrontend()	Same as call in the line below.
11	preg_replace_callback()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/shortcode.php:875
10	JSNTplMMHelperShortcode::doShortcodeFrontend()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:824
9	JSNTplTemplateMegamenu::renderShortcode()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:119
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 0.05 ms Query memory: 0.038 MB Memory before query: 4.892 MB Rows returned: 331

Duplicate queries: #8 #48 #61 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

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.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.78 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	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
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
13	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784
12	JSNTplHelper::checkMegamenuTable()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872
10	JSNTplTemplateMegamenu::getMenuType()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.901 MB Rows returned: 1

Duplicate queries: #49 #62

SELECT COUNT(*)

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='en-gb'

Explain

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

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.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872
10	JSNTplTemplateMegamenu::getMenuType()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.908 MB Rows returned: 1

Duplicate queries: #50 #63

SELECT *

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='*'

  ORDER BY modified DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jsn_tplframework_megamenu	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.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.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872
10	JSNTplTemplateMegamenu::getMenuType()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.19 ms After last query: 0.04 ms Query memory: 0.038 MB Memory before query: 4.911 MB Rows returned: 331

Duplicate queries: #8 #48 #58 #76

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

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
Filling schema table	0.01 ms
checking permissions	0.74 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	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
Query end	0.01 ms
Starting cleanup	0.02 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
13	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784
12	JSNTplHelper::checkMegamenuTable()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
10	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 4.920 MB Rows returned: 1

Duplicate queries: #49 #59

SELECT COUNT(*)

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='en-gb'

Explain

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

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.02 ms
Statistics	0.01 ms
Preparing	0.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
10	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 4.927 MB Rows returned: 1

Duplicate queries: #50 #60

SELECT *

  FROM `zofl_jsn_tplframework_megamenu`

  WHERE style_id='9' 
  AND LOWER(language_code)='*'

  ORDER BY modified DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jsn_tplframework_megamenu	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.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.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68
11	JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783
10	JSNTplTemplateMegamenu::megamenuItems()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.19 ms Query memory: 0.052 MB Memory before query: 4.949 MB Rows returned: 408

Select * 
  from zofl_osrs_configuration

Explain

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

Profile

Status	Duration
Starting	0.07 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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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/components/com_osproperty/helpers/helper.php:27
18	OSPHelper::loadConfig()	JROOT/components/com_osproperty/router.php:25
17	OspropertyBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:249
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 5.210 MB Rows returned: 1

Select * 
  from zofl_osrs_currencies 
  where id = '56'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_osrs_currencies	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.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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:38
18	OSPHelper::loadConfig()	JROOT/components/com_osproperty/router.php:25
17	OspropertyBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:249
9	JSNTplTemplateMegamenu::getMenuList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120
8	JSNTplTemplateMegamenu::render()	JROOT/templates/jsn_reta_pro/index.php:279
7	require JROOT/templates/jsn_reta_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.74 ms Query memory: 0.020 MB Memory before query: 5.026 MB Rows returned: 0

SELECT assets, legacy

  FROM zofl_jsn_poweradmin_menu_assets

  WHERE type='css' 
  AND menuId='3350'

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
8	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:209
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 5.031 MB Rows returned: 0

SELECT assets, legacy

  FROM zofl_jsn_poweradmin_menu_assets

  WHERE type='js' 
  AND menuId='3350'

Explain

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

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.02 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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
8	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:210
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 5.036 MB Rows returned: 1

Duplicate queries: #71

SELECT parent_id

  FROM zofl_menu

  WHERE id='3350'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_menu	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.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
9	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 5.041 MB Rows returned: 0

SELECT assets, legacy

  FROM zofl_jsn_poweradmin_menu_assets

  WHERE type='css' 
  AND menuId='1'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 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/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #73

SELECT parent_id

  FROM zofl_menu

  WHERE id='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_menu	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.01 ms
Optimizing	0.02 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.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:215
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #68

SELECT parent_id

  FROM zofl_menu

  WHERE id='3350'

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 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
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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
9	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 5.057 MB Rows returned: 0

SELECT assets, legacy

  FROM zofl_jsn_poweradmin_menu_assets

  WHERE type='js' 
  AND menuId='1'

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #70

SELECT parent_id

  FROM zofl_menu

  WHERE id='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_menu	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.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.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
8	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:248
7	plgSystemJsnpoweradmin->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 5.078 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `zofl_extensions`

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 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.07 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	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
Query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
10	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
9	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/pagebuilder/pagebuilder.php:68
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 5.106 MB Rows returned: 1

Duplicate queries: #80

SELECT *

  FROM zofl_extensions

  WHERE `element` = 'jsnframework' 
  AND `type` = 'plugin' 
  AND `folder` = 'system'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/pagebuilder/pagebuilder.php:71
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 0.26 ms Query memory: 0.036 MB Memory before query: 5.110 MB Rows returned: 331

Duplicate queries: #8 #48 #58 #61

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

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
Filling schema table	0.01 ms
checking permissions	0.77 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	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
Query end	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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/pagebuilder/pagebuilder.php:135
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 5.155 MB Rows returned: 2

SELECT name,value

  FROM zofl_jsn_pagebuilder_config

  WHERE 1

Explain

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

Profile

Status	Duration
Starting	0.07 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.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/pagebuilder/pagebuilder.php:135
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 3.31 ms Query memory: 0.023 MB Memory before query: 5.527 MB Rows returned: 3

SELECT `name`, `value`

  FROM `zofl_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_jsn_imageshow_config	range	name	name	767	NULL	3	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.02 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_imageshow/classes/jsn_is_parameter.php:81
14	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
13	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
12	require_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/jsnpagebuilder/defaultelements/imageshow/imageshow.php:32
11	JSNPBShortcodeImageShow->__construct()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:105
10	JSNPagebuilderHelpersElements->registerElements()	JROOT/administrator/components/com_pagebuilder/helpers/elements.php:38
9	JSNPagebuilderHelpersElements->__construct()	JROOT/plugins/system/pagebuilder/pagebuilder.php:424
8	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:150
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 5.28 ms Query memory: 0.022 MB Memory before query: 5.977 MB Rows returned: 11

Duplicate queries: #41

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM zofl_modules AS m

  LEFT JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN zofl_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 <= '2024-07-27 06:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 06:23:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 3350 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	106	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	u522904507_n17L5.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	u522904507_n17L5.m.module,const	1	Using index condition; 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.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.51 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
9	JModuleHelper::getModuleList()	JROOT/plugins/system/pagebuilder/pagebuilder.php:431
8	plgSystemPagebuilder::loadElementAssets()	JROOT/plugins/system/pagebuilder/pagebuilder.php:150
7	plgSystemPagebuilder->onBeforeRender()	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:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 4.80 ms Query memory: 0.021 MB Memory before query: 5.621 MB Rows returned: 1

Duplicate queries: #75

SELECT *

  FROM zofl_extensions

  WHERE `element` = 'jsnframework' 
  AND `type` = 'plugin' 
  AND `folder` = 'system'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zofl_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.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
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/pagebuilder/pagebuilder.php:226
7	plgSystemPagebuilder->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:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

49 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access 
  FROM zofl_modules AS m 
  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

4 × SELECT assets, legacy 
  FROM zofl_jsn_poweradmin_menu_assets

4 × SELECT parent_id 
  FROM zofl_menu

4 × select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours,                    GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses                   
  from zofl_jbusinessdirectory_company_provider_hours as cph

4 × SELECT `alias` 
  FROM `zofl_jbusinessdirectory_companies`

3 × SELECT * 
  FROM `zofl_jsn_tplframework_megamenu`

3 × SELECT COUNT(*) 
  FROM `zofl_jsn_tplframework_megamenu`

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM zofl_modules AS m 
  LEFT JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN zofl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

```
2 × SELECT * 
  FROM zofl_extensions
```

2 × SELECT COUNT(*) 
  FROM zofl_extensions

2 × SELECT m.id 
  FROM zofl_modules AS m 
  INNER JOIN zofl_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT `data` 
  FROM `zofl_session`

1 × 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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,       at.code as attributeTypeCode,       GROUP_CONCAT(DISTINCT ca.value 
  ORDER BY ca.value) as attributeValue       
  from zofl_jbusinessdirectory_attributes a              
  left join zofl_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type             
  left join zofl_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id             
  left join zofl_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=58

1 × SELECT DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM zofl_jbusinessdirectory_companies

1 × Select * 
  from zofl_osrs_configuratio

1 × Select * 
  from zofl_osrs_currencies

1 × SELECT name,value 
  FROM zofl_jsn_pagebuilder_config

1 × 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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,       at.code as attributeTypeCode,       GROUP_CONCAT(DISTINCT ca.value 
  ORDER BY ca.value) as attributeValue       
  from zofl_jbusinessdirectory_attributes a              
  left join zofl_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type             
  left join zofl_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id             
  left join zofl_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=57

1 × select slec.* , companyName , featured      
  from (      select       cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering         ,GROUP_CONCAT( DISTINCT cg.id) as categoryIds                    
  from zofl_jbusinessdirectory_companies cp                           
  left join zofl_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId             
  left join zofl_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1              
  left join zofl_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1                
  left join zofl_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2                                                              
  left join zofl_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id                      
  left join zofl_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)                                                                           
  left join zofl_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1

1 × select slec.* , companyName , featured      
  from (      select        cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,      cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile,      cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,     cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,     cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,     cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,     cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,                         GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.lft separator '#|') as categories,     GROUP_CONCAT( DISTINCT cg.id) as categoryIds,                 bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker,bcm.icon as mainCategoryIcon, bcm.iconImgLocation as categoryIconImage, bcm.id as mainCategoryId,            GROUP_CONCAT(DISTINCT ct.name) as typeName,       bk.id as bookmark,      count(distinct cr.id) as nr_reviews,     cn.country_name as countryName                              
  from zofl_jbusinessdirectory_companies cp                           
  left join zofl_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId             
  left join zofl_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1              
  left join zofl_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1                
  left join zofl_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2                                                              
  left join zofl_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id                      
  left join zofl_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)                                                                           
  left join zofl_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1

1 × SELECT fas.*                    
  FROM zofl_jbusinessdirectory_application_settings fa

1 × SELECT id, rules 
  FROM `zofl_viewlevels

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

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

1 × SELECT name,value 
  FROM zofl_jsn_poweradmin_config

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM zofl_menu AS m 
  LEFT JOIN zofl_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `id` 
  FROM `zofl_jbusinessdirectory_companies`

1 × SELECT fas.*                    
  FROM zofl_jbusinessdirectory_date_formats fas

1 × SELECT `session_id` 
  FROM `zofl_session`

1 × SELECT fas.*                    
  FROM zofl_jbusinessdirectory_currencies fas

1 × SELECT id, home, template, s.params 
  FROM zofl_template_styles as s 
  LEFT JOIN zofl_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT manifest_cache 
  FROM zofl_extensions

```
1 × SELECT * 
  FROM zofl_languages
```

1 × SELECT *                    
  FROM zofl_jbusinessdirectory_mobile_app_confi

1 × SELECT id, name, listing_config as config 
  FROM zofl_jbusinessdirectory_default_attribute

1 × select * 
  from       (select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,            cp.id              
  from zofl_jbusinessdirectory_companies cp

1 × SELECT `name`, `value` 
  FROM `zofl_jsn_imageshow_config`

OTHER Tables:

```
5 × SHOW TABLE
```

1 × INSERT INTO `zofl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3737633065633835646164613831396534383231343533396562383533373266', 1, 1722061417, 0, '', 0

1 × UPDATE `zofl_extensions` 
  SET `params` = '{\"mediaversion\":\"96b2e81c2d7d67db573bed2487965f82\"}'

1 × SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_default_attributes

1 × SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_companies

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × 
  SET SESSION group_concat_max_len = 1000

1 × SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_company_providers

1 × SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_company_attributes

1 × SHOW FULL COLUMNS 
  FROM `zofl_jbusinessdirectory_attributes

1 × SHOW FULL COLUMNS 
  FROM `zofl_extensions

1. Right Estate

2. Right Estate

infomation

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

80 Queries Logged 49.78 ms

23 duplicate found!

49 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Maps detected!

1. Right Estate

2. Right Estate

infomation

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

80 Queries Logged 49.78 ms

23 duplicate found!

49 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: