Magnetawan Area Business Association

Featured Businesses

First Choice Landscaping 2010

4817 Hwy 124 RR#2, Magnetawan, Ontario, Canada

(705) 387-1850

First Choice Landscaping 2010

Sound Software

11 Meadowcrest Dr, Parry Sound, Ontario, Canada

888-545-0004

http://soundsoftware.ca/

Sound Software

BCGD

0 Gibson, Parry Sound, Ontario, Canada

705-300-3244

http://bradycarpentergraphicdesigner.ca/

BCGD

Brenda King, Sales Representative, Century 21 Blue Sky Region Realty Inc., Brokerage

86 Main Street, Sundridge, Ontario, Canada

(705) 384-4500

http://www.century21.ca/brenda.king

Brenda King, Sales Representative, Century 21 Blue Sky Region Realty Inc., Brokerage

YOU CREATE

Then, use the registration form to create your business listing page.

Our registration processis simple. You can do it yourself or we can do it for you. Give your prospects the information they need to find you. Describe your business, tell them where you are located, how you can be contacted. Feel free to add images, business hours and even video.

Your customers are sure to easily find you.

WE PUBLISH

Your business listing goes online.

You get your account login and password so you can modify any time your business details. If you have any trouble we are available any time by email or phone to help you set up, design and list your business.

You also get a free lisitng in the Magnetawan Area Businesses Booklet.

YOU ARE FOUND

As soon as it goes online, your business listing page becomes visible to everyone.

Our platofrm is fully responsive so anyone using any device will be ablie to easily see your listing.
Your company gets visibility and ranking both on our website and on all national and international search engines.

You start getting leads and valuable traffic is driven to you.

Ready to create your business listing

Add business now

Latest Offers

Your coupon or offer could be here. Contact us to list.

Come Explore

So whether you're a summer cottager, a local resident or up for a fall or winter getaway in Magnetawan your visit is sure to leave you feeling richer, relaxed and well cared for.

COME EXPLORE Magnetawan.

Local Towns

In the Community

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1786963059,
                "last": 1786963059,
                "now": 1786963059
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 2.70 ms / 2.70 ms Memory: 2.002 MB / 2.37 MB Application: afterLoad

Time: 16.25 ms / 18.94 ms Memory: 4.722 MB / 7.09 MB Application: afterInitialise

Time: 4.85 ms / 23.80 ms Memory: 0.964 MB / 8.06 MB Application: afterRoute

Time: 2.13 ms / 25.93 ms Memory: 0.106 MB / 8.16 MB Application: beforeRenderComponent com_sppagebuilder

Time: 4.46 ms / 30.38 ms Memory: 0.791 MB / 8.96 MB Application: Before Access::preloadComponents (all components)

Time: 1.53 ms / 31.92 ms Memory: 0.059 MB / 9.01 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 31.95 ms Memory: 0.000 MB / 9.01 MB Application: Before Access::getAssetRules (id:180 name:com_sppagebuilder)

Time: 1.22 ms / 33.18 ms Memory: 0.009 MB / 9.02 MB Application: After Access::getAssetRules (id:180 name:com_sppagebuilder)

Time: 16.48 ms / 49.66 ms Memory: 0.865 MB / 9.89 MB Application: beforeRenderModule mod_jbusinessdirectory (JBusinessDirectory Search - No map)

Time: 5.82 ms / 55.48 ms Memory: 0.448 MB / 10.33 MB Application: afterRenderModule mod_jbusinessdirectory (JBusinessDirectory Search - No map)

Time: 0.49 ms / 55.97 ms Memory: 0.000 MB / 10.30 MB Application: beforeRenderModule mod_jbusiness_latest (JBusinessDirectory - Latest Businesses Slider)

Time: 14.98 ms / 70.95 ms Memory: 0.520 MB / 10.82 MB Application: afterRenderModule mod_jbusiness_latest (JBusinessDirectory - Latest Businesses Slider)

Time: 0.59 ms / 71.54 ms Memory: 0.000 MB / 10.81 MB Application: beforeRenderModule mod_jbusiness_offers (JBusinessDirectory - Offers)

Time: 15.16 ms / 86.70 ms Memory: 0.472 MB / 11.28 MB Application: afterRenderModule mod_jbusiness_offers (JBusinessDirectory - Offers)

Time: 0.12 ms / 86.82 ms Memory: 0.000 MB / 11.20 MB Application: afterRenderComponent com_sppagebuilder

Time: 0.76 ms / 87.58 ms Memory: 0.010 MB / 11.21 MB Application: afterDispatch

Time: 6.55 ms / 94.13 ms Memory: 1.265 MB / 12.47 MB Application: beforeRenderModule mod_customcss (Custom CSS)

Time: 0.08 ms / 94.21 ms Memory: 0.006 MB / 12.48 MB Application: afterRenderModule mod_customcss (Custom CSS)

Time: 0.03 ms / 94.24 ms Memory: 0.000 MB / 12.48 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 0.80 ms / 95.04 ms Memory: 0.031 MB / 12.51 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.03 ms / 95.07 ms Memory: 0.000 MB / 12.51 MB Application: beforeRenderModule mod_search (Search)

Time: 0.35 ms / 95.42 ms Memory: 0.014 MB / 12.52 MB Application: afterRenderModule mod_search (Search)

Time: 0.05 ms / 95.47 ms Memory: 0.000 MB / 12.52 MB Application: beforeRenderModule mod_menu (In the Community)

Time: 0.32 ms / 95.78 ms Memory: 0.021 MB / 12.54 MB Application: afterRenderModule mod_menu (In the Community)

Time: 0.03 ms / 95.81 ms Memory: 0.000 MB / 12.54 MB Application: beforeRenderModule mod_menu (Local Towns)

Time: 0.22 ms / 96.03 ms Memory: 0.014 MB / 12.55 MB Application: afterRenderModule mod_menu (Local Towns)

Time: 0.02 ms / 96.05 ms Memory: 0.000 MB / 12.55 MB Application: beforeRenderModule mod_custom (Come Explore)

Time: 0.17 ms / 96.22 ms Memory: 0.006 MB / 12.55 MB Application: afterRenderModule mod_custom (Come Explore)

Time: 1.13 ms / 97.35 ms Memory: 0.453 MB / 13.01 MB Application: afterRender

Database queries total: 29.47 ms

Memory Usage

Database Queries

33 Queries Logged 29.47 ms

8 duplicate found!

2 duplicates: #9 #10

2 duplicates: #24 #25

2 duplicates: #26 #27

2 duplicates: #28 #29

Query Time: 0.36 ms Query memory: 0.023 MB Memory before query: 4.448 MB Rows returned: 0

SELECT `data`

  FROM `qgvsi_session`

  WHERE `session_id` = X'3261323662386338633739616164666364303063656437366664313430386461'

Explain

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

Profile

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php: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

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

Query Time: 0.14 ms After last query: 0.51 ms Query memory: 0.020 MB Memory before query: 4.675 MB Rows returned: 0

SELECT `session_id`

  FROM `qgvsi_session`

  WHERE `session_id` = X'3261323662386338633739616164666364303063656437366664313430386461' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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

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

Query Time: 0.22 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.680 MB

INSERT INTO `qgvsi_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3261323662386338633739616164666364303063656437366664313430386461', 1, 1786963059, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `qgvsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3261323662386338633739616164666364303063656437366664313430386461', 1, 1786963059, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.51 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 4.927 MB Rows returned: 39

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

  FROM `qgvsi_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.52 ms Query memory: 0.021 MB Memory before query: 5.170 MB Rows returned: 5

SELECT id, rules

  FROM `qgvsi_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.25 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 5.182 MB Rows returned: 2

SELECT b.id

  FROM qgvsi_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.54 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 5.204 MB Rows returned: 85

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

  FROM qgvsi_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_extensions	NULL	ref	extension	extension	82	const	108	0.43	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 0.81 ms After last query: 4.61 ms Query memory: 0.048 MB Memory before query: 7.124 MB Rows returned: 19

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

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

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

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php: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.69 ms After last query: 2.06 ms Query memory: 0.086 MB Memory before query: 8.015 MB Rows returned: 1

Duplicate queries: #10

SELECT fas.*, df.*, c.currency_name, c.currency_id 
  FROM qgvsi_jbusinessdirectory_applicationsettings fas
					
  inner join  qgvsi_jbusinessdirectory_date_formats df 
  on fas.date_format_id=df.id
					
  inner join  qgvsi_jbusinessdirectory_currencies c 
  on fas.currency_id=c.currency_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	df	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/components/com_jbusinessdirectory/assets/utils.php:68
10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:55
9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:38
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.24 ms After last query: 0.02 ms Query memory: 0.079 MB Memory before query: 8.028 MB Rows returned: 1

Duplicate queries: #9

SELECT fas.*, df.*, c.currency_name, c.currency_id 
  FROM qgvsi_jbusinessdirectory_applicationsettings fas
					
  inner join  qgvsi_jbusinessdirectory_date_formats df 
  on fas.date_format_id=df.id
					
  inner join  qgvsi_jbusinessdirectory_currencies c 
  on fas.currency_id=c.currency_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	df	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/assets/utils.php:73
10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:55
9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:38
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.25 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.048 MB Rows returned: 0

SELECT * 
  FROM qgvsi_jbusinessdirectory_categories c 
  where c.type=1 
  and c.alias = '' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_alias	idx_alias	302	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:166
9	plgSystemUrlTranslator->getCategoryParms()	JROOT/plugins/system/urltranslator/urltranslator.php:84
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.24 ms After last query: 0.01 ms Query memory: 0.038 MB Memory before query: 8.053 MB Rows returned: 0

SELECT * 
  FROM `qgvsi_jbusinessdirectory_companies` c 
  where c.alias = '' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_alis	idx_alis	302	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:124
9	plgSystemUrlTranslator->getBusinessListingParms()	JROOT/plugins/system/urltranslator/urltranslator.php:86
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.21 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 8.081 MB Rows returned: 1

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

  FROM `qgvsi_extensions`

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

Explain

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

Profile

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

Call Stack

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

UPDATE `qgvsi_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.25 ms After last query: 0.34 ms Query memory: 0.020 MB Memory before query: 8.096 MB Rows returned: 1

SELECT *

  FROM qgvsi_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.42 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 8.106 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM qgvsi_template_styles as s

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.34 ms After last query: 4.88 ms Query memory: 0.029 MB Memory before query: 8.961 MB Rows returned: 39

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `qgvsi_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jbusinessdirectory','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	149	26.85	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.28 ms After last query: 1.53 ms Query memory: 0.023 MB Memory before query: 9.023 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM qgvsi_sppagebuilder as a

  LEFT JOIN `qgvsi_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN qgvsi_users AS ua 
  ON ua.id = a.created_user_id

  WHERE a.id = 7 
  AND a.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	l	NULL	const	idx_langcode	idx_langcode	28	const	0	0.00	unique row not found
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
11	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.73 ms After last query: 13.09 ms Query memory: 0.025 MB Memory before query: 9.873 MB Rows returned: 1

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

  FROM qgvsi_modules AS m

  WHERE m.published = 1 
  AND m.id = 122 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-17 10:37:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-17 10:37:39') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/addons/module/site.php:56
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 3.01 ms Query memory: 0.035 MB Memory before query: 10.273 MB Rows returned: 26

SELECT * 
  FROM qgvsi_jbusinessdirectory_categories 
  where parent_id=1 
  and published=1  
  order by name

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_categories	NULL	ref	idx_parent,idx_state	idx_parent	4	const	25	96.30	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusinessdirectory/helper.php:24
20	modJBusinessDirectoryHelper::getMainCategories()	JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:56
19	include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.46 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 10.326 MB Rows returned: 0

SELECT c.* 
  FROM qgvsi_jbusinessdirectory_categories c
                   
  inner join  qgvsi_jbusinessdirectory_categories  cc  
  on c.parent_id = cc.id  
  where c.parent_id!=1  
  and cc.parent_id = 1 
  and c.published=1
                   
  order by c.name 
  LIMIT 0, 1000

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	idx_parent,idx_state	idx_parent	4	NULL	3	96.30	Using index condition; Using where; Using filesort
1	SIMPLE	cc	NULL	eq_ref	PRIMARY,idx_parent	PRIMARY	4	magarea_db.c.parent_id	1	92.59	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusinessdirectory/helper.php:33
20	modJBusinessDirectoryHelper::getSubCategories()	JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:58
19	include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.31 ms After last query: 1.98 ms Query memory: 0.025 MB Memory before query: 10.289 MB Rows returned: 1

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

  FROM qgvsi_modules AS m

  WHERE m.published = 1 
  AND m.id = 110 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-17 10:37:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-17 10:37:39') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/addons/module/site.php:56
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 7.94 ms After last query: 3.42 ms Query memory: 0.045 MB Memory before query: 10.702 MB Rows returned: 4

select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), slec.featured) as featured
				
  from (
				select  cp.id, cp.name, cp.alias, cp.short_description, cp.description, cp.street_number, cp.address, cp.city, cp.county, cp.website, cp.phone, cp.email, cp.state, cp.fax,
				cp.averageRating, cp.slogan, cp.logoLocation, cp.creationDate,
				cp.featured,cp.publish_only_city, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, cnt.contact_name,
				GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames,
				GROUP_CONCAT(DISTINCT pf.feature) as features,
				bc.name as mainCategory,  bc.id as mainCategoryId
				
  from qgvsi_jbusinessdirectory_companies cp
				
  left join qgvsi_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId
				
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId
				
  left join qgvsi_jbusinessdirectory_categories bc 
  on bc.id=cp.mainSubcategory
				
  left join qgvsi_jbusinessdirectory_company_contact cnt 
  on cp.id=cnt.companyId
				
  left join qgvsi_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id
				
  left join qgvsi_jbusinessdirectory_company_types ct 
  on cp.typeId=ct.id
				
  left join qgvsi_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id
				
  left join qgvsi_jbusinessdirectory_packages p 
  on (inv.package_id=p.id ) or (p.id=cp.package_id 
  and p.price=0)
				
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
				
  where 1     
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= 0)  
				
  group by cp.id 
  order by cp.name) as slec
				
  left join qgvsi_jbusinessdirectory_company_ratings cra 
  on cra.companyId=companyId1
				
  group by companyId1 
				 
  having featured  = 1
				
  order by  rand() 
  LIMIT 0, 30

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	cra	NULL	system	idx_company	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	220	100.00	Using temporary; Using filesort
2	DERIVED	cp	NULL	ref	PRIMARY,idx_state,idx_approved	idx_state	2	const	35	70.00	Using where; Using temporary; Using filesort
2	DERIVED	cc	NULL	ref	PRIMARY,idx_category	PRIMARY	4	magarea_db.cp.id	1	100.00	Using index
2	DERIVED	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	NULL
2	DERIVED	bc	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.mainSubcategory	1	100.00	NULL
2	DERIVED	cnt	NULL	ref	R_13	R_13	4	magarea_db.cp.id	1	100.00	NULL
2	DERIVED	cn	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.countryId	1	100.00	NULL
2	DERIVED	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.typeId	1	100.00	Using index condition
2	DERIVED	inv	NULL	ref	idx_company	idx_company	4	magarea_db.cp.id	1	100.00	NULL
2	DERIVED	p	NULL	ALL	PRIMARY,idx_price	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Range checked for each record (index map: 0x9)
2	DERIVED	pf	NULL	ref	idx_package_id	idx_package_id	5	magarea_db.p.id	9	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_latest/helper.php:90
20	modJBusinessLatestHelper::getList()	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:45
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.34 ms After last query: 1.92 ms Query memory: 0.030 MB Memory before query: 10.737 MB Rows returned: 1

Duplicate queries: #25

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '83'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
31	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
30	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.15 ms After last query: 0.12 ms Query memory: 0.032 MB Memory before query: 10.751 MB Rows returned: 1

Duplicate queries: #24

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '83'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
32	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
31	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
30	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
29	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
28	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
27	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.13 ms After last query: 0.14 ms Query memory: 0.030 MB Memory before query: 10.768 MB Rows returned: 1

Duplicate queries: #27

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '39'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
31	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
30	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.17 ms After last query: 0.04 ms Query memory: 0.032 MB Memory before query: 10.783 MB Rows returned: 1

Duplicate queries: #26

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '39'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
32	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
31	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
30	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
29	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
28	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
27	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.15 ms After last query: 0.18 ms Query memory: 0.030 MB Memory before query: 10.800 MB Rows returned: 1

Duplicate queries: #29

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '41'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
31	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
30	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.14 ms After last query: 0.09 ms Query memory: 0.032 MB Memory before query: 10.815 MB Rows returned: 1

Duplicate queries: #28

SELECT `alias`

  FROM `qgvsi_jbusinessdirectory_companies`

  WHERE id = '41'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
32	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
31	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
30	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
29	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
28	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
27	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php:51
20	require JROOT/templates/j-directory/html/mod_jbusiness_latest/default_slider.php	JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php:64
19	include JROOT/modules/mod_jbusiness_latest/mod_jbusiness_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.32 ms After last query: 0.32 ms Query memory: 0.025 MB Memory before query: 10.800 MB Rows returned: 1

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

  FROM qgvsi_modules AS m

  WHERE m.published = 1 
  AND m.id = 112 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-17 10:37:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-17 10:37:39') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/addons/module/site.php:56
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 3.42 ms After last query: 6.02 ms Query memory: 0.038 MB Memory before query: 10.865 MB Rows returned: 52

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_offers`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:23
25	JTableOffer->__construct()	JROOT/libraries/src/Table/Table.php:312
24	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_jbusiness_offers/helper.php:60
23	modJBusinessOffersHelper::getList()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
20	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_jbusiness_offers/mod_jbusiness_offers.php:38
19	include JROOT/modules/mod_jbusiness_offers/mod_jbusiness_offers.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 3.89 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 10.938 MB Rows returned: 0

select co.id, co.subject, co.short_description, co.address, co.main_subcategory, co.city, co.county, co.province, co.area, co.street_number, co.postalCode, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.show_time, co.created, co.type, co.companyId,
				    co.price, co.specialPrice, co.currencyId, co.countryId, co.price_text,
					op.picture_info, cg.markerLocation as categoryMaker, op.picture_path,
					GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color  
  ORDER BY cg.name separator '#|') as categories,
					 co.featured as featured  ,
					cp.phone, cp.name as company_name, cp.id as company_id, cp.alias as company_alias
					
					
  from
					qgvsi_jbusinessdirectory_company_offers co
					
  left join  qgvsi_jbusinessdirectory_company_offer_pictures op 
  on co.id=op.offerId
					
  and
						(op.id in (
								select  min(op1.id) as min 
  from qgvsi_jbusinessdirectory_company_offers co1
								
  left join  qgvsi_jbusinessdirectory_company_offer_pictures op1 
  on co1.id=op1.offerId
								
  where op1.picture_enable=1
								
  group by co1.id
							)
						)
					
  left join qgvsi_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId
					
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join qgvsi_jbusinessdirectory_companies cp 
  on co.companyId = cp.id
					
					
  left join qgvsi_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id 
					
  left join qgvsi_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and p.status=1) or (p.price=0 
  and p.status=1)
					
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
					
  left join qgvsi_jbusinessdirectory_package_fields pf2 
  on p.id=pf2.package_id  
  where co.state=1 
  and co.approved !=-1 
					     
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and co.publish_start_time<=time(now()) or co.publish_start_date!=DATE(now())) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
		      
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and co.publish_end_time>=time(now()) or co.publish_end_date!=DATE(now())) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )   
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) 
  and (co.approved = 0 or co.approved = 1)  
  and (co.approved = 0 or co.approved = 1) 
					    
					
  group by co.id
					
					
  order by featured desc,  rand() 
  LIMIT 0, 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	co	NULL	ref	PRIMARY,idx_company,idx_search,idx_approved	idx_search	1	const	2	37.34	Using index condition; Using where; Using temporary; Using filesort
1	PRIMARY	cp	NULL	eq_ref	PRIMARY,idx_state,idx_approved	PRIMARY	4	magarea_db.co.companyId	1	35.71	Using where
1	PRIMARY	inv	NULL	ref	idx_company	idx_company	4	magarea_db.co.companyId	1	100.00	NULL
1	PRIMARY	p	NULL	ref	PRIMARY,idx_status,idx_price	idx_status	1	const	1	100.00	Using where
1	PRIMARY	op	NULL	ref	idx_offer	idx_offer	4	magarea_db.co.id	4	100.00	Using where
1	PRIMARY	cc	NULL	ref	PRIMARY	PRIMARY	4	magarea_db.co.id	3	100.00	Using index
1	PRIMARY	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	Using where
1	PRIMARY	pf	NULL	ref	idx_package_id	idx_package_id	5	magarea_db.p.id	9	100.00	Using index
1	PRIMARY	pf2	NULL	ref	idx_package_id	idx_package_id	5	magarea_db.p.id	9	100.00	Using index
2	DEPENDENT SUBQUERY	co1	NULL	index	PRIMARY	PRIMARY	4	NULL	3	100.00	Using index
2	DEPENDENT SUBQUERY	op1	NULL	ref	idx_offer	idx_offer	4	magarea_db.co1.id	4	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:594
24	JTableOffer->getOffersByCategories()	JROOT/modules/mod_jbusiness_offers/helper.php:61
23	modJBusinessOffersHelper::getList()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
20	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_jbusiness_offers/mod_jbusiness_offers.php:38
19	include JROOT/modules/mod_jbusiness_offers/mod_jbusiness_offers.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:81
17	sp_module_addon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:84
16	AddonParser::doAddonTag()	Same as call in the line below.
15	preg_replace_callback()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:32
14	AddonParser::spDoAddon()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:371
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:57
12	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
9	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:19
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.51 ms After last query: 6.38 ms Query memory: 0.027 MB Memory before query: 12.113 MB Rows returned: 11

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

  FROM qgvsi_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-17 10:37:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-17 10:37:39') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 437 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	57	1.75	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	magarea_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	magarea_db.m.id	1	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	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/ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:502
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:458
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:222
8	Helix3::generatelayout()	JROOT/templates/j-directory/index.php:154
7	require JROOT/templates/j-directory/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.]

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT `alias` 
  FROM `qgvsi_jbusinessdirectory_companies`

3 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM qgvsi_modules AS m

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

2 × SELECT fas.*, df.*, c.currency_name, c.currency_id 
  FROM qgvsi_jbusinessdirectory_applicationsettings fas
      
  inner join  qgvsi_jbusinessdirectory_date_formats df 
  on fas.date_format_id=df.id
      
  inner join  qgvsi_jbusinessdirectory_currencies c 
  on fas.currency_id=c.currency_i

1 × SELECT `data` 
  FROM `qgvsi_session`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `qgvsi_assets`

1 × select co.id, co.subject, co.short_description, co.address, co.main_subcategory, co.city, co.county, co.province, co.area, co.street_number, co.postalCode, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.show_time, co.created, co.type, co.companyId,
         co.price, co.specialPrice, co.currencyId, co.countryId, co.price_text,
      op.picture_info, cg.markerLocation as categoryMaker, op.picture_path,
      GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color  
  ORDER BY cg.name separator '#|') as categories,
       co.featured as featured  ,
      cp.phone, cp.name as company_name, cp.id as company_id, cp.alias as company_alias
      
      
  from
      qgvsi_jbusinessdirectory_company_offers co
      
  left join  qgvsi_jbusinessdirectory_company_offer_pictures op 
  on co.id=op.offerId
      
  and
       (op.id in (
         select  min(op1.id) as min 
  from qgvsi_jbusinessdirectory_company_offers co1
         
  left join  qgvsi_jbusinessdirectory_company_offer_pictures op1 
  on co1.id=op1.offerId

1 × select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), slec.featured) as featured     
  from (     select  cp.id, cp.name, cp.alias, cp.short_description, cp.description, cp.street_number, cp.address, cp.city, cp.county, cp.website, cp.phone, cp.email, cp.state, cp.fax,     cp.averageRating, cp.slogan, cp.logoLocation, cp.creationDate,     cp.featured,cp.publish_only_city, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, cnt.contact_name,     GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames,     GROUP_CONCAT(DISTINCT pf.feature) as features,     bc.name as mainCategory,  bc.id as mainCategoryId     
  from qgvsi_jbusinessdirectory_companies cp     
  left join qgvsi_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId     
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId     
  left join qgvsi_jbusinessdirectory_categories bc 
  on bc.id=cp.mainSubcategory     
  left join qgvsi_jbusinessdirectory_company_contact cnt 
  on cp.id=cnt.companyId     
  left join qgvsi_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id     
  left join qgvsi_jbusinessdirectory_company_types ct 
  on cp.typeId=ct.id     
  left join qgvsi_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id     
  left join qgvsi_jbusinessdirectory_packages p 
  on (inv.package_id=p.id ) or (p.id=cp.package_id 
  and p.price=0)     
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id

1 × SELECT c.* 
  FROM qgvsi_jbusinessdirectory_categories c
                    
  inner join  qgvsi_jbusinessdirectory_categories  cc  
  on c.parent_id = cc.id

1 × SELECT * 
  FROM qgvsi_jbusinessdirectory_categories

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM qgvsi_sppagebuilder as a 
  LEFT JOIN `qgvsi_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN qgvsi_users AS ua 
  ON ua.id = a.created_user_id

```
1 × SELECT * 
  FROM qgvsi_languages
```

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

1 × SELECT `session_id` 
  FROM `qgvsi_session`

1 × SELECT * 
  FROM `qgvsi_jbusinessdirectory_companies` c

1 × SELECT * 
  FROM qgvsi_jbusinessdirectory_categories c

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 qgvsi_menu AS m 
  LEFT JOIN qgvsi_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `qgvsi_viewlevels

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM qgvsi_modules AS m 
  LEFT JOIN qgvsi_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN qgvsi_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTHER Tables:

1 × INSERT INTO `qgvsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3261323662386338633739616164666364303063656437366664313430386461', 1, 1786963059, 0, '', 0

1 × UPDATE `qgvsi_extensions` 
  SET `params` = '{\"mediaversion\":\"d13b0498efc8b3db4bea724063797ef5\"}'

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_offers

Let's get started

Featured Businesses

First Choice Landscaping 2010

First Choice Landscaping 2010

Sound Software

Sound Software

BCGD

BCGD

Brenda King, Sales Representative, Century 21 Blue Sky Region Realty Inc., Brokerage

Brenda King, Sales Representative, Century 21 Blue Sky Region Realty Inc., Brokerage

YOU CREATE

WE PUBLISH

YOU ARE FOUND

Ready to create your business listing

Latest Offers

Come Explore

Local Towns

In the Community

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

33 Queries Logged 29.47 ms

8 duplicate found!

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: