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

Time

Memory

75 Queries Logged 41.32 ms

1. Query Time: 0.58 ms Query memory: 0.023 MB Memory before query: 4.449 MB Rows returned: 0

   SELECT `data`
   
     FROM `qgvsi_session`
   
     WHERE `session_id` = X'6437366633393230376239623439356561323231663663313762643038616365'

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

2. Query Time: 0.18 ms After last query: 0.43 ms Query memory: 0.020 MB Memory before query: 4.675 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `qgvsi_session`
   
     WHERE `session_id` = X'6437366633393230376239623439356561323231663663313762643038616365' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

3. Query Time: 0.27 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 4.680 MB

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

   Explain

   EXPLAIN not possible on query: INSERT INTO `qgvsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6437366633393230376239623439356561323231663663313762643038616365', 1, 1787128739, 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.]

   ---

4. Query Time: 0.45 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 4.928 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.]

   ---

5. Query Time: 0.24 ms After last query: 0.51 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.]

   ---

6. Query Time: 0.34 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.]

   ---

7. Query Time: 0.54 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.]

   ---

8. Query Time: 0.79 ms After last query: 4.76 ms Query memory: 0.048 MB Memory before query: 7.125 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.]

   ---

9. Query Time: 0.81 ms After last query: 2.67 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.]

   ---

10. Query Time: 0.26 ms After last query: 0.04 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.]

    ---

11. Query Time: 0.27 ms After last query: 0.06 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 = 'r-w-haviland-studio-gallery' 
      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.]

    ---

12. Query Time: 0.30 ms After last query: 0.02 ms Query memory: 0.040 MB Memory before query: 8.056 MB Rows returned: 1

    SELECT * 
      FROM `qgvsi_jbusinessdirectory_companies` c 
      where c.alias = 'r-w-haviland-studio-gallery' 
      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.]

    ---

13. Query Time: 0.26 ms After last query: 0.34 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.]

    ---

14. Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 8.074 MB

    UPDATE `qgvsi_extensions`
    
      SET `params` = '{\"mediaversion\":\"32655dbda09dd26160bc9bac455d2829\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `qgvsi_extensions` SET `params` = '{\"mediaversion\":\"32655dbda09dd26160bc9bac455d2829\"}' 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.]

    ---

15. Query Time: 0.37 ms After last query: 0.36 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.]

    ---

16. Query Time: 0.44 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.]

    ---

17. Query Time: 1.52 ms After last query: 6.46 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.]

    ---

18. Query Time: 0.40 ms After last query: 0.20 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.]

    ---

19. Query Time: 2.22 ms After last query: 0.28 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.]

    ---

20. Query Time: 1.35 ms After last query: 0.36 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.]

    ---

21. Query Time: 0.20 ms After last query: 0.06 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= 67

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

    ---

22. Query Time: 0.82 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=67 
    				
      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.]

    ---

23. Query Time: 0.87 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=67 
      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	1	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.]

    ---

24. Query Time: 1.19 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 11.072 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.]

    ---

25. Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 11.093 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 = 67 
      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.]

    ---

26. Query Time: 0.55 ms After last query: 0.05 ms Query memory: 0.041 MB Memory before query: 11.111 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=67 
      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	1	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.]

    ---

27. Query Time: 0.35 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 11.111 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 = 67 
      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.]

    ---

28. Query Time: 1.43 ms After last query: 0.45 ms Query memory: 0.028 MB Memory before query: 11.515 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.]

    ---

29. Query Time: 0.19 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 11.545 MB Rows returned: 1

    select * 
      from qgvsi_jbusinessdirectory_categories c
    				 
      where c.id=90

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

    ---

30. Query Time: 1.04 ms After last query: 0.19 ms Query memory: 0.028 MB Memory before query: 11.558 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.]

    ---

31. Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 11.583 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=67

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

    ---

32. Query Time: 0.56 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 11.590 MB Rows returned: 0

    select * 
      from  qgvsi_jbusinessdirectory_company_attachments 
      where type=1  
      and status=1  
      and object_id=67 
      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.]

    ---

33. Query Time: 0.19 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 11.605 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.]

    ---

34. Query Time: 0.94 ms After last query: 0.30 ms Query memory: 0.026 MB Memory before query: 11.605 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.]

    ---

35. Query Time: 0.06 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 11.620 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.]

    ---

36. Query Time: 0.77 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 11.629 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=67
    		          
    		          
      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.]

    ---

37. Query Time: 0.80 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 11.638 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.]

    ---

38. Query Time: 0.24 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 11.656 MB Rows returned: 1
    Duplicate queries: #39

    select * 
      from qgvsi_jbusinessdirectory_company_contact 
      where companyId=67 
      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.]

    ---

39. Query Time: 0.10 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 11.663 MB Rows returned: 1
    Duplicate queries: #38

    select * 
      from qgvsi_jbusinessdirectory_company_contact 
      where companyId=67 
      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.]

    ---

40. Query Time: 0.71 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 11.674 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.]

    ---

41. Query Time: 0.20 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 11.689 MB Rows returned: 0

    select * 
      from qgvsi_jbusinessdirectory_company_testimonials 
      where companyId=67 
      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.]

    ---

42. Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 11.696 MB Rows returned: 1

    select DISTINCT contact_department 
      from qgvsi_jbusinessdirectory_company_contact 
      where companyId=67 
      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.]

    ---

43. Query Time: 0.17 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 11.702 MB Rows returned: 0
    Duplicate queries: #44

    SELECT *
    				
      FROM qgvsi_jbusinessdirectory_company_pictures
    				
      WHERE picture_enable =1 
      and companyId =67
    				
      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	1	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.]

    ---

44. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 11.709 MB Rows returned: 0
    Duplicate queries: #43

    SELECT *
    				
      FROM qgvsi_jbusinessdirectory_company_pictures
    				
      WHERE picture_enable =1 
      and companyId =67
    				
      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	1	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.]

    ---

45. Query Time: 0.65 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 11.720 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.]

    ---

46. Query Time: 0.82 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 11.733 MB Rows returned: 1

    select * 
      from qgvsi_jbusinessdirectory_company_videos 
      where companyId=67

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

    ---

47. Query Time: 1.41 ms After last query: 0.24 ms Query memory: 0.034 MB Memory before query: 11.750 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.]

    ---

48. Query Time: 0.87 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 11.815 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=67 
      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.]

    ---

49. Query Time: 1.06 ms After last query: 0.22 ms Query memory: 0.034 MB Memory before query: 12.194 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.]

    ---

50. Query Time: 0.77 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 12.253 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=67
    							
      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=67 
      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.]

    ---

51. Query Time: 0.40 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 12.267 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=67   
      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.]

    ---

52. Query Time: 0.66 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 12.269 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.]

    ---

53. Query Time: 0.35 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 12.282 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=67
                        ) 
      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.]

    ---

54. Query Time: 0.67 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 12.292 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.]

    ---

55. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 12.308 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=67 
      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.]

    ---

56. Query Time: 0.70 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 12.317 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.]

    ---

57. Query Time: 0.58 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.347 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=67 
      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.]

    ---

58. Query Time: 0.61 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 12.357 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.]

    ---

59. Query Time: 0.15 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 12.370 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.]

    ---

60. Query Time: 0.62 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 12.380 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.]

    ---

61. Query Time: 0.10 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 12.397 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.]

    ---

62. Query Time: 0.58 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 12.406 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.]

    ---

63. Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.422 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 =67 
      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.]

    ---

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

    select * 
      from qgvsi_jbusinessdirectory_company_claim 
      where companyId = 67 
      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.]

    ---

65. Query Time: 0.65 ms After last query: 0.34 ms Query memory: 0.031 MB Memory before query: 12.448 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.]

    ---

66. Query Time: 0.16 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.467 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.]

    ---

67. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 12.474 MB Rows returned: 1

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

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

    ---

68. Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 12.488 MB

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

    Explain

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

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

    ---

69. Query Time: 0.69 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 12.500 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.]

    ---

70. Query Time: 1.81 ms After last query: 0.09 ms Query memory: 0.008 MB Memory before query: 12.518 MB

    INSERT INTO `qgvsi_jbusinessdirectory_statistics`
    (`id`,`item_id`,`item_type`,`date`,`type`) 
      VALUES 
    ('0','67','1','2026-08-19 08:38:59','0')

    Explain

    EXPLAIN not possible on query: INSERT INTO `qgvsi_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) VALUES ('0','67','1','2026-08-19 08:38:59','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.]

    ---

71. Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 12.516 MB Rows returned: 1
    Duplicate queries: #21

    select id, package_id 
      from qgvsi_jbusinessdirectory_companies 
      where id= 67

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

    ---

72. Query Time: 0.48 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 12.525 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=67 
    				
      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.]

    ---

73. Query Time: 0.18 ms After last query: 0.66 ms Query memory: 0.028 MB Memory before query: 12.947 MB Rows returned: 1
    Duplicate queries: #74

    SELECT `alias`
    
      FROM `qgvsi_jbusinessdirectory_companies`
    
      WHERE id = '67'

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

    ---

74. Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 12.959 MB Rows returned: 1
    Duplicate queries: #73

    SELECT `alias`
    
      FROM `qgvsi_jbusinessdirectory_companies`
    
      WHERE id = '67'

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

    ---

75. Query Time: 0.89 ms After last query: 1.75 ms Query memory: 0.028 MB Memory before query: 13.000 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-19 08:38:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-19 08:38:59') 
      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.]

    ---