Sound Software

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1786965374,
                "last": 1786965374,
                "now": 1786965374
            },
            "token": "0smEVRDc1iskgK0VH0IXipdsIwL0WrBj"
        },
        "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
        }
    }
}

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

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

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

id	select_type	table	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

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

EXPLAIN not possible on query: INSERT INTO `qgvsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6535633338636462386532636433343337383761646532626331636263386336', 1, 1786965374, 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.36 ms After last query: 0.55 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.15 ms After last query: 0.50 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.19 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.79 ms After last query: 0.15 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.69 ms After last query: 4.66 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.43 ms After last query: 2.35 ms Query memory: 0.086 MB Memory before query: 8.017 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.23 ms After last query: 0.02 ms Query memory: 0.079 MB Memory before query: 8.030 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.17 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 8.050 MB Rows returned: 0

SELECT * 
  FROM qgvsi_jbusinessdirectory_categories c 
  where c.type=1 
  and c.alias = 'sound-software' 
  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.20 ms After last query: 0.01 ms Query memory: 0.040 MB Memory before query: 8.055 MB Rows returned: 1

SELECT * 
  FROM `qgvsi_jbusinessdirectory_companies` c 
  where c.alias = 'sound-software' 
  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.20 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 8.083 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.27 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 8.073 MB

UPDATE `qgvsi_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `qgvsi_extensions` SET `params` = '{\"mediaversion\":\"a1940a9b7bc82cbdec59df9f71e0f2e9\"}' 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.20 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 8.098 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.26 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 8.108 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.64 ms After last query: 7.35 ms Query memory: 0.026 MB Memory before query: 10.504 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_default_attributes`

Explain

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

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()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:21
13	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/assets/utils.php:2901
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:80
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 10.519 MB Rows returned: 40

Duplicate queries: #33

SELECT * 
  FROM qgvsi_jbusinessdirectory_default_attributes

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:32
12	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/assets/utils.php:2902
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:80
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 0.45 ms Query memory: 0.038 MB Memory before query: 10.906 MB Rows returned: 66

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_companies`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:27
15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:28
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 0.46 ms Query memory: 0.030 MB Memory before query: 11.000 MB Rows returned: 27

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_packages`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:23
16	JTablePackage->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
14	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:484
13	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:40
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #71

select id, package_id 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:204
14	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:485
13	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:40
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 11.047 MB Rows returned: 0

Duplicate queries: #72

select * , inv.id as invoice_id,  max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS 
				
  from qgvsi_jbusinessdirectory_packages p
				
  left join qgvsi_jbusinessdirectory_orders inv 
  on p.id=inv.package_id 
  and inv.company_id=83 
				
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
				
  where p.status=1  
  and (
									  (
										(inv.state= 1 
  and (
											(
												(now() > (inv.start_date) 
  and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1 ))
									 			or
												(now() > (inv.start_trial_date) 
  and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY)))
									 ))
									)
									or (
										((p.expiration_type=1 
  and p.price=0) or (p.id = 0 
  and p.price=0)))
								) 
				
  group by p.id
				
  order by p.price desc, ordering desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	system	PRIMARY,idx_status,idx_price	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	inv	NULL	ref	idx_company,idx_package	idx_company	4	const	1	25.00	Using where
1	SIMPLE	pf	NULL	ref	idx_package_id	idx_package_id	5	const	9	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:233
14	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:485
13	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:40
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.03 ms Query memory: 0.040 MB Memory before query: 11.052 MB Rows returned: 1

Duplicate queries: #26

select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName,
				GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,  
				cr.country_name,
				ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
				
  from qgvsi_jbusinessdirectory_companies bc 
				
  left join qgvsi_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,bc.typeId)
				
  left join qgvsi_jbusinessdirectory_company_category cc 
  on bc.id=cc.companyId 
				
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
				
  left join qgvsi_jbusinessdirectory_categories ccm 
  on ccm.id=bc.mainSubcategory 
  and ccm.published=1
				
  left join qgvsi_jbusinessdirectory_countries as cr 
  on cr.id = bc.countryId 
				
  where bc.id=83 
  group by bc.id 
  order by name

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ct	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where
1	SIMPLE	cc	NULL	ref	PRIMARY,idx_category	PRIMARY	4	const	2	100.00	Using index
1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	NULL
1	SIMPLE	ccm	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	cr	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:127
13	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/companies.php:42
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.47 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 11.074 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_providers`

Explain

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

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/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:20
17	JTableCompanyServiceProviders->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
15	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1192
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1253
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:49
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 11.095 MB Rows returned: 0

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:34
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1193
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1253
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:49
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.08 ms Query memory: 0.041 MB Memory before query: 11.113 MB Rows returned: 1

Duplicate queries: #23

select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName,
				GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,  
				cr.country_name,
				ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
				
  from qgvsi_jbusinessdirectory_companies bc 
				
  left join qgvsi_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,bc.typeId)
				
  left join qgvsi_jbusinessdirectory_company_category cc 
  on bc.id=cc.companyId 
				
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
				
  left join qgvsi_jbusinessdirectory_categories ccm 
  on ccm.id=bc.mainSubcategory 
  and ccm.published=1
				
  left join qgvsi_jbusinessdirectory_countries as cr 
  on cr.id = bc.countryId 
				
  where bc.id=83 
  group by bc.id 
  order by name

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ct	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where
1	SIMPLE	cc	NULL	ref	PRIMARY,idx_category	PRIMARY	4	const	2	100.00	Using index
1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	NULL
1	SIMPLE	ccm	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	cr	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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:127
15	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/companies.php:1201
14	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1253
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:49
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:34
15	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1235
14	JBusinessDirectoryModelCompanies->getBreakHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1254
13	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:49
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.36 ms After last query: 0.57 ms Query memory: 0.028 MB Memory before query: 11.517 MB Rows returned: 19

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_categories`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:29
15	JBusinessTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:65
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 11.547 MB Rows returned: 1

select * 
  from qgvsi_jbusinessdirectory_categories c
				 
  where c.id=84

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:53
13	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.48 ms After last query: 0.22 ms Query memory: 0.028 MB Memory before query: 11.561 MB Rows returned: 15

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_locations`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companylocations.php:21
15	JTableCompanyLocations->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:93
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 11.586 MB Rows returned: 0

select a.*,b.country_name as country 
  from qgvsi_jbusinessdirectory_company_locations a
				  
  left join qgvsi_jbusinessdirectory_countries b 
  on a.countryId = b.id
				  
  where company_id=83

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companylocations.php:35
13	JTableCompanyLocations->getCompanyLocations()	JROOT/components/com_jbusinessdirectory/models/companies.php:94
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select * 
  from  qgvsi_jbusinessdirectory_company_attachments 
  where type=1  
  and status=1  
  and object_id=83 
  ORDER BY name,path

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_attachments	NULL	ref	idx_type,idx_object	idx_object	5	const	1	9.39	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/helpers/attachments.php:37
13	JBusinessDirectoryAttachments::getAttachments()	JROOT/components/com_jbusinessdirectory/models/companies.php:116
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 11.607 MB Rows returned: 40

Duplicate queries: #18

SELECT * 
  FROM qgvsi_jbusinessdirectory_default_attributes

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:32
14	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/assets/utils.php:2902
13	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/companies.php:122
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:87
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 0.34 ms Query memory: 0.026 MB Memory before query: 11.608 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_attributes`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:21
15	JTableCompanyAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:346
12	JBusinessDirectoryModelCompanies->getCompanyAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:88
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 11.623 MB


  SET SESSION group_concat_max_len =1000000

Explain

EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

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/database.php:33
14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/companies.php:354
12	JBusinessDirectoryModelCompanies->getCompanyAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:88
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 11.631 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.ordering asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
				  GROUP_CONCAT(ao.icon 
  ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from qgvsi_jbusinessdirectory_attributes a 
		          
  left join qgvsi_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join qgvsi_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join qgvsi_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=83
		          
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/companies.php:354
12	JBusinessDirectoryModelCompanies->getCompanyAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:88
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 11.641 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_contact`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companycontact.php:21
15	TableCompanyContact->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:400
12	JBusinessDirectoryModelCompanies->getCompanyContactsWithEmail()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:89
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 11.659 MB Rows returned: 1

Duplicate queries: #39

select * 
  from qgvsi_jbusinessdirectory_company_contact 
  where companyId=83 
  order by contact_department

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_contact	NULL	ref	R_13	R_13	4	const	1	100.00	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companycontact.php:41
13	TableCompanyContact->getAllCompanyContacts()	JROOT/components/com_jbusinessdirectory/models/companies.php:401
12	JBusinessDirectoryModelCompanies->getCompanyContactsWithEmail()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:89
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 11.667 MB Rows returned: 1

Duplicate queries: #38

select * 
  from qgvsi_jbusinessdirectory_company_contact 
  where companyId=83 
  order by contact_department

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_contact	NULL	ref	R_13	R_13	4	const	1	100.00	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companycontact.php:41
13	TableCompanyContact->getAllCompanyContacts()	JROOT/components/com_jbusinessdirectory/models/companies.php:368
12	JBusinessDirectoryModelCompanies->getCompanyContacts()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:90
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 11.677 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_testimonials`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:21
15	TableCompanyTestimonials->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:381
12	JBusinessDirectoryModelCompanies->getCompanyTestimonials()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:91
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select * 
  from qgvsi_jbusinessdirectory_company_testimonials 
  where companyId=83 
  order by testimonial_title

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_testimonials	NULL	ref	idx_companyId	idx_companyId	4	const	1	100.00	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:33
13	TableCompanyTestimonials->getAllCompanyTestimonials()	JROOT/components/com_jbusinessdirectory/models/companies.php:382
12	JBusinessDirectoryModelCompanies->getCompanyTestimonials()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:91
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 11.700 MB Rows returned: 1

select DISTINCT contact_department 
  from qgvsi_jbusinessdirectory_company_contact 
  where companyId=83 
  order by contact_department

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_contact	NULL	ref	R_13	R_13	4	const	1	100.00	Using temporary; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companycontact.php:48
13	TableCompanyContact->getAllCompanyContactsDepartment()	JROOT/components/com_jbusinessdirectory/models/companies.php:414
12	JBusinessDirectoryModelCompanies->getCompanyDepartments()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:92
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 11.705 MB Rows returned: 12

Duplicate queries: #44

SELECT *
				
  FROM qgvsi_jbusinessdirectory_company_pictures
				
  WHERE picture_enable =1 
  and companyId =83
				
  ORDER BY id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_pictures	NULL	ref	idx_companyId	idx_companyId	4	const	12	10.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jbusinessdirectory/models/companies.php:307
12	JBusinessDirectoryModelCompanies->getCompanyImages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:93
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 11.719 MB Rows returned: 12

Duplicate queries: #43

SELECT *
				
  FROM qgvsi_jbusinessdirectory_company_pictures
				
  WHERE picture_enable =1 
  and companyId =83
				
  ORDER BY id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_pictures	NULL	ref	idx_companyId	idx_companyId	4	const	12	10.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jbusinessdirectory/models/companies.php:308
12	JBusinessDirectoryModelCompanies->getCompanyImages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:93
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.45 ms Query memory: 0.025 MB Memory before query: 11.731 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_videos`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:20
15	JTableCompanyVideos->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:314
12	JBusinessDirectoryModelCompanies->getCompanyVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:94
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 11.744 MB Rows returned: 1

select * 
  from qgvsi_jbusinessdirectory_company_videos 
  where companyId=83

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_videos	NULL	ref	idx_companyId	idx_companyId	5	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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:40
13	JTableCompanyVideos->getCompanyVideos()	JROOT/components/com_jbusinessdirectory/models/companies.php:315
12	JBusinessDirectoryModelCompanies->getCompanyVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:94
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.04 ms After last query: 0.30 ms Query memory: 0.034 MB Memory before query: 11.760 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:23
15	JTableOffer->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:418
12	JBusinessDirectoryModelCompanies->getCompanyOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:96
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.99 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 11.826 MB Rows returned: 0

select co.id, co.price , co.specialPrice, co.subject, co.short_description, co.address, co.city, co.county, co.province, co.area, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url,
					op.picture_info,op.picture_path, co.currencyId, co.price_text,
					GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,
					GROUP_CONCAT(DISTINCT cg.id) as categoryIds
					
  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
					
  where co.companyId=83 
  and co.state=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_end_date>=DATE(now()) or co.publish_end_date='0000-00-00'or co.publish_end_date is null) 
					
  and (co.approved = 0 or co.approved = 1)   
  and co.type = 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) )
					
  group by co.id, op.id
					
  order by co.id desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	co	NULL	ref	idx_company,idx_search,idx_approved,idx_type	idx_company	4	const	1	33.33	Using where; Using temporary; Using filesort
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
2	SUBQUERY	co1	NULL	index	PRIMARY	PRIMARY	4	NULL	3	100.00	Using index
2	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:210
13	JTableOffer->getCompanyOffers()	JROOT/components/com_jbusinessdirectory/models/companies.php:419
12	JBusinessDirectoryModelCompanies->getCompanyOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:96
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 0.24 ms Query memory: 0.034 MB Memory before query: 12.204 MB Rows returned: 49

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_events`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:20
15	JTableEvent->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:457
12	JBusinessDirectoryModelCompanies->getCompanyEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:97
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 12.264 MB Rows returned: 0

select co.*, op.picture_path, et.name as eventType, cg.markerLocation as categoryMarker
					
  from qgvsi_jbusinessdirectory_company_events co
					
  left join  qgvsi_jbusinessdirectory_company_event_pictures op 
  on co.id=op.eventId
					
  and (op.id in (
							select  min(op1.id) as min 
  from qgvsi_jbusinessdirectory_company_events co1
							
  left join  qgvsi_jbusinessdirectory_company_event_pictures op1 
  on co1.id=op1.eventId
							
  where op1.picture_enable=1 
  and company_id=83
							
  group by co1.id))
					
  left join  qgvsi_jbusinessdirectory_company_event_types et 
  on co.type=et.id
					
  left join qgvsi_jbusinessdirectory_company_event_category cc 
  on co.id=cc.eventId
					
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  where co.state=1 
  and co.end_date>=DATE(now()) 
  and company_id=83 
  and (co.approved = 0 or co.approved = 1) 
					
  group by co.id	
					
  order by co.start_date

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	cc	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	cg	NULL	const	PRIMARY,idx_state	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Impossible ON condition
1	PRIMARY	co	NULL	ref	PRIMARY,idx_company	idx_company	5	const	1	14.29	Using where; Using temporary; Using filesort
1	PRIMARY	op	NULL	ref	idx_event	idx_event	4	magarea_db.co.id	3	100.00	Using where
1	PRIMARY	et	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.co.type	1	100.00	NULL
2	DEPENDENT SUBQUERY	co1	NULL	ref	PRIMARY,idx_company	idx_company	5	const	1	100.00	Using temporary
2	DEPENDENT SUBQUERY	op1	NULL	ref	idx_event	idx_event	4	magarea_db.co1.id	3	10.00	Using where

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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/event.php:559
13	JTableEvent->getCompanyEvents()	JROOT/components/com_jbusinessdirectory/models/companies.php:458
12	JBusinessDirectoryModelCompanies->getCompanyEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:97
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 12.277 MB Rows returned: 0

select DISTINCT cp.* 
  from qgvsi_jbusinessdirectory_companies cp 
                    
  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 
  and 0) or (p.price=0 
  and p.status=1 
  and 0)
                    
  left join qgvsi_jbusinessdirectory_company_related rc 
  on rc.related_company_id=cp.id  
                    
  where rc.company_id=83   
  and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)   
  and cp.state = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1311
13	JTableCompany->getRelatedCompanies()	JROOT/components/com_jbusinessdirectory/models/companies.php:1015
12	JBusinessDirectoryModelCompanies->getRelatedCompanies()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:98
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 12.279 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_event_associated_items`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:21
15	JTableEventAssociatedCompanies->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1043
12	JBusinessDirectoryModelCompanies->getAssociatedEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:99
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select DISTINCT ce.* 
                    
  from qgvsi_jbusinessdirectory_company_events ce
                    
  left join qgvsi_jbusinessdirectory_companies cp 
  on cp.id = ce.company_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 
  and 0) or (p.price=0 
  and p.status=1 
  and 0)
                    
  WHERE ce.id IN (
                    select eac.event_id
                    
  from qgvsi_jbusinessdirectory_company_events co
                    
  left join qgvsi_jbusinessdirectory_company_event_associated_items eac  
                    
  on eac.event_id=co.id  
  where eac.company_id=83
                    ) 
  and ce.state = 1 
  and (ce.approved = 0 or ce.approved = 1)    
  and ce.end_date>= DATE(NOW())

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235
13	JTableEventAssociatedCompanies->getAssociatedEventsDetails()	JROOT/components/com_jbusinessdirectory/models/companies.php:1045
12	JBusinessDirectoryModelCompanies->getAssociatedEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:99
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 12.302 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_memberships`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/memberships.php:22
15	TableMemberships->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1026
12	JBusinessDirectoryModelCompanies->getCompanyMemberships()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:100
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select c.* 
  from qgvsi_jbusinessdirectory_memberships c
				  
  left join qgvsi_jbusinessdirectory_company_membership cc 
  on c.id=cc.membership_id
				  
  where company_id=83 
  and c.status = 1 
				 
  order by c.name

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/memberships.php:111
13	TableMemberships->getCompanyMemberships()	JROOT/components/com_jbusinessdirectory/models/companies.php:1027
12	JBusinessDirectoryModelCompanies->getCompanyMemberships()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:100
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 12.328 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/review.php:21
15	JTableReview->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:217
12	JBusinessDirectoryModelCompanies->getReviews()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:103
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select cr.*, scores, criteria_ids, answer_ids, question_ids 
  from qgvsi_jbusinessdirectory_company_reviews cr
					
  left join (
						select GROUP_CONCAT(ruc.score) as scores, GROUP_CONCAT(rc.id) as criteria_ids, r.id as cr_id
						
  from qgvsi_jbusinessdirectory_company_reviews r
						
  left join qgvsi_jbusinessdirectory_company_reviews_user_criteria ruc 
  on r.id=ruc.review_id
						
  left join qgvsi_jbusinessdirectory_company_reviews_criteria rc 
  on rc.id=ruc.criteria_id 
  and rc.published =1 
						
  group by r.id
					) rcs 
  on cr.id = rcs.cr_id
					
  left join (
						select GROUP_CONCAT(rqa.id) as answer_ids, GROUP_CONCAT(rq.id) as question_ids, r.id as cr_id
						
  from qgvsi_jbusinessdirectory_company_reviews r
						
  left join qgvsi_jbusinessdirectory_company_reviews_question_answer rqa 
  on r.id=rqa.review_id
						
  left join qgvsi_jbusinessdirectory_company_reviews_question rq 
  on rq.id=rqa.question_id
						
  group by r.id
					) rqs 
  on cr.id = rqs.cr_id
					
  where cr.itemId=83 
  and cr.review_type =1 
  and state=1 
  and (cr.approved = 2)  
					
  order by creationDate desc;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/review.php:74
13	JTableReview->getReviews()	JROOT/components/com_jbusinessdirectory/models/companies.php:218
12	JBusinessDirectoryModelCompanies->getReviews()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:103
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 12.367 MB Rows returned: 4

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_criteria`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:20
15	JTableReviewCriteria->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:251
12	JBusinessDirectoryModelCompanies->getReviewCriterias()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:104
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select * 
  from qgvsi_jbusinessdirectory_company_reviews_criteria
					
  where published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_reviews_criteria	NULL	ref	idx_published	idx_published	2	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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:34
13	JTableReviewCriteria->getCriterias()	JROOT/components/com_jbusinessdirectory/models/companies.php:254
12	JBusinessDirectoryModelCompanies->getReviewCriterias()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:104
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 12.391 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_question`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:20
15	JTableReviewQuestion->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:272
12	JBusinessDirectoryModelCompanies->getReviewQuestions()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:105
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.407 MB Rows returned: 0

select * 
                  
  from qgvsi_jbusinessdirectory_company_reviews_question 
                  
  where 1 
  and published = 1
                  
  order by ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:35
13	JTableReviewQuestion->getQuestions()	JROOT/components/com_jbusinessdirectory/models/companies.php:273
12	JBusinessDirectoryModelCompanies->getReviewQuestions()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:105
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 12.417 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_question_answer`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:20
15	JTableReviewQuestionAnswer->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:289
12	JBusinessDirectoryModelCompanies->getReviewQuestionAnswers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:106
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select rqa.*
                
  from qgvsi_jbusinessdirectory_company_reviews_question_answer rqa
                
  left join qgvsi_jbusinessdirectory_company_reviews cr 
  on cr.id = rqa.review_id
                
  where cr.itemId =83 
  and review_type = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:36
13	JTableReviewQuestionAnswer->getAnswersByCompany()	JROOT/components/com_jbusinessdirectory/models/companies.php:290
12	JBusinessDirectoryModelCompanies->getReviewQuestionAnswers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:106
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.446 MB Rows returned: 0

select * 
  from qgvsi_jbusinessdirectory_company_claim 
  where companyId = 83 
  and status <> -1 
  order by id desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qgvsi_jbusinessdirectory_company_claim	NULL	ref	idx_companyId,idx_status	idx_companyId	5	const	1	85.71	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:917
13	JTableCompany->getClaimDetails()	JROOT/components/com_jbusinessdirectory/models/companies.php:888
12	JBusinessDirectoryModelCompanies->getClaimDetails()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:109
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.16 ms Query memory: 0.031 MB Memory before query: 12.458 MB Rows returned: 4

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_ratings`

Explain

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

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/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/rating.php:20
15	JTableRating->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:194
12	JBusinessDirectoryModelCompanies->getUserRating()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:112
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.477 MB Rows returned: 0

select * 
  from qgvsi_jbusinessdirectory_company_ratings 
  where id=0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/rating.php:31
13	JTableRating->getRating()	JROOT/components/com_jbusinessdirectory/models/companies.php:195
12	JBusinessDirectoryModelCompanies->getUserRating()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:112
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 12.484 MB Rows returned: 1

select count(*) as nrRatings 
  from qgvsi_jbusinessdirectory_company_ratings 
  where companyId=83

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/rating.php:62
13	JTableRating->getNumberOfRatings()	JROOT/components/com_jbusinessdirectory/models/companies.php:636
12	JBusinessDirectoryModelCompanies->getRatingsCount()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:113
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 12.498 MB

update  qgvsi_jbusinessdirectory_companies 
  set viewCount = viewCount + 1 
  where id=83

Explain

EXPLAIN not possible on query: update qgvsi_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=83

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:861
14	JTableCompany->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/companies.php:930
13	JBusinessDirectoryModelCompanies->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/companies.php:948
12	JBusinessDirectoryModelCompanies->getViewCount()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:115
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 12.511 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_statistics`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/statistics.php:22
16	JTableStatistics->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:212
14	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:940
13	JBusinessDirectoryModelCompanies->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/companies.php:948
12	JBusinessDirectoryModelCompanies->getViewCount()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:115
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.008 MB Memory before query: 12.529 MB

INSERT INTO `qgvsi_jbusinessdirectory_statistics`
(`id`,`item_id`,`item_type`,`date`,`type`) 
  VALUES 
('0','83','1','2026-08-17 11:16:14','0')

Explain

EXPLAIN not possible on query: INSERT INTO `qgvsi_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) VALUES ('0','83','1','2026-08-17 11:16:14','0')

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1421
16	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:805
15	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Table/Table.php:917
14	Joomla\CMS\Table\Table->save()	JROOT/components/com_jbusinessdirectory/models/companies.php:941
13	JBusinessDirectoryModelCompanies->increaseViewCount()	JROOT/components/com_jbusinessdirectory/models/companies.php:948
12	JBusinessDirectoryModelCompanies->getViewCount()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:115
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 12.527 MB Rows returned: 1

Duplicate queries: #21

select id, package_id 
  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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:204
13	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:485
12	JBusinessDirectoryModelCompanies->getPackage()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:116
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 12.536 MB Rows returned: 0

Duplicate queries: #22

select * , inv.id as invoice_id,  max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS 
				
  from qgvsi_jbusinessdirectory_packages p
				
  left join qgvsi_jbusinessdirectory_orders inv 
  on p.id=inv.package_id 
  and inv.company_id=83 
				
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
				
  where p.status=1  
  and (
									  (
										(inv.state= 1 
  and (
											(
												(now() > (inv.start_date) 
  and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1 ))
									 			or
												(now() > (inv.start_trial_date) 
  and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY)))
									 ))
									)
									or (
										((p.expiration_type=1 
  and p.price=0) or (p.id = 0 
  and p.price=0)))
								) 
				
  group by p.id
				
  order by p.price desc, ordering desc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	system	PRIMARY,idx_status,idx_price	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	inv	NULL	ref	idx_company,idx_package	idx_company	4	const	1	25.00	Using where
1	SIMPLE	pf	NULL	ref	idx_package_id	idx_package_id	5	const	9	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/administrator/components/com_jbusinessdirectory/tables/package.php:233
13	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:485
12	JBusinessDirectoryModelCompanies->getPackage()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:116
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.65 ms Query memory: 0.028 MB Memory before query: 12.958 MB Rows returned: 1

Duplicate queries: #74

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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
25	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php:30
15	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php:36
13	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:145
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #73

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
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/components/com_jbusinessdirectory/router.php:97
26	JBusinessDirectoryRouter->getCompaniesSegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246
23	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
22	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php:30
15	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php:36
13	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:145
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.04 ms After last query: 3.76 ms Query memory: 0.028 MB Memory before query: 13.806 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 11:16:14') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-17 11:16:14') 
  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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php:556
15	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default_style_3.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php:36
13	include JROOT/components/com_jbusinessdirectory/views/companies/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:145
10	JBusinessDirectoryViewCompanies->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT * 
  FROM qgvsi_jbusinessdirectory_default_attribute

2 × select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName,
     GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,  
     cr.country_name,
     ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
     
  from qgvsi_jbusinessdirectory_companies bc 
     
  left join qgvsi_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,bc.typeId)
     
  left join qgvsi_jbusinessdirectory_company_category cc 
  on bc.id=cc.companyId 
     
  left join qgvsi_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
     
  left join qgvsi_jbusinessdirectory_categories ccm 
  on ccm.id=bc.mainSubcategory 
  and ccm.published=1
     
  left join qgvsi_jbusinessdirectory_countries as cr 
  on cr.id = bc.countryId

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

2 × SELECT `alias` 
  FROM `qgvsi_jbusinessdirectory_companies`

2 × select * 
  from qgvsi_jbusinessdirectory_company_contact

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

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

2 × SELECT *
     
  FROM qgvsi_jbusinessdirectory_company_pictures

2 × select id, package_id 
  from qgvsi_jbusinessdirectory_companies

2 × select * , inv.id as invoice_id,  max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS 
     
  from qgvsi_jbusinessdirectory_packages p
     
  left join qgvsi_jbusinessdirectory_orders inv 
  on p.id=inv.package_id 
  and inv.company_id=83 
     
  left join qgvsi_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id

1 × select co.id, co.price , co.specialPrice, co.subject, co.short_description, co.address, co.city, co.county, co.province, co.area, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url,
      op.picture_info,op.picture_path, co.currencyId, co.price_text,
      GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,
      GROUP_CONCAT(DISTINCT cg.id) as categoryIds
      
  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 co.*, op.picture_path, et.name as eventType, cg.markerLocation as categoryMarker
      
  from qgvsi_jbusinessdirectory_company_events co
      
  left join  qgvsi_jbusinessdirectory_company_event_pictures op 
  on co.id=op.eventId
      
  and (op.id in (
        select  min(op1.id) as min 
  from qgvsi_jbusinessdirectory_company_events co1
        
  left join  qgvsi_jbusinessdirectory_company_event_pictures op1 
  on co1.id=op1.eventId

1 × select DISTINCT cp.* 
  from qgvsi_jbusinessdirectory_companies cp 
                     
  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 
  and 0) or (p.price=0 
  and p.status=1 
  and 0)
                     
  left join qgvsi_jbusinessdirectory_company_related rc 
  on rc.related_company_id=cp.id

1 × select DISTINCT ce.*                      
  from qgvsi_jbusinessdirectory_company_events ce                     
  left join qgvsi_jbusinessdirectory_companies cp 
  on cp.id = ce.company_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 
  and 0) or (p.price=0 
  and p.status=1 
  and 0)

1 × select c.* 
  from qgvsi_jbusinessdirectory_memberships c       
  left join qgvsi_jbusinessdirectory_company_membership cc 
  on c.id=cc.membership_id

1 × SELECT `data` 
  FROM `qgvsi_session`

1 × select cr.*, scores, criteria_ids, answer_ids, question_ids 
  from qgvsi_jbusinessdirectory_company_reviews cr
      
  left join (
       select GROUP_CONCAT(ruc.score) as scores, GROUP_CONCAT(rc.id) as criteria_ids, r.id as cr_id
       
  from qgvsi_jbusinessdirectory_company_reviews r
       
  left join qgvsi_jbusinessdirectory_company_reviews_user_criteria ruc 
  on r.id=ruc.review_id
       
  left join qgvsi_jbusinessdirectory_company_reviews_criteria rc 
  on rc.id=ruc.criteria_id 
  and rc.published =1 
       
  group by r.id
      ) rcs 
  on cr.id = rcs.cr_id
      
  left join (
       select GROUP_CONCAT(rqa.id) as answer_ids, GROUP_CONCAT(rq.id) as question_ids, r.id as cr_id
       
  from qgvsi_jbusinessdirectory_company_reviews r
       
  left join qgvsi_jbusinessdirectory_company_reviews_question_answer rqa 
  on r.id=rqa.review_id
       
  left join qgvsi_jbusinessdirectory_company_reviews_question rq 
  on rq.id=rqa.question_id
       
  group by r.id
      ) rqs 
  on cr.id = rqs.cr_id

1 × select * 
  from qgvsi_jbusinessdirectory_company_reviews_criteria

1 × select *                    
  from qgvsi_jbusinessdirectory_company_reviews_question

1 × select rqa.*                 
  from qgvsi_jbusinessdirectory_company_reviews_question_answer rqa                 
  left join qgvsi_jbusinessdirectory_company_reviews cr 
  on cr.id = rqa.review_id

1 × select * 
  from qgvsi_jbusinessdirectory_company_claim

1 × select * 
  from qgvsi_jbusinessdirectory_company_ratings

1 × select count(*) as nrRatings 
  from qgvsi_jbusinessdirectory_company_ratings

1 × select * 
  from qgvsi_jbusinessdirectory_company_videos

1 × select a.*, 
       GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.ordering asc SEPARATOR ',')  options,
       GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
       GROUP_CONCAT(ao.icon 
  ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
       at.code as attributeTypeCode,
       ca.value as attributeValue
       
  from qgvsi_jbusinessdirectory_attributes a 
             
  left join qgvsi_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
             
  left join qgvsi_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
             
  left join qgvsi_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=83

1 × select DISTINCT contact_department 
  from qgvsi_jbusinessdirectory_company_contact

1 × select * 
  from qgvsi_jbusinessdirectory_company_testimonials

1 × SELECT `session_id` 
  FROM `qgvsi_session`

1 × select * 
  from  qgvsi_jbusinessdirectory_company_attachments

1 × select a.*,b.country_name as country 
  from qgvsi_jbusinessdirectory_company_locations a
       
  left join qgvsi_jbusinessdirectory_countries b 
  on a.countryId = b.id

1 × select * 
  from qgvsi_jbusinessdirectory_categories c

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 * 
  FROM qgvsi_languages
```

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'6535633338636462386532636433343337383761646532626331636263386336', 1, 1786965374, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_offers

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_statistics

1 × update  qgvsi_jbusinessdirectory_companies 
  set viewCount = viewCount + 1

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_ratings

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_question_answer

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_question

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews_criteria

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_reviews

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_memberships

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_event_associated_items

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_events

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_videos

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

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_testimonials

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_contact

1 × 
  SET SESSION group_concat_max_len =100000

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_attributes

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_locations

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_categories

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_company_providers

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_packages

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_companies

1 × SHOW FULL COLUMNS 
  FROM `qgvsi_jbusinessdirectory_default_attributes

1 × INSERT INTO `qgvsi_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) 
  VALUES  ('0','83','1','2026-08-17 11:16:14','0'

Map Location

Opening hours

Gallery

Videos

Contact business

Report abuse

Come Explore

Local Towns

In the Community

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

75 Queries Logged 37.55 ms

16 duplicate found!

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Sound Software

Sound Software

Map Location

Opening hours

Gallery

Videos

Contact business

INFO

Report abuse

Come Explore

Local Towns

In the Community

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

75 Queries Logged 37.55 ms

16 duplicate found!

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: